[Fwd: Re: [Fwd: [PHP3] [Fwd: Error: with MySQL Connect]]]

How do I change PHP 4.0B3-RC2 to reference mysql.sock in a location other than /tmp/mysql.sock (i.e. /var/lib/mysql/mysql.sock)? Is there a compilation directive or php.ini entry that I've missed? Regards, Jack Lauman -------- Original Message -------- Subject: Re: [Fwd: [PHP3] [Fwd: Error: with MySQL Connect]] Date: Sun, 07 Nov 1999 11:02:20 -0800 From: Jack Lauman <jlauman@nwcascades.com> Organization: nwcascades.com To: sinisa@cytanet.com.cy References: <3825B6D1.D3E9C63@nwcascades.com> <14373.47357.859330.489032@localhost.localdomain> Sinisa: Thank you for your prompt response. I have included the following in /etc/my.cnf. I can connect to MySQL from any of the unix hosts on the system as well as NT 4.0 hosts. PHP insists on using /tmp/mysql.sock. I'm open to suggestion. PHP 4.0B2 compiled and worked without any MySQL problems, however PHP include and require statements all failed. PHP 4.0-B3-RC2 has apparently fixed the include/request problem but now it can't connect to MySQL. The following is the current contents of /etc/my.cnf: # This will be passed to all mysql clients [client] #password = my_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K # Start logging log [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable = key_buffer=16M Regards, Jack Lauman sinisa@cytanet.com.cy wrote: > > Jack Lauman writes: > > > > I compiled the cvs version of PHP/4.0B3-RC2 this evening. > > > > Although I got no compilation errors, I get the following browser > > error when loading a previously working page from beta 2: > > > > Warning: Cant connect to local MySQL server through socket > > '/tmp/mysql.sock' (111) in ...... > > > > mysql.sock is located at /var/lib/mysql/mysql.sock > > > > What do I need to do to point PHP to the right location for mysql.sock? > > > > Regards, > > > > Jack Lauman > > > > > > HI! > > Create my.cnf in /etc and add an entry for socket file as depicted in > our fine manual. > > You will have to restart server. > > Sinisa > > +----------------------------------------------------------------------+ > | TcX ____ __ _____ _____ ___ == mysql@tcx.se | > | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic | > | /*/ /*/ /*/ \*\_ |*| |*||*| > mailto:sinisa@cytanet.com.cy| > | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus | > | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ | > | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ | > | /*/ \*\ Developers Team | > +----------------------------------------------------------------------+ > > --------------------------------------------------------------------- > Please check > "http://www.mysql.com/Manual_chapter/manual_toc.html" > before > posting. To request this thread, e-mail mysql-thread18033@lists.mysql.com > > To unsubscribe, send a message to the address shown in the > List-Unsubscribe header of this message. If you cannot see it, > e-mail mysql-unsubscribe@lists.mysql.com instead.