OK, now you are REALLY da man!
PS, I look forward to this doc and will gladly add if needed.
.vp
>Ahh yes, that problem arose for one of my customers using the program.
>I've written a user guide which outlines the need to do that, but it
>has sensitive customer data in it. I'll see if I can scrub the doc and
>send it out for inclusion in the next release.
>
>
>On 9/20/06, Vadim Pushkin <[EMAIL PROTECTED]> wrote:
> > Hi Clayton;
> >
> > 1. The attached logtotate.php script seems to have worked, but so was
>the
> > one before posted by Ian. The problem that I was having was due to user
> > error, not application error. :-( I realized that when you are doing a
> > search using old logs that you need to specify the date ranges to match
>the
> > logs you are browsing. I took a look at the SQL statement that the
>search
> > was using, changed it to match the dates for the log I chose, and voila,
>I
> > had data.
> >
> > 2. Is there any way, when choosing an old log, to automatically alter
>the
> > SQL statement in the GUI to peform a search using the same date ranges
>as
> > the log itself? I.e., when searching logs20060704, then also limit the
> > search to dates 20060704? Like this "WHERE datetime > '2006-07-04"?
> >
> > Many thanks to Clayton, Ian, Matt and all others for the great help!
> >
> > .vp
> >
> >
> > >
> > >OK, this is diff from what I am running and from what Ian posted, but I
> > >will
> > >run this and let you know my results tomorrow.'
> > >
> > >Thanks!
> > >
> > >.vp
> > >
> > > >Hmmm...
> > > >Not sure, try this script:
> > > >
> > > >#!/usr/bin/php
> > >>
> > >>[...SNIP...]
> > > >
> > > >
> > > >On 9/19/06, Vadim Pushkin <[EMAIL PROTECTED]> wrote:
> > > >>but both logs20060917 and logs20060917 are *not* older than 2. If
>I
> > >set
> > > >>this to 90, then I will have to wait 90 days to encounter this bug.
> > > >>
> > > >>It keeps the proper tablename in the pulldown, the tables exist, and
> > > >>contain
> > > >>data, but I am unable to search them using the GUI.
> > > >>
> > > >>.vp
> > > >>
> > > >> >Well that's why, if you set retention to 2, it will delete
>anything
> > > >>older.
> > > >> >Try setting to 90
> > > >> >
> > > >> >
> > > >> >On 9/19/06, Vadim Pushkin <[EMAIL PROTECTED]> wrote:
> > > >> >>HI Clayton;
> > > >> >>
> > > >> >>Welcome back!
> > > >> >>
> > > >> >>I am still having one issue, I am able to see data when using the
> > > >>pulldown
> > > >> >>for either:
> > > >> >>
> > > >> >>logs
> > > >> >>all_logs
> > > >> >>logs20060919 (today)
> > > >> >>
> > > >> >>I am *unable* to see any data for either:
> > > >> >>
> > > >> >>logs20060917 (two days ago)
> > > >> >>logs20060918 (yesterday)
> > > >> >>
> > > >> >>Incidentally, all_logs and logs contain only what is contained in
> > > >>todays
> > > >> >>(logs20060919) logs.
> > > >> >>
> > > >> >>So, while the logrotate is better, and I am able to see a login
> > >screen
> > > >>and
> > > >> >>login sucessfully, I am no longer able to see any data that is
>older
> > > >>than
> > > >> >>todays date.
> > > >> >>
> > > >> >>Lastly, I have my logrotate set to 2 (reasoning why I am only
>seeing
> > > >>two
> > > >> >>days worth of options in my pulldown) within my config.php as:
> > > >> >>
> > > >> >>define('LOGROTATERETENTION', 2);
> > > >> >>
> > > >> >>Thanks in advance all,
> > > >> >>
> > > >> >>.vp
> > > >> >>
> > > >> >> >I've confirmed that the logrotate fixes are working as well.
> > > >> >> >
> > > >> >> >
> > > >> >> >On 8/31/06, Vadim Pushkin <[EMAIL PROTECTED]> wrote:
> > > >> >> >>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],
> > > >>[email protected]
> > > >> >> >> >> >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: <[email protected]>
> > > >> >> >> >> > >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
> >
> >
> >
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Php-syslog-ng-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
