Am I missing something? PHP, MySQL, Apache

agallant · 06-07-2004, 09:18 AM

OK,

Fedora core 1
Apache 1.3
PHP 4.3.7
MySql (I don't know what version what ever came with Fedora)

Apache is working
MySql is working
PHP is installed but do i have to start it?

when i try to add a MySQL connection is Dreamweaver MX i get an error message stating
1. "There is no testing server running on the machine"
2. "the testing server specified for this site does not map to http://***/apache/_mmserverscripts/MMHTTPDB.php url. Verifie that the URl prefix maps to the root of the site"

Any ideas, What am i missing?

paulsm4 · 06-07-2004, 09:41 AM

Hi -

1. You can see whether or not PHP is installed by typing in and executing the following script:

Code:

<?php
  phpinfo ();
 ?>

You should see lots of information about your Apache and your PHP versions displayed in your browser.

2. Next, I'd verified that I could connect to mySQL from the command line (i.e. you can talk to your database and query tables with the "mysql" command interpreter).

3. Finally, I'd suggest writing a brief "hello world" to verify that your PHP can talk to mySQL. I have a sample here:

http://home.jps.net/~paulsm/proj/hello_sql/hello_pg.php

Hope that helps .. PSM

marghorp · 06-07-2004, 01:50 PM

Dreamweaver? You wan't to connect from a different Windows box? Then you have to open your mysql port.

agallant · 06-07-2004, 02:07 PM

How do i do that. I would assume in one of the configuration files. Do you know which one? I was able to connect through ODBC

marghorp · 06-07-2004, 02:15 PM

You connected through ODBC? Then it is some problem in Dreamweaver perhaps.

agallant · 06-07-2004, 02:22 PM

It keeps asling me to setup my test site, i do but it does not. I got annoyed enough to rebuild the server.

agallant · 06-08-2004, 07:32 AM

Quote:

Originally posted by paulsm4
Hi -

1. You can see whether or not PHP is installed by typing in and executing the following script:

Code:

<?php phpinfo (); ?>

I tried your test and i got just a blank web page, no error message, just a blank page. Is that good or bad? I also rebuilt the server and on the good side IE6 is not trying to download php files any more, it will display them now.

marghorp · 06-08-2004, 07:35 AM

in IE6 you have to delete cache files so it will stop asking you to set up your test page. Caching in IE6 is very anoying. Sometimes, even if you press SHIFT + F5 it won't refresh the site, it just uses the one from cache.

paulsm4 · 06-08-2004, 08:37 AM

That's bad. It means PHP is not configured on your server.

Your best bet is to "google" for a tutorial on installing PHP.

The problem can be any of:

1. PHP isn't installed
2. The PHP DSO isn't installed where Apache can find it.
3. The Apache httpd.conf file isn't configured for PHP.

As far as httpd.conf, you need the following entries:
EXAMPLE:

Code:

LoadModule vhost_alias_module libexec...
 LoadModule...
 LoadModule php4_module libexec/libphp4.so

 ClearModuleList
 AddModule mod_vhost_alias.c
 AddModule...
 AddModule mod_php4.c
...
 AddType application/x-httpd-php .php .php3 .phtml
 AddType application/x-httpd-php-source .phps
...

'Hope that helps .. PSM

agallant · 06-08-2004, 09:03 AM

Ok this is diving me crazy. I am trying to reinstall php4. ./configure --with-mysql=/????????

Where are the libbrerys? i have a mysql folder in:
/usr/share
/usr/lib
/var/lib

Which one do i use. I am running Fedora and installed mysql off of the fedora cd.

marghorp · 06-08-2004, 09:05 AM

why didn't you install apache from the fedora cd also? You stil can install from a RPM from fedora cd

agallant · 06-08-2004, 09:08 AM

I don't know. i just downloaded apache and installed it. I don't like where fedora puts files if you install from the cd.

agallant · 06-08-2004, 10:49 AM

Thank you guys so much for all of your help. It magicailly started working when I installed Apache2. I had to of cource do a make clean on the php and reinstall it to work with apache2 but it works i got my configuration page when i ran the <? phpinfo() ?> script.

-AG

marghorp · 06-08-2004, 10:57 AM