There seems to be some fundamental change in the permissions in mysql as shipped with 9.2 compared with 9.0 which has completely floored me. A bugzilla set up that works fine talking to a mysql db on 9.0 comes up with the following error when the db is on a 9.2 system:- DBI connect(';localhost;3306','test2',...) failed: Access denied for user: 'test2@localhost' (Using password: YES) at ./checksetup.pl line 1460 As far as I can tell permissions on both the 9.0 and 9.2 db's are identical, *and* I have no trouble at all connecting to the 9.2 db using Rekall and the same username/login as bugzilla is trying to use. And for the moment the firewall is off, (but then Rekall wouldn't work anyway). Anyone any idea at all where to carry on looking for this one, as I've run out of ideas!! -- Tim Nicholson http://www.bbc.co.uk/ This e-mail (and any attachments) is confidential and may contain personal views which are not the views of the BBC unless specifically stated. If you have received it in error, please delete it from your system. Do not use, copy or disclose the information in any way nor act in reliance on it and notify the sender immediately. Please note that the BBC monitors e-mails sent or received. Further communication will signify your consent to this.
Tim wrote regarding '[SLE] mysql permissions in 9.2' on Mon, Jan 24 at 08:20:
There seems to be some fundamental change in the permissions in mysql as shipped with 9.2 compared with 9.0 which has completely floored me.
A bugzilla set up that works fine talking to a mysql db on 9.0 comes up with the following error when the db is on a 9.2 system:-
DBI connect(';localhost;3306','test2',...) failed: Access denied for user: 'test2@localhost' (Using password: YES) at ./checksetup.pl line 1460
As far as I can tell permissions on both the 9.0 and 9.2 db's are identical, *and* I have no trouble at all connecting to the 9.2 db using Rekall and the same username/login as bugzilla is trying to use.
And for the moment the firewall is off, (but then Rekall wouldn't work anyway).
Anyone any idea at all where to carry on looking for this one, as I've run out of ideas!!
Look at the startup log for mysql (frequently /var/lib/mysql/*.log), and see if it's complaining about anything. Also, make sure that you can actually connect with the mysql client mysql -h localhost -u test2 -p dbname (It'll prompt you for a password). I had that problem when connecting to a new MySQL while using an old MySQL client, as the format of the PASSWD() function output changed. But then, that was when I switched to 4.1, IIRC. --Danny, always checking the logs first
Danny Sauer wrote:
Tim wrote regarding '[SLE] mysql permissions in 9.2' on Mon, Jan 24 at 08:20:
There seems to be some fundamental change in the permissions in mysql as shipped with 9.2 compared with 9.0 which has completely floored me.
A bugzilla set up that works fine talking to a mysql db on 9.0 comes up with the following error when the db is on a 9.2 system:-
DBI connect(';localhost;3306','test2',...) failed: Access denied for user: 'test2@localhost' (Using password: YES) at ./checksetup.pl line 1460
[snip]
Look at the startup log for mysql (frequently /var/lib/mysql/*.log),
"050121 09:17:02 mysqld started /usr/sbin/mysqld: ready for connections. Version: '4.0.21' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution" so no whinges there!
and see if it's complaining about anything. Also, make sure that you can actually connect with the mysql client mysql -h localhost -u test2 -p dbname
Ahh, same problem, I had done a quick check with the "test" user and no pw and that's fine, the problem seems to be when you have to use a password!
(It'll prompt you for a password). I had that problem when connecting to a new MySQL while using an old MySQL client, as the format of the PASSWD() function output changed. But then, that was when I switched to 4.1, IIRC.
9.0 is 4.0.15, 9.2 is 4.0.21 so looks like the change occurred earlier! Looks like in 9.2 the supplied client is incompatible with the supplied server version! (the 9.2 client will connect perfectly to 4.0.15) One for SuSE to sort!! :( Thanks for the help.
--Danny, always checking the logs first
-- Tim Nicholson http://www.bbc.co.uk/ This e-mail (and any attachments) is confidential and may contain personal views which are not the views of the BBC unless specifically stated. If you have received it in error, please delete it from your system. Do not use, copy or disclose the information in any way nor act in reliance on it and notify the sender immediately. Please note that the BBC monitors e-mails sent or received. Further communication will signify your consent to this.
participants (2)
-
Danny Sauer -
Tim Nicholson