Submitted by pham on Sat, 10/01/2011 - 13:47
I am finding the way to create mysql account which should be separated system/domain account. This account is only hold mysql permission on specific mysql database(s), no mailbox and virtual server login.
From (Virtualmin - Edit Mail and FTP Users), it always requires to create mailbox under "Virtual domain user mailbox details".
It's better to have separate pages for creating account on each apps (mail, mysql, ftp ...) or a combine/single Select Box/Options to let domain owner decided it.
Please advice :)
Status:
Active
Comments
Submitted by JamieCameron on Sat, 10/01/2011 - 15:41 Comment #1
Virtualmin has a single list of users, which can be given mail, FTP or DB access. You can create a user with only DB access by setting the "Primary email address" enabled field to "No" on the creation form, and selecting some databases for him to be granted access to..
Submitted by pham on Sun, 10/02/2011 - 11:39 Comment #2
Which menu should i use to create the account like you said? From Virtualmin - Edit Mail and FTP Users ? If it is, i can't find option "Primary email address" and field "No".
Please show me.
Submitted by andreychek on Sun, 10/02/2011 - 17:07 Comment #3
If you go into Edit Mail and FTP users, and click "Add a user to this server" -> "Email Settings", you should see the "Primary Email Address Enabled" option in there.
Submitted by JamieCameron on Sun, 10/02/2011 - 17:36 Comment #4
You are using qmail + vpopmail there, right? If so, you can't create a user without email access, as to my knowledge all vpopmail users are mailboxes.
Submitted by pham on Sun, 10/02/2011 - 22:39 Comment #5
well, it's really messy because i am using qmail/vpopmail :(
Is that possible to create separate mysql and FTP account separate to email account?
Submitted by JamieCameron on Mon, 10/03/2011 - 15:54 Comment #6
With vpopmail, no .. sorry.
Submitted by pham on Mon, 10/03/2011 - 21:15 Comment #7
Alright. How about qmail/ldap (patch)? Does it work well for creating separate accounts?
;)
Submitted by JamieCameron on Tue, 10/04/2011 - 16:16 Comment #8
Qmail+LDAP has the same issue - because the users are not real Unix users and always have email, it is impossible to create a MySQL-only user.
The recommended (and default) configuration for Virtualmin is to use regular Unix users as mailboxes. From what we've seen, this works fine unless you plan to host tens of thousands of mailboxes on a single system.