phpmyadmin error

Discussion in 'ISPConfig 3 Priority Support' started by Tom John, Jun 16, 2019.

  1. Tom John

    Tom John Member HowtoForge Supporter

    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
     
    Last edited: Jun 16, 2019
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

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

    till Super Moderator Staff Member ISPConfig Developer

  4. Tom John

    Tom John Member HowtoForge Supporter

    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:
    [email protected]:~# 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
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  6. Tom John

    Tom John Member HowtoForge Supporter

    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
     

Share This Page