MonitorWare Knowledge Base

Hi,

I've just tried installing phpLogCon 2.1.1 to work with a MySQL backend database and just can't get it work, always showing the following error:

No syslog records found. - Error Details:
Unknown or unhandeled error occured.

The apache errorlogs make plenty of complaints and I also noticed there doesn't seem to be any way to have user accounts in the system?

I was able to get a direct read of my /var/log/messages file working (when making it 644 permission) but I'm more interested in it reading my MySQL log which is on a remote server.

Michael.

Hi,

I change config.php
$CFG['Sources'][Source1]['ID'] = 'Source1';
$CFG['Sources'][Source1]['Name'] = 'Log_srvherb01';
$CFG['Sources'][Source1]['SourceType'] = 2;
$CFG['Sources'][Source1]['DBTableType'] = 'winsyslog';
$CFG['Sources'][Source1]['DBType'] = '0';
$CFG['Sources'][Source1]['DBServer'] = 'localhost';
$CFG['Sources'][Source1]['DBName'] = 'Syslog';
$CFG['Sources'][Source1]['DBUser'] = 'rsyslog';
$CFG['Sources'][Source1]['DBPassword'] = '*******';
$CFG['Sources'][Source1]['DBTableName'] = 'SystemEvents';

and now it's ok but in error log but I have this message :

[..] [error] [...] PHP Notice: Use of undefined constant Source1 - assumed 'Source1' in /usr/share/phplogcon2/config.php on line 111, referer: https://.../phplogcon/?&uid=20649&filte ... rch=Search

Hi,

fredolido wrote:Hi,

I change config.php
$CFG['Sources'][Source1]['ID'] = 'Source1';
$CFG['Sources'][Source1]['Name'] = 'Log_srvherb01';
$CFG['Sources'][Source1]['SourceType'] = 2;
$CFG['Sources'][Source1]['DBTableType'] = 'winsyslog';
$CFG['Sources'][Source1]['DBType'] = '0';
$CFG['Sources'][Source1]['DBServer'] = 'localhost';
$CFG['Sources'][Source1]['DBName'] = 'Syslog';
$CFG['Sources'][Source1]['DBUser'] = 'rsyslog';
$CFG['Sources'][Source1]['DBPassword'] = '*******';
$CFG['Sources'][Source1]['DBTableName'] = 'SystemEvents';

I changed the DBTableType to winsyslog (from syslog) and I saw the results I was looking for. Thanks for this.

fredolido wrote:
and now it's ok but in error log but I have this message :

[..] [error] [...] PHP Notice: Use of undefined constant Source1 - assumed 'Source1' in /usr/share/phplogcon2/config.php on line 111, referer: https://.../phplogcon/?&uid=20649&filte ... rch=Search

Yes I get that message too, but it doesn't seem to harm anything.

Michael.

Hi all,

this are notices which will not be shown if you set "$CFG['MiscShowDebugMsg'] = 0;" in your config.php.
These notices are helpful for the development of phplogcon. But you can also remove these notices if you changed all "$CFG['Sources'][Source1]" to "$CFG['Sources']['Source1']".

regards,
Andre