#83 Install Script (Step 4 Database Settings) Internal Server Error

[Anonymous]

Hi,

I run the install script and it works fine, but if I go to the Database settings (Step: 4/10) and enter the correct credentials, I get a blank site (Firebug says 500 Internal Server Error).

I entered the following code:
GRANT ALL PRIVILEGES ON unattended TO 'dbconnector'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

Same problem with the user root. Problems with user rights?

Cheers
Claudio

[Mario Gzuk]

Hi Claudio,
you should also take a look into the server log files. Is this possible? In this step the tables will be created by the script. This needs a lot of memory, so mostly the error is because there is not enough memory for php. Which webserver version and wich php version are you running?

Alternativ you can do:
1.) create an info.php file on the webserver with:
<?php
phpinfo();
?>
2.) open the file with the browser, e.g. http://yourhostname/info.php
3.) send me the output (best would be directly)

Cheers Mario

[Claudio]

Hi Mario,

I send you an eMail with the output.

Cheers Claudio

[Mario Gzuk]

Hi,
please (re)set the following in /etc/php.ini:
max_execution_time = 180
max_input_time = 600
memory_limit = 1024M
and restart the webserver. After that the installation will be hopfully goning on ;)

[Claudio]

Hi,
I tried the solution but the problem is still present. I also tried a full server restart.

I found a log entry /var/log/httpd/error_log.
[Tue Mar 25 14:31:10 2014] [error] [client 192.168.178.6] PHP Fatal error: Call to a member function getMessage() on a non-object in /var/www/uranos/www/install/functions.php on line 246, referer: http://192.168.178.79/uranos/www/install.php?PHPSESSID=eocn6a8vl8ru5ima08gp3rghu2&step=4&status=40

[Mario Gzuk]

Ah, this is a connection problem. Can you try to connect with an other client, e.g.:
mysql -h localhost -u dbconnector unattended

Cheers

[Claudio]

Are you sure? Because the command works with additional -p.
mysql -h localhost -u dbconnector unattended -p

I already tried with user 'root'@'%' and the same problem appears.

Cheers
Claudio

[Mario Gzuk]

Hi,
please only use the username, not the string: username@% (or username@localhost or whatever).
Take a look here:
http://uranos.sourceforge.net/www/index.php?loadsub=quwiki&func=documentation&type=index#2.2.2.4.5.

The @HOSTNAME is only used for the mysql command:
German:
https://dev.mysql.com/doc/refman/5.1/de/create-user.html
English:
https://dev.mysql.com/doc/refman/5.1/en/create-user.html

Cheers

[Claudio]

Hi Mario,

yes I know it. I only want you to show the access of user root. Of course, I entered the username without the hostname.

[Wed Mar 26 15:25:03 2014] [error] [client 192.168.178.6] PHP Fatal error: Call to a member function getMessage() on a non-object in /var/www/uranos/www/install/functions.php on line 246, referer: http://10.242.44.79/uranos/www/install.php?PHPSESSID=uj4gn9ma2im2vgat4gsbodagq5&step=4&status=40

The problem is still present with the same error. Any ideas?

Cheers

[Mario Gzuk]

The DB is running on the same host like the webserver?
So this is working:
mysql -udbconnector -psome_pass -h localhost unattended

and if you make this settings in the step 4:
DB hostname: localhost
DB user: dbconnector
DB password: some_pass
DB name: unattended
DB type: mysql

You ran into this error.

Can you please post the output from:

>pear list

so that I can see which pear modules you have installed?

Thank you.

[Claudio]

Hi,

yes, DB and webserver are on the same server.

INSTALLED PACKAGES, CHANNEL PEAR.PHP.NET:

PACKAGE VERSION STATE

Archive_Tar 1.3.7 stable
Console_Getopt 1.2.3 stable
HTML_Template_Sigma 1.3.0 stable
HTTP 1.4.1 stable
HTTP_Download 1.1.4 stable
HTTP_Header 1.2.1 stable
MDB2 2.5.0b5 beta
PEAR 1.9.4 stable
Structures_Graph 1.0.4 stable
XML_RPC 1.5.4 stable
XML_Util 1.2.1 stable

Thanks for your help.

Cheers

[Mario Gzuk]

So there is the error,
you need also the DB Driver:

pear install MDB2_Driver_mysql

I will close the BUG. If you have questions feel free to contact me
directly, you can find my mail address on the project webpage.

Cheers Mario

Am 26.03.2014 16:02, schrieb Claudio:

Hi,

yes, DB and webserver are on the same server.

INSTALLED PACKAGES, CHANNEL PEAR.PHP.NET:

PACKAGE VERSION STATE

Archive_Tar 1.3.7 stable
Console_Getopt 1.2.3 stable
HTML_Template_Sigma 1.3.0 stable
HTTP 1.4.1 stable
HTTP_Download 1.1.4 stable
HTTP_Header 1.2.1 stable
MDB2 2.5.0b5 beta
PEAR 1.9.4 stable
Structures_Graph 1.0.4 stable
XML_RPC 1.5.4 stable
XML_Util 1.2.1 stable

Thanks for your help.

Cheers

---

[bugs:#83] http://sourceforge.net/p/uranos/bugs/83/ Install Script
(Step 4 Database Settings) Internal Server Error

Status: accepted
Group: v1.0 (example)
Labels: Internal Server Error Database Settings Database
Created: Mon Mar 24, 2014 04:24 PM UTC by Anonymous
Last Updated: Wed Mar 26, 2014 02:19 PM UTC
Owner: Mario Gzuk

Hi,

I run the install script and it works fine, but if I go to the Database
settings (Step: 4/10) and enter the correct credentials, I get a blank
site (Firebug says 500 Internal Server Error).

I entered the following code:
GRANT ALL PRIVILEGES ON unattended TO 'dbconnector'@'localhost'
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

Same problem with the user root. Problems with user rights?

Cheers
Claudio

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/uranos/bugs/83/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

[Mario Gzuk]

So there is the error,
you need also the DB Driver:

pear install MDB2_Driver_mysql

I will close the BUG. If you have questions feel free to contact me
directly, you can find my mail address on the project webpage.

Cheers Mario