Author Archives: admin

To dump a mysql database use the mysqldump command and pipe it to gzip on the fly so the resulting backup file is compressed with this command: mysqldump -u[uname] -p [dbname] | gzip – > backupfilename.dmp.gz To restore this on … Continue reading →

Upgrading to Ubuntu 10.10 caused my HDPVR ir blaster to stop working, again… I had to re-figure out how I got it working int he first place, so I figured I’d write it down this time. Ubuntu 10.10 comes with … Continue reading →

To move a subversion repository just dump the repository. Here is a little script to dump all /var/svn repositories to their own portable dump.gz file: #!/usr/bin/perl ## backup each repository in /var/svn to a file dirname.svn.dmp.gz ## and push to … Continue reading →

NOTE: This can only be done on filesystems that can be unmounted. (i.e. You can’t do it on /root unless you boot from a rescue CD ) First unmount the file system umount /big1 Next, convert ext3 –> ext2 filesystem … Continue reading →

If you need to move a mysql database’s data files to another partition because space on /var/lib/mysql is getting low you can do this: 1) Shut down the database service mysqld stop 2) move the database files using cpdir cd … Continue reading →

Any samba shares need to have the context changed. chcon -R -t samba_share_t /cc_share If you want to have home directories not enforce SE linux permission denial for homes just issue this command: setsebool -P samba_enable_home_dirs 1

Configuring Apache on CENTOS: Just some random notes on what I had to do to get my Perferred tools installed on Apache under centos: yum install php-Smarty php-pear php-pear-MDB2 php-mysql To get pear configured I ran these commands: pear upgrade … Continue reading →

Jason came up with this nifty formula to calculate the fiscal year in excel based on a string in the YYYY-MM-DD format. It could be adapted to support other formats by changing the MID substring values ( MID is the … Continue reading →

Notes from 3/8/2010  troubleshooting crl issues. Users called and could not access the cobra web site. They were using certificates issued by Verisign – specifically: CN=VeriSign Client External Certification Authority – G2 I checked our page using the command: openssl … Continue reading →

We’ve got data that uses a funky date format — not a true julian date  but the Year followed by the DAY of the year. i.e. 2010005 = January 5th, 2010 2010031 = January 31st 2010 2010365 = December 31st … Continue reading →