HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=25)
-   -   Cannot create DB User (http://www.howtoforge.com/forums/showthread.php?t=61579)

pbrille 23rd April 2013 17:51

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

Code:

#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/tform_actions.inc.php:244] #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/tform_actions.inc.php:188] #2 tform_actions->onInsert() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:87] #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/tform_actions.inc.php:68] #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?

pbrille 24th April 2013 06:20

News:
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.


All times are GMT +2. The time now is 14:11.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.