Cannot login after fresh installation

Discussion in 'Installation/Configuration' started by jakrla, Nov 23, 2023.

  1. jakrla

    jakrla New Member

    Just finished a Perfect Server Automated ISPConfig 3 Installation on Ubuntu 22.04. There were no reported issues during installation. However, for some reason i cannot login with given admin password ("Username or Password wrong.") (MySQL password, by contrast, works fine)
    Any idea how could I circumvent this? All hints are highly appreciated...

    Code:
    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    [WARN] could not determine server's ip address by ifconfig
    [INFO] OS version is Ubuntu 22.04.3 LTS
     
    [INFO] uptime:  20:50:23 up 10 min,  1 user,  load average: 0.00, 0.02, 0.00
     
    [INFO] memory:
                   total        used        free      shared  buff/cache   available
    Mem:            29Gi       1.7Gi        27Gi        59Mi       343Mi        27Gi
    Swap:             0B          0B          0B
     
    [INFO] systemd failed services status:
      UNIT                                 LOAD   ACTIVE SUB    DESCRIPTION
    ● systemd-networkd-wait-online.service loaded failed failed Wait for Network to be Configured
    
    LOAD   = Reflects whether the unit definition was properly loaded.
    ACTIVE = The high-level unit activation state, i.e. generalization of SUB.
    SUB    = The low-level unit activation state, values depend on unit type.
    1 loaded units listed.
    
    [INFO] ISPConfig is installed.
    
    ##### ISPCONFIG #####
    ISPConfig version is 3.2.11p1
    
    
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 8.1.25
    [INFO] php-cgi (used for cgi php in default vhost!) is version 8.1.25
    
    ##### PORT CHECK #####
    
    
    ##### MAIL SERVER CHECK #####
    
    
    ##### RUNNING SERVER PROCESSES #####
    
    [INFO] I found the following web server(s):
        Apache 2 (PID 764)
    [INFO] I found the following mail server(s):
        Postfix (PID 1747)
    [INFO] I found the following pop3 server(s):
        Dovecot (PID 1154)
    [INFO] I found the following imap server(s):
        Dovecot (PID 1154)
    [INFO] I found the following ftp server(s):
        PureFTP (PID 807)
    
    ##### LISTENING PORTS #####
    (only        ()
    Local        (Address)
    [localhost]:11334        (1157/rspamd:)
    [localhost]:11332        (1157/rspamd:)
    [localhost]:11333        (1157/rspamd:)
    [localhost]:11211        (523/memcached)
    [anywhere]:8081        (764/apache2)
    [anywhere]:8080        (764/apache2)
    ***.***.***.***:53        (490/systemd-resolve)
    [localhost]:53        (566/named)
    [localhost]:53        (566/named)
    [localhost]:53        (566/named)
    [localhost]:53        (566/named)
    [localhost]:53        (566/named)
    [localhost]:53        (566/named)
    [localhost]:53        (566/named)
    [localhost]:53        (566/named)
    [localhost]:953        (566/named)
    [localhost]:953        (566/named)
    [localhost]:953        (566/named)
    [localhost]:953        (566/named)
    [localhost]:953        (566/named)
    [localhost]:953        (566/named)
    [localhost]:953        (566/named)
    [localhost]:953        (566/named)
    [anywhere]:4190        (1154/dovecot)
    [anywhere]:3306        (637/mariadbd)
    ***.***.***.***:53        (566/named)
    ***.***.***.***:53        (566/named)
    ***.***.***.***:53        (566/named)
    ***.***.***.***:53        (566/named)
    ***.***.***.***:53        (566/named)
    ***.***.***.***:53        (566/named)
    ***.***.***.***:53        (566/named)
    ***.***.***.***:53        (566/named)
    [anywhere]:587        (1747/master)
    [localhost]:6379        (546/redis-server)
    [anywhere]:993        (1154/dovecot)
    [anywhere]:995        (1154/dovecot)
    [anywhere]:143        (1154/dovecot)
    [anywhere]:80        (764/apache2)
    [anywhere]:110        (1154/dovecot)
    [anywhere]:21        (807/pure-ftpd)
    [anywhere]:22        (584/sshd:)
    [anywhere]:25        (1747/master)
    [anywhere]:465        (1747/master)
    [anywhere]:443        (764/apache2)
    *:*:*:*::*:953        (566/named)
    *:*:*:*::*:953        (566/named)
    *:*:*:*::*:953        (566/named)
    *:*:*:*::*:953        (566/named)
    *:*:*:*::*:953        (566/named)
    *:*:*:*::*:953        (566/named)
    *:*:*:*::*:953        (566/named)
    *:*:*:*::*:953        (566/named)
    *:*:*:*::*:4190        (1154/dovecot)
    *:*:*:*::*:3306        (637/mariadbd)
    *:*:*:*::*:587        (1747/master)
    *:*:*:*::*:993        (1154/dovecot)
    *:*:*:*::*:995        (1154/dovecot)
    [localhost]43        (1154/dovecot)
    [localhost]10        (1154/dovecot)
    *:*:*:*::*:21        (807/pure-ftpd)
    *:*:*:*::*:22        (584/sshd:)
    *:*:*:*::*:25        (1747/master)
    *:*:*:*::*:465        (1747/master)
    
    
    
    
    ##### IPTABLES #####
    Chain INPUT (policy ACCEPT)
    target     prot opt source               destination         
    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-sshd (1 references)
    target     prot opt source               destination         
    REJECT     all  --  ***.***.***.***          [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***       [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***         [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***       [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***      [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***       [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***        [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***        [anywhere]/0            reject-with icmp-port-unreachable
    RETURN     all  --  [anywhere]/0            [anywhere]/0           
    
    
    
    
    ##### LET'S ENCRYPT #####
    acme.sh is installed in /root/.acme.sh/acme.sh
    
     
    Last edited: Nov 23, 2023
  2. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    Search for how to change your admin password via mysql.
     
  3. jakrla

    jakrla New Member

    I tried this as a first means, but i didn't help. I assume that dbispconfig.sys_user still uses MD5 for hashing pw? (as instructions were few years old "UPDATE sys_user SET passwort = md5('Admin123') WHERE username = 'admin';")
    Also tried to remove pw completely, but login screen doesn't allow pws shorter than 1 char.
    re-installation returned error as "The server already has ISPConfig installed."
    Or maybe there is some way to force re-installation?
     
  4. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    if this is vm, just delete it and create new one. If this is a machine, you may want to reinstall the OS afresh. That is if you want to use ISPConfig Auto Installer in a clean setup. Otherwise, you can run ISPConfig uninstall.php but this of course will not be a clean setup.
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    ISPConfig does not use md5 anymore for more than 10 - 15 years, but it still supports it. Which means that when you insert a password in md5 format for legacy reasons, then this will work, but you should set a new password from within ISPConfig afterwards to get a secure encryption for the hash.
     
  6. jakrla

    jakrla New Member

    I just ended up to wipe and reinstall the whole server, this time it worked as expected.
    Thank you guys for your efforts, really appreciate it!!
     
    ahrasis and till like this.

Share This Page