Repair rpm database on *nix

Filed Under (cPanel/WHM, DirectAdmin, InterWorx, Linux, Plesk) by WebScHoLaR on 24-02-2011

Tagged Under : , ,

1. Check for processes holding the rpm database open (usually in MUTEX/FUTEX states):

lsof | grep /var/lib/rpm

If it finds any, kill -9 them all.

2. Delete any temporary DB files:

rm -fv /var/lib/rpm/__*

3. Rebuild your RPM database:

rpm –rebuilddb -v -v

If you still have problems, a reboot is probably quickest, then repeat steps 2 and 3 above.

Bulk Update DNS zone files serial

Filed Under (cPanel/WHM, DirectAdmin, Linux) by WebScHoLaR on 11-12-2010

Tagged Under : , , , ,

DNS zone files in Bind are refreshed by increasing the serial number that is in the format yyyymmddXX (e.g 2010121101 i.e 11th December, 2010 and serial number is 01). In case all DNS zone files on the server need to be refreshed by incrementing serial number, this can be done as:

for i in `ls /var/named/*.db` ; do cat $i | sed ‘s/[0-9]\{10\}/2010121101/g’ > $i.new; mv -f $i.new $i; chown named.named $i ;done

This will set serial for all DNS zone files to 2010121101. Make sure to reload BIND after wards as:

[root@System ~]# rndc reload
server reload successful

Access MySQL prompt on DirectAdmin

Filed Under (DirectAdmin, Linux, MySQL) by WebScHoLaR on 11-12-2010

Tagged Under : , , ,

The default MySQL installations on Linux have root user as the Admin user that has full access. DirectAdmin setups another Database user da_admin as Super database user. Password for it is stored inside /usr/local/directadmin/conf/mysql.conf. MySQL prompt can be accessed directly on DirectAdmin as:

mysql –user=da_admin –password=`cat /usr/local/directadmin/conf/mysql.conf | grep passwd |cut -d= -f2`

To access mysqladmin on DirectAdmin system, use:

mysqladmin –user=da_admin –password=`cat /usr/local/directadmin/conf/mysql.conf | grep passwd |cut -d= -f2` processlist

Proudly Hosted by eServicesProvider