Re: [Bacula-users] problem of disk space - 80 GB backup catalog...

2011-09-19 Thread Pieter (NL) 


LAZARO Bruno wrote:
> 
> Hello,
> 
>  
> 
> Attached is the job history "BackupCatalog »:
> 
>  
> 
> 16-Sep 15:07 tis002-dir JobId 4631: shell command: run BeforeJob
> ""F:\Serveur_Sauvegarde\Bacula\bin\make_catalog_backup""
> 16-Sep 15:07 tis002-dir JobId 4631: BeforeJob: 
> 16-Sep 15:07 tis002-dir JobId 4631: BeforeJob: C:\WINDOWS\system32>DEL /f
> "C:\Documents and Settings\All Users\Application
> Data\Bacula\Work\trustbacula.sql"  2>nul 16-Sep 15:07 tis002-dir JobId
> 4631: BeforeJob: 
> 16-Sep 15:07 tis002-dir JobId 4631: BeforeJob: C:\WINDOWS\system32>set
> path=F:\Serveur_Sauvegarde\wamp\bin\mysql\mysql5.1.36\bin;F:\Serveur_Sauvegarde\wamp\bin\mysql\mysql5.1.36\bin
> 
> 16-Sep 15:07 tis002-dir JobId 4631: BeforeJob: 
> 
> 16-Sep 15:07 tis002-dir JobId 4631: BeforeJob:
> C:\WINDOWS\system32>"F:\Serveur_Sauvegarde\wamp\bin\mysql\mysql5.1.36\bin\mysqldump"
> -u bacula --password=trustbacula bacula  1>"C:\Documents and Settings\All
> Users\Application Data\Bacula\Work\trustbacula.sql" 
> 
> 16-Sep 15:11 tis002-dir JobId 4631: Start Backup JobId 4631,
> Job=BackupCatalog.2011-09-15_23.55.02_25
> 
> 16-Sep 15:11 tis002-dir JobId 4631: Using Device "FileStorage"
> 
> 16-Sep 15:11 tis002-sd JobId 4631: Volume "VolLocalN1" previously written,
> moving to end of data.
> 
> 16-Sep 15:11 tis002-sd JobId 4631: Ready to append to end of Volume
> "VolLocalN1" size=85616645910 16-Sep 15:11 tis002-fd JobId 4631: Generate
> VSS snapshots. Driver="VSS Win 2003", Drive(s)="C"
> 
> 16-Sep 15:14 tis002-fd JobId 4631: VSS Writer (BackupComplete):
> "SqlServerWriter", State: 0x1 (VSS_WS_STABLE) 16-Sep 15:14 tis002-fd JobId
> 4631: VSS Writer (BackupComplete): "System Writer", State: 0x1
> (VSS_WS_STABLE) 16-Sep 15:14 tis002-fd JobId 4631: VSS Writer
> (BackupComplete): "WMI Writer", State: 0x1 (VSS_WS_STABLE) 16-Sep 15:14
> tis002-fd JobId 4631: VSS Writer (BackupComplete): "FRS Writer", State:
> 0x1 (VSS_WS_STABLE) 16-Sep 15:14 tis002-fd JobId 4631: VSS Writer
> (BackupComplete): "NTDS", State: 0x1 (VSS_WS_STABLE) 16-Sep 15:14
> tis002-sd JobId 4631: Job write elapsed time = 00:03:21, Transfer rate =
> 1.510 M bytes/second 16-Sep 15:14 tis002-fd JobId 4631: VSS Writer
> (BackupComplete): "Event Log Writer", State: 0x1 (VSS_WS_STABLE) 16-Sep
> 15:14 tis002-fd JobId 4631: VSS Writer (BackupComplete): "MSDEWriter",
> State: 0x1 (VSS_WS_STABLE) 16-Sep 15:14 tis002-fd JobId 4631: VSS Writer
> (BackupComplete): "Registry Writer", State: 0x1 (VSS_WS_STABLE) 16-Sep
> 15:14 tis002-fd JobId 4631: VSS Writer (BackupComplete): "COM+ REGDB
> Writer", State: 0x1 (VSS_WS_STABLE) 16-Sep 15:14 tis002-fd JobId 4631: VSS
> Writer (BackupComplete): "IIS Metabase Writer", State: 0x1 (VSS_WS_STABLE)
> 16-Sep 15:14 tis002-dir JobId 4631: Bacula tis002-dir 3.0.3a (06Dec09):
> 16-Sep-2011 15:14:51
> 
>   Build OS:   Linux Cross-compile Win32
> 
>   JobId:  4631
> 
>   Job:BackupCatalog.2011-09-15_23.55.02_25
> 
>   Backup Level:   Full
> 
>   Client: "tis002-fd" 3.0.3a (06Dec09)
> Linux,Cross-compile,Win32
> 
>   FileSet:"Catalog" 2009-11-19 23:55:00
> 
>   Pool:   "Default" (From Run pool override)
> 
>   Catalog:"MyCatalog" (From Client resource)
> 
>   Storage:"File" (From Job resource)
> 
>   Scheduled time: 15-Sep-2011 23:55:02
> 
>   Start time: 16-Sep-2011 15:11:29
> 
>   End time:   16-Sep-2011 15:14:51
> 
>   Elapsed time:   3 mins 22 secs
> 
>   Priority:   12
> 
>   FD Files Written:   1
> 
>   SD Files Written:   1
> 
>   FD Bytes Written:   303,681,022 (303.6 MB)
> 
>   SD Bytes Written:   303,681,220 (303.6 MB)
> 
>   Rate:   1503.4 KB/s
> 
>   Software Compression:   None
> 
>   VSS:yes
> 
>   Encryption: no
> 
>   Accurate:   no
> 
>   Volume name(s): VolLocalN1
> 
>   Volume Session Id:  133
> 
>   Volume Session Time:1314373648
> 
>   Last Volume Bytes:  85,920,552,714 (85.92 GB)
> 
>   Non-fatal FD errors:0
> 
>   SD Errors:  0
> 
>   FD termination status:  OK
> 
>   SD termination status:  OK
> 
>   Termination:Backup OK
> 
>  
> 
> 16-Sep 15:14 tis002-dir JobId 4631: Begin pruning Jobs.
> 
> 16-Sep 15:14 tis002-dir JobId 4631: No Jobs found to prune.
> 
> 16-Sep 15:14 tis002-dir JobId 4631: Begin pruning Files.
> 
> 16-Sep 15:14 tis002-dir JobId 4631: No Files found to prune.
> 
> 16-Sep 15:14 tis002-dir JobId 4631: End auto prune.
> 
>  
> 
> 16-Sep 15:14 tis002-dir JobId 4631: shell command: run AfterJob
> ""F:\Serveur_Sauvegarde\Bacula\bin\delete_catalog_backup""
> 
> 16-Sep 15:14 tis002-dir JobId 4631: AfterJob: 
> 
> 16-Sep 15:14 tis002-dir JobId 4631: AfterJob: C:\WINDOWS\system32>DEL /f
> "C:\Documents and Settings\All Users\Application
> Data\Bacula\Work\trustbacula.sql" 
> 
>  
> 
>  
> 
> Sincerely,Trust-i

