[debian-mysql] Bug#797210: Bug#797210: mariadb-10.0: mariadb-server does not ship a debconf set for creating a adminitrative user (like mysql-server do)

[Otto Kekäläinen]

Hello!

2015-08-28 21:51 GMT+03:00 Carsten Schoenert <c.schoenert at t-online.de>:
> Hello,
>
> On Fri, Aug 28, 2015 at 08:58:46PM +0300, Otto Kekäläinen wrote:
>> MariaDB uses socket authentication in Debian unstable. That is an
>> important feature that increases security and makes administration
>> easier. In the majority of cases you don't need or want to make a root
>> user, only user accounts that have limited and intended access to the
>> database.
>>
>> I don't know what README.Debian you refer to. The mariadb-10.0 does
>> not have any such file.
>
> I think it has.
> http://anonscm.debian.org/cgit/pkg-mysql/mariadb-10.0.git/tree/debian/mariadb-server-10.0.README.Debian
>
> That's there I have found the needed information how to set up a user so
> dbconfig-common can setup a database. And the information there is
> contrary to your words above!

I have updated the README, see
https://github.com/ottok/mariadb-10.0/commit/817a2fbe6bdeb76f7f076f745574ae3a865f35f4

Unfortunately I don't understand dbconfig-common enough to know what I
should do to accomodate the automation. Where does it fall short now?
On new installs you can just run as root mysqld and execute whatever
you want, it is very simple.

I skimmed through
https://people.debian.org/~seanius/policy/dbconfig-common.html/ but
didn't really get the hang of it. The docs are written for "consumers"
and not "providers" like the mariadb-10.0 package maintainers would
need to read about.

Feel free to send in pull requests / git merge requests if you have
ideas for improvement. I promise to review them quickly.