[dev] Horde logging.

[Frederic Trudeau]

Thanks. Table created, but I get this error message.

Warning: 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


Here is the content of horde.php :


// Should Horde log errors and other useful information?
$conf['log']['enabled'] = true;

// What log driver should we use? Valid values are 'file', 'mcal',
// 'sql', and 'syslog'.
$conf['log']['type'] = 'sql';

// What is the name of the log? For the 'file' driver, this is the
// path to a text file; for mcal, it would be the name of a calendar,
// and for sql it would be the table name to use. For the 'syslog'
// driver it is the facility as a _constant_ (with no quotes), e.g.:
// ... = LOG_LOCAL0;
$conf['log']['name'] = 'log_table';

// What level of messages should we log? The values are LOG_EMERG,
// LOG_ALERT, LOG_CRIT, LOG_ERR, LOG_WARNING, LOG_NOTICE, LOG_INFO,
// and LOG_DEBUG. Each level logs itself and all those that come
// before it: LOG_ALERT would only log alerts and emergencies, but
// LOG_DEBUG would log everything.
$conf['log']['priority'] = LOG_DEBUG;

// What identifier should we use in the logs?
$conf['log']['ident'] = 'HORDE';

// Any additonal configuration information, like an MCAL or database
// username and password.
$conf['log']['params'] = array();
$conf['log']['params']['phptype'] = 'mysql';
$conf['log']['params']['hostspec'] = 'localhost';
$conf['log']['params']['username'] = 'hordemgr';
$conf['log']['params']['password'] = 'xxxxxxx';
$conf['log']['params']['database'] = 'horde';
//$conf['log']['params']['table'] = 'log_table';


Any clue ?


-- 
Frederic Trudeau


[A]dvanced [S]upport [A]gent
Colocation/Customer Support Agent
CAM Internet -> http://www.cam.org
->


Quoting Jon Parise <jon at horde.org>:

> On Thu, Sep 27, 2001 at 05:36:22PM -0400, Frederic Trudeau wrote:
> 
> > can I put all loggin info in a mysql db ? If so, what are the mysql tree
> > that I must create. thanks
> 
> Sure.  Here's the table schema:
> 
>     CREATE TABLE log_table (
>         unixtime    int NOT NULL,
>         ident       char(16) NOT NULL,
>         priority    int,
>         message     varchar(200),
>         primary key (unixtime, ident)
>     );
> 
> -- 
> Jon Parise (jon at csh.rit.edu)  .  Information Technology (B.S.)
> http://www.csh.rit.edu/~jon/  :  Computer Science House Member
> 
> -- 
> Horde Developers mailing list: http://horde.org/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: dev-unsubscribe at lists.horde.org
> 
> 


---------------------------------------------------------------------
Service de Courrier en-ligne de CAM Internet: http://courrier.cam.org
CAM Internet Webmail Service: http://webmail.cam.org