Monday, 30 June 2014

Trigger an action via CSF when server load is high on Server


Config Server Firewall works well by default. But if you customize it some, it can be even more poweful of a tool. When your load is high, you usually receive an alert from CSF. However, those reports contain a limited amount of information. If your receive these high server alerts often and want more information about what is actually going on when high load averages occur, then do the following. You can have lfd send you custom reports by using the PT_LOAD_ACTION option within the CSF configuration.First, login to shell.


Then create a file call /etc/csf/load.sh


touch /etc/csf/load.sh
nano /etc/csf.load.sh

Add the following contents to the file:



#!/bin/sh

>/etc/csf/csf.report

iostat -d 1 5 >> /etc/csf/csf.report

iostat -x -d 1 5 >> /etc/csf/csf.report

mpstat -P ALL >> /etc/csf/csf.report

top -b -n 1 >> /etc/csf/csf.report

netstat -autpn

mail -s “Load Report” root < /etc/csf/csf.report



Save the file.


Then, change the chmod settings of the file:


chmod +x /etc/csf/load.sh

Finally, edit /etc/csf/csf.conf and goto the section labeled “PT_LOAD_ACTION”. Add “/etc/csf/load.sh” so that it now looks like this:


PT_LOAD_ACTION = "/etc/csf/load.sh"

Restart csf:

csf -r

That’s it! Now when you receive a high CPU load alert, you will also receive an email with a lot more information in it. If you want CSF to automatically restart apache too, you can add the following line to the end of the load.sh file:


service httpd restart

And then save the file and restart config server.



Thursday, 26 June 2014

Upgrading PostgreSQL

To upgrade a PostgreSQL installation start by dumping all the existing databases. You should do this before stopping the current database server
$ PGUSER=postgres /usr/bin/pg_dumpall > dump.sql
$ sudo /etc/init/d/postgresql stop
$ sudo mv /usr/local/pgsql /usr/local/pgsql.old


Build and install your new version. Be sure to create a PGDATA directory that is owned by the postgres user. Initialize the PGDATA directory with initdb
$ sudo mkdir /usr/local/pgsql/data
$ sudo chown postgres:postgres /usr/local/pgsql/data
$ sudo -u postgres /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data


Once you have created your new database, start the new database server and populate the new database with the data you dumped from your old system:


$ sudo -u postgres /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
$ sudo -u postgres /usr/local/pgsql/bin/psql -d postgres -f dump.sql



Upgrading PostgreSQL

Problem with yum update

Following is the error that occurred :

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
addons | 951 B 00:00
base | 2.1 kB 00:00
extras | 1.1 kB 00:00
updates | 1.9 kB 00:00
Not using downloaded repomd.xml because it is older than what we have:
Current : Tue Feb 9 08:57:23 2010
Downloaded: Tue Jan 26 09:27:44 2010
Excluding Packages in global exclude list
Finished
Setting up Update Process
No Packages marked for Update

Solution :


Run the following two commands :

yum clean all
yum check-update

That should fix the issue.



Problem with yum update

How to Enable Sound in VMWare Server 2.0


So I had switched from VirtualBox to VMWARE since its free and has much easier bridging behind the scenes for my virtual machines. Currently I run Linux as my main computer and well the necessities of certain office windows products I was missing and their Linux counterparts didn’t work as well. I had created a windows xp virtual machine from my computers license key since I no longer have the thing installed.


Creating the virtual machine and setting up Linux went fine and smooth. Once in windows I started to tweak it and noticed there is no sound. I had shut down the machine and tried to add a sound device on “auto detect” was my only option. Booting the virtual machine I received an error that the sound was not able to be initialized, where I started to search the internet with no luck.


Finally I had figured it out and I have SOUND! Below you can find the steps I took and hope they work out as well for you as for me.


First is first – figure out what your device is for sound. I loaded up amarok and went to the configuration. From there to “Engine” and there it beholds “Device:”. For me there were two options:






1 /dev/dsp




2 /dev/sound/dsp



I had restarted amarok with each as my device and figured out that /dev/dsp was the one for me.


