cPanel upgrade to 11.50.x – issues with horde database ?

Prior to cPanel & WHM version 11.50,  Horde user data was stored in a single server-wide MySQL database. However, in 11.50, cPanel moved these data to individual SQLite database for each cPanel account.

Recently, during the upgrade, several users are seeing this failure message :

While attempting to back up Horde database, mysqldump did not exit cleanly: 2

For more information about the exact nature of the failure, review the /var/cpanel/logs/horde_mysqltosqlite_log file. cPanel & WHM versions 11.50 and later require SQLite for Horde data storage. Any Horde data that the system could not migrate is not visible to Horde users.

Review the log file as mentioned and see if the entire conversion has failed.

The command to perform the conversion in full on a server that did not get a chance to begin the conversion would be :

# /scripts/horde_mysqltosqlite

If you encounter a server that has been partially completed according to the output of the conversion process  /var/cpanel/logs/horde_mysqltosqlite_log , then it can be performed for a single user as per the logs using the following command :

# /usr/local/cpanel/3rdparty/bin/perl -MCpanel::Horde::MySQLToSQLite -e 'Cpanel::Horde::MySQLToSQLite->new->convert_user("cpanelaccountname")'

Replace ‘cpanelaccountname‘ with the concerned cpanel account name viewed from the logs !

 

Corrupt Roundcube tables in WHM ?

Are you getting a message from cPanel saying something like ?


check_mysql has determined that there are corrupted database tables .

cPanel & WHM has determined that the following database tables are corrupt: 

Error : Table 'roundcube.contacts' doesn't exist
roundcube.identities.
Error : Table 'roundcube.identities' doesn't exist
roundcube.messages
Error : Table 'roundcube.messages' doesn't exist
roundcube.session
Error : Table 'roundcube.session' doesn't exist

The roundcube database on the server might have got corrupt. You can re-generate the database by stopping the MySQL service, moving away the corrupt ones, restarting the service and then moving ahead with updating roundcube :

# /etc/init.d/mysql stop

# mv /var/lib/mysql/roundcube/ var/lib/mysql/roundcube_bk

# /scripts/restartsrv_mysql

# /usr/local/cpanel/bin/update-roundcube --force

Once this is done, you will be able to access roundcube and the databases will be fixed !

 

Upgrade / install a different version of Python in CentOS !

The Python version which comes along with CentOS is usually 2.4.x, which is way behind and some of the applications / scripts would require a newer version of Python.

Upgrading Python in a cPanel environment using yum is not preffered as it may break services / managers including yum which is dependent on Python.

The best option will be to install a different version of Python at a different location. The default Python binary will be at /usr/bin/python. We can install the newer one at an alternate location. Following steps will help you :

cd /usr/src

wget https://www.python.org/ftp/python/3.0/Python-3.0.tgz

( You can download a different version if you prefer, just go to the above URL – deleting upto /3.0.. and check for the versions )

tar -xvzf Python-3.0.tgz

cd Python-3.0

./configure –prefix=/usr/local

make

make install

Now, Python3.0 will be installed in /usr/local and the binary will be available at /usr/local/bin/python3.0 and you can use this path as reference to scripts / apps which require the newer version.

That’s it !

 

Remove the option to change the theme for a cPanel user !

There might be situations in which a particular cPanel user mess with his themes and you would want to limit his privilages so that he cant change the theme to a specific one or two. Perhaps you do not want him to change to X Theme or Paper Lantern.

To do this, login to your server as root and create the following file :

/var/cpanel/themes.conf

Edit the file and mention the list of themes which you want to be in the switch theme dropbox in cPanel interface.

For example, if you do not want X theme, the content of the above file would be :

 

# cat /var/cpanel/themes.conf
x3
paper_lantern
x2

If you want the X theme and do not want paper_lantern, just give x in place of paper_lantern in the file.

That’s it !

 

MySQL databases not showing up space in cPanel

When trying to view the databases from the cPanel interface of an account, you might end up with no values at all. However, if you check the backend, you can find that these database folders consumes space.

To fix this issue, SSH to the server and open the file :  /var/cpanel/cpanel.config and make sure the variable disk_usage_include_sqldbs is set to 1 ( instead of 0 )

Once that change is made, hit the following from the shell :

# /scripts/update_db_cache

This should fix the issue !

 

Run FSCK without password during the startup !

You might have a situation in which you need to run an FSCK in your server and you do not have a root password or you do not get the desired login prompt due to any disk issues, which might need an FSCK.

You can try the following steps to attempt an FSCK :

* Reboot

* Edit the grub

Edit grub entry by pressing ‘e’

