PHP/MySQL and the OS X version of Abyss

[tristanforsyth]

Dont know if this has been asked (and yes, I did do a search. OS X returned nothing and macintosh returned three hits....)
Sorry, just preparing for the "do a search" barrage that most ppl reply with!!!
LOL

Anyway, my question is: How to get php/mysql working with the OS X version of abyss. I had a look at the mysql tutorial and it says to create a database folder and in it create a mysql folder then to unzip/install mysql into it. The only problem is the OS X version of MySQL from mysql.com has its own installer that doesnt allow you to custom install (ie it gets installed into the libaray folder)
Is it as simple as copying over the mysql folder from the library folder (yes, I could try this but I dont know if it installs stuff else where as well). If this is not the case, how do you install mysql under the OS X version of abyss (and hence installing php)
If the php issue is a separate thing, is it as simple as installing the cgi file/ini file as per the instructions on http://www.aprelium.com/abyssws/php.html

I hope this makes sense as whilst I have php enabled, its kinda useless with mysql!!
:?
Any help, suggestions etc would be greatfully appreciated and my students will thank you as well!!

Thanks guys (and girls!!),
Tristan
http://www.tristanforsyth.com

[aprelium]

tristanforsyth,

You should install PHP as explained in http://www.aprelium.com/abyssws/php.html . There is there a MacOS X PHP version made by us that will run without any problem.

To set MySQL, you should go to www.mysql.com and install it as explained in their instructions (download the Installer package from http://dev.mysql.com/downloads/mysql/4.0.html - MacOS X - it's the easiest to install). Once set up, there is nothing to do. MySQL will run in the background and start automatically when the computer is on.

Now, install a PHP script that can use MySQL in your web server and enjoy :D
_________________
Support Team
Aprelium - http://www.aprelium.com

[tristanforsyth]

thx aprelium for the quick reply. Straight from the boss, Im impressed!!!

So it doesnt matter that the mysql files are not in the abyss folder (as per the tutorials for the windows version?) I just want to clarify this before I install it.
I did try to install both the versions from entophy.ch and the link you gave but they both refused to install (the last screen said there wan error) and I just assumed that this maybe be becasue of the abyss server (it was running at the time). Im going to try the version from serverlogistics.com as I have installed this before when running apache and it seemd to work.
Once installed, is there any configuring on the server as per the php setup in the advanced panel? Again, I just want to make sure from the start so I dont get half way through and hit a wall!!

Thanks again,
Tristan
_________________
http://www.tristanforsyth.com

[Moxxnixx]

[tristanforsyth]

thanks again for the quick reply. I have just installed mysql 4.x from serverlogistics but I keep getting an access denied msg (its not recognising either my user (default of mysql or my password)
*sigh*
I think I might just give and do things in good old html and give php a miss!!
(I really just wanted to try it out to see if it would make like a little easier..)
Oh well

Thanks agian
Tristan
_________________
http://www.tristanforsyth.com

[Foxified]

default sql is root, no password...

[tristanforsyth]

will try that

I thought that under OS X the default was mysql (its installed as a user when you install) but I will try this combination.

Thanks again.......
I really owe you
_________________
http://www.tristanforsyth.com

[tristanforsyth]

Just as an update. Everything is working fine now ("root" was the username but the database also had a password which I had spelt wrong!! {stupid keyboard 8O } ) so thanks again to foxified and aprelium for your help.
I am now trialling phpbb at www.tristanforsyth.com/forum but I really want to use php for a photo galley.......

Thanks again guys!! :D
_________________
http://www.tristanforsyth.com