Hello Mikael;
Here are my current issues.
1. Logrotate (the one that comes stock because I was unable to work out
several bugs with the "modified" version) does not rotate to the correct
number of days. My LOGROTATE entry has a 2. Here is what my syslog DB has
in terms of tables as of right now:
mysql> show tables;
+------------------
| Tables_in_syslog
+-----------------
| actions
| all_logs
| cemdb
| logs
| logs20060717
| logs20060718
| logs20060719
| search_cache
| user_access
| users
+-----------------
10 rows in set (0.00 sec)
2. This AM, I had to edit all_logs.MRG, had to remove logs20060716, which
was no longer available, presumably dropped as it should have been, but why
not logs20060717 as well?
PS I am running logrotate at 00:15 HRS and without the removal of
logs20060716, the front-end would not work.
The below is as of right now (mid-day).
[root /]# cat /var/lib/mysql/syslog/all_logs.MRG
logs
logs20060717
logs20060718
logs20060719
3. Within mysql, tablename "search_cache" shows hostnames in "logs" for
srv-www-001, this was one of the "canned" hostnames that Clayton provided as
a test. They *do not* live in the logs table, though they *may* live under
all_logs, so why are they still there? And how do I remove them?
With regads to MERGE tables, what version of MySql are you running? I
*believe* that this feature will not work on earlier version of MySql.
I hope someone, hopefully someone with far more ability to do something
about this than I, will find this info useful :)
.vp
>From: "Freeman, Michael" <mfreeman@xxxxxxxxxxxx>
>Did you get anywhere with logrotate.php?
>Can someone please explain to me what is going on with MERGE tables in
>2.9.2?
>-----Original Message-----
>From: php-syslog-ng-support-bounces@xxxxxxxxxxxxxxxxxxxxx
>[mailto:php-syslog-ng-support-bounces@xxxxxxxxxxxxxxxxxxxxx] On Behalf
>Of Vadim Pushkin
>Sent: Saturday, July 15, 2006 2:00 PM
>To: php-syslog-ng-support@xxxxxxxxxxxxxxxxxxxxx
>Subject: [Php-syslog-ng-support] LogRotate (V2.9.2 tested)
>
>Hello All;
>
>I've downloaded and am testing the latest (2.9.2) and have set LOGROTATE
>to
>2 within my config.php file. So far, I now have 3 days worth of data,
>when I should have just 2.
>
>I have *not* re-created my SQL db, and assuming this does not matter, am
>I the only one with this problem?
>
>Thanks,
>
>.vp
-------------------------------------------------------------------------
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
|
