ISP not create db users

Discussion in 'Installation/Configuration' started by Poliman, Dec 1, 2016.

  1. Poliman

    Poliman Member

    I have the newest version of Ispconfig - 3.1.1p1. I created client, database user, database and finally website. Unfortunatelly only database I can see after login as root to phpmyadmin. I can't login as created database user. I have errors:
    #1045 - Access denied for user 'serpepsAdm1'@'localhost' (using password: YES)
    mysqli_real_connect(): (HY000/1045): Access denied for user 'serpepsAdm1'@'localhost' (using password: YES)

    Database serpeps_base1 is normally created via ISP panel.

    I logged in as root and checked users accounts - there is root, ispconfig and roundcube users but not serpepsAdm1. What should I check resolve this issue?
    By the way - few days after ISPconfig installation I upgraded mysql from 5.5.53 version to 5.7.16 - MySQL Community Server (GPL), and moreover I see that mysql client under www server (all in phpmyadmin) is in strange version -> libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Use the ispconfig debug mode to create a new mysql user and database to see if you get any additional errors in the log or hint's why it fails.
     
  3. Poliman

    Poliman Member

    How can I turn on debug mode? Is it possible to turn on reconfiguring mysql via ISP?
     
    Last edited: Dec 1, 2016
  4. Jesse Norell

    Jesse Norell Active Member

    Debugging is at the bottom of https://www.howtoforge.com/community/threads/please-read-before-posting.58408/

    as for reconfiguring mysql, I know slave servers can reconfigure permissions on the master (download the ispconfig source, untar it and run update.php (from install/ directory), and answer yes to that question), but I am not positive if that is done on a single-server installation. it shouldn't hurt to try.
     
  5. Poliman

    Poliman Member

    Ok, I will do this. Btw Is it possible to reinstall mysql and is it possible that Ispconfig will see properly reinstalled mysql?

    EDIT
    This is what this command /usr/local/ispconfig/server/server.sh shows:
    02.12.2016-06:33 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
    02.12.2016-06:33 - DEBUG - Found 1 changes, starting update process.
    02.12.2016-06:33 - DEBUG - Calling function 'db_user_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_user_insert'.
    02.12.2016-06:33 - DEBUG - Processed datalog_id 58
    02.12.2016-06:33 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    ~~ above part for user creation, below for db creation
    02.12.2016-06:35 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
    02.12.2016-06:35 - DEBUG - Found 2 changes, starting update process.
    02.12.2016-06:35 - DEBUG - Calling function 'db_user_update' from plugin 'mysql_clientdb_plugin' raised by event 'database_user_update'.
    02.12.2016-06:35 - DEBUG - Processed datalog_id 59
    02.12.2016-06:35 - DEBUG - Calling function 'db_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_insert'.
    02.12.2016-06:35 - DEBUG - Created MySQL database: serpeps_base1
    02.12.2016-06:35 - DEBUG - Calling GRANT for serpeps_base1 with access rw and hosts localhost
    02.12.2016-06:35 - DEBUG - GRANT for user serpepsAdm1 at host localhost
    02.12.2016-06:35 - DEBUG - GRANT ALL PRIVILEGES ON `serpeps_base1`.* TO 'serpepsAdm1'@'localhost' IDENTIFIED BY PASSWORD '*5B114EAB83AFCA2F5D6E84CA70CB58574F4F0183' success? no
    02.12.2016-06:35 - DEBUG - Processed datalog_id 60
    02.12.2016-06:35 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock

    Third line from the bottom says "success? no".
    Btw I have created backup 25.11.2016 - there is: etc.tar.gz, ispconfig_db_backup.sql, ispconfig_software.tar.gz.
     
    Last edited: Dec 2, 2016

Share This Page