Many Thanks, Clayton
I have found the issue, since mysql module is disable in php. After rebuilding
the php with mysql support, it works well now. and I will try to install
logzilla as your suggestion. thank you.
> Date: Wed, 16 Jun 2010 21:57:33 -0400
> Subject: Re: [Php-syslog-ng-support] php-syslog installation issue
> From: [email protected]
> To: [email protected]
> CC: [email protected]
>
> Hi,
> That version is *very* old and no longer supported. Please try the
> latest version. Here are some helpful links:
>
> Forum
> http://forum.logzilla.info
>
> Installation Guide
> http://nms.gdd.net/index.php/Install_Guide_for_LogZilla_v3.0
>
> User/Admin Guide
> http://nms.gdd.net/index.php/LogZilla_3.0_User_Guide
>
>
> ______________________________________________________________
>
> Clayton Dukes
> ______________________________________________________________
>
>
> 2010/6/16 Binbin Wang <[email protected]>
> >
> > Hi, All
> > I just encounter a problem when installing php-syslog, and the web page
> > always show that "A database connection problem was encountered.
> > Please check config/config.php to make sure everything is correct and make
> > sure the MySQL server is up and running."
> > The config.php file is as below, and I promise all the user name and
> > password are correct, could anyone help me ? the version is 2.8, and the
> > database is setup by dbsetup.sql within the php-syslog-ng. thanks a lot.
> >
> > ################################################################################
> >
> > <?php
> > // Copyright (C) 2005 Claus Lund, [email protected]
> > //========================================================================
> > // BEGIN: MISC FUNCTIONALITY
> > //========================================================================
> > define('PAGETITLE', 'php-syslog-ng');
> > define('VERSION', '2.8');
> > // COUNT_ROWS determines if results also display the number of total
> > // entries in the query. You need to have MySQL 4.0.0 or later for this
> > // to work. If you are using an older version of MySQL then disable this
> > // feature.
> > define('COUNT_ROWS', TRUE);
> > // DEFAULTLOGTABLE is the name of the table where new syslog entries are
> > // stored.
> > define('DEFAULTLOGTABLE', 'logs');
> > // MERGELOGTABLE is the name of the merge table. This feature should
> > // generally only be used in combination with the logrotate script.
> > // If it is enabled then the logrotate script will create a merge table
> > // of all the log tables. Be aware that you need to be a little careful
> > // when using merge tables so it is recommended that you only use it with
> > // the logrotate script. The merge table will also be the one used to
> > // populate the HOSTS and FACILITY fields on the search form.
> > define('MERGELOGTABLE', 'all_logs');
> > // If LOGROTATERETENTION is defined then it determines how many days logs
> > // are kept. Old log tables with a datestamp older than LOGROTATERETENTION
> > // days will be dropped.
> > define('LOGROTATERETENTION', 90);
> > //========================================================================
> > // END: MISC FUNCTIONALITY
> > //========================================================================
> >
> > //========================================================================
> > // BEGIN: DATABASE CONNECTION INFO
> > //========================================================================
> > // DBUSER is the name of the basic user.
> > define('DBUSER', 'sysloguser');
> > // DBUSERPW is DBUSER's database password.
> > define('DBUSERPW', 'PW_HERE');
> > // DBADMIN is the name of the admin user.
> > define('DBADMIN', 'syslogadmin');
> > // DBADMINPW is DBADMIN's database password.
> > define('DBADMINPW', 'syslogadminpassword');
> > // DBNAME is the name of the database you are using.
> > define('DBNAME', 'syslog');
> > // DBHOST is the host where the MySQL server is running.
> > define('DBHOST', 'localhost');
> > // DBPORT is the port where the MySQL server is listening.
> > // The default port is 3306.
> > define('DBPORT', '3306');
> > //========================================================================
> > // END: DATABASE CONNECTION INFO
> > //========================================================================
> >
> > //========================================================================
> > // BEGIN: AUTHENTICATION
> > //========================================================================
> > define('REQUIRE_AUTH', FALSE);
> > define('AUTHTABLENAME', 'users');
> > // Authentication has two modes:
> > // 1) You renew the session on every page view. This means you can have a
> > // tail screen running and the session will never expire as long as you
> > // refresh the screen before SESSION_EXP_TIME. This is the default.
> > // 2) The session is timed from the time you login. The session is only
> > // refreshed on login.
> > define('RENEW_SESSION_ON_EACH_PAGE', TRUE);
> > // SESSION_EXP_TIME is seconds until the session expires.
> > define('SESSION_EXP_TIME', '3600');
> > // Set the URL to php-syslog-ng. If you don't then the login screen will
> > // not be able to redirect users automatically after a successful login.
> > //define('URL', 'http://localhost/phpsyslogng/');
> > //========================================================================
> > // END: AUTHENTICATION
> > //========================================================================
> >
> > //========================================================================
> > // BEGIN: ACCESS CONTROL
> > //========================================================================
> > // Access Control Lists allows you to specify what individual users have
> > // access to. Access Control requires Authentication to have any effect.
> > // Currently only the Configure screen uses this options.
> > define('USE_ACL', TRUE);
> > define('USER_ACCESS_TABLE', 'user_access');
> > define('ACTION_TABLE', 'actions');
> > //========================================================================
> > // BEGIN: ACCESS CONTROL
> > //========================================================================
> >
> > //========================================================================
> > // BEGIN: SEARCH CACHE
> > //========================================================================
> > // Enabling the search cache will create a small table with the values
> > // needed to fill in the HOSTS and FACILITY fields on the search page.
> > // The cache table has to filled/updated by either clicking the refresh
> > // cache option or periodically running the updateCache.php script (from
> > // cron).
> > // If you use the MERGELOGTABLE then the cache will be updated using that
> > // table. If you do not use MERGELOGTABLE then the cache is updated for
> > // each table with log data.
> > define('USE_CACHE', TRUE);
> > define('CACHETABLENAME', 'search_cache');
> > //========================================================================
> > // END: SEARCH CACHE
> > //========================================================================
> >
> > //========================================================================
> > // BEGIN: REG EXP ARRAY USED FOR INPUT VALIDATION
> > //========================================================================
> > $regExpArray = array(
> > "username"=>"(^\\w{4,}\$)",
> > "password"=>"(^.{4,}\$)",
> > "pageId"=>"(^\\w+$)",
> > "sessionId"=>"(^\\w{32}\$)",
> >
> > "date"=>"/^yesterday$|^today$|^now$|^(\\d){4}-([01]*\\d)-([0123]*\\d)$/i",
> > "time"=>"/^now$|^([012]*\\d):([012345]*\\d):([012345]*\\d)$/i",
> > "limit"=>"(^\\d+$)",
> > "orderby"=>"/^seq$|^host$|^facility$|^priority$|^datetime$/i",
> > "order"=>"/^asc$|^desc$/i",
> > "offset"=>"(^\\d+$)",
> > "collapse"=>"/^1$/",
> > "table"=>"(^\\w+$)",
> > "excludeX"=>"(^[01]$)",
> > "host"=>"(^[\\w-.]+$)",
> > "facility"=>"(^\\w+$)",
> >
> > "priority"=>"/^debug$|^info$|^notice$|^warning$|^err$|^crit$|^alert$|^emerg$/i",
> > );
> > //========================================================================
> > // END: REG EXP ARRAY USED FOR INPUT VALIDATION
> > //========================================================================
> > ?>
> >
> > #########################################################################
> >
> >
> > ________________________________
> > Your E-mail and More On-the-Go. Get Windows Live Hotmail Free. Sign up now.
> > ------------------------------------------------------------------------------
> > ThinkGeek and WIRED's GeekDad team up for the Ultimate
> > GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
> > lucky parental unit. See the prize list and enter to win:
> > http://p.sf.net/sfu/thinkgeek-promo
> > _______________________________________________
> > Php-syslog-ng-support mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
> >
_________________________________________________________________
Hotmail: Powerful Free email with security by Microsoft.
https://signup.live.com/signup.aspx?id=60969------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Php-syslog-ng-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
