Also tried that, and didn't find any possible fixes. Ultimately I started a new droplet from a backup snapshot, and implemented SFTP instead. Remote file editing is working smoothly with this method.
Thanks @Gideon So for your suggestions.
Thanks for your suggestion. I just restarted the droplet and that didn't solve the issue unfortunately.
I just checked the status for MySQL and it says:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Then I tried to reinstall MySQL and it's still showing that it fails to start.
Perhaps related?
Hi! Looking for help debugging what went wrong.
I have a ProcessWire site hosting remotely on a DigitalOcean droplet, and I wanted to open and edit some files on my local machine. I use Sublime so I installed rsub following these instructions.
Then I opened up my site at its usual domain and I see the following error:
Oops… Error: Exception: SQLSTATE[HY000] [2002] No such file or directory (in wire/core/WireDatabasePDO.php line 509)
#0 wire/core/WireDatabasePDO.php (509): PDO->__construct()
#1 wire/core/WireDatabasePDO.php (872): WireDatabasePDO->pdoWriter()
#2 wire/core/WireSaveableItems.php (219): WireDatabasePDO->prepare()
#3 wire/core/Wire.php (416): WireSaveableItems->___load()
#4 wire/core/WireHooks.php (968): Wire->_callMethod()
#5 wire/core/Wire.php (484): WireHooks->runHooks()
#6 wire/core/Fields.php (285): Wire->__call()
#7 wire/core/Fields.php (172): Fields->getWireArray()
#8 wire/core/ProcessWire.php (625): Fields->init()
#9 wire/core/ProcessWire.php (578): ProcessWire->initVar()
#10 wire/core/ProcessWire.php (315): ProcessWire->load()
#11 index.php (52): ProcessWire->__construct()
#12 {main}
This error message was shown because: site is in debug mode. ($config->debug = true; => site/config.php). Error has been logged.
I'm not sure where to go from here! Any advice would be very appreciated.