Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Developers' Forum

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 14th June 2012, 14:48
Croydon Croydon is offline
ISPConfig Developer
 
Join Date: Jul 2007
Location: Koblenz, Germany
Posts: 922
Thanks: 16
Thanked 259 Times in 206 Posts
Post Changing database and database user architecture

I noticed there is a feature request in the bugtracker
FS#1448 - one database user name and multiple databases

I think having multiple databases per user is nice, but there should be multiple users per database, too. I would even prefer different rights for db users like "read-only / read-write".

To accomplish this I think databases and database users have to be separated and linked on a n<->m basis instead of 1<->n or n<->1.

I don't know if I have the time to do it but before I start with something like that I'd like to discuss how it's done best.

My prefered feature would be:
  • create new database
    - optionally create new database user for this db automatically
    - grant remote access on a per-database basis
  • create new users / edit users
    - grant read-write or read-only to chosen database(s)
    - grant or revoke remote access option on a per-user basis
Reply With Quote
Sponsored Links
  #2  
Old 14th June 2012, 18:56
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,678
Thanks: 819
Thanked 5,317 Times in 4,170 Posts
Default

I think that most admins will use phpmaydmin for such a task.

If we built that functionality in ispconfig too, then we should be careful that it does not get too complicated for users without server much knowledge. Also updates from older ispconfig versions must work automatically so a a script must be integrated that detecs a old style config and migraes it automatically to the new style.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 14th June 2012, 19:23
Croydon Croydon is offline
ISPConfig Developer
 
Join Date: Jul 2007
Location: Koblenz, Germany
Posts: 922
Thanks: 16
Thanked 259 Times in 206 Posts
Default

Quote:
Originally Posted by till View Post
I think that most admins will use phpmaydmin for such a task.
I don't know if that is enough. Clients are not able to add database users through phpmyadmin, are they?
So they could not add further database users for their databases or use multiple databases with a single username.

Quote:
Originally Posted by till View Post
If we built that functionality in ispconfig too, then we should be careful that it does not get too complicated for users without server much knowledge. Also updates from older ispconfig versions must work automatically so a a script must be integrated that detecs a old style config and migraes it automatically to the new style.
Changing the database to the new style should be simple sql queries.
- add new table(s)
- copy relevant user data from site_database to the new table(s) via INSERT TO ... SELECT FROM ...
- delete old user columns from the site_database tables

Of course it should be simple to admin.
The current form/list layout should work with the changed database layout as long as there are only single database <-> user pairs.
So a client could switch to "extended database management" if he likes to manage the databases and users separately and/or use the read-only feature.
Once a client has at least one database with user count different than 1 or at least one user with database cout different than 1, he cannot switch back to simple database management.
Reply With Quote
  #4  
Old 25th January 2013, 07:18
codingideas codingideas is offline
Junior Member
 
Join Date: Jan 2013
Posts: 7
Thanks: 4
Thanked 0 Times in 0 Posts
Default

Hey,

Sorry to bump this thread but are there any plans to continue this? I was reading "FS#2288 - Importer for data from Plesk control panel" and I came to this thread and noticed that it was a few months old. Lost motivation?
Reply With Quote
  #5  
Old 25th January 2013, 10:03
Croydon Croydon is offline
ISPConfig Developer
 
Join Date: Jul 2007
Location: Koblenz, Germany
Posts: 922
Thanks: 16
Thanked 259 Times in 206 Posts
Default

The database / user management has been changed in 3.0.5.
It is now possible to use the same user for multiple databases.
We decided not to allow multiple users for the same database through ispconfig but you can now choose a default database user and a read-only database user for each database.
__________________
Marius Cramer

pixcept KG
Reply With Quote
The Following User Says Thank You to Croydon For This Useful Post:
codingideas (25th January 2013)
  #6  
Old 25th January 2013, 11:48
codingideas codingideas is offline
Junior Member
 
Join Date: Jan 2013
Posts: 7
Thanks: 4
Thanked 0 Times in 0 Posts
 
Default

sweet, I have a friend who has 30 or so sites on a plesk server, so I got excited to see a migration for plesk.

so this is something you're going to finish because I can see myself hosting his sites.

next, whm/cpanel migration. The easier you make it to switch the more people you will get coming over. I really like ISPConfig.. a lot.
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
Horde Groupware Webmail Edition ByteMe Networking Tips/Tricks/Mods 17 20th December 2012 10:12
dovecot start problem veneficus Installation/Configuration 3 10th April 2012 17:39
Need help with ISPConfig Mail and Squirrelmail m.xander Installation/Configuration 109 3rd February 2012 00:15
dovecot: lda: Fatal: Unknown user dpicella Installation/Configuration 1 22nd August 2010 02:59
Vhosts...conf not synced to changes crypted General 50 24th April 2010 00:54


All times are GMT +2. The time now is 22:27.


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