Hello.  We have started keeping our online.db in sql with mysql.  I am
seeing some strange behavior.  My mysql process hang after an hour or so.
When I check the tables, here is what isamchk returns...

Checking ISAM file: RADONLINE.ISM
Data records:     138   Deleted blocks:       0
- check file-size
- check delete-chain
- check index reference
- check data record references index: 1
isamchk: error: Key in wrong position at page 5120
ISAM-table 'RADONLINE.ISM' is corrupted
Fix it using switch "-r" or "-o"

Well, I fix, remove and remake the db, and here it comes again.  The only
thing is that I also get this error in my logfile for radiator...

Wed Aug 11 13:46:16 1999: ERR: do failed for 'insert into RADONLINE 
(USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, 
FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('admin', '206.230.70.216', 
, '080039EF', 934393531, '', '', 'Administrative-User')': 
You have an error in your SQL syntax near ' '080039EF', 934393531, '', '', 
'Administrative-User')' at line 1

I am not sure if the 2 problems are related, but can any one offer some
insite?
I am running redhat 6.0 with the rpm from mysql.com.  Radiator is 2.14.1.
Thanks in advance.



Kelly Prescott, Network Administrator
West Central Ohio Internet Link, Ltd.
Lima, Ohio U.S.A.
[EMAIL PROTECTED]

Serving Lima and the rest of West Central Ohio with full Internet Access

Reply via email to