Ciao Christian -
Could you please send me a couple of user definitions from your database, so I can see the contents of the various fields? thanks Hugh On Thu, 11 Jul 2002 00:27, Christian Rautscher wrote: > Hi there, > > I'm actually testing Radiator 3.1 DEMO Version for different kind > of AccessAuthentications for different Services on Cisco Routers. > When i tested Radiator by a "flat-file" Authentication everything > went well. > Actually i am using Mysql as DB and it works fine > for Login and Administrative Services, but only the Dial-IN connections > with PPP doesn't work. The Debug on my Cisco-Router tells me Authorization > errors. > > ( I am sure that the Cisco Config is fine, 'coz it works with > Radiator-Flat-File-Authentication) > > My Radiator config looks like this: > --------------------------------------------------------------------------- >------------------------- <ClientListSQL> > DBSource dbi:mysql:radius > DBUsername [snip] > DBAuth [snip] > </ClientListSQL> > > <Realm DEFAULT> > <AuthBy SQL> > DBSource dbi:mysql:radius > DBUsername [snip] > DBAuth [snip] > > AuthSelect select password, checkattr, replyattr from SUBSCRIBERS > where USERNAME='%U' > > AuthColumnDef 0, User-Password, check > AuthColumnDef 1, GENERIC, check > AuthColumnDef 2, GENERIC, reply > --------------------------------------------------------------------------- >---------------------------- > > The Radiator Log "trace 5" looks like this. The User Authentication seems > going well, but after that > in the Section of "Reply-Attributes" the log acruptly ends without any > reason. > > I'd like to thank you just in advance for your help, and if anyone needs > any other > information, please don't hesitate to contact me. > Thankyou and kind regards, > Chris > > > ---------------------------- > Log-File Radiator (trace5) > > Code: Access-Request > Identifier: 131 > Authentic: <185><152>Mw&<156><132><27>h;<179><160>c6<233>9 > Attributes: > NAS-IP-Address = [snip] > NAS-Port = 74 > NAS-Port-Type = Async > User-Name = "test" > Called-Station-Id = "[snip]" > Calling-Station-Id = "[snip]" > User-Password = "[snip]" > Service-Type = Framed-User > Framed-Protocol = PPP > > Wed Jul 10 15:51:36 2002: DEBUG: Handling request with Handler > 'Realm=DEFAULT' > Wed Jul 10 15:51:36 2002: DEBUG: Deleting session for test, > IP-ADDRESS[snip], 74 > Wed Jul 10 15:51:36 2002: DEBUG: Handling with Radius::AuthSQL > Wed Jul 10 15:51:36 2002: DEBUG: Handling with Radius::AuthSQL: > Wed Jul 10 15:51:36 2002: DEBUG: Query is: select password, checkattr, > replyattr from SUBSCRIBERS where USERNAME='test' > > Wed Jul 10 15:51:36 2002: DEBUG: Radius::AuthSQL looks for match with > bcomtest > Wed Jul 10 15:51:36 2002: DEBUG: Radius::AuthSQL ACCEPT: > Wed Jul 10 15:51:36 2002: DEBUG: Access accepted for test > Wed Jul 10 15:51:36 2002: DEBUG: Packet dump: > *** Sending to IP[snip] port 1645 .... > > Packet length = 20 > 02 83 00 14 9a 9e 5d 4b 4f 70 91 b2 73 7f f1 dc > a1 6e 2b 7b > Code: Access-Accept > Identifier: 131 > Authentic: <185><152>Mw&<156><132><27>h;<179><160>c6<233>9 > Attributes: > > > > > === > Archive at http://www.open.com.au/archives/radiator/ > Announcements on [EMAIL PROTECTED] > To unsubscribe, email '[EMAIL PROTECTED]' with > 'unsubscribe radiator' in the body of the message. -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.