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.
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
Filed Under (DirectAdmin, Linux, MySQL) by WebScHoLaR on 11-12-2010
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