I incorporated MattW's fix into logrotate.php which you can find as an attachment here:
http://code.google.com/p/php-syslog-ng/issues/list See item ID 6. I've used it for a week and it fixes the GUI login problem and deletes the old tables as specified by the retention config setting. On 8/29/06, Vadim Pushkin <[EMAIL PROTECTED]> wrote: > > Help! > > Has anyone been able to fix or test Matts new logrotate? So far, this is > the only bug, albeit a big one, in this entire package! > > Thank you, > > .vp > > > >From: "Vadim Pushkin" <[EMAIL PROTECTED]> > >To: [EMAIL PROTECTED], php-syslog-ng-support@lists.sourceforge.net > >Subject: Re: [Php-syslog-ng-support] Logrotate.php > > >Hi Matt; > > > >Have you been able to determine if your changes worked? > > > >1. Were you able to sucessfully rotate logs? > >2. Were you able to keep n number of days worth of logs within the > >all_logs > >table? > > > >Thank you, > > > >.vp > > > > > > >From: "Matt Westby" <[EMAIL PROTECTED]> > > >To: <php-syslog-ng-support@lists.sourceforge.net> > > >Subject: Re: [Php-syslog-ng-support] Logrotate.php > > >Date: Thu, 17 Aug 2006 12:40:07 +0100 > > > > >... The script therefore becomes > > > > > > > > >-- snip -- > > > > >-- snip -- > > > > > >Not tested it yet ... Waiting for tonight's logrotate. > > > > > >Matt > > > > > >-----Original Message----- > > >From: Vadim Pushkin [mailto: > > >Sent: 17 August 2006 12:33 > > >To: Matt Westby > > >Subject: RE: [Php-syslog-ng-support] Logrotate.php > > > > > >Did you fix the script? I am suffering badly from this bug right now... > > > > > >.vp > > > > > > > > > > > > > >Have just implemented the logretention settings withing logrotate after > > > > > > >filling up the drive space rather quickly. > > > > > > > >Looking at the list archive - it seems that others have come across the > > > > > > >issue that I am now seeing. > > > > > > > >After the logrotate in the evening - the Web GUI no longer works with a > > > > > > >Query failed: Can't find file: 'all_logs' (errno: 2) > > > > > > > >This is because we have created the merged all_logs table using an > > > >outdated list of available log tables. > > > > > > > >The current logic is: > > > >Get list of all tables if creating merge tables or dropping table Are > > > >we looking to drop a table? Yes : Search list for old table & drop it > > > >Do we want to create merge table? Yes : create merge using list we have > > > > > > >got. > > > > > > > >The list includes the table we just dropped - hence the error > > > > > > > >Change the script to > > > > > > > >Are we looking to drop a table? Yes : get a list of tables. Search list > > > > > > >for old table & drop it Do we want to create merge table? Yes : get a > > > >list of tables. Create merge. > > > > > > > >Maybe a FLUSHTABLES is needed in there -- but not sure > > > > > > > >Matt > > > > > > > >Matt Westby | Senior Technical Analyst > > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Php-syslog-ng-support mailing list > Php-syslog-ng-support@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Php-syslog-ng-support mailing list Php-syslog-ng-support@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
