(RADIATOR) MySQL corruption

[Nick Rogness]

On Thu, 31 Jan 2002, Hugh Irvine wrote:

> 
> Hello Nick -
> 
> This is the first time I have heard of such a thing. 

	Take a look:

////// First on DB server ////////////////

mngmt1# myisamchk -c ACCOUNTING.MYI
Checking MyISAM file: ACCOUNTING.MYI
Data records:      48   Deleted blocks:       0
- check file-size
- check key delete-chain
- check record delete-chain
- check index reference
- check data record references index: 1


////// Test Radiator server ////////////////

# radpwtst -s $host -user nick -password nick -secret secret
sending Access-Request...
OK
sending Accounting-Request Start...
OK
sending Accounting-Request Stop...
OK


////// Now look at DB Server again ////////////////

mngmt1# myisamchk -c ACCOUNTING.MYI
Checking MyISAM file: ACCOUNTING.MYI
Data records:      50   Deleted blocks:       0
- check file-size
myisamchk: error: Size of datafile is: 7776              Should be: 8100
- check key delete-chain
- check record delete-chain
- check index reference
- check data record references index: 1
myisamchk: error: Found key at page 1024 that points to record outside
datafile
MyISAM-table 'ACCOUNTING.MYI' is corrupted
Fix it using switch "-r" or "-o"



> I would suspect that there is a problem with either the version of
> MySQL and/or the version of DBD-mysql. You should probably check the
> MySQL web site and also do a google search (www.google.com).

	I will do some research...

> 
> regards
> 
> Hugh
> 
> 
> On Thu, 31 Jan 2002 09:29, Nick Rogness wrote:
> > It appears after every modification performed by Radiator to a MySQL DB,
> > corrupts the tables (RADONLINE and ACCOUNTING).  How do I resolve
> > this without running a cron job to repair it every X minutes.  Run a
> > different DB like postgreSQL
> >
> > Using AuthBy SQL (for Accounting) and SessionDB's (for RADONLINE).
> >
> > Perl DBI version is 1.20
> > Perl DBD-mysql version is 2.1004
> > perl version is v5.6.1 built for i386-freebsd
> > Radiator Version is 2.18.4
> >
> > All on FreeBSD 4.4-STABLE.
> >
> > Nick Rogness <nick at rogness.net>
> >  - Don't mind me...I'm just sniffing your packets
> >
> > ===
> > Archive at http://www.open.com.au/archives/radiator/
> > Announcements on radiator-announce at open.com.au
> > To unsubscribe, email 'majordomo at open.com.au' with
> > 'unsubscribe radiator' in the body of the message.
> 
> -- 
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
> -
> Nets: internetwork inventory and management - graphical, extensible,
> flexible with hardware, software, platform and database independence.
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
> 

Nick Rogness <nick at rogness.net>
 - Don't mind me...I'm just sniffing your packets

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.