step 5 installation cannot set up database

andrewcpy

Joined: 2010-10-25
Posts: 18
Posted: Fri, 2010-11-19 10:04

how to deal with this! problem ?
system info
php 5.2.14
mysql 3.23.41nt
server 2003
IIS
is that i need to connect database to php by myself ?
or other thing else ?

Thanks

AttachmentSize
1.JPG26.25 KB
 
andrewcpy

Joined: 2010-10-25
Posts: 18
Posted: Fri, 2010-11-19 10:05

I also cannot select reuse database ? where is it ?
Thanks

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Fri, 2010-11-19 14:11

You'r using relatively new PHP, new(er) version of windows server and yet you're using a version of MySQL that's been dead for years:
http://www.mysql.com/about/legal/lifecycle/#calendar

Also see the note at the end of this page:
http://dev.mysql.com/doc/refman/4.1/en/

The docs may not even be around after the end of this year....

oh, ok, I guess 3.x is listed as usable here:
http://codex.gallery2.org/Gallery2:Installation_Requirements#Database

...

But at least part of the problem is that PHP doesn't know MySQL even exists. See the big red note on the screenshot you posted. Make sure you're following the instructions here:
http://codex.gallery2.org/Gallery2:Installation_Requirements#IIS

Reuse a DB? Why? Are you moving Gallery from one server to another? Is this a shared host or something you have full control over the server on?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
andrewcpy

Joined: 2010-10-25
Posts: 18
Posted: Fri, 2010-11-19 15:56

recently i found that i cannot use gallery2 in my web server build 12 years ago, and it runs on winnt with IIS4 and so it does not support mysql of newer version,
see http://gallery.menalto.com/node/98759, and so I use another server instead, which runs on server 2003, and so I installed PHP 5.2.14 instead, and I afraid the database will affected, so I install mysql 3.23.41 as orginal, after installing IIS6, mysql and PHP, I downloaded gallery2.3.1 and want to fresh install the program and reuse original database, (gallery2 is 2.2.2 in old server), then I go to /localhost/gallery2/install/index.php, it works, and i do think it can be installed. and when go to step 5 , problem comes.

actually I have gallery2 dir under the web server dir, and I copied gallery2datasets (album dir) at the parent dir of web file

1. should I rebuild database in mysql again ? "create database gallery2datasets" ? and should I copy the "old" dir gallery2datasets to this server without change anything ?
2. Should I connect php to mysql by myself ? or they can connect in gallery2 ?
3 or should i upgrade the mysql to 5.x ? will it affect the original datasets ?
actually i followed the guide step by step is there any tailored procedure for me in this case ?

what i want to do is install gallery 2.3.1 using original datasets.

thanks

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Fri, 2010-11-19 16:12

http://www.google.com/search?q=php+mysql+module+iis

PHP Cannot see MySQL

There is this procedure, but first you must have a working configuration. Right now it appears PHP cannot see or connect to MySQL, so that right now is the problem.

FAQ: How can I move my gallery installation from one server to another?

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
andrewcpy

Joined: 2010-10-25
Posts: 18
Posted: Fri, 2010-11-19 16:18

will this help ? phpinfo()

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Fri, 2010-11-19 16:29

A link would be better. That is a screenshot of only the top part of that page. There are about 20 more pages of info :)
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
andrewcpy

Joined: 2010-10-25
Posts: 18
Posted: Fri, 2010-11-19 16:32
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Fri, 2010-11-19 16:41

Yeah, there's no MySQL extensions loaded. See this tutorial:
http://www.ozzu.com/programming-forum/tutorial-how-install-php-and-mysql-iis-t56303.html
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here