Re: [Bacula-users] Bacula 5.0.3 doesn't restore client wndows xp on usb disk.

2011-08-30 Thread Pieter (NL) 


kollerholm wrote:
> 
> Hi,
> 
> I give you more informations about my conf and one job backup and one job
> restore.
> 
> bacula-dir.conf (http://pastebin.com/d8bK5nsy)
> 
> bacula-sd.conf (http://pastebin.com/5g0B3f8Z)
> 
> bacula-fd.conf_windows_xp (http://pastebin.com/cx7H9Jhd)
> 
> bacula-fd.conf_debian (http://pastebin.com/PNpp4H30)
> 
> run_job_by_bconsole (http://pastebin.com/tUXNj1yM)
> 
> restore_job_by_bconsole (http://pastebin.com/W5qJP0py)
> 
> backup_folder_after_backup_and_restore_job (http://pastebin.com/mJaaaeWV)
> 
> Running Job backup on windows xp:
>  (http://imageshack.us/photo/my-images/51/runningjobxp.png/)
> 
> Job backup windows finish:
>  (http://imageshack.us/photo/my-images/705/finaljob.png/)
> 
> Job restore finish:
>  (http://imageshack.us/photo/my-images/823/restorejobfinish.png/)
> 
> Log bacula-sd.conf:
> bacula-sd.log (http://pastebin.com/rP2HNcMh)
> 
> Log bacula-dir.log ( I removed a lot of lines with the functions 
> sql_create.c and getmsg.c)
> bacula-dir.log (http://pastebin.com/RAgD8XBp)
> 
> After these tests where I found no error, I am always in the same
> situation, the restoration is done as well bacula but no files in the
> folder!
> 
> I try to give you the maximum informations !
> 
> Thank for your help .
> 
> Steeve CHARLES
> 
> 

Did a restore on my windows system.
Used /mnt/backup/bacula/irris/cristal2-restores as my restore location
The files (directory structure) appeared in
C:\mnt\backup\bacula\irris\cristal2-restores\

Pieter

-- 
View this message in context: 
http://old.nabble.com/Bacula-5.0.3-doesn%27t-restore-client-wndows-xp-on-usb-disk.-tp32353473p32362274.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


--
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at an even better 
price-free! And you'll get a free "Love Thy Logs" t-shirt when you
download Logger. Secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsisghtdev2dev
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula 5.0.3 doesn't restore client wndows xp on usb disk.

2011-08-29 Thread Pieter (NL) 

If I do a restore to a windows system the directories appear with the system
and hidden attributes set.

Look in your restore directory for subdirectories with those attributes set.

Kind regards,
Pieter Sybesma


Jeremy Maes wrote:
> 
> Op 28/08/2011 18:51, man_in_the_hill schreef:
>> Hello the world,
>>
>> I use bacula 5.0.3 for backup files from linux client and windows client.
>>
>> My backup system:
>>
>> One serveur debian lenny proxmox 1.8 with  bacula-dir, bacula-fd,
>> bacula-sd running on and one virtual machine running windows xp with
>> bacula-win 5.0.3  running on .
>>
>> The backup device is a usb disk NTFS  mounted on debian via ntfs-3g.
>>
>> The backup file run fine and the volumes are created  but when I want to
>> restore a client windows backup, the restore is ok but no files appears
>> in the restore folder !
> When you set up the restore job, did you use the default restore folder, 
> or did you manually change it? If you didn't change it, what is the 
> restore directory set to in the definition of your 
> "RestoreFilesCristal2" job? Have you checked there?
>>Files Expected: 8,804
>>Files Restored: 8,804
> My experience with bacula is that if it says it has restored the files 
> but you can't find them, you usually just have to search a bit more 
> where they are. They've always been there for me though after a bit of 
> searching.
> 
> Kind regards,
> Jeremy
> 
>   DISCLAIMER 
> http://www.schaubroeck.be/maildisclaimer.htm
> 
> --
> EMC VNX: the world's simplest storage, starting under $10K
> The only unified storage solution that offers unified management 
> Up to 160% more powerful than alternatives and 25% more efficient. 
> Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
> 
> 

-- 
View this message in context: 
http://old.nabble.com/Bacula-5.0.3-doesn%27t-restore-client-wndows-xp-on-usb-disk.-tp32353473p32355137.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


--
EMC VNX: the world's simplest storage, starting under $10K
The only unified storage solution that offers unified management 
Up to 160% more powerful than alternatives and 25% more efficient. 
Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] No Full backup in first weekend of january

2010-01-11 Thread Pieter (NL) 

In the schedule resource the manual says:

 = w00 | w01 | ... w52 | w53

So why didn't my backup run in week 53?
(Still a lot of time to fix no week 53 until 2016.)

Pieter



Marek Simon-2 wrote:
> 
> Bacula follows the ISO 8601 specification. The first week of years is 
> the first week that has the first Thursday in this year. The first 
> weekend was not in the first week of the year.
> More in Bacula Documentation, Section Schedule Resource.
> Marek
> 
> Fahrer, Julian napsal(a):
>> I ve seen the same thing at a customers site using 3.0.3
>> 
>> Mit freundlichem Gruß
>> 
>> Julian Fahrer
>> 
>> 
>> - Originalnachricht -
>> Von: Pieter (NL) 
>> An: bacula-users@lists.sourceforge.net
>> 
>> Gesendet: Sat Jan 09 20:17:12 2010
>> Betreff: [Bacula-users]  No Full backup in first weekend of january
>> 
>> 
>> Hi,
>> 
>> I noticed something stange. In the first week of january no Full backup
>> was
>> made on my server(s). I have the following schedule:
>> 
>> Schedule {
>>   Name = "WeeklyCycle"
>>   Run = Level=Full w01 w03 w05 w07 w09  w11 w13 w15 w17 w19 w21 w23 w25
>> w27
>> w29 w31 w33 w35 w37 w39 w41 w43 w45 w47 w49 w51 w53 on sun at 01:05
>>   Run = Level=Differential w02 w04 w06 w08 w10 w12 w14 w16 w18 w20 w22
>> w24
>> w26 w28 w30 w32 w34 w36 w38 w40 w42 w44 w46 w48 w50 w52 on sun at 01:05
>>   Run = Level=Incremental tue-fri at 01:05
>> }
>> 
>> I know this weekend was in week 53 is this a missing week in bacula?
>> 
>> Greetings,
>> Pieter
>> 
>> 
>> 
>> 
>> 
>> --
>> This SF.Net email is sponsored by the Verizon Developer Community
>> Take advantage of Verizon's best-in-class app development support
>> A streamlined, 14 day to market process makes app distribution fast and
>> easy
>> Join now and get one step closer to millions of Verizon customers
>> http://p.sf.net/sfu/verizon-dev2dev 
>> 
>> 
>> 
>> 
>> ___
>> Bacula-users mailing list
>> Bacula-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/bacula-users
> 
> 
> --
> This SF.Net email is sponsored by the Verizon Developer Community
> Take advantage of Verizon's best-in-class app development support
> A streamlined, 14 day to market process makes app distribution fast and
> easy
> Join now and get one step closer to millions of Verizon customers
> http://p.sf.net/sfu/verizon-dev2dev 
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
> 
> 

-- 
View this message in context: 
http://old.nabble.com/No-Full-backup-in-first-weekend-of-january-tp27091872p27112900.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] No Full backup in first weekend of january

2010-01-09 Thread Pieter (NL) 

Hi,

I noticed something stange. In the first week of january no Full backup was
made on my server(s). I have the following schedule:

Schedule {
  Name = "WeeklyCycle"
  Run = Level=Full w01 w03 w05 w07 w09  w11 w13 w15 w17 w19 w21 w23 w25 w27
w29 w31 w33 w35 w37 w39 w41 w43 w45 w47 w49 w51 w53 on sun at 01:05
  Run = Level=Differential w02 w04 w06 w08 w10 w12 w14 w16 w18 w20 w22 w24
w26 w28 w30 w32 w34 w36 w38 w40 w42 w44 w46 w48 w50 w52 on sun at 01:05
  Run = Level=Incremental tue-fri at 01:05
}

I know this weekend was in week 53 is this a missing week in bacula?

Greetings,
Pieter

-- 
View this message in context: 
http://old.nabble.com/No-Full-backup-in-first-weekend-of-january-tp27091872p27091872.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] folder permissions on restore

2009-04-28 Thread Pieter (NL) 


Bugzilla from tho...@chaschperli.ch wrote:
> 
> hi
> 
> I've got problems on access rights on restored folders on debian etch 
> with bacula 2.4.4.
> 
> example: 
> 
> file to restore: /A/B/C/file.txt
> 
> original folder A access rights: 2775/drwxrwsr-x
> restored folder A access rights: 0764/drwxrw-r--
> 
> is there a way to get the correct permissions restored for the parent 
> folders?
> 
> - Thomas
> 

Same here on Windows. Backup was done with client Version: 1.38.10 Restore
to client Version: 3.0.0. Permissons on folders change. D:/tmp/x now has
permissions Hidden and Read Only, subfolder of d:/tmp/x gets System and Read
Only permission.
Restore logfile is also showing access denied ('Toegang geweigerd') message
think that is causing the file count mismatch warning all the access denied
messages are on directories.

http://www.nabble.com/file/p23271900/restore-log.txt restore-log.txt 

Pieter

-- 
View this message in context: 
http://www.nabble.com/folder-permissions-on-restore-tp23253403p23271900.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


--
Register Now & Save for Velocity, the Web Performance & Operations 
Conference from O'Reilly Media. Velocity features a full day of 
expert-led, hands-on workshops and two days of sessions from industry 
leaders in dedicated Performance & Operations tracks. Use code vel09scf 
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] FreeBSD Bare Metal Recovery

2009-02-18 Thread Pieter (NL) 


Doug Sampson wrote:
> 
>> > On Wed, 11 Feb 2009 16:34:16 -0800, Doug Sampson said:
>> > 
>> > I poked around some more. I discovered the 'ldd' command 
>> which shows the
>> > libraries used/required by bacula-fd as follows:
>> > 
>> > r...@pisces:/root# ldd /usr/local/sbin/bacula-fd
>> > /usr/local/sbin/bacula-fd:
>> > libz.so.4 => /lib/libz.so.4 (0x280c6000)
>> > libthr.so.3 => /lib/libthr.so.3 (0x280d8000)
>> > libintl.so.8 => /usr/local/lib/libintl.so.8 (0x280ea000)
>> > libwrap.so.5 => /usr/lib/libwrap.so.5 (0x280f3000)
>> > libiconv.so.3 => /usr/local/lib/libiconv.so.3 (0x280fa000)
>> > libssl.so.5 => /usr/lib/libssl.so.5 (0x281ef000)
>> > libcrypto.so.5 => /lib/libcrypto.so.5 (0x2822f000)
>> > libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x2837e000)
>> > libm.so.5 => /lib/libm.so.5 (0x2846d000)
>> > libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x28482000)
>> > libc.so.7 => /lib/libc.so.7 (0x2848c000)
>> >
> 
Found a few ways to create a static-fd (i think)

run make configure in /usr/ports/sysutils/bacula-client
write down (copy) the configure command with all the argument from
config.log in the work/bacula-2.4.4 dir
run make clean in /usr/ports/sysutils/bacula-client
now run make extract, make path and cd into work/bacula-2.4.4 and run the
copied configure command with all the arguments and add --enable-static-fd
to the line
run make and a static-bacula-fd is in src/filed directory.

run make in /usr/ports/sysutils/bacula-client
cd into  work/bacula-2.4.4/src/filed and run make static-bacula-fd

ldd static-bacula-fd
static-bacula-fd:
libintl.so.8 => /usr/local/lib/libintl.so.8 (0x281e3000)
libiconv.so.3 => /usr/local/lib/libiconv.so.3 (0x281ec000)


don't know if it will work dont have the resources to try it right now.

Pieter
-- 
View this message in context: 
http://www.nabble.com/FreeBSD-Bare-Metal-Recovery-tp21945778p22087528.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


--
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Column 'PoolId' cannot be null

2009-01-07 Thread Pieter (NL) 

Updated to version 2.4.4 and the sql error from the migrate job, with no
files to migrate, disappeared. Also the sql error PoolID seems to have gone
aways. Thank you.


Greetings,
Pieter

-- 
View this message in context: 
http://www.nabble.com/Column-%27PoolId%27-cannot-be-null-tp20898308p21327251.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


--
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Column 'PoolId' cannot be null

2008-12-10 Thread Pieter (NL) 

Got another error today just like the poolid error:

10-Dec 06:10 backup-dir JobId 12988: No Oldest Volumes found to migrate.
10-Dec 06:10 backup-dir JobId 12988: No JobIds found to migrate.
10-Dec 06:10 backup-dir JobId 12988: Error: sql_update.c:194
sql_update.c:194 update UPDATE Job SET JobStatus='T',EndTime='2008-12-10
06:10:01',ClientId=3,JobBytes=0,JobFiles=0,JobErrors=0,VolSessionId=0,VolSessionTime=0,PoolId=13,FileSetId=NULL,JobTDate=1228885801,RealEndTime='2008-12-10
06:10:01',PriorJobId=0 WHERE JobId=12988 failed:
Column 'FileSetId' cannot be null
10-Dec 06:10 backup-dir JobId 12988: sql_update.c:194 UPDATE Job SET
JobStatus='T',EndTime='2008-12-10
06:10:01',ClientId=3,JobBytes=0,JobFiles=0,JobErrors=0,VolSessionId=0,VolSessionTime=0,PoolId=13,FileSetId=NULL,JobTDate=1228885801,RealEndTime='2008-12-10
06:10:01',PriorJobId=0 WHERE JobId=12988
10-Dec 06:10 backup-dir JobId 12988: Warning: Error updating job record.
sql_update.c:194 update UPDATE Job SET JobStatus='T',EndTime='2008-12-10
06:10:01',ClientId=3,JobBytes=0,JobFiles=0,JobErrors=0,VolSessionId=0,VolSessionTime=0,PoolId=13,FileSetId=NULL,JobTDate=1228885801,RealEndTime='2008-12-10
06:10:01',PriorJobId=0 WHERE JobId=12988 failed:
Column 'FileSetId' cannot be null
10-Dec 06:10 backup-dir JobId 12988: Bacula backup-dir 2.4.3 (10Oct08):
10-Dec-2008 06:10:01


Greetings,
Pieter

-- 
View this message in context: 
http://www.nabble.com/Column-%27PoolId%27-cannot-be-null-tp20898308p20937797.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


--
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you.  Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Column 'PoolId' cannot be null

2008-12-08 Thread Pieter (NL) 

When I do a restore I get the message "Column 'PoolId' cannot be null" did I
miss a database update?

The following is part of my logfile:

08-Dec 16:22 backup-dir JobId 12951: Start Restore Job
RestoreFiles.2008-12-08_16.22.10
08-Dec 16:22 backup-dir JobId 12951: Using Device "FileStorage"
08-Dec 16:23 backup-sd JobId 12951: Ready to read from volume "FuDi-2046" on
device "FileStorage" (/usr/backupdisk/baculafiles).
08-Dec 16:23 backup-sd JobId 12951: Forward spacing Volume "FuDi-2046" to
file:block 0:210.
08-Dec 16:23 backup-sd JobId 12951: End of Volume at file 0 on device
"FileStorage" (/usr/backupdisk/baculafiles), Volume "FuDi-2046"
psy-fd JobId 12951: -r--r--r--   1 0015837 2008-09-26
10:12:26  d:/tmp/usr/local/etc/pkgtools.conf
08-Dec 16:23 backup-sd JobId 12951: End of all volumes.
08-Dec 16:23 backup-dir JobId 12951: Error: sql_update.c:194
sql_update.c:194 update UPDATE Job SET JobStatus='T',EndTime='2008-12-08
16:23:01',ClientId=2,JobBytes=15837,JobFiles=1,JobErrors=0,VolSessionId=3,VolSessionTime=1228749224,PoolId=NULL,FileSetId=NULL,JobTDate=1228749781,RealEndTime='2008-12-08
16:23:01',PriorJobId=0 WHERE JobId=12951 failed:
Column 'PoolId' cannot be null
08-Dec 16:23 backup-dir JobId 12951: sql_update.c:194 UPDATE Job SET
JobStatus='T',EndTime='2008-12-08
16:23:01',ClientId=2,JobBytes=15837,JobFiles=1,JobErrors=0,VolSessionId=3,VolSessionTime=1228749224,PoolId=NULL,FileSetId=NULL,JobTDate=1228749781,RealEndTime='2008-12-08
16:23:01',PriorJobId=0 WHERE JobId=12951
08-Dec 16:23 backup-dir JobId 12951: Warning: Error updating job record.
sql_update.c:194 update UPDATE Job SET JobStatus='T',EndTime='2008-12-08
16:23:01',ClientId=2,JobBytes=15837,JobFiles=1,JobErrors=0,VolSessionId=3,VolSessionTime=1228749224,PoolId=NULL,FileSetId=NULL,JobTDate=1228749781,RealEndTime='2008-12-08
16:23:01',PriorJobId=0 WHERE JobId=12951 failed:
Column 'PoolId' cannot be null
08-Dec 16:23 backup-dir JobId 12951: Bacula backup-dir 2.4.3 (10Oct08):
08-Dec-2008 16:23:01
  Build OS:   i386-portbld-freebsd6.1 freebsd 6.1-RELEASE-p2


Greetings Pieter
-- 
View this message in context: 
http://www.nabble.com/Column-%27PoolId%27-cannot-be-null-tp20898308p20898308.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


--
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you.  Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Job Failed Fatal error: sql_create.c:93 Create DB Job record

2007-07-10 Thread Pieter (NL) 

There was really no error message. Rebooted the server and recompiled and
reinstalled mysql51-server and client and it's working again. Don't know why
the problem disappeared.



Arno Lehmann wrote:
> 
> Hi,
> 
> 10.07.2007 10:56,, Pieter (NL) wrote::
>> Updated MySQL yesterday and all backups fail with the following
>> message(s):
>> 
>> Job failed.
>> 10-Jul 10:05 backup-dir: sql_create.c:91 INSERT INTO Job
>> (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
>> ('halrouter.2007-07-10_10.05.22','halrouter','B','I','C','2007-07-10
>> 10:05:20',1184054720)
>> 10-Jul 10:05 backup-dir: halrouter.2007-07-10_10.05.22 Fatal error:
>> sql_create.c:93 Create DB Job record INSERT INTO Job
>> (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
>> ('halrouter.2007-07-10_10.05.22','halrouter','B','I','C','2007-07-10
>> 10:05:20',1184054720) failed. ERR=
> 
> Really no error message printed?
> 
>> Any suggestions?
> 
> Yup... check the database. MySQL can fill its table space, the cure is 
> simple.
> It's also possible that the MySQL server disconnected after a long 
> idle time, which can also easily be fixed.
> Finally, you might have a more serious problem with the database, 
> which you could analyze and hopefully fix using the MySQL tools.
> 
> Since you write you updated the database, but give no more details, I 
> suggest looking through the MySQL related log files first.
> 
> Arno
> 
>> Pieter
> 
> -- 
> Arno Lehmann
> IT-Service Lehmann
> www.its-lehmann.de
> 
> -
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Job-Failed-Fatal-error%3A-sql_create.c%3A93-Create-DB-Job-record-tf4054580.html#a11522451
Sent from the Bacula - Users mailing list archive at Nabble.com.


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Job Failed Fatal error: sql_create.c:93 Create DB Job record

2007-07-10 Thread Pieter (NL) 

Updated MySQL yesterday and all backups fail with the following message(s):

Job failed.
10-Jul 10:05 backup-dir: sql_create.c:91 INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
('halrouter.2007-07-10_10.05.22','halrouter','B','I','C','2007-07-10
10:05:20',1184054720)
10-Jul 10:05 backup-dir: halrouter.2007-07-10_10.05.22 Fatal error:
sql_create.c:93 Create DB Job record INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
('halrouter.2007-07-10_10.05.22','halrouter','B','I','C','2007-07-10
10:05:20',1184054720) failed. ERR=

Any suggestions?

Pieter
-- 
View this message in context: 
http://www.nabble.com/Job-Failed-Fatal-error%3A-sql_create.c%3A93-Create-DB-Job-record-tf4054580.html#a11517075
Sent from the Bacula - Users mailing list archive at Nabble.com.


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Restore files from windows client to linux client

2006-05-08 Thread Pieter (NL) 

Got a server-crash this weekend and now i'm trying to restore some file to a
linux client.
I'm getting the following message:

07-May 16:27 linuxgate-fd: RestoreFiles.2006-05-07_16.26.54 Error: Win32
GZIP data stream not supported on this Client.
07-May 16:34 linuxgate-fd: RestoreFiles.2006-05-07_16.26.54 Error: 418
non-supported data streams and 0 non-supported attrib streams

And nothing is restored. Is there a sollution for this?

Pieter
--
View this message in context: 
http://www.nabble.com/Restore-files-from-windows-client-to-linux-client-t1572464.html#a4269662
Sent from the Bacula - Users forum at Nabble.com.



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Backups too big, and other questions

2006-04-26 Thread Pieter (NL) 

Can't you use the command last (/var/log/wtmp) for that?
The size is that big, according to a google search, because a userid exists
which is probably -1 or realy big. That is why the size of the file is only
64K with all the nulls left out. One record for each userid who has logged
in. The index used in this file is userid So 1,2 Tb / recordsize if the
big userid


Ryan Novosielski wrote:
> 
> lastlog contains the last logins to the system. While many hackers are
> smarter than to leave it around, some are not, and if your machine is
> brought down, it can be forensic evidence  (or at least clues) if you
> have that file. I'd back it up if it were my system.
> 
> Really, the thing that needs to be done is to find out why on this
> system it is 1.2TB. Chances are, restarting whatever file is currently
> holding lastlog open (or rotating the file) may take care of the
> problem. I'd doubt this persists across reboot (unless this file is made
> this large because of a different problem).
> 
> Try running lsof on that file, if you have it.
> 
> Pieter (NL) wrote:
> 
>>From what I undestand of the manual and fd source code Bacula is actually
>>reading all 1.2 Tb of data to scan for blocks with all zero's. I could
>>imagine this takes time.
>>What is actually stored in /var/log/lastlog? Is it worth being backed up?
>>
>>Pieter
>>
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
> 
> 
--
View this message in context: 
http://www.nabble.com/Backups-too-big%2C-and-other-questions-t1502635.html#a4107091
Sent from the Bacula - Users forum at Nabble.com.



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Backups too big, and other questions

2006-04-26 Thread Pieter (NL) 

>From what I undestand of the manual and fd source code Bacula is actually
reading all 1.2 Tb of data to scan for blocks with all zero's. I could
imagine this takes time.
What is actually stored in /var/log/lastlog? Is it worth being backed up?

Pieter


Scott Ruckh wrote:
> 
> 
> This is what you said Pieter (NL)
>>
>> Did you look, with for example wx-console, if the files you didn't want
>> to
>> be
>> backed up are indeed excluded to make sure if your fileset is or isn't
>> the
>> problem
>>
>> Pieter
>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Backups-too-big%2C-and-other-questions-t1502635.html#a4083663
>> Sent from the Bacula - Users forum at Nabble.com.
> 
> Backing up the sparse file (1.2TB in size (64K actual size)), with the
> spase otion enabled for the file, still takes about 2.5 hours to backup. 
> Does this sound correct?
> 
> That is an improvement on the 7 hours without sparse enabled, but I would
> have guessed that backing up a sparse file whose actual file size is 64K
> would only take a matter of seconds.
> 
> Here is the new FileSet with the sparse option enabled:
> 
> FileSet {
>   Name = "Firewall Full"
> 
>   Include {
> Options {
>   signature = MD5
>   sparse = yes
>   compression = GZIP
> }
> File = /var/log/lastlog
>   }
> 
>   Include {
> Options {
>   compression = GZIP
>   signature = MD5
>   wildfile = "/var/log/lastlog"
>   wildfile = "/.journal"
>   wildfile = "/.fsck"
>   wilddir = /proc
>   wilddir = /tmp
>   wilddir = /sys
>   wilddir = /dev
>   wilddir = /mnt
>   wilddir = /BACKUPS
>   wilddir = /var/spool/squid
>   Exclude = yes
> }
> File = /
> File = /boot
> File = /home
> File = /var
>   }
> }
> 
> I could probably remove /wildir = /BACKUPS as /BACKUPS is its own
> filesystem, but I included it for readability.
> 
> If this is still not the correct way to handle the sparse file, please let
> me know.
> 
> Thanks.
> Scott
> 
> 
> 
> ---
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
> 
> 
--
View this message in context: 
http://www.nabble.com/Backups-too-big%2C-and-other-questions-t1502635.html#a4102834
Sent from the Bacula - Users forum at Nabble.com.



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] bacula-web image test/phplot fails with "argument not an array" erro

2006-04-26 Thread Pieter (NL) 

Works OK. The only thing I had to change was short_open_tag = On in php.ini
--
View this message in context: 
http://www.nabble.com/bacula-web-image-test-phplot-fails-with-%22argument-not-an-array%22-errors-t1503146.html#a4100316
Sent from the Bacula - Users forum at Nabble.com.



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Backups too big, and other questions

2006-04-25 Thread Pieter (NL) 

Did you look, with for example wx-console, if the files you didn't want to be
backed up are indeed excluded to make sure if your fileset is or isn't the
problem

Pieter


--
View this message in context: 
http://www.nabble.com/Backups-too-big%2C-and-other-questions-t1502635.html#a4083663
Sent from the Bacula - Users forum at Nabble.com.



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Backups too big, and other questions

2006-04-25 Thread Pieter (NL) 

I use following filesets. First exclude in options and after that include:

FileSet {
Name= "bsdserver1 files"
Include {
Options {
signature   = MD5
compression = GZIP
Exclude = yes
WildDir = "/proc"
WildDir = "/dev"
}
File = "/etc"
File = "/usr/local/etc"
File = "/usr/image/part2/home"
File = "/usr/image/part2/profiles"
File = "/usr/image/part2/oldproj"
File = "/usr/image/part1/mysql.bak"
}
}


Maybe for you something like this will work:

FileSet {
  Name = "Firewall Full"

  Include {
Options {
  compression = GZIP
  signature = MD5
  exclude = yes
  WildFile = "/var/log/lastlog"
WildDir = /proc
WildDir = /tmp
WildDir = /sys
WildDir = /dev
WildDir = /.journal
WildDir = /.fsck
WildDir = /mnt
WildDir = /var/spool/squid
WildDir = /BACKUPS
}
File = /
File = /boot
File = /home
File = /var
  }

Pieter
--
View this message in context: 
http://www.nabble.com/Backups-too-big%2C-and-other-questions-t1502635.html#a4082934
Sent from the Bacula - Users forum at Nabble.com.



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] bacula-web image test/phplot fails with "argument not an array" erro

2006-04-25 Thread Pieter (NL) 

I've got it working. Problem is the array_merge function. For phplot I've
installed a newer version of phplot (rc2) from
http://www.sourceforge.net/projects/phplot/ in the external_packages/phplot
directory.
There are some other phpscripts i've adjusted
classes.inc:

bsdtest# grep -e "array_merge" *
classes.inc: $whole_result[] =
array_merge((array)$row["$derecha"],(array)$row[$izquierda]);
classes.inc: $whole_result[] =
array_merge((array)$row["Jobid"],(array)$row["JobFiles"],(array)$row["JobBytes"]);
classes.inc: $spr2 =
array_merge($spr2,array($row["Name"]=>$row["SUM(JobBytes)"]));

Pieter

--
View this message in context: 
http://www.nabble.com/bacula-web-image-test-phplot-fails-with-%22argument-not-an-array%22-errors-t1503146.html#a4081641
Sent from the Bacula - Users forum at Nabble.com.



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Backup only to Hard Drive

2006-04-14 Thread Pieter (NL) 

I'm currently backing up to 2 mobile firewire disks. If I switch disks I
first disable all the volumes stored on this mobile disk and store the
status of the volumes in a mysql database. Umount the disk and remove it.
Mount the other disk (in the same location) and put the state of all the
volumes on that disk back to the value stored in the database. To bacula it
seems just one storage the only problem is I have to be carefull where to
restore from since bacula lets me restore from disabled volumes!

(Fatal error: acquire.c:109 Read open device "MobileStorage"
(/usr/mobiledisk) Volume "Mob-Full-0119" failed: ERR=dev.c:450 Could not
open: /usr/mobiledisk/Mob-Full-0119, ERR=No such file or directory)

Pieter.
--
View this message in context: 
http://www.nabble.com/Backup-only-to-Hard-Drive-t1435294.html#a3917510
Sent from the Bacula - Users forum at Nabble.com.



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users