Check all your fields. In the program I made to maintain the user db, I =
had overlooked the "extension" field in the MA and SA tables. I am very =
certain that I didn't need to use it before, but I must have checked a =
box an Radius Admin to require it. So, as a quick fix I did a mass =
update on the columns, but I had to modify my code to make sure that it =
would enter a "0" in the extension field. [This problem has happened in =
other fields as well, so I make many updates to my code :)]
If you start radius with -x15 you will get a clue as to which field is =
missing. Actually, -x15 might be excessive, try -x4 for the SQL =
statements and use those for a test.
da
-----Original Message-----
From: Eric Cowperthwaite [SMTP:eric@valleynetworking.com]
Sent: Monday, April 13, 1998 7:29 PM
To: Radius NT List
Subject: adding users to odbc database
I am using RadiusNT 2.2, running a MS Access database. Everything would
appear to be correctly configured, since, after I built the database the =
first
time and brought radius up it authenticated users no problem. The hitch =
I have
run into is that I cannot add any new users. I add them to the database =
and
they cannot be authenticated.=20
Anyone seen this before with a new install of RadiusNT? Any idea where =
the
problem might lie?
Thanks in advance,
Eric W. Cowperthwaite
Intellinet, Inc.
Sys Engineer
------ =_NextPart_000_01BD6785.32324AF0
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IigNAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQmAAQAhAAAAMEY3QkEyQjJGNkM0RDExMTlBODkwMDYwOTdEODgy
MTQADAcBBYADAA4AAADOBwQADgAJAAgACAACAAIBASCAAwAOAAAAzgcEAA4ACQAIAAgAAgACAQEE
kAYA+AEAAAEAAAARAAAAAwAAMAAAAAALAA8OAAAAAAIB/w8BAAAAUwAAAAAAAACBKx+kvqMQGZ1u
AN0BD1QCAAAAACdSYWRpdXNOVEBpZWEtc29mdHdhcmUuY29tJwBTTVRQAFJhZGl1c05UQGllYS1z
b2Z0d2FyZS5jb20AAB4AAjABAAAABQAAAFNNVFAAAAAAHgADMAEAAAAaAAAAUmFkaXVzTlRAaWVh
LXNvZnR3YXJlLmNvbQAAAAIB9g8BAAAABAAAAAAAAAADABUMAQAAAAIBCzABAAAAHwAAAFNNVFA6
UkFESVVTTlRASUVBLVNPRlRXQVJFLkNPTQAAHgABMAEAAAAcAAAAJ1JhZGl1c05UQGllYS1zb2Z0
d2FyZS5jb20nAB4AIDoBAAAAHAAAACdSYWRpdXNOVEBpZWEtc29mdHdhcmUuY29tJwALAEA6AQB8
AAMA/g8GAAAAAwAAOQAAAAADAP9fAAAAAAMA/V8BAAAAHgD2XwEAAAAaAAAAUmFkaXVzTlRAaWVh
LXNvZnR3YXJlLmNvbQAAAAIB918BAAAAUQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAFJhZGl1
c05UQGllYS1zb2Z0d2FyZS5jb20AU01UUABSYWRpdXNOVEBpZWEtc29mdHdhcmUuY29tAAAAAENx
AQ2ABAACAAAAAgACAAEEgAEAIgAAAFJFOiBhZGRpbmcgdXNlcnMgdG8gb2RiYyBkYXRhYmFzZQC6
CwEDkAYA3AkAACsAAAADADYAAAAAAAMABYAIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAB0EAAAHgAd
gAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAFAAAAOC4wMgAAAAADABiACCAGAAAAAADAAAAA
AAAARgAAAAABhQAAAAAAAAsAAIAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAAAAAACwAegAggBgAA
AAAAwAAAAAAAAEYAAAAADoUAAAAAAAADAAKACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMA
H4AIIAYAAAAAAMAAAAAAAABGAAAAABGFAAAAAAAAAwAggAggBgAAAAAAwAAAAAAAAEYAAAAAGIUA
AAAAAAAeACGACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAAAAEAAAAAAAAAHgAigAggBgAAAAAA
wAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4AI4AIIAYAAAAAAMAAAAAAAABGAAAAADiFAAAB
AAAAAQAAAAAAAAACAQkQAQAAAOMEAADfBAAADwcAAExaRnVjrpYoAwAKAHJjcGcxMjUWMgD4C2Bu
DhAwMzOdAfcgAqQD4wIAY2gKwOBzZXQwIAcTAoMAUKEQdnBycTIRdn0KgNkIyCA7CW8OMDUCgAqB
bHVjAFALA2MSEgvEIGRDaAWQayAHQAMgeQkIYSBmCJBsZHMuqCAgSQOgdBdgIBLA0m8JwGFtGMAg
AMABAH0Y8G8Z0QuAAZALgBjzdWMRMAXAZGIsGbERAGSYIG92BJAJAG9rCYDhGPMiZXh0CfAAkAIg
SiIYNCAaxU1BF6Bu7RwAUx6wAZFsB5AYohegYxmgHDF5IGMEkBqlYYMFQBnAZGlkbicFQH5uCeAc
sRpAGzEeIAVAYksBEAWwZRugYnUhIm1/GzAFQBEAHDAgYBdiHKFhuSKwb3gewQfwGfBpGzA5EXBk
bRrCGkAJcHF1TmkJcCKBGKFTbxugYf8EICTAJnEXgRhAJQAhQySx4wDABBF1cGQhEBkgAiDzGPMI
4XVtAIAjJhviGjL3BHAGkCBQbSBRBHEaJByQvCBzCHAaESECIpF3CGCfHgEJ8B1ABcAkwCIwHbCP
GsUdJxg0GKFbVGgEAD8ZMh9hGaARAAQgEQBwcHcJ8ByhGsFvGQEYJidSd/UYYGwboHMaQBnCLKED
gR8gUCkkBCAaMivlOild5wqiCoQKgElmF+IswAGQHwAgJkAlZAPwGQAgLXjcMTU2wwPwF8FnEUAk
se5jCkEnUhoxdzBwEPAdxi8EICXgBBALgGcYoUFjdHR1F7F5G6A4MyXgZ35oIqIvISBwOzEcMBug
dDsgQTgwNBgwBbEZAlNR/kw3Ah1AB4ACMCdxHuEiUv0ZAG8iYT5iJMA0wSbgNeqHKUA16gr0bGkz
NgFAPxaQAUAZQR1AO8ASBDE26zggRQJPBRBnC4AHQAXQ/T1hYTkQRQM15kQUQ+ELE8FEFmktMTQ0
AUBDYDgxODABQAzQSKNiIKpGA2E6DINiEWBFBRAyYxdAb3cxoAAgaHcDC3ApYVtTTVRQOpEGcWNA
dhexZXkh0LJ0LaByaztSBaBtNdbvSdAGYAIwSjdNAiApQDwhJkESwAMRMTMboDE5ADk4IDc6Mjkg
ZFBNTfdUb0o3JVVOOFQgTAQARGBOB3Vi/mpEQUo3GfAhYA8gGyM0470EcGJK8ClBAaAnYGVGr/9H
ukNkC7Y2VB/iGzBVEiVUEVLhMi4yG6BydW7/AwBVISTABeE7sD1SVicYoP5FICIZAFUSLaM15DGC
CsF/GjE9AQWhCXA7wDwQKfFu9RhAZyzhZDNxC4AgcCdB/wGAG1EZwCNAAxAFQBkCVjZvGPMYQBEg
U0V0B3Eew2K9A2B1PMI3dSkgIoJhI1C/F2ACMA3gKVE/81WBbhpA3zC1GKAwYBkgMHB0OlEbwv8c
MDXkW0EeIRoxMIEg9WYg/1tgMjBU0h7BIFAh0AfgVVP/GKAf0WqxGQEZoBoxYgse0f9jZRdgIFFq
RD0BZasYoDXq/kE0UAIgLLEJ4RjxMIEixL831CTAayILgDcRF8FvNrD9WmY/EXA0USFwXrA6EQSQ
n2KzNeQwtjykQ2BlPzXq+zBgAHBrBCAawRnwTKBg0vs16krDVxigSxs2RS4RF8B/C4ARQBuhYNBB
VQawBCBFXw8ge4EEkDXkE4EAfeAAAwAmAAAAAAADAC4AAAAAAAsAAgABAAAACwAjAAAAAAALACkA
AAAAAB4AcAABAAAAHgAAAGFkZGluZyB1c2VycyB0byBvZGJjIGRhdGFiYXNlAAAAAgFxAAEAAAAb
AAAAAb1nM+qT6sNIsNLnEdGDIgCgyZVGLwAcb1DwAB4AQhABAAAALQAAADw3MzE3RjYyQUY3NURE
MTExOUE2QzAwNjA5N0Q4ODIxNDA5RjA1OEBIQUw+AAAAAEAAOQA6/7hepme9AQMA8T8JBAAAHgAe
DAEAAAADAAAARVgAAB4AHwwBAAAAOQAAAC9PPUNPTVBVVEVSIFNIT1dDQVNFL09VPVNIT1dDQVNF
L0NOPVJFQ0lQSUVOVFMvQ049REFWRVJBAAAAAAMAGUAAAAAAAwD9P+QEAAADAIAQ/////wIB+T8B
AAAAVQAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAAAAAAAAAvTz1DT01QVVRFUiBTSE9XQ0FTRS9P
VT1TSE9XQ0FTRS9DTj1SRUNJUElFTlRTL0NOPURBVkVSQQAAAAAeAPg/AQAAAA4AAABEYXZpZCBS
LiBBb3VuAAAAAgH7PwEAAABVAAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAAAAAAAC9PPUNPTVBV
VEVSIFNIT1dDQVNFL09VPVNIT1dDQVNFL0NOPVJFQ0lQSUVOVFMvQ049REFWRVJBAAAAAB4A+j8B
AAAADgAAAERhdmlkIFIuIEFvdW4AAABAAAcw4Pvec6VnvQFAAAgwlGG7XqZnvQEeADUQAQAAAC0A
AAA8NzMxN0Y2MkFGNzVERDExMTlBNkMwMDYwOTdEODgyMTQwOTVCNEVASEFMPgAAAAADAAYQ08kj
pgMABxA0BAAAAwAQEAAAAAADABEQAAAAAB4ACBABAAAAZQAAAENIRUNLQUxMWU9VUkZJRUxEU0lO
VEhFUFJPR1JBTUlNQURFVE9NQUlOVEFJTlRIRVVTRVJEQixJSEFET1ZFUkxPT0tFRFRIRSJFWFRF
TlNJT04iRklFTERJTlRIRU1BQU5EU0EAAAAAAwANNP0/AAACARQ0AQAAABAAAABUlKHAKX8QG6WH
CAArKiUXHgA9AAEAAAAFAAAAUkU6IAAAAAD3aA==
------ =_NextPart_000_01BD6785.32324AF0--