As the RADONLINE databases is ever changing you can just whack it 'delete
from RADONLINE;'
and let it start over. Within an hour or two (Once everyone on before you
reset it has logged off) you'll
be back in sync.
I had errors like that once when trying to import mysql update.log files
from a primary to a secondary server.
If there are entries in there, that are beleived to be gone already (Things
got really out of whack somehow), the UPDATE
statements can cause an error, duplicate key value or something like that.
Deleting all records cures that.
If not that, you should be able to see the exact errors in your mysql
logfile 'tail -f /usr/local/mysql/data/logfile'
and watch the exact query (After all radiators variables have been processed
and mysql has been called) and hopefully
see what the error is more specifically. That and running your server in
trace level 4 and watching there, what queries radiator is sending to mysql
'tail -f /var/log/radius/log'
----- Original Message -----
From: "Andrew P. Kaplan" <[EMAIL PROTECTED]>
To: "Radiator" <[EMAIL PROTECTED]>
Sent: Thursday, November 02, 2000 9:07 AM
Subject: (RADIATOR) radwho stopped working after changing IP addresses
> I have a pressing issue. I turned off the Global Crossing "T" this past
> Saturday. The IP block was 206.165.153.x. The main IP address on my
Radiator
> server was 206.165.153.185, however there were other working IP's. With my
> NAS server pointed at the new IP address. Ever since then radwho stopped
> working. I can still make a connection to the website
> http://mozart.cshore.com/cgi-bin/radwho.cgi. But it doesn't display any
> current data. I couldn't find anything in mysql that was referring to a
> particular IP address.
>
> I did see an error message on the screen:
>
> "You have an error in your SQL syntax . . at
> usr/local/lib/site_perl/Radius/SqlDb.pm line 228"
>
> I saw nothing strange on that line.
>
> I tried stopping mysql, touching the mysql.log file and restarting. Radwho
> will then work, but for only one entry. It will only list a single new
entry
> and then stop displaying new logins.
>
> Do you have any ideas as to how I could fix it.
>
> Andrew P. Kaplan, CNE, MCSE+Internet, MCT, CCNA, CCDA
> CyberShore, Inc. -- Premium Internet Services -- http://www.cshore.com
>
>
> "The ultimate measure of a man is not where he stands in moments of
comfort,
> but where he stands at times of challenge and controversy."
> -Martin Luther King, Jr.
>
>
> ===
> 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.
