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 < [email protected]> 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] <https://i.stack.imgur.com/uQqdb.png> > > [image: enter image description here] > <https://i.stack.imgur.com/PaWSO.png> > > 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/bacula-users > -- ############################# # Sistema Operativo: Debian # # Caracas, Venezuela # #############################
_______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
