Horde mail users not authorized (Linux)

Running tail /usr/local/psa/var/log/maillog' shows LOGIN FAILED and "unable to open mail authentication database: No such file or directory"

You can verify this by running 'ls /var/lib/plesk/mail/auth/passwd.db', which will return "No such file or directory".

Fix this by running the following command as root:

# /usr/local/psa/admin/sbin/mail_auth_dump

Error when logging in to Horde ("fatal error. DB Error: connect failed") / Linux

* Check /etc/my.cnf and make sure the following line exists:

socket=/var/lib/mysql/mysql.sock

Run the following command and make sure you can no errors are received:

#mysql -uhorde -p`cat /etc/psa/.webmail.shadow` -D horde

Type 'quit' to exit mysql.

If /etc/psa/.webmail.shadow is missing, create the file and type a password into the file. The file should only contain one password. Save the file and then update mysql with the new password:

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D mysql

Now type this at the mysql prompt:

update user set password=password("PASSWORD_FROM_WEBMAIL.SHADOW") where user="horde";

FLUSH PRIVILEGES;

# Also check /var/log/psa-horde/psa-horde.log for any errors. If you see something like this:

DB Error: connect failed: [nativecode=Access denied for user: 'root@localhost' (Using password: NO)]

# open the /etc/php.ini file and make sure sql.safe_mode is set to off, like this:

sql.safe_mode=off

Restart Apache if you edit the php.ini file:

# /usr/sbin/apachectl -k restart

How to force update RVSiteBuilder using this command.

For force updating the RVSiteBuilde You can use the following command

# rm -f /var/cpanel/rvglobalsoft/rvsitebuilder/var/INSTALL_COMPLETE.php
# rm -f /var/cpanel/rvglobalsoft/rvsitebuilder/rvsitebuilderversion.txt
# perl /usr/local/cpanel/whostmgr/docroot/cgi/rvsitebuilderinstaller/autoinstaller.cgi

And go to root WHM/RVSiteBuilder, it will automatically rebuild the database for you. If doesn't work, please submit me the login information to the account in question or attach me the snapshot of what you did and its result.

How to install RVSiteBuilder?

1. After get the license confirmation, SSH to your cPanel server as root, download the installer using the command below:

cd /usr/local/cpanel/whostmgr/docroot/cgi/
rm -f rvsitebuilderinstaller.tar
wget http://download.rvglobalsoft.com/rvs...rinstaller.tar
tar -xvf rvsitebuilderinstaller.tar
chmod 755 addon_rvsitebuilder.cgi
rm -f rvsitebuilderinstaller.tar

2. Open root WHM, at the bottom left menu under Plugins section, you will find RVSiteBuilder Installer menu.
3. Click RVSiteBuilder Installer to begin the installation process.
4. After complete the installation, you will be sent to RVSiteBuilder Manager automatically. Please configure RV SiteBuilder immediatly.


cPanel should show the RVSiteBuilder as a feature in all cPanel users. Special note for specific cPanel skin:

* RVSkin - It will automatically integrate RVSiteBuilder to RVSkin. You may need to edit the Package-Feature list if RVSite Builder doesn't show up or you don't want some hosting packages access to it.
* X3, X Skin and some which support addon api - It will automatically display on cPanel. You also able to manage the feature list in WHM Feature Manager.
* CPSkins - You have to manually integrate it by editting file /usr/local/cpanel/base/frontend/themename/index.html. Insert



On the top of the page. And edit /usr/local/cpanel/base/frontend/themename/main.php. Place



in the area you want to show the RVSiteBuilder Icon. Don't edit file RVS2CPSkinmenu.html. Your change will be lost when you update RVSiteBuilder. If you want to edit it just copy it to the new name and change the cpanel include path to the new one.

How to enable IP tables modules for vps

You need to stop the VPS contaner first to enabled the modules.

# vzctl stop


* need to enabled the following iptables modules in vps node.

