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.
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 list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
