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.
>
===
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.
