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
Month: July 2008
phpMyAdmin Error: Cannot start session
Among other problems you might not have noticed, phpMyAdmin might be giving you this error: phpMyAdmin – Error Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly. This means that your /tmp partition is full, or if you are on a VPS… Continue reading phpMyAdmin Error: Cannot start session
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.
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