Open Source

How much are those volumes in the library?

I pretty much ignore my tape library. It asks for tapes when it runs out. However, I think I should be looking ahead and anticipating requests. Thus, I came up with this SQL query: [dan@ngaio:~] $ psql bacula psql (8.4.5) Type “help” for help. bacula=# SELECT mediaid, volumename, volstatus, slot, inchanger, pool.name, volbytes FROM media, pool WHERE media.poolid = pool.poolid AND volumename LIKE ‘ETU0%’ AND inchanger != 0 ORDER BY slot; mediaid |

How much are those volumes in the library? Read More »

Bacula Copy Job

With Bacula, a great piece of backup software [disclosure: I wrote the PostgreSQL module for Bacula], you can copy a Job after it has run. This is often used to backup first to disk, and then Copy that Job to tape. That is exactly what I’ve been doing recently. NOTE: You can also migrate a Job, which is very similar to a Job Copy. With a Job Copy, the original Job remains and

Bacula Copy Job Read More »

Why not use the tape that’s there?

*run A job name must be specified. The defined Job resources are: 1: BackupCatalog 2: RestoreFiles 3: MigrateDiskToTape 4: CopyMegaFileToTape 5: laptop 6: laptop-vpn 7: laptop-wifi-5.3 8: laptop-verify 9: laptop-websites 10: laptop-xp 11: wocker 12: bast basic 13: bast home 14: dbclone basic 15: dbclone home 16: polo basic 17: polo 18: kraken basic 19: kraken 20: nyi maildir 21: nyi maildir tarball 22: nyi basic 23: nyi 24: supernews basic 25: supernews

Why not use the tape that’s there? Read More »

Running a Bacula Copy Job

Over the past few months, I’ve been getting ready to copy Bacula backups from disk to tape, via a Copy Job. Tonight was my first attempt. I failed. And I think I know why. Concurrency. The output so far: *run job=CopyMegaFileToTape Using Catalog “MyCatalog” Run Copy job JobName: CopyMegaFileToTape Bootstrap: *None* Client: wocker-fd FileSet: wocker files Pool: MegaFile-wocker (From Job resource) Read Storage: MegaFile-wocker (From Pool resource) Write Storage: DigitalTapeLibrary (From Storage from

Running a Bacula Copy Job Read More »

pf – cannot define table: Cannot allocate memory

I use pf on FreeBSD 8.1-stable as my firewall of choice. Recently I’ve started using the University of Alberta list of trapped addresses. As of the time of writing this, the list contains about 56,000 IP addresses. When combined with my own list of 27,000 SPAMTRAP addresses, I quick ran into a problem when reload my rule set: $ sudo pfctl -f /etc/pf.rules No ALTQ support in kernel ALTQ related functions disabled /etc/pf.rules:69:

pf – cannot define table: Cannot allocate memory Read More »

zfs send | zfs receive

For the record, I was doing a copy within a system recently: # time zfs send storage/bacula@transfer | mbuffer | zfs receive storage/compressed/bacula-buffer in @ 0.0 kB/s, out @ 0.0 kB/s, 4394 GB total, buffer 100% fullll summary: 4394 GByte in 35 h 11 min 35.5 MB/s real 2111m18.302s user 11m44.831s sys 258m59.151s I was copying my Bacula Volumes from non-compressed ZFS to compressed ZFS. # zfs list NAME USED AVAIL REFER MOUNTPOINT

zfs send | zfs receive Read More »

ntp wasn’t running but Nagios didn’t notice

Earlier today, I noticed the following output from a Bacula job: 24-Sep 14:14 bacula-dir JobId 38548: Start Backup JobId 38548, Job=latens_home.2010-09-24_14.12.38_31 24-Sep 14:14 bacula-dir JobId 38548: Using Device “MegaFile-latens” 24-Sep 14:09 latens-fd JobId 38548: DIR and FD clocks differ by -307 seconds, FD automatically compensating. That’s 5 minutes. It shouldn’t be varying by that much. So I started ntp. That’s when I noticed it was not being started by /etc/rc.conf. But I thought

ntp wasn’t running but Nagios didn’t notice Read More »

Sending out a URL for password reset

Quite some time ago, FreshPorts and The FreeBSD Diary both moved from clear text passwords to password hashes. As such, you are no longer able to recover your password. You had to email me. This is extra work for everyone. Let us automate this. The first, step, is a table: create table user_password_reset( user_id int not null, date_requested timestamp with time zone default (‘now’::text)::timestamp(6) with time zone, ip_address inet not null, token text

Sending out a URL for password reset Read More »

More RAID oddness

After running the 3Ware diagnostic script, the status of the array went to OK. A short time later, it reverted to this $ sudo /usr/local/sbin/tw_cli info c0 u0 Unit UnitType Status %RCmpl %V/I/M Port Stripe Size(GB) ———————————————————————— u0 RAID-0 OK – – – 64K 195.548 u0-0 UNKNOWN UNKNOWN – – p0 – 104.314 u0/v0 Volume – – – – – 195.548 But this differs from the web output (image) which is rather similar

More RAID oddness Read More »

Scroll to Top