[phpLogCon] Is loganalyzer capable of generating offline report?

[Kaiwang Chen]

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_wi
>> > 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-rele
>> >> 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
>> >
>