[Bacula-users] Bacula web site All Files link broken
Hi There, FYI bacula.org webmaster. The bacula home page link for All Files which is links to: http://download.sourceforge.net/bacula appears to be broken: Not Found The requested URL /bacula was not found on this server. Apache/2.0.55 (Unix) PHP/5.0.5 Server at download.sourceforge.net Port 80 In the meantime can anyone suggest where I might be able to get tarballs of older versions of bacula - in particular 1.34.5 ? On the All Files section of the bacula download page on sourceforge, the only 1.34 version I can see is 1.34.6 Jason -- Why work smarter when you can work harder? --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Scheduling problem - schedules loaded but jobs won't queue (though they will run if fired manually)
Hi All, I a have a problem with scheduling - specifically jobs I think should be getting queued are not. The story is this I have two exernal USB disks, which are mounted on different mount points, and I want to fire off jobs so that for one week we do a full backup and a set of diffs to one disk and on another week we do a full backup and a set of diffs to the other disk. The idea is that we will eventaully keep some offsite. I can see the schedules in bconsole if I do a show schedules, but the jobs don't get queued. If I do a manual run of a job, the work, so I am fairly confident that pretty much every thign about the jobs is correct - except the scheduling. Below are a date and a cal ouput from my baculsa director host for reference and below that the two schdules from bacula-dir.conf as well as an the default jobs defs and an example job. Below those is a bcsonsole status dir showing none of the jobs queued and a show schedules. Please not the bottom five chedules were orignally the top fvie schedules but these work so are not very interesting in the context of the problem, so I've moved them to the bottom Bacula version is 1.34.5. I'd really appreciate it if any one could make any suggestions as to what is going on (or more correctly not going on) and any suggestiosn for further diagnosis or fix. Regards and Thanks Jason [EMAIL PROTECTED] bacula]# date Tue Dec 6 10:51:40 CST 2005 [EMAIL PROTECTED] bacula]# cal December 2005 Su Mo Tu We Th Fr Sa 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Schedule { Name = QuickDiskWeeklySched1 Run = Storage = QuickDiskStorage1 Level = Full Pool = QuickDiskPool1 FullPool = QuickDiskPool1 DifferentialPool = QuickDiskPool1 1st Sat at 00:05 Run = Storage = QuickDiskStorage1 Level = differential Pool = QuickDiskPool1 FullPool = QuickDiskPool1 DifferentialPool = QuickDiskPool1 1st sun-fri at 00:05 Run = Storage = QuickDiskStorage1 Level = Full Pool = QuickDiskPool1 FullPool = QuickDiskPool1 DifferentialPool = QuickDiskPool1 3rd Sat at 00:05 Run = Storage = QuickDiskStorage1 Level = differential Pool = QuickDiskPool1 FullPool = QuickDiskPool1 DifferentialPool = QuickDiskPool1 3rd sun-fri at 00:05 Run = Storage = QuickDiskStorage1 Level = Full Pool = QuickDiskPool1 FullPool = QuickDiskPool1 DifferentialPool = QuickDiskPool1 5th Sat at 00:05 Run = Storage = QuickDiskStorage1 Level = differential Pool = QuickDiskPool1 FullPool = QuickDiskPool1 DifferentialPool = QuickDiskPool1 5th sun-fri at 00:05 } # This schedule fires off jobs on the 2nd and 4th weeks of the month Schedule { Name = QuickDiskWeeklySched2 Run = Storage = QuickDiskStorage2 Level = Full Pool = QuickDiskPool2 FullPool = QuickDiskPool2 DifferentialPool = QuickDiskPool2 2nd Sat at 00:05 Run = Storage = QuickDiskStorage2 Level = differential Pool = QuickDiskPool2 FullPool = QuickDiskPool2 DifferentialPool = QuickDiskPool2 2nd sun-fri at 00:05 Run = Storage = QuickDiskStorage2 Level = Full Pool = QuickDiskPool2 FullPool = QuickDiskPool2 DifferentialPool = QuickDiskPool2 4th Sat at 00:05 Run = Storage = QuickDiskStorage2 Level = differential Pool = QuickDiskPool2 FullPool = QuickDiskPool2 DifferentialPool = QuickDiskPool2 4th sun-fri at 00:05 } # one set of job defaults that includes both the schedules # these same jobs will fir off the odd and even numbered weeks schedules # these schedules in turn vary the pool and sotrage from odd to even weeks JobDefs { Name = QuickDiskDefaults Schedule = QuickDiskWeeklySched1 Schedule = QuickDiskWeeklySched2 Pool = QuickDiskPool1 # overidden in shedule Storage = QuickDiskStorage1 # overidden in schedule Level= Differential #never used, overridden in schedule Client Run Before Job = /usr/local/bin/su/before_backup Client Run After Job = /usr/local/bin/su/after_backup Messages = Standard Type = Backup Priority = 10 #if the job has been delayed for 23hrs, cancel it Max Start Delay = 82800 #stop shoeshining, spool data across network to disk first Spool Data = yes } #** Real jobs to disk storage on quick ** Job { Name = radio-disk JobDefs = QuickDiskDefaults Client = radio-fd FileSet = radio-disk Write Bootstrap = /var/lib/bacula/radio-disk.bsr } *status dir Using default Catalog name=MySQL DB=bacula radio-dir Version: 1.34.5 (21 June 2004) i586-mandrake-linux-gnu mandrake (Community) Daemon started 06-Dec-05 10:38, 1 Job run since started. Scheduled Jobs: Level Type Scheduled Name Volume === Differential Backup 07-Dec-05 02:05radio *unknown* Differential Backup 07-Dec-05 00:05BackupCatalog *unknown* Differential Backup 07-Dec-05 00:05retro *unknown* Differential Backup 07-Dec-05 00:05under
Re: [Bacula-users] MySQL Structure question (1.36.*)
Rushowr wrote: Anyone have a rundown of the relationships that bacula uses between tables in the mysql db? I'm trying to manually track down a file and ALL jobs within a date range that saved it, but the database is so spread out, it would be beautiful if I could come across this. I could have sworn I saw it online, but can't find it, and the PDF of documentation doesn't have it either.. Thanks to any who can help. (A SQL query that would find file FINDMEX.sql and all jobs that saved that file in the date range STARTDATE to ENDDATE would be even more awesome). It used to be in the manual. In a version of the HTML manual for version 1.34.5 there is a page called catalog.html, which I can';t find in the current online manual (at least not by looking at likely contents entries and then checking. This page has some description of the db schema. Since I can not make the docs I have public, I've just pasted the page contents into this email. Apologies for the HTML. Hope this helps. Regards Jason Bacula 1.34 User's Guide Back http://intranet.pvt-servers.groundhog.com.au/manuals/bacula/file.html Bacula File Services Index http://intranet.pvt-servers.groundhog.com.au/manuals/bacula/index.html Index Next http://intranet.pvt-servers.groundhog.com.au/manuals/bacula/internals.html Internal Component Designs Catalog Services General This chapter is intended to be a technical discussion of the Catalog services and as such is not targeted at end users but rather at developers and system administrators that want or need to know more of the working details of *Bacula*. The *Bacula Catalog* services consist of the programs that provide the SQL database engine for storage and retrieval of all information concerning files that were backed up and their locations on the storage media. We have investigated the possibility of using the following SQL engines for Bacula: Beagle, mSQL, GNU SQL, PostgreSQL, SQLite, Oracle, and MySQL. Each presents certain problems with either licensing or maturity. At present, we have chosen for development purposes to use MySQL, PostgreSQL and SQLite. MySQL was chosen because it is fast, proven to be reliable, widely used, and actively being developed. MySQL is released under the GNU GPL license. PostgreSQL was chosen because it is a full-featured, very mature database, and because Dan Langille did the Bacula driver for it. PostgreSQL is distributed under the BSD license. SQLite was chosen because it is small, efficient, and can be directly embedded in *Bacula* thus requiring much less effort from the system administrator or person building *Bacula*. In our testing SQLite has performed very well, and for the functions that we use, it has never encountered any errors except that it does not appear to handle databases larger than 2GBytes. The Bacula SQL code has been written in a manner that will allow it to be easily modified to support any of the current SQL database systems on the market (for example: mSQL, iODBC, unixODBC, Solid, OpenLink ODBC, EasySoft ODBC, InterBase, Oracle8, Oracle7, and DB2). If you do not specify either *--with-mysql* or *--with-postgresql* or *--with-sqlite* on the ./configure line, Bacula will use its minimalist internal database. This database is kept for build reasons but is no longer supported. Bacula *requires* one of the three databases (MySQL, PostgreSQL, or SQLite) to run. Filenames and Maximum Filename Length In general, either MySQL, PostgreSQL or SQLite permit storing arbitrary long path names and file names in the catalog database. In practice, there still may be one or two places in the Catalog interface code that restrict the maximum path length to 512 characters and the maximum file name length to 512 characters. These restrictions are believed to have been removed. Please note, these restrictions apply only to the Catalog database and thus to your ability to list online the files saved during any job. All information received and stored by the Storage daemon (normally on tape) allows and handles arbitrarily long path and filenames. Installing and Configuring MySQL For the details of installing and configuring MySQL, please see the Installing and Configuring MySQL http://intranet.pvt-servers.groundhog.com.au/manuals/bacula/mysql.html chapter of this manual. Installing and Configuring PostgreSQL For the details of installing and configuring PostgreSQL, please see the Installing and Configuring PostgreSQL http://intranet.pvt-servers.groundhog.com.au/manuals/bacula/postgresql.html chapter of this manual. Installing and Configuring SQLite For the details of installing and configuring SQLite, please see the Installing and Configuring SQLite http://intranet.pvt-servers.groundhog.com.au/manuals/bacula/sqlite.html chapter of this manual. Internal Bacula Catalog Please see the Internal Bacula Database
[Bacula-users] File based backups
Hi All, I'm wondering if anyone who uses file based backups (instead of tapes) could tell me if the volumes for their files get VolumeBytes, VolumeFiles and LastWritten recorded. My catalog shows 11 jobs on Volume BaculaQuickFile-0001 (ie Volume Id 50). However these is apparently no data and no files recorded on the Volume in the catalog (at least not that part of the catalog that bconsole displays). In addition a file listing shows the volume to have been written to the tune of about 2.3G. What I am trrying to do is get backups working on a pair of remoavvable USB disks. The data gets written to the volume, but the volume never changes, despite the fact that Max Volumes Jobs for the pool is exceeded and other labelled volumes exist in the pool. I also get an error listed below, about an Invalid Catalog Request. I'm not sure how to interpret this other than quick's sd cant write to radio's sd. However it is possible to open a socket from quick to radio:9101 which is what I assume is required for quick's sd to communicate with radio's dir. Various data below. Has any one had a similar experience? Can anyone suggest what the issue might be or where I might look for more info. The bacula log bascially doesn't containt anything over and above the messages I get via mail or bconsole. Regards and thanks for reading this far. Jason BConsoel message post job. *messages 25-Oct-2005 14:04 radio-dir: Start Backup JobId 2515, Job=radio-quick.2005-10-25_14.04.56 25-Oct-2005 14:05 quick-sd: Volume BaculaQuickFile-0001 previously written, moving to end of data. 25-Oct-2005 14:05 radio-dir: radio-quick.2005-10-25_14.04.56 Error: catreq.c:274 Invalid Catalog request: CatReq Job=radio-quick.2005-10-25_14.04.56 UpdateMedia VolName=BaculaQuickFile-0001 VolJobs=0 VolFiles=0 VolBlocks=0 VolBytes=0 VolMounts=1 VolErrors=0 VolWrites=0 MaxVolBytes=0 EndTime=1130214900 VolStatus=Append Slot=0 relabel=0 25-Oct-2005 14:05 quick-sd: radio-quick.2005-10-25_14.04.56 Error: Error updating Volume info Vol=BaculaQuickFile-0001: 1990 Invalid Catalog Request: CatReq Job=radio-quick.2005-10-25_14.04.56 UpdateMedia VolName=BaculaQuickFile-0001 VolJobs=0 VolFiles=0 VolBlocks=0 VolBytes=0 VolMounts=1 VolErrors=0 VolWrites=0 MaxVolBytes=0 EndTime=1130214900 VolStatus=Append Slot=0 relabel=0 * MySQL Query: [EMAIL PROTECTED] bacula]# mysql -u bacula --password=XXX bacula Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5626 to server version: 4.0.18 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql select count(*) from JobMedia where MediaId=50; +--+ | count(*) | +--+ | 11 | +--+ 1 row in set (0.00 sec) Bconsole output: + *list volumes pool=QuickDiskPool +-+--+---+--+--+--+-+--+---+-+ | MediaId | VolumeName | VolStatus | VolBytes | VolFiles | VolRetention | Recycle | Slot | MediaType | LastWritten | +-+--+---+--+--+--+-+--+---+-+ | 50 | BaculaQuickFile-0001 | Append|0 |0 | 604,800 | 1 |0 | File | -00-00 00:00:00 | | 51 | BaculaQuickFile-0002 | Append|0 |0 | 604,800 | 1 |1 | File | -00-00 00:00:00 | | 52 | BaculaQuickFile-0004 | Append|1 |0 | 604,800 | 1 |0 | File | -00-00 00:00:00 | +-+--+---+--+--+--+-+--+---+-+ * BConsole Pool Info show pools Pool: name=QuickDiskPool PoolType=Backup use_cat=1 use_once=0 acpt_any=0 cat_files=1 max_vols=10 auto_prune=1 VolRetention=7 days VolUse=2 days recycle=1 LabelFormat=BaculaQuickFile- CleaningPrefix=*None* recyleOldest=1 MaxVolJobs=10 MaxVolFiles=0 Dir listing: [EMAIL PROTECTED] usb-storage]# ls -l total 2390244 -rw-r- 1 bacula bacula 2445196608 Oct 25 14:05 BaculaQuickFile-0001 -rw-r- 1 bacula bacula237 Oct 25 14:04 BaculaQuickFile-0004 drwx-- 2 root root16384 Oct 21 15:47 lost+found/ --- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today * Register for a JBoss Training Course Free Certification Exam for All Training Attendees Through End of 2005 Visit http://www.jboss.com/services/certification for more information ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users