CentOS Yum GCC-Dummy Error

The following error has been reported while doing yum updates on CentOS 4.x systems: –> Processing Dependency: glibc-common = 2.3.4-2.25 for package: glibc-dummy-centos-4 –> Finished Dependency Resolution Error: Missing Dependency: glibc-common = 2.3.4-2.25 is needed by package glibc-dummy-centos-4 To fix this error, the the following commands: yum remove glibc-dummy-centos-4 yum install gcc & yum install… Continue reading CentOS Yum GCC-Dummy Error

MySQL Cheat Sheet

SSH repair and optimize all MySQL databases: # /usr/bin/mysqlcheck –repair –all-databases –password=xxxxxx # /usr/bin/mysqlcheck –optimize –all-databases –password=xxxxxx Upgrade/Downgrade to MySQL 4.x: backup database: # cd /root # /usr/bin/mysqldump –create-options –compatible=mysql40 –all-databases –force –user=root –password=xxxx > backup.sql

MySQL Optimization (my.cnf)

# vi /etc/my.cnf #opteron 852 4GB RAM [mysqld] safe-show-database max_connections = 500 key_buffer = 150M myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 1M table_cache = 1024 thread_cache_size = 100 wait_timeout = 300 connect_timeout = 10 max_allowed_packet = 16M max_connect_errors = 10 query_cache_limit = 1M query_cache_size = 32M query_cache_type = 1 skip-innodb… Continue reading MySQL Optimization (my.cnf)

Optimize sysctl.conf

# vi /etc/sysctl.conf # Kernel sysctl configuration file for Red Hat Linux # # For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and # sysctl.conf(5) for more details. # Disables packet forwarding net.ipv4.ip_forward=0 # Disables IP source routing net.ipv4.conf.all.accept_source_route = 0 net.ipv4.conf.lo.accept_source_route = 0 net.ipv4.conf.eth0.accept_source_route = 0 net.ipv4.conf.default.accept_source_route = 0 # Enable… Continue reading Optimize sysctl.conf

Install vsftpd

login into the server as root. Go to the /usr/local/src/ folder and download the latest version of vsftpd……. # cd /usr/local/src/ # wget ftp://vsftpd.beasts.org/users/cevans…d-2.0.5.tar.gz untar the tar.gz file. # tar -zxvf vsftpd-2.0.5.tar.gz Go to the directory and run the make file. # cd vsftpd-2.0.5 # make Once it has finished compile and execute it #… Continue reading Install vsftpd

cPanel commands run from root.

Common cPanel commands that are used in root. Restart chkservd: /etc/init.d/chkservd restart Tail Apache log: tail -f /usr/local/apache/logs/error_log Updates the cpanel server software: /scripts/upcp Reinstalls exim: /scripts/exim4 View traffic or if you think a site is being DDoS: cd /usr/local/apache/domlogs tail -f targetsite.com Correct bandwidth issues /scripts/cleanbw To fix problem in webalizer that stop updating… Continue reading cPanel commands run from root.

Published
Categorized as cPanel

How to import and export a mysql database as root

MySQL Backup mysqldump -u root -p DBNAME > BKPNAME.sql ———– MySQL Restore mysql -u root -p DBNAME < BKPNAME.sql You pay leave out the “-p” and it won’t ask you for the root password – -p, –password[=name] Password to use when connecting to server. If password is not given it’s asked from the tty.

Installing Subversion

It’s best to upgrade to Apache 2.2 with the DAV module enabled, but you may be able to get away with Apache 1.3 with DAV. cd /usr/src wget http://www.webdav.org/neon/neon-0.25.5.tar.gz tar -xvzf neon-0.25.5.tar.gz cd neon-0.25.5 ./configure && make && make install cd ../ mv neon-0.25.5 neon After the installation, download the subversion sources from here: http://subversion.tigris.org/servlets/ProjectDocumentList?folderID=260&expandFolder=74… Continue reading Installing Subversion

Installing DomainKeys

DomainKeys, similar to SPF records, authenticate that an email was sent from an authorized sender.  Several mail services such as Hotmail and Yahoo have started requiring these…luckily they are easy to set up in your cPanel. System requirements 1. cPanel/WHM v11.x with the latest build 2. Your Mail server must be using Maildir format and… Continue reading Installing DomainKeys