I am migrating to a new machine (Debian Stretch) using your Moving ISPConfig tutorial. I cannot login to ISPConfig using admin:admin. Possibly this is because I used mysqldump --all-databases from the old machine which used to work in the past. The old machine is running v3.1.11 The old machine's password won't work either. Deleting the admin password in the sys_user table has no effect. The only obvious error is that the ISPConfig title is missing from the login form.
Have you tried cleaning browser cache? Also this thread: https://www.howtoforge.com/community/threads/cannot-login-to-ispconfig-admin-panel.48055/
Thanks for the help. Sorry I couldn't respond yesterday, I had to deal with fires in another part of the empire! It's now running, not sure what was wrong. I made one error, I thought that if I deleted the password in sys_user table the login would default to admin:admin. I copied over the password from the old system and all is now working. I had checked the hash before I deleted it and it looked correct, so not sure what was going on. I even have the ISPC banner back on the login form. Must have been a gremlin! Spoke too soon! Can't login to ISPConfig and I get 2 error messages from phpmyadmin:- Code: mysqli_real_connect() (HY000/1025) Access denied for user 'phpmyadmin@localhost' (using password YES) Code: Connection for controluser as defined in your configuration failed Apart from that phpmyadmin functions normally, I can read and edit all tables. If I try to reset the admin password to default using: Code: UPDATE sys_user SET passwort=md5('admin') WHERE username=@admin'; the response is Code: #1054 Unknown column 'admin' in 'where clause'
