web analytics

Category Troubleshooting

IIS7 file upload limit of 30M

I had wordpress setup for one of my domains in a windows 2008 server with IIS7. All files uploads upto 30M was working fine, but more than that no luck. Then I read that IIS7 has a default upload limit of 30M. I had to do two things to get it working. Details given below.

Click Start -> Internet Information Services Manager

Click on the webserver name to highlight it(in order to make changes globally) or just click on your website name to enable changes for that site alone.

On features view, scroll down to IIS -> Request Filtering.

On the right pane, click on Edit Feature Settings

Look for the field “Maximum Allowed Content Length”. It will be the default value of 30000000

Change the value to 104857600 which is 100M.

Save the changes and restart IIS(usually a restart is not needed)

Now...

Read More

The used command is not allowed with this MySQL version – LOAD DATA LOCAL INFILE

This error normally occurs when you run the ‘load data local infile’ command in mysql.

If you are seeing this error in shell, please check this link

If you are seeing this error while running a php script, here are the following things you can test.

I have a php script as follows for testing.


<?php
mysql_connect(“localhost”,”myuser”,”mypass”)or die(mysql_error());
mysql_select_db(“abc_test”) or die(mysql_error());

$query =”LOAD DATA LOCAL INFILE ‘/home/abc/public_html/test.csv’ INTO TABLE abctesting”;
mysql_query($query) or die(mysql_error());

?>

The file ‘test.csv’ contains some random input and if when this script runs, my database abc_test should populate the table abctesting with contents from the file ‘test.csv’

Unfotunately, when I ran this script over browser, I got the following ...

Read More

530 This FTP server is anonymous only. Login failed.

Ever received the following error while connecting to your site via FTP????

# ftp test.com
Connected to test.com.
220 (vsFTPd 2.3.5)
Name (test):
530 This FTP server is anonymous only.
Login failed.
ftp> bye

You can correct this problem by doing the following in the FTP configuration file.

vi /etc/vsftpd.conf

Now, the following lines will be commented, uncomment them.

local_enable=YES    – this lets the local users login via FTP
write_enable=YES   – this lets the users upload files

Save and quit the file.

/etc/init.d/vsftpd restart

Read More

htaccess pcfg_openfile: unable to check htaccess file

I was getting random forbidden errors on one of my websites one day. It appears and disappears and was not getting an idea as to what had happened. Upon checking the apache error log, I noticed the following error.

[Thu May 16 23:38:13 2013] [crit] [client x.x.x.x] (24)Too many open files: /var/www/vhosts/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable, referer: http://abc.com/blog/%20abcd?ades

Normally it happens due to the open files exceeding the limit. I tried the following and that fixed it.

1) A simple restart of apache fixed it all of a sudden.

2) Try ulimit -a as root and  check for “open files”. The default value will be 1024. Try raising it to 4096 as follows.

ulimit -n 4096

3) Also, you can raise this limit for apache by giving it in apache star...

Read More

configure: error: Cannot find libsphinxclient headers ERROR: `/tmp/pear/temp/sphinx/configure –with-sphinx’ failed

Installing SphinxClient
———————————
In a linux machine, you can install sphinx client using pecl install sphinx

But when I tried, it was hitting the error as follows:

configure: error: Cannot find libsphinxclient headers
ERROR: `/tmp/pear/temp/sphinx/configure –with-sphinx’ failed

After a lot of googling, I was about to solve it which is explained below.

1) Download sphinx source from sphinx site
    cd /usr/local/src/
    wget http://sphinxsearch.com/downloads/accept.php?file=sphinx-2.0.4-release.tar.gz

2) Untar it
   tar -xzvf sphinx-2.0.4-release.tar.gz

3) cd sphinx-2.0.4-release/api/libsphinxclient

4) ./configure

5) Once ./configure succeeds it is a common procedure to run make, make install to build the binaries. But here, don’t do it.

6) Instead, install a package named check...

Read More

Ubuntu Error: “No init found. Try passing init= bootarg”

It was my work time and I was all set to login. I logged in to my ubuntu 10.04 and took the applications one by one and soon the machine was all stuck. I waited some time to see if it corrects itself, but there was no luck. I then rebooted the machine and thought of taking everything again. To my surprise and making me tensed, was a black screen with the following error.

mount: mounting /dev/disk/by-uuid/***************************** on /root
failed: Invalid argument
mount: mounting /sys on /root/sys failed: No such file or directory
mount: mounting /dev on /root/dev failed: No such file or directory
mount: mounting /sys on /root/sys failed: No such file or directory
mount: mounting /proc on /root/proc failed: No such file or directory
Target file system doesn’t have /sbin/init
No init f...

Read More

OS Template not found in rebuild list

Sometimes, in hypervm, when you click on rebuild option, all available OS templates may not be listed. Here is what you can do to correct it.

1) Login to hypervm

2) Search the VPS and enter into its controlpanel

3) Click on OSTemplate list

It will list all available templates and you can select the required one and move it to the box right to it. After that when you click on rebuild option, that template will be listed there.

Read More