[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
[Expired for mariadb-10.0 (Ubuntu) because there has been no activity for 60 days.] ** Changed in: mariadb-10.0 (Ubuntu) Status: Incomplete => Expired -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
Thank you for reporting this bug to Ubuntu. RELEASE reached EOL on February 4, 2016. See this document for currently supported Ubuntu releases: https://wiki.ubuntu.com/Releases Please upgrade to the latest version and re-test. If the bug is still reproducible, increase the verbosity of the steps to recreate it so we can try again. Do feel free to report any other bugs you may find. ** Changed in: mariadb-10.0 (Ubuntu) Status: Invalid => Incomplete -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
Ubuntu 15.04 is no more supported: https://www.ubuntu.com/info/release-end-of-life ** Changed in: mariadb-10.0 (Ubuntu) Status: Confirmed => Invalid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
I had an analogous problem. Mariadb install, I create the users, I import the data and everthing is ok. I reboot the computer and mysql dous not start. In the logs I found ● mysql.service - LSB: Start and stop the mysql database server daemon Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled) Active: failed (Result: exit-code) since mer 2017-06-14 10:26:19 CEST; 12s ago Docs: man:systemd-sysv-generator(8) Process: 5885 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE) giu 14 10:25:49 portattile-caiofior mysqld[6058]: 170614 10:25:49 [ERROR] Plugin 'blackhole' already installed giu 14 10:25:49 portattile-caiofior mysqld[6058]: 170614 10:25:49 [ERROR] Plugin 'federated' already installed giu 14 10:25:49 portattile-caiofior mysqld[6058]: 170614 10:25:49 [ERROR] Plugin 'innodb' already installed giu 14 10:25:49 portattile-caiofior mysqld[6058]: 170614 10:25:49 [Note] Server socket created on IP: '127.0.0.1'. giu 14 10:25:49 portattile-caiofior mysqld[6058]: 170614 10:25:49 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format. giu 14 10:26:19 portattile-caiofior mysql[5885]:...fail! giu 14 10:26:19 portattile-caiofior systemd[1]: mysql.service: Control process exited, code=exited status=1 giu 14 10:26:19 portattile-caiofior systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon. giu 14 10:26:19 portattile-caiofior systemd[1]: mysql.service: Unit entered failed state. giu 14 10:26:19 portattile-caiofior systemd[1]: mysql.service: Failed with result 'exit-code'. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
This bug report is no longer valid, is it ? Can we close it ? -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
I find systemd loses track of starting mariadb-server-10.0 because /etc/mysql/debian-start fails because 'root'@'localhost' needs to have a password set for legacy code. There used to be a `debian-sys-maint' user and /etc/mysql/debian.cnf could be changed to run as that user instead of root, but that user no longer exists. Grabbing an existing user@host combination and mandating the access method used is a bit of a cheek. A new user can't clash; can we have debian-sys-maint back? I ended up leaving user as root in /etc/mysql/debian.cnf and putting the needed password in there. Then /etc/mysql/debian-start succeeds and `systemctl status mysql' correctly tracks it's "active (running)". -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
I don't really understand the problem but there was some definitely weirdness in my install. systemctl enable mysql sputtered some nonsense about "Too many levels of symbolic links" so I ran systemctl disable mysql systemctl enable mysql service mysql restart and then everything was fixed. Best of luck guys. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
I have exactly the same problem. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
I have exactly the same problem. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
Hello, Is it this problem : https://answers.launchpad.net/ubuntu/+source/mariadb-10.0/+question/292083 If yes, could you help me please ? Best regards Battant -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
I am not an expert on how systemd invokes legacy init.d/mysql files. Please presenting a reproducable case I can repeat and/or analyze what systemd exactly does and send a patch for http://git.debian.org/?p=pkg- mysql/mariadb-10.0.git (or mirror at https://github.com/ottok/mariadb-10.0) For auth_socket issues see https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1447808 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
locate mysql.service returns no results, but systemctl commands related to mysql or mysql.service seem to invoke /etc/init.d/mysql from the mariadb-server-10.0 package ** Changed in: mariadb-10.0 (Ubuntu) Status: Invalid => Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
The original reported has not shed any light where he got a mysql.service file that does not work. Anyway the MariaDB package does not contain one, so I am closing this issue as Invalid now. ** Changed in: mariadb-10.0 (Ubuntu) Status: Confirmed => Invalid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
Any update on this? I tried around a little and no matter what I do (even purging and manually removing all visible mariadb/mysql stuff) I get this after reinstalling mariadb-server. The mysqld_safe process should not be running after a proper installation I guess. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
I wonder how you have a mysql.service file on your system? If belongs to the mysql-5.6 package and should not be there is you are installing/upgrading MariaDB. (http://packages.ubuntu.com/search?searchon=contents&keywords=mysql.service&mode=exactfilename&suite=vivid&arch=any) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
The new MariaDB 10.0 do no longer require users to set a root password. This is a security feature. You don't need root passwords (or debian- maint-user passwords) simply to run and maintain your database anymore. If you have root on the system you will get in as root to the database (or using sudo). For use cases where you need to access the database as some user from somewhere, just create a user and grant it the required permissions, and then use that user in your apps and other places. There is no need to have a general MySQL/MariaDB root user. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
@Fred Azevedo I solved this problem. Thanks for http://ubuntuforums.org/showthread.php?t=2275033 I wrote a script and it is here: http://zhxq.io/?p=99 It contains a script and a manually way to solve the problem. I used it, and it is functional. Hope this helps. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
** Changed in: mariadb-10.0 (Ubuntu) Importance: Undecided => High -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
My friends, I have the same problem. Have added the plugin-load code = auth_socket.so in my.cnf and not solved. When trying to log into phpMyAdmin is giving the following error: Plugin unix_socket 'is not loaded mysql_connect (): Plugin unix_socket 'is not loaded Can anyone help me? -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1445549] Re: systemctl start mysql.service starts mariadb but reports failure
Status changed to 'Confirmed' because the bug affects multiple users. ** Changed in: mariadb-10.0 (Ubuntu) Status: New => Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1445549 Title: systemctl start mysql.service starts mariadb but reports failure To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs