Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
I
ISPConfig 3
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 495
    • Issues 495
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Merge Requests 32
    • Merge Requests 32
  • CI / CD
    • CI / CD
    • Pipelines
    • Jobs
    • Schedules
  • Operations
    • Operations
    • Incidents
    • Environments
  • Analytics
    • Analytics
    • CI / CD
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Members
    • Members
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • ISPConfig
  • ISPConfig 3
  • Issues
  • #5294

Closed
Open
Opened Apr 16, 2019 by Christopher Davidson@cajdavidson

MySQL User not creating / updating

short description

Updating MySQL user password in ISPConfig is not affecting MySQL "user" table. Initial user creation doesn't seem to work correctly either. The below sequence is run and values look to be correct in "web_database_user" but nothing in "mysql.user" table.

correct behaviour

The database user should be created/updated.

environment

Server OS: (debian)
Server OS version: (8) ISPConfig version: 3.1dev

log entries

16.04.2019-14:13 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
16.04.2019-14:13 - DEBUG - Found 1 changes, starting update process.
16.04.2019-14:13 - DEBUG - Replicated from master: REPLACE INTO `web_database_user` (`database_user_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`database_user`,`database_user_prefix`,`database_password`,`database_password_mongo`) VALUES ('498','308','302','riud','riud','','0','XXXXXXXXXXX','XXXXXXXXXX','*XXXXXXXXXXXXX',NULL)
16.04.2019-14:13 - DEBUG - Calling function 'db_user_update' from plugin 'mysql_clientdb_plugin' raised by event 'database_user_update'.
16.04.2019-14:13 - DEBUG - Changing MySQL user password for: XXXXXXXXXXXX@localhost
16.04.2019-14:13 - DEBUG - Processed datalog_id 18145
16.04.2019-14:13 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
finished.```
Assignee
Assign to
None
Milestone
None
Assign milestone
Time tracking
None
Due date
None
Reference: ispconfig/ispconfig3#5294