Error: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (13) on database: sphinx

[Former user]

Hi,

I use centos 6.4 Piler configuration: piler -V piler 0.1.23, build 789, Janos SUTO [e-mail]

Build Date: Fri Aug 16 05:57:45 EDT 2013 ldd version: ldd (GNU libc) 2.12 gcc version: gcc version 4.4.7 20120313 (Red Hat 4.4.7-3) (GCC) Configure command: ./configure --localstatedir=/var --enable-starttls --enable-tcpwrappers

rc.piler and rc.searchd started, both connected to mysql

Is it compatible with mariadb-server-5.5.32-1.el6.x86_64? How can i see all errors (php errors enabled, but see nothing)?

When i open website i see following error: Error: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (13) on database: sphinx

[Janos SUTO]

yes, piler is compatible with mariadb, too.

The php errors could be either sent to syslog or logged to a file. Check your php.ini to determine which is set. If none, then set the following, and restart your webserver:

error_log = /var/log/phplog

I think searchd is not running, or using a wrong config file. Please show me netstat -an|grep 93

[s s]

it was selinux rule, so i just changed it.

Thank you for the quick responce

[Janos SUTO]

If you had fixed it by adding / changing a selinux rule, then I'd be glad to include it in the FAQ section.