Hmmm, On 03-01-17 22:07, Paul Gevers wrote: > On 03-01-17 21:21, PICCA Frederic-Emmanuel wrote: >> I just try to use dbconfig-common like I did before, >> (create the tango database, populate it with a few values and create some >> procedures.) >> >> What is strange to me is that with dbconfig-common (jessie version), I end >> up with procedure owned by >> root @ localhost >> >> but when I use the dbconfig-common of stretch, the procedure are owned by >> tango @ localhost 5which is right) >> >> I always used the non dbadmin script in order to configure my database. >> This is why I do not understand why the mysqldump does not work anymore. >> Does the dump changed between the jessie and strecth dbconfig-common ? >> >> By change I mean. >> >> In jessie it is run as root, but on stretch it is run as tango ? > > Let me check the (huge) delta between jessie and stretch (hopefully > tomorrow). I made major improvements in the code, but I don't > specifically remember anything related to this issue. Furthermore, I > don't rule out that this is indeed MySQL/MariaDB related. We/you could > also ask the maintainers list of those packages if the current behavior > rings a bell. Additionally, trying to do the tests as you did so far but > sticking to MySQL instead of moving over to MariaDB would be an > interesting and insightful exercise.
I am suspecting that this commit may be related to the current behavior: https://anonscm.debian.org/cgit/collab-maint/dbconfig-common.git/commit/?id=acdb99d61abfff54630c4cfba6e4452357a83fb9 I believe I implemented there that the drop of the database is performed with the user privileges instead of the dbadmin privileges because I believed one should always have the rights to drop the db. Apparently I was wrong. We may need to clone or reassign this bug to dbconfig, but I'm not sure yet if there aren't more things, or if tango-db should work around the issue (which may be created by buggy dbconfig-common behavior of the past). Out of time now. Paul
signature.asc
Description: OpenPGP digital signature
