ISPConfig 3 has been running so flawlessly for over 2 years that I forgot I even installed it. So today I went to install something in Apache and it required MySQL, and I couldn't do the Thing without a MySQL password, so I changed it...and now everything in ISPConfig 3 is completely broken. POP/IMAP not working, can't log in to the portal, the whole server is thrashed. I'm sure it's something simple like "change the MySQL password in This Here Config File" or "reset the MySQL password to ____" or something like that and I'll be back to normal, but could someone please tell me what that is I need to do here? Thanks!
Really? This has never happened? Ever? The latest: changing the password to null doesn't work, neither does changing it to its old password. Basically, I have completely screwed myself by not having a backup, or knowing how to restore or even being a responsible adult. I'm just surprised I'm the first person in history to experience this level of shame and disgust.
can you connect to mysql: mysql -u root -h localhost -p and mysql -u ispconfig -h localhost -p (see server/lib/config.inc.php for the password)
petern@toolbox:~$ mysql -u root -h localhost -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) petern@toolbox:~$ Says that for the ispconfig user as well. I double-checked the password and I'm typing it in correctly.
Wait, I read the wrong file, sorry. The password in config.inc.php looks like some kind of hashed or encrypted password? I won't print it here, but I can't verify that's the password. However, if I su to ispconfig it's the password I remember and works fine.
OK, enough. This server is stone dead, I haven't received mail and this can't go on. How do I "unwind" ISPConfig and at least let mail spool (it's bouncing right now)? seriously, I'm done with this. How do I uninstall it? This is unreasonable: over a MONTH to get SOMETHING to help?
Your problem is not related to ISPConfig, so uninstalling it won't help at all. Your problem is that your mysql server is not working and that's why your mail's bounce and why you can't login with any mysql user nor login to ISPConfig. Restart mysql and if it is still not running agan then take a look at the syslog fle to find out why mysql fails. No, that's the cleartext password. But the password is not your problem.
And btw. This here is the ISPConfig community forum and not the ISPConfig support. When you need help urgently, then contact the support team: http://www.ispconfig.org/get-support/?type=ispconfig
OK, I get it. I'm sorry for being "that guy" in the community forum, it wasn't what I intended and didn't realize support was Elsewhere. As I said, I've been using this for 3 years and haven't had one single glitch, so I've never needed to be here. Having re-read your posts, I'm inclined to think the mysql itself has become corrupted, because it won't even run. If I back up /var/lib/mysql/dbispconfig, can I just blow away mysql and reinstall it? Would it then be trivial to restore the backup and be up and running again? Thanks in advance, and sorry for my rudeness.
SOLVED. OK, so we can all learn a lesson and future users won't run into this problem again, here's what I learned: In the process of trying to start mysql manually, I got an error that the disk containing /var/lib/mysql was full. It wasn't. I looked at the directory, and it wasn't mysql, it was mysqld. I don't recall renaming it. That was part 1. So then I tried starting it manually and the mysql log said: 171129 23:22:48 [ERROR] /usr/sbin/mysqld: unknown variable 'detail0=$OWD' No idea what that is, but it obviously won't do anything but generate an error. I commented out that line and myswl started, I can log into ISPConfig just like always and mail is working again. tl;dr: something renamed /var/lib/mysql and added a line to my.cnf that does nothing Thanks.
