Go Back   Hardware Canucks > SOFTWARE > O/S's, Drivers & General Software

    
Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old March 26, 2010, 12:57 PM
odis172's Avatar
Allstar
F@H
 
Join Date: Oct 2008
Location: Ottawa, ON
Posts: 683

My System Specs

Default Any mysql experts in the house?

Im installing mantis bugtracker, which requires mysql,php and iis or apache.

Im using the following:
mysql essentials 5.1.45 -x86
php-5.3.2 x86
and IIS 7

The OS is server 2008 standard 64

The main problem is that the mantis install, I cant connect to mysql.

If during mantis configuration, I use "database type" of mysql - i get the error: Attempting to connect to database as admin - Does administrator user have access to database? (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because the connected host has failed to respond.)

If I use mysqli i get an "internal server error" 500.0 php-cgi - the fastcgi process exited unexpectedly

I have set IIS to run in 32bit mode, through the application pool.

If I run the following php script to access mysql then i get "Could not connect to mysql server - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because the connected host has failed to respond"
<?php
// Establish a connection and select a database
$link = mysql_connect('localhost', 'phptest', 'phptest')
or die('Could not connect to the MySQL Server: ' . mysql_error());
mysql_select_db('mysql') or die('Could not Select the Database.<br><br>
The error returned by MySQL was: <br>' . mysql_error());
// Close the connection
mysql_close($link);
?>

This leads me to believe that mantis is not the problem, but php and mysql arent communicating.

In the php.ini file, I have activated the mysql and mysqli extensions.
And mysql is installed as a service in windows, and is running.
I suspect I may have to do something in mysql to allow it to accept connections.
Also in all of the programs respective directories, and the wwwroot I have enabled full control for IIS_user, network service and Users

Any ideas?
__________________
Laptop: Lenovo T420 - Core i5 2520 - 8GB DDR3
Server: 2 xeon E5530 - Asus Z8N-D6 - 12GB DDR3 - 8x 500GB raid 50 - Perc 6/i - Compucase RA448A00
Reply With Quote
  #2 (permalink)  
Old March 26, 2010, 01:30 PM
enaberif's Avatar
Hall Of Fame
 
Join Date: Dec 2006
Location: Calgahree, AB
Posts: 10,604
Default

Use this -> apache friends - xampp

IIS is horrible and garbage.
Reply With Quote
  #3 (permalink)  
Old March 26, 2010, 01:52 PM
odis172's Avatar
Allstar
F@H
 
Join Date: Oct 2008
Location: Ottawa, ON
Posts: 683

My System Specs

Default

After a week of playing around with this, and countless hours of googling, i probably should :P
Do I have to uninstall the IIS role, or can it coexist?
__________________
Laptop: Lenovo T420 - Core i5 2520 - 8GB DDR3
Server: 2 xeon E5530 - Asus Z8N-D6 - 12GB DDR3 - 8x 500GB raid 50 - Perc 6/i - Compucase RA448A00
Reply With Quote
  #4 (permalink)  
Old March 26, 2010, 01:56 PM
enaberif's Avatar
Hall Of Fame
 
Join Date: Dec 2006
Location: Calgahree, AB
Posts: 10,604
Default

Quote:
Originally Posted by odis172 View Post
After a week of playing around with this, and countless hours of googling, i probably should :P
Do I have to uninstall the IIS role, or can it coexist?
Should be able to co-exist.

But if IIS is setup to be a system service you'll have to disable it.
Reply With Quote
  #5 (permalink)  
Old March 26, 2010, 04:44 PM
m1dget's Avatar
Allstar
 
Join Date: Nov 2008
Location: Terrebonne, Qc
Posts: 707

My System Specs

Default

Quote:
Originally Posted by enaberif View Post
IIS is horrible and garbage.
I'm glad seeing that... for all the times I got in conversation about IIS being shit with all the microsoft fans I know that swears only by Windows server and all its bells and whistles
__________________
"NIX is a classic example of security through obscurity because there is no real monetary reward for crackers and hackers to break Linix" -AkG
Reply With Quote
  #6 (permalink)  
Old March 26, 2010, 05:09 PM
enaberif's Avatar
Hall Of Fame
 
Join Date: Dec 2006
Location: Calgahree, AB
Posts: 10,604
Default

Quote:
Originally Posted by m1dget View Post
I'm glad seeing that... for all the times I got in conversation about IIS being shit with all the microsoft fans I know that swears only by Windows server and all its bells and whistles
Only thing Windows is good at SEMI doing is Active Directory.

Otherwise for a server for things like mail and web and etc a *nix server is the only way.
Reply With Quote
  #7 (permalink)  
Old March 26, 2010, 05:44 PM
BigDogg's Avatar
Top Prospect
 
Join Date: Jan 2010
Location: Kitchener/Waterloo
Posts: 187

My System Specs

Default

Quote:
Originally Posted by odis172 View Post
Im installing mantis bugtracker, which requires mysql,php and iis or apache.

Im using the following:
mysql essentials 5.1.45 -x86
php-5.3.2 x86
and IIS 7

The OS is server 2008 standard 64

The main problem is that the mantis install, I cant connect to mysql.

If during mantis configuration, I use "database type" of mysql - i get the error: Attempting to connect to database as admin - Does administrator user have access to database? (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because the connected host has failed to respond.)

If I use mysqli i get an "internal server error" 500.0 php-cgi - the fastcgi process exited unexpectedly

I have set IIS to run in 32bit mode, through the application pool.

If I run the following php script to access mysql then i get "Could not connect to mysql server - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because the connected host has failed to respond"
<?php
// Establish a connection and select a database
$link = mysql_connect('localhost', 'phptest', 'phptest')
or die('Could not connect to the MySQL Server: ' . mysql_error());
mysql_select_db('mysql') or die('Could not Select the Database.<br><br>
The error returned by MySQL was: <br>' . mysql_error());
// Close the connection
mysql_close($link);
?>

This leads me to believe that mantis is not the problem, but php and mysql arent communicating.

In the php.ini file, I have activated the mysql and mysqli extensions.
And mysql is installed as a service in windows, and is running.
I suspect I may have to do something in mysql to allow it to accept connections.
Also in all of the programs respective directories, and the wwwroot I have enabled full control for IIS_user, network service and Users

Any ideas?
Where is your PHP.ini file located? Make sure you have it in the C:\Windows folder. It needs to be in that folder for it to properly run. Have you also setup your windows Path Environment variable to have C:\PHP incluided? Do both of those and see if it works after that. You may have to copy a few of the php mysql DLL's to the c:\windows\system32 folder if the above does not work.

It looks like it is either your MySql server is not running or PHP is not able to properly connect to it.

Even better it looks like your using IIS7. Did you check out the Web platform installer? Is that how you installed PHP & MySql?

Use the Microsoft Web Platform Installer : Web Platform Installer : Microsoft Web Platform : The Official Microsoft IIS Site Check this out Might help make things easier.

Can you access MySql through its command line?
Reply With Quote
  #8 (permalink)  
Old March 26, 2010, 07:52 PM
odis172's Avatar
Allstar
F@H
 
Join Date: Oct 2008
Location: Ottawa, ON
Posts: 683

My System Specs

Default

oh em ge. Your a F****** genious. Ive never heard of "microsoft web platform installer" But it worked like a charm. I removed the mess I had made, and it installed php and mysql, which immediately worked. From there I had mantis and myphpadmin going no problem. Thanks so much!

enaberif, I would have went your route next, but I actually should get myself familiar with the workings of IIS, as substandard as it may be.
__________________
Laptop: Lenovo T420 - Core i5 2520 - 8GB DDR3
Server: 2 xeon E5530 - Asus Z8N-D6 - 12GB DDR3 - 8x 500GB raid 50 - Perc 6/i - Compucase RA448A00
Reply With Quote
  #9 (permalink)  
Old March 26, 2010, 08:03 PM
BigDogg's Avatar
Top Prospect
 
Join Date: Jan 2010
Location: Kitchener/Waterloo
Posts: 187

My System Specs

Default

Quote:
Originally Posted by odis172 View Post
oh em ge. Your a F****** genious. Ive never heard of "microsoft web platform installer" But it worked like a charm. I removed the mess I had made, and it installed php and mysql, which immediately worked. From there I had mantis and myphpadmin going no problem. Thanks so much!

enaberif, I would have went your route next, but I actually should get myself familiar with the workings of IIS, as substandard as it may be.
IIS7 is not substandard by any means. Its actually quite powerful, has good performance and strong security. I really enjoy working with it but I am comfortable with IIS6 which isn't near as polished. Glad that worked, I installed Wordpress on my Windows 7 box using that and couldn't believe how easy it was.
Reply With Quote
Reply


Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
House Robbed redwagon Off Topic 23 September 25, 2009 06:03 PM
Need advice from TV experts. Nodscene Display Units 4 August 27, 2009 08:47 PM
So... I might want to go back to school. Any machinsts / aviation experts here? S_G Off Topic 25 January 29, 2009 12:20 AM
Here's one for the RAM experts... dadzilla RAM 8 November 24, 2008 06:59 PM
my new house ebdoradz Off Topic 22 May 10, 2008 09:11 PM