Edit the kernel line by pressing ‘e’

Add the following at the end of the kernel line: init=/bin/bash

Press enter to save and ‘b’ to boot

The above given statement boots straight into a shell without any password. You can now manually run the FSCK using commands such as :  fsck -y /

 

Windows 10 Insider Preview Build 10074 (April Update) is available now: Let’s see what’s new

Microsoft made some pretty cool Windows 10 announcements at the Build 2015 happening at San Francisco, with it came latest Windows 10 insider Preview Build 10074. This new build is available to both the Fast and Slow ring of Windows Insiders (The Windows Insider program by Microsoft allows users to sign up for early builds of the Windows operating system.), which also means that ISOs are too available for those who like a clean install. According to the blog post by Microsoft this version of early build comes with lot of subtle changes and improvements, along with some more evolved features. Many of the changes were influenced directly by Windows Insiders feedbacks. One of those changes is the reintroduction of some Aero Glass elements in the UI. Also Microsoft promises to use insider feedback directly to shape how their feature teams operate, and they hope that Windows 10 will be the best version of Windows yet because the public have a direct hand in its creation.One other subtle change is that Microsoft has renamed its “Technical Preview” to “Insider Preview” to reflect the importance of the Windows Insider community in how they’re building Windows 10.

Win 10 PC
Windows 10 PC

Continue reading Windows 10 Insider Preview Build 10074 (April Update) is available now: Let’s see what’s new

Wrong permissions when uploaded over SFTP ?

When uploading files / folders via SFTP, do you get the wrong / unintended permissions ? This might be evident when you get the permission of a file as 664 when uploaded via FileZilla over SFTP, and you get 644 when the same file is done over FTP.

This is due to the different umask setting for the different services.

To change this unintended behavior for SFTP, open the SSH configuration at /etc/ssh/sshd_config. Add this particular line :

Subsystem sftp /usr/libexec/openssh/sftp-server -u 022

022 means the permission for your files will be 644 (rw-r–r–) and for your directories 755 (rwxr-xr-x)


002 means the permission for your files will be 664 (rw-rw-r–) and for your directories 775 (rwxrwxr-x).

Once this is added, restart SSH service !

 

Blocking all mails originating from a domain in your cPanel server !

Basically, there are times when a particular domain in your server is involved in spamming or excessive mail delivery and you just want to block that domain alone from sending mails.  With the current setup with cPanel, it is not straightforward to establish this.

We will see how to do this step-by-step.

First, login to your WHM and navigate to, Home »Service Configuration »Exim Configuration Manager » Advanced editor

Find the portion “ROUTERS CONFIGURATION” and right under the section – PREROUTERS, give the following piece of code :

reject_domains:

driver = redirect
# RBL Blacklist incoming hosts
domains = +exim_blacklist
allow_fail
data = :fail: Connection rejected: Sorry dude :/

Once this is done, save the configuration.

Next, SSH to your server and open the file /etc/exim.conf for editing.

Open it and right after the first line (usually it is something like)  “#!!# cPanel Exim 4 Config”,  give in the following and save the file :

domainlist exim_blacklist = lsearch;/etc/eximblacklist

Save the file and restart exim.

Now, all you need to do is enter the concerned domain(s) in the file ‘/etc/eximblacklist‘ ( one domain – each line )

Now, when you test to see if you can send a mail from the domain, the following can be seen in logs :

DATE H=localhost (xxxxx]:44411 sender verify fail for <test1@domain.com>: Connection rejected: Sorry dude :/

This is it, do you still face any issue ? Post a comment below with the error / issue you get !

 

Clicking on email accounts from cPanel throwing an error ?

When you click on email accounts from cPanel, do you face this error ?

A fatal error or timeout occurred while processing this directive.

Undefined subroutine &Cpanel::ExpVar::expand_and_detaint called at cpanel.pl line 963.main::real_cpexectag(“<?cp StatsBar::stat( [p class=\”caution\” style=\”margin:20px 0\””…) called at cpanel.pl line 4293main::dotag_finished_headers(0) called at cpanel.pl line 4110 main::cpanel_parseblock(“<cpanel setvar=\”headerimg=../images/mailmenu.gif\”>\x{a}<cpanel se”…) called at cpanel.pl line 4024 main::y(GLOB(0x47fb938)) called at cpanel.pl line 5393 main::run_standard_mode() called at cpanel.pl line 828

This is due to a bug in x3 theme in cPanel. Reverting the theme to paper_lantern should fix this error ! I was not able to find any other fix after hours of searching !

Hope it helps !

 

 

%d bloggers like this: