[kronolith] configuring kronolith for use w/ sql

[Paul]

liam> trying to get kronolith working with sql.. i didn't find
liam> anything blatant in the archives talking about
liam> configuration... so this is what i tried...

liam> $conf['calendar']['driver'] = 'sql';
liam> $conf['calendar']['params'] = array();
liam> $conf['calendar']['params']['phptype'] = 'mysql';
liam> $conf['calendar']['params']['hostspec'] = 'localhost';
liam> $conf['calendar']['params']['protocol'] = '';
liam> $conf['calendar']['params']['username'] = 'hordemgr';
liam> $conf['calendar']['params']['password'] = 'BLAHBLAHBLAH';
liam> $conf['calendar']['params']['database'] = '';
liam> $conf['calendar']['params']['table'] = 'kronolith_events';
liam> $conf['calendar']['params']['options'] = '';
liam> $conf['calendar']['params']['tty'] = '';
liam> $conf['calendar']['params']['port'] = '';

Specifying the database (horde) would probably help.

Here's a working example:

$conf['calendar']['driver'] = 'sql';

$conf['calendar']['params'] = array(
     'phptype'       => 'mysql',
     'hostspec'      => 'localhost',
     'protocol'      => 'unix',
     'username'      => 'hordemgr',
     'password'      => 'XXXXX',
     'database'      => 'horde',
     'port'          => '3306',
     'table'         => 'kronolith_events'
);

liam> it failed spectacularly.  can anyone help me out here?

Did you set up the tables in MySQL for the kronolith_events per
$HORDE/kronolith/docs/kronolith.sql:

CREATE TABLE kronolith_events (
  event_id bigint DEFAULT '0' NOT NULL,
  calendar_id varchar(100) NOT NULL,
  event_description text,
  event_location text,
  event_keywords text,
  event_title varchar(80),
  event_category varchar(80),
  event_recurType varchar(11) DEFAULT '0',
  event_recurInterval varchar(11),
  event_recurDays varchar(11),
  event_recurEnddate datetime,
  event_start datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  event_end datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  event_alarm int DEFAULT '0',
  PRIMARY KEY (event_id)
);