we are running radiator (vers: 2.13.1) and mysql for just a while
without problems (thanks to mike for a realy good product). now we got
an oracle database. i've ported all tables from mysql to oracle. then i
compiled the DBI and DBD perl modules without problems.
after that i wanted to test radiator with oracle. following problem
occured-->
Packet length = 70
01 49 00 46 31 32 33 34 35 36 37 38 39 30 31 32
33 34 35 36 01 08 73 61 6e 63 68 72 06 06 00 00
00 02 04 06 cb 3f 9a 01 05 06 00 00 04 d2 3d 06
00 00 00 00 02 12 99 ee 0b bc 82 0d de b2 7a c7
f6 68 8a 06 38 80
Code: Access-Request
Identifier: 73
Authentic: 1234567890123456
Attributes:
User-Name = "sanchr"
Service-Type = Framed-User
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
User-Password = "xxx"
Thu Apr 1 11:22:28 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Thu Apr 1 11:22:28 1999: DEBUG: Handling with Radius::AuthSQL
Thu Apr 1 11:22:28 1999: DEBUG: Handling with Radius::AuthSQL
Thu Apr 1 11:22:28 1999: DEBUG: Query is: select pw from rtest
where login = 'sanchr'
Thu Apr 1 11:22:28 1999: DEBUG: Radius::AuthSQL looks for match
with sanchr
Thu Apr 1 11:22:28 1999: DEBUG: Radius::AuthSQL REJECT: Bad
Password
Thu Apr 1 11:22:28 1999: DEBUG: Query is: select pw from rtest
where login = 'DEFAULT'
Thu Apr 1 11:22:28 1999: INFO: Access rejected for sanchr: Bad
Password
Thu Apr 1 11:22:28 1999: DEBUG: Packet dump:
*** Sending to 195.243.199.130 port 58015 ....
Code: Access-Reject
Identifier: 73
Authentic: 1234567890123456
Attributes:
Reply-Message = "Request Denied"
Thu Apr 1 11:23:00 1999: NOTICE: SIGTERM received: stopping
when i use the exact config-file with changed dbi:... -statement everything works fine -->
Packet length = 70
01 03 00 46 31 32 33 34 35 36 37 38 39 30 31 32
33 34 35 36 01 08 73 61 6e 63 68 72 06 06 00 00
00 02 04 06 cb 3f 9a 01 05 06 00 00 04 d2 3d 06
00 00 00 00 02 12 99 ee 0b bc 82 0d de b2 7a c7
f6 68 8a 06 38 80
Code: Access-Request
Identifier: 3
Authentic: 1234567890123456
Attributes:
User-Name = "sanchr"
Service-Type = Framed-User
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
User-Password = "xxx"
Thu Apr 1 11:21:18 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Thu Apr 1 11:21:18 1999: DEBUG: Handling with Radius::AuthSQL
Thu Apr 1 11:21:18 1999: DEBUG: Handling with Radius::AuthSQL
Thu Apr 1 11:21:18 1999: DEBUG: Query is: select pw from rtest
where login = 'sanchr'
Thu Apr 1 11:21:18 1999: DEBUG: Radius::AuthSQL looks for match
with sanchr
Thu Apr 1 11:21:18 1999: DEBUG: Radius::AuthSQL ACCEPT:
Thu Apr 1 11:21:18 1999: DEBUG: Access accepted for sanchr
Thu Apr 1 11:21:18 1999: DEBUG: Packet dump:
*** Sending to 195.243.199.130 port 58014 ....
Code: Access-Accept
Identifier: 3
Authentic: 1234567890123456
Attributes:
Ascend-Idle-Limit = 900
Thu Apr 1 11:21:33 1999: NOTICE: SIGTERM received: stopping
is there something to know about oracle???
i've also tested the sql-query with a simple perl-script:
the output of oracle is exact the same as that from mysql
does anybody know what went wrong??
best regards
christoph sander
bavaria telecentrum