Newbie trouble on Windows 2003 Server

[cada0310]

Hi all,

Been wrestling with MySQL/PHP/Coppermine for a couple days off and on, and things look like they're almost working.  I can get the install.php page to come up without any errors.  I fill in my data, hit "Lets Go!" and....

...it brings me right back to that page with all the data I've entered cleared out.  No errors...no nothing.

Any ideas?

Thanks!

Chris

[kegobeer]

Have you looked around on the forum, done any searches?

Sounds like you still haven't properly configured your server, php, or mysql.  Posting your versions will help us determine what you should do.

[cada0310]

Hi, thanks for your reply.

I've done searches and read quite a few KB articles and posts.  I've been through the installation and configuration a couple times in the course of all this, and I've seen error messages when I had the password wrong, or the wrong version of the client software for MySQL - I thought it odd that there was no message at all...

I've downloaded and installed Coppermine 1.3.2, MySQL 4.1, PHP 5.03 (after getting failure to connect messages with MySQL and PHP 4 and troubleshooting that from the 'net).  I'm running IIS 6 (Windows 2003 Server).

Thanks.

[kegobeer]

Do you have register_long_arrays enabled in php.ini?

[cada0310]

Yeah, tried that.  I have this line:

register_long_arrays = on

In my php.ini file.  I've also messed with permissions/properties of the website to make sure there's write access to include and albums, to no avail.

I can use the MySQL Administrator without issue, and I use the same login that I used with that for Coppermine.

[kegobeer]

Have you reviewed your logs to see if there are any error messages?

Did you install PHP manually or did you use the installer?  If manually, did you follow the instructions at www.php.net?  And did you also do these steps?

• add the location of your php dlls to the Path environmental variable?
• add the location of php to the PHPRC environmental variable?

If you used the installer, uninstall it and do the manual installation.  Nothing good can come from the automated install. 

Did you configure your website to allow Anonymous Internet Access (the xxx_IUSR account)?  Not just via the IIS snap-in, but also on the directories for your site?

You should also write a simple php file that tests your MySQL connection.  I recently posted such a test script, you can find it by clicking on my profile and looking at my last posts.  You may have to go back a few posts, but it's there.  I'd post the link but I don't remember where it is exactly.

You should also download phpMyAdmin and use it to administer your MySQL databases.  It's web-based and very easy to use.  Also a good indicator if your PHP/MySQL setup is working correctly.

[cada0310]

Got success right around 1am last night.  Trying to get the PHP SQL Admin working was a good tip, and, though I can't remember everything I did in my sleepy haze, I believe the final solution was getting the PHP.INI file configured properly and enabling the extensions within it.  Also, moving the DLLs for mysql and gd2 into the folder specified in the extensions_dir.

So far, everything's working great, and I'm uploading my 10 billion photos into my database.

Thanks again.

[kegobeer]

Glad you got it sorted.  Remember, use batch add!  As the admin, you don't need to limit yourself to 5 uploads at a time.