Re: [Bacula-users] mariadb 10.5.15
Oh, one other thing ... how old was your OLD mysql database? Red Hat had the incredibly stupid idea of shipping MySQL configured by default with 'old_passwords=1', and many other distributions just blindly shrugged and said, "Huh, seems legit to me." If your password hashes in the mysql.user table are less than 41 characters in length, you probably have old pre-MySQL-4.1 insecure passwords which have been deprecated since ... 2004 I think? All such passwords should be regenerated, and preferably changed, after making certain that old_passwords is OFF. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] mariadb 10.5.15
On 3/6/22 14:39, Alan Polinsky wrote: If I use mysql -U bacula, I cannot connect to the Bacula database. It seems to be a permission issue, but things were changed with version 10.4 of MariaDB. Can someone suggest a solution? OK, first: - Can you log into your database as superuser? - Can you verify that the 'bacula' user has a password set? - Can you verify that it is set to what you *think* it is? (Or you could just make sure by CHANGING it to what you think it should be.) - Is the host part for the 'bacula' user correct? - Does the 'bacula' user have the correct permissions? (SHOW GRANTS FOR bacula@...) - Having done all of those, can you log in using 'mysql -u bacula -p' ? -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] mariadb 10.5.15
After many years of using the Bacula 5.X series on a Slackware14.2 machine, I upgraded to Slackware Current with Mariadb 10.5.15 and Bacula 9.6.7. I cannot connect to the database. I ran scripts from the scripts directory to create the Bacula database and set permissions. Running bacula-dir -t I get: bacula-dir: dird.c:1273-0 Could not open Catalog "MyCatalog", database "bacula" . bacula-dir: dird.c:1279-0 mysql.c:269 Unable to connect to MySQL server. Database=bacula User=bacula MySQL connect failed either server not running or your authorization is incorre ct. 06-Mar 14:30 bacula-dir ERROR TERMINATION Please correct configuration file: bacula-dir.conf If I use mysql -U bacula, I cannot connect to the Bacula database. It seems to be a permission issue, but things were changed with version 10.4 of MariaDB. Can someone suggest a solution? Than you. Alan Polinsky ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
