Plesk Bug Fixing
- or -
Post a project like this3375
€20/hr(approx. $21/hr)
- Posted:
- Proposals: 7
- Remote
- #650662
- Awarded
PHP | Mysql | Ajax | Smarty | Opencart | Moodle | Concrete5 | Wordpress | X-cart | Magento | SEO | Mobile apps
Rajkot
Top Shopify Developer ,WordPress, React.js, Next.js, Node.JS, Laravel, Express.js, Vue.js, Mongo DB, Expert ( PHP MySQL ).
Dallas
23158172411328767405229642456815316837364
Description
Experience Level: Intermediate
General information for the website: Business Consulting
Database management system (DBMS): MySQL
Description of requirements/features: Here is the description / fix I need in the wording from parallels support desk
It can be found at: http://kb.sp.parallels.com/en/120312
Symptoms
Plesk Panel dysplays the below error upon logging in:
ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory
Cause
Plesk PHP configuration file contains incorrect option for pdo_mysql socket file (or one of the include files does so):
[root@~]# grep pdo_mysql /usr/local/psa/admin/conf/php.ini
pdo_mysql.default_socket = /var/run/mysqld/mysqld.sock
Resolution
Find out the current location for the mysql.sock file:
# ps ax | grep mysql.sock | grep -v grep
21731 pts/1 S 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
22046 pts/1 Sl 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
Make sure that /usr/local/psa/admin/conf/php.ini' contains the same socket option as specified in '/etc/my.cnf':
# grep socket /etc/my.cnf
socket=/var/lib/mysql/mysql.sock
Also check the file '/etc/psa/psa.conf' for the same option:
# grep -i socket /etc/psa/psa.conf
MYSQL_SOCKET /var/lib/mysql/mysql.sock
Restart sw-cp-server:
/etc/init.d/sw-engine restart
/etc/init.d/sw-cp-server restart
Search words:
ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory (Abstract.php:144)
Extra notes: I am using a virtual server / Linux from Strato.de.
Next to the fix above I would need (ongoing) quality checks on my server settings.
Database management system (DBMS): MySQL
Description of requirements/features: Here is the description / fix I need in the wording from parallels support desk
It can be found at: http://kb.sp.parallels.com/en/120312
Symptoms
Plesk Panel dysplays the below error upon logging in:
ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory
Cause
Plesk PHP configuration file contains incorrect option for pdo_mysql socket file (or one of the include files does so):
[root@~]# grep pdo_mysql /usr/local/psa/admin/conf/php.ini
pdo_mysql.default_socket = /var/run/mysqld/mysqld.sock
Resolution
Find out the current location for the mysql.sock file:
# ps ax | grep mysql.sock | grep -v grep
21731 pts/1 S 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
22046 pts/1 Sl 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
Make sure that /usr/local/psa/admin/conf/php.ini' contains the same socket option as specified in '/etc/my.cnf':
# grep socket /etc/my.cnf
socket=/var/lib/mysql/mysql.sock
Also check the file '/etc/psa/psa.conf' for the same option:
# grep -i socket /etc/psa/psa.conf
MYSQL_SOCKET /var/lib/mysql/mysql.sock
Restart sw-cp-server:
/etc/init.d/sw-engine restart
/etc/init.d/sw-cp-server restart
Search words:
ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory (Abstract.php:144)
Extra notes: I am using a virtual server / Linux from Strato.de.
Next to the fix above I would need (ongoing) quality checks on my server settings.
Axel H.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
40%
Last project
3 Jan 2015
Germany
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies