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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users