• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

Resolved Can't connect after server reset - locked out via ftp

Brad Mehlenbacher

New Pleskian
Hey guys, so the company I'm doing work with runs a dedicated server. Earlier today we were getting internal error 500s - likely due to lack of space. We reset the server, but upon restarting the server gave the following error:

ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory

ERROR: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] No such file or directory' in /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:129 Stack trace: #0 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:dbname=ps...', 'admin', '$AES-128-CBC$Nk...', Array) #1 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() #2 /opt/psa/admin/externals/Zend/Db/Adapter/Abstract.php(460): Zend_Db_Adapter_Pdo_Mysql->_connect() #3 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('select param, v...', Array) #4 /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(30): Zend_Db_Adapter_Pdo_Abstract->query('select param, v...', Array) #5 /opt/psa/admin/plib/db.php(36): Db_Adapter_Pdo_Mysql->query('select param, v...') #6 /opt/psa/admin/plib/db.php(212): db_query('select param, v...', false) #7 /opt/psa/admin/plib/Plesk/Mode.php(423): get_param('disable_provisi...') #8 /opt/psa/admin (Abstract.php:144)
Now please note that we were running very low on space before the reset - but now that we've reset I can't connect via the :8443 port at all, every time I try I get that error.

Any time I try to connect to the site itself I get:

Error establishing a database connection

I've tried connecting via FTP, but with my current login it isn't giving me permission, stating that I have to use my plex login. Any time I try to connect via my user login for plex, it does not connect.

Now I've got a few questions:

1) Has anybody ever had anything remotely similar to this happen to them? What did you do?
2) Does plex ftp connect differently to their hosted directory than the actual server itself would? Any reason why my plex login wouldnt work via ftp if it's stating in filezilla that I have to use that login? (Note that it says a different name than my actual login as permission, but similar)

Thank you for any help you guys may be able to provide, sincerely appreciate it!
 
Back
Top