When accessing Centova Cast I see the following error message:
Warning: stream_socket_client(): unable to connect to localhost:465 (Connection refused) in /usr/local/centovacast/system/PEAR/Net/Socket.php on line 159
What does this mean and how do I fix it?
This means that Centova Cast cannot connect to your database for some reason.
Possible causes for this include:
Your MySQL server isn't running. Start your MySQL server to fix this.
You specified the wrong IP address or hostname for MySQL, or the IP address/hostname has changed. Edit
/usr/local/centovacast/etc/centovacast.confand make sure the
DB_HOSToption is set correctly.
Your MySQL server is listening on a UNIX domain socket at an unusual location, and Centova Cast was unable to detect the UDS location during installation.
To find your UDS path, try running:
ps aux | grep mysql | grep socket
You should see something like:
mysql 1945 0.1 12.8 562728 32792 ? Sl Mar04 182:31 /usr/sbin/mysqld --socket=/var/run/mysqld/mysqld.sock --pid-file=/var/run/mysqld/mysqld.pid
The UDS path specified after the
--socketparameter; i.e., in the above example it's
/var/run/mysqld/mysqld.sock. If the command above does not display the UDS path, you'll need to find your MySQL configuration file (usually
/etc/mysql/my.cnf) and look inside it for the
/usr/local/centovacast/etc/cc-system.confand make sure the
mysql.default_socketoption is set to the correct UDS path.