I found the reason is that on OpenSuse 15.3, mysql is installed with a port of 0. Un-commenting the port setting in my.cnf fixed the problem.
On Monday, 22 November 2021 14:59:11 GMT Graham Dicker wrote: > I have installed Bacula 11.0.5 on my new installation of OpenSuse 15.3 but I > am struggling to understand why Bacula cannot connect to mysql. Initially > the problem seemed to be connected with the mysql socket. When akonadi > starts it uses a mysql socket at /run/user/1000/akonadi/mysql.socket and I > think the director was trying to connect to mysql using the default > location for the socket at > > /run/mysql/mysql.sock. > > So I put > > dbsocket = /run/user/1000/akonadi/mysql.socket > > in the Catalog definition but now when I start the director with debug > output I get this: > > vivaldi:/opt/bacula/etc # ../bin/bacula-dir -d 99 -f -c bacula-dir.conf > bacula-dir: dird.c:300-0 Debug level = 99 > bacula-dir: address_conf.c:289-0 Initaddr 0.0.0.0:9101 > bacula-dir: dir_plugins.c:151-0 Load Director plugins > bacula-dir: dir_plugins.c:153-0 No Director plugin directory! > bacula-dir: mysql.c:242-0 mysql_init done > bacula-dir: mysql.c:285-0 mysql_real_connect done > bacula-dir: mysql.c:287-0 db_user=bacula db_name=bacula db_password= > bacula-dir: mysql.c:297-0 Error 1044 (42000): Access denied for user > ''@'localhost' to database 'bacula' > bacula-dir: dird.c:1458-0 Could not open Catalog "MyCatalog", database > "bacula". > bacula-dir: dird.c:1463-0 mysql.c:293 Unable to connect to MySQL server. > Database=bacula User=bacula > MySQL connect failed either server not running or your authorization is > incorrect. > 22-Nov 14:16 bacula-dir ERROR TERMINATION > Please correct configuration file: bacula-dir.conf > > I had no such problems with an earlier version of Bacula > Can anybody help please? > > Graham Dicker > > > > > > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
