Hi all,
After searching CMS software for some time I have decided to install Drupal. But I have some problems during installation.
Below is detailed explanation of my setup and problems:
Installation environment 1(Hosting Company) :
System Linux 2.6.9-023stab044.4-smp #1 SMP
Apache Version Apache/2.0.51 (Fedora)
PHP Version 5.2.5
Mysql Client API version 5.0.45
Mysqli Client API library version 5.0.45
Installation environment 2(Local Linux Box) :
System Linux debian 2.6.18-6-686 #1 SMP
Apache Version Apache/2.2.3 (Debian) PHP/4.4.4-8+etch4
PHP Version 4.4.4-8+etch4
Mysql Client API version 5.0.32
Installation problems occur only when I try to install Drupal to my hosting account, whenever I install to my linux box both using local mysql database and using my hosting account database the installation competes without any problems. I have given the above env. information for you to make a comparison if needed.
I upload the package. (tried all as tar.gz and extracting files locally on W/XP and sending unpacked files via ftp and through Control Panel)
I change the rights as described in installation procedures. (Both methods tried, chmod w+o and 0777)
I start the installation and end up with the:
An HTTP error 403 occurred. http://www.pipstra.net/install.php?locale=en&profile=default&id=1&op=do
screenshot: http://03396.ve.carpathiahost.net/http_error_403.jpg
If I drop all tables from database (in order to check if it creates tables again.) then I receive the below message:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM d6_menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /home/cergun/pipstra.net/html/includes/menu.inc on line 315.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM d6_menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /home/cergun/pipstra.net/html/includes/menu.inc on line 315.
After trying many combinations of installation fiddling with user rights, database user changes etc. and many I have realised that the local installation and host installation has different number of tables.
When it ends with 403 error, there are only 43 tables created in database, on the other hand I have 53 tables created in my local debian box.
screenshot: http://03396.ve.carpathiahost.net/missing_tables.jpg
By mysqldump I gathered the table structure (not the data) from my linux box and loaded to my mysql database on host, but no go. Probably if I load the data with the table structure to my host database it may work but I prefer a flawless installation. Otherwise it may cause an unexpected error in the future and that may cause a lot of trouble.
And I have just found the below messages in error logs of the web server:
[Tue May 06 17:53:44 2008] [notice] jrApache[20741] Couldn't initialize from remote server, JRun server(s) probably down.
[Tue May 06 17:53:44 2008] [error] [client 78.176.235.198] mod_security: Access denied with code 403. Pattern match "!(^application/x-www-form-urlencoded$|^multipart/form-data;)" at HEADER("Content-Type") [id "9001"] [severity "EMERGENCY"] [hostname "www.pipstra.net"] [uri "/install.php?locale=en&profile=default&id=1&op=do"] [unique_id "4dzcFn8AAAEAAA44g2sAAAAA"]
[Tue May 06 17:53:53 2008] [notice] jrApache[21253] could not initialize Server_1:127.0.0.1:51010
[Tue May 06 17:53:53 2008] [notice] jrApache[21253] Couldn't initialize from remote server, JRun server(s) probably down.
[Tue May 06 17:53:53 2008] [notice] jrApache[21509] could not initialize Server_1:127.0.0.1:51010
[Tue May 06 17:53:53 2008] [notice] jrApache[21509] Couldn't initialize from remote server, JRun server(s) probably down.
[Tue May 06 17:53:53 2008] [error] [client 78.176.235.198] PHP Fatal error: Call to undefined function _user_password_dynamic_validation() in /home/cergun/pipstra.net/html/install.php on line 710, referer: http://www.pipstra.net/install.php?locale=en&profile=default&op=start&id=1
[Tue May 06 17:53:56 2008] [notice] jrApache[21765] could not initialize Server_1:127.0.0.1:51010
If it was about Forex I would give many advices and teach lots of things about trading. But when it comes to PHP/mysql stuff, it seems I am rusted. It has been 8 years that I am away from computer business and even then I was never a web technologies expert in terms of web programming.
So... I am looking forward to recommendations and solutions.
Thanks in advance.
Caglar
Comments
Problem solved.
After my hosting company's investigation on the issue, it appears that the source of the problem was mod_security. For those who have this problem can contact their hosts and ask if they use mod_security on their Apache servers.
Then they can have mod_security disabled.
All the best.
I have same error during
I have same error during installation.
I have mode_security as well.
So, i keep mode_security too bad no more ver. 6 for me.
bob
ie / firefox mod_security
Same problem with Drupal v6.4
I logged the install process, and find ajax requests was rejected with 403
Find the install works with IE, not with mozilla/firefox.
Disabling mod_security in .htaccess works for me:
<IfModule mod_security.c>
SecFilterEngine Off
</IfModule>
but I'm not pleased with this.
I traced the request:
http://www.mysite.tld/dp/install.php?locale=en&profile=default&id=1&op=do
POST /dp/install.php?locale=en&profile=default&id=1&op=do HTTP/1.1
Host: www.mysite.tld
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.8.1.16) Gecko/20080702 Firefox/2.0.0.16
Accept: application/json, text/javascript, */*
Accept-Language: fr,fr-fr;q=0.8,en-us;q=0.5,en;q=0.3
Accept-Encoding: gzip,deflate
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive: 300
Connection: keep-alive
X-Requested-With: XMLHttpRequest
Referer: http://www.mysite.tld/dp/install.php?locale=en&profile=default&op=start&...
Content-Length: 0
Content-Type: application/xml
Cookie: SESSf1d58bd4a5fadf1d8e2dc45cee1b7b4f=t5sgarl67cpd7j7a25mm187fd5; PHPSESSID=jj54co34f47q41m2ef99kj3eb5; has_js=1
Pragma: no-cache
Cache-Control: no-cache
HTTP/1.x 403 Forbidden
Date: Sun, 24 Aug 2008 14:05:26 GMT
Server: Apache/10.0
Content-Length: 216
Keep-Alive: timeout=2, max=45
Connection: Keep-Alive
Content-Type: text/html; charset=iso-8859-1 find
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
I happened to read somewhere firefox doesn't send a Content-Length header with the POST request if you call send with null or an empty string, and it looks
like Apache's "SecFilterEngine" of mod_security is rejecting the POST because of the missing header.
Here, it seems firefox send Content-Length: 0.
My guess is that mod_security doesn't like 0 either?
I don't know if it's possible to modify mod_security configuration to accept Content-Length: 0, or if it's ok to modify drupal ajax requests to have Content-Length <>0 ?
Install error 403
I was able to set "SecFilterEngine Off" to the .htaccess for the site and got past the error.
modsec
I also start getting Forbidden responses when submitting pages. On this particular case, it happens when I try to upload a .jpg image, but NOT when I upload a .jpg. Couriouser and Curiouser.
@cagler. I see in your list
@cagler. I see in your list of errors the following
[Tue May 06 17:53:53 2008] [notice] jrApache[21253] could not initialize Server_1:127.0.0.1:51010
[Tue May 06 17:53:53 2008] [notice] jrApache[21253] Couldn't initialize from remote server, JRun server(s) probably down.
When you "fixed" mod_security, did this error go away? I can't find where jrun is needed by Drupal. I have the same issue on a client site - getting the jrun error.
thanks in advance
c