Hi guys, i am running ISPConfig 3 with ubuntu18.04 When i open phpmyadmin and i want to import a database i get the following error: Code: OpenSSL error: error:0906D06C:PEM routines:PEM_read_bio:no start line and then the following error: Code: Warning in ./libraries/plugin_interface.lib.php#551 [IMG]http://server3.cl-i.net/phpmyadmin/themes/dot.gif[/IMG] count(): Parameter must be an array or an object that implements Countable Backtrace ./libraries/display_import.lib.php#371: PMA_pluginGetOptions( string 'Import', array, ) ./libraries/display_import.lib.php#456: PMA_getHtmlForImportOptionsFormat(array) ./libraries/display_import.lib.php#691: PMA_getHtmlForImport( string '5d065412cdb0e', string 'database', string 'c1wppass', string '', integer 2097152, array, NULL, NULL, string '', ) ./db_import.php#43: PMA_getImportDisplay( string 'database', string 'c1wppass', string '', integer 2097152, ) When login to mysql admin i get this error: Code: [IMG]http://server3.cl-i.net/phpmyadmin/themes/dot.gif[/IMG] The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why. Or alternately go to 'Operations' tab of any database to set it up there. the same errors i get with every installation of ISPConfig 3, so maybe anyone could help me how to resolve this? thanks in advance for your kind help
https://www.howtoforge.com/community/threads/please-read-before-posting.58408/ How many installations? Do you mean every time you install ISPConfig 3 you end up with that same error? How are those ubuntu and ispconfig installed? Which guide or tutorial was used? Have you checked twice you really have installed following the guide? Is httpS used when accessing PHPMyadmin? Are the certificates OK? Is there something additional installed, something not mentioned in ISPConfig installation guide? Or configuration changed? Try Code: systemctl --state=failed to see if any services are failing to run.
That's a bug in the Ubuntu phpmyadmin package: https://stackoverflow.com/questions...t-be-an-array-or-an-object-that-implements-co
It works, thank you so much. May i ask another question: when i try the code : Code: systemctl --state=failed i get the following output: Code: UNIT LOAD ACTIVE SUB DESCRIPTION ● certbot.service loaded failed failed Certbot ● systemd-networkd-wait-online.service loaded failed failed Wait for Network to be Configured how can i resolve this? here is the testscript of ISPConfig: Code: root@server4:~# cat htf_report.txt | more ##### SERVER ##### IP-address (as per hostname): ***.***.***.*** [WARN] could not determine server's ip address by ifconfig [INFO] ISPConfig is installed. ##### ISPCONFIG ##### ISPConfig version is 3.1.13p1 ##### VERSION CHECK ##### [INFO] php (cli) version is 7.2.17-0ubuntu***.***.***.*** ##### PORT CHECK ##### ##### MAIL SERVER CHECK ##### ##### RUNNING SERVER PROCESSES ##### [INFO] I found the following web server(s): Apache 2 (PID 8771) [INFO] I found the following mail server(s): Unknown process (smtpd) (PID 4227) [INFO] I found the following pop3 server(s): Dovecot (PID 7232) [INFO] I found the following imap server(s): Dovecot (PID 7232) [INFO] I found the following ftp server(s): PureFTP (PID 7295) ##### LISTENING PORTS ##### (only () Local (Address) [anywhere]:110 (7232/dovecot) [anywhere]:143 (7232/dovecot) [anywhere]:8080 (8771/apache2) [anywhere]:80 (8771/apache2) [anywhere]:8081 (8771/apache2) [anywhere]:465 (7189/master) ***.***.***.***:53 (7302/named) [localhost]:53 (7302/named) [anywhere]:21 (7295/pure-ftpd) ***.***.***.***:53 (437/systemd-resolve) [anywhere]:22 (513/sshd) [localhost]:953 (7302/named) [anywhere]:25 (4227/smtpd) [anywhere]:443 (8771/apache2) [anywhere]:993 (7232/dovecot) [anywhere]:995 (7232/dovecot) [localhost]:10024 (7219/amavisd-new) [anywhere]:9000 (31366/hhvm) [localhost]:10025 (7189/master) [localhost]:10026 (7219/amavisd-new) [localhost]:10027 (7189/master) [anywhere]:587 (7189/master) [localhost]:11211 (6498/memcached) [localhost]10 (7232/dovecot) [localhost]43 (7232/dovecot) *:*:*:*::*:465 (7189/master) *:*:*:*::*:53 (7302/named) *:*:*:*::*:21 (7295/pure-ftpd) *:*:*:*::*:22 (513/sshd) *:*:*:*::*:25 (4227/smtpd) *:*:*:*::*:993 (7232/dovecot) *:*:*:*::*:995 (7232/dovecot) *:*:*:*::*:3306 (6860/mysqld) *:*:*:*::*:587 (7189/master) ##### IPTABLES ##### Chain INPUT (policy ACCEPT) target prot opt source destination f2b-dovecot-pop3imap tcp -- [anywhere]/0 [anywhere]/0 multiport dports 110,995,143,993 f2b-sshd tcp -- [anywhere]/0 [anywhere]/0 multiport dports 22 Chain FORWARD (policy ACCEPT) target prot opt source destination Chain OUTPUT (policy ACCEPT) target prot opt source destination Chain f2b-dovecot-pop3imap (1 references) target prot opt source destination RETURN all -- [anywhere]/0 [anywhere]/0 Chain f2b-sshd (1 references) target prot opt source destination RETURN all -- [anywhere]/0 [anywhere]/0 thanks a lot for your kind help every time
Certbot service is not used or required by ispconfig. ISPConfig uses its own cron scripts to renew let's encrypt certificates. You can try to disable the certbot service using systemctl command. Regarding the other service, as you probably have a working network at the moment, this service seems to be not required as well. But not sure how it will affect the bootup process of your system, so I would just leave it as it is.
thanks for your kind help. the error of the library is fixed. i still have 2 other errors. maybe you can help? Code: [IMG]http://server3.cl-i.net/phpmyadmin/themes/dot.gif[/IMG] The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why. Or alternately go to 'Operations' tab of any database to set it up there. and Code: OpenSSL error: error:140E0197:SSL routines:SSL_shutdown:shutdown while in init maybe you have an idea how to fix that? thanks a lot
