The bacula upgrade script fails for mariadb (and I assume mysql) databases that are running in the recomended ‘safe mode’.<\/p>\n
The script \/usr\/libexec\/bacula\/update_bacula_tables mysql<\/b> (basically runs update_mysql_tables) fails with the error Fortunately it is the last step in the upgrade script, only the command below fails.<\/p>\n And the workaround is simple<\/p>\n Now, an issue would be that at no point does it prompt for a userid or password.<\/p>\n It did highlight a rather major point that I had omitted to set a root password for mariadb on my bacula backup server, all the users had one but forgetting root… well that is fixed now; have run the mysql_secure_installation script which should have been run ages ago.<\/p>\n Which tends to imply that with a password set on the root mariadb user the script would fail anyway. <\/p>\n But as bacula is the best free<\/em> file level backup tool I have ever come across for linux I can live with the inconvenience of having it break every time a yum\/dnf update upgrades it to a new version; but it is a pain.<\/p>\n","protected":false},"excerpt":{"rendered":" The bacula upgrade script fails for mariadb (and I assume mysql) databases that are running in the recomended ‘safe mode’. The script \/usr\/libexec\/bacula\/update_bacula_tables mysql (basically runs update_mysql_tables) fails with the error You are using safe update mode and you tried … Continue reading
\nYou are using safe update mode and you tried to update a table without a WHERE that uses a KEY column<\/em><\/p>\n\r\nMariaDB [bacula]> UPDATE Version SET VersionId=15;\r\nERROR 1175 (HY000): You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column\r\n<\/pre>\n
\r\nMariaDB [bacula]> SET SQL_SAFE_UPDATES = 0;\r\nQuery OK, 0 rows affected (0.00 sec)\r\n\r\nMariaDB [bacula]> UPDATE Version SET VersionId=15;\r\nQuery OK, 1 row affected (0.04 sec)\r\nRows matched: 1 Changed: 1 Warnings: 0\r\n \r\nUPDATE Version SETSET SQL_SAFE_UPDATES = 1;\r\nQuery OK, 0 rows affected (0.00 sec)\r\n\r\nMariaDB [bacula]>quit\r\n\r\n[root@server7]# service mariadb restart\r\n<\/pre>\n