Hello Josh
I'm uploading a new server:
Distributor ID: Ubuntu
Description: Ubuntu 16.04.2 LTS
Release: 16.04
Codename: xenial
I will do the test
Best Regards
*Wanderlei Hüttel*
http://www.huttel.com.br
2017-03-16 10:13 GMT-03:00 Josh Fisher <jfis...@pvct.com>:
>
> 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>:
>
>> 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>
>> > >
>> > > 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>
>> > >> > 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
>> 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
> listBacula-users@lists.sourceforge.nethttps://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
