VB3 and IIS6 install permissions error on step 2

[DthStlkr13]

Is this on dedicated or shared virual server. If shared, how many sites share this server (ask web host if needed)

This server is dedicated to one specific site.

server specs.

cpu speed/type single or dual cpus): Single AMD Athlon 1.6ghz
how much memory installed: 512mb Registered ram
hard drive type/configuration: 40GB EIDE non raid 7200RPM
linux distributor or windows version: Windows Server 2003 Enterprise Edition
apache/IIS version: IIS 6
PHP version: php 4.3.10
MySQL version: MySQL 4.1.10
*Also MySQL Admin v1.0.19

Here is my php info file: http://www.landscapershelper.com/info.php

I have used and installed older versions of vbulletin on Windows 2000 machines running IIS4 with no problems whatsoever. I have decided to start a new website, and ordered a server for it. My specs are listed above. The new server is using Windows Server 2003 with IIS 6. Most of the problems I have run into so far have been located in IIS 6. I finally have PHP and MySQL recognizing each other, and can get to the install screen for vBulletin.

I am able to pass the customer info, get past the welcome screen, verify config file is readable, and then I get an error on step 2:

The database has failed to connect because you do not have permission to connect to the server. Please confirm the values entered in the 'includes/config.php' file.

Now, I have spent the past couple of hours searching the forums here and have seen several posts in reference to this error, most of which end up with a generic reply stating that "the script is exactly as it reads" and/or "the problem is with your username/password" etc.

I have checked, double checked, triple checked, infinity... the username and password I am using are correct and does have full access in MySQL Admin to the database I created in MySQL. I have tried both a username I created, as well as the root username. I have also tried both the localhost and the actual server name of WINSERV3. None of the variations are working. I have also enabled the 'everyone' and 'IUSR_WINSERV3' usergroups with full permissions on all files/subfiles of the website root directory, the php folder, and the mysql folder. I also disabled the firewall to make sure that wasn't interfering with anything. On a further attempt, I also allowed all unknown CGI and ISAPI on the server. I have also made sure to stop and restart both IIS and MySQL after each modification.

None of this has worked, and in all honesty, I don't think the problem has anything to do with the config.php file. I think it has to do with IIS permissions/settings. Does anyone have any other suggestions or have an actual answer as to what I can do to fix this?? I'm actually on a time line as I'm working with Rentacoder.com to have the rest of my site developed. It's all waiting for me to get vbulletin installed for the database to be linked together.

Personally, I have a feeling that something needs to be changed/added in the Web Service Extensions portion of IIS.... but may be way off. :(

PLEASE PLEASE PLEASE PLEASE HELP ME.....

[DthStlkr13]

Follow-up Post....

I found the test script on the vBulletin main section. It is showing the following:

PHP 4.3.10 Pass
MySQL Fail
PCRE Pass
magic_quotes_sybase Pass
XML Pass
MySQL Permission Requirements
create Fail
alter Fail
insert Fail
update Fail
select Fail
delete Fail
drop Fail
Recommended Settings
open_basedir Pass
safe_mode Pass
GZIP Pass
magic_quotes_runtime Pass
magic_quotes_gpc Pass
GD Fail
----------------------------------
I recieved the same results on both my created username and the default root username. MySQL is listed in the Component Services and starts automatically. I notice that it says fail for MySQL in the vbulletin script... any suggestions?

[Steve Machol]

MySQL Fail

Your PHP is not compiled with MySQL support. You need to install PHP with thisw support.

[DthStlkr13]

MySQL Fail

Your PHP is not compiled with MySQL support. You need to install PHP with thisw support.

That version of PHP states in the php.ini: "NOTE that MySQL and ODBC support is now built in, so no dll is needed for it."

There is no extension to uncomment... or are you referring to something else?

Thanks for getting back to me!

Note: This is the version I downloaded - PHP 4.3.10 zip package [7,405Kb] - 15 Dec 2004
(CGI binary plus server API versions for Apache, Apache2 (experimental), ISAPI, NSAPI, Servlet and Pi3Web. MySQL support built-in, many extensions included, packaged as zip)
md5: 0bb30525512ea686abf22c8fe61e1bb6

Maybe it's something to do with IIS6 needing to allow MySQL as part of the php extensions? :confused:

[AWS]

MySQL 4.1.10
Make sure in my.ini you have use old passwords turned on. If that doesn't work roll back mysql to 4.0.23.
See http://dev.mysql.com/doc/mysql/en/old-client.html.

[DthStlkr13]

Make sure in my.ini you have use old passwords turned on. If that doesn't work roll back mysql to 4.0.23.
See http://dev.mysql.com/doc/mysql/en/old-client.html.

I tried 'use old passwords' and also added the my.ini file to the permitted files for .php extensions in IIS6.

It appears that MySQL is functional as when I attempt to access the forums directory, I recieve the standard MySQL error:

There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.
-------------

Do you still think I should uninstall 4.1 and use 4.0? That means I also have to uninstall the MySQL admin v1.0.19 as it only works with 4.1 and higher. Grr!!

[Steve Machol]

We need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.

[DthStlkr13]

We need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.

Hey guys... I GOT IT!!!

It actually WAS the old password setting, however, you need to take an additional step to correct it.

I'm not sure if you need to stop and restart MySQL twice or not, but it wouldn't hurt... so here is what I did...

1) Used MySQL Admin v1.0.19 and changed the settings in Startup Variables --> Security --> Check mark the box titled 'Use Old Passwords'
2) Under Service Control --> Start/Stop Service --> Click on the Stop Service Button
3) After Service stops, restart
4) Under User Administration --> Click on an account and change/confim password --> Click Apply Changes (repeat for each account listed)
5) Under Service Control --> Start/Stop Service --> Click on the Stop Service Button
6) After Service stops, restart

NOTE: You MUST reset the password after you tell it to 'Use Old Passwords' or it will not work!!!


It should not be necessary to restart IIS6 after doing this. You should now be able to install vBulletin without any problems, and the vb_test script should pass on all levels.

After I get things done, I will work on a complete info section to put everything together. IIS6 really screws with your head on getting this stuff configured. :o

Thanks for all that contributed with the suggestions and the efforts!! Once I got the walk through done, I'll post a link to it and can copy it into a thread for the admins to post/lock to help others... of course it should be in the private area for paid members. :p