[RadiusNT] PPP has no RADIUS default attributes

Chuck Chopp ( ChuckChopp@rtfmcsi.com )
Fri, 11 Feb 2000 09:26:36 -0500

This is a multi-part message in MIME format.
--------------9F3FC04E754A57B69C78E5EE
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I'm running RadiusNT v2.5.205 on WinNT 4.0 SP5. I am using ODBC and the
DSN name is RADIUS_25. This DSN is configured to use the sample
"radius97.mdb" file that is shipped with the RadiusNT product.

I am trying to do a basic test of my configuration before proceeding any
further. However, I cannot get a successful authentication test to run
when using the RADLOGIN.EXE utility. I have configured the "localhost"
entry at address 127.0.0.1 with secret "localhost" as described in the
product documentation. I have all of my other configuration settings in
place. I start RadiusNT in interactive mode with the command "radius
-x15 > logfile.txt" all stdout text is piped to a log file.

Anyway, all attempts at authenticating with a value username/password
("radlogin test test") result in the message "PPP has no RADIUS default
attributes" being generated in the log file. I have verified that the
RadATConfigs table does contain two records for account type "PPP". The
field values are 6/2/2 adn 7/1/1, respectively, for those two records;
these are the defaults.

I noticed that early in the log file there is an ODBC error that happens
due to a syntax error in an SQL statement. I think that this SQL error
is the actual source of the problem since it appears to affect the
loading of attribute information from the database into the radius
program.

Has anybody else encountered this problem and had it resolved to their
satisfaction?

Please refer to the attached log file that shows the actual SQL error
and the results of the authentication attempt.

TIA,

Chuck

--Chuck Chopp

ChuckChopp@rtfmcsi.com            http://www.rtfmcsi.com                                  ICQ # 22321532RTFM Consulting Services Inc.     864 801 2795 voice & voicemail103 Autumn Hill Road              864 801 2774 faxGreer, SC  29651                  800 400 4935 pager                                  8004004935@alphapage.airtouch.com



--------------9F3FC04E754A57B69C78E5EEContent-Type: application/x-unknown-content-type-txtfile; name="t4.log"Content-Transfer-Encoding: base64Content-Disposition: inline; filename="t4.log"

DQowKSBJZ25vcmVDYXNlOiAwDQoxKSBSZXFBY2N0QXV0aDogMA0KMikgQWxsb3dNYWxmb3JtZWQ6IDENCjMpIFRyaW1OYW1lOiAzDQo0KSBNb2RlOiAxDQo1KSBQcm94eTogMA0KNikgT3B0aW9uczogNjUNCjcpIFNOTVA6IDANCjgpIERlYnVnOiAxNQ0KOSkgTG9nRmlsZTogYzpcdGVtcFxyYWRpdXNudC5sb2cNCjEwKSBBY2N0TG9nRmlsZTogDQoxMSkgT0RCQ0RhdGFzb3VyY2U6IFJBRElVU18yNQ0KMTIpIFVzZXJuYW1lOiANCjEzKSBQYXNzd29yZDogDQoxNCkgQWNjdE9EQkNEYXRhc291cmNlOiANCjE1KSBBY2N0VXNlcm5hbWU6IA0KMTYpIEFjY3RQYXNzd29yZDogDQoxNykgVGVzdERhdGFiYXNlU2VjczogDQoxOCkgRGF0YURpcmVjdG9yeTogZTpccHJvZ3JhfjFccmFkaXVzbnQNCjE5KSBBY2N0RGlyZWN0b3J5OiANCjIwKSBVc2Vyc0ZpbGU6IFVzZXJzDQoyMSkgQ29tcGFueU5hbWU6IE5ldHdpdHogSW50ZXJuZXQNCjIyKSBMaWNlbnNlOiA2Njk1NzIwMDA1OTUwMDAwMDAwMTc2MDcNCjIzKSBJUEFkZHJlc3M6IEFsbA0KMjQpIEF1dGhQb3J0OiAxNjQ1DQoyNSkgQWNjdFBvcnQ6IDE2NDYNCjI2KSBDYWNoZVVzZXJQcmVmZXRjaExhc3REYXlzOiANCjI3KSBDYWNoZVVzZXJNb2RpZnlDaGVja1NlY3M6IA0KMjgpIENhY2hlVXNlckRlbGV0ZUFmdGVyVW51c2VkRGF5czogDQoyOSkgQ2FjaGVVc2VyRm9yY2VVcGRhdGVEYXlzOiANCjMwKSBDYWNoZVVzZXJSZW1vdmVEZWxldGVkTWluczogDQozMSkgQ2FjaGVVc2VyTm9RdWVyeU9uRmFpbFNlY3M6IA0KMzIpIENhY2hlRG91YmxlQ2hlY2s6IDANCjMzKSBDYWNoZUFjY291bnRUeXBlc1VwZGF0ZU1pbnM6IA0KMzQpIENhY2hlU2VydmVyQWNjZXNzVXBkYXRlTWluczogDQozNSkgQ2FjaGVETklTVXBkYXRlTWluczogDQozNikgQ2FjaGVQcm94eUF0dHJpYnV0ZU1pbnM6IA0KMzcpIERhdGFiYXNlVGltZU9mZnNldERheXM6IA0KMzgpIENhY2hlV3JpdGVNaW5zOiANCjM5KSBNYXhBY2N0U3Bvb2xJdGVtczogDQo0MCkgQWNjdE1heEhvbGRUaW1lOiANCjQxKSBBY2N0TWF4QmF0Y2hJdGVtczogDQo0MikgQ2FjaGVSb290RGlyZWN0b3J5OiANCjQzKSBOVkZsYWc6IDANCjQ0KSBTeXNMb2dJUDogDQoNClBhcmFtOiBEZWJ1ZyBMZXZlbDogMTUNCkluaXRpYWxpemluZyBXaW5zb2NrLi4uDQpPREJDIERhdGFzb3VyY2U6ICdSQURJVVNfMjUnLi4uDQpNYWtpbmcgT0RCQyBDb25uZWN0aW9uLi4uDQpNUyBBY2Nlc3MgTW9kZSBFbmFibGVkDQpPREJDIERhdGFzb3VyY2U6ICdSQURJVVNfMjUnLi4uDQpNYWtpbmcgT0RCQyBDb25uZWN0aW9uLi4uDQpNUyBBY2Nlc3MgTW9kZSBFbmFibGVkDQoNCiBTUUwgU3RhdGVtZW50OiBTZWxlY3QgTmFtZSwgUmFkQXR0cmlidXRlSUQsIFR5cGUsIFJhZFZlbmRvcklELCBSYWRWZW5kb3JUeXBlIEZyb20gUmFkQXR0cmlidXRlcyBPcmRlciBCeSBSYWRWZW5kb3JJRCwgUmFkQXR0cmlidXRlSUQNCg0KDQogU1FMIFN0YXRlbWVudDogU2VsZWN0IHJhLk5hbWUsIHJ2Lk5hbWUsIHJ2LlZhbHVlLCBydi5WZW5kb3JJRCwgcnYuUmFkVmVuZG9yVHlwZUZyb20gUmFkVmFsdWVzIHJ2LCBSYWRBdHRyaWJ1dGVzIHJhIFdoZXJlIHJ2LlJhZEF0dHJpYnV0ZUlEID0gcmEuUmFkQXR0cmlidXRlSUQgIGFuZCBydi5SYWRWZW5kb3JJRCA9IHJhLlJhZFZlbmRvcklEICBhbmQgcnYuUmFkVmVuZG9yVHlwZSA9IHJhLlJhZFZlbmRvclR5cGUNCg0KT0RCQyBFcnJvcjozNzAwMDotMzEwMDoNCiBbTWljcm9zb2Z0XVtPREJDIE1pY3Jvc29mdCBBY2Nlc3MgRHJpdmVyXSBTeW50YXggZXJyb3IgKG1pc3Npbmcgb3BlcmF0b3IpIGluIHF1ZXJ5IGV4cHJlc3Npb24gJ3J2LlJhZFZlbmRvclR5cGVGcm9tIFJhZFZhbHVlcyBydicuDQoNCiAxMTggRGljdGlvbmFyeSBBdHRyaWJ1dGVzIExvYWRlZC4uLg0KDQogU1FMIFN0YXRlbWVudDogU2VsZWN0IFNlcnZlciwgSVBBZGRyZXNzLCBTZWNyZXQgRnJvbSBTZXJ2ZXJzDQoNCiAxIENsaWVudHMgTG9hZGVkDQogMTUgQWNjb3VudGluZyBDb2x1bW5zIExvYWRlZA0KY29uZmlnX2luaXQoKTogZGljdF92YWxmaW5kKExpZmV0aW1lLUluLURheXMpIG5vdCBmb3VuZC4NCg0KUmFkaXVzTlQgMi41LjIwNSBTdGFuZGFyZCBJbml0aWFsaXplZC4uLg0KDQoNCnJhZHJlY3Y6IFJlcXVlc3QgZnJvbSBob3N0IDdmMDAwMDAxIGNvZGU9MSwgaWQ9ODYsIGxlbmd0aD01Ng0NCiAgICBOQVMtSWRlbnRpZmllciA9IDEyNy4wLjAuMQ0KICAgIE5BUy1Qb3J0ID0gMA0KICAgIFVzZXItTmFtZSA9ICJ0ZXN0Ig0KICAgIFBhc3N3b3JkID0gIlwyMjVaR1ldXDIxNFwzMDZcMjYxXDM3MXdcMjQyfVwyMTNcMzcxXDI1M1wzNjIiDQpyYWRfYXV0aGVudGljYXRlX09EQkMoKQ0NCg0KIFNRTCBTdGF0ZW1lbnQ6IFNlbGVjdCBEYXRlRGlmZignbicsIE5vdywgRGF0ZUFkZCgnZCcsIG1hLkV4dGVuc2lvbisxLCBtYUV4cGlyZURhdGUpKSwgRGF0ZURpZmYoJ24nLCBOb3csIERhdGVBZGQoJ2QnLCBtYS5FeHRlbnNpb24rMSwgbWFFeHBpcmVEYXRlKSksIHNhLkFjY291bnRJRCwgc2EuQWNjb3VudFR5cGUsIHNhLlBhc3N3b3JkLCBzYS5Mb2dpbiwgc2EuU2hlbGwsIHNhLkxvZ2luTGltaXQgRnJvbSBNYXN0ZXJBY2NvdW50cyBtYSwgU3ViQWNjb3VudHMgc2EgIFdoZXJlIHNhLkxvZ2luPSd0ZXN0JyAgQU5EIG1hLkN1c3RvbWVySUQ9c2EuQ3VzdG9tZXJJRCBhbmQgc2EuQWN0aXZlPD4wIGFuZCBtYS5BY3RpdmU8PjANCg0KQ2hlY2tpbmcgZm9yIGR1cGxpY2F0ZSBsb2dpbnMuDQoNCiBTUUwgU3RhdGVtZW50OiBTZWxlY3QgQ291bnQoVXNlcm5hbWUpIEZyb20gU2VydmVyUG9ydHMgV2hlcmUgVXNlcm5hbWU9J3Rlc3QnIGFuZCBBY2N0U3RhdHVzVHlwZT0xDQoNCiAgICAgIHRlc3QgZm91bmQgb24tbGluZSAwIHRpbWUocykuDQoNCiBTUUwgU3RhdGVtZW50OiBTZWxlY3QgcmEuUmFkQXR0cmlidXRlSUQsIE5hbWUsIERhdGEsIFZhbHVlLCBUeXBlLCByYy5SYWRWZW5kb3JJRCwgcmMuUmFkVmVuZG9yVHlwZSwgcmMuUmFkQ2hlY2sgRnJvbSBSYWRDb25maWdzIHJjLCBSYWRBdHRyaWJ1dGVzIHJhIFdoZXJlIHJhLlJhZEF0dHJpYnV0ZUlEPXJjLlJhZEF0dHJpYnV0ZUlEICBBTkQgcmEuUmFkVmVuZG9ySUQ9cmMuUmFkVmVuZG9ySUQgIEFORCByYS5SYWRWZW5kb3JUeXBlPXJjLlJhZFZlbmRvclR5cGUgIEFORCByYy5BY2NvdW50SUQ9MQ0KDQoNCiBTUUwgU3RhdGVtZW50OiBTZWxlY3QgcmEuUmFkQXR0cmlidXRlSUQsIE5hbWUsIERhdGEsIFZhbHVlLCBUeXBlLCByYy5SYWRWZW5kb3JJRCwgcmMuUmFkVmVuZG9yVHlwZSwgcmMuUmFkQ2hlY2sgRnJvbSBSYWRBVENvbmZpZ3MgcmMsIFJhZEF0dHJpYnV0ZXMgcmEgV2hlcmUgcmEuUmFkQXR0cmlidXRlSUQ9cmMuUmFkQXR0cmlidXRlSUQgIEFORCByYS5SYWRWZW5kb3JJRD1yYy5SYWRWZW5kb3JJRCAgQU5EIHJhLlJhZFZlbmRvclR5cGU9cmMuUmFkVmVuZG9yVHlwZSAgQU5EIHJjLkFjY291bnRUeXBlPSdQUFAnDQoNClNlbmRpbmcgUmVqZWN0IG9mIGlkIDg2IHRvIDdmMDAwMDAxIChsb2NhbGhvc3QpDQ0KdGVzdDogUFBQIGhhcyBubyBSQURJVVMgZGVmYXVsdCBhdHRyaWJ1dGVzLg0KDQ0KdGVzdDogUFBQIGhhcyBubyBSQURJVVMgZGVmYXVsdCBhdHRyaWJ1dGVzLg0KDQ0KIFNRTCBTdGF0ZW1lbnQ6IElOU0VSVCBJTlRPIFJhZExvZ3MoUmFkTG9nTXNnSUQsIExvZ0RhdGUsIFVzZXJuYW1lLCBEYXRhLCBOQVNJZGVudGlmaWVyLCBOQVNQb3J0LCBDYWxsZXJJRCkgIFZBTFVFUyAoMTksIE5vdywgJ3Rlc3QnLCAndGVzdCcsICcxMjcuMC4wLjEnLCAwLCBOVUxMKQ0KDQpPREJDIEVycm9yOlMwMDIyOi0xNTA3Og0KIFtNaWNyb3NvZnRdW09EQkMgTWljcm9zb2Z0IEFjY2VzcyBEcml2ZXJdIFRoZSBJTlNFUlQgSU5UTyBzdGF0ZW1lbnQgY29udGFpbnMgdGhlIGZvbGxvd2luZyB1bmtub3duIGZpZWxkIG5hbWU6ICdOQVNJZGVudGlmaWVyJy4gIE1ha2Ugc3VyZSB5b3UgaGF2ZSB0eXBlZCB0aGUgbmFtZSBjb3JyZWN0bHksIGFuZCB0cnkgdGhlIG9wZXJhdGlvbiBhZ2Fpbi4NCg0KUmVzcCBUaW1lOiAxMDAgCSBBdXRoOiAwLzEgLT4gMSAgQWNjdDogMC8wLzAgLT4gMA0KDQoNCiBDTEVBTlVQIElOIFBST0dSRVNTICgyKS4uLi4NCg0K--------------9F3FC04E754A57B69C78E5EE--