Cannot create DB User

Discussion in 'General' started by pbrille, Apr 23, 2013.

  1. pbrille

    pbrille New Member

    Using ISPConfig I cannot create a new DB user.
    This is the error:

    #0 db->query(INSERT INTO `web_database_user` (`server_id`, `database_user`, `database_user_prefix`, `database_password`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`) VALUES ('1', 'c1MYSTRING', 'c1', '*11E9912BD83597CF97126CADBCEDAC96A0202191', '2', '2', 'riud', 'riud', '')) called at [/usr/local/ispconfig/interface/lib/classes/] #1 tform_actions->onInsertSave(INSERT INTO `web_database_user` (`server_id`, `database_user`, `database_user_prefix`, `database_password`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`) VALUES ('1', 'c1MYSTRING', 'c1', '*11E9912BD83597CF97126CADBCEDAC96A0202191', '2', '2', 'riud', 'riud', '')) called at [/usr/local/ispconfig/interface/lib/classes/] #2 tform_actions->onInsert() called at [/usr/local/ispconfig/interface/lib/classes/] #3 tform_actions->onSubmit() called at [/usr/local/ispconfig/interface/web/sites/database_user_edit.php:117] #4 page_action->onSubmit() called at [/usr/local/ispconfig/interface/lib/classes/] #5 tform_actions->onLoad() called at [/usr/local/ispconfig/interface/web/sites/database_user_edit.php:228] Unknown column 'database_user_prefix' in 'field list'
    There is actually no such column. There's only database_user.
    What's wrong here?
  2. pbrille

    pbrille New Member

    When I create a new DB with an existing user... This specific user effectively has no rights to access this specific DB. I guess there went something wrong with the transition to this new DB schema where one user can use multiple databases.... I guess I will file a bug report.

Share This Page