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 [enter image
description here] <https://i.stack.imgur.com/uQqdb.png>
[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
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
