I just set up ISPConfig with the auto installer. I'm trying to import one of my old databases in via phpmyadmin and I have two issues: I get this error when I click on the import tab - If I hit the ignore button and proceed with the import, it acts like it's working and gives me the message "you've successfully imported the database" but the database isn't there. No tables or data are imported at all. Any help would be greatly appreciated.
That error message looks like there are incompatible versions of applications and PHP. Follow this as first thing: https://www.howtoforge.com/community/threads/please-read-before-posting.58408/ How did you set up ISPConfig? Following which Guide or Tutorial?
That automated script is know to make a not working ISPConfig setup without showing any errors. There are previous discussions on that in this forum, searchable with Internet Search Engines. I repeat: https://www.howtoforge.com/community/threads/please-read-before-posting.58408/
Doing that gives me this: ##### SERVER ##### IP-address (as per hostname): ***.***.***.*** [WARN] could not determine server's ip address by ifconfig [INFO] OS version is Ubuntu 18.04.3 LTS [INFO] ISPConfig is installed. ##### ISPCONFIG ##### ISPConfig version is 3.1.15p2 ##### VERSION CHECK ##### [INFO] php (cli) version is 7.2.24-0ubuntu***.***.***.*** ##### PORT CHECK ##### [WARN] Port 465 (SMTP server SSL) seems NOT to be listening ##### MAIL SERVER CHECK ##### [WARN] I found no "submission" entry in your postfix master.cf [INFO] this is not critical, but if you want to offer port 587 for smtp connecti ons you have to enable this. [WARN] I found no "smtps" entry in your postfix master.cf [INFO] this is not critical, but if you want to offer SSL for smtp (not TLS) con nections you have to enable this. ##### RUNNING SERVER PROCESSES ##### [INFO] I found the following web server(s): Apache 2 (PID 2655) [INFO] I found the following mail server(s): Postfix (PID 29808) [INFO] I found the following pop3 server(s): Dovecot (PID 18708) [INFO] I found the following imap server(s): Dovecot (PID 18708) [INFO] I found the following ftp server(s): PureFTP (PID 32229) ##### LISTENING PORTS ##### (only () Local (Address) [localhost]:10023 (4292/postgrey) [localhost]:10024 (18689/amavisd-new) [localhost]:10025 (29808/master) [localhost]:3306 (1334/mysqld) [localhost]:10026 (18689/amavisd-new) [localhost]:10027 (29808/master) [localhost]:11211 (5136/memcached) [anywhere]:110 (18708/dovecot) [anywhere]:143 (18708/dovecot) [anywhere]:21 (32229/pure-ftpd) ***.***.***.***:53 (18864/named) [localhost]:53 (18864/named) ***.***.***.***:53 (3577/systemd-resolv) [anywhere]:22 (1374/sshd) [localhost]:631 (26610/cupsd) [anywhere]:25 (29808/master) [localhost]:953 (18864/named) [anywhere]:993 (18708/dovecot) [anywhere]:995 (18708/dovecot) *:*:*:*::*:10024 (18689/amavisd-new) *:*:*:*::*:10026 (18689/amavisd-new) [localhost]10 (18708/dovecot) [localhost]43 (18708/dovecot) *:*:*:*::*:8080 (2655/apache2) *:*:*:*::*:80 (2655/apache2) *:*:*:*::*:8081 (2655/apache2) *:*:*:*::*:21 (32229/pure-ftpd) *:*:*:*::*:53 (18864/named) *:*:*:*::*:22 (1374/sshd) *:*:*:*::*:631 (26610/cupsd) *:*:*:*::*:25 (29808/master) *:*:*:*::*:953 (18864/named) *:*:*:*::*:443 (2655/apache2) *:*:*:*::*:993 (18708/dovecot) *:*:*:*::*:995 (18708/dovecot) ##### IPTABLES ##### Chain INPUT (policy ACCEPT) target prot opt source destination f2b-pureftpd tcp -- [anywhere]/0 [anywhere]/0 multiport dports 21 Chain FORWARD (policy ACCEPT) target prot opt source destination Chain OUTPUT (policy ACCEPT) target prot opt source destination Chain f2b-pureftpd (1 references) target prot opt source destination RETURN all -- [anywhere]/0 [anywhere]/0
OK, I got that issue fixed by upgrading to the phpmyadmin 4.9 version. (It was on 4.6). Now I don't get any errors, but when I try to import my database it goes through the motions, says it imported it but none of the tables and data are there.
