On 3/16/2017 8:18 AM, Wanderlei Huttel wrote:

Hello Erick

You must access with root user.

I've made some tests with Ubuntu 16.04 LTS and MariaDB and have some problems like yours.

I was only able to access the bconsole after changing the localhost catalog address setting to 127.0.01.

When the DNS lookup is made (probably a getaddrinfo() call) without a specified protocol, all addresses for all protocols are returned. Bacula would then choose one, likely the first one found. I'm not familiar with 16.04 LTS, but on most Linux systems, an IPv6 address will precede an IPv4 address. Also on most systems, both protocols are enabled and the name "localhost" is both 127.0.0.1 and ::1.

Is MariaDB configured to listen on ::1?

Can you access the bconsole when Dbaddress = ::1?

But I will try another thest with Ubuntu Server 16.04 LTS

Catalog {

   Name = MyCatalog

   Dbdriver = "dbi: mysql"

   Dbaddress = "localhost"

   Dbport = "3306"

   Dbname = "bacula"

   Dbuser = "bacula"

   Dbpassword = "bacula"

}

Best regards

Wanderlei Hüttel

http://www.huttel.com.br

2017-03-16 9:04 GMT-03:00 Erik P. Olsen <epodata AT gmail DOT com>:

On 2017-03-16 at 11:10:10 Richard wrote:

> > Date: Thursday, March 16, 2017 08:00:26 +0100
> > From: "Erik P. Olsen" <epodata AT gmail DOT com>
> >
> > On 2017-03-15 at 21:17:07 Dan Langille wrote:
> >
> >> > On Mar 14, 2017, at 2:42 AM, Erik P. Olsen <epodata AT gmail DOT com>
> >> > wrote:
> >> >
> >> > On 2017-03-13 at 22:52:04 Richard wrote:
> >> >
> >> >> What you have for privileges is what I would expect. My
> >> >> "grant_mysql_privileges" script has two lines - the first will
> >> >> do the "localhost" setup for the bacula user. Assuming that
> >> >> your script is lacking that, you might want to add it and try
> >> >> rerunning the script.
> >> >>
> >> >> grant all privileges on ${db_name}.* to ${db_user}@localhost
> >> >> ${pass}; grant all privileges on ${db_name}.* to ${db_user}@"%"
> >> >> ${pass};
> >> >
> >> >
> >> > In my script the lines are:
> >> >
> >> > use mysql
> >> > grant all privileges on ${db_name}.* to ${db_user}@localhost
> >> > ${pass} ${ssl_options};  grant all privileges on ${db_name}.* to
> >> > ${db_user}@"%" ${pass} ${ssl_options};  select * from user;
> >> > flush privileges;
> >> >
> >> > Ups, I now see that a semicolon is missing after "use mysql".
> >> > I'll add it and rerun the script:
> >> > Oh it won't let me do the "use mysql;" Access denied.
> >>
> >>
> >> Perhaps connect to mysql using the user name / password you have
> >> in the Catalog definition.
> >
> > [erik@Erik-PC ~]$ mysql bacula --user=bacula
> > ERROR 1044 (42000): Access denied for user ''@'localhost' to
> > database 'bacula' [erik@Erik-PC ~]$
> >
> > I am afraid it will never work :-(
>
> >From the output you provided, the "grant" script that you are running
> doesn't appear to be giving access permissions to bacula@localhost -
> though seems to be for bacula@%. You might just want to look at the
> bacula@% records and (manually) enter matching ones for
> bacula@localhost. I suspect that that will at least get you on to the
> next step.

MariaDB [(none)]> grant all privileges on bacula.* to bacula@localhost;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'bacula'
MariaDB [(none)]>

Apparently gets me nowhere.

------------------------------------------------------------------------------
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
[email protected].net
https://lists.sourceforge.net/lists/listinfo/bacula-users

------------------------------------------------------------------------------
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

------------------------------------------------------------------------------
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