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 <epod...@gmail.com
<mailto:epod...@gmail.com>>:
On 2017-03-16 at 11:10:10 Richard wrote:
> > Date: Thursday, March 16, 2017 08:00:26 +0100
> > From: "Erik P. Olsen" <epod...@gmail.com
<mailto:epod...@gmail.com>>
> >
> > On 2017-03-15 at 21:17:07 Dan Langille wrote:
> >
> >> > On Mar 14, 2017, at 2:42 AM, Erik P. Olsen
<epod...@gmail.com <mailto:epod...@gmail.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
Bacula-users@lists.sourceforge.net
<mailto:Bacula-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/bacula-users
<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
