Re: deb package fails to add user for debian-sys-maint
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.
Re: deb package fails to add user for debian-sys-maint
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.