[horde] Installing horde4 on debian / kolab

[Alexander Gran]

Zitat von Gunnar Wrobel <wrobel at horde.org>:

> Quoting Alexander Gran <alexg at moduleworks.com>:
>
>> Hi,
>>
>> I have a shiny new server to play with that should take over from 
>> our exsiting kolab/debian native/horde 3 system.
>> I managed to (test-)migrate kolab,imap,postfix on the box. Ldap is 
>> still running on the live old box.
>> Now I wanted to install horde4 as by
>> http://lists.alioth.debian.org/pipermail/pkg-php-pear/2011-June/000125.html
>> (coming from 
>> http://log.pardus.de/2011/06/horde4-debian-packages-second-round.html#comments)
>> The box is running debian testing, I have unstable sources enabeld 
>> as well. It pulled a few unstable packages when doing the apt-get.
>> However what I got is:
>> (all before went ok)
>> root at havanna:/etc# webmail-install
>>
>> Installing Horde Groupware Webmail Edition
>>
>> Configuring database settings
>>
>> What database backend should we use?
>>    (false) [None]
>>    (mysql) MySQL / PDO
>>    (mysqli) MySQL (mysqli)
>>    (pgsql) PostgreSQL
>>    (sqlite) SQLite
>>
>> Type your choice []: sqlite
>>
>> Absolute path to the database file* [] /var/lib/kolab/horde4/config.db
>>
>> Internally used charset* [utf-8]
>>
>> Writing main configuration file... done.
>>
>> Creating database tables...
>> ====================
>>
>> Fatal Error:
>> SQLSTATE[HY000]: General error: 1 near "1": syntax error
>>
>> 1. Horde_Core_Bundle->migrateDb() /usr/bin/webmail-install:32
>> 2. Horde_Db_Migration_Migrator->up() /usr/share/php/Horde/Core/Bundle.php:99
>> 3. Horde_Db_Migration_Migrator->_doMigrate() 
>> /usr/share/php/Horde/Db/Migration/Migrator.php:102
>> 4. Horde_Db_Migration_Base->migrate() 
>> /usr/share/php/Horde/Db/Migration/Migrator.php:182
>> 5. KronolithUpgradeAddAllDay->up() 
>> /usr/share/php/Horde/Db/Migration/Base.php:121
>> 6. KronolithUpgradeAddAllDay->execute() 
>> /usr/share/horde4/kronolith/migration/3_kronolith_upgrade_addallday.php:24
>> 7. Horde_Db_Migration_Base->__call() 
>> /usr/share/horde4/kronolith/migration/3_kronolith_upgrade_addallday.php:24
>> 8. call_user_func_array() /usr/share/php/Horde/Db/Migration/Base.php:86
>> 9. Horde_Db_Adapter_Pdo_Sqlite->execute()
>> 10. Horde_Db_Adapter_Pdo_Sqlite->_catchSchemaChanges() 
>> /usr/share/php/Horde/Db/Adapter/Pdo/Sqlite.php:123
>> 11. call_user_func_array() 
>> /usr/share/php/Horde/Db/Adapter/Pdo/Sqlite.php:171
>> 12. Horde_Db_Adapter_Base->execute()
>>
>> ====================
>>
>> Any Idea how to process. I just made up a path and type for the DB...
>
> Can you try to run the migrations again? I think this is still an 
> unsolved problem with sqlite and the Kronolith migrations. If you run 
> them twice it might work. Definitely worth a ticket though.

Yes, this fixed the issue.
Note that this was a fresh install, no migration needed.
Where to raise the ticket? Horde?

regards
Alex