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

[Guido Günther]

On Tue, Sep 15, 2015 at 07:23:03AM +0200, Carsten Schoenert wrote:
> 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.

Check the autopkgtest in git (debian/tests/smoke) - I think everything
is already there or I don't understand which problem you like to solve.

Cheers,
 -- Guido