Debian: Error with 3.1 setup-kolab and mysql setup

[Karma Kolabor]

Just to mention:
* I used, of course, fresh debian netinstall iso in vm with only ssh
server installed (and git) for each new test.
* I tried to install in one go with just adding package sources to
/etc/apt/sources.d/kolab.list.
* I tried to install mysql-server first, double-checked that mysql
root password in fact does work.
* I tried both mysql options that setup-kolab asked for (already
installed and new server)
* I tried both mysql options that setup-kolab asked for (already
installed and new server) with pre-installed mysql-server
* I tried to use more complex mysql password at debconf, assuming some
pw checking in the following script fails silently because of too
simple test passwords
* i tried with empty debconf password, assuming that option 2 of
setup-kolab needs empty root password.

And so on, I think i have not left any possibility out, tested about
20 times, no way around that error, install always stops at this
point.

Is there a way to use only parts of setup-kolab? Is it possible to
just each single step and do the mysql setup part manually?

Thanks for your attention,
Karma

On Thu, Jan 23, 2014 at 2:16 PM, Karma Kolabor <kolaborista at gmail.com> wrote:
> Hi,
>
> I am trying to install Kolab from these sources:
>
> deb http://obs.kolabsys.com:82/Kolab:/3.1/Debian_7.0/ ./
> deb http://obs.kolabsys.com:82/Kolab:/3.1:/Updates/Debian_7.0/ ./
>
>
> setup-kolab fails after the mysql password dialog, I get these errors:
>
> ERROR 1005 (HY000) at line 9: Can't create table
> 'roundcube.kolab_alarms' (errno: 150)
> ERROR 1146 (42S02) at line 175: Table 'roundcube.system' doesn't exist
>
> and some long python traceback that essentially boils down to
>
> OperationalError: (OperationalError) unable to open database file None None
>
>
> for reference I put the whole traceback on bottom of this post.
>
> This looks like the mysql password is not accepted. I tried several
> variations. setup-kolab asks at one point for mysql passwords and
> gives two options, preconifgured mysql and new setup - I do not
> understand this, as debconf already setup the mysql password before,
> but no matter what I try I always get the error described above. I
> tried to give no password at debconf mysql dialog because I had the
> suspicion that setup-kolab expects an empty root password at option 2
> (New MySQL server), tried more complex passwords, tried everything
> else that seemed possible but no success. setup-kolab always fails at
> this point.
>
> Any solution?
>
> Here is the whole python trace:
>
> Traceback (most recent call last):
>   File "/usr/lib/python2.7/dist-packages/kolabd/process.py", line 54,
> in synchronize
>     auth.synchronize()
>   File "/usr/lib/python2.7/dist-packages/pykolab/auth/__init__.py",
> line 251, in synchronize
>     self._auth.synchronize(mode=mode)
>   File "/usr/lib/python2.7/dist-packages/pykolab/auth/ldap/__init__.py",
> line 952, in synchronize
>     modified_after = self.get_latest_sync_timestamp()
>   File "/usr/lib/python2.7/dist-packages/pykolab/auth/ldap/__init__.py",
> line 531, in get_latest_sync_timestamp
>     timestamp = cache.last_modify_timestamp(self.domain)
>   File "/usr/lib/python2.7/dist-packages/pykolab/auth/ldap/cache.py",
> line 173, in last_modify_timestamp
>     db = init_db(domain)
>   File "/usr/lib/python2.7/dist-packages/pykolab/auth/ldap/cache.py",
> line 165, in init_db
>     metadata.create_all(engine)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/schema.py", line
> 2564, in create_all
>     tables=tables)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
> line 2299, in _run_visitor
>     conn = self.contextual_connect(close_with_result=False)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
> line 2490, in contextual_connect
>     self.pool.connect(),
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
> 224, in connect
>     return _ConnectionFairy(self).checkout()
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
> 387, in __init__
>     rec = self._connection_record = pool._do_get()
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
> 802, in _do_get
>     return self._create_connection()
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
> 188, in _create_connection
>     return _ConnectionRecord(self)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
> 270, in __init__
>     self.connection = self.__connect()
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
> 330, in __connect
>     connection = self.__pool._creator()
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py",
> line 80, in connect
>     return dialect.connect(*cargs, **cparams)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py",
> line 281, in connect
>     return self.dbapi.connect(*cargs, **cparams)
> OperationalError: (OperationalError) unable to open database file None None
>
> Thanks and have a nice day,
> Karma