Re: (RADIATOR) Radiator errors
Hi Oliver, thanks for reporting this problem. It was due to a bug in our code. We have fixed it, and you can download the fixed version of LogSQL.pm from http://www.open.com.au/radiator/downloads/patches-2.13.1/LogSQL.pm We apologise for that problem. Please let me know how you get on. Cheers. On May 13, 3:37pm, Oliver Stockhammer wrote: > Subject: (RADIATOR) Radiator errors > > > Hello, > I am running radpwtst and everytime I do so I get an error. I am > putting all accounting into a mysql database and authenticating off of a > flat file. Here is one of the repeditive errors being sent to STDOUT. > > DBD::mysql::db do failed: You have an error in your SQL syntax near > '203.63.154.1' and NASPORT=1234 > ')' at line 2 at /usr/local/lib/perl5/site_perl/5.005/Radius/SqlDb.pm line > 189. > Thu May 13 17:54:38 1999: ERR: do failed for 'insert into RADLOG > (TIME_STAMP, PRIORITY, MESSAGE) > values (926632478, 4, 'do query is: delete from RADONLINE > where NASIDENTIFIER='203.63.154.1' and NASPORT=1234 > ')': You have an error in your SQL syntax near '203.63.154.1' and > NASPORT=1234 > ')' at line 2 > DBD::mysql::db do failed: You have an error in your SQL syntax near > '203.63.154.1' and NASPORT=1234 > ')' at line 2 at /usr/local/lib/perl5/site_perl/5.005/Radius/SqlDb.pm line > 189. > Thu May 13 17:54:38 1999: ERR: do failed for 'insert into RADLOG > (TIME_STAMP, PRIORITY, MESSAGE) > values (926632478, 4, 'do query is: delete from RADONLINE > where NASIDENTIFIER='203.63.154.1' and NASPORT=1234 > ')': You have an error in your SQL syntax near '203.63.154.1' and > NASPORT=1234 > ')' at line 2 > > It is logging properly to the ACCOUNTING, RADONLINE and RADLOG tables. I > have just started testing your product for which we have purchased a > license. Any help would be appreciated. I have attached the radius.cfg > that I am using as well. > > Thank You, > Oliver Stockhammer > The Internet Channel > 180 Varick St. NY NY 10023 USA > [EMAIL PROTECTED] > > > [ Attachment (text/plain): "radius.cfg" 4599 bytes > Character set: US-ASCII > Radiator conf file > Encoded with "base64" ] >-- End of excerpt from Oliver Stockhammer -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, 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, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) Radiator errors
Hello, I am running radpwtst and everytime I do so I get an error. I am putting all accounting into a mysql database and authenticating off of a flat file. Here is one of the repeditive errors being sent to STDOUT. DBD::mysql::db do failed: You have an error in your SQL syntax near '203.63.154.1' and NASPORT=1234 ')' at line 2 at /usr/local/lib/perl5/site_perl/5.005/Radius/SqlDb.pm line 189. Thu May 13 17:54:38 1999: ERR: do failed for 'insert into RADLOG (TIME_STAMP, PRIORITY, MESSAGE) values (926632478, 4, 'do query is: delete from RADONLINE where NASIDENTIFIER='203.63.154.1' and NASPORT=1234 ')': You have an error in your SQL syntax near '203.63.154.1' and NASPORT=1234 ')' at line 2 DBD::mysql::db do failed: You have an error in your SQL syntax near '203.63.154.1' and NASPORT=1234 ')' at line 2 at /usr/local/lib/perl5/site_perl/5.005/Radius/SqlDb.pm line 189. Thu May 13 17:54:38 1999: ERR: do failed for 'insert into RADLOG (TIME_STAMP, PRIORITY, MESSAGE) values (926632478, 4, 'do query is: delete from RADONLINE where NASIDENTIFIER='203.63.154.1' and NASPORT=1234 ')': You have an error in your SQL syntax near '203.63.154.1' and NASPORT=1234 ')' at line 2 It is logging properly to the ACCOUNTING, RADONLINE and RADLOG tables. I have just started testing your product for which we have purchased a license. Any help would be appreciated. I have attached the radius.cfg that I am using as well. Thank You, Oliver Stockhammer The Internet Channel 180 Varick St. NY NY 10023 USA [EMAIL PROTECTED] # radius.cfg # # This is a very simple radius.cfg that you can use to get started. # only the most important parameters are set here. The full set # of parameters can be seen in radius.cfg in the top of the distribution tree. # # As it stands, it will authenticate a single client and a # single realm from a flat file # database, and save the accounting info to a single details file. # # Author: Mike McCauley ([EMAIL PROTECTED]) # Copyright (C) 1997 Open System Consultants # $Id: radius.cfg,v 1.3 1999/01/28 05:13:52 mikem Exp $ LogStdout # Set this to the directory where your logfile and details file are to go LogDir /var/log/radius # Set this to the database directory. It should contain these files: # users The user database # dictionary The dictionary for your NAS DbDir /usr/local/etc/radiusDB ## Added for USR shite## #SnmpgetProg/usr/bin/snmpget # This clause defines a single client to listen to Secret crap@ss NasType TotalControl # For testing: this allows us to honour requests from radpwtst # on the same host. Secret mysecret DupInterval 0 # This clause handles all users from all realms by looking them up # in the users file at /usr/local/etc/raddb/users # # # # The filename defaults to %D/users # Filename %D/users # # # Log accounting to the detail file in LogDir # AcctLogFileName %L/detail # RewriteUsername s/^([^@]+).*/$1/ AuthByPolicyContinueAlways DBSourcedbi:mysql:Radiator DBUsername root DBAuth crap@ss # an empty AuthSelect turns off auth AuthSelect AccountingTable ACCOUNTING AcctColumnDef USERNAME,User-Name AcctColumnDef TIME_STAMP,Timestamp,integer AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer AcctColumnDef ACCTSESSIONID,Acct-Session-Id AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause AcctColumnDef NASIDENTIFIER,NAS-Identifier AcctColumnDef NASIDENTIFIER,NAS-IP-Address AcctColumnDef NASPORT,NAS-Port,integer # The filename defaults to %D/users Filename %D/users Filename %D/users1 DBSourcedbi:mysql:Radiator DBUsername root DBAuth crap@ss # AddQuery insert into . # DeleteQuery delete from . # ClearNasQuery delete from ... # CountQuery select DBSourcedbi:mysql:Radiator DBUsername root DBAuth crap@ss