Great news Ian. Are you also able to see data within the various logs with a date?
Regards, .vp >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
