Mamboo login gives 500 internal server error

1.The problem is relaed to the cache folder
2./home/ruralrev/public_html/website/administrator/
3.there is folder named cache
4. move the folder

dada mail installation

http://dadamailproject.com/installation/installation_basic.html

===========================

perl should be 5.8.2 or more

How to set hostname in vps

vzctl set 8015 --hostname vps.technobros.info --save
then stop and start vps
using
vzctl 8015 start
vzctl 8015 stop

fatal error in cpanel: your allowed memory is 40 mb

Error during
/scripts/easyapache
/scripts/upcp
/scripts/makecpphp
Allowed memory is 40mb but you can use more than 90mb

Solution

===============
(07:49:19 IST) Chinthu Jemsheed: athil /etc/sysconfig/vz-scripts/ edit cheythu
(03:19:42 IST) hdinchinthuj@im.dimenoc.com/Home: PRIVVMPAGES="231072:231072"

66.7.214.45/~username is not working

go to whm>> security center>> disable apache_mode tweak

Cant switch accounts from resellers spanel

Problem:

one cant switch accounts from cpanels reselers cpanel

Solution:
goto WHM
reselers center
select the reseller
and unsuspend all accounts

Connecting to pop3 via konsole

This summary is not available. Please click here to view the post.

How to enter into postgress konsole

su postgress

databases connection

psql /c dbname uname

or
psql -d dbname

Email bounce managment processing problem

Getting following error in send studio while processing email bounce management

====================

Unable to log in using the details provided, the server returned this error message: Certificate failure for server.worthylive.com: self signed certificate:

===================

Solution:

If you receive this error, log into NewsletterServe, edit your mailing lists, and in the bounce processing details, check the option which reads "Yes, use extra mail settings", and in the "Extra Mail Settings" field enter this value:

/novalidate-cert

Use the "Test Bounce Settings" button to ensure the system can connect to your bounce mailbox.

If you are not hosting your bounce mailbox with us, but are having similar problems which are not resolved by the above, here are three more settings you can try, one at a time, until the bounce mailbox can be accessed:

/notls
/nossl
/notls/nossl

sshd daemon in whm failed

If you have changed the shell default Port 22 on a cPanel powered server , restarting sshd from the WHM will fail.

===============

solution.

ssh into server
change the server port to 22
/etc/ssh/sshd_config
===============

squirrel mail error "Connection timed out 110 Can't open SMTP stream."

error:
Connection timed out
110 Can't open SMTP stream.

=================

solution:

vi /usr/local/cpanel/base/3rdparty/squirrelmail/config/config.php

$useSendmail = false;

to:

$useSendmail = true;


restart cpanel and exim service.

Enable net-snmp

For enabling net-snmp we need to recompile php since it is a php module

How to enable fancy indexing

Fancy indexing means detailed explanation of each files

============
put this on .htaccess

IndexOptions FancyIndexing

=========

fantastico icon is not present in the cpanel accounts

1. check fantastico is enabled in the WHM's Feature Sets .
ie. feature manager >> fantastico

horde login looping

cd /var/cpanel/userhomes/cpanelhorde/sessions
remove the file

==============

/scripts/restartsrv httpd

===========

unable to remove addon domain

==========

Error from park wrapper: Sorry, you do not control the domain acsinco.net

==========
remove folloaing entries

/var/named/domain.com.db
/etc/httpd/conf/httpd.conf
/var/cpanel/users/username remove (dd) related entries to domain,
/etc/userdomains
/etc/localdomains
vim /etc/named.conf remove (dd) related entries to domain
remove dns entry in whm
run /scripts/updateuserdomains

=============

for sending messgaes via ssh

wall message ==>>publicly send
write root pts/1 then enter messages1 ==>>send privately (pts/1 is the recipient)

Check the ssl is valid or not

http://www.madboa.com/geek/openssl/#cert-exam

To extract information from a certificate

openssl x509 -text -in cert.pem

To verify a certificate

openssl verify cert.pem

Dolphin (Boonex Software)

1. I had added Dolphin CMS into cpaddons so that users could install it similar to the way fantastico installs things

2. Technical Requirements
Dolphin requires the following pre-requisites for your server:

* Linux/Unix (Red Hat, Debian, FreeBSD, Mandrake, etc.) or Windows OS, Apache Web Server ver. 1.3

* If you're going to use media streaming features in some Flash apps, you should have VPS or Dedicated server in order to install and run RMS (Ray Media Server). You should be able to access root or administrator account on that server. JRE (Java Runtime Environment) ver. 1.6 or higher should be installed on the server as well.

* The ports 1935, 1936 and 5080 should be open on the server (where Dolphin is to be installed) and on the local computers of your site's members

* PHP 4.4.0/5.1.0 and higher

* register_globals must be Off
safe_mode must be Off
exec() (executable files) must be allowed
allow_url_fopen should be On
allow_url_include should be Off
open_basedir should not have any value memory_limit should be 128M or higher

* mbstring, domxml (only for PHP 4.x) and xslt extensions should be installed

* MySQL 4.1.2 and higher

* The magic_quotes_gpc extension is also required starting from Dolphin 6.1.5 version

* If some security module is installed on the server (such as mod_security for Apache), it should be able to be disabled or set up for specific folders.

* Direct connection to boonex.com should be able to be established (i.e. connection without requiring proxy authorization).

* You should be able to run executable files (necessary for ffmpeg.exe)

* The server should be able to read any document located in public_html directory via http protocol.

* GD library compiled with FreeType fonts (for photo processing) or ImageMagick as an alternative

* Sendmail or Postfix programs for sending emails

* Ability to create Cron Jobs

* 20MB of disk space and 1MB of MySQL DB space for installation

* 8MB of disk space and 50KB of MySQL DB space for an average user

* Your server should allow 15 KB/sec for media streaming capabilities for each user.

If all the above requirements are met on your server then you are ready for installation.

Check the Hosting page to choose among recommended hosting providers.

If you want to add Dolphin to your cpanel automatic installation you should follow these instructions. These instructions are for Hosting providers and/or VPS/Dedicated server holders.


======================

3. dolphin is not installed in shared server since it contains lot of videos etc

4. It is not work with suphp , work only with dso module

Click_be installation error

======================

Warning: shell_exec() has been disabled for security reasons in /var/netenberg/click_be/installer/functions/others.php on line 227

=======================

Solution:

vi /usr/local/lib/php.ini
check disable_functions
remove shell_exec

and install click_be

======================

Httpd failure

root@server [~]# /etc/init.d/httpd start
/etc/init.d/httpd: line 83: 21567 File size limit exceeded(core dumped) $HTTPD -DSSL
/etc/init.d/httpd start: httpd could not be started
root@server [~]#
====================================

Solution: Check the size of the logs....

error_log
====================================

Unable to download email attachement

Increase the value of max_exec_time in cpanels php.ini

Unable to send email attachememts via maliing list

Actually the problem is due to some settings in the mailing list administrative panel

1.enter into mailing list (via cpanel)
2.In general options
Maximum length in kilobytes (KB) of a message body. Use 0 for no limit
set it to 0.

3.This will fix the issue.

Some Scripts

1. To print natural numbers

for i in `seq 1 10` ;do echo $i;done;

2.To print a-z

for i in {a..z};do echo $i;done;

3.To delete all the accounts from a server

for i in `cat /etc/userdomains`;do /scripts/killacct;done;

4.sed -i s/on/off/g php.ini
this will on all off options

5.for i in `cat new2.txt` ; do echo "-------------------$i----------------";ssh -p 1291 -l root $i /usr/local/apache/bin/httpd -v ; e ;done

to fine out version of apache of servers in the file new2.txt

6.grep server version?

for i in `cat new2.txt` ; do echo "-------------------$i----------------";ssh -p 1291 -l root $i /usr/local/apache/bin/httpd -v | grep "Server version" ; e ;done


7. To find out mysql db user?

find /home/costagr/public_html -type f -exec grep -H username_ '{}' \;
8. To copy zone files into a file

ll | awk print '{print $9}'| cat > test

9. Script to replace email id in zone file

for i in `cat /var/named/test` ; do sed -i 's/judyndenis.yahoo.com/convergencecos.gmail.com/g' $i; done


10.script to copy usernames into a file

cat /etc/userdomains | cut -d ':' -f2 >> domaintxt

11. cut command

cat all.txt | cut -d ',' -f2-4 | sort > new.txt

12. It will list 10 files in the decreasing order according to their size

ls -al -SR | head -10

13. Script To watch load for each second ?

watch -n1 w


14. To find out the all space used by a reseller

for a in `grep resellerlogin /etc/trueuserowners | cut -d":" -f1`; do quota -s $a| tail -n 1 | awk {'print $2'};done

15. Replace command

replace 'source' 'destintaion' -- filename

eg; need to change jibin in file.txt to A
replace 'jibin' 'A' -- file.txt

How to install the script VZFREE

VZFREE is a script which is showing guaranteed memory usage

=================

* Download vzfree-0.1.tgz (1.5kb)
* Unpack the tarball and change into the directory
* Type “make && sudo make install“

===============

# vzfree
Total Used Free
Kernel: 49.83M 3.57M 46.26M
Allocate: 250.00M 103.91M 146.09M (256M Guaranteed)
Commit: 147.93M 53.07M 94.86M (47.6% of Allocated)
Swap: 0.03M (0.1% of Committed)

==============

Disable ftp root login

We can disable ftp root login by using the following

===========

1. go to WHM
2. Main >> Service Configuration >> FTP Server Configuration
3.select "Allow Logins with Root Password" as No

============

sar command is not working

sar -q
there is no such file or directory
/var/log/sa/sa23

Solution:
sar 1 10 -o sa23

Apache 404 error " script not found or unable to stat: /usr/local/apache/cgi-bin/form.cgi,"

Solution :

copy the form.cgi to /usr/local/apache/cgi-bin/
from the given location

Cpanel having two password

The problem is that you can go to cpanel with 2 different passwords.

you can test:

http://controlip.net:2082/
user: control
pass1: teleip
pass2: GranVia0
----------------------
VPS : 22arroba.com
usuario : xxarrob
password : e621023

=========================

We can disable the cpanel root login by using the following

=============

1.go to WHM
2.Tweak settings ==>> Disable login with root or reseller password into the users' cPanel interface. Also disable switch account dropdown in themes with switch account feature.
3.Check this option .i.e disabling the cpanel access with resellers root password

php: error while loading shared libraries: libpq.so.3+php

1.try to link the libraries
2./scripts/easyapache

Name servers are not displayng in WHM under Main >> Networking Setup >> Nameserver IPs

Solution:

If the domain is not in the dns zone then add the domain into dns zone

Default Setting up Name Servers on CPANEL / WHM
I found this interesting article about name server setup on http://www.webhostingtalk.com/.

Setting up nameservers in WHM/Cpanel

1. Log into WHM

2. Goto Server Setup =>> Edit Setup

Make sure your primary IP is correct under Main Shared Virtual Host IP

Make sure your Hostname is correct under Hostname (server1.xyz.com)

Under Primary Nameserver enter your primary nameserver (ns1.xyz.com), click on Assign Ip Address, then click on Add A entry for this nameserver

Under Secondary Nameserver enter your secondary nameserver (ns2.xyz.com), click on Assign Ip Address, then click on Add A entry for this nameserver

