Hi, I have a problem with an already running ispconfig 3. I cannot login through the login panel now. I can open PHP my admin but it always says error mysql 1045. however I can login using mysql -u 'username' -p I have looked at various log it seems the problem is about connecting to the database. I changed the config.inc.php in both /usr/local/ispconfig/interface/lib and /usr/local/ispconfig/server/lib to reflect the current mysql password. FYI : my server was just ddos'ed by another person and this happens Tried all kinds of stuff but at a loss right now. Please help. Regards, Ray
Do not change the mysql password of the ispconfig user in these files manually. If you want to set a password in mysql,take the password that is inserted into the files by the ispconfig installer and set this password in mysql. So the other way round as you did it. The password is used in many more files and if you alter it manually, most parts of the system will start to fail. After you restored the files, we can strt to search for your original problem: post the output of: nestat -tap | grep mysql
How do I do that manually? I am using ispconfig 3.0.3.2 netstat shows : tcp 0 0 localhost.localdo:mysql *:* LISTEN 27716/mysqld
I tried and cannot do anything. It still shows cannot connect. How do I reset my main user/password for mysql for ispconfig? Is there a script I can use? I can't even do an install script for upgrading because it somehow cannot connect to mysql. php -q update.php shows : Code: | | \ `--.| |_/ / | / \/ ___ _ __ | |_ _ __ _ _/ / | | `--. \ __/ | | / _ \| '_ \| _| |/ _` | |_ | _| |_/\__/ / | | \__/\ (_) | | | | | | | (_| | ___\ \ \___/\____/\_| \____/\___/|_| |_|_| |_|\__, | \____/ __/ | |___/ -------------------------------------------------------------------------------- >> Update Operating System: Debian 6.0 (Squeeze/Sid) or compatible This application will update ISPConfig 3 on your server. Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]: Creating backup of "/usr/local/ispconfig" directory... Creating backup of "/etc" directory... Unable to connect to mysql server Access denied for user 'root'@'localhost' (using password: NO) MySQL root password [1234567]: 1234567 Unable to connect to mysql server Access denied for user 'root'@'localhost' (using password: NO) MySQL root password [1234567]: PS : I use 1234567 for security's sake
Found out what's wrong. It turns out the mysql safe mode is messing around with ispconfig. I've been hardening the server and turning it off makes it ok for me to log in. Can I do PHP safe mode with ispconfig?
Hi... I got this error persist After follow tutorial from https://www.howtoforge.com/tutorial...-stretch-apache-bind-dovecot-ispconfig-3-1/3/ every step, I cannot login into fresh install of ISPConfig.3 Here is my netstat -tap Code: root@srv001-sg:/usr/local/ispconfig/interface# netstat -tap Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 0.0.0.0:imap2 0.0.0.0:* LISTEN 930/dovecot tcp 0 0 0.0.0.0:urd 0.0.0.0:* LISTEN 1357/master tcp 0 0 0.0.0.0:ftp 0.0.0.0:* LISTEN 1383/pure-ftpd (SER tcp 0 0 10.130.88.163:domain 0.0.0.0:* LISTEN 787/named tcp 0 0 10.15.0.6:domain 0.0.0.0:* LISTEN 787/named tcp 0 0 srv001-sg.srv.in:domain 0.0.0.0:* LISTEN 787/named tcp 0 0 localhost:domain 0.0.0.0:* LISTEN 787/named tcp 0 0 0.0.0.0:ssh 0.0.0.0:* LISTEN 870/sshd tcp 0 0 0.0.0.0:smtp 0.0.0.0:* LISTEN 1357/master tcp 0 0 localhost:953 0.0.0.0:* LISTEN 787/named tcp 0 0 0.0.0.0:imaps 0.0.0.0:* LISTEN 930/dovecot tcp 0 0 0.0.0.0:pop3s 0.0.0.0:* LISTEN 930/dovecot tcp 0 0 localhost:10023 0.0.0.0:* LISTEN 1040/postgrey --pid tcp 0 0 localhost:10024 0.0.0.0:* LISTEN 1366/amavisd-new (m tcp 0 0 localhost:10025 0.0.0.0:* LISTEN 1357/master tcp 0 0 localhost:10026 0.0.0.0:* LISTEN 1366/amavisd-new (m tcp 0 0 localhost:10027 0.0.0.0:* LISTEN 1357/master tcp 0 0 0.0.0.0:submission 0.0.0.0:* LISTEN 1357/master tcp 0 0 localhost:11211 0.0.0.0:* LISTEN 834/memcached tcp 0 0 0.0.0.0:pop3 0.0.0.0:* LISTEN 930/dovecot tcp 0 0 localhost:44902 localhost:imap2 TIME_WAIT - tcp 0 0 srv001-sg.srv.indod:ssh mx-ll-180.183.139:41986 ESTABLISHED 2617/sshd: goltogel tcp 0 0 localhost:39030 localhost:mysql ESTABLISHED 2514/sshd: goltogel tcp 0 0 srv001-sg.srv.indod:ssh mx-ll-180.183.139:51778 ESTABLISHED 2498/sshd: goltogel tcp 0 0 localhost:39086 localhost:mysql ESTABLISHED 3469/amavisd-new (c tcp 0 0 localhost:52628 localhost:ftp TIME_WAIT - tcp 0 4652 srv001-sg.srv.indod:ssh mx-ll-180.183.139:52098 ESTABLISHED 3424/sshd: goltogel tcp 61 0 localhost:54822 localhost:10025 CLOSE_WAIT 3469/amavisd-new (c tcp 0 848 srv001-sg.srv.indod:ssh cognize.co:57486 ESTABLISHED 6955/sshd: [accepte tcp6 0 0 [::]:imap2 [::]:* LISTEN 930/dovecot tcp6 0 0 [::]:http [::]:* LISTEN 1033/apache2 tcp6 0 0 [::]:http-alt [::]:* LISTEN 1033/apache2 tcp6 0 0 [::]:urd [::]:* LISTEN 1357/master tcp6 0 0 [::]:tproxy [::]:* LISTEN 1033/apache2 tcp6 0 0 [::]:ftp [::]:* LISTEN 1383/pure-ftpd (SER tcp6 0 0 [::]:domain [::]:* LISTEN 787/named tcp6 0 0 [::]:ssh [::]:* LISTEN 870/sshd tcp6 0 0 [::]:smtp [::]:* LISTEN 1357/master tcp6 0 0 ip6-localhost:953 [::]:* LISTEN 787/named tcp6 0 0 [::]:https [::]:* LISTEN 1033/apache2 tcp6 0 0 [::]:imaps [::]:* LISTEN 930/dovecot tcp6 0 0 [::]:pop3s [::]:* LISTEN 930/dovecot tcp6 0 0 ip6-localhost:10024 [::]:* LISTEN 1366/amavisd-new (m tcp6 0 0 ip6-localhost:10026 [::]:* LISTEN 1366/amavisd-new (m tcp6 0 0 [::]:mysql [::]:* LISTEN 1234/mysqld tcp6 0 0 [::]:submission [::]:* LISTEN 1357/master tcp6 0 0 [::]:pop3 [::]:* LISTEN 930/dovecot tcp6 0 0 localhost:mysql localhost:39030 ESTABLISHED 1234/mysqld tcp6 0 0 localhost:mysql localhost:39086 ESTABLISHED 1234/mysqld
What does Code: systemctl status mysql show? https://www.howtoforge.com/community/threads/please-read-before-posting.58408/
