Created client doesn't have user login

Discussion in 'Installation/Configuration' started by ztodorovski, Feb 17, 2019.

  1. ztodorovski

    ztodorovski New Member

    This is my second ISPConfig install, it will be based on multiple Ubuntu 18.04 servers each with dedicated function, database, web/file, email, dns however I ran into an issue I have installed the database server (no ispconfig there just perconadb) and web server ( nginx + php fpm + ispconfig 3.1.13 ) I can login with root and everything is fine that far. the problem appears when i create a client, the client account is created in the panel and in the db "client" table, however there is no user created for that client, nothing in CP Users on the panel or in the DB "sys_user" table, I have checked all the logs in /var/log/ispconfig and there is no errors.

    Please assist, I've lost many hours with no idea what to look for.
  2. ztodorovski

    ztodorovski New Member

    Strange, I discovered the percona mysql server was failing silently on adding into sys_user
    Changing in client_edit.php
    $sql = "INSERT INTO sys_user (username,passwort,modules,startmodule,app_theme,typ,active,language,groups,default_group,client_id)
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
    $sql = "INSERT INTO sys_user (`username`,`passwort`,`modules`,`startmodule`,`app_theme`,`typ`,`active`,`language`,`groups`,`default_group`,`client_id`)
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

    Seems to resolve the issue.
    till likes this.
  3. ztodorovski

    ztodorovski New Member

    Just a FYI for anyone having issues... I've ran into additional problems with isp config and had to modify a lot of php code, they are all related with the database, seems ispconfig is not yet ready to handle mysql 8.0.13.
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    MySQL 8 is not supported by ISPConfig yet, that's right. Please see ISPConfig installation instructions (perfect server guides) to see which database versions are supported.

    If you like to help us to get ISPConfig ready for MySQL 8, then it would be great if you could contribute your changes here:

    To be able to forl the project, please send me a PM with your ispconfig git username after you signed up so I can grant you additional developer permissions.

Share This Page