manually updating java in ubuntu
Wed, 02/27/2013 - 09:59 — sandipBelow is outlined the process of updating to the latest JDK in ubuntu and updating the alternatives link manually to point the the latest java:
Step 1: Download:
wget http://download.oracle.com/otn -pub/java/jdk/7u15-b03/jdk-7u1 5-linux-x64.tar.gz
cd /usr/lib/jvm/
tar -xzf ~/downloads/jdk-7u15-linux-x64 .tar.gz
Step 2: If java-7-sun already exists, the below is all that is needed if not skip to step 3 if this is the first time it is setup:
unlink java-7-sun
ln -s jdk1.7.0_15 java-7-sun
Step 3: If java-7-sun link does not already exists:
ln -s jdk1.7.0_15 java-7-sun
update-alternatives --install "/usr/bin/java" "java" "/usr/lib/jvm/java-7-sun/ bin/java" 1
update-alternatives --install "/usr/bin/javac" "javac" "/usr/lib/jvm/java-7-sun/ bin/javac" 1
update-alternatives --install "/usr/lib/mozilla/plugins /libjavaplugin.so" "mozilla-javaplugin.so&qu ot; "/usr/lib/jvm/java-7-sun/ jre/lib/amd64/libnpjp2.so" ; 1
update-alternatives --install "/usr/bin/javaws" "javaws" "/usr/lib/jvm/java-7-sun/ bin/javaws" 1
Step 4: Choose the java just installed as default:
update-alternatives --config java
update-alternatives --config javac
update-alternatives --config javaws
update-alternatives --config mozilla-javaplugin.so
Resetting WordPress admin password
Fri, 02/22/2013 - 14:09 — sandipHere is the sql to reset admin password for wordpress:
update wp_users set user_pass=md5("NEWPASS&qu ot;) where ID=1;
Even if the passwords are salted, you can still replace the password with an MD5 hash.
Install yum from centos vault
Tue, 02/12/2013 - 14:53 — sandipI had to update an old release of CentOS-5.5 on an OpenVZ container where yum was not available.
The below script should automatically download and install the required rpms from "vault.centos.org".
#!/bin/bash
# install_yum.sh
rpms="
&nbs p; rpm-libs-4.4.2.3-18.el5.x86_64 .rpm
&nbs p; popt-1.10.2.3-18.el5.x86_64.rp m
&nbs p; rpm-4.4.2.3-18.el5.x86_64.rpm< br /> &nbs p; python-elementtree-1.2.6-5.x86 _64.rpm
&nbs p; python-iniparse-0.2.3-4.el5.no arch.rpm
&nbs p; python-sqlite-1.1.7-1.2.1.x86_ 64.rpm
&nbs p; rpm-python-4.4.2.3-18.el5.x86_ 64.rpm
&nbs p; python-urlgrabber-3.1.0-5.el5. noarch.rpm
&nbs p; yum-fastestmirror-1.1.16-14.el 5.centos.1.noarch.rpm
&nbs p; yum-metadata-parser-1.1.2-3.el 5.centos.x86_64.rpm
&nbs p; yum-3.2.22-26.el5.centos.noarc h.rpm
"
for rpm in $rpms
do
rpm -Uvh --nodeps http://vault.centos.org/5.5/os /x86_64/CentOS/${rpm};
done
Disabling IDLE in courier-imap
Wed, 02/06/2013 - 09:26 — sandipApple and BlackBerry email clients has a configurable setting to use the IMAP IDLE functionality to stay logged in, periodically checking email. This causes imapd to run out of daemons and stop responding. One solution is to raise MAXDAEMONS in /etc/courier-imap/imapd, but will eventually cause high loads on the server.
The better solution is to disable IDLE entirely in /etc/courier-imap/imapd by removing "IDLE" option from "IMAP_CAPABILITY".
Change:
IMAP_CAPABILITY="IMAP4rev 1 UIDPLUS CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA IDLE"
To:
IMAP_CAPABILITY="IMAP4rev 1 UIDPLUS CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA"
Upon courier-imap restart, this should prevent connections from persisting.
Telnet to imap port 143 to verify that the IDLE option is not present anymore in CAPABILITY response from the server.
force qmail to process mail queue
Tue, 01/08/2013 - 22:16 — sandipUse qmail-qstat or qmail-qread to check the messages in queue.
Run qmail-tcpok to clear out the TCP timeout table.
After that, send the "ALRM " signal to the "qmail-send" process, and Qmail will process all messages in the queue immediately:
kill -ALRM `ps ax | grep [q]mail-send | awk '{print $1}'`
monitor and kill long running mysql select statements
Fri, 12/21/2012 - 17:29 — sandipBelow script checks and kills any sql SELECT statements that has been running for more than 60 seconds. The script can be added to a cron task to be run periodically. Make sure to check the log file it creates to keep an eye on the long running sql statements and tune it.
#!/bin/bash
LOG=/tmp/kill_mysql.log
SECONDS=60
echo "####" `date` "####" >>${LOG}
PIDS=$(mysql -t -e 'show full processlist' | awk -F'|' -v seconds="$SECONDS" '$7 > seconds && toupper($9) ~ /^ SELECT/ {print $0}' | tee -a $LOG | awk -F'|' '{print $2}')
[ -n "$PIDS" ] && mysqladmin kill `echo $PIDS | tr ' ' ','`
Prior to running it, setup the root login in "~/.my.cnf" file with the login credentials:
[client]
user=root
password=xxxxxxxx
Install ImageMagick with PHP imagick extension on CentOS-5.8
Tue, 11/20/2012 - 11:27 — sandipYou can easily install ImageMagick and PHP imagick extension from remi repository. There are some dependencies from epel repository too.
yum --enablerepo=remi,epel install ImageMagick.x86_64 php-pecl-imagick.x86_64
Wireless Ad-Hoc connection sharing in Ubuntu 10.10
Fri, 11/16/2012 - 18:05 — sandip-
dnsmasq-base has to be installed:
sudo apt-get install dnsmasq-base
sudo apt-get remove dnsmasq
sudo /etc/init.d/network-manager restart
Set encryption to WEP 40/128-bit Key with a 13 characters key. (Note: You may have to experiment here according to what type of encryption with ad-hoc the device supports. WPA is not supported).
NetworkManager now should connect to itself (which means it creates the ad-hoc wireless network and routes any Internet traffic to your wired network interface). Now, connect with the client(s), and you should have a working Internet connection.
You have to make sure that this connection is shared to other computers and devices (clients). Make sure that the Connect automatically check-box is selected and on the IPv4 Settings tab make sure that the Method option is set to "Shared to other computers".
Updating OpenVZ vzctl on CentOS-5.8
Wed, 11/14/2012 - 11:27 — sandipWhile updating vzctl to latest on CentOS-5.8, I was getting the below error:
# yum update vzctl
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* openvz-kernel-rhel5: mirror.fdcservers.net
* openvz-utils: mirror.fdcservers.net
Excluding Packages in global exclude list
Finished
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package vzctl.x86_64 0:4.1-1 set to be updated
--> Processing Dependency: vzctl-core = 4.1-1 for package: vzctl
--> Processing Dependency: libvzctl-4.1.so()(64bit) for package: vzctl
--> Processing Dependency: libcgroup.so.1()(64bit) for package: vzctl
--> Running transaction check
---> Package libcgroup.x86_64 0:0.37-4 set to be updated
---> Package vzctl-core.x86_64 0:4.1-1 set to be updated
--> Processing Conflict: vzctl conflicts ploop-lib < 1.5-1
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package ploop-lib.x86_64 0:1.5-1 set to be updated
--> Processing Conflict: ploop-lib conflicts vzkernel < 2.6.32-042stab061.1
--> Processing Conflict: ploop-lib conflicts vzkernel < 2.6.32-042stab061.1
--> Processing Conflict: ploop-lib conflicts vzkernel < 2.6.32-042stab061.1
--> Processing Conflict: ploop-lib conflicts vzkernel < 2.6.32-042stab061.1
--> Finished Dependency Resolution
ploop-lib-1.5-1.x86_64 from openvz-utils has depsolving problems
--> ploop-lib conflicts with ovzkernel
Error: ploop-lib conflicts with ovzkernel
You could try using --skip-broken to work around the problem
You could try running: package-cleanup --problems
&nbs p; &nbs p; &nbs p; &nbs p; package-cleanup --dupes
&nbs p; &nbs p; &nbs p; &nbs p; rpm -Va --nofiles --nodigest
The program package-cleanup is found in the yum-utils package.
Turns out that ploop is no longer required for vzctl on CentOS-5.8 and can be removed:
yum update problem on CentOS 5.8 server
"Since you have RHEL5-based kernel that do not require ploop, you can remove ploop when installing vzctl-4.0. I have made vzctl not requiring ploop by dynamically loading it when it's available. Note that vzctl is not requiring ploop anymore, it just conflicts with the old version of it."
The solution was to remove ploop in single transaction as mentioned:
# yum shell
> update vzctl
> remove ploop\*
> run
> quit