Note: You can add a third and fourth name server if you wish, however this is not necessary. All name servers will be automatically assigned to any accounts you setup later. You will have to manually disable extra nameservers from each account.

Scroll to the bottom and click Save.


Goto DNS Functions =>> Edit a DNS Zone

Choose the primary domain for the server and click Edit

The beginning of your Zone File should look something like this:


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

; Zone File for ip-2-ip.net


$TTL 14400


@ 14440 IN SOA ns1.xyz.com. admin.xyz.com

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


In SOA add your primary ns (ns1.xyz.com.) and contact email (admin.xyz.com.). Put a period at the end of your nameserver, and use a period in place of @ in your contact email and add a period at the end too.)


In most cases you should have the following Record Types:

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

xyz.com. 14440 IN NS ns1.xyz.com.

xyz.com. 14440 IN NS ns2.xyz.com.

xyz.com. 14440 IN A 123.123.123.12 (primary IP Address)

localhost.xyz.com. 14440 IN A 127.0.0.1

xyz.com. 14440 IN MX 0 xyz.com.

mail 14440 IN CNAME xyz.com.

www 14440 IN CNAME xyz.com.

ftp 14440 IN A 123.123.123.13

ns1 14440 IN A 123.123.123.12

ns2 14440 IN A 123.123.123.13

server1 14440 IN A 123.123.123.12 (primary IP Address)

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


If you do not have A records for your Nameservers add them now. If you use Managed DNS for your domain name, also add A records to your domain name with your DNS.

If you made changes to your zone file, scroll down to the bottom and click on Save


Goto DNS Functions =>> Perform a DNS Cleanup


Now log out of WHM and SSH to your server and login as root.

Note: You can download Putty by Clicking Here (http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html). It's a clean running application that will not require installation on Windows-boxes.

Once logged in...

At command prompt type: pico /etc/nameserverips

Make sure all of your nameservers are listed

123.123.123.12=ns1.xyz.com
123.123.123.13=ns2.xyz.com
123.123.123.14=0
123.123.123.15=0
123.123.123.16=0

Remove any nameservers that do not belong.

If you make changes to the file, then press the following keys on your keyboard Ctrl o and then Enter to save the file, then Ctrl x to exit.


At command prompt type: pico /etc/resolv.conf

There should only be three records in the resolv.conf file... localhost, primary nameserver, secondary nameserver.

nameserver 127.0.0.1
nameserver 123.123.123.12
nameserver 123.123.123.13

Remove anything else and then save and exit.


At the prompt type: pico /etc/wwwacct.conf

Make sure all of the information is correct. Remove anything that does not belong, save, then exit.

ADDR 123.123.123.12
CONTACTEMAIL admin@xyz.com
CONTACTPAGER
DEFMOD x
ETHDEV
FTPTYPE proftpd
HOMEDIR /home
HOMEMATCH home
HOST server1.xyz.com
LOGSTYLE combined
MINUID
NS ns1.xyz.com
NS2 ns2.xyz.com
ns3
SCRIPTALIAS y
ns4



At the prompt type: pico /etc/named.conf

Scroll down to the bottom of the file to the zone records.

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

zone "xyz.com" {
type master;
file "/var/named/xyz.com.db";
};

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

Make sure all domain zone records are correct. Remove any zone records that are old or do not belong there. If you make any changes, save and then exit.


At the prompt type: pico /etc/host.conf[b]

This file should look like this:

[b]order hosts,bind


At the prompt type: pico /etc/host

This file should look like this:

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

# Do not remove the following line, or various programs
# that require network functionality will fail.
123.123.123.12 server1.xyz.com server1
127.0.0.1 localhost

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


Now your done and your nameservers will work like a pro.


Source: http://www.webhostingtalk.com/archiv.../t-327461.html

How to change cpanel theme via backend

1.'/var/cpanel/users'
2.edit the theme.

To download backup from cpanel

wget http://agrupaci:51/*-78+_09@j@servercristiano.com:2082/download?file=backup-10.8.2009_03-16-36_agrupaci.tar.gz

===================

wget http://uname:pass@domainname.com:2082/download?file=backup-10.8.2009_03-16-36_agrupaci.tar.gz

=====================

To find ssh port of a remote server

nmap -v -A 38.108.120.125 -P1000-4000

up2date, aptitude,yum commands

1. For centos servers we can use yum

2.for debian servers we can use aptitude

3.For RHEL (redhat servers) we can use up2date

To grep mulitiple contents

[root@server ~]# rpm -qa | egrep 'binutils|compat-db'
binutils-2.17.50.0.6-12.el5
compat-db-debuginfo-4.2.52-5.1
[root@server ~]#

===============

php -m | egrep -i 'curl| XML|MySQL|GD|mbstring|gettext'
curl
gd

ftp file upload is noot working

ftp file upload is not working

=============
error:

/home/index.html: open for write: permission denied

=============

Check the /etc/pureftpd.conf

enable the following option

KeepAllFiles yes

=============

To find out highly memory used processes from pstree

ps -eo pcpu,pid,user,args | sort -k 1 -r | head -10
ps -eo pcpu,pid,user,args | sort -k 1 -r | less

Roundcube is not working

1//usr/local/cpanel/bin/updtae-roundcube
2.If still exist the problem then
mysql roundcube < mysql5.initial.sql1

Magento Installation

http://www.magentocommerce.com

================
1.download the source to document root of the given account
2.tar
3.create db
4.installation.

http://siteground.eu/tutorials/magento/magento_installation.htm

=============

To set permissions for files and folders

find -type d -exec chown urbanele.urbanele {} \; ==>> directories

find -type f -exec chown urbanele.urbanele {} \; ==>> files

find -type d -exec chmod 644 {} \;

Cpanel links are not showing in WHm under list accounts

go to whm >> tweak settings >> system >> Disable login with root or reseller password into the users' cPanel interface. Also disable switch account dropdown in themes with switch account feature.

Install domain keys

1. First check that you are running the latest version on RELEASE or CURRENT of cPanel 11.
2. Run the script

/usr/local/cpanel/bin/domain_keys_installer username

Where username is the cPanel user.

If you get an error similar to “Domain keys are not installed on this machine.” you either are not running the latest release or current version of cPanel or you have not converted yet to maildir. Maildir conversion is required before you install DomainKeys.
You will find an article about converting to maildir on this site !

Ok, we just installed DomainKeys for a domain, but how about if we want to install it for all the domains (users)?
Well I found the solution just a few days ago on a public forum. Someone wrote a nice bash script that will parse all the cpanel users and then run the installation for each of them.

mails bypassed

root@ping.dizinc.com(~)$ tail -f /var/log/exim_mainlog | grep pam@joyloft.com

2009-09-07 16:00:55 1MkkOS-0000sl-JW <= jibinthomas007@gmail.com H=mail-ew0-f215.google.com [209.85.219.215]:55174 I=[72.29.74.235]:25 P=esmtp S=1898 id=6cae4a7c0909071300u642cb36u857fd8b40beda34c@mail.gmail.com T="test" from for pam@joyloft.com
2009-09-07 16:00:55 1MkkOS-0000sl-JW => /dev/null F= R=central_filter T=**bypassed** S=0

root@ping.dizinc.com(~)$

=============

soultion:

1. You should look at the file in /etc/valiases/(domainname) and see what filters are setup for that domain
2./etc/vfilters/domainname

=============

upcp error

=====================
/scripts/upcp --force
Can't locate cPScript/Config/Sources.pm in @INC (@INC contains: /usr/local/cpanel /scripts /usr/local/lib/perl5/5.8.8/i686-linux /usr/local/lib/perl5/5.8.8 /usr/local/lib/perl5/site_perl/5.8.8/i686-linux /usr/local/lib/perl5/site_perl/5.8.8 /usr/local/lib/perl5/site_perl .) at /scripts/upcp line 18.
BEGIN failed--compilation aborted at /scripts/upcp line 18.

===================

solution:

replace the cpscript folder

i.e /scripts/cPScript/

php mail function

mail("somebody@example.com","My subject",$txt);
?>

Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

Solution:

