Monday, 22 September 2008

FTP error 530 Login incorrect

First of all check which FTP is using the Cpanel proftpd or pureftpd

If it is using the proftpd, do the folowing to fix the 530 error
1. First of all try the /scripts/ftpupdate
2. grep /etc/proftpd/passwd.vhosts (here is the domain username)
3. If it is not present there then grep /etc/proftpd/
4. Check details and cat >> /etc/proftpd/passwd.vhosts
5. Paste the main ftp account details in this file
6. /scripts/restartsrv_ftpserver

Note: please be careful in doing it. If you have specified cat > /etc/proftpd/passwd.vhosts, it w
ill overwrite the whole content.

If it is pureftpd:
Do the above 6 steps
7. Sometimes you need to rum "/usr/sbin/pure-uploadscript -B -r /usr/local/bin/ftpfilter" also

Saturday, 20 September 2008

Installing MySQL from Source

Get the source code
tar -xzf mysql-5.0.XX.tar.gz
% cd mysql-5.0*
% ./configure
--enable-thread-safe-client
--with-big-tables
--with-fast-mutexes
--with-extra-charsets=all
--with-innodb

and if you want some more engines
--with-archive-storage-engine 
--with-blackhole-storage-engine
--with-csv-storage-engine
--with-example-storage-engine
--with-federated-storage-engine

% make
% make install

Then:
chown -R mysql /usr/local/mysql/var
chmod -R 755 /usr/local/mysql/var

path could also be:
chown -R mysql /usr/local/var/
chmod -R 755 /usr/local/var

Also run :

/usr/local/bin/mysql_install_db /usr/local/bin/mysqld_safe &

Dont forget to change the admin password :

mysqladmin -u root -p password 'new-password'

On Linux/CentOS/RedHat :

1. Copy mysql.server.sh from the src directory /support-files to /etc/init.d and rename it to mysqld 2. Enter it into the startup scripts :

chkconfig –add mysqld chkconfig mysqld on

3. Edit the /etc/init.d/mysqld script so that the correct parameters (basedir , datadir, etc) are filled in and run the script to test it

4. Start and stop the service with : service mysqld stop service mysqld start

Wednesday, 10 September 2008

Setting Google site map generator script for domain

You can setup the Google sitemap generator script in the domain using the help of following URL:

The config.xml file should be edited according to the need of the customer domain. All steps are
specified in the URL. The python version should be 2.2 or above.
https://www.google.com/webmasters/tools/docs/en/sitemap-generator.html

Thursday, 28 August 2008

How to Fix PHPMyAdmin 403 Forbidden Error

If you have installed phpMyAdmin in your linux server (centos/RHEL/debian), and tried to access phpMyAdmin in most cases you will get this 403 forbidden error. I have seen this issue very often if you are installing phpmyadmin using yum or by apt-get. By default phpmyadmin installed path is /usr/share/phpmyadmin and the apache configuration file is located in /etc/httpd/conf.d/phpmyadmin.conf

Wednesday, 13 August 2008

Spamd child process causing high server load

Sometimes, spamd child process for a particular user can cause high server load. This is a bug with spamassassin :

To fix the issue, apply the patch mentioned in the bug.

For  servers, run the following scripts:

/scripts/autorepair spamd_dbm_fix
/etc/init.d/ restart

Sunday, 10 August 2008

Wordpress admin login issue -due to siteurl

During the wordpress installation, customers set the Site URL as http://www.domainName/wordpress. But in the configuration file (or wordpress folder) it will be "WordPress". Due to this customer can't login wordpress admin using http://www.domaName/WordPress/wp-login.php.

Fix: In that case you need to modify the wordpress database table entry.

Use the word press database and the following update:
select * from wp_options where option_name="siteurl"G;
update wp_options set option_value="http://www.domainName/WordPress" where option_name="siteurl";


Note: Replace the domainName by corresponding domain name. The wordpress prefix wp_ will change a
ccording to the situation.

Perl mail script

#!/usr/bin/perl

# This is a simple script to test sendmail.
# Replace "me" with a from address and "mydom.com" with the #sending domain.
# Replace "you" with a username to send to and "yourdom.com" #with the recipient's domain name.
# Upload this to the public_html folder as mailtest.pl and CHMOD it to 755
print "Content-type: text/plainnn";
unless(open (MAIL, "|/usr/sbin/sendmail -t")) {
print "error.n";
warn "Error starting sendmail: $!";
}
else{
print MAIL "From: me@mydom.comn";
print MAIL "To: you@yourdom.comn";
print MAIL "Subject: test subjectnn";
print MAIL "Perl Sendmail is working, please check your code.";
close(MAIL) || warn "Error closing mail: $!";
print "Mail sent.n";

}