WebScHoLaR Dot NET

I have seen this issue many times when clients complain that they cannot login to VPS using RDP. Most of the time its because they turn Windows Firewall On but do not configure it so it just denies access to everything. Following commands can be executed from the command prompt of Node to turn Windows Firewall Off inside any VPS and set the Firewall services to not start automatically.

vzctl exec VEID net stop ipnat
vzctl exec VEID net stop policyagent
vzctl exec VEID sc config policyagent start= demand
vzctl exec VEID sc config ipnat start= demand

(NOTE: Replace VEID with actual VPS IP that can be checked by “vzlist -a” command)

New Plesk versions 8.6+ comes with MSDE (Microsoft SQL Desktop Edition) by default so you just need to follow the below mentioned steps in order to configure it.In earlier Plesk versions, MSDE needs to be installed. This can be done by downloading the MSDE from Microsoft site or installing “msde” virtuozzo template. Virtuozzo template can be installed to VPS using VZMC or “vzpkgadd” command. Continue reading »

In Virtuozzo, we can migrate a VPS from one hardware node to another using “vzmigrate” command. The migration will also include the IP addresses so you do not have to go back and re-add them. We may need to clear the arp cache for the IP to begin routing to the new network device.  If you are stopping the VPS prior to the migration then arp cache should not be a problem. I am taking VZNodeA and VZNodeB for reference and migrating a VPS from VZNodeA to VZNodeB. Continue reading »

Nowadays everyone prefers watching a video rather than reading the text. Youtube has introduced a new concept for information sharing. There are several vendors who offer product to provide the  functionality like youtube and these softwares require some modules that are usually called video sharing modules. Here is a quick way to install these modules. Continue reading »

We need to migrate the data from a server to a new server often and it can be because of several factors like

• Old server is having hardware issues and need to be replaced completely
• Server is being upgraded and full data needs to be transferred
• The servers are being transferred from one data center to another

and many more. This script can be used to migrate all user data and the cPanel config files from Old server to new Server. Continue reading »

Backup option is available in both cPanel and WHM. Backup option in cPanel can not be set to automatic backups and the user has to login and manually generate the backup. Backup feature in WHM allows scheduled backups but Resellers are not provided with that option. As backup is a must thing so I wrote a small bash script that will backup the databases and the accounts data for all the accounts under the mentioned reseller and transfer the backup to a backup server. This script requires that the backup server should allow scp or rsync and supports SSH Authentication Keys.This script doesn’t need any update if the reseller adds new accounts or any user creates new databases. Continue reading »

If after upgrading the MySQL to higer version, PhpMyAdmin still reports the old MySQL version then following steps should be performed:

mv /usr/local/cpanel/lib/libmysqlclient.so.14 /usr/local/cpanel/lib/libmysqlclient.so.14.backup
ln -s /usr/lib/libmysqlclient.so.15.0.0 /usr/local/cpanel/lib/libmysqlclient.so.14

You may have experienced this issue that the Horde doesn’t login to the mailbox and on clicking the Login button, the page just refreshes and continue to load the same login page. The most possible reason is that the Horde session table is corrupt. I will explain step by step that how we can check and fix this session table issue. Continue reading »

Collation refers to the character set used to store data in text fields and is necessary to provide support for all of the many written languages of the world. Collation can be changed for the database, tables or even columns. Continue reading »

A short bash command to update the serials for all the domains on the server. You can specify the new serial number and change the directory where the DNS zone files are present. I used this command when I performed bulk migrations.

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