1001 tail -f /var/lib/mysql/server.dizinc.com.err
1002 hostname
1003 tail -f /var/lib/mysql/dime138.dizinc.com.err
1004 ll /var/lib/mysql/mysql/
1005 ll /var/lib/mysql/mysql/
1006 myisamchk -r /var/lib/mysql/mysql/host.MYI
1007 ll /var/lib/mysql/mysql/
1008 cp /backup/cpbackup/daily/dirs/_var_lib_mysql/mysql/host.* /var/lib/mysql/mysql/
1009 chown -R mysql.mysql /var/lib/mysql/mysql/
1010 myisamchk -r /var/lib/mysql/mysql/*.MYI
1011 ll /var/lib/mysql/mys
1012 ll /var/lib/mysql/mysql/
1013 ps aux | grep mysql
1014 mysql
1015 ps aux | grep mysql
1016 mysql

server date settings

rdate -s rdate.cpanel.net

Apache – “Client denied by server configuration” tips

Having problems with displaying your site and getting error 403 in your web-browser?

does the log-file for apache errors contain lines like tis?
“client denied by server configuration: /path/to/files”

Then you probably have denied access to the directory in the httpd.conf file.

Allow access by adding:

allow from all


If your are using VirtualHosts then add the directory-block inside the block.

Unable to add package on cpanel as user

Unable to add package on cpanel as user and getting following error "an error occured while processing this dirctive"

============
Cpanel Package creation problem : Attempt to free unreferenced scalar
Posted on August 19th, 2009 Admin No comments

while creating packages for the reseller via reseller WHM we were getting blank page and it appears that the packages were not getting created. After looking into the CPanel error logs in /usr/local/cpanel/logs/error_log the following error was reported.

(internal warning while parsing [stdin]) Wed Aug 193 13:21:08 2009 [94568] warn: Attempt to free unreferenced scalar.

Solution

WHM -> Server Configuration -> Tweak Settings Choose the setting for:

The maximum memory a cPanel process can use before it is killed off (in megabytes). Values less than 128 megabytes can not be specified. A value of “0″ will disable the memory limits.

The settings had 256M there by default, and increasing the value to 1024 MB helped. The server Server had 4G RAM, so the value of 1024M was fine here.

==================

Set memory to 512

Adobe flash media server

http://www.scribd.com/doc/8124539/Flash-Media-Server-Install

Down load it to s/m and upload into server. then refer above link

./fmsmgr server fms start

To find out database user

find /home/costagr/public_html -type f -exec grep -H username_ '{}' \;

Internal server +cgi bin error

Add these lines to httpd.conf

==================

Options All
scriptAlias /cgi-bin/ /var/www/cgi-bin/

AllowOverride None
Options +ExecCGI
Order allow,deny
Allow from all

AddHandler cgi-script .cgi .pl

===============

Unable to upload files

Problem:

file gets stuck uploading, waited almost a whole to upload a 6.67MB file image. which never finished.

===========

solution:

To resolve the issue, I did the following things.

1. Checked the values in php.ini. upload_max_filesize is set to 50M.
2. In your admin area, in upload settings, made the 'max size' part blank, so that it will take the default value from php.ini
3. Also, I made the file upload privileges to "Everyone". Earlier it was set to superuser only.

How to change a username

Go to whm >> modify an acct
change it

=========

Shell already set to /usr/local/cpanel/bin/noshell
`/etc/proftpd/tmacey' -> `/etc/proftpd/tarquin'
`/var/cpanel/users/tmacey' -> `/var/cpanel/users/tarquin'
`/home/tmacey' -> `/home/tarquin'

=========

rvsite buider installation

RVSiteBuilder :: Support :: Installation for cPanel server
1. If RVSkin has been installed on your server it should be updated for RVSkin to Version 6.75 or upper versions. (Skip this step if no RVSkin has been installed).
perl /root/rvadmin/auto_rvskin.pl

2. After receiving the license confirmation,please set SSH to your cPanel server as root,and download an installer using below command :
cd /usr/local/cpanel/whostmgr/docroot/cgi/
rm -f rvsitebuilderinstaller.tar
wget http://download.rvglobalsoft.com/rvsitebuilderinstaller.tar
tar -xvf rvsitebuilderinstaller.tar
chmod 755 addon_rvsitebuilder.cgi
rm -f rvsitebuilderinstaller.tar

3. Open root WHM, at the bottom of menu on the left side where is under Plugins section, you will find RVSiteBuilder Installer menu.

4. Click RVSiteBuilder Installer to begin installation process.

5. After completing installation, you will be linked to RVSiteBuilder Manager automatically. Please configure RV SiteBuilder immediately.

6. Done!! Your cPanel should show RVSiteBuilder as a feature in all cPanel users. Special note for specific cPanel skin:

* RVSkin - It will automatically switch RVSiteBuilder to RVSkin.You may require editing the Package-Feature List if RV Site Builder doesn't show up or you don't require some hosting packages access.
* X Skin and some which support AddOn application - It will be automatically displayed on cPanel.Also you will be to manage the feature list in WHM Feature Manager.
* CPSkins - Upgrade RVSiteBuilder to Version 1.07 or upper versions.You have to manually integrate it by editing file /usr/local/cpanel/base/frontend/themename/index.html.Insert



which is on the top of the page and also you edit /usr/local/cpanel/base/frontend/themename/main.php. Place



in the area you would like to show RVSiteBuilder Icon. Do not edit file RVS2CPSkinmenu.html.Your change will be lost when you update RVSiteBuilder. If you would like to edit it you can copy it to another new file, rename and change the cPanel including path to the new one.

Installation Trouble Shooting
Cannot find RVSiteBuilder Installer

Please close all WHM and open it again.

Cannot find RVSiteBuilder Manager

Please close all WHM and open it again.

Cannot connect to DB, check your credentials, exiting .....

Sorry your request can not be processed now.Please contact your service provider. .
If you deploy local MySQL, please go to WHM / MySQL Services / MySQL Root Password and then enter the random password.You don't need to remember it.Then, please try to install again.If it still fails, you are suggested to restarting MySQL.If you deploy remote MySQL, please ensure the database name, database user and its combination are correct.And also, please make sure that your server has a privilege for an access to remote MySQL.

Cannot find RVSiteBuilder in user's cPanel X skin

Go to WHM / Packages / Feature Manager and edit "default" Features List. And activate RVSiteBuilder.

Cannot find RVSiteBuilder in user's cPanel RVSkin

Go to WHM / Add-ons / RVSkin Manager / Integration / WHM Add On Modules. Activate RVSiteBuilder. Then, go to 'Package-Feature Manager' and enable RVSiteBuilder in the feature lists as appropriate.

email account creation problem

When we are trying to create an email account then we got following error

error: two account are created in the same name

===========

solution:

1. go to /home/username/.cpanel
2.move the file

=============

Install yum

1.
cd /usr/src
2.
wget http://linux.duke.edu/projects/yum/download/2.0/yum-2.0.7.tar.gz
3.
tar -xvzf yum-2.0.7.tar.gz
4.
cd yum-2.0.7
5.
./configure
6.
make
7.
make install

===========================

http://imountain.com/blog/2008/09/13/how-to-install-yum-manually-on-redhatrhel-4x-or-centos-4x/

=======================.

http://www.webhostingtalk.com/archive/index.php/t-907431.html

=======================

Hi,

Login as root in SSH Command Prompt of your VPS

Run these commands

Code:

mkdir temp && cd temp

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/elfutils-0.137-3.el5.i386.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/elfutils-libs-0.137-3.el5.i386.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/elfutils-libelf-0.137-3.el5.i386.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/expat-1.95.8-8.2.1.i386.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/gmp-4.1.4-10.el5.i386.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/libxml2-2.6.26-2.1.2.7.i386.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/libxml2-python-2.6.26-2.1.2.7.i386.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/m2crypto-0.16-6.el5.3.i386.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/python-2.4.3-24.el5.i386.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/python-elementtree-1.2.6-5.i386.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/python-iniparse-0.2.3-4.el5.noarch.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/python-sqlite-1.1.7-1.2.1.i386.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/python-urlgrabber-3.1.0-5.el5.noarch.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/readline-5.1-1.1.i386.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/rpm-4.4.2.3-9.el5.i386.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/rpm-libs-4.4.2.3-9.el5.i386.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/rpm-python-4.4.2.3-9.el5.i386.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/sqlite-3.3.6-2.i386.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/yum-3.2.19-18.el5.centos.noarch.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/yum-fastestmirror-1.1.16-13.el5.centos.noarch.rpm

wget http://mirror.centos.org/centos-5/5.3/os/i386/CentOS/yum-metadata-parser-1.1.2-2.el5.i386.rpm


This will download all the RPMs needed to install YUM
=================

Now run these commands to install those RPMs

Code:

rpm -Uvh elfutils-0.137-3.el5.i386.rpm

rpm -Uvh elfutils-libs-0.137-3.el5.i386.rpm

rpm -Uvh elfutils-libelf-0.137-3.el5.i386.rpm

rpm -Uvh expat-1.95.8-8.2.1.i386.rpm

rpm -Uvh gmp-4.1.4-10.el5.i386.rpm

rpm -Uvh libxml2-2.6.26-2.1.2.7.i386.rpm

rpm -Uvh libxml2-python-2.6.26-2.1.2.7.i386.rpm

rpm -Uvh m2crypto-0.16-6.el5.3.i386.rpm

rpm -Uvh python-2.4.3-24.el5.i386.rpm

rpm -Uvh python-elementtree-1.2.6-5.i386.rpm

rpm -Uvh python-iniparse-0.2.3-4.el5.noarch.rpm

rpm -Uvh python-sqlite-1.1.7-1.2.1.i386.rpm

rpm -Uvh python-urlgrabber-3.1.0-5.el5.noarch.rpm

rpm -Uvh readline-5.1-1.1.i386.rpm

rpm -Uvh rpm-4.4.2.3-9.el5.i386.rpm

rpm -Uvh rpm-libs-4.4.2.3-9.el5.i386.rpm

rpm -Uvh rpm-python-4.4.2.3-9.el5.i386.rpm

rpm -Uvh sqlite-3.3.6-2.i386.rpm

rpm -Uvh yum-3.2.19-18.el5.centos.noarch.rpm

rpm -Uvh yum-fastestmirror-1.1.16-13.el5.centos.noarch.rpm

rpm -Uvh yum-metadata-parser-1.1.2-2.el5.i386.rpm


This will install all those downloaded RPMs
Most of the RPMs would be installed by default, but it is a must to have the Latest Versions for installing YUM.
===========================
Now update the YUM by running this command

Code:

yum update yum

OR
Code:

yum -y update

===========================


Emjoy....

Check Load Logs from previous days

sar -q -f /var/log/sa/sa01

RVskin installation error

Updating rvskin database...
=============================
DBI connect('rvadmin_news:localhost:3306','rvadmin_public',...) failed: Access denied for user 'rvadmin_public'@'localhost' (using password: YES) at /root/rvadmin/real_auto_rvskin.pl line 709

Database connection failed, You need to create it manually in rvadmin Skin Manager after installation is completed.

-------- Database connection testing command --------
perl -e "use DBI;print \"\n\";unless ( DBI->connect('DBI:mysql:rvadmin_news:localhost:3306','rvadmin_public','2412935') ){print \"Connection fail\n\";exit;}print \"Connection OK\n\";"
----- Above is 1 line command. It must show Connection OK. -----

====================

run the perl script perl -e "use DBI;print \"\n\";unless ( DBI->connect('DBI:mysql:rvadmin_news:localhost:3306','rvadmin_public','2412935') by replacing current passwd

Apache Connections

1.
#this will tell you how many connections each domain has
2.

3.
lynx --dump --width=260 localhost/whm-server-status | grep "^ [0-9]" | awk '{print $12}' | grep -i ^[a-z] | sort | uniq -c | sort -nk1
4.

5.
#this will tell you how many connections each IP Address has
6.

7.
lynx --dump --width=260 localhost/whm-server-status | grep "^ [0-9]" | awk '{print $11}' | grep ^[0-9] | sort | uniq -c | sort -nk1

Download

wget https://scripts.dimenoc.com/files/Apache_Connections_242.sh --no-check-certificate

sh Apache_Connections_242.sh

getting emails

Type: LOCALRELAY, Local Account - nobody

Count: 101 emails relayed

Blocked: No

===========

It can be solved by setting the value of RT_LOCALRELAY_LIMIT to '0' .

ffmpeg Installation

http://ffmpeginstaller.com//free/
wget http://mirror.ffmpeginstaller.com/old/scripts/ffmpeg3/ffmpeginstall.3.2.1.tar.gz
tar
./install

=========

root@server [/usr/local/src/ffmpeginstall.3.2.1]# ffmpeg -version[root@superlink ~]# which ffmpeg
/usr/local/bin/ffmpeg
[root@superlink ~]# which mplayer
/usr/local/bin/mplayer
[root@superlink ~]# whcih mencoder
-bash: whcih: command not found
[root@superlink ~]# which mencoder
/usr/local/bin/mencoder
[root@superlink ~]# whcih flvtool2
-bash: whcih: command not found
[root@superlink ~]# which flvtool2

============

If you are facing a problem in ffmpeg installation i.e mplayer failure
then it can be solved by

===========

In ffmpeg installation if mplayer is failed then
600 rpm -qa | grep -i alsa
601 yum remove alsa-lib-devel-1.0.17-1.el5 alsa-lib-1.0.17-1.el5

install again i.e ./install

============

Unable to create subdomain

problem: In cpanel got an error when trying to create a subdomain, but domain created

=======
subdomain error

=======

solution:

/usr/local/apache/conf/httpd.conf has an attribute...so remove that attribute....that will fix the issue

OR

===============
1.check the files /etc/named.conf
2./var/cpanel/userdata
3./var/named/

YuM UPDATE FAILURE

error:

Using newyum support.
http://yum.theplanet.com/4/updates/i386/repodata/repomd.xml: [Errno 12] Timeout:
Trying other mirror.
Cannot open/read repomd.xml file for repository: update
failure: repodata/repomd.xml from update: [Errno 256] No more mirrors to try.
Error: failure: repodata/repomd.xml from update: [Errno 256] No more mirrors t

SOLUTION:


Check the yum conf files

i.e in /etc/yum.repos.d/
replace mono.repo
yum update

This will solve the problem

How to change mail server IP temporarily

go to whm >> exim configuration editor

then check the option

"Send outgoing mail from the ip that ..."

then go /etc/mailips and add the IP

==========

`There are two options to switch the mail server IP in Cpanel.

Option #1

Login to WHM

Click Exim Configuration Editor

Check the box next to:
"Send outgoing mail from the ip that matches the domain name in /etc/mailips (*: IP can be added to the file to change the main outgoing interface)"

Save Changes

Then edit the file /etc/mailips
nano /etc/mailips
from shell and add:

*: ReplacewithnewIP

Restart exim

service exim restartOption #2

Login to Shell

Access the Exim configuration file:
nano /etc/exim.confLocate remote_smtp

The default setup will look like:

remote_smtp:
driver = smtp
interface = ${if exists {/etc/mailips}{${lookup{$sender_address_domain}lsearch{/etc/mailips}{$value}{}}}{}}
helo_data = ${if exists {/etc/mailhelo}{${lookup{$sender_address_domain}lsearch{/etc/mailhelo}{$value}{$primary_hostname}}}{$primary_ho stname}}Change to:

remote_smtp:
driver = smtp
#interface = ${if exists {/etc/mailips}{${lookup{$sender_address_domain}lsearch{/etc/mailips}{$value}{}}}{}}
#helo_data = ${if exists {/etc/mailhelo}{${lookup{$sender_address_domain}lsearch{/etc/mailhelo}{$value}{$primary_hostname}}}{$primary_ho stname}}
interface = 11.1.1.1.1 # Change to your server IP address.
Save changes and exit.

Restart Exim

=================

Named Error

root@smx3.hostdime.com.mx(~)$ /etc/init.d/named restart
Stopping named: [ OK ]
Starting named:
Error in named configuration:
zone clone2.dizinc.com.zz/IN: loaded serial 2009021100
zone phpinfotest.com/IN: loaded serial 2009021100
zone transportesmiguel.com/IN: loaded serial 2009021100
zone grupoferrer.com/IN: loaded serial 2009021100
zone jyaa.com.mx/IN: loaded serial 2009021100
zone avpca.org/IN: loaded serial 2009021100
zone hawkanime.net/IN: loaded serial 2009021100
zone nortechengineering.com.mx/IN: loaded serial 2009021100
.
.
.
zone heraldodelbajio.com/IN: loading master file /var/named/heraldodelbajio.com.db: file not found
.
.
.

===========

actually the error is due to some incorrect entries in the /etc/named.conf
1.first check is there any entry for heraldodelbajio.com.db i.e in the error log
2.add it to /etc/named.conf
3.remove or comment following entries

# key "rndckey" {
# algorithm hmac-md5;
# secret "53Ard+LKadYqYxNPTZoMpQ==";
# };
#
# controls {
# inet 127.0.0.1 port 953
# allow { 127.0.0.1; } keys { "rndckey"; };
# };

rndc reload
/scripts/fixrndc
then restart named
this will fix the issue

Check a web page exists

Here is a short method to check if a web page exists from a perl script,
this script will test the existense of a page and do something as a result:

==========

#!/usr/bin/perl
use LWP::Simple;
print “Content-Type: text/htmlnn”;

$url = “ http://site.com/“;

if (head($url)) {
# ok document exists
print “OK: found $url”;
} else {
# something is not well
print “PROBLEM: $url is missing”;
}

=============

How to reset mysql root password ?

1. Stop/ kill the mysqld
# service mysql stop
#pkill -9 mysqld

2) Start the mysql insafe mode as follows

# /usr/sbin/mysqld --skip-grant-tables --user=root &

3) Now update the mysql user tables and root password as follows

#mysql
mysql>use mysql;
mysql>UPDATE user SET Password=PASSWORD('YOUR_PASSWORD') WHERE Host='localhost' AND User='root';
mysql>flush privileges;

Now add the new password “YOUR_PASSWORD” in /root/.my.cnf and start mysql

# service mysql start


// To grant privilege on mysql table

grant EXECUTE on procedure lenbelle_mydbr.sp_MyDBR_UserPassword to 'lenbelle_mydbru'@'localhost';

where lenbelle_mydbr.sp_MyDBR_UserPassword = procedure that having problem
lenbelle_mydbru = dbuser

Mysql optimization

MySQL Optimization

Login to your server as root and do a backup of my.cnf mySQL configuration file:
# cp /etc/my.cnf /etc/my.cnf.backup

Edit my.cnf file using nano or other text editor:
# nano /etc/my.cnf

You can use that configuration to optimize default configuration:

[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=8M
query_cache_size=256M
query_cache_type=1
max_connections=500
max_user_connections=100
interactive_timeout=60
wait_timeout=60
connect_timeout=30
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=100
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=2
myisam_sort_buffer_size=64M
#log-bin
server-id=1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

Save and exit

How to disable telnet

Login as root to your server, now:

Edit /etc/xinetd.d/telnet
# nano /etc/xinetd.d/telnet

Search for: "disable = no" (you can use Ctrl+W) ,
Change it to: disable = yes

Save and Exit

Restart xinted
# /etc/rc.d/init.d/xinetd restart

How To Install Rkhunter

If you are running a Web Server, Mail Server, Hosting Server or VPS Server and you need to provide security against rootkits, so we recommend you to install Rkhunter.

RKhunter is compatible with the most popular Hosting Control Panels like cPanel, Plesk, Ensim etc.

"Rootkit scanner is scanning tool to ensure you for about 99.9%* you're clean of nasty tools.
This tool scans for rootkits, backdoors and local exploits by running tests like:
- MD5 hash compare
- Look for default files used by rootkits
- Wrong file permissions for binaries
- Look for suspected strings in LKM and KLD modules
- Look for hidden files
- Optional scan within plaintext and binary files
Rootkit Hunter is released as GPL licensed project and free for everyone to use.
* No, not really 99.9%.. It's just another security layer"
( http://www.rootkit.nl/ )


Install Rkhunter:
# wget http://downloads.rootkit.nl/rkhunter-1.2.7.tar.gz
# tar -zxvf rkhunter-1.2.7.tar.gz
# cd rkhunter-1.2.7
# ./installer.sh

Update Rkhunter:
# rkhunter --update

Run a Test Scan (help to prevent false positives):
# /usr/local/bin/rkhunter -c

Setup a daily scan report:
# nano /etc/cron.daily/rkhunter.sh

and add it:
#!/bin/bash
(/usr/local/bin/rkhunter -c --cronjob 2>&1 mail -s "Daily Rkhunter Scan Report" email@domain.com)

Change premissions:
# chmod +x /etc/cron.daily/rkhunter.sh

rkhunter version:

rkhunter --version

How To FIX email account disk usage incorrect on cpanel

/scripta/fixquotas

If it is not solved us the following

============

# find /home/*/.cpanel-datastore/ -name “diskusage_*” | xargs rm -f
# find /home/*/mail/ -name maildirsize | xargs rm -f

