On Tue, Aug 24, 1999 at 07:43:15PM +1000, Hugh Irvine wrote:
>
> On Tue, 24 Aug 1999, O Stockhammer wrote:
>
> > And the second set seem to be with the MySQL DBM module when it tries to
> > query the database:
> >
> > DBD::mysql::db do failed: You have an error in your SQL syntax near
> > 'Realm='',
> > 'Aug 21, 1999 12:35')' at line 2 at
> > /usr/local/lib/perl5/site_perl/5.005/Radius/SqlDb.pm line 189.
[...]
> >
>
> I note in your configuration file that you have redefined your SQL accounting.
> The above errors are due to missing values as indicated by the " ,'', " strings
> in the debug messages. If you could send us the corresponding debug output we
> will see what packets (and values) are causing the problems.
Hi Hugh,
I'm not sure if you saw my follow-up to Oliver question, but it
looks like the problem is that when you try to insert a log message
into the MySQL db, SqlDb.pm does not escape single quotes ( ' )
that exist in the message. Thus, MySQL interprets the single quote
surrounding a word as an end of field, causing the errors below.
I reproduce them below so you can see the whole set of errors caused
by the misinterpretation of the single quote.
I don't think the empty value is a problem because MySQL would just
enter a NULL into that field.
--
Omar Thameen
Systems Administration
The Internet Channel
[EMAIL PROTECTED]
------------------------- Begin included text -------------------------
DBD::mysql::db do failed: You have an error in your SQL syntax near 'Realm='', 'Aug
21, 1999 12:35')' at line 2 at /usr/local/lib/perl5/site_perl/5.005/Radius/SqlDb.pm
line 189.
DBD::mysql::db do failed: You have an error in your SQL syntax near 'Realm='', 'Aug
21, 1999 12:35')' at line 2 at /usr/local/lib/perl5/site_perl/5.005/Radius/SqlDb.pm
line 189.
DBD::mysql::db do failed: You have an error in your SQL syntax near 'PPP', '4evryng',
'', 'Async', '207.240.215.217', 'ccittV42bi' at line 2 at
/usr/local/lib/perl5/site_perl/5.005/Radius/SqlDb.pm line 189.
DBD::mysql::db do failed: You have an error in your SQL syntax near 'PPP', '4evryng',
'', 'Async', '207.240.215.217', 'ccittV42bi' at line 2 at
/usr/local/lib/perl5/site_perl/5.005/Radius/SqlDb.pm line 189.
DBD::mysql::db do failed: You have an error in your SQL syntax near '4evryng' and
NAS_IDENTIFIER='207.240.142.9' and NAS_PORT=333' at line 2 at
/usr/local/lib/perl5/site_perl/5.005/Radius/SqlDb.pm line 189.
DBD::mysql::db do failed: You have an error in your SQL syntax near '4evryng' and
NAS_IDENTIFIER='207.240.142.9' and NAS_PORT=333' at line 2 at
/usr/local/lib/perl5/site_perl/5.005/Radius/SqlDb.pm line 189.
-------------------------- End included text --------------------------
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
