the problem with SSL

After restore from Backups all sites with Mysql write:
"Error connection to database"
 
The error "Oshibka podklyucheniya (2002) No such file or directory" has nothing to do with SSL. It's most likely an application level error on PHP or MySQL side.

Check web-server logs for more information. We don't know what you run there... custom written PHP, perl code. Text of the error does not look common or familiar for any good known CMS.
 
It's probably related to MySQL. The issue might be related to mysql.sock which changed it's location and you need to adjust PHP configs and point it to the right location of mysql.sock.
 
zEitEr said:
It's probably related to MySQL. The issue might be related to mysql.sock which changed it's location and you need to adjust PHP configs and point it to the right location of mysql.sock.
Click to expand...

This is standart:

# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
 
Code: 
Configure Command =>  './configure'  '--prefix=/usr/local/php53' '--program-suffix=53' '--with-config-file-scan-dir=/usr/local/php53/lib/php.conf.d' '--with-curl=/usr/local/lib' '--with-gd' '--enable-gd-native-ttf' '--with-gettext' '--with-jpeg-dir=/usr/local/lib' '--with-freetype-dir=/usr/local/lib' '--with-libxml-dir=/usr/local/lib' '--with-kerberos' '--with-openssl' '--with-mcrypt' '--with-mhash' '--with-mysql=mysqlnd' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-mysqli=mysqlnd' '--with-pcre-regex=/usr/local' '--with-pdo-mysql=mysqlnd' '--with-pear' '--with-png-dir=/usr/local/lib' '--with-xsl' '--with-zlib' '--with-zlib-dir=/usr/local/lib' '--enable-zip' '--with-iconv=/usr/local' '--enable-bcmath' '--enable-calendar' '--enable-ftp' '--enable-sockets' '--enable-soap' '--enable-mbstring' '--with-icu-dir=/usr/local/icu' '--enable-intl'
mysql.default_socket => /var/lib/mysql/mysql.sock => /var/lib/mysql/mysql.sock
mysqli.default_socket => /var/lib/mysql/mysql.sock => /var/lib/mysql/mysql.sock
pdo_mysql.default_socket => /var/lib/mysql/mysql.sock => /var/lib/mysql/mysql.sock

Code: 
[root@sun public_html]# file /var/lib/mysql/mysql.sock
/var/lib/mysql/mysql.sock: socket
 
That's only a guess that PHP can not connect to MySQL. You need to verify it yourself. Use a custom script with

PHP: 
error_reporting(E_ALL);
ini_set('display_errors',1);

and try to connect to to MySQL. The script has no instructions to connect to MySQL, you should add by yourself... it only makes errors to be shown.

Are connection from console to MySQL successful?

Code: 
mysql
?

p.s. If I had an access to your server I could investigate the incident within 5-15 and suggest a fix.
 
[root@sun mysql]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@sun mysql]#
 
You need to check all installed PHP versions, you can list them with:

Code: 
ls -1 /usr/local/php*/bin/php


and debug PHP scripts further if it's not a MySQL related issue.
 
Before this the operation is going well. Now the error in the error. Do all the same.
 
I wonder why do you expect to solve an issue by re-installing a server?

I'm sure it took much more time to reinstall a server and restore backups... and if you tried to debug the PHP scripts as I suggested... you would have the sites running now.
 
You must log in or register to reply here.
Back
Top