Turn CHAP off and use PAP. Also make sure the machine you are dialing =
in from does not have the encrypted password required in the dial-up =
networking properties.
Mark A. Knight
PC Express, Inc.
(602) 516-9284
mknight@pce-inc.com
-----Original Message-----
From: Webmaster [SMTP:butlerlk@computron.net]
Sent: Wednesday, May 07, 1997 4:23 PM
To: RadiusNT@emerald.iea.com
Subject: Access Database File
The access database file that came with radius does not seem to be =
working
for me. I have tried everything I know with ODBC and Access. The data =
the
sql is calling for is simple enough, it should be able to find atleast =
the
test user.
radius -x15 -o -R31 is what I use to start radius (atleast most of my
tries)
I can tell It is reading the access file because the server ip is =
showing
up when radius starts.
But when I log in I get this:
radrecv: Request from host d0c90e1a code=3D1, id=3D196, length=3D139
User-Name =3D "test"
Challenge-Response =3D
"\001h\034^`6\260\300\271W\355\326\313\302\376\344\331"
NAS-Identifier =3D 208.201.14.26
NAS-Port =3D 29
User-Service =3D Framed-User
Framed-Protocol =3D PPP
Vendor-Specific =3D ""
Vendor-Specific =3D ""
Vendor-Specific =3D ""
Received unknown attribute 32
Acct-Session-Id =3D "00000049"
NAS-Port-Type =3D Async
rad_authenticate_ODBC()
Challenge-Response =3D
"\001h\034^`6\260\300\271W\355\326\313\302\376\344\331"
Decrypted Password: /??EZ$I+=3D>|?+>?=3D
Allocating Statement...
SQL Statement: Select DateAdd('d', ma.extension, maExpireDate),
DateAdd('d', ma.extension, maExpireDate), sa.AccountID, sa.AccountType,
sa.Password, sa.Login, sa.Shell From MasterAccounts ma, SubAccounts sa
Where (sa.Login=3D'test' or sa.Shell=3D'test') AND =
ma.CustomerID=3Dsa.CustomerID
and sa.Active<>0 and ma.Active<>0
Freeing SQL Statement...
LOG: User: test Not found
User: test Not found
Sending Reject of id 196 to d0c90e1a (netserver1)
If I copy the sql statement into access I get the information I need. =
------ =_NextPart_000_01BC5B10.62FD40E0
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IhMAAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYAyAEAAAEAAAAQAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAATwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAFJhZGl1c05UQGVtZXJh
bGQuaWVhLmNvbQBTTVRQAFJhZGl1c05UQGVtZXJhbGQuaWVhLmNvbQAAHgACMAEAAAAFAAAAU01U
UAAAAAAeAAMwAQAAABkAAABSYWRpdXNOVEBlbWVyYWxkLmllYS5jb20AAAAAAwAVDAEAAAADAP4P
BgAAAB4AATABAAAAGwAAACdSYWRpdXNOVEBlbWVyYWxkLmllYS5jb20nAAACAQswAQAAAB4AAABT
TVRQOlJBRElVU05UQEVNRVJBTEQuSUVBLkNPTQAAAAMAADkAAAAACwBAOgEAAAAeAPZfAQAAABkA
AABSYWRpdXNOVEBlbWVyYWxkLmllYS5jb20AAAAAAgH3XwEAAABPAAAAAAAAAIErH6S+oxAZnW4A
3QEPVAIAAAAAUmFkaXVzTlRAZW1lcmFsZC5pZWEuY29tAFNNVFAAUmFkaXVzTlRAZW1lcmFsZC5p
ZWEuY29tAAADAP1fAQAAAAMA/18AAAAAAgH2DwEAAAAEAAAAAAAAArFhAQSAAQAZAAAAUkU6IEFj
Y2VzcyBEYXRhYmFzZSBGaWxlABgIAQWAAwAOAAAAzQcFAAcAEQA7ABEAAwBAAQEggAMADgAAAM0H
BQAHABEAOgAQAAMAPgEBCYABACEAAAA2ODI3ODBEMzdCQzJEMDExOUYwQjQ0NDU1MzU0MDAwMADN
BgEDkAYAZA4AACIAAAALAAIAAQAAAAsAIwABAAAAAwAmAAAAAAALACkAAAAAAAMALgAAAAAAAgEx
AAEAAADLAAAAUENERkVCMDkAAQACAE0AAAAAAAAAOKG7EAXlEBqhuwgAKypWwgAATVNQU1QuRExM
AAAAAABOSVRB+b+4AQCqADfZbgAAAEM6XEV4Y2hhbmdlXG1haWxib3gucHN0ABgAAAAAAAAAR8Ln
lKjWzxGcw0RFU1QAAKKAAAAAAAAAGAAAAAAAAABHwueUqNbPEZzDREVTVAAAwoAAABAAAABoJ4DT
e8LQEZ8LREVTVAAAGQAAAFJFOiBBY2Nlc3MgRGF0YWJhc2UgRmlsZQAAAwA2AAAAAABAADkAAMI+
DktbvAEeAHAAAQAAABkAAABSRTogQWNjZXNzIERhdGFiYXNlIEZpbGUAAAAAAgFxAAEAAAAWAAAA
AbxbSw3704AnasJ7EdCfC0RFU1QAAAAAHgAeDAEAAAAFAAAAU01UUAAAAAAeAB8MAQAAABQAAABt
a25pZ2h0QHBjZS1pbmMuY29tAAMABhDOpLnPAwAHEK0GAAAeAAgQAQAAAGUAAABUVVJOQ0hBUE9G
RkFORFVTRVBBUEFMU09NQUtFU1VSRVRIRU1BQ0hJTkVZT1VBUkVESUFMSU5HSU5GUk9NRE9FU05P
VEhBVkVUSEVFTkNSWVBURURQQVNTV09SRFJFUVVJUkVEAAAAAAIBCRABAAAAcAoAAGwKAABQFwAA
TFpGdZzMxTIDAAoAcmNwZzEyNXIyDGBjMQMwAQcLYG6RDhAwMzMPFmZlD5JPAfcCpANjAgBjaArA
c4RldALRcHJxMgAAkioKoW5vElAgMAHQhQHQNg+gMDUwNBQh8wHQFBA0fQdtAoMAUAPU+xH/Ewti
E+EUUBOyGPQU0K8HEwKAApEI5jsJbzAa3/plDjA1HAodIRzfHekb9P8eEhx/IE8gDR+PHb8cDxBg
/DI4Jdom8SavJ7kb9CfivyZPKh8p3SlfJ48rVDkOUB8upDABKCMwAAKCc3R56mwHkGgJ4HQAABNQ
A/BQZGN0bAqxXDJYYZhkanUxcAUQZ2gFQjsWMgwBYwnAMmADMHNufGV4FzAHsAWwAMACc3OxAFBz
YjIUUDFgYRPw9FxrCeBwC5AyPzKjCGDrMpALgGUxoHY5YAFAM5u/DDA0ZCgAN0AEoAuAZyfx6TTm
YmEXEGQCIDWgNUbnMdAzkDuRIDExMw5QNp//N684vwBROfwAoDRuPH89hv8xJA/APo8/n0CvDlA5
70MP20QfPbMzAoITEGM2YEuhkzOQPbB0aTmQIEQBEKhhdWwFQFAKwGEJwOBhcGggRgIhNiQlQOhm
aS0PkDgBQDkwUDPrRw8yo2ILIHIJUFJSFqDZUlJ3NCVBFwBwAdBNcn8zv0qfS6ZP0E6QBRACMC1D
TzADYTogVG9XsFModWJqBZB0V7BEYeh0ZTo2JDZP/1EPUh//Uy9UOTHAPaMOIUuhOrYOUJtVb1Z+
UjmBFwEgSD2R+wSQNiQ3WW9af1uPXJ05Dy9dvw+QaXAI0GIKsHQ4/0n6D1RGEF+/YMZqAGHQC1C8
eS9PQFywCxFiRXM2JP8oAGM/ZE9lX1yvVE9rX2xv7211V9JXdFipOW+/Mz8DMB1pszlzn3SveqBE
b2P+dQeAAjAF0E8AGgF40ngw93hwcVEBgG5YMABgCfBNoO99AAIBNeBeUmUA8H0AMYCScB6AXHYI
kHdrC4D+ZGtAgKIE8AdAEGEBQA4A73EiPYKCBQIQbwVCFyES8g1YwG0LUVjAIEM6XLpcBeBPASAN
4H/wXIT21kUAwAMQLktwdH3QFxC3eHA1IWdyeAFAfwFuMdD3GvCGlE40YwMgEvMAgAWQ/Gx2QaFG
0A5wNeCJIgGQ/wAgibKA8X1BAcGJIRbgD3DPAABG0AzQAZAgLhoSiRj/DlCJ0k5weMCKT4tfjG8P
wN9G0AWBjg+PH5AvbGtARtDubI3Pko+TlSmMnCVAkW/jlk+ThGIgKAKRl2+JY/9ZUJUfmd+a75v/
iZBjEJ1C/4ofnq+fv4ycKACdT6LPo9//pO+JkHgAoc+nX6hvqXQK+c8DMHgveT96zXtUCHADoEBD
SEFQIG8BICAvAHA1ILCgE4BQsqAuIMAgQWxzbyAAwEag7CBzCHATgHQx0LQxFtD5Z4EgeQhgswC0
sT2wB0DvPcKu0QNSthBvB5ETUAVA/xbgTfG04gnwBQCAUFjANSA7CrAEEHcFsDUgGvBxdR5pGvG2
krTitiItdXC/t2AXILkhgOE94Bdwb4Bg8wAgCJBzLgqFCoW9JX2Ad7tAs+CzwEsDALDxvMpQMEMg
RXgXcAeQcyxcIEm4ULxGvSQoE/AyKCkgNVlALTAAODRJCoVta74zQHCFMC33C4DAIAWgbQqFrjSu
/7AP/QVAe7xcxAZncKwyxI/Fn88IwTTyNaAS8mJrwmCrQxwgX32AAxBYoWF9Lf3Mok+w0QuAB0AF
0L+xTtD/wwDMosObrpZi/W8gyF9wv/9xz2c/aE9pX2pvsdTKpldz4QyCIFdlYgDAMXAEkAAgW1NN
VFA6YqPT8QSQbGtAw2Fw0/DpA2BuLrrxXc5Pz1Ruu//Qj9Gf0q9yv7FcDCHKtQZgfwIw2TQaIsrE
2ZCHoAeQZKxheb/gfYB5E5A3v+ABL/A5NyA0OjIzvU6QTcOW41lX0eRdUj2hceHQTlRAhBAEkAdA
ZHouCJBhw1rjWlgl5F1BfmOFMAQRzFJLMk8wAxBl/9wPrtLIH8kv4g+x48cv8F/78W/GY1S08QDQ
7cPloO41b27QMaC00ViwIIGQB4Ag/wPwtOC5YOmTtxgXEIQQtNB9tCBi+UG7NAqFf3G0MGW9s8FJ
t6UIgTUgYeJ5tOAfPcL80MJw9RD5VE9EQv+/ULMS7aSzwfcy9+K00gqF3HNxAyAEAPkBbLZT/EL/
AaEN0IQhuCIIYPJwv+BNwP20gGgIYOpg+yIMoPiStCD/btCzIViwMaDZ0QC5WMAFoU2zUXK8Tfm1
LXhW0S2xtCAtUjMOkAGhd/jSX/zQs1L7Acuk+bUoBVZtbxNgg1Cy0LQweQYG/VFzfim8XPzQgZC6
EdSAAYBJ/4NQAaEa8D2ktOL3dfhz+zD/gZAJ07TxBtFh8baQutACkv8D8BZw+7e6wQlgG3D5pqtD
/bw+QtPwExT80BpwtoP80DfN0AWyAaA6Bx8a8GN2/1ewYdC5kAaCttMD8AWhGxB4YzkwKFCT4MNg
q/A9yjEDkWQaYDk2v+AxoKdeoP7gGmAzObzJVQbRRC1O+SI9ICIGciL9vMlDCXAB8BsxwwBh0OFA
a0uAYiE9+9UihLDWEDFCaCABMzReYFlQXDIyRnFcM9YhIPA3Mf5XITElMSFAIQAhMRuQITLrgIAh
QDcicjRrQCFACQBBHYpOQVMtSavyaU9u0NoBHRB7IDgueyAxqC4xNCYQNiQtUAJg/4NQJcEbv+QA
EWCFIR0BV3D5+SFkLRxyvMkp1VcAg0BtfQBvAYAdEFAsULzJVq9/AQJgKSCAYGMlYWMdAv8dii0/
Lk8vX/O/9M/138Zj72HQhTBN4bMxbv5y8ABYsP/yQdqRhHAiUDJfM280f8Zj370i7aFXQOQA97Bp
S4AlAWcdAtYR1hE0OSQeJ6ItxlSAUR0BQXN5uFAHiL5fTlC04SVBgZBYwF//Ev4oDQYeDx8fIC8h
PyJPI18//BFOILhmTqC5BFewL/cArEVapEkrPbvgpqwrPj9C5rPwFeC7QFFMglPuMIQBfUEuS/Dx
vF1TUUxLWFfx1EE5QIVYk0F/ICgnZCe/4P21IC5WobhAO+JPIr9xubH5WKIpLEeWTo9Pn1CktIDP
6rDtodPgrbBJRFP6PmLvUPZUEUimU/NMFfDNMFPz/lMVgA5x2PJ9cdniVEUBsL+1IL/g7DFZB82w
+9VXh8LTqOBXJj0nBnInssBWM0dX81wVwVBBTkRSMkPv8iHbMG4gVLA9VBFeSPvVz/9iVBO8ANRw
PD7tgP9i/1JBYKe8XNjw+sBLI00qS/h4TE9HdzAccncwBnNO94NBgyA2YGS8XGVvZnjkAf8PM20A
7GIL4nuBGtH68hmX9ii68RFEMQ0OsvAN8bvA/+YQEQMBcatBS5S2kfsB93X/FlaEcM0wf3JLAXUA
/MF1YP/lULPBFTENh/ISDgJcIBZj3wOx/uADUvmlvE1QBXKEcP1YAXBkpoDxWqa8XcyjeE//eV96
b84n6Xe9kYYg/hJ2UP8FoX141BDyMBFE6g6tcMsmR4eBy/nDln0AAIHwAwAQEAAAAAADABEQAAAA
AAMAgBD/////QAAHMOBVpOlKW7wBQAAIMOBVpOlKW7wBCwABgAggBgAAAAAAwAAAAAAAAEYAAAAA
A4UAAAAAAAADAAWACCAGAAAAAADAAAAAAAAARgAAAABShQAAtw0AAB4ABoAIIAYAAAAAAMAAAAAA
AABGAAAAAFSFAAABAAAABAAAADguMAADAAeACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAsA
EIAIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwARgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUA
AAAAAAADABKACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMAFYAIIAYAAAAAAMAAAAAAAABG
AAAAABiFAAAAAAAAHgAlgAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAB4AJoAI
IAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeACeACCAGAAAAAADAAAAAAAAARgAA
AAA4hQAAAQAAAAEAAAAAAAAAHgA9AAEAAAAFAAAAUkU6IAAAAAADAA00/TcAAKsH
------ =_NextPart_000_01BC5B10.62FD40E0--