[phpLogCon] Is loganalyzer capable of generating offline report?

[Kaiwang Chen]

A clean installation process revealed the cause of missing php-mysql
in Step 4 - Create Tables:

Fatal error: Call to undefined function mysql_connect() in
/var/www/html/install.php on line 312

which could be installed with "yum install php53-mysql.x86_64" in
CentOS 5.6. Maybe you would like to add some words to keep careless
guys from running into my case.


I selected "enable UserDB" during the install process to avoid
explicit convert.php invocation afterwards.
Then everything worked well as I followed
How_to_schedule_an_offline_report_with_email_delivery_on_Debian.
Noticed that stock mail client(mailx-8.1.1-44.2.2) did not support
attachments, I used mutt instead, and created pdf reports.


Thanks a lot.

Kaiwang

2011/5/18 Andre Lorbach <alorbach at ro1.adiscon.com>:
> Perhaps you should try to do a clean installation, or enable php error output
> in your php.ini.
>
> Best regards,
> Andre Lorbach
>
>> -----Original Message-----
>> From: Kaiwang Chen [mailto:kaiwang.chen at gmail.com]
>> Sent: Mittwoch, 18. Mai 2011 09:14
>> To: Andre Lorbach
>> Cc: phplogcon at lists.adiscon.com
>> Subject: Re: [phpLogCon] Is loganalyzer capable of generating offline
> report?
>>
>> When I turn on 'UserDBEnabled', ther server simply returns 500, without any
>> clue in /var/log/messages, /var/log/httpd/error_log.
>>
>> $CFG['UserDBEnabled'] = true;
>> $CFG['UserDBServer'] = 'localhost';
>> $CFG['UserDBPort'] = 3306;
>> $CFG['UserDBName'] = 'loganalyzer';
>> $CFG['UserDBPref'] = 'logcon_';
>> $CFG['UserDBUser'] = 'root';
>> $CFG['UserDBPass'] = '';
>> $CFG['UserDBLoginRequired'] = false;
>> $CFG['UserDBConvertAllowed'] = true;
>>
>> I have already done "chown -R /var/www/html apache.apache", and the
>> mysqld is running with empty password listening on both 3306 and the
>> default /var/lib/mysql/mysql.sock(It made no difference when using
>> 127.0.0.1)  So what am I missing? Should the schema be created beforehand
>> ? Then, what's it? It is really frustrating to get 500 without any clue,
> even with
>> *Debug* in config.php turned on.
>>
>>
>> Thanks,
>> Kaiwang
>>
>>
>> 2011/5/17 Andre Lorbach <alorbach at ro1.adiscon.com>:
>> > It is called the UserDB System in LogAnalyzer and requires a Mysql
>> Database.
>> > See this link on how to enable the UserDB System:
>> >
>> http://wiki.rsyslog.com/index.php/How_to_to_use_convert.php_to_install
>> > _the_Us erdb-System_in_an_existing_LogAnalyzer_installation
>> >
>> > best regards,
>> > Andre
>> >
>> >> -----Original Message-----
>> >> From: Kaiwang Chen [mailto:kaiwang.chen at gmail.com]
>> >> Sent: Dienstag, 17. Mai 2011 12:53
>> >> To: Andre Lorbach
>> >> Cc: phplogcon at lists.adiscon.com
>> >> Subject: Re: [phpLogCon] Is loganalyzer capable of generating offline
>> > report?
>> >>
>> >> So there is an admin panel I was not aware of...  I noticed the admin
>> >> directory:
>> >> # ls admin/
>> >> charts.php      fields.php  index.php    reports.php  searches.php
>> >> upgrade.php  views.php dbmappings.php  groups.php  parsers.php
>> >> result.php   sources.php users.php
>> >>
>> >> When I tried to access http://host/admin/, it displayed: The
>> >> LogAnalyzer
>> > user
>> >> system is currently disabled or not installed. What's the directive
>> >> to
>> > enable it?
>> >> I just followed the INSTALL, and it said nothing about admin panel.
>> >>
>> >>
>> >> Thanks,
>> >> Kaiwang
>> >>
>> >>
>> >> 2011/5/17 Andre Lorbach <alorbach at ro1.adiscon.com>:
>> >> > Hi,
>> >> >
>> >> > as promised in my last email here is a faq article describing how
>> >> > to setup a scheduled report with LogAnalyzer on Debian:
>> >> >
>> >>
>> http://wiki.rsyslog.com/index.php/How_to_schedule_an_offline_report_w
>> >> i
>> >> > th_emai
>> >> > l_delivery_on_Debian
>> >> >
>> >> > I hope this helps you.
>> >> >
>> >> > Best regards,
>> >> > Andre Lorbach
>> >> >
>> >> >> -----Original Message-----
>> >> >> From: phplogcon-bounces at lists.adiscon.com [mailto:phplogcon-
>> >> >> bounces at lists.adiscon.com] On Behalf Of Kaiwang Chen
>> >> >> Sent: Dienstag, 17. Mai 2011 09:34
>> >> >> To: phplogcon at lists.adiscon.com
>> >> >> Subject: [phpLogCon] Is loganalyzer capable of generating offline
>> > report?
>> >> >>
>> >> >> Hello,
>> >> >>
>> >> >> I just evaluated loganalyzer 3.2.1 stable release.
>> >> >> http://loganalyzer.adiscon.com/news/loganalyzer-v3-2-1-v3-stable-r
>> >> >> ele
>> >> >> ased
>> >> >>
>> >> >> Fancy stuff, really.
>> >> >>
>> >> >> I experienced FortiAnalyzer serveral years ago, which is a
>> >> >> commertial product, closed-source and running is own hardware,
>> >> >> dedicated to Fortinet's products. It is capable of producting
>> >> >> statistics reports and mailing to configured receiver, so that one
>> >> >> could just check his mail to notice what's going on.
>> >> >>
>> >> >> Is loganalyzer shipped with such a feature, or is it in
>> >> >> development
>> > plan?
>> >> >>
>> >> >> Thanks,
>> >> >> Kaiwang
>> >> >> _______________________________________________
>> >> >> phpLogCon mailing list
>> >> >> http://lists.adiscon.net/mailman/listinfo/phplogcon
>> >> >> http://www.phplogcon.org
>> >> > _______________________________________________
>> >> > phpLogCon mailing list
>> >> > http://lists.adiscon.net/mailman/listinfo/phplogcon
>> >> > http://www.phplogcon.org
>> >> >
>> >
>