Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 23rd April 2013, 18:51
pbrille pbrille is offline
Junior Member
 
Join Date: Sep 2009
Posts: 21
Thanks: 1
Thanked 0 Times in 0 Posts
Default 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?
Reply With Quote
Sponsored Links
  #2  
Old 24th April 2013, 07:20
pbrille pbrille is offline
Junior Member
 
Join Date: Sep 2009
Posts: 21
Thanks: 1
Thanked 0 Times in 0 Posts
 
Default

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.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Force PAM to create user home folder if it already not exists lorens Desktop Operation 19 22nd August 2014 21:50
dovecot start problem veneficus Installation/Configuration 3 10th April 2012 18:39
My Server Is Sending Spam. How Do I Block This? LordJ Server Operation 1 7th July 2011 20:34
Statistic not working mzo Installation/Configuration 49 20th April 2011 13:19
dovecot: lda: Fatal: Unknown user dpicella Installation/Configuration 1 22nd August 2010 03:59


All times are GMT +2. The time now is 10:57.


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