============

IMAGE MAGIC

If you are running cPanel, you can use the next command to check if ImageMagick is running:

# /scripts/checkimagemagick

If you want to install ImageMagick on cPanel you can use this script:

# /scripts/installimagemagick

Can't connect to local MySQL server through socket

/usr/local/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists

========================
Solution I:
To fix it, and if you are running cPanel just try to run the next commands:

# ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

# /scripts/mysqlup --force

If its not worked add the following line in my.cnf that will helps to start the mysql

skip-innodb

then check the mysql databases.
=========================

Solution II

Go to var/lib/mysql
touch mysql.sock
chown mysql.mysql mysql.sock
chmod 777 mysql.sock

cd /tmp
ln -s /var/lib/mysql/mysql.sock mysql.sock

/etc/init.d/mysql restart

Now check the mysql

Note :: If the error persist you need to kill all existing mysql process and try.
======================

Account restore

This doc will help you to restore an account from backup through backend(shell) in cpanel servers

1) Check whether the account have backup

2) Create a backup copy of the current account

# /scripts/pkgacct username

3) move teh account from /home to any other partition.

# mv /home/cpmove-username.tar.gz /root

4) /scripts/killacct username

5) cd /backup/cpbackup/respective folder

6) cp username.tar.gz /home

7) /scripts/restorepkg clintons

Acount tranfer in shared server

1. we have to add Ip into /etc/security/access.conf
2.then use scp
i.e scp -P 1291 /home/filename root@hostname:/root

===================

We can also transfer a file via /usr/local/apache/htdocs

i.e 1.copy the file into /usr/local/apache/htdocs
then goto destination and
wget http://IP/filename
e.g http://66.7.209.120/kitchenx_gootgp.tar

==================

RUBY AND VERSIONS

RUBY VERSIONS

root@sh112 [~]# gem --version
1.3.5
root@sh112 [~]# ruby --version
ruby 1.8.5 (2006-08-25) [x86_64-linux]
root@sh112 [~]#

RUBY INSTALLATION

GEMS:

gem install rubygems-update
update_rubygems

RUBY

/scripts/installruby

Mount Error

When we try to mount a backup drive get the following error

==========

mount: wrong fs type, bad option, bad superblock on /dev/hdc3

=========

This error indicates that partition got corrupted ,this can be overcome by formatting the partition by using the following command

=========

mkfs [ -V ] [ -t fstype ] [ fs-options ] filesys [ blocks ]

eg: mkfs -t ext3 partitionname

==========
=========

phpphpextensionmgr

/scripts/phpphpextensionmgr list
install ioncube by scripts/phpphpextensionmgr install ioncube


==========

How To Secure /tmp and /dev/shm partition

How To Secure /tmp and /dev/shm partition

Keep you server clean of rookits is a good idea to get a good security level. A sysadministrator can create a seperate partition for /tmp and mount it with noexec and nosuid parameters. And to do it is not necessary to reboot or repartition your drive.

1. First you should secure /tmp:

Make a 1GB file for /tmp parition and an ext3 filesystem for tmp:
# dd if=/dev/zero of=/dev/tmpFS bs=1024 count=1000000
# /sbin/mkfs.ext3 /dev/tmpFS

Create a backup copy of your current /tmp drive:
# cp -Rpf /tmp /tmpbackup

Mount our new tmp parition and change permissions:
# mount -o loop,noexec,nosuid,rw /dev/tmpFS /tmp
# chmod 1777 /tmp

