2016-07-26 - Re: cant find file mtotaccttmp

Header Data

From: Hotspotuser <jo***s@algardata.pt>
Message Hash: 7b57834f5aaf740bc916aa7dd36c5b82c827b0562ece3485d35fc9a480f00a60
Message ID: <4e37326d-8ec2-4586-986f-dc18b8390d6f@grasehotspot.org>
Reply To: <f2d78abc52b406564aa850626cb7e5cd.squirrel@www.pc-networking-services.com>
UTC Datetime: 2016-07-26 10:08:26 UTC
Raw Date: Tue, 26 Jul 2016 10:08:26 -0700

Raw message 

That table (mtotaccttmp) is used for compacting the radius accounting 
information, its used by cron.php to compact database information and then 
when finished should be empty. its a temporary table, hence the 
"mtotaccttmp" name. I would not worry about this... you can drop it and 
rebuild it with:

CREATE TABLE `mtotaccttmp` (
  `MTotAcctId` bigint(21) NOT NULL AUTO_INCREMENT,
  `UserName` varchar(64) NOT NULL DEFAULT '',
  `AcctDate` date NOT NULL DEFAULT '0000-00-00',
  `ConnNum` bigint(12) DEFAULT NULL,
  `ConnTotDuration` bigint(12) DEFAULT NULL,
  `ConnMaxDuration` bigint(12) DEFAULT NULL,
  `ConnMinDuration` bigint(12) DEFAULT NULL,
  `InputOctets` bigint(12) DEFAULT NULL,
  `OutputOctets` bigint(12) DEFAULT NULL,
  `NASIPAddress` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`MTotAcctId`),
  KEY `UserName` (`UserName`),
  KEY `AcctDate` (`AcctDate`),
  KEY `UserOnDate` (`UserName`,`AcctDate`),
  KEY `NASIPAddress` (`NASIPAddress`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

terça-feira, 26 de Julho de 2016 às 01:45:10 UTC+1, christopher escreveu:
>
> Hello, 
>
> I see late last year that this error was coming up. 
>
> I now have the exact same thing happening.  I am using the latest debian 
> stable with all security updates applied. 
>
> I used phpmyadmin to check the radius database and the table is listed as 
> being there but it gives an error: 
>
> #1017 cant find file mtotaccttmp errno: 2 
>
> The mysql version being used is 5.5.50 under debian's versioning. 
>
> Also repairing of the database fails as it claims that the same file can 
> not be found. 
>
> Regards, 
>
> Christopher. 
>
>

Thread