[Pkg-giraffe-discuss] database connection while setup (Re: zarafa-7.2.1 RC1 released)

[Carsten Schoenert]

Some thinking about the mariadb-server problem ...

Am 13.09.2015 um 10:44 schrieb Carsten Schoenert:
> As from the point we don't really now what the future will bring for
> MySQL packages I would like to suggest or as you wrote recommend mariadb
> packages.
> Right now the mariadb-server lacks a debconf setup for creating the root
> user like the mysql-server does! I opened up a bug because of this. But
> the reaction of Otto wasn't there helpful until yet. The user has
> currently first setup a root user for mariadb-server before continuing
> installing Zarafa.

After more reading the mariadb-server README.Debain file I came to the
conclusion that we can easily setup the needed permission by ourself
while running dbconfig_common.
mariadb-server provides the possibility to simply setup permissions for
a database user via socket or local machine account.

>From that file [1] in section 'Passwords'

communication via socket
>   sudo /usr/bin/mysql -e "GRANT ALL ON *.* TO '$USER'@'localhost' IDENTIFIED VIA unix_socket WITH GRANT OPTION"

via local machine account
>   sudo /usr/bin/mysql -e "GRANT ALL ON *.* TO 'USERNAME'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION"

We could simply run a customized command like this if we have detected a
installed mariadb-server and so on. Or we use the $ZARAFA-HOME/.my.cnf
option .
That would close the gap between the current state after mariadb-server
is installed via Recommends.

[1]
http://anonscm.debian.org/cgit/pkg-mysql/mariadb-10.0.git/tree/debian/mariadb-server-10.0.README.Debian

-- 
Regards
Carsten Schoenert