Changed MySQL password, now everything's broken

Discussion in 'General' started by zlurg, Oct 20, 2017.

  1. zlurg

    zlurg New Member

    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!
     
  2. zlurg

    zlurg New Member

    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.
     
  3. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    du you have a localhost assign to 127.0.0.1 in /etc/hosts?
     
  4. zlurg

    zlurg New Member

    Yes.
     
  5. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    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)
     
  6. zlurg

    zlurg New Member

    [email protected]:~$ 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)
    [email protected]:~$

    Says that for the ispconfig user as well.

    I double-checked the password and I'm typing it in correctly.
     
  7. zlurg

    zlurg New Member

    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.
     
  8. zlurg

    zlurg New Member

    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?
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

  11. zlurg

    zlurg New Member

    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.
     
  12. zlurg

    zlurg New Member

    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.
     
    till likes this.

Share This Page