PHP and Apache in Leopard

@Mickey79:

I had this exact same problem. I ended up going with MAMP after experimenting with a bunch of solutions. Until the Entropy package is ready (Marc is very busy with a paying gig at the moment, so it will probably be a while), this is your best bet if you need GD, MCrypt, etc.

Here's a step-by-step guide to installing MAMP and tweaking for web development use:

http://stringfoo.com/2007/11/07/mamp-setup-leopard/

Cheers,
Steve

Thanks. That is what I thought. But here is what happened...
I inadvertently deleted the original httpd.conf that shipped with 10.5 in etc/apache2. So i copied the one pasted earlier in this thread by eddy kestemont . I was confused when I first saw that post bc it looked like the comments were not all hashed out. So now, I am still not sure how that posting of the httpd.conf file for apache 2 can work.

jeff

@Ndna:
Ouch.

Ping me here with your email address and I'll send you a backup copy of the http.conf included with Leopard.

http://stringersites.com/contact_email.php

-Steve

Ok, PHP working fine now. Thanks.
Now, need to tackle mysql...
Can't connect to mysql engine.
I followed instructions for mysql on StringFoo. However, if I type mysql or mysqld at the terminal prompt, I get: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)

My phpinfo shows...
PHP version 5.2.4
Configuration File (php.ini) path: /etc
Loaded Configuration File: /private/etc/php.ini

Is this correct?
Why is the path different from the Loaded?

P.S. MySQL has been running on this machine (iBook G4) for nearly 3 years. (Not that it helps much with 10.5 now)...

Also, where are my old databases from mysql 4?

Jeff
-------

The error you're getting means that MySQL isn't finding the socket that gets created.

One difference between 10.4 and 10.5--or more specifically, the versions of PHP that are installed with each--is that they expect MySQL to be in different places. Since MySQL is still installing in the "old" place, the 10.5 version of PHP can't find it. Thus, we have to give it a little help. To do this, try the following:

Create a text file and save it as "/etc/my.cnf". If you're in a terminal, type:

sudo nano /etc/my.cnf

Enter the following text:

[client]
socket = /var/mysql/mysql.sock
[mysqld]
socket = /var/mysql/mysql.sock

Save the file.

In a terminal window, type the following in order to create a folder where the MySQL sock file will live:

sudo mkdir /var/mysql
sudo chown _mysql /var/mysql

Note: If you are using any of the MySQL Tools (e.g. MySQL Administrator, etc.), you’ll need to tell them where to find the new sock file. To do this, click the Advanced drop-down on the connection dialog, and enter “/var/mysql/mysql.sock“.

Let me know if that helps or doesn't work.

Cheers,
Steve

I pre-appologize for my ignorance here...
I already tried this before posting for mysql help, above.
What confuses me is that in the instructions here, I create a directory "/var/mysql" and chown to mysql, where is the socket? There is nothing actually in the directory /var/mysql.

???

the socket is created at runtime when you fire up mysql. The my.cnf file tells mysql where to put the socket.

Sorry about grammar. Typing on iPod touch.

I did:
sudo cp /private/etc/httpd/users/* /private/etc/apache2/users/

There is an eflaten.conf in apache2, same as in httpd folder.
The browser says it cant esatblish a connection. The websharing is turned on in the controllpanel. I cant connect on http://localhost/ or http://127.0.0.1 either.

jippi! Both Apahe and php now works after enabling php in the httpd.conf with LoadModule php5_module. OK mySQL tomorrow 🙂

Best thanks for this type. PHP and local host function!

I am trying to get php to run, but I am having some problems. I found a site detailing how to switch on php but after following the instructions it still wasn't working. I noticed however that some the files/folders were missing from my private folder that I probably need. Although the machine is new and had Leopard on it from the start, I believe the problem may have arisen when I reinstalled Leopard to resolve another unrelated problem. I noticed that at least one folder that I may need is not in the current private/etc folder. This folder is entitled 'httpd' and it, itself contains a folder 'users'. I believe I need these.

The problem I am having is that the php files are simply showing up as text, I guess they are not being read or parsed properly.

If someone could help and let me know what I need to do to get this to work, ie. Do I need to transfer the httpd folder? If so, how?

Thanks in advance for any help.