On 2017-03-05 at 21:10:58 Erik P. Olsen wrote: > On 2017-03-05 at 20:24:15 Josip Deanovic wrote: > > > On Sunday 2017-03-05 19:53:26 Erik P. Olsen wrote: > > > Hello Kern, > > > > > > I have main.pdf downloaded and I believe I have followed the > > > various steps in phase II to the letter. I have come to the point > > > where I need some tools to diagnose what is wrong. I am pretty > > > sure that the problem is due to some sort of security settings in > > > the mysql database but I am not able to see what that could and > > > the manual has not been to any help in that respect > > > > When in doubt always try to connect manually using the credentials > > you plan to use from bacula-dir in order to rule out incorrect > > database or network setup. > > > > For example, from the bacula-dir server you can try something like > > this: mysql -h <dbhost> -u <dbuser> -p <dbname> > > > > The command above should prompt you for a password and if you are > > able to connect then there is nothing wrong with the mysql setup. > > Otherwise you need to setup your mysql database properly first. > > > > Regards > > > > Thanks for your advice which I tried both with and without arguments > and it apparently connected correctly - at least I got a welcome > message from mariadb. So I guess it is safe to assume that the mysql > database is properly setup. >
I have tried again. Dropped the tables and made (make) them again just to be sure there is nothing incorrect in the tables. Testing bacula-dir gave this time: [root@Erik-PC bacula]# bacula-dir -t -d100 -c bacula-dir.conf bacula-dir: dird.c:208-0 Debug level = 100 bacula-dir: address_conf.c:274-0 Initaddr 0.0.0.0:9101 bacula-dir: dird_conf.c:1958-0 runscript cmd=prune expired volume yes type=@ bacula-dir: dird_conf.c:1958-0 runscript cmd=/usr/libexec/bacula/make_catalog_backup.pl MyCatalog type=| bacula-dir: dird_conf.c:1958-0 runscript cmd=truncate storage=FileStorage pool=Files type=@ bacula-dir: dird_conf.c:1958-0 runscript cmd=truncate storage=CatalogueStorage pool=Catalogues type=@ bacula-dir: dird_conf.c:1958-0 runscript cmd=/usr/libexec/bacula/delete_catalogue_backup type=| 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:119-0 db_init_database first time bacula-dir: mysql.c:218-0 mysql_init done bacula-dir: mysql.c:257-0 mysql_real_connect done bacula-dir: mysql.c:259-0 db_user=bacula db_name=bacula db_password= bacula-dir: mysql.c:269-0 Error 1044 (42000): Access denied for user ''@'localhost' to database 'bacula' bacula-dir: dird.c:969-0 Could not open Catalog "MyCatalog", database "bacula". bacula-dir: dird.c:974-0 mysql.c:265 Unable to connect to MySQL server. Database=bacula User=bacula MySQL connect failed either server not running or your authorization is incorrect. bacula-dir: mysql.c:319-0 closedb ref=0 connected=0 db=0 05-mar 22:35 bacula-dir ERROR TERMINATION Please correct configuration file: bacula-dir.conf I noticed "Access denied for user ''@'localhost' ...". Where does this user come from? Isn't that the reason for the failures and if it's true what can I do to correct it? Also "Initaddr 0.0.0.0:9101" looked strange. -- Erik ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
