RE: [cobalt-developers] How to make PHP and MySQL work on a RAQ XTR

["Pete Stulginskis" <vps@xxxxxxxxxxx>]

Lee,

You can go to the mysql.com site and get the most recent rpm's "3.23.37" and
install them.

I've just done this with a Qube3 and will shortly be doing it on a XTR.

The issue that did cost me a couple of days, which for me, would be worth
the price if the Cobalt Professional-development group assisted you with, is
that the MySQL rpm's put the socket file in "/var/lib/mysql/mysql.sock" and
that by default, PHP looks at "/tmp/mysql.sock".

You can force PHP to look where ever you want in the command:
mysql_connect() by appending ":/path-to-socketfile" after the hostname.
  example: mysql_connect("localhost:/var/lib/mysql/mysql.sock",....);

The php.ini file needs to be edited also, uncomment:
  'extension=mysql.so'

Pete S.



-----Original Message-----
From: cobalt-developers-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-developers-admin@xxxxxxxxxxxxxxx]On Behalf Of Lee Dale
Sent: Wednesday, May 09, 2001 4:59 AM
To: cobalt-developers@xxxxxxxxxxxxxxx
Subject: Re: [cobalt-developers] How to make PHP and MySQL work on a RAQ
XTR


crap! I just took the time and expense to pay a contract sys. admin. for
this.
There was no mention of a package on the web site. It said to go to
mysql.com...
grr.

Lee Dale
President
_____
Smack Inc.
416.440.4246  Telephone
416.440.1230  Facsimile
http://www.smackinc.com
Clear. Concise.
Communication Solutions from Smack Inc.



Taco Scargo wrote:

> You can also download a pkg format install from http://pkg.nl.cobalt.com
>
> ;)
>
> With regards,
>
> Taco Scargo
> Professional Services Manager, EMEA
>
> Sun Microsystems B.V.
> Server Appliance Business Unit
> ----- Original Message -----
> From: "David Koopman" <dave@xxxxxxxxxxxxxx>
> To: <cobalt-developers@xxxxxxxxxxxxxxx>
> Sent: Wednesday, May 09, 2001 0:35
> Subject: [cobalt-developers] How to make PHP and MySQL work on a RAQ XTR
>
> > The RAQ XTR comes with PHP installed, however, mySQL is not installed by
> > default.
> >
> > Install MySQL on the XTR:
> > 1) log in as admin - create a 'download' folder or a rpm 'folder' and cd
> > into it.
> > 2) point a browser to www.mysql.com - follow the link for the download
> page
> > for the most recent stable version (right now, it's 3.23 version).  Find
> the
> > path to the Standard binary RPMs (all you need is the 'The server for
i386
> > systems' and 'Client programs for i386 systems')
> > 3) go back to your shell and type:  wget
> > http://path_to_latest_mysql_version.rpm  (repeat this for both the
server
> > and the client programs)
> > 4) su -
> > 5) rpm -Uvh the_rpms.rpm  (do it twice - once for the server, once for
the
> > client)
> >
> > ok, at this point mySQL is installed on your cobalt xtr -- proceed to
set
> it
> > up the way you want it....  get the root password set and everything and
> > load some databases.
> >
> > You'll find that when you try to use a mysql_connect() funtion in your
PHP
> > code, it will fail, by default.  You must modify the /etc/httpd/php.ini
> > file.  You need to add:
> > extension=mysql.so
> > in the right place in that file.
> >
> > Now try to run your PHP script that makes a call to mysql_connect().  If
> it
> > says something about cannot connect to /tmp/mysql.sock  ---  then you
must
> > do one more thing to make it work......   you must create a symbolic
link
> to
> > the real mysql.sock inside the /tmp folder, like this:
> > ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
> >
> > That's it.  Took me awhile to figure it all out.  The knowledgebase is
> VERY
> > scarce on information.  I am not very happy with the level of support
from
> > cobalt, personally.  I have had to figure everything out for myself....
> the
> > XTR documentation is lacking big time.  If you have an XTR and you know
> how
> > to do something tricky, you should post the How to so others can figure
it
> > out too.  Thanks.
> >
> > Dave Koopman
> >
> >
> >
> > _______________________________________________
> > cobalt-developers mailing list
> > cobalt-developers@xxxxxxxxxxxxxxx
> > http://list.cobalt.com/mailman/listinfo/cobalt-developers
> >
>
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers



_______________________________________________
cobalt-developers mailing list
cobalt-developers@xxxxxxxxxxxxxxx
http://list.cobalt.com/mailman/listinfo/cobalt-developers