[horde] Installing horde4 on debian / kolab

[Gunnar Wrobel]

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.

Cheers,

Gunnar

>
> regards
> Alex

-- 
Core Developer
The Horde Project

e: wrobel at horde.org
t: +49 700 6245 0000
w: http://www.horde.org

pgp: 9703 43BE
tweets: http://twitter.com/pardus_de
blog: http://log.pardus.de