Lik`s forum

Administrating a MySQL server

Setting the password:
1. From Unix shell:
shell> mysql -u username -h hostname -p password
mysql> SET PASSWORD FOR 'username'@'localhost'=PASSWORD('new_password');

2. Directly manipulate the privilege tables:
shell> mysql -u username -h host -u username -p
mysql> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
mysql> FLUSH PRIVILEGES;

3. Using the mysqladmin command:
shell> mysqladmin -u username password new_password

In our case we were able to change password specifying host name along with user ...

Bug with MailMan ImportError: No module named korean

Sometimes, you may get the following error on cpanel error log while creating mailing list.

File “/usr/local/cpanel/3rdparty/mailman/bin/mailmanctl”, line ****, in ?
import paths
ImportError: No module named korean

FIX:

Code: Select all

uname -i


then do accordingly:

Code: Select all

yum install python-devel.i386
or
yum install python-devel.x86_64

/scripts/reinstallmailman

Short explanation of the cPanel scripts (located in /scripts/ directory):

* adddns - Adds a DNS zone.
* addfpmail - Add frontpage mail extensions to all domains without them.
* addfpmail2 -Add frontpage mail extensions to all domains without them.
* addnetmaskips - Add the netmask 255.255.255.0 to all IPs that have no netmask.
* addnobodygrp - Adds the group nobody and activates security.
* addpop - Add a Pop Account.
* addservlets - Add ...

* Linux distribution: RedHat/Fedora
* Bootloader: grub
* The current running Linux system harddisk will, from now on, be called "old harddisk."

Note:

With the arrival of kernel-2.6.20, all the harddisk device names are now /dev/sdx. It used to be /dev/hdx for ide harddisk and /dev/sdx for SCSI. The following is the old naming convention:

EIDE0 primary /dev/hda
EIDE0 secondary /dev/hdb
EIDE1 primary /dev/hdc
EIDE1 secondary /dev/hdd

With the new naming convention, the first harddisk ...

If you want to use only one php.ini file for all your sites you need to create .htaccess file in main directory (/public_html/.htaccess) and put into variable:
================
SetEnv PHPRC /location/to_dir/containing/phpinifile
================
For example:

SetEnv PHPRC /home/user/public_html/php.ini

Note: This solution highly depends on PHP mode.

Password for wordpress user can be easily changed with help of PhpMyAdmin. Navigate to the database -> users. Select to edit an entry.
Change type of the input value to MD5 and type new password.

With every cPanel installation, there is a binary located at /usr/local/cpanel/bin/cpuwatch, what cpuwatch does is that it executes the command and monitors the load, if the load goes past the set limit, it will stop the application and resume it after the load averages are below the threshold for a few seconds, the usage for it is very simply

# /usr/local/cpanel/bin/cpuwatch
Usage: cpuwatch <maxload> (<-p PID>|<command> [arguments])
maxload : system load at which throttling should ...

10 Tips for making your cPanel and WHM servers more secure
June 24th, 2007

Please note that these tips are suggestions only and cPanel takes no responsibility for modifications to individual servers, or the security practices of individual servers. Server security is a collection of compromises, as any server that allows connections could be insecure. These tips are to be followed at your own risk.

1) Use secure passwords!

Insecure passwords are the most common ...

Homepage: http://eaccelerator.net/

Choose the preferable version and install it:

Code: Select all

cd /usr/local/src
    wget http://bart.eaccelerator.net/source/0.9.5.2/eaccelerator-0.9.5.2.tar.bz2
    bzip2 -d eaccelerator-0.9.5.2.tar.bz2
    tar xvf eaccelerator-0.9.5.2.tar
    cd eaccelerator-0.9.5.2


Check if all needed modules presented in the system:

* apache >= 1.3,
* mod_php >= 4.1,
* autoconf,
* automake,
* libtool,
* m4

Sometimes php-devel package needed, because phpize function is used to compile php:

Code: Select all

yum install php-devel
whereis phpize

Commonly it`s in /usr/bin/phpize.
In this situation we should do ...

It is very easy to install zend optimizer on a cPanel based web servers, the steps are as below:

Login to your web server as root

Execute the script:

Code: Select all

/scripts/installzendopt