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
