Order:
1) install bacula (this creates the database for you)
2) Delete DB Bacula
3) Create New DB Bacula
4) Import SQL (bacula.sql) of 5.2.3
5) Run:/opt/bacula/scripts/update_mysql_tables
It should work. My only doubt is that it is a strong jump from the 5X
directly to the 9X. I don't know if it is feasible.
In this case, I would have to go to 7 and then to 9.
I take this opportunity to indicate days ago I went from 9.6.7 to 11.0.6
(debian), then I had to run the update_tables script since the upgrade
process did not do it and I also had to correct the permissions of the
bacula user in postgres.
On Fri, May 6, 2022 at 9:19 PM Jack Chuong via Bacula-users <
bacula-users@lists.sourceforge.net> wrote:
> Hi all,
>
> Here my case : I want to migrate & upgrade bacula
>
> From Centos 7 Apache PHP 5.4 mariadb 5.5 bacula 5.2.3
>
> To Centos 8 Apache PHP 7.4 mysql 8.0 bacula 9.6.7
>
> What I did : Installed bacula 9.6.7 dir+sd+fd (RPM packages) on Centos 8
> Apache PHP 7.4 mysql 8.0 Run /opt/bacula/scripts/update_mysql_tables -uroot
> -p***
>
> It run ok
>
> This script will update a Bacula MySQL database from version 12-16 to 16
>
> Depending on the current version of your catalog, you may have to run this
> script multiple times.
>
> mysql: [Warning] Using a password on the command line interface can be
> insecure. mysql: [Warning] Using a password on the command line interface
> can be insecure.
>
> Update of Bacula MySQL tables 16 to 16 succeeded. mysql: [Warning] Using a
> password on the command line interface can be insecure.
>
> But when I start bacula services I see many error like this in
> /var/log/bacula/bacula.log
>
> JobId 0: Fatal error: bdb.h:142 bdb.h:142 query SELECT
> MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolType,VolParts,VolCloudParts,LastPartBytes,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,CacheRetention
> FROM Media WHERE PoolId=105 AND MediaType='File' AND (VolStatus IN ('Full',
> 'Append', 'Used') OR (VolStatus IN ('Recycle', 'Purged', 'Used') AND
> Recycle=1)) AND Enabled=1 ORDER BY LastWritten LIMIT 1 failed: Unknown
> column 'VolType' in 'field list'
>
> And bacula dir doesn't realize any volumes in any pools [image: enter
> image description here]
>
> [image: enter image description here]
>
>
> How can I fix it ? Please give me some advice thank you very much.
> *Disclaimer: This email and any files transmitted with it are confidential
> and intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify the
> system manager. This message contains confidential information and is
> intended only for the individual named. If you are not the named addressee
> you should not disseminate, distribute or copy this e-mail. Please notify
> the sender immediately by e-mail if you have received this e-mail by
> mistake and delete this e-mail from your system. If you are not the
> intended recipient you are notified that disclosing, copying, distributing
> or taking any action in reliance on the contents of this information is
> strictly prohibited. Thank you! *
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
--
#
# Sistema Operativo: Debian #
#Caracas, Venezuela #
#
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
