Hi Dave -
Hmmmm - that is what the patch is supposed to do, but I haven't been
able to test it yet. I'll check with Mike when I see him next.
cheers
Hugh
At 10:34 -0600 01/1/19, Dave Salaman wrote:
>Thanks Hugh,
>
>The patch didn't change anything but you were on the right track though.
>
>If I add a single backslash in the AuthSelect clause it goes through ok.
>Both 'test\@ing' and '%U\@%R' work fine, the latter effectively
>substituting for %n.
>
>
>On Fri, 19 Jan 2001, Hugh Irvine wrote:
>
>>
>> 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.
>>
--
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.
===
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.
