[HOWTO] - Setup PHP & MySQL

Status
Not open for further replies.
Hey roguephp,

How do I delete the other one? It is hidden. I know it is called MySQL so I cannot create another one with the same name. Does it have to be called MySQL?

Shouldn't I delete "Other..." first, then create a new user?

ListerMint
 
OK. Having issues...

Did the whole php setup from www.entropy.ch/. I'm getting the following message:

httpd not running, trying to start
Syntax error on line 368 of /etc/httpd/httpd.conf:
Cannot add module via name 'mod_php4.c': not in list of loaded modules
/usr/sbin/apachectl graceful: httpd could not be started


What am I doing wrong? I'm using OS X 10.2.3 on an B&W G3 with 768 RAM. And, I'm a newbie.
 
Use the NetInfo Manager... take a look at this site for some good info:

http://www.phpmac.com/articles/view.php?id=41

If you go to the homepage of that same site, there is a new how-to on getting MySQL and PHP running for the total newbie and there are other how-to articles if you browse them that are a bit more hands on.

Originally posted by ListerMint
Hey roguephp,

How do I delete the other one? It is hidden. I know it is called MySQL so I cannot create another one with the same name. Does it have to be called MySQL?

Shouldn't I delete "Other..." first, then create a new user?

ListerMint
 
Originally posted by byronfunk
OK. Having issues...

Did the whole php setup from www.entropy.ch/. I'm getting the following message:

httpd not running, trying to start
Syntax error on line 368 of /etc/httpd/httpd.conf:
Cannot add module via name 'mod_php4.c': not in list of loaded modules
/usr/sbin/apachectl graceful: httpd could not be started


What am I doing wrong? I'm using OS X 10.2.3 on an B&W G3 with 768 RAM. And, I'm a newbie.


well just make sure you have this line in the /etc/httpd/httpd.conf file:
LoadModule php4_module libexec/httpd/libphp4.so

it is located somewhere under the sub heading:
Dynamic Shared Object (DSO) Support
 
roguephp.

How do I delete the other one? It is hidden. I know it is called MySQL so I cannot create another one with the same name. Does it have to be called MySQL?

Shouldn't I delete "Other..." first, then create a new user?

ListerMint
Use the NetInfo Manager... take a look at this site for some good info:

http://www.phpmac.com/articles/view.php?id=41

I tried it step by step exactly as instructed. I still have the hidden user account, mysql, that I can't access. Now I can't find the one I just created. This is becoming a nightmare! :mad:

Any other ideas?

ListerMint
 
How and where can i tell its running? and if i restart dose it still run? i didnt entirely understand the "mysql test" part it just said:

[Quicksilver:/usr/local/mysql] quicksilver% Starting mysqld daemon with databases from /usr/local/mysql/data

then i typed "mysql test"

and i got this:

mysql: Command not found.

yeah i know im still learning UNIX etc but doeas that look like it installed? what do i do next?

Cheers..
 
I did a cut n paste following of php setup, but something went whacked. Anyway, the result is that I think I messed up my Apache server.

For instance, Terminal tells me:

"/usr/sbin/httpd can't open library: /usr/lib/libiodbc.2.1.6.dylib (No such file or directory, errno = 2)"

Figuring that I really messed things up, should I try to reinstall the server? Any favorite starting points?

Joe
 
Originally posted by LogicMan
cool. i got php to work. but where can i find the php.ini or config file?

Depending on which insallation you did, one may not have been created. I know I had to make my own. Do a search on google for php.ini and you will find instructions.
 
ok i am a linux user, used to run linux mandrake 7.2 with my web site on it, i was useing phpweblog.org, and now i am working on setting it up on my PB500
i installed mysql, mafe the user, followed the steps at the start of the thread, and i cant do the test, also, if i open index.php, i get the text,, HELP,, lol
 
I recently installed mysql 4.0.12 on my Power Mac G4 running Mac OS X Server 10.2.5. I believe that mysql version 3.23.51( ? ) is still installed(came with the OS). My questions are:

1) How do I know if the older version of mysql is still on the computer?

2)if it still is on the computer, how do I take it out without touching mysql 4.0.12?

thanks
 
Hi, I think I've got a problem.....:(

After trying several times t install MySQL I found that I've been istalling different version.

This is what the terminal is showing me:

include
lib
mysql
mysql-debug-4.0.13-apple-darwin6.4-powerpc
mysql-debug-4.1.0-alpha-apple-darwin6.4-powerpc
mysql-standard-4.0.13-apple-darwin6.4-powerpc

Another thing is when I type:
sudo ./bin/safe_mysqld --user=mysql &

I get the message:
Starting mysqld daemon with databases from /usr/local/mysql/data
030529 21:52:27 mysqld ended


Could one of you please help me out here... Ihave installed Mac os x 10.2.6

Thanks,

Shyos
 
Here's an interesting one, when i go to "gunzip libphp4.so.gz" after the download, it tells me that it is not in "gzip format" ? ever heard of this?

-J-
 
I installed PHP again recently with the centropy installer but after a while it just stops working. This happened to me a while ago but I thought I'd give it another go since I had the latest version of Panther with the newest centropy install. As far as I remember, PHP just stopped working, I'm not sure there was even a restart in between.

It's a bit much to ask, "Why isn't my PHP not working?!" but can anyone help me with troubleshooting? For example, how can you check if Apache is loading the module and what the error messages mean, if there are any. I've already tried reinstalling the centropy package but no dice.

Thanks,
Craig
 
Panther comes allready with php4 you just have to open the terminal and type => $cd /etc/httpd/
here is were you configure your Apache

Second step is to check if you uncomment the module
$cat httpd.conf | grep php4
#LoadModule php4_module libexec/httpd/libphp4.so
AddModule mod_php4.c
<IfModule mod_php4.c>

if it's like the above with the # you should delete the #

open the system preferences and restart apache in the sharing tab or
do
$sudo apachectl restart
 
Status
Not open for further replies.
Back
Top