unable to login to ISPconfig 3 new install

Discussion in 'Installation/Configuration' started by scorpious, Jul 19, 2018.

  1. scorpious

    scorpious Member

    Hi All
    New install using Debian 9
    Followed:The Perfect Server - Debian 9 (Stretch) with Apache, BIND, Dovecot, PureFTPD and ISPConfig 3.1
    I am unable to login to the ispconfig admin area and phpmyadmin
    listed are some errors I noticed while installing
    Processing triggers for initramfs-tools (0.130) ...
    update-initramfs: Generating /boot/initrd.img-4.9.0-6-amd64
    W: Possible missing firmware /lib/firmware/tigon/tg3_tso5.bin for module tg3
    W: Possible missing firmware /lib/firmware/tigon/tg3_tso.bin for module tg3
    W: Possible missing firmware /lib/firmware/tigon/tg3.bin for module tg3
    root@user:/home/user# service mysql restart
    Warning: mysql.service changed on disk. Run 'systemctl daemon-reload' to reload units.

    I can login to MariaDB using the password I set.
    when I view /usr/local/ispconfig/interface/lib/config.inc.php this is the setting
    //** Database
    $conf['db_type'] = 'mysql';
    $conf['db_host'] = 'localhost';
    $conf['db_port'] = '3306';
    $conf['db_database'] = 'dbispconfig';
    $conf['db_user'] = 'ispconfig';
    $conf['db_password'] = 'xxxxxxxxxx';
    $conf['db_charset'] = 'utf8'; // same charset as html-charset - (HTML --> MYSQL$
    $conf['db_new_link'] = false;
    $conf['db_client_flags'] = 0;

    //** Database settings for the master DB. This setting is only used in multiser$
    $conf['dbmaster_type'] = 'mysql';
    $conf['dbmaster_host'] = '';
    $conf['dbmaster_port'] = '';
    $conf['dbmaster_database'] = 'dbispconfig';
    $conf['dbmaster_user'] = '';
    $conf['dbmaster_password'] = 'xxxxxxxxxxxx';

    When i enter the username admin and password admin its just says Username or Password wrong.

    How can I correct this.
    Cheers Scorp
     
    Last edited: Jul 20, 2018
  2. scorpious

    scorpious Member

  3. ztk.me

    ztk.me Well-Known Member HowtoForge Supporter

    maybe you delete the password from your first post now. you might aswell also want to change it.
     
  4. EyeofChaos

    EyeofChaos New Member

    This worked for me on Ubuntu. Maybe it will work for you:
    mysql -u root -p
    use dbispconfig;
    UPDATE sys_user SET passwort = md5('admin') WHERE username = 'admin';
    quit;
     
  5. ztk.me

    ztk.me Well-Known Member HowtoForge Supporter

    oftentimes it's a cookie issue when visiting the login page using the IP instead of an hostname , think it was a firefox issue
     

Share This Page