Copy the old data:
cp -Rpf /tmpbackup/* /tmp/

If you run the mount command and you should get something like this:
/dev/tmpMnt on /tmp type ext3 (rw,noexec,nosuid,loop=/dev/loop0)

Edit /etc/fstab and add this:
/dev/tmpMnt /tmp ext3 loop,nosuid,noexec,rw 0 0
Test your fstab entry:
# mount -o remount /tmp

You can test it runnig a script on /tmp partitio, if you get "permission denied" it is fine :)


2. Secure /var/tmp:

It should be done because some applications use /var/tmp as the temporary folder, and anything that's accessible by all, needs to be secured.

Rename it and create a symbolic link to /tmp:
# mv /var/tmp /var/tmp1
# ln -s /tmp /var/tmp

Copy the old data back:
# cp /var/tmpold/* /tmp/

Note: you should restart and services that uses /tmp partition

3. Securing /dev/shm:

To get all the work well done, you should secure /dev/shm to stop rootkits running here.

Edit your /etc/fstab:
# nano /etc/fstab

change:
"none /dev/shm tmpfs defaults,rw 0 0" to
"none /dev/shm tmpfs defaults,nosuid,noexec,rw 0 0"

Remount /dev/shm:
# mount -o remount /dev/shm

It should be fine now. You can also read related posts:
How to install Rkhunter
How to install Rootcheck

HDD Failure

root@smx4.hostdime.com.mx(/etc/csf)$ /scripts/upcp --force
Failed to write upcp pid file: Read-only file system at /scripts/upcp line 98.
root@smx4.hostdime.com.mx(/etc/csf)$ touch test
touch: cannot touch `test': Read-only file system
root@smx4.hostdime.com.mx(/etc/csf)$ hostname -i
66.7.205.107
root@smx4.hostdime.com.mx(/etc/csf)$ cd
root@smx4.hostdime.com.mx(~)$ hostname
smx4.hostdime.com.mx
root@smx4.hostdime.com.mx(~)$ touch a
touch: cannot touch `a': Read-only file system
root@smx4.hostdime.com.mx(~)$


==================

fsck
reboot

database error "0 DB_ERROR_NOT_CONNECTED"

when we check the site "www.domainname.com" got the following error

0 DB_ERROR_NOT_CONNECTED

SOLUTION:

I removed the users access to their database and re-added the access
They had full permissions but for some reason it still wasn't working

>>go to cpanel>>mysql databases >> delete and add user and grant all privileges

EASY APACHE ERROR

root@amberserver [~]# /scripts/easyapache
-----------------------------------

Donot run easyapache, please use
acela.dizinc.com/utils/buildapache.tar.gz

------------------------------------
root@amberserver [~]#

SOLUTION: chattr -ia /scripts/easyapache
rm -rf /scripts/easyapache
/scripts/upcp

cannot access whm and cpanel via IP address

10.8.1.110/cpanel
10.8.1.110/whm

solution:

In /var/cpanel/cpanel.config, I changed these two lines

alwaysredirecttossl=0
cpredirect=IP

click be installation

mkdir -p /var/netenberg/click_be/installer/
cd /var/netenberg/click_be/
wget http://www.netenberg.com/files/click_be/free/click_be_installer.bz2
tar -xjpf click_be_installer.bz2
cd /var/netenberg/click_be/installer/
php click_be.php status
php click_be.php install

rvskin installation

mkdir /root/rvadmin
cd /root/rvadmin
wget http://member.rvskin.com/auto_rvskin.tgz; tar -xvzf auto_rvskin.tgz perl auto_rvskin.pl

=================

RVSKIN DETAILS:

RVSkin :: Frequently Asked Questions
We are tried to put together of these questions and answers for help you solve a problem at the first step. If you do not get your answer from these all questions, please send your inquiries to us at here

1. Pre-sales questions
2. Installation
3. 3rd party software integration
4. IP change/Server Migration


Pre-sales questions


1. How to order?

You can order RVSkin at http://www.rvskin.com/index.php?page=product/index in the site including the price for license and licenses agreement.


2. How to pay for the products?

You can pay by Master card, Visa, Amex and PayPal. If you do not have a credit card, you can pay by a money transfer via banks, Western Union and Money gram but you have to pay a fee transfer cause the our price not including it. In this way, please email and ask for payment information at here


3. How long is the license activated after payment?

Usually, you will get an email notification almost instantly. And you can install RVSkin on your server immediately. If you do not get an email, please contact us using contact form here here


4. How can I get invoice?



Log in at www.rvskin.com




1. On the top left side, click on Member Area
2. In member Area, on the left side you will see all menus. Select Print Invoice
3. In Print Invoice, you will see all your order and/or payment information.
4. In the table, look at the invoice column that you can see "print" click on "print" if you want to print invoice.


5. What are WHM, cPanel and RVSkin and how are they difference?

WHM (WebHosting Manager) is the control panel for managing your server. It has tools to manage all features in the server such as server setup, reseller, account function, themes, etc.
cPanel has been controlled by WHM. cPanel is a fully featured web-based control panel that allows you to manage your domain through a web interface. The idea is transfer as much of the control and responsibility of managing your web site to clients. Your clients can manage all aspects of e-mail, files, backup, FTP, CGI scripts, and web site statistics themselves. The default cPanel control panel is cPanel X. RVSkin is the multi-languages, multi-themes advanced skin management software for cPanel server. Here are the comparison table between cPanel X3 and RVSkin .


6. What the requirement to order RVSkin?

Firstly, you have to install cPanel at your server. If you do not have cPanel in your server, you can order cPanel by http://www.cpanel.net/dist.cgi Secondly, you must have root access for installing RVSkin.


7. How many discounts will you get if you are the data center, dedicated server or order more than 20 licenses?

Discounts are available for the data center, dedicated server or who order more than 20 licenses only. Send me your detail, contact person, amount of licenses you want to order. By here sale@rvskin.com




Installation


1. How do if install error?

Go to see information about installation at here.


2. How do if I get invalid license error?

You have to report error and your IP Address (that you got after you order) back to us by support@rvskin.com


3. How to set up WHM Remote Access Key for RVSkin?



Usually, RVSkin will detect WHM Remote Access Key. If RVSkin detected, WHM Remote Access Key will install automatically. However if your server is new or just installs cPanel, RVSkin will not able to detect WHM Remote Access Key and you have to install WHM Remote Access Key manually. To install WHM Remote Access Key please follow instruction here.

1. SSH to server as root
2. Create new file and paste WHM Remote Access Key ( You can find your WHM Remote Access in https://YOUR_SERVER_IP:2087/scripts/setrhash) using below command :

pico /usr/local/cpanel/Cpanel/rvwhmkey

And paste remote access key in this file. PASTE ONLY a key DON'T INCLUDE additional SPACE, line break, ------BEGIN WHM ACCESS KEY------, -------END WHM ACCESS KEY-------

chown securervskin:securervskin /usr/local/cpanel/Cpanel/rvwhmkey
chmod 700 /usr/local/cpanel/Cpanel/rvwhmkey


4. How do if error missing WHM Remote Access Key or error incorrect WHM Remote Access Key

You can generate a new WHM Remote Access Key using above instruction.


5. When creating admin for RVSkin, why in admin RVSkin account said hostname.net.zz?

The first time you install RVSkin, installer will create new hosting account for admin purpose. It should not reference to any valid domain to prevent email spamming. So, we use your hostname and follow with .zz to make it invalid. Domain name for Rvadmin could be abcdef.zz but we pick the hostname to make it easy to browse when you bookmark it. You will know which server you are accessing.


6. How to uninstall RVSkin?
Run this command:
perl /root/rvadmin/uninstall.pl


3 Rd party software integration


1. How to integrate Fantastico?



Fantastico is automatically integrated since Fantastico Deluxe 2.8. If it isn't integrated, please follow the instruction here:

1. Go to rvadmin RVSkin Manager / 3rd Party Integration / Fantastico Integration.
2. There is an instruction to creaet symbolic link, if it doesn't exist please do it first. You can verify it by ignore this step. If the symbolic link doesn't exist, when you do step 4 it will return you an error.
3. Choose standalone Fantastico and click at submit. Fantastico should now integrated.
4. After that, at configuration go to Package ? feature Manager.
5. Click at edit at default feature list or in each package feature list.
6. Find the Fantastico and select Enable in each feature list allowing user to access..


2. How to integrate Urchin?


1. At RVSkin Manager, go to Urchin Integrate
2. In Urchin integrate; you get two choices for set Urchin. The first one is cPanel Urchin build-in integration that you can integrate immediately and the second one is your own integration that you have to show the path and log in page to install Urchin by yourself ( we recommended to select the cPanel Urchin build ? in integrate)
3. Click at submit. Urchin should now integrated.
4. After that, at configuration go to Package ? feature Manager.
5. Click at edit at default feature list or in each package feature list.
6. Find the Urchin and select Enable in each feature list allowing user to access..


3. After install CPskins, what I have to do?
Go to Package - feature Manager, and edit the feature list that user will allow to use the scripts.


4. PostgreSQL database


1. At RVSkin Manager, go to PostgreSQL database
2. Select the 'Enable' to integrate PostgreSQL database to RVSkin.
3. Click at submit. PostgreSQL should now integrated.
4. In Package - feature Manager, Click at edit at default feature list or in each package feature list.
5. Find the PostgreSQL and select Enable in each feature list allowing user to access..


5. Modernbill


Passwordless accessing modernbill from user cPanel will not easier than this. You can integrate it to RVSkin within 1 minutes!

1. At RVSkin Manager, go to Modernbill Integration
2. Set modernbill database information
3. Surprises, you are done.


IP change/Server Migration
I am migrating the server to the new one. How can I transfer the license to the new IP?


We allow you change IP to the new server belonging to you. You cannot change or transfer the license to others.

To transfer the license pleases follow the instruction here step by step. You will be able to run RVSkin on the old server for 30 days, but it cannot be updated.

1. Request the transfer.
If you purchase directly from http://rvskin.com and your license is in the subscription period, you can transfer the license to the new IP at no cost. Newly purchased license will get free 1 year subscription. Additional year will cost $25 - $29 depend on your type of the license. To transfer the license, please login to our website, you will find the transfer request form. The IP change request form is not automated. Each IP need to be approved manually. It will takes 24 hours to be updated (not including Saturday and Sunday). If you forgot the password, please request new one at the forgot password page.

If you get it from your provider, you need to contact him asking for the transfer. Some providers sell dedicated server w/ RVSkin license. If you move out, very less chance your provider will transfer license for you.
2. Transfer rvadmin hosting account from the old server to new server using WHM /Transfers.
3. Install RVSkin in the new server using installation here.


=====================

Fantastico problems

I) Fantastico is not installed at the default location
/usr/local/cpanel/3rdparty/fantastico. Either move the
Fantastico directory from it's current location to
/usr/local/cpanel/3rdparty/fantastico OR enable
ioncube loaders in WHM -> Tweak settings.

II)Internal Server Error

Premature end of script headers: /usr/local/cpanel/whostmgr/docroot/cgi/addon_fantastico.cgi: Please check /usr/local/cpanel/logs/error_log for the exact error.

======================

solution: The problem is related to perl

cd /usr/local/bin/ ;
mv perl perl.old ;
ln -s /usr/bin/perl ;

======================

To print a-z

for i in {a..z} ; do echo $i;done;

Unable to upload files via cpanel file manager

solution:

go to whm>manage plugins> install clamav

this will fix the issue

To grep multiple contents

egrep "foldername|foldername|foldername"

How to install RPM

How to install RPM
What is RPM?



Many Linux distributions use RPM as the default application management system. This means that when using RPM packages, it is quite easy to install applications to your favorite Linux distributions.

RPM is originally developed by Red Hat, but nowadays you can run into rpm in many other linux distributions (for example Fedora Core, CentOS, Mandriva or Yellow Dog Linux) and even on other operating systems (Novel Netware and IBM Aix).

RPM packaged software follows usually the following format:

(name)-(version)-(release).(arch).rpm

For example: httpd-2.23-2.i386.rpm

Also source codes can be downloaded in rpm packages. For example httpd-2.23-2.i386.src.rpm. RPM files with the noarch.rpm extension refer to files that don't depend on a computer's architecture.

Install RPM

Installing RPM package is very easy and straightforward:

* rpm -ivh package.rpm - installs package.rpm
* rpm -Uvh package.rpm - updates package.rpm
* rpm -qi package - displays (already installed ) information about application "package"
* rpm -qpi package.rpm - displays information about rpm-file
* rpm -qpl package.rpm - displays files included in package.rpm
* rpm -qa - lists all rpm packages installed to your distribution
* rpm --rebuilddb - rebuilds your rpm database

With these simple commands you can install rpm packages to your linux distribution!

Data base restore from old to new

1. Check whether the PHP and Apache configurations of /old and the new server.
/old/var/cpanel/cpanel.conf
/old/usr/local/apache/conf/
2. Recompile PHP and Apache to make so.
3. Run the script http://script.sherin.co.in/cpanel/restorefiles.sh
4. Copy the content in /old/var/lib/mysql to /var/lib mysql/ ---- (with same permisions and ownerships)
5. Copy the content of /old/home/ to /home/ ---- (with same permisions and ownerships)
6. Again run an upcp and recompile Apache and PHP.

disable open_base and safe_mode

Warning: curl_setopt() [function.curl-setopt]: CURLOPT_FOLLOWLOCATION cannot be activated when in safe_mode or an open_basedir is set in /home/brightla/public_html/directions.php on line 190


solution

1. log into his WHM and click Security Center under the Security section.
2.The 5th option down should be PHP open_basedir Tweak
3.From there you can disable it per account

Argument list too long

Argument list too long

Have you ever seen this very annoying error message? I bet you have!

I had to move little over 36k files in one directory to another box. Scp and both let me know there's too many files for them to handle. So what to do?

Each shell session has a pre-configured amount of storage with a hard limit. To check it you can type getconf ARG_MAX which will type whatever the max arg is in your box.

You can work around this easily wit tar. Just pre-build list of filenames and then pass the list to tar:


find . -iname '*.gif' > list.txt
tar czvf files.tar.gz --files-from list.txt


Sit back and enjoy the ride while box archives your files!

database repair

mysqldump: Got error: 145: Table './epidata_tikidb/tiki_searchindex' is
marked as crashed and should be repaired when using LOCK TABLES

solution:

myisamchk -crS /var/lib/mysql/database/*.MYI

To repair a table?

myisamchk -r /var/lib/mysql/apnoshr_joomla/jos_components.MYI

HOW TO PREVENT DDOS ATTACKS

All web servers been connected to the Internet subjected to DoS (Denial of Service) or DDoS (Distrubuted Denial of Service) attacks in some kind or another, where hackers or attackers launch large amount connections consistently and persistently to the server, and in advanced stage, distributed from multiple IP addresses or sources, in the hope to bring down the server or use up all network bandwidth and system resources to deny web pages serving or website not responding to legitimate visitors.

You can detect the ddos using the following command

netstat -anp|grep tcp|awk '{print $5}'| cut -d : -f1|sort|uniq -c|sort -n

It will shows the number of connections from all IPs to the server.

There are plenty of ways to prevent, stop, fight and kill off DDoS attack, such as using firewall. A low cost, and probably free method is by using software based firewall or filtering service. (D)DoS-Deflate is a free open source Unix/Linux script by MediaLayer that automatically mitigate (D)DoS attacks. It claims to be the best, free, open source solution to protect servers against some of the most excruciating DDoS attacks.

(D)DoS-Deflate script basically monitors and tracks the IP addresses are sending and establishing large amount of TCP network connections such as mass emailing, DoS pings, HTTP requests) by using “netstat” command, which is the symptom of a denial of service attack. When it detects number of connections from a single node that exceeds certain preset limit, the script will automatically uses APF or IPTABLES to ban and block the IPs. Depending on the configuration, the banned IP addresses would be unbanned using APF or IPTABLES (only works on APF v 0.96 or better).

Installation and setup of (D)DOS-Deflate on the server is extremely easy. Simply login as root by open SSH secure shell access to the server, and run the the following commands one by one:

wget http://www.inetbase.com/scripts/ddos/install.sh
chmod 0700 install.sh
./install.sh

To uninstall the (D)DOS-Deflate, run the following commands one by one instead:

wget http://www.inetbase.com/scripts/ddos/uninstall.ddos
chmod 0700 uninstall.ddos
./uninstall.ddos

The configuration file for (D)DOS-Deflate is ddos.conf, and by default it will have the following values:

FREQ=1
NO_OF_CONNECTIONS=50
APF_BAN=1
KILL=1
EMAIL_TO=”root”
BAN_PERIOD=600

Users can change any of these settings to suit the different need or usage pattern of different servers. It’s also possible to whitelist and permanently unblock (never ban) IP addresses by listing them in /usr/local/ddos/ignore.ip.list file. If you plan to execute and run the script interactively, users can set KILL=0 so that any bad IPs detected are not banned

DIG COMMAND

DIG Command
dig is a command-line tool for querying DNS name servers for information about host addresses, mail exchanges, name servers, and related information.
Understanding the default output

The most typical, simplest query is for a single host. By default, however, dig is pretty verbose. You probably don’t need all the information in the default output, but it’s probably worth knowing what it is. Below is an annotated query.

This article explains you how to do the data recovery from a crashed windows-plesk server.

$ dig www.yahoo.com

That’s the command-line invocation of dig I used

; <<>> DiG 9.2.3 <<>> www.yahoo.com
;; global options: printcmd

The opening section of dig’s output tells us a little about itself (version 9.2.3) and the global options that are set (in this case, printcmd). This part of the output can be quelled by using the +nocmd option, but only if it’s the very first argument on the command line (even preceeding the host you’re querying).

;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 43071
;; flags: qr rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 3, ADDITIONAL: 3

Here, dig tells us some technical details about the answer received from the DNS server. This section of the output can be toggled using the +[no]comments option—but beware that disabling the comments also turns off many section headers.

;; QUESTION SECTION:
;www.yahoo.com. IN A

In the question section, dig reminds us of our query. The default query is for an Internet address (A). You can turn this output on or off using the +[no]question option.

;; ANSWER SECTION:
www.yahoo.com. 600 IN A 203.23.184.88

Finally, we get our answer: the address of www.yahoo.com is 204.152.184.88. I don’t know why you’d ever want to turn off the answer, but you can toggle this section of the output using the +[no]answer option.

;; AUTHORITY SECTION:
yahoo.com. 2351 IN NS ns1.nis.tc.org.
yahoo.com. 2351 IN NS ns1.gnac.com.
yahoo.com. 2351 IN NS ns2.nis.tc.org.

The authority section tells us what DNS servers can provide an authoritative answer to our query. In this example, yahoo.com has three name servers. You can toggle this section of the output using the +[no]authority option.

;; ADDITIONAL SECTION:
ns1.gnac.com. 171551 IN A 203.23.34.21
ns-int.yahoo.com. 2351 IN A 211.52.18.65
ns-int.yahoo.com. 2351 IN AAAA 2001:4f8:0:2::15

The final section of the default output contains statistics about the query; it can be toggled with the +[no]stats option.
Some useful options with dig

dig will let you perform any valid DNS query, the most common of which are A (the IP address), TXT (text annotations), MX (mail exchanges), NS name servers, or the omnibus ANY.
# get the address(es) for yahoo.com

dig yahoo.com A +noall +answer

# get a list of yahoo's mail servers

dig yahoo.com MX +noall +answer

# get a list of DNS servers authoritative for yahoo.com

dig yahoo.com NS +noall +answer

# get all of the above

dig yahoo.com ANY +noall +answer

#Short answer

dig yahoo.com +short

#To get the TTL values

dig +nocmd yahoo.com mx +noall +short

#To get a long answer

dig +nocmd yahoo.com any +multiline +noall +answer

#To reverselookup

dig -x 216.109.112.135 +short

To bulk lookups # do full lookups for a number of hostnames

#dig -f /path/to/host-list.txt

#the same, with more focused output

dig -f /path/to/host-list.txt +noall +answer

Tracing dig's path

dig yahoo.com +trace

How to interpret TTL value

If you ask your local DNS server for an Internet address, the server figures out where to find an authoritative answer and then asks for it. Once the server receives an answer, it will keep the answer in a local cache so that if you ask for the same address again a short time later, it can give you the answer quickly rather than searching the Internet for it all over again.

When domain administrators configure their DNS records, they decide how long the records should remain in remote caches. This is the TTL number (usually expressed in number of seconds).

When domain administrators configure their DNS records, they decide how long the records should remain in remote caches. This is the TTL number (usually expressed in number of seconds).
For example, as of this writing, the TTL for the MX records for the gmail.com domain is 300 seconds. The gmail.com admins are asking that remote servers cache their MX records for no more than five minutes. So when you first ask for that record set, dig will report a TTL of 300.

$ dig +nocmd gmail.com MX +noall +answer
gmail.com. 300 IN MX 20 gsmtp57.google.com.
gmail.com. 300 IN MX 10 gsmtp171.google.com.

If you ask a few seconds later, you’ll see the TTL number reduced by approximately the number of seconds you waited to ask again.

$ dig +nocmd gmail.com MX +noall +answer
gmail.com. 280 IN MX 10 gsmtp171.google.com.
gmail.com. 280 IN MX 20 gsmtp57.google.com.

If your timing is good, you can catch the record at the very end of its life.

$ dig +nocmd gmail.com MX +noall +answer
gmail.com. 1 IN MX 10 gsmtp171.google.com.
gmail.com. 1 IN MX 20 gsmtp57.google.com.

After that, the DNS server you’re querying will “forget" the answer to that question, so the whole cycle will start over again (in this example, at 300 seconds) the next time you perform that query.

INSTALL A PEAR MODULE MAIL.php

For installing Mail.php module

pear install mail

we can verify it from the following command

pear list

DOMAIN NAME IS NOT LISTING IN THE WHM * LIST ACCOUNTS

Please make sure that the domain entry in the following files.

/etc/userdomains

(domain name and username should be present in this file)

/etc/localdomains

/etc/trueuserdomains

CPANEL INSTALLATION

cPanel Installation Instructions:
cPanel now uses a universal install script which can be found at
http://layer1.cpanel.net/. You can use the following commands in the root
shell to download and start the installation script:
mkdir /home/cpins
cd /home/cpins
wget http://layer1.cpanel.net/latest
sh latest

EACCELERATOR INSTALLATION

Eaccellerator Installation
Also another route is:

Code:

wget http://www.ecsportal.com/projects/eaccelerator.sh
chmod 755 eaccelerator.sh
./eaccelerator.sh



when done you see link look like

Code:

quote:/usr/local/lib/php/extensions/no-debug-non-zts-20020429/eaccelerator.so

copy your like to add in php.ini

edit php.ini
Code:

nano -w /usr/local/lib/php.ini

add this after Windows Extensions , in the list down.

Code:

zend_extension="/usr/local/lib/php/extensions/no-debug-non-zts-20020429/eaccelerator.so"
eaccelerator.shm_size="32"
eaccelerator.cache_dir="/tmp/eaccelerator"
eaccelerator.enable="1"
eaccelerator.optimizer="1"
eaccelerator.check_mtime="1"
eaccelerator.debug="0"
eaccelerator.filter=""
eaccelerator.shm_max="0"
eaccelerator.shm_ttl="0"
eaccelerator.shm_prune_period="0"
eaccelerator.shm_only="0"
eaccelerator.compress="1"
eaccelerator.compress_level="9"



save and restart apache

Code:

/sbin/service httpd restart


*END*

test your work now

Code:

php -v


if your install done you will see look like this

Code:

> php -v
PHP 4.4.4 (cli) (built: Aug 23 2006 04:09:14)
Copyright (c) 1997-2006 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
with eAccelerator v0.9.5-rc1, Copyright (c) 2004-2006 eAccelerator, by eAccelerator
with Zend Extension Manager v1.0.10, Copyright (c) 2003-2006, by Zend Technologies
with Zend Optimizer v3.0.1, Copyright (c) 1998-2006, by Zend Technologies


This installation will work on DirectAdmin + CPanel Systems

IONCUBE INSTALLETION

Installing Ioncube
ionCube produces leading tools for PHP source code protection to secure your PHP software from prying eyes and to combat software piracy. Featuring an advanced compiled-code encoding engine that translates source to highly efficient bytecodes, ionCube encoding tools deliver the ideal combination of maximum source code protection without sacrificing performance, reliability or language compatibility.

In order to view encoded ionCube files on your server you need the ionCube loader. This is a free plugin for Apache web server that only takes a few minutes to install and is well worth it.
http://www.ioncube.com/

Requirements:
- Root Shell access to your server
- phpinfo page: create a new document and call it phpinfo.php. Inside place phpinfo();
Place this document in your www directory so you can view it and see all your PHP settings.


Installing ionCube Loader:

1. Download the program and store it on your server using wget or FTP.
http://www.ioncube.com/loader_download.php

2. Unpack the program
tar -zxvf ioncube_loaders.tar.gz

3. cd ioncube

4. copy ioncube-install-assistant.php to a web directory such as your hosting directory and open it in your browser window.
cp ioncube-install-assistant.php /home/userdirectoryhere/www

Then open it http://www.yourdomain.com/ioncube-install-assistant.php
The output should be something similar to:

Analysis of your system configuration shows:

PHP Version 4.3.3
Operating System Linux
Threaded PHP No
php.ini file /usr/local/lib/php.ini
Required Loader ioncube_loader_lin_4.3.so

5. Now lets move the iconcube directory to a permanent location:
cd ..
mv ioncube /usr/local

6. Now that you know the location of php.ini you need to edit it.
pico /usr/local/lib/php.ini

Now find where other zend extentions are in the file.
ctrl + w: zend_extension

Paste in your new line for ioncube loader
zend_extension = /usr/local/ioncube/ioncube_loader_lin_4.3.so

7. Save the changes
ctrl + X then Y and enter

8. Restart the web server to take effect.
/etc/init.d/httpd restart

Success! You should now see a section in your PHP Info page that says:
Additional Modules
Module Name ionCube Loader

Hide Commands in Shell

Hide Commands in Shell

To hide the commands you are entering in shell, use "stty" command :)

#stty -echo

Now, all commands that you type are invisible.
To disable this mode, issue the following command at the shell prompt:

#stty echo

Hows it? :)

To disable email seniding in cron tab

Add /dev/null 2>&1 at the end of the script

i.e 30 8 * * * command > /dev/null 2>&1

script to print 1-10

for i in `seq 1 10` ;do echo $i;done;

DNS FORWARDING

for a in 'grep theright /etc/trueuserowners | cut -d ':' -f1'; do for b in `grep $a /etc/userdomains | cut -d":" -f1`;do replace "66.7.213.144" "66.7.219.239" -- /var/named/$b.db ; done ; done;

To change the Ip from 66.7.213.144 to 66.7.219.239

Email forwarders

You can import email forwarders for one domain at a time ,i.e your list must be in the following form

For example you have 5 email address in the domain "nmjw02.com" i.e test1@nmjw02.com,...test5@nmjw02.com ,you can import the forwarders for these addresses in the following manner

source target
test1 jibin.t@hostdime.in
test2 rahul.r@hostdime.in
.
.

and lastly select the domain "nmjw02.com" from the drop down list. Other wise it will not work.

You can get the details regarding this issue From the following link

===================

http://tutorials.hostmonster.com/emailimport/

==================

If you need further assistance Please feel free to contact us.

Regards.

Installations

http://karthickv.wordpress.com/2008/06/

how to do transfer having account size more than 2 GB

1) Move public_html to /home/ as user_public or public_user (anything like that)
2) create a link of user_public to ../ (i.e /home)
3) packageaccount user_public
4) restore account user_public

then you need to transfer public_html by rsync

transfer user_public using rsync to /home of dest: and then it rename a public_html ...

How to secure a server....

We can easily done by this using the following script

=========

http://script.sherin.co.in/jsecure.sh

=========

How can I change my MySQL database collation?

Usually you will be interested in changing your MySQL collation in order to solve problems with foreign character encodings. The most common case is to change your MySQL collation from latin1 to utf8. This can be done by using phpMyAdmin and following the instructions below:



1. Enter your cPanel and click on the phpMyAdmin icon in the Databases box.


2. Select the database you wish to manage from the drop-down menu on the left



3. Click on the Operations tab in the top menu of your phpMyAdmin



4. At the bottom of the page you will see the collation option. You can now select a collation from the drop down menu and click on the Go button.


Please note that after your change the collation of a database only the new tables will be created with the new collation. All other tables remain with the collation, they were initially created.



For the convenience of their customers, most web hosts have set MySQL's collation to utf8 by default. You can also benefit from this feature by joining Siteground.

How to change ssh informations

Changing the port number
vi /etc/ssh/sshd_config
edite the port number
restart the sshd------>>>/etc/init.d/sshd restart

AWSTATS NOT UPDATING

go to

/home/user/tmp/awstats/awstats.domainname.conf

change

AllowToUpdateStatsFromBrowser 0 ===>>> 1

go to whm >> tweak settings >> under stats >> AllowToUpdateStatsFromBrowser

check the option

How to reset mysql password

mysql -u username -p

SET PASSWORD FOR cenimed_cardio@localhost = OLD_PASSWORD('123456');

grant all privileges on saudican_monpl2.* to 'saudican_monpl2'@'localhost' identified by 'monpl2';

Disable Modsecurity

Add the following into .htaccess

SecFilterEngine Off
SecFilterScanPOST Off

IT IS POSSIBLE TO DISABLE MOD_SECURITY UNDER PARTICULAR FOLDERS i.e add a .htaccess file under that folder and add the above two lines

To convert courier to dovcot

To convert courier to dovecot

==========
# /scripts/setupmailserver --force dovecot
# /scripts/convert2dovecot
=========

PS: Don't convert it is shared server until you get an update

convert mbox to maildir

In shared servers maildir is preferred .You can do the above same by using mail directory conversion system in the webhost manager

To enable Wild card on domains

Wild card:

Security for your entire domain. A wildcard certificate for *.example.com will secure www.example.com, mail.example.com, and any other first-level subdomain of example.com. DigiCert's wildcard even secures the base domain itself—example.com—something no other wildcard currently offers.


go to SSL Virtual Hosting on one IP. IIS 6 and Apache are both able to use a wildcard certificate to serve multiple secure sites from a single IP address.

===================

zone file
vi /var/named/dnmae.db
* IN A IP
/scripts/restartsrv httpd

vi /usr/local/apache/conf/httpd.conf

server alias *.domainname

save and exit

restart httpd

Mysql error

[root@ibasoft ~]# service mysql restart
Shutting down MySQL/etc/init.d/mysql: line 220: kill: (7430) - No such process
................................... [FAILED]
rm: cannot remove `/var/lock/subsys/mysql': Read-only file system
Starting MySQL [ OK ]


=======

Check the hard disk by using

/scripts/smartcheck

SVN (subversion)

For future reference, to recompile the svn modules:
cd /root/downloads/subversion-1.6.2
make clean

./configure --with-apxs=/usr/local/apache/bin/apxs --with-apr=/home/cpeasyapache/src/httpd-/srclib/apr/apr-1-config --with-apr-util=/home/cpeasyapache/src/httpd-/srclib/apr-util/apu-1-config --prefix=/usr/local/subversion --with-sqlite=/usr/local/sqlite

OR

./configure --with-apxs=/usr/local/apache/bin/apxs --with-apr=/usr/local/apache/bin/apr-1-config --with-apr-util=/home/cpeasyapache/src/httpd-2.2.13/srclib/apr-util/


make

make install

================
http://forums.cpanel.net/f5/installing-subversion-cpanel-76149.html
==============

FAST CGIT OVER mod_wsg

FastCGI for PHP makes all your PHP applications run through mod_fastcgi instead of mod_phpsusexec. This eliminates the overhead of loading the PHP interpretor on every hit. Since it is always in memory ready for the next hit, the responses will be generated faster. This is done without a need to modify to your existing PHP applications will be performed so you can easily enable and disable it at will.
Please verify the following FastCGI Benefits:
================================
1.PHP scripts will run faster. The PHP interpreter is loaded into memory rather than calling from storage for every hit, greatly improving performance of your scripted site.
2.You will use less Server Resources. Since the server does not have load the PHP interpreter for each hit, you will be able to accommodate a higher traffic site without exceeding your CPU quota.
3. No modifications to your existing code are required. Everything you currently run will work with FastCGI for PHP.
===================================
Thus, FastCGI is better than mod_wsgi. Shall we procced with the FastCGI installation.

cannot create mailing list

ImportError: No module named paths
Unable to touch file /usr/local/cpanel/3rdparty/mailman/archives/public/index.html: No such file or directory at /usr/local/cpanel/bin/mailman-install line 188.
Processing consult

=========

yum install python-devel
/scripts/reinstallmailman

Difference between du and df commands

This is due to the fact that, some user processes keeps the deleted files open. "du" doesn't show that since the file (if it is removed), or the file contents (if it is cleared) is not there in the current working directory.

"df" will continue to display the previous disk space, until the space is de-allocated. To de-allocate this space either the file descriptor of the file should close or the process should exit.

Therefore you can try restarting the daemons used by these files or reboot the server.

Squirrelmail: [ALERT] You exceeded your mail quota

Squirrelmail webmail will sometimes throw the following error message when sending (or moving) an email:
ERROR: Could not append message to INBOX.Sent.
Server responded: [ALERT] You exceeded your mail quota.
Solution: Remove unneccessary messages from your folder and start with
your Trash folder.
Common sense would say to delete your trash. Well, that’s not going to work. The problem is that the “maildirsize” file in the user’s Maildir is not showing the correct quota information. Simply delete the file from the user’s Maildir and the problem will go away. When the user receives a new email, the file will be recreated with the correct information.

maildirsize file

root@clara [~]# cat /home/jckmedia/mail/domain.com/username/maildirsize

Outlook Express

Steps to configure Outlook express

1) Go to the Tools menu and select Accounts.
2) In the Internet Accounts window, click the Add button and select the Mail option.
3) Enter your name as you would like it to appear on your email in Display name: field.
4) Click the Next button.
5) Fill in E-mail address.
6) Click the Next button.
7) For Incoming mail (POP3, IMAP, or HTTP) server put your e-mail server(mail.DOMAIN.COM)
8) Click the Next button.
9) Enter the Account name: (test@DOMAIN.COM)
10) Enter the Password which corresponds to this account.
11) Do NOT select Log on using Secure Password Authentication (SPA).
12) Click the Next button.
13) Click the Finish button.
14) In the Internet Accounts window, click the Mail tab, then double-click your account name, this will open the properties window.
15) In the Account Properties window, click the Servers tab.
16) Under Outgoing Mail Server, check next to My server requires authentication.
17) Click the Advanced tab, disable the option Leave a copy of message in the server.
18)Then click apply and then Ok.

Script to change premission of files and folders

To change the permission of files to 644
find /home/$i/public_html -type f -exec chmod 644 '{}' \;

To change the permission of folders to 755
find /home/$i/public_html -type d -exec chmod 755 '{}' \;

Php Suexec

To check whether php suexec is enabled in the server

/usr/local/cpanel/bin/rebuild_phpconf --current

Block IP using IP tables

iptables -A INPUT -s IP -j DROP
iptables -A OUTPUT -d IP -j DROP

Php info page not showing changes??

1)Copy /usr/local/cpanel/cgi-sys/php5.cgi to /home/username/ public_html/cgi-bin

2)Add the below given script

root [/home/username/public_html/cgi-bin]# vi phpini.cgi
#!/bin/sh
export PHPRC=/home/username/public_html
exec /home/username/public_html/cgi-bin/php5.cgi

3)And added a php.ini in the location (/home/username/public_html)

4)In the .htaccess put the following.

AddHandler php-cgi .php
Action php-cgi /cgi-bin/phpini.cgi

5) Permission of phpini.cgi should be 755

To change Maximum emails perhour for a domain

1) Check [root@server ~]#vi /var/cpanel/maxemailsperhour to increase the value

2)[root@server ~]# vi /var/cpanel/maxemails
# If you update this file you must run /scripts/build_maxemails_config
domain.com=500
site.net=1000

3) To check the change
[root@server ~]#cat /var/cpanel/maxemailsperdomain/domain.com
500

To check whether ASP is avaliabe in server

/usr/local/apache/bin/httpd -l |grep mod_mono

Exim commands

1) To delete mails in the mail queue older than a day
exiqgrep -o 86400 -i | xargs exim -Mrm

2)exim -bp|grep $name Will show the mail in queue for $name
exim -Mvh $MSGID View message header
exim -Mvb $MSGID View message body
exim -M $MSGID Force delivery of message
exim -v -M $MSGID View the transact of message

3)Force delivery of one message
exim -M email-id

4)Force another queue run
exim -qf

5)Force another queue run and attempt to flush the frozen message
exim -qff

6)View the log for the message
exim -Mvl messageID

7)View the body of the message
exim -Mvb messageID

8)View the header of the message
exim -Mvh messageID

8)Remove message without sending any error message
exim -Mrm messageID

9)Giveup and fail message to bounce the message to the Sender
exim -Mg messageID

10)How much mail in the queue?
exim -bpr | grep "<" | wc -l


11)How many Frozen mails in the queue
exim -bpr | grep frozen | wc -l


12)Deleteing Frozen Messages
exim -bpr | grep frozen | awk {'print $3'} | xargs exim -Mrm


13)To find out, how many messages are there in the mail queue:
exim -bpc

14)To check the mails in the queue:
exim -bp

15)To force exim update:
/scripts/eximup --force

Number of connection to port 80 from different IP's

netstat -plan | grep :80 | awk '{print $5}' | cut -d: -f 1 | sort | uniq -c | sort -n

tmp showing 100% even after removing file!!!

root@server [/tmp]# lsof +aL1 /tmp | awk '{print $2}' | xargs kill -9

Cpanel Backend files!

Apache
=======
/usr/local/apache
+ bin- apache binaries are stored here - httpd, apachectl, apxs
+ conf - configuration files - httpd.conf
+ cgi-bin
+ domlogs - domain log files are stored here
+ htdocs
+ include - header files
+ libexec - shared object (.so) files are stored here - libphp4.so,mod_rewrite.so
+ logs - apache logs - access_log, error_log, suexec_log
+ man - apache manual pages
+ proxy -
+ icons -

Init Script :/etc/rc.d/init.d/httpd - apache start script
Cpanel script to restart apache - /scripts/restartsrv_httpd

Exim
=====
Conf : /etc/exim.conf - exim main configuration file
/etc/localdomains - list of domains allowed to relay mail
Log : /var/log/exim_mainlog - incoming/outgoing mails are logged here
/var/log/exim_rejectlog - exim rejected mails are reported here
/exim errors are logged here
Mail queue: /var/spool/exim/input
Cpanel script to restart exim - /scripts/restartsrv_exim
Email forwarders and catchall address file - /etc/valiases/domainname.com
Email filters file - /etc/vfilters/domainname.com
POP user authentication file - /home/username/etc/domainname/passwd
catchall inbox - /home/username/mail/inbox
POP user inbox - /home/username/mail/domainname/popusername/inbox
POP user spambox - /home/username/mail/domainname/popusername/spam
Program : /usr/sbin/exim (suid - -rwsr-xr-x 1 root root )
Init Script: /etc/rc.d/init.d/exim

ProFTPD
========
Program :/usr/sbin/proftpd
Init Script :/etc/rc.d/init.d/proftpd
Conf: /etc/proftpd.conf
Log: /var/log/messages, /var/log/xferlog
FTP accounts file - /etc/proftpd/username - all ftp accounts for the domain are listed here

Pure-FTPD
=========
Program : /usr/sbin/pure-ftpd
Init Script :/etc/rc.d/init.d/pure-ftpd
Conf: /etc/pure-ftpd.conf
Anonymous ftp document root - /etc/pure-ftpd/ip-address

Frontpage Extensions
=================
Program - (Install): /usr/local/frontpage/version5.0/bin/owsadm.exe
Uninstall and then install for re-installations
FP files are found as _vti-bin, _vti-pvt, _vti-cnf, vti-log inside the public_html

Mysql
=======
Program : /usr/bin/mysql
Init Script : /etc/rc.d/init.d/mysql
Conf : /etc/my.cnf, /root/.my.cnf
Data directory - /var/lib/mysql - Where all databases are stored.
Database naming convention - username_dbname (eg: john_sales)
Permissions on databases - drwx 2 mysql mysql
Socket file - /var/lib/mysql/mysql.sock, /tmp/ mysql.sock

SSHD
======
Program :/usr/local/sbin/sshd
Init Script :/etc/rc.d/init.d/sshd
/etc/ssh/sshd_config
Log: /var/log/messages

Perl
====
Program :/usr/bin/perl
Directory :/usr/lib/perl5/5.6.1/

PHP
====

Program :/usr/local/bin/php, /usr/bin/php
ini file: /usr/local/lib/php.ini - apache must be restarted after any change to this file
php can be recomplied using /scripts/easyapache

Named(BIND)
============
Program: /usr/sbin/named
Init Script: /etc/rc.d/init.d/named
/etc/named.conf
db records:/var/named/
/var/log/messages

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

Cpanel installation directory structure
=============================
/usr/local/cpanel
+ 3rdparty/ - tools like fantastico, mailman files are located here
+ addons/ - AdvancedGuestBook, phpBB etc
+ base/ - phpmyadmin, squirrelmail, skins, webmail etc
+ bin/ - cpanel binaries
+ cgi-sys/ - cgi files like cgiemail, formmail.cgi, formmail.pl etc
+ logs/ - cpanel access log and error log
+ whostmgr/ - whm related files

WHM related files
===============
/var/cpanel - whm files
+ bandwidth/ - rrd files of domains
+ username.accts - reseller accounts are listed in this files
+ packages - hosting packages are listed here
+ root.accts - root owned domains are listed here
+ suspended - suspended accounts are listed here
+ users/ - cpanel user file - theme, bwlimit, addon, parked, sub-domains all are listed in this files
+ zonetemplates/ - dns zone template files are taken from here

Common CPanel scripts
===================
cpanel/whm Scripts are located in /scripts/
+ addns - add 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 gorup nobody and activates security
+ addpop - add a pop account
+ addservlets - Add JSP support to an account (requires tomcat)
+ addstatus - (Internal use never called by user)
+ adduser - Add a user to the system
+ bandwidth - (OLD)
+ betaexim - Installs the latest version of exim
+ biglogcheck - looks for logs nearing 2 gigabytes in size
+ bsdcryptoinstall - Installs crypto on FreeBSD
+ bsdldconfig - Configures the proper lib directories in FreeBSD
+ bsdpkgpingtest - Tests the connection speed for downloading FreeBSD packages
+ buildbsdexpect - Install expect on FreeBSD
+ builddomainaddr - (OLD)
+ buildeximconf - Rebuilds exim.conf
+ buildpostgrebsd-dev - Installs postgresql on FreeBSD.
+ chcpass - change cpanel passwords
+ easyapache - recompile/upgrade apache and/or php
+ exim4 - reinstall exim and fix permissions
+ fixcommonproblems - fixes most common problems
+ fixfrontpageperm - fixes permission issues with Front Page
+ fixmailman - fixes common mailman issues
+ fixnamed - fixes common named issues
+ fixndc - fixes rndc errors with named
+ fixquotas - fixes quota problems
+ fullhordereset - resets horde database to a fresh one - all previous user data are lost
+ initquotas - initializes quotas
+ installzendopt - installs zend optimizer
+ killacct - terminate an account - make sure you take a backup of the account first
+ mailperm - fixes permission problems with inboxes
+ park - to park a domain
+ pkgacct - used to backup an account
+ restartsrv - restart script for services
+ restorepkg - restores an account from a backup file ( pkgacct file)
+ runlogsnow - update logs of all users
+ runweblogs - update stats for a particular user
+ securetmp - secures /tmp partition with options nosuexec and nosuid
+ suspendacct - suspends an account
+ unsuspendacct - unsuspends a suspended account
+ upcp - updates cpanel to the latest version
+ updatenow - updates the cpanel scripts
+ updateuserdomains - updates userdomain entries
Important cpanel/whm files
====================
/etc/httpd/conf/httpd.conf - apache configuration file
/etc/exim.conf - mail server configuration file
/etc/named.conf - name server (named) configuration file
/etc/proftpd.conf - proftpd server configuration file
/etc/pure-ftpd.conf - pure-ftpd server configuration file
/etc/valiases/domainname - catchall and forwarders are set here
/etc/vfilters/domainname - email filters are set here
/etc/userdomains - all domains are listed here - addons, parked,subdomains along with their usernames
/etc/localdomains - exim related file - all domains should be listed here to be able to send mails
/var/cpanel/users/username - cpanel user file
/var/cpanel/cpanel.config - cpanel configuration file ( Tweak Settings )*
/etc/cpbackup-userskip.conf -
/etc/sysconfig/network - Networking Setup*
/etc/hosts -
/var/spool/exim -
/var/spool/cron -
/etc/resolv.conf - Networking Setup--> Resolver Configuration
/etc/nameserverips - Networking Setup--> Nameserver IPs ( FOr resellers to give their nameservers )
/var/cpanel/resellers - For addpkg, etc permissions for resellers.
/etc/chkserv.d - Main >> Service Configuration >> Service Manager *
/var/run/chkservd - Main >> Server Status >> Service Status *
/var/log/dcpumon - top log process
/root/cpanel3-skel - skel directory. Eg: public_ftp, public_html. (Account Functions-->Skeleton Directory )*
/etc/wwwacct.conf - account creation defaults file in WHM (Basic cPanel/WHM Setup)*
/etc/cpupdate.conf - Update Config *
/etc/cpbackup.conf - Configure Backup*
/etc/clamav.conf - clamav (antivirus configuration file )
/etc/my.cnf - mysql configuration file
/usr/local/Zend/etc/php.ini OR /usr/local/lib/php.ini - php configuration file
/etc/ips - ip addresses on the server (except the shared ip) (IP Functions-->Show IP Address Usage )*
/etc/ipaddrpool - ip addresses which are free
/etc/ips.dnsmaster - name server ips
/var/cpanel/Counters - To get the counter of each users.
/var/cpanel/bandwidth - To get bandwith usage of domain