MonitorWare Knowledge Base

Hi Andre,

I am facing problem in phplogcon-2.1.4 installation.
I have configured rsyslog-1.19.6 on RHEL with mysql support. and i m able to forward logs from /var/log/messages to mysql database.
When i configured phplogcon with belolw database details and once i finished the installation and try to see index.php then i m keep getting "page can not be display."

Pls see my config.php details:

$CFG['Sources']['Source1']['ID'] = 'Source1';^M
$CFG['Sources']['Source1']['Name'] = 'My Syslog Source';^M
$CFG['Sources']['Source1']['SourceType'] = 2;^M
$CFG['Sources']['Source1']['DBTableType'] = 'monitorware';^M
$CFG['Sources']['Source1']['DBType'] = '0';^M
$CFG['Sources']['Source1']['DBServer'] = 'localhost';^M
$CFG['Sources']['Source1']['DBName'] = 'my DB name';^M
$CFG['Sources']['Source1']['DBUser'] = 'my DB user';^M
$CFG['Sources']['Source1']['DBPassword'] = '********';^M
$CFG['Sources']['Source1']['DBTableName'] = 'my DB tablename';^M

// ---

and i have configured my php with mysql.

Note:i am able to see /var/log/messages with phplogcon but not able to see logs from database...

pls helppppppp.....

thanks and Regards,
Karen

Hi Andre,

Sorry for late reply as I was busy in other stuff.

Hey now i tried phplogcon-2.3.0.tar.gz and again i m facing the same problem.

Once i finished the installation it redirected to index.php and i got "Page can not be display" message. (using Mysql support)

I am able to open "search.php" page. but i cant understand whts the problem with index.php

Is there any setting in httpd.conf for phplogcon??

U know if i mentioned below alises in httpd.conf i got "you are not authorised to view this page" message for "phplogcon" folder itself.

# Directives to allow phplogcon
Alias /phplogcon "/usr/local/apache2/htdocs/phplogcon"


Pls help..I need to get it done asap.

Thanks,

Karen

Hi Andre,

I tried phplogcon-2.3.6 and still facing the same problem....

getting "page can not be dispaly" for index.php

i m using rsyslog-3.19.4 with mysql support on RHEL 5.

if i select Database (PDO) the i get " no syslog data found" message on index.php..!!!

and there is a data in my database.

My source file is like this for latest version:
$CFG['DefaultSourceID'] = 'Source1';

$CFG['Sources']['Source1']['ID'] = 'Source1';
$CFG['Sources']['Source1']['Name'] = 'My Syslog Source';
$CFG['Sources']['Source1']['ViewID'] = 'SYSLOG';
$CFG['Sources']['Source1']['SourceType'] = SOURCE_DB;
$CFG['Sources']['Source1']['DBTableType'] = 'monitorware';
$CFG['Sources']['Source1']['DBServer'] = 'server ip';
$CFG['Sources']['Source1']['DBName'] = 'My DB name;
$CFG['Sources']['Source1']['DBUser'] = 'MY DB USer';
$CFG['Sources']['Source1']['DBPassword'] = '***************';
$CFG['Sources']['Source1']['DBTableName'] = 'my table name;
$CFG['Sources']['Source1']['DBEnableRowCounting'] = false;

// ---


Pls help....


Regards,

karen

If I remember correctly, there is a config settings that permits internet explorer to let you see the real error. It is something along the lines of disabling "friendly" error messages (someone seems to assume that a friendly message is one that does not tell you anything ).

In any case, I'd recommend to give it a try with a different browser, IN CASE you actually use MSIE.

Rainer

Hi Guys,

I have configured mysql databases on the same server. everything is on the same server. And there is no any firewall. You know as i informed Rainer i tried rsyslog + phplogcon 2 months back with rsyslog V1 and phplogcon V1in test environment and tht time it worked fine..but now i really dont understand wht is the issue. Ya one things is that i m collecting lot of data from all devices. so might be i/o to database might be slow.
As you suggest about different browser..i will definitly try tht and will let you know tomorrow. Today i m planning to work on mail alert for rsyslog.

Thanks,
Karen

hi,

I tried with firefox browser and i got blank page without any error for http://<my server ip>/phplogcon/index.php
at the botom of the browser its showing "Done". I can access search.php but in that if i access "show events" in that then it again redirect to index.php and getting BLANK page in firefox.

Any suggestion??

Thanks,

Karen

Hi Andre,

I tried that but still no luck..getting BLANK page without error page. And getting below message in error_log of apache.

"script '/usr/local/apache/htdocs/phplogcon/index.php' not found or unable to stat"

Regards,

Karen

Heyyy,

there is a good news...My phplogcon now communicating with mysql. I have reconfigured php with pdo-mysql and its now working with PDO-database option..
But yes its working veryyyyyyy slow..so now need to work on performnace tunning.. !!!


Regards,
Karen

Hi Andre,

Now Phplogcon is working fine. I have increased the memory so the performance is also satisfactory.

One silly question ...i couldnt find any way to search the logs by specific date. So how to do that ?

And one more thing..in advance search at left hand side there are below 2 modes :

All time
Time range
Time x since today

i couldnt get any useful output by any of this mode..how to use it?

Thanks,

Karen