[Bacula-users] Accurate Mode Fails after "Upgrade"
I moved from using the downloaded Community Bacula to the Ubuntu packaged version, both 13.0.4. The difference is the downloaded uses /opt/bacula/etc while the packaged conf files are in /etc/bacula. The mysql database was not changed. After the switch client Full's worked, but incrementals and differentials which use Accurate Mode failed because bacula-fd gets "Fatal error: Cannot find previous jobids." Without accurate mode they succeed. The conf files I'm using in /etc/bacula are just copies of the ones from /opt where I have adjusted the path references. I did not copy the files where /opt pointed, just adjusted the paths in the conf files. That presumably is my mistake. So now I'm a week in using the packaged Bacula, most with Accurate turned off so that the incremental succeed. I noticed from mysql that Bacula created new FileSetId's for FULL (one for catalog, one for client backups). So how do I recover from this? I'm not sure which files I should have copied. For working the opt version uses /opt/bacula/working, the packaged uses /var/lib/bacula. The ones in the former are bacula-sd.9103.state bacula-fd.9102.state bacula-dir.9101.state BackupCatalog.bsr orac-fd.bsr The state files are close to the switch, the bsr's a few days earlier. I'm not aware of other path changes, but could have missed something. Are there any other files I missed? I just assumed it was all in the mysql tables. I would like to go back to using Accurate, so how do I recover? I'd like to use the existing backups, old and new (the volumes are all files, no devices), but it wouldn't be a tragedy to lose the old (there was also a move from Ubuntu 23.10 to 24.04, so many older files are not relevant) Any help? ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Fatal error: Cannot find previous jobids
I recently updated both the OS (Ubuntu 23.10 to 24.04), and switched from the community download of 13.0.4 to the Ubuntu 13.0.4 package that goes with 24.04 Backups of the Catalog and Full Client backups are working, but the incremental Client backups fail 05-Jun 23:05 orac-dir JobId 7830: Connected to Client "orac-fd" at orac:9102 wit h TLS 05-Jun 23:05 orac-fd JobId 7830: Connected to Storage at localhost:9103 with TLS 05-Jun 23:05 orac-dir JobId 7830: Fatal error: Cannot find previous jobids. 05-Jun 23:08 orac-dir JobId 7830: Fatal error: Network error with FD during Back up: ERR=Interrupted system call 05-Jun 23:09 orac-dir JobId 7830: Error: Director's connection to SD for this Jo b was lost. How can I fix this? ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Disk Volumes Showing 1B Read-Only
My Volumes are all Disk files. Several now show up as 1B Read-Only. In fact, as files "ls -l" shows them at their correct size, with modification dates that go back correctly to when they were filled. This is likely due to my transition from Ubuntu 23.10 to 24.04. There was a period during the transition where the file system containing these backup volumes was either not mounted or had ownerships set incorrectly. I'm guessing that bacula noticed that and marked those backup files 1B Read-Only. These files are the oldest of the backup files, the slightly more recent ones are fine. Is there any way to convince bacula that they are good? ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Pool Configuration
I have my pool set as 15 50GB files, with a 20 day retention, autoprune, recycle. Typically the oldest one is about 30 days old, and several of the oldest show no jobs on volume. Are those oldest volumes doing me any good with no jobs, just waiting for their time to be recycled? Should I adjust the parameters to make them more valuable? ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Permission Issues
x|grep sql here is my output from ps aux|grep bacula [gerber@NSF-rocky ~]$ ps aux|grep bacula apache 1541 0.0 0.0 11804 2908 ? S Jan28 1:20 /usr/sbin/lighttpd -f /etc/bacularis/bacularis-lighttpd.conf bacula 531384 0.6 0.0 602708 11236 ? Ssl Feb15 188:42 /opt/bacula/bin/bacula-sd -u bacula -g disk -v -c /opt/bacula/etc/bacula-sd.conf root 531394 0.7 0.0 676260 20728 ? Ssl Feb15 224:15 /opt/bacula/bin/bacula-fd -u root -g bacula -v -c /opt/bacula/etc/bacula-fd.conf bacula 531403 0.0 0.0 1351572 11952 ? Ssl Feb15 1:00 /opt/bacula/bin/bacula-dir -u bacula -g bacula -v -c /opt/bacula/etc/bacula-dir.conf gerber 3689255 0.0 0.0 221796 2296 pts/0 R+ 13:22 0:00 grep --color=auto bacula Regards, Robert Gerber 402-237-8692 r...@craeon.net On Wed, Mar 6, 2024 at 1:05 PM Ken Mandelberg wrote: I had to run 'ls -lah /opt/bacula/ /opt/bacula/working/ as root to get access to working: /opt/bacula/: total 44K drwxr-xr-x 11 root root 4.0K Jul 11 2023 . drwxr-xr-x 9 root root 4.0K Feb 12 12:33 .. drwx-- 2 bacula root 4.0K May 3 2023 archive drwxr-xr-x 2 root root 4.0K Oct 25 10:19 bin drwxr-x--- 2 bacula bacula 4.0K May 3 2023 bsr drwxr-x--- 2 bacula bacula 4.0K Oct 25 10:19 etc drwxr-xr-x 2 root root 4.0K Oct 25 10:19 lib drwxr-x--- 2 bacula adm 4.0K Aug 1 2023 log drwxr-xr-x 2 root root 4.0K Oct 25 10:19 plugins drwxr-xr-x 3 root root 4.0K Dec 28 11:35 scripts drwxr-x--- 3 bacula bacula 4.0K Mar 6 12:29 working /opt/bacula/working/: total 622M drwxr-x--- 3 bacula bacula 4.0K Mar 6 12:29 . drwxr-xr-x 11 root root 4.0K Jul 11 2023 .. -rw-r--r-- 1 root root 190 Jul 11 2023 BackupCatalog.bsr -rw-r- 1 bacula bacula 2.2K Mar 6 12:28 bacula-dir.9101.state -rw-r--r-- 1 root root 414 Jul 11 2023 bacula-dir.bacula-dir.-1636748120.mail -rw-r- 1 root root 2.2K Mar 6 12:28 bacula-fd.9102.state -rw-r- 1 bacula tape 5 Mar 6 12:29 bacula-sd.9103.pid -rw-r- 1 bacula tape 2.2K Mar 6 12:28 bacula-sd.9103.state -rw--- 1 bacula bacula 622M Mar 5 23:19 bacula.sql drwx-- 2 bacula root 4.0K May 3 2023 bkp -rw--- 1 bacula bacula 56 Mar 5 23:19 .my.cnf -rw--- 1 bacula bacula 0 Mar 6 12:07 orac-dir.conmsg -rw-r--r-- 1 bacula root 19K Mar 5 23:19 orac-fd.bsr Rob Gerber wrote on 3/6/24 13:57: I am concerned that these backups might not be successful (in the sense that they are quite probably not actually backing your catalog up). If the catalog export via "/opt/bacula/scripts/make_catalog_backup.pl <https://nam11.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmake_catalog_backup.pl%2F&data=05%7C02%7Ckm%40mathcs.emory.edu%7C9b08e759badf4275b09108dc3e13a9a3%7Ce004fb9cb0a4424fbcd0322606d5df38%7C0%7C0%7C638453501400200100%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=e67xHjx8emOTtV98f1mcnIwETeBacZULxJYciPuQEfo%3D&reserved=0> MyCatalog" is not successful and if bacula cannot access the bacula.sql file written to /opt/bacula/working/bacula.sql then I'd be very concerned that the backups did not succeed in their purpose. Obviously you likely hold said concern because you messaged the list. I just want to make that clear. While I don't know everything one would need to know to troubleshoot this issue, I want to check something: When you do an 'ls -lah /opt/bacula/ /opt/bacula/working/' what is your output? Robert Gerber 402-237-8692 r...@craeon.net On Wed, Mar 6, 2024, 12:29 PM Ken Mandelberg wrote: I I notice these two permission errors in my logs. I'm on Ubuntu. What do I need to do to correct them. The backups succeed but I guess they are missing info. 05-Mar 23:19 orac-dir JobId 7661: shell command: run BeforeJob "/opt/bacula/scripts/make_catalog_backup.pl <https://nam11.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmake_catalog_backup.pl%2F&data=05%7C02%7Ckm%40mathcs.emory.edu%7C9b08e759badf4275b09108dc3e13a9a3%7Ce004fb9cb0a4424fbcd0322606d5df38%7C0%7C0%7C638453501400200100%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=e67xHjx8emOTtV98f1mcnIwETeBacZULxJYciPuQEfo%3D&reserved=0> MyCatalog" 05-Mar 23:19 orac-dir JobId 7661: BeforeJob: mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces 05-Mar 23:19 orac-dir JobId 7661: Start Backup JobId 7661, Job=BackupCatalog.2024-03-05_23.10.00_05 05-Mar 23:19 orac-dir JobId 7661: Connected to St
Re: [Bacula-users] Permission Issues
I had to run 'ls -lah /opt/bacula/ /opt/bacula/working/ as root to get access to working: /opt/bacula/: total 44K drwxr-xr-x 11 root root 4.0K Jul 11 2023 . drwxr-xr-x 9 root root 4.0K Feb 12 12:33 .. drwx-- 2 bacula root 4.0K May 3 2023 archive drwxr-xr-x 2 root root 4.0K Oct 25 10:19 bin drwxr-x--- 2 bacula bacula 4.0K May 3 2023 bsr drwxr-x--- 2 bacula bacula 4.0K Oct 25 10:19 etc drwxr-xr-x 2 root root 4.0K Oct 25 10:19 lib drwxr-x--- 2 bacula adm 4.0K Aug 1 2023 log drwxr-xr-x 2 root root 4.0K Oct 25 10:19 plugins drwxr-xr-x 3 root root 4.0K Dec 28 11:35 scripts drwxr-x--- 3 bacula bacula 4.0K Mar 6 12:29 working /opt/bacula/working/: total 622M drwxr-x--- 3 bacula bacula 4.0K Mar 6 12:29 . drwxr-xr-x 11 root root 4.0K Jul 11 2023 .. -rw-r--r-- 1 root root 190 Jul 11 2023 BackupCatalog.bsr -rw-r- 1 bacula bacula 2.2K Mar 6 12:28 bacula-dir.9101.state -rw-r--r-- 1 root root 414 Jul 11 2023 bacula-dir.bacula-dir.-1636748120.mail -rw-r- 1 root root 2.2K Mar 6 12:28 bacula-fd.9102.state -rw-r- 1 bacula tape 5 Mar 6 12:29 bacula-sd.9103.pid -rw-r- 1 bacula tape 2.2K Mar 6 12:28 bacula-sd.9103.state -rw--- 1 bacula bacula 622M Mar 5 23:19 bacula.sql drwx-- 2 bacula root 4.0K May 3 2023 bkp -rw--- 1 bacula bacula 56 Mar 5 23:19 .my.cnf -rw--- 1 bacula bacula 0 Mar 6 12:07 orac-dir.conmsg -rw-r--r-- 1 bacula root 19K Mar 5 23:19 orac-fd.bsr Rob Gerber wrote on 3/6/24 13:57: I am concerned that these backups might not be successful (in the sense that they are quite probably not actually backing your catalog up). If the catalog export via "/opt/bacula/scripts/make_catalog_backup.pl <https://nam11.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmake_catalog_backup.pl%2F&data=05%7C02%7Ckm%40mathcs.emory.edu%7C5f4f45453a1e48ddc3e208dc3e0f5d81%7Ce004fb9cb0a4424fbcd0322606d5df38%7C0%7C0%7C638453482917134191%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=zYK5okl%2F2Zbm2EHPgxk3OF8dsy%2FpHnc12rpYWZg6bpg%3D&reserved=0> MyCatalog" is not successful and if bacula cannot access the bacula.sql file written to /opt/bacula/working/bacula.sql then I'd be very concerned that the backups did not succeed in their purpose. Obviously you likely hold said concern because you messaged the list. I just want to make that clear. While I don't know everything one would need to know to troubleshoot this issue, I want to check something: When you do an 'ls -lah /opt/bacula/ /opt/bacula/working/' what is your output? Robert Gerber 402-237-8692 r...@craeon.net On Wed, Mar 6, 2024, 12:29 PM Ken Mandelberg wrote: I I notice these two permission errors in my logs. I'm on Ubuntu. What do I need to do to correct them. The backups succeed but I guess they are missing info. 05-Mar 23:19 orac-dir JobId 7661: shell command: run BeforeJob "/opt/bacula/scripts/make_catalog_backup.pl <https://nam11.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmake_catalog_backup.pl%2F&data=05%7C02%7Ckm%40mathcs.emory.edu%7C5f4f45453a1e48ddc3e208dc3e0f5d81%7Ce004fb9cb0a4424fbcd0322606d5df38%7C0%7C0%7C638453482917134191%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=zYK5okl%2F2Zbm2EHPgxk3OF8dsy%2FpHnc12rpYWZg6bpg%3D&reserved=0> MyCatalog" 05-Mar 23:19 orac-dir JobId 7661: BeforeJob: mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces 05-Mar 23:19 orac-dir JobId 7661: Start Backup JobId 7661, Job=BackupCatalog.2024-03-05_23.10.00_05 05-Mar 23:19 orac-dir JobId 7661: Connected to Storage "File" at localhost:9103 with TLS 05-Mar 23:19 orac-dir JobId 7661: Using Device "FileStorage" to write. 05-Mar 23:19 orac-dir JobId 7661: Connected to Client "orac-fd" at orac:9102 with TLS 05-Mar 23:19 orac-fd JobId 7661: Connected to Storage at localhost:9103 with TLS 05-Mar 23:19 orac-sd JobId 7661: Volume "Vol0010" previously written, moving to end of data. 05-Mar 23:19 orac-sd JobId 7661: Ready to append to end of Volume "Vol0010" size=52,690,472,345 05-Mar 23:19 orac-sd JobId 7661: Elapsed time=00:00:02, Transfer rate=325.8 M Bytes/second 05-Mar 23:19 orac-sd JobId 7661: Sending spooled attrs to the Director. Despooling 233 bytes ... 05-Mar 23:19 orac-dir JobId 7661: Error: Could not open WriteBootstrap file: /opt/bacula/working/BackupCatalog.bsr: ERR=Permission denied 05-Mar 23:19 orac-dir JobId 7661: Error: Bacula Enterprise orac-dir 13.0.3 (02May23): Build OS: x86_64-pc-linux-gnu-bacula-enterprise ubuntu 22.04 ___
[Bacula-users] Permission Issues
I I notice these two permission errors in my logs. I'm on Ubuntu. What do I need to do to correct them. The backups succeed but I guess they are missing info. 05-Mar 23:19 orac-dir JobId 7661: shell command: run BeforeJob "/opt/bacula/scripts/make_catalog_backup.pl MyCatalog" 05-Mar 23:19 orac-dir JobId 7661: BeforeJob: mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces 05-Mar 23:19 orac-dir JobId 7661: Start Backup JobId 7661, Job=BackupCatalog.2024-03-05_23.10.00_05 05-Mar 23:19 orac-dir JobId 7661: Connected to Storage "File" at localhost:9103 with TLS 05-Mar 23:19 orac-dir JobId 7661: Using Device "FileStorage" to write. 05-Mar 23:19 orac-dir JobId 7661: Connected to Client "orac-fd" at orac:9102 with TLS 05-Mar 23:19 orac-fd JobId 7661: Connected to Storage at localhost:9103 with TLS 05-Mar 23:19 orac-sd JobId 7661: Volume "Vol0010" previously written, moving to end of data. 05-Mar 23:19 orac-sd JobId 7661: Ready to append to end of Volume "Vol0010" size=52,690,472,345 05-Mar 23:19 orac-sd JobId 7661: Elapsed time=00:00:02, Transfer rate=325.8 M Bytes/second 05-Mar 23:19 orac-sd JobId 7661: Sending spooled attrs to the Director. Despooling 233 bytes ... 05-Mar 23:19 orac-dir JobId 7661: Error: Could not open WriteBootstrap file: /opt/bacula/working/BackupCatalog.bsr: ERR=Permission denied 05-Mar 23:19 orac-dir JobId 7661: Error: Bacula Enterprise orac-dir 13.0.3 (02May23): Build OS: x86_64-pc-linux-gnu-bacula-enterprise ubuntu 22.04 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula Community Installation UPGRADE
The suggestion below which is essentially to run "update_mysql_tables" manually instead of within the "apt-get install bacula-mysql" runs into the same issue. Specifically Update of Bacula MySQL tables from 16 to 1017 succeeded. Update of Bacula MySQL tables from 1017 to 1018 succeeded. Update of Bacula MySQL tables 1018 to 1019 succeeded. (From 16) Update of Bacula MySQL tables 1019 to 1020 succeeded. Update of Bacula MySQL tables 1020 to 1021 succeeded. ERROR 1050 (42S01) at line 3: Table 'TagJob' already exists Update of Bacula MySQL tables 1021 to 1022 failed. I also tried deleting TagJob and starting again, and then it just moves on to the next table that already exists. In fact I deleted all the Tag* tables, and that it complains about the Object table. I suspect it won't like any. Any ideas? On 7/4/23 19:48, Ken Mandelberg wrote: > Another followup. One thing I learned, I need to remove all the Ubuntu > bundled bacula 9 packages before doing? the apt-get install bacula-mysql > for the Community 13 release, otherwise there are package conflicts. > > So after removing the old packages, apt-get install bacula-mysql tires > to install the mysql bacula database. It gets caught at > > mysql said: ERROR 1050 (42S01) at line 9: Table 'TagJob' already exists > > I imagine if I removed that table it would just get caught at the next one. > > Its not really clear on how to proceed preserving the current database 9 > info and letting 13 do the update job. OK, try this. - DUMP the bacula schema using mysqldump or your database dump tool of choice. (Personally I prefer mydumper.) - Then DROP the bacula DB. - Then run apt-get install bacula-mysql. - You MIGHT need to drop the bacula schema *again* at this point. to be safe. - Then RESTORE the bacula schema from your dump. - Then run update_mysql_tables to update your v9 Bacula DB to v13. ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula Community Installation UPGRADE
Another followup. One thing I learned, I need to remove all the Ubuntu bundled bacula 9 packages before doing the apt-get install bacula-mysql for the Community 13 release, otherwise there are package conflicts. So after removing the old packages, apt-get install bacula-mysql tires to install the mysql bacula database. It gets caught at mysql said: ERROR 1050 (42S01) at line 9: Table 'TagJob' already exists I imagine if I removed that table it would just get caught at the next one. Its not really clear on how to proceed preserving the current database 9 info and letting 13 do the update job. Ken Mandelberg wrote on 7/1/23 18:30: This is a followup of my previous posts. I'm doing an upgrade from Bacula 9 to 13 on Ubuntu 23.04. I realize there is no specific support for 23.04 so I'm making believe I'm on Jammy. I've gotten past the apt-key issue and sources are set up, and apt-get update has succeeded. Now my question is about the next step dealing with the fact that this is an upgrade of a working Bacula 9 installation. (Don't worry, its really on a test machine before I try it on a production machine). So I know I need to copy /etc/bacula to a safe place. Should I also delete it? I will also stop director , sd, and fd. and move those binaries out of the way. I'm running mysql. Should I do anything there to the existing bacula data base? Assuming the answers to those the next stop is apt-get install bacula-mysql I would assume I then copy back the saved /etc/bacula back in place and then start the new binaries. What about updating the mysql tables from 9 to 13? Where does that happen. Sorry for all the needy questions. This is my first time not using the bundled Ubuntu package support for Bacula which handles updates transparently. Debian/Ubuntu has no Bacula maintainer now. --- Side issue about the Documentation, what is the "concatenate" note about. It makes no sense, deb would just be an ignored comment. Complete example: #Bacula Community deb [arch=amd64] https://www.bacula.org/packages/abc123defxxxyyy/debs/13.0.1 xenial main Note 1: please concatenate the last 2 lines into 1 line. ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula Community Installation UPGRADE
This is a followup of my previous posts. I'm doing an upgrade from Bacula 9 to 13 on Ubuntu 23.04. I realize there is no specific support for 23.04 so I'm making believe I'm on Jammy. I've gotten past the apt-key issue and sources are set up, and apt-get update has succeeded. Now my question is about the next step dealing with the fact that this is an upgrade of a working Bacula 9 installation. (Don't worry, its really on a test machine before I try it on a production machine). So I know I need to copy /etc/bacula to a safe place. Should I also delete it? I will also stop director , sd, and fd. and move those binaries out of the way. I'm running mysql. Should I do anything there to the existing bacula data base? Assuming the answers to those the next stop is apt-get install bacula-mysql I would assume I then copy back the saved /etc/bacula back in place and then start the new binaries. What about updating the mysql tables from 9 to 13? Where does that happen. Sorry for all the needy questions. This is my first time not using the bundled Ubuntu package support for Bacula which handles updates transparently. Debian/Ubuntu has no Bacula maintainer now. --- Side issue about the Documentation, what is the "concatenate" note about. It makes no sense, deb would just be an ignored comment. Complete example: #Bacula Community deb [arch=amd64] https://www.bacula.org/packages/abc123defxxxyyy/debs/13.0.1 xenial main Note 1: please concatenate the last 2 lines into 1 line. ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula Community Installation Guide
Ben Thanks! I now have the access key. But going forward another obstacle. I'm running Ubuntu 23.04 Lunar Lobster. apt-key is no longer available in 23.04, so the instructions for importing the GPG key won't work. Is there a simple replacement, and maybe more to the point if I get as far as "deb" for sources, will the repository have Lunar? Ken Ben Tyger wrote on 6/30/23 12:12: https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.bacula.org%2Fbacula-binary-package-download%2F&data=05%7C01%7Ckm%40mathcs.emory.edu%7Ccf20eaabdd404567f8b408db7984dc88%7Ce004fb9cb0a4424fbcd0322606d5df38%7C0%7C0%7C638237383887165100%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=b2k4q2Gw622smLbaKpbvlZxcoxkF6eHlaCqk%2BsJgdag%3D&reserved=0 is the registration page. You'll get the specialized link in your e-mail On 6/30/23 11:27, Ken Mandelberg wrote: I'm trying to use the instructions for installing the community version binaries for Bacula 13 on Ubuntu. https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.bacula.org%2Fwhitepapers%2FCommunityInstallationGuide.pdf&data=05%7C01%7Ckm%40mathcs.emory.edu%7Ccf20eaabdd404567f8b408db7984dc88%7Ce004fb9cb0a4424fbcd0322606d5df38%7C0%7C0%7C638237383887165100%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=Q5lKyN1XZJHNI%2BjCJJU66hC6uSC7qSRzqOQsf4661hM%3D&reserved=0 To get started setting up sources for apt it needs an access key which it says "This is the trailing path component sent in the registration email". I can't find any place to register for the community version which should be free. Any ideas? ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fbacula-users&data=05%7C01%7Ckm%40mathcs.emory.edu%7Ccf20eaabdd404567f8b408db7984dc88%7Ce004fb9cb0a4424fbcd0322606d5df38%7C0%7C0%7C638237383887165100%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=6UXvNFZgmFnVZcDJGG4QQB5iLXmrEhCHyO24kcMxr4E%3D&reserved=0 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula Community Installation Guide
I'm trying to use the instructions for installing the community version binaries for Bacula 13 on Ubuntu. https://www.bacula.org/whitepapers/CommunityInstallationGuide.pdf To get started setting up sources for apt it needs an access key which it says "This is the trailing path component sent in the registration email". I can't find any place to register for the community version which should be free. Any ideas? ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Upgrading Bacula 9 to 13 on Ubuntu?
I've been running Community Bacula for many years on Ubuntu via the bundled Universe repository. That's currently at 9.6.7 and not likely to increase in the Ubuntu bundle. How do I upgrade this to 13? Which repository, what upgrade tools? ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] bacularis data table error
I get DataTables warning: table id=job_list - Requested unknown parameter 'filetable' for row 0, column 30. For more information about this error, please see http://datatables.net/tn/4 I don't see a job_list table in the mysql bacula database. There are | Job | | JobHisto | | JobMedia | no job_list. ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] bconsole on bacularis?
I get stuck configuring with the wizard with Problem with connection to bconsole. Output=>sudo: a terminal is required to read the password; either use the -S >option to read from standard input or configure an askpass helper sudo: a password is required, Exitcode=>1 Not clear to where the -S option should be set. ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacularis on Ubuntu 23.04?
I'm running Ubuntu 23.04 and want to install bacularis. Bacula itself is running, but there is no repository package beyond 22.04. Any workaround? ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] List all versions of a file?
Is there a way to list all versions of a file including metadata? ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] OneDrive and Google Drive?
Will there ever be support for either OneDrive or Google Drive directly in the community edition? ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] How to list all versions of a particular file
I would like to list all the versions of a particular file, with associated meta data (at least the size). Is there a way to do this? ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] MS One Drive or Google Drive?
Is there any plan for supporting cloud backup to either Microsoft One Drive or Google Drive in the community version? ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] [External] Re: Volume Corruption?
Actually, I have been doing that in "bat" which has the same options update volume. This has allowed the oldest to get recycled as needed. However, the content of the files are no longer represented in the catalog, and would be unavailable in a recover. Do I need to scan them into the catalog? Martin Simmons wrote on 6/8/22 13:26: To fix a volume, you could use the "update volume" command in bconsole and change the Volume Status to Full. That should allow the volume to be recycled as normal. BTW, the default config writes logs into a file called "bacula.log" in the Director's working directory and also into the catalog. __Martin On Wed, 8 Jun 2022 12:50:56 -0400, Ken Mandelberg said: It doesn't look like have logs covering that period. At any rate my concern is just recovering the volumes like Vol0005. I ran bls on it, and it seems to show the file is fine. How do I get it back into the catalog? Martin Simmons wrote on 6/8/22 05:46: On Tue, 7 Jun 2022 19:09:38 -0400, Ken Mandelberg said: I run bacula with file volumes not tapes. Recently several volumes may have gotten corrupted. Here are 3 examples Vol0001 Read-Only File 2022-06-01 2:22:42 34.0GB Vol0004 Full File 2022-05-26 2:11:09 53.6GB Vol0005 Read-Only File 2022-04-03 2:41:19 1B Vol 4 is seemingly ok, but vol 1 and 5 got changed to Read-Only and 5 shows no 1B, although it size on the filesystem is 50GB. There are several like Vol 5. Are they lost for good or is there some way to resurrect them? Bacula sets the Read-Only status in the catalog if gets EACCES or EROFS from the OS when trying to open the volume for writing. I suggest looking in the Bacula log for messages like: Marking Volume "Vol0005" Read-Only in Catalog. Then look for other logs from around that time to see why it might have done that. __Martin ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Volume Corruption?
It doesn't look like have logs covering that period. At any rate my concern is just recovering the volumes like Vol0005. I ran bls on it, and it seems to show the file is fine. How do I get it back into the catalog? Martin Simmons wrote on 6/8/22 05:46: On Tue, 7 Jun 2022 19:09:38 -0400, Ken Mandelberg said: I run bacula with file volumes not tapes. Recently several volumes may have gotten corrupted. Here are 3 examples Vol0001 Read-Only File 2022-06-01 2:22:42 34.0GB Vol0004 Full File 2022-05-26 2:11:09 53.6GB Vol0005 Read-Only File 2022-04-03 2:41:19 1B Vol 4 is seemingly ok, but vol 1 and 5 got changed to Read-Only and 5 shows no 1B, although it size on the filesystem is 50GB. There are several like Vol 5. Are they lost for good or is there some way to resurrect them? Bacula sets the Read-Only status in the catalog if gets EACCES or EROFS from the OS when trying to open the volume for writing. I suggest looking in the Bacula log for messages like: Marking Volume "Vol0005" Read-Only in Catalog. Then look for other logs from around that time to see why it might have done that. __Martin ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Volume Corruption?
I run bacula with file volumes not tapes. Recently several volumes may have gotten corrupted. Here are 3 examples Vol0001 Read-Only File 2022-06-01 2:22:42 34.0GB Vol0004 Full File 2022-05-26 2:11:09 53.6GB Vol0005 Read-Only File 2022-04-03 2:41:19 1B Vol 4 is seemingly ok, but vol 1 and 5 got changed to Read-Only and 5 shows no 1B, although it size on the filesystem is 50GB. There are several like Vol 5. Are they lost for good or is there some way to resurrect them? ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] bacula-fd missing on Ubuntu 22.04 (Jammy)
After an update from Ubuntu 21.10 to 22.04 bacula-fd was missing. There are packages for the director and sd, but no fd. Any help? ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Retention Period
I'm using files for Volumes, not tapes. Originally I was doing 90 day retention, but since then the amount of data to backup has increased, and I don't want to commit more file volumes (I have 13 *50G ). The backups stop when the files are full and the soonest expiration date hasn't been reached. I tried changed the setting in the director.conf for the client to File Retention = 30 days # 30 days Job Retention = 45 days AutoPrune = yes # Prune expired Jobs/Files } I have rebooted the client (its all localhost) and the files still show 90 day expirations , all full and the jobs don't run. To get things running, I can manually purge the oldest, but when it starts writing to it, I still see the 90 days expiration date. I don't actually care about the limit. I have as many volumes as I want to commit, and just want it to purge what ever is necessary when they are all filled. What do I need to do? ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Label Command Error
My problem with the label command comes down do this, the INSERT into the Media Record fails since FirstWritten doesn't have a default value. Details below. From very old posting this seems to be an incompatibility with newer Mysql that doesnt want NULL values. For the record, I'm running Bacula 9.0.6 and Mysql 5.7 both of which are the defaults on Ubuntu 18.04. Suggestions? The failing INSERT: 14-Mar 15:55 orac-dir JobId 3992: Error: sql_create.c:439 Create DB Media record INSERT INTO Media (VolumeName,MediaType,MediaTypeId,PoolId,MaxVolBytes,VolCapacityBytes,Recycle,VolRetention,VolUseDuration,M axVolJobs,MaxVolFiles,VolStatus,Slot,VolBytes,InChanger,VolReadTime,VolWriteTime,VolType,VolParts,VolCloudParts,LastPartBytes,EndFile,EndBlock,LabelType,StorageId,DeviceId,LocationId,ScratchPoolId,RecyclePo olId,Enabled,ActionOnPurge,CacheRetention)VALUES ('Vol0013','File',0,2,53687091200,0,1,7776000,0,0,0,'Append',0,0,0,0,0,0,0,0,'0',0,0,0,1,0,0,0,0,1,0,0) failed. ERR=Field 'FirstWritten' doesn't have a default value ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Problem Adding File Volume
I have a File Pool with 9 volumes (50GB each) Vol0004-Vol0012. I want to add an additional volume of the same size to the Pool. I thought this was done with the label command, but I must be missing something. The filesystem shows rw-r--r-- 1 bacula tape 53687065427 Mar 7 23:05 Vol0004 -rw-r--r-- 1 bacula tape 53687075347 Jan 28 23:07 Vol0005 -rw-r--r-- 1 bacula tape 54643600598 Mar 4 00:18 Vol0006 -rw-r--r-- 1 bacula tape 53687078088 Jan 19 23:05 Vol0007 -rw-r--r-- 1 bacula tape 53687085250 Mar 3 10:58 Vol0008 -rw-r--r-- 1 bacula tape 53687066869 Mar 3 10:21 Vol0009 -rw-r- 1 bacula tape 53687047492 Feb 4 00:08 Vol0010 -rw-r- 1 bacula tape 53687036466 Mar 3 11:39 Vol0011 -rw-r- 1 bacula tape 5368707 Feb 4 01:05 Vol0012 -rw-r- 1 bacula tape 213 Mar 10 10:50 Vol0013 but list media only show the old volumes. What am I missing? ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Incorrect datetime value after Bionic Update
Phil Stracchino wrote on 05/05/2018 01:22 PM: At this point your best course of action might be to stop Bacula, drop and recreate your Bacula database, then restart Bacula. What I actually did was drop the bacula database and recreate it from /var/lib/bacula/bacula.sql. That was post upgrade, but the Media table was good. As it turned out the only thing that actually was not done by the update_mysql_tables script originally was the updates to Media, presumably because the running copy was bad. All is working now, By the way, I wonder if the sql-mode change was necessary, the update_mysql_table has a whole bunch of DROP DEFAULT for the time and date columns for Mysql 5.7. Phil, thanks for your help! Lesson learned, I'll be looking into backing up mysql properly. Ken -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Incorrect datetime value after Bionic Update
Phil Stracchino wrote on 05/05/2018 12:48 PM: I would definitely restore the Bacula database from a recent DB dump (you *do* run regular DB dumps, right...?) and rerun the upgrade script. Meaculpa, if its not a default I don't do it. All I'm aware of is the two jobs, the catalog and the files job. -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Incorrect datetime value after Bionic Update
Phil Stracchino wrote on 05/04/2018 03:03 PM: On 05/04/18 14:58, Ken Mandelberg wrote: [...] Looking at the script it should have added these fields but didn't. I wonder if that was because I ran it before the zero date issue was fixed. That is very likely the problem. Any suggestion on how to recover? The VersionId does show 16, so the script is not going to re-run as is. Can you restore a previous-to-upgrade version of the database from a backup and re-run the upgrade script? Well the backup I was counting on doesn't exist. I Duplicated the Ubuntu 16.04 filesystem in another slice before doing the OS upgrade, assuming I would have a copy of everything pre-update. It was a big surprise to find that the update updated both the live slice and the backup slice to 18.04. Furthermore looking at the mysql bacula database post install, it looks corrupted. See below. I didn't do anything that isn't default for a mysql or a bacula saved copy of the mysql bacula database. Presumably I can extract one from the volumes (which are actually files not tapes). I could use some advise on how to do that. I had planned just to fix up the database I had by manually doing what the update script does, but when I ran into what must be corruption shown below, it seems like I should start over from a backup. mysql> use bacula; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +--+ | Tables_in_bacula | +--+ | BaseFiles | | CDImages | | Client | | Counters | | Device | | File | | FileSet | | Filename | | Job | | JobHisto | | JobMedia | | Location | | LocationLog | | Log | | Media | | MediaType | | Path | | PathHierarchy | | PathVisibility | | Pool | | RestoreObject | | Status | | Storage | | UnsavedFiles | | Version | +--+ 25 rows in set (0.00 sec) mysql> describe Media; ERROR 1146 (42S02): Table 'bacula.Media' doesn't exist (I haven't tried them all, but many of the other tables exist). -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Incorrect datetime value after Bionic Update
Phil Stracchino wrote on 05/04/2018 01:57 PM: On 05/04/18 12:09, Ken Mandelberg wrote: With this mysqld always fails apparently with 018-05-04T15:55:57.823432Z 0 [ERROR] unknown variable 'SQL_MODE=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' That looks correct to me. Try making sql_mode lower case. And just out of constructive paranoia, don't copy and paste, retype the line by hand just to be certain there are no weird non-printing characters in there. Actually, going to lower case was enough. One problem solved! Aside from the startup problem, with sql_mode set dynamically to avoid the zero date issue, I still have another one. Bacula does a QUERY to Media with a large number of fields which includes VolType, but gets Unknown column 'VolType' in 'field list' You HAVE run the Bacula table upgrade script, right? From my original post -- I did a Ubuntu update from 16.04 to 18.04. The automatic Bacula update as part of the OS upgrade partially failed. After the upgrade I found myself with bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 14 So I ran /usr/share/bacula-director/update_mysql_tables I had to change db_name in the script to "bacula", but it seemed to have worked and the the director was able to start - I hope I ran the right script. To be honest I was surprised the only copy was in /usr/share and that I had to hand edit the db_name to 'bacula" in the script. It did change from 14 to 16. The Query to Media has a long list of fields and comparing the query to fields in the Media Table I see 7 missing fields: VolType,VolHoles,VolHoleBytes, VolABytes,VolCloudParts,LastPart,LastPartBytes. Looking at the script it should have added these fields but didn't. I wonder if that was because I ran it before the zero date issue was fixed. Any suggestion on how to recover? The VersionId does show 16, so the script is not going to re-run as is. -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Incorrect datetime value after Bionic Update
Phil, thanks! However, still two issues. bacula-users-requ...@lists.sourceforge.net wrote on 05/03/2018 05:33 AM: On 04/30/18 09:43, Ken Mandelberg wrote: I did a Ubuntu update from 16.04 to 18.04. The automatic Bacula update as part of the OS upgrade partially failed. After the upgrade I found myself with bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 14 So I ran /usr/share/bacula-director/update_mysql_tables I had to change db_name in the script to "bacula", but it seemed to have worked and the the director was able to start. However, when it was time for its first backup job 29-Apr 23:05 orac-dir JobId 0: Fatal error: sql_create.c:84 Create DB Job record INSERT INTO Job (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId,Comment) VALUES ('BackupClient1.2018-04-29_23.05.00_03','BackupClient1','B','D','C','2018-04-29 23:05:00',1525057500,1,'') failed. ERR=Incorrect datetime value: '-00-00 00:00:00' for column 'StartTime' at row 1 This most likely means that Ubuntu 18.04 updated you to MySQL 5.7 or its MariaDB equivalent (10.2.x). Yes mysql 5.7.22 Find your MySQL/MariaDB configuration file[s] and look for the line that sets SQL_MODE. (There may not be one, especially if you've never tuned it.) Log into MySQL and run this query: SELECT @@GLOBAL.sql_mode; Take the result, REMOVE the terms NO_ZERO_DATE and NO_ZERO_IN_DATE, and set what is left as your new SQL_MODE. For example: SET GLOBAL sql_mode = 'STRICT_ALL_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; (If in doubt, the above example is a good starting point.) This worked in my case SET GLOBAL sql_mode ='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' Add a line to your MySQL configuration setting the same, so that it will persist across restarts: This should get you up and running. You probably want to restart Bacula just to be safe. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 SQL_MODE = STRICT_ALL_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION (This goes in the [mysqld] section) Had a problem with this. I added to /etc/mysql/mysql.conf/mysqld.conf. Here is a few lines [mysqld] # # * Basic Settings SQL_MODE = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO _AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION # user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock With this mysqld always fails apparently with 018-05-04T15:55:57.823432Z 0 [ERROR] unknown variable 'SQL_MODE=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' Aside from the startup problem, with sql_mode set dynamically to avoid the zero date issue, I still have another one. Bacula does a QUERY to Media with a large number of fields which includes VolType, but gets Unknown column 'VolType' in 'field list' -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Incorrect datetime value after Bionic Update
I did a Ubuntu update from 16.04 to 18.04. The automatic Bacula update as part of the OS upgrade partially failed. After the upgrade I found myself with bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 14 So I ran /usr/share/bacula-director/update_mysql_tables I had to change db_name in the script to "bacula", but it seemed to have worked and the the director was able to start. However, when it was time for its first backup job 29-Apr 23:05 orac-dir JobId 0: Fatal error: sql_create.c:84 Create DB Job record INSERT INTO Job (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId,Comment) VALUES ('BackupClient1.2018-04-29_23.05.00_03','BackupClient1','B','D','C','2018-04-29 23:05:00',1525057500,1,'') failed. ERR=Incorrect datetime value: '-00-00 00:00:00' for column 'StartTime' at row 1 29-Apr 23:10 orac-dir JobId 0: Fatal error: sql_create.c:84 Create DB Job record INSERT INTO Job (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId,Comment) VALUES ('BackupCatalog.2018-04-29_23.10.00_04','BackupCatalog','B','F','C','2018-04-29 23:10:00',1525057800,1,'') failed. ERR=Incorrect datetime value: '-00-00 00:00:00' for column 'StartTime' at row 1 The new version is Version: 9.0.6 (20 November 2017). Not sure what the old version was. -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Cloud Storage?
On 03/15/2018 09:06 AM, Radosław Korzeniewski wrote: Hello, 2018-03-13 14:49 GMT+01:00 Ken Mandelberg <mailto:k...@mathcs.emory.edu>>: Is there anything new in using Bacula with Cloud Storage? I was under the impression that a feature was being added to the commercial version (perhaps an S3 interface) There are two interfaces available now: S3 and Azure. :) I presume you mean they are available on the commercial version. Is there any news on it coming to the community version? -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Cloud Storage?
Is there anything new in using Bacula with Cloud Storage? I was under the impression that a feature was being added to the commercial version (perhaps an S3 interface) which might make its way into a future open source release. -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] restore a fiile tree to a specific date?
I accidentally deleted a large file tree that changes a lot. Fortunately there was a backup this morning. I used restore option 5 Select item: (1-13): 5 Automatically selected Client: orac-fd The defined FileSet resources are: 1: Catalog 2: Full Set Select FileSet resource (1-2): 2 +---+---+---++-++ | JobId | Level | JobFiles | JobBytes | StartTime | VolumeName | +---+---+---++-++ | 3,059 | F | 1,232,312 | 78,986,824,929 | 2017-12-03 23:05:03 | Vol0005| | 3,059 | F | 1,232,312 | 78,986,824,929 | 2017-12-03 23:05:03 | Vol0010| | 3,059 | F | 1,232,312 | 78,986,824,929 | 2017-12-03 23:05:03 | Vol0012| | 3,115 | D | 128,364 | 11,738,624,538 | 2017-12-31 23:05:02 | Vol0011| +---+---+---++-++ You have selected the following JobIds: 3059,3115 I navigated and marked the top of the appropriate tree, and initiated the restore which worked. However, it looks bigger than the original that was there this morning. I presume its restoring files that had been deleted. Is that the case, and if so is there a way to get it to restore it to exactly the state at the time of the 12-31 backup? -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Restore from offline disk files
A given job can backup to multiple disk files (volumes). When restoring a file, Bacula knows what volumes were used by the backup jobid. Does it also know which volumes are needed to restore a given file, or does it want all the volumes associated with the jobid and just seek through them looking for the file it is restoring? I guess I'm asking if all the volumes associated with the backup jobid have to be made accessible before the restore? It may not make much difference on an incremental, but if the file being restored is on a full that may be a lot. The issue is that retrieving the offline disk volumes is slow and and it would be nice to not retrieve unnecessary ones. -- What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. http://sdm.link/zohodev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Backups to Google Drive?
bacula-users-requ...@lists.sourceforge.net wrote on 07/28/2016 07:34 AM: > How fast? We have a 10gbit connection from the server to campus backbone which has multiple 10gbit connections to the internet. In practice 1-2 gbits of throughput to google drive. We rarely exceed that to tape. > Bacula expects its TCP connections to stay up for the entire job Again, I don't think a fuse/google-drive solution is robust enough. I also don't think keeping the connection up during collection, compression, encryption is feasible. Transfer would be done at the end. The idea would be treating the storage pool like a virtual tape drive with a limited number of slots. Unmounting a volume means copy it out to the network. Mounting a volume means copying it back. Once a volume is unmounted its marked read/only. This would be for write once read rarely for anything unmounted. Fast for recent files, painful for older files. Just wondered if anyone had tried anything like this. Maybe there is different backup software that would be a better fit. -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Backups to Google Drive?
What is the current thinking of the most effective way to use Bacula doing storage to Google Drive? We have a fast network connection, with multi-terabyte Linux systems to regularly backup. I don't think any of the Linux fuse filesystems for Google Drive are really robust enough to depend on. If you agree, that just leaves writing to local storage and doing a command line transfer at the end, and the reverse for restores. Is there any support for managing the transfers (both backup and restore) without manual interaction? -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Adding Encryption and Compression
I've been doing bacula backups to disk file volumes for some time, basically with defaults. I'm now thinking of doing cloud backup of the volume files, and it strikes me that I should enable encryption and compression on the bacula client. Can I add those options to the the fd config, and assume it will start using them as the volumes recycle. Will it know how to deal with the mix of volumes with and without on restore? -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] moving bacula
I switched to an updated Ubuntu on a different partition. mysql-server and bacula are reinstalled, but I moved /var/lib/mysql and /etc/bacula. The hostname is the same, and a manual invocation of mysql client shows the bacula database as expected. However, the bacula director doesn't start and fails with. 25-May 20:21 bacula-dir JobId 0: Fatal error: Could not open Catalog "MyCatalog", database "". 25-May 20:21 bacula-dir JobId 0: Fatal error: mysql.c:210 Unable to connect to MySQL server. Database= User= MySQL connect failed either server not running or your authorization is incorrect. What am I missing? If there was a password wouldn't it have moved with /var/lib/mysql and the /etc/bacula/* config files? -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] ibdata1
My ibdata1 file is currently at almost a GB. As far as I know Bacula is the only thing using mysql on my workstation. Is this size normal? I've seen generic mysql postings about ibdata1 expanding because of bad transactions and the inability to shrink it. I'm not sure how this fits in with Bacula. Advise? -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] restoring a directory recursively as of a specific date
None of the restore options do what I think would be a common need, ie to restore a directory recursively as it existed on a certain date. Am I missing something? -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Changing Retention Periods
I've tried both suggestions given here update pool from resource update all volumes in pool which shows the lower period, but "list media" still has the old retention period. and the more interactive bconsole update .. which had the same result. So I ended up doing update Volume=Vol0001 which did let me select Volume Retention Period and it did take effect. Now Vol0001 shows an expiration date that has passed, what else do I need to do to be sure I can safely remove the Vol0001 file? -- October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Changing Retention Periods
John Drescher wrote, On 10/16/2013 08:19 AM: > > Remember that the pool resource in bacula is just a template on how to > create new volumes. Changing anything in that resource does not apply > to volumes that already exist. To fix you need to run 2 commands in > bconsole. They should be similar to the following ( I am going from > memory here ): > > update pool from resource > > update all volumes in pool > > John > I ran the two commands and got output that showed the new volume retention time and "Pool DB record updated from resource." after each. However, when I run "list media", I still see the old retention. Will this update after the next backup? -- October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Changing Retention Periods
I've lowered my File, Job, and Volume retention periods in bacula-dir.conf, and restarted bacula-director. I'm not sure about File and Job but after one backup the existing older Full Volumes still show the old retention period. What do I need to do to get the old volumes to recycle and the database to adjust to the lower File and Job periods. By the way, these volumes are not tapes, they are just files and I want to delete ones that are marked recycle. -- October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Expiration of Backup Volumes on DIsk
I don't backup to tape, just disk. When a Volume hits its expiration what happens? Is the Volume erased, or overwritten as needed? -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula and Glacier
The last time I asked about this there was skepticism about using Amazon Glacier for cloud storage of backups generated by Bacula. I still have some interest in this particularly for off site backups for disaster recovery at least for occasional snapshots. Has anyone actually had success using Glacier with Bacula? I have done some minimal tests using https://github.com/uskudnik/amazon-glacier-cmd-interface/blob/master/doc/Scripting.rst It's not very usable for daily backups as is. The backup volumes get appended to until they reach their maximum and would be sent repeatedly until they hit the max and a new volume is created. If I got around this by some how forcing a new volume each time it would result in small files being sent to Glacier, which is not desirable. I suppose I could decouple the Glacier send from the Bacula director and just send finished volumes when a cron sees that a new one has been created. At any rate, just wondering if anyone is using Bacula with Glacier and how. -- Get 100% visibility into Java/.NET code with AppDynamics Lite It's a free troubleshooting tool designed for production Get down to code-level detail for bottlenecks, with <2% overhead. Download for free and get started troubleshooting in minutes. http://p.sf.net/sfu/appdyn_d2d_ap2 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula with Glacier?
Is anyone using Bacula together with the Amazon Glacier for cheap cloud storage? -- LogMeIn Central: Instant, anywhere, Remote PC access and management. Stay in control, update software, and manage PCs from one command center Diagnose problems and improve visibility into emerging IT issues Automate, monitor and manage. Do more in less time with Central http://p.sf.net/sfu/logmein12331_d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula on Sun HA Cluster?
We have a 2 node Sun (now Oracle) Solaris HA Cluster that does NFS file service. Only one node does service at a time, with an IP address that moves to the other node on node failure. Has anyone tried using Bacula to backup a Sun HA cluster? -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Fiber Connected Library?
Are there any fiber connected tape libraries thats are known to work with Bacula? -- Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Reliable Backups without Tapes?
We currently backup our department network running Legato networker with backup to a raided disk array (advanced file device in their jargon) followed by cloning to a Qualstar/SAIT2 tape library. Our backup needs are increasing and we don't want to buy licenses for more file device space or more tape slots. We would like to go with Bacula and have no limits. In fact since SAIT has dead ended and its not clear to me if Bacula supports Qualstar, I wonder about an all disk solution. Under Legato the license restriction artificially keep the "file-device" small relative to the tape storage. However, these days disks are cheaper than tapes and license free we could afford a lot of disk space. However, the second feature of the tapes is that if the "file-device" fails (even raid fails), we can transparently go to tape. It also affords the option of off site copies of the tapes. Is there any strategy for Bacula that adds the reliability we would lose by abandoning the tapes. Perhaps a second redundant array combined with some removable drives for off sites? -- AppSumo Presents a FREE Video for the SourceForge Community by Eric Ries, the creator of the Lean Startup Methodology on "Lean Startup Secrets Revealed." This video shows you how to validate your ideas, optimize your ideas and identify your business strategy. http://p.sf.net/sfu/appsumosfdev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Qualstar TLS-5000 SAIT Library
I know its not on the supported list, but I'm wondering if anyone has tried to get a Qualstar TLS-5433 SAIT tape library to work with Bacula. -- Free Software Download: Index, Search & Analyze Logs and other IT data in Real-Time with Splunk. Collect, index and harness all the fast moving IT data generated by your applications, servers and devices whether physical, virtual or in the cloud. Deliver compliance at lower cost and gain new business insights. http://p.sf.net/sfu/splunk-dev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users