Hi Dave -
I have enclosed a patched version of LogSQL.pm for you to try.
Please let us know if it works correctly for you and we will roll the
patch into the next release.
regards
Hugh
At 22:48 -0600 01/1/15, Dave Salaman wrote:
>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.
%LogSQL.pm
LogSQL.pm
--
NB: I am travelling this week, so there may be delays in our correspondence.
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