Then go to “/var/lib/vmware/Virtual Machines/” and open “.vmx” and look for the following lines:






sound.present = "TRUE"





sound.allowGuestConnectionControl = "FALSE"




sound.fileName = "/dev/dsp" (changed from -1)





sound.autodetect = "FALSE" (changed from TRUE)




sound.pciSlotNumber = "36"




sound.startConnected = "TRUE"



Save the file and reboot the virtual machine and there we have sound! Isn’t that fantastic?!? If you have comments or suggestions please leave them as others might be experiencing the same issues as you.





How to Enable Sound in VMWare Server 2.0

How to use gmail with mutt

For sending and receiving you mails, with the famous mail client mutt, insert the following lines into your ~/.muttrc


set smtp_url = “smtp://username@smtp.gmail.com:587/”
set smtp_pass = “password”
set from = “username@gmail.com”
set realname = “Your Real Name”


you can also use fetchmail to get your mail automatically.
so, edit the ~/.fetchmailrc and add the following :


poll smtp.gmail.com protocol imap user “username” password “password” mda “/usr/bin/procmail -d %T” ssl


That’s great if we will receive notification when a new mail arrived.
for that add the following lines into a shell script, we will name it checkmail.


$ cat >checkmail<<EOF
#!/bin/sh
if [ "$1" = "-v" ]; then
EXTRAARG=”-v”
fi
fetchmail -a -K $EXTRAARG >/dev/null 2>&1


if [ "$?" = "0" ]; then
DISPLAY=:0.0 /usr/bin/notify-send -t 0 -u critical -h “int:x:168? -h “int:y:100? -i /home/mezgani/photo/mail.jpg “?????? ????” “New mail received”
fi
EOF


Ok, right now we will define an entry to crontab, which will call the checkmail script every 5min.
of course change the path /home/handrix/bin/checkmail by the emplacement of the script in you host.


*/5 * * * * /home/mezgani/bin/checkmail



How to use gmail with mutt

Wordpress mod_rewrite rules taking over mod_status

While working on setting up a monitoring solution for a big wordpress installation, I realized that the server-status url was not working as expected even ifmod_status was configured correctly:


ExtendedStatus On


SetHandler server-status
Order deny,allow
Deny from all
Allow from some_ips


The .htaccess wordpress rules were taking over this and the server-status url was returning a page not found error from within wordpress. This was happening because of the way how the rewrite rules are setup to handle all the permalinks on the site, and for any non-existing file send it to index.php:
# BEGIN WordPress


RewriteEngine On
RewriteBase /
RewriteCond %REQUEST_FILENAME !-f
RewriteCond %REQUEST_FILENAME !-d
RewriteRule . /index.php [L]


# END WordPress

This works fine with any aliases defined in apache, but the mod_status handler was going to the rewrite rules first, hence the problem. This is not a wordpress problem, and should happen with any other application (like zend framework is one other example that comes to my mind right now) that uses the same type of catch-all rewrite rules to handle all the urls inside the application. The solution in this case is to specifically add a rewrite rule to not have the server-status url processed and sent to the default rule:
RewriteCond %REQUEST_URI !=/server-status
and the wordpress rewrite rules should look like this:
# BEGIN WordPress


RewriteEngine On
RewriteBase /
RewriteCond %REQUEST_URI !=/server-status
RewriteCond %REQUEST_FILENAME !-f
RewriteCond %REQUEST_FILENAME !-d
RewriteRule . /index.php [L]


# END WordPress



Wordpress mod_rewrite rules taking over mod_status

Cannot send emails- RoundCube just shows “Sending Message”

I found a problem with Roundcube, it shows sending message and hangs up there and actually it doesn’t send message anymore. I found the following solution here.


Problem with Roundcube, installed when updated to newest CURRENT release. – Page 3 – cPanel Forums:


vi /usr/local/cpanel/base/3rdparty/roundcube/config/main.inc.php


and changed


$rcmail_config['smtp_user'] = ‘%u’;
to
$rcmail_config['smtp_user'] = ”;



Cannot send emails- RoundCube just shows “Sending Message”