SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Wizard lorenw's Avatar
    Join Date
    Feb 2005
    Location
    was rainy Oregon now sunny Florida
    Posts
    1,100
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Having a propblem with a mysql bug

    I am (very rarely) getting the number 34560000 in my database so I found,
    http://bugs.mysql.com/bug.php?id=27023

    The column is for session time and NULL=yes DeFAULT=NULL.

    The session start mysql script puts a 0 into the session time column. (I didn't set up the database).

    Other columns have a default value and that number does not appear in any of those columns.

    I'm thinking that if it was set to a default value of 0 that number would no longer appear.

    I'm asking if this would be a fix?

    The number only gets inserted possibly once a month with thousands of users so it would be months before I would know if it was a fix.

    Thanks
    Loren
    What I lack in acuracy I make up for in misteaks

  2. #2
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,027
    Mentioned
    103 Post(s)
    Tagged
    0 Thread(s)
    Can you show a CREATE TABLE for that table?
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  3. #3
    SitePoint Wizard lorenw's Avatar
    Join Date
    Feb 2005
    Location
    was rainy Oregon now sunny Florida
    Posts
    1,100
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Sure, it is in freeradius and AcctSessionTime now defaults to 0. I made the change but, like I say it is very intermittant and will be months to verify this fixed the problem.

    Thanks for looking
    Code:
    CREATE TABLE `radacct` (
      `RadAcctId` bigint(21) NOT NULL auto_increment,
      `AcctSessionId` varchar(32) NOT NULL default '',
      `AcctUniqueId` varchar(32) NOT NULL default '',
      `UserName` varchar(64) NOT NULL default '',
      `Realm` varchar(64) default '',
      `NASIPAddress` varchar(15) NOT NULL default '',
      `NASPortId` varchar(15) default NULL,
      `NASPortType` varchar(32) default NULL,
      `AcctStartTime` datetime NOT NULL default '0000-00-00 00:00:00',
      `AcctStopTime` datetime NOT NULL default '0000-00-00 00:00:00',
      `AcctSessionTime` int(12) NOT NULL default '0',
      `AcctAuthentic` varchar(32) default NULL,
      `ConnectInfo_start` varchar(50) default NULL,
      `ConnectInfo_stop` varchar(50) default NULL,
      `AcctInputOctets` bigint(12) default NULL,
      `AcctOutputOctets` bigint(12) default NULL,
      `CalledStationId` varchar(50) NOT NULL default '',
      `CallingStationId` varchar(50) NOT NULL default '',
      `AcctTerminateCause` varchar(32) NOT NULL default '',
      `ServiceType` varchar(32) default NULL,
      `FramedProtocol` varchar(32) default NULL,
      `FramedIPAddress` varchar(15) NOT NULL default '',
      `AcctStartDelay` int(12) default NULL,
      `AcctStopDelay` int(12) default NULL,
      PRIMARY KEY  (`RadAcctId`),
      KEY `UserName` (`UserName`),
      KEY `FramedIPAddress` (`FramedIPAddress`),
      KEY `AcctSessionId` (`AcctSessionId`),
      KEY `AcctUniqueId` (`AcctUniqueId`),
      KEY `AcctStartTime` (`AcctStartTime`),
      KEY `AcctStopTime` (`AcctStopTime`),
      KEY `NASIPAddress` (`NASIPAddress`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26790 ;
    What I lack in acuracy I make up for in misteaks


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •