ourdelta-developers team mailing list archive

[Sergey Petrunia <psergey@xxxxxxxxxxxx>]

It is possible to connect to the server and there one can see that
indeed mysql.user table has no debian-sys-maint user.

Failure to add user is because of the following:

bakery/debian-5.1/dist/Ubuntu/mariadb-server-5.1.postinst  has this command:
    replace_query=`/bin/echo -e \
        "USE mysql\n" \
        "REPLACE INTO user SET " \
        "  host='localhost', user='debian-sys-maint', password=password('$pass'), " \
        "  Select_priv='Y', Insert_priv='Y', Update_priv='Y', Delete_priv='Y', " \
        "  Create_priv='Y', Drop_priv='Y', Reload_priv='Y', Shutdown_priv='Y', " \
        "  Process_priv='Y',  File_priv='Y', Grant_priv='Y', References_priv='Y', " \
        "  Index_priv='Y', Alter_priv='Y', Super_priv='Y', Show_db_priv='Y', "\
        "  Create_tmp_table_priv='Y', Lock_tables_priv='Y', Execute_priv='Y', "\
        "  Repl_slave_priv='Y', Repl_client_priv='Y', Create_view_priv='Y', "\
        "  Show_view_priv='Y', Create_routine_priv='Y', Alter_routine_priv='Y', "\
        "  Create_user_priv='Y', Event_priv='Y', Trigger_priv='Y' "`;

On a server with all-defaults configuration the command will succeed with three warnings:
  Field 'ssl_cipher' doesn't have a default value
  Field 'x509_issuer' doesn't have a default value
  Field 'x509_subject' doesn't have a default value

However, ourdelta-mariadb51-2/bakery/debian-5.1/additions/my.cnf  has
this line:

sql_mode                = NO_ENGINE_SUBSTITUTION,TRADITIONAL

Which will make those warnings to be errors, and the command won't
succeed any more.


** Also affects: ourdelta
   Importance: Undecided
       Status: New

** Changed in: maria
   Importance: Undecided => High

** Changed in: ourdelta
   Importance: Undecided => High

-- 
deb package fails to add user for debian-sys-maint
https://bugs.launchpad.net/bugs/454237
You received this bug notification because you are a member of OurDelta-
developers, which is the registrant for OurDelta.

Status in Maria: Confirmed
Status in OurDelta - Builds for MySQL,MariaDB: New

Bug description:
deb package fails to add user for debian-sys-maint on installation.

This causes package configuration to fail with an error:

ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)

and then this error will show up on any invocation of  /etc/init.d/mysql start|stop|etc.