|
|
Posted by Jerry Stuckle on 03/08/06 14:31
Al Dykes wrote:
> Is there a usenet group for Apache questions? If I knew of one I'd
> post the question there.
>
How about alt.apache.configuration?
> I can't get a MySQL connection in PHP code under apache to work.
>
Not good. :-)
> I'm learning LAMP, starting on a w2k box. I've downloaded recent
> copies of Apache, MySQL and PHP and done the setup and it seems to
> work,except for SQL. I can run pure PHP under the apache server and
> I've installed phpmyadmin and I can make a database and then access it
> from mysql in a cmd shell.
>
Then MySQL and PHP ARE working together.
> I suspect there is some configuration in Apache to talk to Mysql that
> I've missed. There is no explicit mention of MySQL in my httpd.conf.
>
You shouldn't need it in the httpd.conf file. Apache isn't accessing
MySQL - PHP is. But it does need to be in your php.ini file.
> This code is my index.php file, generated from Dreamweaver8. When I
> put it on my server and try to hit it from my browser (Firefox) it
> just hangs and times out. Any other file (like index.htlm) works
> fine, and a ling on index.html to index.php also hangs. All the
> passwords, etc, work when tested from command line mysql.
>
Hmmm, that doesn't sound good :-)
> I watch the Apache transaction log and see the client server activity.
> There is none when I type to execute this code.
>
What about the Apache error log? And your MySQL log? Anything there?
Also - did you actually connect to the host in your include file? Since
you didn't post it, we don't know.
If you can't find any errors, you may have to back up and do some
troubleshooting. Like comment out all the MySQL code except the call to
connect and try. If it works, add the db selection, and so on.
> /Connections/apress.php is where it's supposed to be and the contents look fine.
> It was generated by DW.
>
I never trust generated code. I use it, but not without examining it
very closely first. I've been burned too many times. Congratulations
for checking it!
> Thanks.
>
<code snipped>
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|