[Bacula-users] Bacula 9.0.0 - 'StartTime' doesn't have a default value
Hi,
I've managed to compile and install 9.0.0 (with much appreciated help)
however now the jobs fail.
I have run the update_bacula_tables script
--
Error Message:
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
('Client1.2017-07-16_00.05.00_04','Client1','B','D','C','2017-07-16
00:05:00',1500159900,3,'')
failed. ERR=Field 'StartTime' doesn't have a default value
--
OS: openSUSE Leap 42.1 (x86_64)
-
MySQL version info
innodb_version 5.6.34-79.1
protocol_version 10
slave_type_conversions
version 10.0.29-MariaDB
version_comment SLE 12 SP1 package
version_compile_machine x86_64
version_compile_os Linux
version_malloc_library system
Any help appreciated.
--
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] Release 9.0. 0 - Suse - ACL Error
Hi, libmysqld-devel was the one that did it (I already had the others). Installed the package and now compile - make - make install all OK. Thank you very much for your help. On 14/07/17 07:47, Ralf Brinkmann wrote: Am 12.07.2017 um 21:53 schrieb Mick: Error Message #error "configure failed to detect availability of sys/acl.h" OS: openSUSE Leap 42.1 (x86_64) Just made a little test with "openSUSE 42.2 (x86_64)" that I have in a VirtualBox for "wine" test issues. For this test I disabled "bat" in my standard configuration. BASE=$(readlink -f ".") cd $BASE/bacula-9.0.0 ./configure --with-mysql --enable-conio # --enable-bat make clean make On the first runnings I got the same error. With yast2 I had to add a compiler at first - "gcc5" - then the "libmysqld-devel" pack and the "libacl-devel" pack ... and succeeded finaly. -- 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] Release 9.0. 0 - Suse - ACL Error
Hi, I already have these 2 packages installed libattr-devel libattr1 I have filed this as a bug. Regards On 14/07/17 06:47, Uwe Schuerkamp wrote: On Thu, Jul 13, 2017 at 06:40:52PM +0100, Mick wrote: Hi, Thanks for your quick response. I removed the 32 bit packages and re-tried but got the same error. I'll file this as a bug later today. Have you tried installing the libattr-devel files as well? Those came up as a depency when I compiled 9.0.0 on CentOS 6. All the best, Uwe -- Uwe Schürkamp | email: <uwe.schuerk...@nionex.net> -- 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] Release 9.0. 0 - Suse - ACL Error
Hi, Thanks for your quick response. I removed the 32 bit packages and re-tried but got the same error. I'll file this as a bug later today. Regards On 13/07/17 17:58, Kern Sibbald wrote: Hello, Would you try removing the two 32 bit libraries and see if that fixes the problem? If that does not fix the problem would you please file a bug report on this? I agree with you that one should either be able to build correctly with acl support or turn it off. At a quick look it looks like the code requires acl support, and if that is the case, it is a bug. Best regards, Kern On 07/12/2017 09:53 PM, Mick wrote: Hi, I have been using Bacula for several years and have been able to compile successfully before but since 7.4.7 I have been getting an error when I run configure which causes make to fail. - Error Message In file included from xacl.c:1306:0: xacl_linux.h:37:2: error: #error "configure failed to detect availability of sys/acl.h" #error "configure failed to detect availability of sys/acl.h" -- OS: openSUSE Leap 42.1 (x86_64) - Packages installed: acl libacl-devel libacl-devel-32bit libacl1 libacl1-32bit --- I use the following to compile: #!/bin/bash CFLAGS="-g -O2" \ ./configure \ --sbindir=/etc/bacula/bin \ --sysconfdir=/etc/bacula/bin \ --with-pid-dir=/etc/bacula/bin/working \ --with-subsys-dir=/etc/bacula/bin/working \ --enable-smartalloc \ --with-mysql \ --with-working-dir=/etc/bacula/bin/working \ --with-dump-email=root \ --with-job-email=root \ --with-smtp-host=localhost \ --with-dir-password=mik \ --with-fd-password=mik \ --with-sd-password=mik \ --with-systemd \ --disable-acl \ --disable-xattr The acl.h file exists on the system /usr/include/sys/acl.h --- I am getting similar errors with XATTR --- I'd love to work out what is wrong but I'd be happy if I could just compile without ACL/XATTR support. I've searched for help but all I could find was some comments about altering some files after running config however I couldn't find any specific details (e.g. which files and what do you do with them). Any help would be appreciated however I am not a C programmer so please keep it simple. Thanks -- 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 -- 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] Release 9.0. 0 - Suse - ACL Error
Hi, I have been using Bacula for several years and have been able to compile successfully before but since 7.4.7 I have been getting an error when I run configure which causes make to fail. - Error Message In file included from xacl.c:1306:0: xacl_linux.h:37:2: error: #error "configure failed to detect availability of sys/acl.h" #error "configure failed to detect availability of sys/acl.h" -- OS: openSUSE Leap 42.1 (x86_64) - Packages installed: acl libacl-devel libacl-devel-32bit libacl1 libacl1-32bit --- I use the following to compile: #!/bin/bash CFLAGS="-g -O2" \ ./configure \ --sbindir=/etc/bacula/bin \ --sysconfdir=/etc/bacula/bin \ --with-pid-dir=/etc/bacula/bin/working \ --with-subsys-dir=/etc/bacula/bin/working \ --enable-smartalloc \ --with-mysql \ --with-working-dir=/etc/bacula/bin/working \ --with-dump-email=root \ --with-job-email=root \ --with-smtp-host=localhost \ --with-dir-password=mik \ --with-fd-password=mik \ --with-sd-password=mik \ --with-systemd \ --disable-acl \ --disable-xattr The acl.h file exists on the system /usr/include/sys/acl.h --- I am getting similar errors with XATTR --- I'd love to work out what is wrong but I'd be happy if I could just compile without ACL/XATTR support. I've searched for help but all I could find was some comments about altering some files after running config however I couldn't find any specific details (e.g. which files and what do you do with them). Any help would be appreciated however I am not a C programmer so please keep it simple. Thanks -- 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] Re: restore complete file system branches
Martin Simmons wrote: I suggest you run the restore command and read what options it gives you. Sorry, I was to pessimistic when I read the options before. Your hint to option 5 should have brought me on track. Actually opition 6 is rigth choice to do almost everythink. Thanks, Mick --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Re: mount USB disk
Josh Fisher wrote: Perhaps a RunBeforeJob is not needed. It seems it should be possible to use a combination of udev, hal/dbus, and hotplug to insert a USB drive at a known device node and known mountpoint. Autofs can then be used to mount/unmount on an as needed basis. This works on Fedora Core 3 for my ThumbDrive. When I insert the ThumbDrive any needed kernel modules are loaded, the /dev/jumpdrive device node is created, and an entry is made to /etc/fstab to mount /dev/jumpdrive at /media/jumpdrive. It is not yet mounted, but can be mounted via /bin/mount /media/jumpdrive by a normal user. When I subsequently issue a command, say /bin/ls /media/jumpdrive, the automount daemon mounts the device and the ls continues as usual. If I don't access the drive for a while (5 minutes in this case), the automount daemon again takes over and umounts the device. As far as I can tell, this timeout that causes the umount will never occur as long as there is an open file handle pointing to the device. When I remove the ThumDrive, the fstab entry, mountpoint, and device node are all deleted. Most likely the kernel eventually unloads any modules that are no longer needed as well. This hint look quite promissing. My aim is not to have the drive mounted automatically when accessed. Because I want to protect it from malusers, malware or even letal errors of the root. Therefore it should not be mounted as long as Bacula is not doing it explicitly. Still I do not understand it why sd has problem if the drive is not already mounted when sd starts. If I could change this all would be much easier. /M --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Re: restore complete file system branches
Martin Simmons wrote: Bacula can analyse the catalog for you. Use restore option like 5: Select the most recent backup for a client which gives you an interactive way to mark files and dirs (recursively by default) for restore. Thanks, but I want to restore for an earlier point in time. Is there any help for this, e.g. a SQL script to generate the file list? /M --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Re: restore complete file system branches
Martin Simmons wrote: Bacula 1.37 beta has an extra option in restore to take a whole directory (but not its subdirs for some reason). __Martin I can't believe that a sophisticated backup application as Bacula is not able to recover the state of a file system branch at the time of a certain backup. This information is in the catalog. Do I really have to analyse the catalog to recreate the directory structure and create the file list manually? /M --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] restore complete file system branches
Martin Simmons wrote: I suggest you post your session output so we can see what options you are choosing and what the error message is. I have to correct my problem description: I can restore a directory even if it is empty. It is necessary to conclude the path with a /. Then the directory is restored, but not its content. How can I restore a complete branch? Is there a possibility to tell Bacula to restore recursively from a given point in the backuped file system tree? restore First you select one or more JobIds that contain files to be restored. You will be presented several methods of specifying the JobIds. Then you will be allowed to select which files from those JobIds are to be restored. To select the JobIds, you have the following choices: 1: List last 20 Jobs run 2: List Jobs where a given File is saved 3: Enter list of comma separated JobIds to select 4: Enter SQL list command 5: Select the most recent backup for a client 6: Select backup for a client before a specified time 7: Enter a list of files to restore 8: Enter a list of files to restore before a specified time 9: Cancel Select item: (1-9): 7 Automatically selected Client: server1-fd Enter file names with paths, or to enter a filename containg a list of file names with paths, and terminate them with a blank line. Enter full filename: /etc No database record found for: /etc Enter full filename: /etc/ Enter full filename: Bootstrap records written to /var/lib/bacula/restore.bsr The job will require the following Volumes: volume0001 1 file selected to be restored. Run Restore job JobName:RestoreFiles Bootstrap: /var/lib/bacula/restore.bsr Where: /tmp/bacula-restores Replace:always FileSet:Full Set Client: server1-fd Storage:File When: 2005-08-11 12:31:41 Catalog:MyCatalog Priority: 10 OK to run? (yes/mod/no): y Job started. JobId=118 11-Aug 12:31 server1-dir: Start Restore Job RestoreFiles.2005-08-11_12.31.49 11-Aug 12:31 server1-sd: Ready to read from volume volume0001 on device /mnt/BackupDisk/backup. server1-fd: drwxr-xr-x 113 root root8192 2005-08-11 03:05:03 /tmp/bacula-restores/etc/ 11-Aug 12:34 server1-dir: Bacula 1.36.2 (28Feb05): 11-Aug-2005 12:34:16 JobId: 118 Job:RestoreFiles.2005-08-11_12.31.49 Client: server1-fd Start time: 11-Aug-2005 12:31:51 End time: 11-Aug-2005 12:34:16 Files Expected: 1 Files Restored: 1 Bytes Restored: 0 Rate: 0.0 KB/s FD Errors: 0 FD termination status: OK SD termination status: OK Termination:Restore OK 11-Aug 12:34 server1-dir: Begin pruning Jobs. 11-Aug 12:34 server1-dir: No Jobs found to prune. 11-Aug 12:34 server1-dir: Begin pruning Files. 11-Aug 12:34 server1-dir: No Files found to prune. 11-Aug 12:34 server1-dir: End auto prune. /M --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] restore empty directories
Hello, I want to restore a complete subtree of my file system. How can I do this? I get an error message when I type a directory name as the file to restore. Even when I generate the sub tree into a file Bacula give errors for each directory in this list. Hence it does not restore empty directories. Regards, Mick --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Re: mount USB disk
Alan Brown wrote: On Sun, 7 Aug 2005, Mick wrote: I use an USB disk as backup target for Bacula. It works fine. But there is one issue: I want to mount it immediatly before the backup and unmount it afterwards. There is even a mount option for the config file (sd.config I think), but this option is not allowed for a harddisk. Assuming you're using a linux system, why not allow hotplug and subfs to do this for you automagically? --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf I want the disk to be dismounted or at least mounted read-only accept when a backup is running. /M --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] mount USB disk
Hi, I use an USB disk as backup target for Bacula. It works fine. But there is one issue: I want to mount it immediatly before the backup and unmount it afterwards. There is even a mount option for the config file (sd.config I think), but this option is not allowed for a harddisk. I place the mount umount in the beforejob and afterjob. But than I have the problem that sd does not recognize the mounted disk unless it is restarted after the mount. If I want to restart it in the beforejob then I have to run director as root because otherwise there would be an access violation for the pid files of sd. Do you know a better solution for this? Regards, Mick --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
