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