Login to mysql and type:
mysql> use syslog;
mysql> show tables;
Then, for each of the tables described, except for the ones created with
logrotate, i.e. logs20060828, type in:
mysql> desc actions;
Send me the output, I will try to help with the proper commands to modify
your existing table.
That makes sense. Only problem is I've got 6 months worth of log data
that we want to keep online. I'll discuss with my folks about if we
can archive that and start fresh. If not I'll need to look at
manually making the database changes. I'm not MySQL expert, but we
might have some somewhere :)
I just installed denyhosts which read /var/log/auth.log but i have no
such thing ... how can i rig syslog to put wrong login on ssh to that log ?
Thanks
-
Using Tomcat but need to do more? Need to support web services, secur
Shane,
You need to install a new copy as a standalone install.
1. Move your original html directory to html.orig
2. Backup your current database: mysqldump syslog > syslog.orig
3. Extract the new install to html and point your browser to
http://servername/install
If somethhing goes wrong or you
Vadim,
The install looks slick! I did what you suggested, and ran the
install script. But it errors out during the table creation. I
didn't realize the format of the database had changed? I was hoping
the new interface could just point to my old database?
or were you saying I should just use
Hi Jeff,
If you're using the latest version, then stick with the logrotate
included in the package -- or use the one that was just posted an hour
or so ago.
I'm on PTO this Friday and plan to spend the day looking into the
logrotate issues that folks have been talking about.
I'll likely be postin
Clayton,Thanks. I'll try that during a maintenance window. I am a little skeptical, as this started happening after I upgraded, and only on the logs table. I currently rotate the tables once a month, and none of the other tables are being corrupted. I have attached the external PHP script which
Hi Jeff,
I've never encountered this, but it sounds like maybe a disk problem?
have you tried running fsck?
I could be wrong here, just guessing :-)
On 8/30/06, Jeffrey Chandler <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I used to be running php-syslog-ng 2.8c and have upgraded my system to
> 2.9.2.
Hello,
I used to be running php-syslog-ng 2.8c and have upgraded my system to
2.9.2. Since upgrading to 2.9.x through the installer, on a sporadic
basis, I recieve the following error when trying to access logs or
graphs:
Query failed: Got error 127 from table handler
To fix the problem, I run
You also may want to add:
$basePath = dirname( __FILE__ );
include_once "$basePath/../includes/common_funcs.php";
include_once "$basePath/../config/config.php";
to the file, instead of hardcoding a path like this:
$APP_ROOT = '/var/www/html/syslog';
include_once "$APP_ROOT/includes/common_funcs.p
Thanks Matt;
I've just replaced the original with yours. I will report my finding in the
next 3 days. The one thing that I've noticed with both the original and
yours is it's inablity to run more than once per day, if you do the
all_logs.MRG gets wiped out and complains about logs20060830 alr
-Original Message-
Sent: 30 August 2006 15:17
Subject: RE: [Php-syslog-ng-support] Logrotate.php
Hi Matt;
Would you mind posting your modfied version as an attachment?
__
This email has been scanned by the MessageLab
Hi Matt;
Would you mind posting your modfied version as an attachment?
Thank you,
.vp
>Making the change so that table list is recreated after table drop for the
>new merge table has sorted it. Have had no issues since posting the
>changes.
>
>Matt
>
>-Original Message-
>From: "Vadim
>From what I can see - this is not the same problem as earlier.
This is confirmed working (for me) on v2.8
Matt
-Original Message-
From: Shane Presley [mailto:[EMAIL PROTECTED]
Sent: 29 August 2006 14:27
To: Vadim Pushkin
Cc: Matt Westby; php-syslog-ng-support@lists.sourceforge.net
Sub
14 matches
Mail list logo