#modprobe ipt_REJECT
#modprobe ipt_tos
#modprobe ipt_LOG
#modprobe ip_conntrack
#modprobe ipt_limit
#modprobe ipt_multiport
#modprobe iptable_filter
#modprobe iptable_mangle
#modprobe ipt_TCPMSS
#modprobe ipt_ttl
#modprobe ipt_length
#modprobe ipt_state
#modprobe iptable_nat
#modprobe ip_nat_ftp
#modprobe ip_tables
#modprobe ipt_conntrack
#modprobe ip_conntrack_ftp
#modprobe ipt_REDIRECT
#modprobe ipt_owner
#modprobe ipt_recent

Then apply the following command

# vzctl set vpsid --iptables ipt_REJECT --iptables ipt_tos --iptables ipt_LOG --iptables ip_conntrack --iptables ipt_limit --iptables ipt_multiport --iptables iptable_filter --iptables iptable_mangle --iptables ipt_TCPMSS --iptables ipt_ttl --iptables ipt_length --iptables ipt_state --iptables iptable_nat --iptables ip_nat_ftp --iptables ip_tables --iptables ipt_conntrack --iptables ip_conntrack_ftp --iptables ipt_REDIRECT --iptables ipt_owner --iptables ipt_recent --save

Then start the container
# Vzctl start container

Enable AWStats Updating from Cpanel(VPS)

*You can use SSH to update the stats by issuing the following command:

# /scripts/runweblogs [username]
where [username] is the cPanel username you wish to update.

Updating Through cPanel

Sometimes, it may be easier to just enable your cPanel user accounts to update manually.

Login to WHM, then select Server Configuration -> Tweak Settings.
Scroll down to Stats and Logs.
Check the box "Allow users to update Awstats from cPanel


checking the AWStats Configuration File for a particular user.

1. Login via SSH as root
2. cd /home/username/tmp/awstats
3. grep AllowToUpdateStatsFromBrowser awstats.example.com.conf
4. It should be set to AllowToUpdateStatsFromBrowser=1
5. If not, edit the file and save.
6. restart cpanel : service cpanel restart

What is OpenEMM and How to Install OpenEMM 5.5.1 on VPS

OpenEMM is a feature-rich enterprise software for e-mail marketing, newsletters and service mails (transaction mails and event or time triggered mails). OpenEMM offers sophisticated bounce management, link tracking, lots of realtime statistics, a CMS module and a scripting feature to implement individual tasks.
-------------------------------------------------------------------------------------


Check Environment

Host: CentOS4.6_x86_64
virtualization software: OpenVZ
Guest:centos-5-i386-default-5.3-20090330
Because OpenEMM only have i386 release, so I have to create i386 VPS under CentOS4.6_x86_64

Download template:
#wget http://download.openvz.org/template/...0090330.tar.gz

Create VE:
#vzctl create 101 –ostemplate centos-5-i386-default-5.3-20090330 –config vps.basic
other settings, please visit Create My First VE under OpenVZ

Install necessary software and do prepare job:
#yum install mysql-server sendmail-cf MySQL-python
#groupadd openemm
#useradd -m -g openemm -d /home/openemm -c “OpenEMM 5.5.1″ openemm

Download jdk-1_5_0_17-linux-i586.bin:
#chmod +x jdk-1_5_0_17-linux-i586.bin
#./jdk-1_5_0_17-linux-i586.bin
#mkdir -p /opt/openemm.org/software
#mv ./jdk1.5.0_17 /usr/
#ln -s /usr/jdk1.5.0_17 /opt/openemm.org/software/java
Test the JDK:
#/opt/openemm.org/software/java/bin/java -version

#wget http://nchc.dl.sourceforge.net/sourc...5.1-1.i386.rpm
rpm -ihv OpenEMM-5.5.1-1.i386.rpm
mysql openemm

Start OpenEMM
(run as superuser)
Become the user ’openemm’ by running
#su – openemm
Change to the directory containing the startup/shutdown script.
#cd bin
To start the OpenEMM enviroment, run
#nohup OpenEMM.sh start &
To stop OpenEMM
#OpenEMM.sh stop

-----------------------------------------------------------------------

---