Looks possible that php isn't using that particular ini file. Make sure
it's the correct ini file, because your error message has it looking in
a different location.
Try mysql_connect("127.0.0.1:3306:/tmp/mysql.sock", etc etc etc) for
your connect (that might supposed to be the path to socket, not the file
itself, try both).
-----Original Message-----
From: Ruprecht Helms [mailto:rhelms@mayn.de]
Sent: Friday, October 03, 2003 8:15 AM
To: Michael Scappa
Cc: php-db@lists.php.net
Subject: RE: [PHP-INSTALL] Problem by running mysql-connection
in php-script
On Thu, 2003-10-02 at 22:28, Michael Scappa wrote:
> Ruprecht,
>
> Make sure you have PHP pointing to the right location for the
> mysql.sock. "locate mysql.sock". Sometimes its in the /tmp dir. If it
is
> in another location you can point to it specifically when you call
> mysql_connect (refer to php.net for the exact string), or just change
it
> in your php.ini.
This are the entries I've made in the php.ini
[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent = On
; Maximum number of persistent links. -1 means no limit.
mysql.max_persistent = -1
; Maximum number of links (persistent + non-persistent). -1 means no
limit.
mysql.max_links = -1
; Default port number for mysql_connect(). If unset, mysql_connect()
will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order). Win32 will
only look
; at MYSQL_PORT.
mysql.default_port =
; Default socket name for local MySQL connects. If empty, uses the
built-in
; MySQL defaults.
mysql.default_socket = /tmp/mysql.sock
; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host = localhost
; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user = root
And this is my actual /tmp-directorylinux:/tmp # ls
. .esd AcroSaTWYY
aaa ksocket-root migrate-2
noteedit.2vmq44
.. .shtool.8404 AcroWx7cEx
alsaplayer_root_0 mc-root migrate-3
noteedit.rvtxIc
.ICE-unix .webmin Acrol21KzJ
audacity1.1-root mcop-root migrate-4
orbit-root
.X0-lock AcroAgqtL1 AcrooMY5eg
gsr-record-Untitled.wav-1603.BHH8QX medusa-idled-service migrate-5
.X11-unix AcroMfep2R Acrowt39f1
jpsock.141.6939 migrate migrate-6
.caitmp AcroQUQtXc Acrox5BdJI
kde-root migrate-1 mysql.sock
You see there is the mysql.sock
And this is the connection-command in some scripts I use. Normaly it
works fine, but now It fails and I get the reported error.
mysql_connect("localhost","root");
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
