Hi,
I don’t expect a response, but I can’t be the only one out there who had
/ is having this issue.
My eGroupware server
Linux version 2.6.18-6-686 (Debian 2.6.18.dfsg.1-26etch1)
(dannf@debian.org) (gcc version 4.1.2 20061115 (prerelease) (Debian
4.1.1-21))
XAMPP 1.6.3a
eGroupware 1.6.002
Over this last weekend I downloaded each XAMPP single step update to
bring XAMPP current at 1.7.3a.
Everything went fairly smoothly, even after editing the php.ini file
after it doubled in size. After each update I logged in to verify that
I could still access my data. I did not try to edit anything, I was
simply verifying connectivity. After updating to 1.7.3a I attempted to
edit the infolog I was keeping notes in and received a popup box containing
SQLSTATE[HY000] [2002] No such file or directory
Click here to resume your eGroupWare Session (hyperlink)
Access to any popup edit box would return the above error, attempting to
enter several of the databases also returned this error. It would seem
that one of the XAMPP upgrades brought PHP up to 5.3.1 and that other
people had experienced this error.
Looking in the /opt/lampp/logs/error_log file I found
[Sat Feb 06 13:10:32 2010] [error] [client w.x.y.z] PHP Warning:
PDO::__construct(): [2002] No such file or directory (trying to
connect via unix:///tmp/mysql.sock) in
/opt/lampp/htdocs/egroupware/phpgwapi/inc/class.sqlfs_stream_wrapper.inc.php
on line 1435, referer
:
http://localhost/egroupware/index.php?menuaction=calendar.calendar_uiviews.day&date=20100214
After an hour or so of flailing around, the final resolution to fix this
issue was to hard code the following
/opt/lampp/etc/php.ini
mysql.default_socket = /tmp/mysql.sock
– NOTE: mysql.default_socket = originally was blank in the php.ini file
/opt/lampp/etc/my.cnf
[client]
socket = /tmp/mysql.sock
[mysqld]
socket = /tmp/mysql.sock
– NOTE: Both above socket = locations prior to the edit was
/opt/lampp/var/mysql/mysql.sock
Before I had set all three line items to /tmp/mysql.sock I had attempted
to set the php.ini mysql.default_socket =
/opt/lampp/var/mysql/mysql.sock. Unfortunately, this didn’t work.
It is my hope that this will help someone else having this issue.
Joseph Hume
F1 for HELP
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
