[horde] horde logging with mysql problem ?

[alex]

Still got a fatul error:
=============================================================================
Horde is not correctly configured to log error messages. You must configure at 
least a text file log in horde/config/conf.php.

Here is my config.php
remove these entry in horde/config/conf.php
$conf['log']['params'] = array();
$conf['log']['params']['phptype'] = 'mysql';
$conf['log']['params']['hostspec'] = 'mysql.my.com';
$conf['log']['params']['username'] = 'root';
$conf['log']['params']['password'] = 'PASSWORD';
$conf['log']['params']['database'] = 'horde';
 
and keep these entry
$conf['log']['enabled'] = true;
$conf['log']['type'] = 'sql';
$conf['log']['name'] = 'log_table';
$conf['log']['dsn'] = 'mysql://root:PASSWORD@mysql.my.com/horde';

¤Þ¥Î Jan Schneider <jan at horde.org>:

> alex wrote:
> 
> >Hi all:
> >runtime env:apache+php4+imp4
> >I used mysql as logging stroage,and here are some of config item in
> >horde/config/conf.php
> >$conf['log']['type'] = 'sql';
> >$conf['log']['name'] = 'log_table';
> >$conf['log']['params'] = array();
> >$conf['log']['params']['phptype'] = 'mysql';
> >$conf['log']['params']['hostspec'] = 'mysql.my.com';
> >$conf['log']['params']['username'] = 'root';
> >$conf['log']['params']['password'] = '***';
> >$conf['log']['params']['database'] = 'horde';
> >
> >even drop all uniq indexes in log_table,but still occur such errors:
> >
> >Notice: Undefined index: dsn in /usr/local/lib/php/Log/sql.php on line 55
> >Fatal error: Call to undefined function: query()
> >in /usr/local/lib/php/Log/sql.php on line 114
> >
> >
> You need to provide a dsn, not an array.
> Try something like:
> $conf['log']['dsn'] = 'mysql://root:***@mysql.my.com/horde';