[matvon]

Here are complete (hopefully) step-by-step instructions for downloading, building and installing MySQL, Apache, and PHP4. These instructions will replace the built-in Apache web server with a binary compiled for PHP4 support.
http://homepage.mac.com/LightyearDesign/MacOSX/

Enjoy, and let me know of any glaring errors :-)

[cwasko]

No errors that I can see of. Great page too. But... what I really want... is to run PHP4 as a DSO. I can't seem to get this to work. I've been trying since 4.0 as official.

Just so people know, I have compiled it succesfully as a DSO, however, when running Apache with PHP4 DSO, there are library error which prevent it from running.

This happened on OSXS and was was hoping that it would be fixed on OSXPB, but this is not the case.

Anybody have a clue on how to fix this error?

[matvon]

Just so people know, I have compiled it succesfully as a DSO, however, when running Apache with PHP4 DSO, there are library error which prevent it from running. to fix this error?

Can you describe the error? I might be able to help you if I have the specifics.

Yeah, great. IF you've got 'make' on your system (hint: it's not in Public Beta).

[QuatermassX]

Actually, GeeForce, he notes that you need the Developers Tool on his main page (not obvious from the link he provided). Check out MacAddict's guide to getting them from the Dawin opensource.


I have a correction, though:

In the MySQL directions, you need to specify the path for "mysqlfixes.tgz" in the line "tar xvfz PATH/mysqlfixes.tgz"

Question: does it have to be tar-ed inside the "mysql-3.23.24-beta.tar.gz" directory (and thus moved there -- something not stated in the instructions)? Or can it be run from its place in the "Temporary" directory?

[matvon]

Question: does it have to be tar-ed inside the "mysql-3.23.24-beta.tar.gz" directory (and thus moved there -- something not stated in the instructions)? Or can it be run from its place in the "Temporary" directory?
[/B]

You should cd into the mysql directory, then tar xfvz ../mysqlfixes.tar.gz so that the files in the tarball will unpack inside the mysql directory. I'll correct that on my page. Thanks :-)

[jblakeh1]

slightly off-topic: has anyone had any luck installing php4 on Mac OS X *Server* 1.2? I give up. I finally got php3 installed, but it doesn't recognize the mySql database, and any other types of install don't work, either as a module or otherwise. I've found instructions on severa different sites, but they don't work... it took me a week to find out why apache 1.3.12 wouldn't install- a Web Objects patch on the cd needed to be installed... ugh...

[ohericord]

i have a fresh unmodified install of macosX beta , and i install the developer.pkg from my DP4 CD , and i follow every damn line of your tutorial .

result : nothing!!!!!

mysqld -> error
apachectl start -> error

i'm so sad


please make a php_mysql_apache.pkg


thanks

[QuatermassX]

Alas ...

Syntax error on line 209 of /Library/WebServer/Configuation/apache.conf : Invalid command 'LoadModule', perhaps mis-spelled or defined by a module no included in the server configuration

:-(

I think something is amiss with the MySQL install ... just a guess ...

But hey, I'm getting better understanding strange UNIX stuff ;-)

[jblakeh1]

It's nice to know I'm not the only one having these problems.

I agree, it would be great if someone with a better understanding of php/mysql could create binaries for the rest of us... I know the limitations of using someone else's binaries, but frankly, at this point, I could care less. I'm more of an author than a developer, and I've probably spent two weeks trying to get all this stuff installed! I've read at least half a dozen installations from the web, and none of them work... compile errors, missing files, ugh!

[jblakeh1]

It's nice to know I'm not the only one having these problems.

I agree, it would be great if someone with a better understanding of php/mysql could create binaries for the rest of us... I know the limitations of using someone else's binaries, but frankly, at this point, I could care less. I'm more of an author than a developer, and I've probably spent two weeks trying to get all this stuff installed! I've read at least half a dozen installations from the web, and none of them work... compile errors, missing files, ugh!

[ohericord]

when i'm trying to launch apache:

Syntax error on line 209 of /Library/WebServer/Configuration/apache.conf:
Invalid command 'LoadModule', perhaps mis-spelled or defined by a module not included in the server configuration
/usr/sbin/apachectl start: httpd could not be started


when i'm trying to launch mysqld:
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)


toooooo baaaad

[jblakeh1]

the 'Load Module' problem: you must have configured apache with php as a static module. Open the apache.conf file (or httpd if you reinstalled it) and comment out all the lines that begin with "Load Module" or "Add Module."

I installed the mysql binary (I am on OS X Server, though, so it won't work for you if you are on PB).

.b

[timster]

- you dont need to have the developer tools to compile the PHP/Apache support.

-however, the instructions are not completely kosher. Apache will fail to start because of bad loadModules. You probably need to go to the config directory in apache and remove the old apache.conf file and replace it with the default apache conf file that is installed with apache 1.3.12. Then Apache will work.

as for MySQL. I'm still investigating. The error when connecting to mysql.sock is because the mysqld daemon is not running. I tried to run the mysqld, and i get a security warning because its trying to run as root. I need to look further into this.



------------------
-The Timster

This actually finally worked for me.
You have first to remove the apache.conf file, and rename the apache.conf.default as apache.conf.
Don't forget to add the .php type by uncommenting the line starting with # AddType ... concerning .php extension. It's a good idea to make the .php3 extension recognized as being php4.

Concerning MySql, it actually seems to work. After the installation, type :
mysql_install_dbsafe_mysqld &
mysql

et voil
!

I've just installed phpMyAdmin ... and created a database :-)

Thanks guys.


------------------
Dominique Peretti

Originally posted by Dom:

Concerning MySql, it actually seems to work. After the installation, type :
mysql_install_dbsafe_mysqld &
mysql

Oops, it should read :

After the installation, type :
mysql_install_db
safe_mysqld &
mysql



------------------
Dominique Peretti

[ohericord]

how to make mysql run at startup???

thanks