Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 PHP & MySQL on win2k server
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

redbrad0
Advanced Member

USA
3725 Posts

Posted - 17 January 2005 :  13:23:24  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
I have just installed php and mysql and can not get it to connect. I figured it was a extension problem which I changed the php.ini file to load the mssql & mysql dll file. Now when you try to load a php it just sit's there and hangs until you get a CGI error that says "The specified CGI application exceeded the allowed time for processing. The server has deleted the process.". Anyone have any thoughts on this?

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets

Podge
Support Moderator

Ireland
3775 Posts

Posted - 17 January 2005 :  14:26:30  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
Its a while since I installed php but if you create a php file with the following code in it, it should let you know if those extensions have been loaded


<?php

// Show all information, defaults to INFO_ALL
phpinfo();

?> 


http://uk.php.net/phpinfo

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 17 January 2005 :  18:21:56  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
Well even if that is the only thing on the page the page will not load and gives the same error. Let me remove the MSSql & mySQL extensions one by one and see then if it will load.

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 17 January 2005 :  18:32:45  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
Ok I just took out of the php.ini the reference to all extensions and then now the page loads up fine. So for some reason there is a problem when trying to load up the extensions like it does not have access to it or can not find it..

I have the following...

; Directory in which the loadable extensions (modules) reside.
extension_dir = "c:\PHP\extensions"


Which the .dll file is located in that directory with everyone and IUSR having full permissions over the directory. Any ideas?

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page

Podge
Support Moderator

Ireland
3775 Posts

Posted - 17 January 2005 :  19:33:56  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
Yes. Use the php cgi installer with MySql support built in. I take it you manually installed the isapi version?

http://www.php.net/get/php-4.3.10-installer.exe/from/a/mirror

http://www.php.net/downloads.php

The PHP 5.0.3 cgi installer doesn't have any extension built in.

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 18 January 2005 :  03:35:25  Show Profile  Visit Gremlin's Homepage
You don't need to uncomment the mySQL extension at all it's compiled into the exe, just install myODBC and you should be GTG. I wouldn't personally touch any 5.x version on windows myself yet either.

Kiwihosting.Net - The Forum Hosting Specialists

Edited by - Gremlin on 18 January 2005 03:36:21
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 18 January 2005 :  23:31:24  Show Profile
I have v5 PHP and MySQL on a Media Center box for testing, and so far so good. I installed the isapi version following the instructions from the php and mysql websites. I'm using the MySQL Administrator and MySql Query Browser apps from MySQL.


======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 19 January 2005 :  05:55:38  Show Profile  Visit Gremlin's Homepage
There are a lot of commercial and freeware applications out there that have compatibility issues with PHP5.x many are still officialy saying it's unsupported, most basic stuff in PHP will be fine though.

Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 19 January 2005 :  20:00:04  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
Well I finally figured it out late last night by doing alot of googling. In the new version of PHP mySQL is not by default supported, you have to load the extension. I found out that I had to put libmysql.dll into the system32 directory and then it worked perfect.

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 19 January 2005 :  20:41:04  Show Profile  Visit Gremlin's Homepage
Podge did highlight that actualy :)
quote:
The PHP 5.0.3 cgi installer doesn't have any extension built in.
.. still I'd go with v4.3.10 personally :)

Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 19 January 2005 :  22:10:05  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
Well I did at first install v4 but had installed the brand new version of mySQL and after having many problems I found out that I had to upgrade PHP to support the new version of mySQL.

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 20 January 2005 :  05:10:39  Show Profile  Visit Gremlin's Homepage
I'm running latest mySQL and PHP 4.3.x with no real serious problems on development, mySQL does need a little tweaking though to get running. I'm not too sure 4.1 of mySQL is fully production ready yet though I've had a few issues with it on the test machine that plus some other quirks due to myODBC not fully supporting 4.1.

Kiwihosting.Net - The Forum Hosting Specialists

Edited by - Gremlin on 20 January 2005 05:12:25
Go to Top of Page

Podge
Support Moderator

Ireland
3775 Posts

Posted - 22 January 2005 :  11:59:17  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
Just came across this and remembered your post -

http://www.hostingtech.com/?m=show&id=608&page=4
http://www.hostingtech.com/?m=show&id=608&page=1

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07