Chaitanya,

Apache is not an option for us, and IIS is serving PHP without issue, so I 
would prefer to resolve my connectivity issue.

Thanks,
Adam

From: Chaitanya Yanamadala [mailto:dr.virus.in...@gmail.com]
Sent: Wednesday, December 23, 2009 10:17 AM
To: Adam Sonzogni
Cc: Edward Brookhouse; php-db@lists.php.net
Subject: Re: [PHP-DB] RE: Help for a beginner

why dont u install the xampp....
On Wed, Dec 23, 2009 at 8:38 PM, Adam Sonzogni 
<asonzo...@setfocus.com<mailto:asonzo...@setfocus.com>> wrote:
Mr. Brookhouse,

Thanks for the quick reply. I am guessing it is not relevant to my case because 
I am not using PERL. I cannot find anything that says PHP requires PERL so I 
suspect Iam ok in this regard.

Thank You,
Adam


-----Original Message-----
From: Edward Brookhouse 
[mailto:eb...@healthydirections.com<mailto:eb...@healthydirections.com>]
Sent: Wednesday, December 23, 2009 9:59 AM
To: Adam Sonzogni; php-db@lists.php.net<mailto:php-db@lists.php.net>
Subject: RE: Help for a beginner

Just a guess, as I have not tried a full stack in windows, but in any unix if 
you are connecting php and mysql, you need something in the middle like 
DBD::mysql

See if this helps: http://forums.mysql.com/read.php?51,189692,189856


-----Original Message-----
From: Adam Sonzogni 
[mailto:asonzo...@setfocus.com<mailto:asonzo...@setfocus.com>]
Sent: Wednesday, December 23, 2009 9:52 AM
To: php-db@lists.php.net<mailto:php-db@lists.php.net>
Subject: [PHP-DB] Help for a beginner

Hi everyone, first thank you for ALL help and the understanding that I am new 
to PHP and MySQL. This is a long email and for that I apologize but I am trying 
to provide as much detail as possible. If this is the wrong list to ask for 
help, kindly direct me to the proper authority.

I am trying to learn and I have built the following environment.

Windows Server 2008 Standard 32bit service Pack 2 with IIS7
mysql-essential-5.1.41-win32
php-5.3.1-nts-Win32-VC9-x86.msi
phpMyAdmin-3.2.4-english.zip


I followed the steps as detailed below (I already had IIS7 and CGI installed)


1. Install CGI & PHP
  http://www.trainsignaltraining.com/iis-7-install-fastcgi-php/2008-09-04/

2. Install MySQL
  http://www.trainsignaltraining.com/install-mysql-on-iis7/2008-09-10/

3. Install PHPMyAdmin
  
http://www.trainsignaltraining.com/install-phpmyadmin-on-iis7-and-server-2008/2008-09-16/


After I completed the installations
1. If I navigate to the PHP directory and type php -info it spews a ton of data 
at me
  AND
  I created info.php which contains:     <?php phpinfo(); ?>
  When I browse this, it correctly produces a page with all the info about my 
PHP server. Although I do not understand much of it I believe this confirms PHP 
is working correctly with IIS

2. I open the MySQL CLI and perform the commands outlined in Step 23 at this 
page
  http://www.bicubica.com/apache-php-mysql/index.php
  This returns the expected results, confirming MySQL is working

3. PHP is configured to work with php_mysql.dll as per the steps in the 
trainsignal links above so I begin!
I go to the phpmyadmin page, enter root and my password and after a long time I 
get a FastCGI error. I am not ready to believe it because, in classic MS form, 
it has several VERY different potential causes, and I have covered all of 
those. Plus the error code is 0x00000000 which is like saying nothing... I 
start thinking maybe it is not connecting to the mYSQL server right, the 
instructions re: pma and the password made no sense to me so I fiddle with that 
with no change.


  I  write the mysql_test.php page in step 5 of 
http://www.bicubica.com/apache-php-mysql/index.php
  This fails with: A connection attempt failed because the connected party did 
not properly respond after a period of time, or established connection failed 
because connected host has failed to respond.

  Because the PHP failed I try with ASP...
  <%
  set conn=Server.CreateObject("ADODB.Connection")
  conn.ConnectionString="Driver={mySQL};Server=localhost;Database=test;User 
Id=root;Password=youwish"
  conn.open
  Response.write("Connected")
  conn.close
  %>

  This returns:
      Microsoft OLE DB Provider for ODBC Drivers error '80004005'
      [Microsoft][ODBC Driver Manager] Data source name not found and no 
default driver specified
      /test.asp, line 4

I believe I have established MySQL is working, but for some reason it appears 
that it cannot be "reached" This IS on the same server so firewall should not 
be an issue, PLUS I confirmed the installer did create a hole. I turn off the 
MS firewall to be safe, no change.... I try a "repair" of MySQL, I uninstall, 
reboot and reinstall with no change.

NOTE: at several points I have tried iisreset and/or rebooting the system with 
no change.

I start to research the matter and my mind is now unglued. I found something 
referencing using mcrypt with PHPMyAdmin to speed it up and wondered if maybe 
the long delay before the FastCGI error could be resolved so I tracked down the 
dll, put it in my ext directory and changed my php.ini to reflect this -- file 
found at http://files.edin.dk/php/win32/mcrypt/

I found quite a bit about using libmysql.dll but there was no such file in my 
install, I pulled down the .zip package and that also did not contain it, I 
eventually found it in a 5.2.x archive but that does not seem to have helped. I 
have tried enabling: only mysql, mysql AND mysqli, and only mysqli. None of 
this seems to have done anything to change my situation.

Again, I apologize for the lengthy message, I hope I have accurately described 
my issue in the right amount of detail.

Thank You!
Adam Sonzogni






--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php





--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



--
Chaitanya

Reply via email to