Database Setup

dakotan

Joined: 2005-06-26
Posts: 5

Posted: Mon, 2005-06-27 03:20

Hello-

I am stuck at "database setup"

the error message:

You must have the MySQL PHP module installed

I already add the database and make some change on php.ini and none of them are working.

I could not find anything regards on this. Could you help.

THanks

----

Gallery URL (optional): not ready
Gallery version: G2
Webserver (with version): IIS 5.1
Datatabase (with version): MYSQL 4.1
PHP version (eg 4.2.1): PHP 5.0.4
phpinfo URL (optional): not ready
Graphics Toolkit(s): ImageMagic
Operating system: Windows XP PRO
Web browser/version: IE 6.0
G1 version (for migration bugs) N/A:

itcheg

Joined: 2003-11-30
Posts: 87

Posted: Mon, 2005-06-27 03:54

this is not a gallery problem, you need to have a database properly setup and you have to put the proper info in, so gallery can find it. Perhaps post you phpinfo. (put <?php phpinfo(); ?>
into a text file, save the file as phpinfo.php and put it it on you site and post a link).

dakotan

Joined: 2005-06-26
Posts: 5

Posted: Mon, 2005-06-27 04:39

Here the php information.

http://69.9.241.166/phpinfo().html

Let me know for any adjustment..

itcheg

Joined: 2003-11-30
Posts: 87

Posted: Mon, 2005-06-27 06:25

dakotan, your phpinfo says that you don't have MYSQL module installed. In php5 the mysql dll files are not enabled by default, so you'll need to add those, see http://no.php.net/mysql for more info.

dakotan

Joined: 2005-06-26
Posts: 5

Posted: Mon, 2005-06-27 13:55

Umm--

I did that one in the php.ini an check the attachment.

let me know if I did right thing...

valiant

Joined: 2003-01-04
Posts: 32509

Posted: Mon, 2005-06-27 14:10

no that's not it.
as itcheg said:
http://no.php.net/mysql

find something like ; extension=msql.dll in your php.ini and remove the leading ;
then restart the webserver.

dakotan

Joined: 2005-06-26
Posts: 5

Posted: Mon, 2005-06-27 23:13

I removed the ;

when I submit the setup 5 (datebase) and took long time to loading before I got the error

"CGI Timeout
The specified CGI application exceeded the allowed time for processing. The server has deleted the process"

oh boy... what is next?

valiant

Joined: 2003-01-04
Posts: 32509

Posted: Mon, 2005-06-27 23:18

in php.ini, set max_execution_time to something large, e.g. 300
then restart the webserver
make sure you empty g2data and delete all database tables before you try again.

dakotan Joined: 2005-06-26 Posts: 5	Posted: Mon, 2005-06-27 03:20
	Hello- I am stuck at "database setup" the error message: You must have the MySQL PHP module installed I already add the database and make some change on php.ini and none of them are working. I could not find anything regards on this. Could you help. THanks ---- Gallery URL (optional): not ready Gallery version: G2 Webserver (with version): IIS 5.1 Datatabase (with version): MYSQL 4.1 PHP version (eg 4.2.1): PHP 5.0.4 phpinfo URL (optional): not ready Graphics Toolkit(s): ImageMagic Operating system: Windows XP PRO Web browser/version: IE 6.0 G1 version (for migration bugs) N/A:
	XUser login Username: * Password: * Create new account Request new password
itcheg Joined: 2003-11-30 Posts: 87	Posted: Mon, 2005-06-27 03:54
	this is not a gallery problem, you need to have a database properly setup and you have to put the proper info in, so gallery can find it. Perhaps post you phpinfo. (put `<?php phpinfo(); ?>` into a text file, save the file as phpinfo.php and put it it on you site and post a link).

dakotan Joined: 2005-06-26 Posts: 5	Posted: Mon, 2005-06-27 04:39
	Here the php information. http://69.9.241.166/phpinfo().html Let me know for any adjustment..

itcheg Joined: 2003-11-30 Posts: 87	Posted: Mon, 2005-06-27 06:25
	dakotan, your phpinfo says that you don't have MYSQL module installed. In php5 the mysql dll files are not enabled by default, so you'll need to add those, see http://no.php.net/mysql for more info.

dakotan Joined: 2005-06-26 Posts: 5	Posted: Mon, 2005-06-27 13:55
	Umm-- I did that one in the php.ini an check the attachment. let me know if I did right thing...

valiant Joined: 2003-01-04 Posts: 32509	Posted: Mon, 2005-06-27 14:10
	no that's not it. as itcheg said: http://no.php.net/mysql find something like ; extension=msql.dll in your php.ini and remove the leading ; then restart the webserver.

dakotan Joined: 2005-06-26 Posts: 5	Posted: Mon, 2005-06-27 23:13
	I removed the ; when I submit the setup 5 (datebase) and took long time to loading before I got the error "CGI Timeout The specified CGI application exceeded the allowed time for processing. The server has deleted the process" oh boy... what is next?

valiant Joined: 2003-01-04 Posts: 32509	Posted: Mon, 2005-06-27 23:18
	in php.ini, set max_execution_time to something large, e.g. 300 then restart the webserver make sure you empty g2data and delete all database tables before you try again.

XUser login