Hi Richard,
I have had some reports of simlar odd behaviour from recent versions of the
mysql client libraries. So You might consider dropping back some revision
level.
Also I notice that there is something odd in the syntax you are using:
> Fri Apr 2 10:50:17 1999: ERR: Execute failed for 'Select PASSWORD,
> IDLETIME, SESSIONTIME, SIMUSE, LOGONTIME, STATICIP, from Subscribers
^
^ bogus comma
> Where USERNAME = 'rhawley' and STATUS = 'A'': You have an error in your
> SQL syntax near 'from Subscribers Where USERNAME = 'rhawley' and STATUS
> = 'A'' at line 1
May I see your config file (no secrets)?
Here we run
Msql-Mysql-modules-1.1828.tar.gz
DBI-1.02.tar.gz
Radiator 2.13.1
mysql-3.21.33b.tar.gz
without any problems.
On Apr 2, 2:22pm, Richard Hawley wrote:
> Subject: (RADIATOR) New radiator setup
> I am setting up Radiator 2.13 on a new box and I am getting the
> following error. The accounting is working fine. I checked the select
> statement in my radius.cfg file by loading mysql and typing it in by
> hand and it works.
>
> sending Access-Request...
> DBD::mysql::st execute failed: You have an error in your SQL syntax near
> 'from Subscribers Where USERNAME = 'rhawley' and STATUS = 'A'' at line 1
> at /usr/lib/perl5/site_perl/Radius/SqlDb.pm line 154.
>
> Log at trace 4
>
> Fri Apr 2 10:50:17 1999: ERR: Execute failed for 'Select PASSWORD,
> IDLETIME, SESSIONTIME, SIMUSE, LOGONTIME, STATICIP, from Subscribers
> Where USERNAME = 'rhawley' and STATUS = 'A'': You have an error in your
> SQL syntax near 'from Subscribers Where USERNAME = 'rhawley' and STATUS
> = 'A'' at line 1
>
> The accounting start and stop test worked fine. What am I missing that
> is causing this error. I know its not an error in the select statement
> because it works manually. So it must be a perl module I am missing?
>
> Radiator 2.13
> Msql-Mysql-modules 1.2009
> DBI 1.06
> TimeDate 1.08
>
> ..Rich
>
>
>
> ===
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>-- End of excerpt from Richard Hawley
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, external, etc etc on Unix, Win95/8, NT, Rhapsody
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
