>>>>> On Wed, 2 Aug 2023 12:21:49 -0400, Phil Stracchino said:
>
> On 8/2/23 11:12, Graham Dicker via Bacula-users wrote:
> > Hello
> >
> > I am installing Bacula 13.0.2 on Opensuse 15.5 and get this problem when I
> > run
> > grant_mysql_privileges:
> >
> > ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check
> > the
> > manual that corresponds to your MariaDB server version for the right syntax
> > to
> > use near '%{db_user}@"%"' at line 1
> >
> > Database version 10.6.14-MariaDB
> >
> > I guess it's complaining about the statement
> >
> > db_user=${db_user:-bacula}
> >
> > Can anyone help with this please?
>
>
> What does the line 'echo "Created MySQL database user: ${db_user}"'
> report as the value of ${db_user}?
It looks like a bug in the script to me (maybe % instead of $):
if $bindir/mysql $* -u root -f <<END-OF-DATA
use mysql
grant all privileges on ${db_name}.* to ${db_user}@"%" ${ssl_options};
grant process on *.* to %{db_user}@"%" ${ssl_options};
select * from user;
flush privileges;
END-OF-DATA
__Martin
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
