Hi,
I'm having trouble getting AuthLog SQL to work under MySQL when a query
which expands to anything containing the '@' symbol. This includes the use
of %n and %u with usernames in the form of username@realm.
For example, using the following query
SuccessQuery insert into RADAUTHLOG \
(Time, User, Realm , Client, Password, Result, Timestamp) \
values ('%l', '%n', '%R', '%C', '%P', 'Succeeded', %t)
the first access-request to hit the server after a restart produces the
following
Mon Jan 15 21:53:48 2001: INFO: Server started: Radiator 2.17.1 on xxxxxx
Global symbol "@savvistest" requires explicit package name at (eval 39) line 1.
DBD::mysql::db do failed: Query was empty at Radius/SqlDb.pm line 259.
DBD::mysql::db do failed: Query was empty at Radius/SqlDb.pm line 259.
Mon Jan 15 21:55:14 2001: DEBUG: Packet dump:
[...]
Mon Jan 15 21:55:14 2001: DEBUG: Handling request with Handler 'NasType=NortelCVX1800,
Realm=test'
Mon Jan 15 21:55:14 2001: DEBUG: Rewrote user name to dsalaman@savvistest
[...]
Mon Jan 15 21:55:14 2001: DEBUG: Radius::AuthSQL looks for match with
dsalaman@savvistest
Mon Jan 15 21:55:14 2001: DEBUG: Radius::AuthSQL ACCEPT:
Mon Jan 15 21:55:14 2001: DEBUG: Access accepted for dsalaman@savvistest
Mon Jan 15 21:55:14 2001: DEBUG: do query is:
Mon Jan 15 21:55:14 2001: ERR: do failed for '': Query was empty
Mon Jan 15 21:55:14 2001: ERR: do failed for '': Query was empty
subsequent access-requests do not contain the "Global symbol
"@savvistest"" and DBD::mysql::db do failed: errors and the querys succeed
but the @realm part of the username is truncated
Mon Jan 15 21:57:31 2001: DEBUG: Handling request with Handler 'NasType=NortelCVX1800,
Realm=test'
Mon Jan 15 21:57:31 2001: DEBUG: Rewrote user name to dsalaman@savvistest
[...]
Mon Jan 15 21:57:31 2001: DEBUG: Radius::AuthSQL looks for match with
dsalaman@savvistest
Mon Jan 15 21:57:31 2001: DEBUG: Radius::AuthSQL ACCEPT:
Mon Jan 15 21:57:31 2001: DEBUG: Access accepted for dsalaman@savvistest
Mon Jan 15 21:57:31 2001: DEBUG: do query is: insert into RADAUTHLOG
(Time, User, Realm , Client, Password, Result, Timestamp) values ('Mon Jan 15 21:57:31
2001', 'dsalaman', 'savvistest', 'usstls1-01.cvx-a.savvis.net', 'xxxxxx', 'Succeeded',
979617451)
Replacing %n in rhe query with %U squeches the error messages. Replacing
%n with 'test@ing' produces the bug, eliminating the expansion itself from
suspicion.
Does the fault lay with MySQL, DBD/DBI, or Radiator ?
Thanks,
--
Dave
Savvis Communications
St.Louis, Missouri
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.