Welcome to MacBoardz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How the hell do I run mysql and php in leopard????

 
Goto page Previous  1, 2
   Macintosh computer (Home) -> System RSS
Next:  Leopard Icons: Reverting to the original ones  
Author Message
Tim Streater

External


Since: May 12, 2007
Posts: 66



(Msg. 16) Posted: Thu Feb 07, 2008 7:19 pm
Post subject: Re: How the hell do I run mysql and php in leopard???? [Login to view extended thread Info.]
Archived from groups: comp>sys>mac>system (more info?)

In article ,
Tim Streater wrote:

> In article
> ,
> wrote:
>
> > Ok so I might be the dummy here, I can take that, dole out the ctdowns
> > but please tell me. I have looked at roughly a million f%@$ing
> > tutorials and the best anyone seems to have is I think you might....
> > with no information. I'll start out by saying the apache and php files
> > are apparently in the library in a webserver folder. Since I don't
> > have a back up drive or any means of backing up prior to screwing
> > around in the terminal, I'm reluctant to. Either way can anyone out
> > there tell me with confidence exactly what I need to do? If its
> > downloading something, whatever, I'm an illustrator who's suddenly
> > become the "it guy" so now as I'm trying to construct a simple
> > database I've got no clue what the hell I'm supposed to do. PLEASE
> > HELP!!!
>
> Do you have any programming experience? If not, I wouldn't use
> PHP/mysql. I'd use FileMaker or this new thing called Bento they
> (FileMaker) have, or something equally easy. And that's not a put-down -
> I'd use it myself in such a case. What simple database is needed, anyway?
>
> I have some notes (at home I think) for getting PHP/apache/mysql to play
> together. You can have these if I can find them, but without some
> programming background you'll be stuck after that.

I finally found my notes, here they are. I wanted to b able to test our
assets database and web front end on my Mac at work, so I needed to
install mysql and then the following extras were needed for Leopard:

Things needed to make apache/mysql/PHP5 play together
=====================================================

Apache
------

1) De-comment the php5 include in main config file in
/private/etc/apache2/httpd.conf

2) Accept .phtml as suffix in: /private/etc/apache2/other/php5.conf

AddType application/x-httpd-php .phtml

3) add a user-specific config file in
/private/etc/apache2/users/name.conf

<Directory /Users/name/Sites>
AllowOverride None
Order deny,allow
Allow from all
</Directory>

mysql
-----

1) When installing the startupitem, ensure it really gets installed and
do it again if necessary. See (2)

2) Start and stop the server from /Library/StartupItems/MySQLCOM. To do
this, run the script there as:

./MySQLCOM start
./MySQLCOM stop

3) Make a /etc/my.cnf from /usr/local/mysql/support-files/my-huge.cnf

Use chmod o+w my.cnf to make it editable
Add a section at the end [mysqld] with max_allowed_packet = 16M
Add this also to the [mysql] section
Undo the first thing with chmod o-w my.cnf
Restart mysql

4) Make a /etc/php.ini from /etc/php.ini.default

Use chmod o+w php.ini to make it editable
Find the line: mysql.default_port =
Change it to be: mysql.default_port = /tmp/mysql.sock
Undo the first thing with chmod o-w php.ini
Restart personal websharing

 >> Stay informed about: How the hell do I run mysql and php in leopard???? 
Back to top
Login to vote
Lewis

External


Since: Jan 19, 2008
Posts: 302



(Msg. 17) Posted: Thu Feb 07, 2008 7:19 pm
Post subject: Re: How the hell do I run mysql and php in leopard???? [Login to view extended thread Info.]
Imported from groups: per prev. post (more info?)

Back to top
Login to vote
David Empson

External


Since: Jul 18, 2004
Posts: 548



(Msg. 18) Posted: Thu Feb 07, 2008 8:25 pm
Post subject: Re: How the hell do I run mysql and php in leopard???? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Ramon Tate wrote:

> In article
> ,
> wrote:
>
> > I'm just
> > trying to set up an in-house comment form, a sign up form, and maybe a
> > little more functionality,
>
> I will second the previous poster's suggestion re: FileMaker. If you've
> already thought out what fields you will need and what relationships
> need to exist to support applications like this, you can probably be up
> and running with most or all of these apps in a day - maybe even a few
> hours if the requirements aren't too extensive. I've used FM ever since
> version 1 for a host of small-to-medium jobs and have been
> well-satisfied with the results. Yes, you CAN use the heavy hitter dbs
> like mysql, etc. but if you aren't a REALLY experienced db programmer,
> there is no comparison in productivity between FM and the more
> traditional SQL dbs. In fact, you might even find that one or more of
> the example FM apps included in the package can be easily modified to do
> exactly what you need.

I'll third that recommendation.

The only restriction which might cause problems is that FileMaker Pro's
Instant Web Publishing feature is limited to five active web clients at
the same time.

This might be an acceptable limit for an internal database in a
relatively small organisation, but if you want more than that
(especially for public access via the Internet) you will need at least
FileMaker Server (with PHP code you need to write to implement the web
pages), or FileMaker Server Advanced (which can also do Instant Web
Publishing, which is much easier to set up).

The cost of a single licence of FileMaker Pro isn't too bad, but it
starts to add up if you need Server as well (much more for Server
Advanced). You might also need a dedicated computer to host the server
if it is getting heavy use.

--
David Empson
dempson.RemoveThis@actrix.gen.nz
 >> Stay informed about: How the hell do I run mysql and php in leopard???? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Leopard + Apache + PHP + Mysql - One more question. Anybody using their Mac for PHP-Mysql development and updated to Leopard? Does the update upgrade mess with the Apache/PHP/Mysql setup?

Server Logistics' MySQL Complete on OS X ... Anybody? - Hi There-- After having trouble activating PHP on my server that came with OS X, on someone's recommendation, I installed Server Logistics' Apache2, PHP and then, MySQL complete. Now I've found that I did turn PHP on okay, so now I can turn one server....

force quit doesn't work, beach ball hell - Using 10.3.4 on a dual 867. I have had trouble getting iphoto to quit, even when I do the option-apple-escape command. The only way to get it to leave the dock is by rebooting. Then iTunes started having the same trouble. After rebooting and trying...

Can I put Apache, PHP, MySQL on Mac OS 9.2? - Hi, I have almost no experience with Macs and am a linux user. I am doing some development work for a small business starting up. I am doing this for free and the person has little to no capital to put into this. She has an iMac running OS 9.2. I wa...

So where's the leopard? - All I see on the packaging and disc is a solid "X" on a galaxy-like bg. ??? Rog :)
   Macintosh computer (Home) -> System All times are: Pacific Time (US & Canada)
Goto page Previous  1, 2
Page 2 of 2

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]