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

• Custom phpLogCon configuration?
• Maintenance Contract?
• Installation support?

Hi karen,

I would recommend to use the latest stable version 2.1.6 or if you want to test the devel Version 2.3.3 - both available for download here:
http://www.phplogcon.org/downloads

Regarding the problem, it's very strange that you get a "page not displayed" error when using a datasource. If reading the source would fail, you should see a propper error message. Can you post a screenshot or somnething like this?

best regards,
Andre Lorbach

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 Karen,

we are at Version 2.3.6 now, I recommend you try this Version first.
( See here for download: http://www.phplogcon.org/downloads )

From what you describe it looks like that something goes wrong while connecting to the mysql database.
The newer Version will have better database performance in case you have a very large database.

best regards,
Andre Lorbach

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

I think the database connection is timing out for some reason, or hanging causing the default php script timeout to hit phpLogCon. Firefox and Opera will show you a script timeout error, but Internet Explorer for example will just show you a "page can not be displayed" error.

So I think there is something wrong in the DB configuration, or the connectivity to the database server. Your configurations looks fine, so my guess is there is something wrong with the connectivity to the mysql server.

Is the database server the same machine as the webserver?
If not, is mysql running on the external IP Address (default is 127.0.0.1 only)?
Is there any Firewall which could block access to the MYSQL Server?

--
regards,
Andre

PS: To avoid such problems, we will add an option to probe the syslog source during installation with detailed error analyzis. This will make it easier to find and solve connection problems with databases for example.

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

Sounds like some php warning which occured and isn't visible because of the error reporting settings in php.
Please edit yoru config.php and change the Option MiscShowDebugMsg to 1 like this:

Code: Select all

$CFG['MiscShowDebugMsg'] = 1;            // if enabled, you will get additional output on certain places


You should then see warnings and notices from php as well. This should help.

best regards,
Andre Lorbach

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

umm ... this does not look like the index.php script has been placed into the phplogcon folder.
Is it possible that your upload was incomplete, or files are not readable by the webserver?

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

You can use the "Time range" option to find an event from a specific time. JUst select the timezone on the search.php page which you are searching for. For example like this on our demo site:

http://demo.phplogcon.org/index.php?fil ... id=Source5

best regards,
Andre Lorbach