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