@maier-m Thanks for providing more information.
It seems your my.cnf points to /etc/alternatives/my.cnf. What does that
file point to then? Please post output of 'ls -la
/etc/alternatives/my.cnf'
I suspect that the update-alternatives didn't work and your my.cnf does
not point to mariadb.cnf.
Without the update-alternatives system debconf would automatically
notify the user that the config is changed, and then ask if the user
wants to keep their file, install the packager version or view a diff of
the changes. It would be nice if that user experience would be present
here.
At least
On Thu, May 21, 2015 at 11:34:47AM -, Otto Kekäläinen wrote:
Without the update-alternatives system debconf would automatically
notify the user that the config is changed, and then ask if the user
wants to keep their file, install the packager version or view a diff of
the changes. It
I think it's just a one line call to update-alternatives?
Ah - I see that you found that. Does my explanation make sense? Should
the behaviour be any different?
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
Well, you're right...
root@system:/etc# ls -la /etc/mysql/my.cnf
lrwxrwxrwx 1 root root 24 Mai 21 11:21 /etc/mysql/my.cnf -
/etc/alternatives/my.cnf
root@system:/etc# ls -la /etc/alternatives/my.cnf
lrwxrwxrwx 1 root root 26 Mai 21 11:21 /etc/alternatives/my.cnf -
/etc/mysql/my.cnf.migrated
Ending up with /etc/mysql/my.cnf.migrated is currently expected and
intended behaviour if you had previously customised configuration. In
this case you are required to either manually update your customisations
or explicitly choose to drop your customisations and switch back to
packaging
2015-05-21 12:53 GMT+03:00 Markus maie...@web.de:
And after a reboot, we're good :-)
So I guess you are right, the update-alternatives did not work out
during migration. Does that point you to a solution?
I'll subscribe the Robie who engineered the update-alternatives for
MySQL/MariaDB if he
At least we've seen that people don't read the first lines in the
my.cnf.migrated even though the solution is there.
Honestly I read that part of the conffile (by chance while scrolling
through the file) but did not even understand that this was the issue
here. The whole link/alternatives
Should this be in the wrapper, or in the one-time migration code in
mysql-common when my.cnf.migrated is generated? I'm happy with the
latter, especially as you point out a regular conffile prompt would
happen anyway. I'm concerned about too many debconf prompts for the
former.
We could
The bug also occurred on my PC:
# cat /etc/issue
Ubuntu 15.04 \n \l
# uname -a
Linux domzjing 3.19.0-16-generic #16-Ubuntu SMP Thu Apr 30 16:09:58 UTC 2015
x86_64 x86_64 x86_64 GNU/Linux
@otto Any news about this problem?
--
You received this bug notification because you are a member of
** Changed in: mariadb-10.0 (Ubuntu)
Assignee: (unassigned) = Otto Kekäläinen (otto)
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1447944
Title:
Cannot access mariadb after upgrading to
Okay guys, slowly getting there... Inspired by
https://lists.launchpad.net/maria-developers/msg08315.html I figured out
that my plugin table in the mysql db was empty.
So
/etc/init.d/mysql stop
killall mysqld_safe
killall mysqld
mysqld_safe --skip-grant-tables
INSERT INTO mysql.plugin (name,
Maybe someone could post a working configuration here which might point
us to a solution?
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1447944
Title:
Cannot access mariadb after upgrading to
Hello guys,
Do you think it is possible to downgrade MariaDB or in anyway go back to
the previous versions of ubuntu and mariaDB ?
Thanks (I'm going crazy by the way, I am very new in all server
administration thing..)
--
You received this bug notification because you are a member of Ubuntu
For me it fails to stop mysql
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1447944
Title:
Cannot access mariadb after upgrading to Ubuntu 15.04: Plugin
'unix_socket' is not loaded
To manage
Oops. That should have been `mysqld`, and I meant the terminal output
rather than /var/log/mysql/error.log.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1447944
Title:
Cannot access mariadb after
Hm, I just realized that after bootup, I see mysqld and mysqld_safe
running:
root 1016 0.0 0.1 22572 3688 ?S20:45 0:00 /bin/bash
/usr/bin/mysqld_safe
root 1017 0.0 0.1 24508 2588 ?S20:45 0:00 logger -p
daemon.err -t /etc/init.d/mysql -i
mysql
Interesting. For me I'm pretty sure that displayed an error about the
plugin file being missing. Sorry, I can't help.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1447944
Title:
Cannot access
I think, that there is some missunderstanding of what the unix_socket
authentication does...
A user, who is loged in on his system (shell, ssh...) is able to access
mariadb with a user that is named like his unix user (if it exists as db
user) without password.
So logged in as root, I'm able to
Yes, correct. What I intended to say is that after zhxq's script was
applied, MariaDB is back on the old authentication mode without any
password for root. So mysql -u root just works for any user!
Focussing back on the issue: we should then get unix_socket running
right after the upgrade. Can
!WARNING! After the script mentionend above has been executed, root was
able to login without a password!
Basically, the script by zhxq does the trick and removes the plugin
authentication for root. But on my system, it left MariaDB with no
password set for root. So in terms of security, this is
If you stop the mysql service and just run `mysql` directly from the
command line, does it mention the plugin file in the log?
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1447944
Title:
Cannot
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
ls -la /etc/mysql gives
insgesamt 44
drwxr-xr-x 4 root root 4096 Apr 24 09:26 .
drwxr-xr-x 152 root root 12288 Apr 24 22:44 ..
drwxr-xr-x 2 root root 4096 Apr 24 09:09 conf.d
-rw--- 1 root root 277 Apr 24 09:26 debian.cnf
-rwxr-xr-x 1 root root 1312 Feb 17 19:24 debian-start
@Markus
It is weird that Ubuntu didn't find this problem before releasing the
new upgrade.
I think this problem will affect tens of thousands of users.
However, I hope my script helps to solve the problem temporary ;-)
--
You received this bug notification because you are a member of Ubuntu
Errors about unix_socket usually mean that your configuration in
/etc/mysql/ does not contain the plugin loading stanza. Something is
messed up in your configuration that the automatic upgraded wasn't able
to resolve. What does 'ls -la /etc/mysql' show? What is the contents of
your main
I was running into this issue and found that installing mariadb-
server-10.0 created the plugin needed to fix the issue.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1447944
Title:
Cannot access
ah by the way I just tried to login using root without password.
and mariadb told me access denied.
using root with password can login normally.
so it shouldn't be a problem, I think.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
Thanks for replying for the functionality of my script.
Because I'm the only one that uses the server, so I don't care others
using MariaDB as root.
However, with this you can create another user by root, and re-enable unix
socket by
update user set plugin=unix-socket where User=root;flush
@Markus
Thanks a lot, and I had noticed the problem in http://zhxq.io/?p=99
Please take a look, and if you are available, please leave a comment
under my website.
Thanks for noticing, and I also tried, this is not a problem.
This will start a mysql with no root password for seconds (this is
On my system, root passwords are being removed during the upgrade from
utopic to vivid (and before zhxq's script is run). I guess this is done
because root should now be authenticated using unix_socket.
So after removing the plugin entry from the user table, the security
issue remains.
--
You
which log? If I stop mysqld and just run mysql, /var/log/mysql/error.log
is not touched.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1447944
Title:
Cannot access mariadb after upgrading to Ubuntu
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
None of the above mentioned fixes worked for me.
In which config file and which section do I have to add the entries? There are
much more in /etc/mysql now than it was before.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
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
Config fix for local root user access
from: plugin-load-add=auth_socket.so
to: plugin-load-add=unix_socket=auth_socket.so
after that
mysql as root is posible
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
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/1447944
Title:
+1
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1447944
Title:
Cannot access mariadb after upgrading to Ubuntu 15.04: Plugin
'unix_socket' is not loaded
To manage notifications about this bug
after an update to 15.04. my system was affected too;
after some research I added
plugin-load=auth_socket.so
ty my.cnf, now authenticated users (like root) can access the databases
without entering a database password.
see https://mariadb.com/kb/en/mariadb/unix_socket-authentication-plugin/
In /etc/mysql/mariadb.conf.d/mysqld.conf there is an something like
#
# * Unix socket authentication plugin
#
# Needed so the root database user can authenticate without a password but
# only when running as the unix root user.
#
# Also available for other users if required.
# See
40 matches
Mail list logo
