Re: [Bacula-users] Problem with grant_mysql_privileges
On Thursday, 3 August 2023 15:39:26 BST Phil Stracchino wrote:
> On 8/3/23 04:05, Graham Dicker via Bacula-users wrote:
> > On Thursday, 3 August 2023 08:35:39 BST Graham Dicker via Bacula-users
wrote:
> >> On Wednesday, 2 August 2023 17:21:49 BST Phil Stracchino wrote:
> >>> 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 reports just the single word bacula
> >>
> >> Graham
> >
> > It doesn't actually create the user bacula either although when I run the
> > script it says it has created it.
>
> Martin is correct that the second GRANT line is incorrect, it should be
> ${db_user} not %{db_user}
>
> Try doing this yourself manually. It's not complex. You know your
> MariaDB superuser password I assume. Log into MariaDB and run the
> following commands:
>
>
> GRANT ALL PRIVILEGES ON bacula@'HOST' IDENTIFIED BY "password goes here";
> GRANT PROCESS ON *.* TO bacula@'HOST';
> FLUSH PRIVILEGES;
>
>
> HOST here can be one of several things. The script uses '%', a wildcard
> meaning 'any host'. If your DB runs on the same host as your Director
> and will not be accessed from anywhere else, it would be more secure to
> use 'localhost' there. Or if you have a subnet behind a firewall and
> want to allow access from a range of hosts or all of your hosts, you can
> use something like bacula@'1.2.3.%'.
>
>
> Report any errors.
Yay!! It's working. Thanks very much Phil for your help. Much appreciated.
Graham
signature.asc
Description: This is a digitally signed message part.
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Problem with grant_mysql_privileges
On 8/3/23 04:05, Graham Dicker via Bacula-users wrote:
On Thursday, 3 August 2023 08:35:39 BST Graham Dicker via Bacula-users wrote:
On Wednesday, 2 August 2023 17:21:49 BST Phil Stracchino wrote:
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 reports just the single word bacula
Graham
It doesn't actually create the user bacula either although when I run the
script it says it has created it.
Martin is correct that the second GRANT line is incorrect, it should be
${db_user} not %{db_user}
Try doing this yourself manually. It's not complex. You know your
MariaDB superuser password I assume. Log into MariaDB and run the
following commands:
GRANT ALL PRIVILEGES ON bacula@'HOST' IDENTIFIED BY "password goes here";
GRANT PROCESS ON *.* TO bacula@'HOST';
FLUSH PRIVILEGES;
HOST here can be one of several things. The script uses '%', a wildcard
meaning 'any host'. If your DB runs on the same host as your Director
and will not be accessed from anywhere else, it would be more secure to
use 'localhost' there. Or if you have a subnet behind a firewall and
want to allow access from a range of hosts or all of your hosts, you can
use something like bacula@'1.2.3.%'.
Report any errors.
--
Phil Stracchino
Babylon Communications
ph...@caerllewys.net
p...@co.ordinate.org
Landline: +1.603.293.8485
Mobile: +1.603.998.6958
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Problem with grant_mysql_privileges
On Thursday, 3 August 2023 08:35:39 BST Graham Dicker via Bacula-users wrote:
> On Wednesday, 2 August 2023 17:21:49 BST Phil Stracchino wrote:
> > 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 reports just the single word bacula
>
> Graham
It doesn't actually create the user bacula either although when I run the
script it says it has created it.
signature.asc
Description: This is a digitally signed message part.
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Problem with grant_mysql_privileges
On Wednesday, 2 August 2023 17:21:49 BST Phil Stracchino wrote:
> 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 reports just the single word bacula
Graham
signature.asc
Description: This is a digitally signed message part.
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
