I am glad that it worked for you. I knew that there was information out
there for configuring PHP under IIS. I just wasn't sure if it was on MYSQL
or PHP's site.  You can go ahead and make a check out to my name for the
amount you were willing to pay to get this resolved..  Just email me
privately for my address :-)..




On Wed, Dec 23, 2009 at 11:24 AM, Adam Sonzogni <asonzo...@setfocus.com>wrote:

> Barry,
>
> You sir saved the day, the very last item on that page was the ticket, I
> disabled IPV6 but never thought to removed the localhost entry for ipv6 in
> hosts...
>
> That said I google'd dozens of times with a variety of keyword combinations
> all including iis7 and PHP,  and not once did that page pop up :(
>
>
>
> The default installation of Windows Vista, Windows 7 and Windows Server
> 2008 adds a line to the Windows/System32/drivers/etc/hosts which causes
> network functions (database connect functions too, like mysql_connect) to
> timeout when connecting to "localhost".  To resolve this problem, remove the
> entry from the hosts file:
> ::1             localhost
>
> or connect using the IP address, 127.0.0.1 or another domain name.
>
> This behavior change is due to IPv6 being enabled by default in Vista or
> other recent Windows version.
>
>
>
>
> From: Barry Stear [mailto:bst...@gmail.com]
> Sent: Wednesday, December 23, 2009 1:54 PM
> To: Adam Sonzogni; PHP DB Posts
> Subject: Re: [PHP-DB] RE: Help for a beginner
>
> I apologize I do see that you tried using phpmyadmin and received the
> FastCGI error.
>
> This might help you :
> http://www.php.net/manual/en/install.windows.iis7.php   . Let me know what
> happens after you try those steps.. I am hoping for the best..
>
>
> On Wed, Dec 23, 2009 at 9:21 AM, Adam Sonzogni <asonzo...@setfocus.com
> <mailto:asonzo...@setfocus.com>> wrote:
> If you read the thread I useda php page totest mysql connectivity after
> phpmyadmin did not work...
>
> At this point I am willing to pay someone to troubleshoot this as I am
> baffled there is no definitive troubleshooting documentation for Windows
> installs.
>
>
> From: Barry Stear [mailto:bst...@gmail.com<mailto:bst...@gmail.com>]
> Sent: Wednesday, December 23, 2009 12:04 PM
> To: Adam Sonzogni
> Cc: PHP DB Posts
>
> Subject: Re: [PHP-DB] RE: Help for a beginner
>
> Well I am not familiar with ASP.  You might want to check to make sure that
> you didn't make any typos in your mysql_test.php page. I would suggest
> seeing if you can connect through phpMyAdmin. That might give you a better
> idea of where the problem lies.
> On Wed, Dec 23, 2009 at 8:31 AM, Adam Sonzogni <asonzo...@setfocus.com
> <mailto:asonzo...@setfocus.com>> wrote:
> Barry,
>
> Yes this is all installed ona single system.
>
> The code was in the original message
>
>  <%
>  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
>  %>
>
> So line 4 is:       conn.open
>
>
> Thanks,
> Adam
>
> -----Original Message-----
> From: Barry Stear [mailto:bst...@gmail.com<mailto:bst...@gmail.com>]
> Sent: Wednesday, December 23, 2009 11:28 AM
> To: PHP DB Posts
> Subject: Re: [PHP-DB] RE: Help for a beginner
>
> Adam,
>
> What is at Line 4 in your test.asp? The error you provided said that there
> was a problem where it could not find the default driver to use.
>
> Also when you get the connection failed you were trying to connect to MYSQL
> from the system running MYSQL correct?
>
> On Wed, Dec 23, 2009 at 7:50 AM, Adam Sonzogni <asonzo...@setfocus.com
> <mailto:asonzo...@setfocus.com>>wrote:
>
> > Giff,
> >
> > Not sure what you mean, and I suspect this is because of my confusion
> > around PMA (as mentioned originally) SO let me elaborate...
> >
> >
> >
> > In my config.inc.php I changed pma to root and the pma password to the
> root
> > password for mysql
> > When I browse to the phpmyadmin page I neter root and the root password
> for
> > mysql
> >
> > Thanks,
> > Adam
> >
> > -----Original Message-----
> > From: Giff Hammar [mailto:gham...@sv-phoenix.com<mailto:
> gham...@sv-phoenix.com>]
> > Sent: Wednesday, December 23, 2009 10:41 AM
> > To: php-db@lists.php.net<mailto:php-db@lists.php.net>
> >  Subject: Re: [PHP-DB] RE: Help for a beginner
> >
> > It looks like you are not connecting because of a user name/password
> > combination. Typically, Windows does not use root as a valid login as do
> > most other operating systems. Try using your login information to see if
> > you can connect to mySQL using the GUI. I suspect you'll succeed. The
> > other option would be to use the mySQL admin user name and password. One
> > of those should work.
> >
> > Once you can connect to your database with the GUI, you can then use PHP
> > to call the mySQL database connect strings and manipulate your data as
> > necessary. The DBD/DBI is a more generic solution that allows you to use
> > a standard coding structure in PHP (or perl) and easily change databases
> > underneath. For a small implementation, this isn't necessary. There are
> > other database abstraction layers that perform the same function.
> >
> > Giff
> >
> > On Wed, 2009-12-23 at 20:46 +0530, Chaitanya Yanamadala wrote:
> > > 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
> > > >
> > > >
> > >
> > >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> --
> <a href="http://www.c28.com/?adid=st&iid=19467";>
> <img src="http://www.c28.com/images/banner_88x31.gif"; border="0"
> width="88"
> height="31"></a>
>
>
>
> --
> <a href="http://www.c28.com/?adid=st&iid=19467";>
> <img src="http://www.c28.com/images/banner_88x31.gif"; border="0"
> width="88" height="31"></a>
>
>
>
> --
> <a href="http://www.c28.com/?adid=st&iid=19467";>
> <img src="http://www.c28.com/images/banner_88x31.gif"; border="0"
> width="88" height="31"></a>
>



-- 
<a href="http://www.c28.com/?adid=st&iid=19467";>
<img src="http://www.c28.com/images/banner_88x31.gif"; border="0" width="88"
height="31"></a>

Reply via email to