[ansel] Trouble setting up Ansel with Kolab

[luis_david]

Dear all,

I've been having some trouble while trying to setup Ansel within a working Kolab Horde Webclient installation.

Horde in Kolab uses SQLite as its database backend, but since MDB2 supports SQLite, I was assuming it would all work out. However, when I click on the "Galleries" or the "My Galleries" views, I get an "MDB2 Error: unknown error".

I double checked the horde.db database file and all of the tables and indices in the ansel.sql script are there. The Ansel test.php page doesn't complain about anything critical (just some of the optional libraries I have not installed). I have also looked for further information in the horde log and the only log entries that seem to be generated by selecting these views are:

May 22 13:51:37 HORDE [debug] [ansel] Hook _horde_hook_share_init in application horde not called. [pid 30581 on line 1683 of "/kolab/var/kolab/www/client/lib/Horde.php"]
May 22 13:51:37 HORDE [debug] [ansel] SQL query by Horde_Alarm_sql::_list(): SELECT alarm_id, alarm_uid, alarm_start, alarm_end, alarm_methods, alarm_params, alarm_title, alarm_text, alarm_snooze, alarm_internal FROM horde_alarms WHERE alarm_dismissed = 0 AND ((alarm_snooze IS NULL AND alarm_start <= ?) OR alarm_snooze <= ?) AND (alarm_end IS NULL OR alarm_end >= ?) AND (alarm_uid = ? OR alarm_uid = ?) ORDER BY alarm_start, alarm_end [pid 30581 on line 148 of "/kolab/var/kolab/www/client/lib/Horde/Alarm/sql.php"]
May 22 13:51:37 HORDE [debug] [ansel] Max memory usage: 8126464 bytes [pid 30581 on line 339 of "/kolab/var/kolab/www/client/lib/Horde/Registry.php"]

I am using Kolab 2.2.3, which includes Horde 3.3, and Ansel 1.1.1.

Any ideas on how to fix this?

Thanks.

Kind regards,

Luis D. Pedrosa