|
|
Resource containers for FreeBSD jailsJuly 14th, 2010The FreeBSD Foundation says:
http://lists.freebsd.org/pipermail/freebsd-announce/2010-July/001335.html A simple nested loopJuly 11th, 2010In a previous post, I wrote about a suspected LIMIT problem. It turns out that suspicion proved correct. The solution was to move to a nested query which limits the underlying data and then allows the outer query to grab all the associated fluff that surrounds it. Here is the fix to the original code:
The query (greatly simplified), before, the fix was: With the fix, the query becomes: How many FreshPorts accounts are enough?April 28th, 2010I found this interesting. The usual FreshPorts logging indicated an unusual number of account creations in a short amount of time. So I went looking. I found one IP address had created 20 logins. freshports.org=# SELECT ip_address, freshports.org-# count(ip_address) freshports.org-# FROM users freshports.org-# GROUP BY ip_address freshports.org-# ORDER BY 2 DESC freshports.org-# LIMIT 2; ip_address | count ---------------+------- 0.0.0.0 | 1203 95.211.27.210 | 38 (2 rows) freshports.org=# Ignore that 0.0.0.0. That indicates a user which was created before the ip_address field was added to the table. So…. what’s going on here? OK, so he’s doing this persistently. I sent him an email earlier. No reply. Shocking. So his next attempt will redirect him to this page. Bacula - errors with 5.0.0 backup catalogMarch 23rd, 2010While creating the FreeBSD package for 5.0.0, I noticed a few new things to be aware of. With 5.0.0 comes a new backup catalog script. It parses the bacula-dir.conf file and extracts what it needs from that. This means you only need to specify the database connection information in one place and it is not passed to a script via the command line. If you see this error while running that script:
Then I suspect the permissions on make_catalog_backup.pl are insufficient for Bacula to run it. I made mine chown bacula:bacula and chmod 744: -rwxr-xr-- 1 bacula bacula 4120 Jan 25 17:10 make_catalog_backup.pl If you see this error:
Then chances are the permissions on bacula-dir.conf or dbcheck are insufficient. Make sure this command works: # su -m bacula -c '/usr/local/sbin/dbcheck -B -c /usr/local/etc/bacula-dir.conf' catalog=MyCatalog db_name=bacula db_driver= db_user=bacula db_password= db_address= db_port=0 db_socket= db_type=PostgreSQL working_dir=/var/db/bacula If you get: /usr/local/sbin/dbcheck: Permission denied. Make sure bacula is allowed to run dbcheck. I use this: -rwxr-xr-- 1 root bacula 100225 Jan 25 17:12 dbcheck If you get this, check the permissions on bacula-dir.conf:
I use this: -rw-r----- 1 root bacula 9095 Jan 25 17:16 bacula-dir.conf Finally, to be sure, run this command: su -m bacula -c '/usr/local/share/bacula/make_catalog_backup.pl MyCatalog' and if that runs fine, Bacula should be able to run it. Also, if during the backup, you see permission errors on pathhierarchy or pathvisibility then the database upgrade wasn’t run as the correct user. You may have to adjust the owner of the database to match that of NOTE: This was originally posted to the Bacula users mailing list on 1 January 2010. power failure and gmirrorMarch 15th, 2010From this morning’s log after a weekend power failure: Mar 15 09:15:45 subie kernel: GEOM_MIRROR: Device gm0: rebuilding provider ad8 finished. Mar 15 09:20:58 subie fsck: /dev/mirror/gm0s1f: UNREF FILE I=35 OWNER=root MODE=100400 Mar 15 09:20:58 subie fsck: /dev/mirror/gm0s1f: SIZE=151568652480 MTIME=Mar 13 16:03 2010 (CLEARED) Mar 15 09:20:58 subie fsck: /dev/mirror/gm0s1f: UNREF FILE I=15356429 OWNER=dan MODE=100644 Mar 15 09:20:58 subie fsck: /dev/mirror/gm0s1f: SIZE=216159 MTIME=Mar 13 15:35 2010 (CLEARED) Mar 15 09:20:58 subie fsck: /dev/mirror/gm0s1f: Reclaimed: 0 directories, 3 files, 97 fragments Mar 15 09:20:58 subie fsck: /dev/mirror/gm0s1f: 796585 files, 14968261 used, 56710199 free (218983 frags, 7061402 blocks, 0.3% fragmentation) Mar 15 09:21:27 subie fsck: /dev/mirror/gm0s1d: 27569 files, 188950 used, 1307441 free (11913 frags, 161941 blocks, 0.8% fragmentation) No ZFS there… Pharma GCP standardsMarch 13th, 2010A friend is looking for a job. She specializes in testing of software systems for compliance with Pharma GCP standards. Please share this post. NRPE: Unable to read outputMarch 10th, 2010After rebooting kraken to take a photo, I found nagios was displaying an error for my smartmon checks: NRPE: Unable to read output. Running the command by hand on the nagios server, I found: $ /usr/local/libexec/nagios/check_nrpe2 -H kraken -c check_smartmon_ad24 NRPE: Unable to read output But from the remote server I got: # /usr/local/libexec/nagios/check_smartmon -d /dev/ad24 OK: device is functional and stable (temperature: 29) I restarted npre and the problem went away… not sure what this is yet…. smartmontools - patchMarch 10th, 2010The smartmon bug I mentioned a few days ago has a patch. It was submitted 24 Jan 2010 but was closed after the maintainer said he would release a new distfile soon. It hasn’t arrived. I sent him and email tonight as a follow up the PR. In the meantime, I’ve applied the patch to my own syst NewEgg - RMAMarch 10th, 2010NewEgg has received and processed my returned purchases. I’m impressed. I mailed them on Thursday (I think) and here it is, Wednesday. I should expect to see the refunds on my credit card within 2-3 days. Interesting hardware siteMarch 8th, 2010I do like CoolDrives.com. I was shown this quick swap drive tray and started hunting around. This spare parts page is interesting and reminds me that I want to buy different cables for the file server. Also neat are these hard drive cases for when your HDD is not in use. |
|