Problem after filling out Database page

[Dick]

I'm installing on MySQL 5.0.51a-community-nt.  I'm installing Elxis locally on my DB server.

My installation passed the Pre-installation check.

After filling out the Database window and clicking Next, I get the following screen:

----------
The website cannot display the page
 HTTP 500 
   Most likely causes:
The website is under maintenance.
The website has a programming error.
 
   What you can try:
     Refresh the page.
 
     Go back to the previous page.
 
     More information

This error (HTTP 500 Internal Server Error) means that the website you are visiting had a server problem which prevented the webpage from displaying.

For more information about HTTP errors, see Help.
 ----

Does anyone know what may be causing this?   Am I using a wrong version of MySQL?   Thanks!

[Ivan Trebješanin]

Hi, and welcome
Please give us some info on your problem, like PHP version, MySQL version, are you using special .htaccess settings, what are the permissions of your root folder... or a link to your site, if it's online.

[datahell]

Check if an htaccess file causes this error. If there is an htaccess file remove it. Also check if your database settings are correct and PHP is allowed to access your database (database host should be localhost). You should have pre-create the database or db user has enough permissions to create the database on-the-fly.

[Dick]

I'm using an MS 2003 server as both my Web server and DB server (and also as my Web client, which is IE7).  I have MySQL 5.0.51a-community-nt installed.  The only database on the server is named Elxis.  I'm trying to access the localhost instance of the database using the root account and password.  That works fine outside of the Elxis installtion.

I'm using PHP 4.3.0.  There is no htaccess file (which I thought was just an Apache thing.)

Other things that may have a bearing.


This is a test server and is (unfortunately) only on my company's Intranet.

All users: local, remote, and user have execute and read access from the root on down.

Elxis is on a separate Web site at port 84.   MS Sharepoint Services control the Default Web Site.

IIS has been configured to work with PHP.

This box also is an MS SQL Server 2003 server.  Strangely, when I specify MS SQL Server on the Elxis installation database window, I do progress a little further.  I get the error "Could not connect to database"

[datahell]

Elxis currently support only MySQL and ProstgreSQL. msSQL is not supported. Please read the "supported databases" table in Elxis installation page (There is a link).
Your PHP version is too old, update at least to 4.4.x
Port 84? We have never tested Elxis in such a port...

[Dick]

Well, I decided to punt and try a clean install on a different machine: a Windows XP box with MySQL 5.0.51a-community-nt and PHP 5.2.5.  The permissions on my Elxis site allow Full Control (modify, read & execute, read, write, etc.) to Everyone, Administrators, Users, SYSTEM, Internet Guest Account and all subfolders inherit this protection.  (I know it's redundant but I'm frustrated.  :-(  The Web site is at port 80.

This time, after I fill out the Database page and hit Next I get an HTTP 500 error:

The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.

--------------------------------------------------------------------------------

Please try the following:

Open the localhost home page, and then look for links to the information you want.
Click the  Refresh button, or try again later.

Click  Search to look for information on the Internet.
You can also see a list of related sites.

-------------------

Any further ideas?   Thanks!  -Dick



HTTP 500 - Internal server error
Internet Explorer 

[datahell]

Check if the same happens with firefox too.
If yes, check your server error log. It is the only way to find out why this is happening.

It is not an Elxis issue, it is a server enviroment issue. Maybe also the problem is caused by a firewall/antivirus such as Zone Alarm.

[Ivan Trebješanin]

Have you created new database before you started installation? If you did, does it have utf8_general_ci collation?

[Dick]

Thank you all!

Yes, it also happens in Firefox.  Yes, I created the elxis database with the utf8 character set and utf8_general_ci_collation.   We're using McAfee, but I didn't notice any Firewall setting and almost all "threats" are set to Report, not Block.

The lines in my Web server log for this (brief) Elxis installation session are:

20:44:13 127.0.0.1 GET /Elxis/installation/index.php 200
20:44:16 127.0.0.1 POST /Elxis/installation/index.php 200
20:44:16 127.0.0.1 POST /Elxis/installation/index.php 200
20:44:20 127.0.0.1 POST /Elxis/installation/index.php 200
20:44:50 127.0.0.1 POST /Elxis/installation/index.php 500

I'm not sure if that's any help.

Thanks!  -Dick