Usermin display tweaks

Ilia's picture
Submitted by Ilia on Mon, 05/20/2013 - 13:49

Good day!

Could you please tell me how not to list mail and folders under Usermin! I only need to use it as possible tool for managing forwarding-replies in easy way?

Tell me please if I uninstall Usermin by running yum remove usermin will it affect webmin/virtualmin in any way? Are there dependencies inside of Webmin/Virtualmin in relation to Usermain.

P.S. Beg you please don't start your answer with "We strongly recommend not to remove Usermin but disabling it in Boot manager" :DD

Status: 
Active

Comments

Submitted by andreychek on Mon, 05/20/2013 - 18:05

Howdy -- you can set what Usermin modules are available by going into Webmin -> Usermin Configuration -> Available modules.

Attempting to remove Usermin would cause dependency errors.

Submitted by andreychek on Mon, 05/20/2013 - 18:05

Howdy -- you can set what Usermin modules are available by going into Webmin -> Usermin Configuration -> Available modules.

Attempting to remove Usermin would cause dependency errors.

Ilia's picture
Submitted by Ilia on Tue, 05/21/2013 - 03:09

Yes, yes! Found it! It's awesome!! So much work you have done!! Good job!!

Ilia's picture
Submitted by Ilia on Tue, 05/21/2013 - 03:36

Is Usermin running as a user or as root (and then applies kind of a shell to make it only for a logged in user)?

Ilia's picture
Submitted by Ilia on Tue, 05/21/2013 - 03:41

EDITED: +1 more question

  1. Is Usermin running as a user or as root (and then applies kind of a shell to make it only for a logged in user)?

  2. Usermin -> Applications -> MySQL Database shows all databases on the server when logged in as a user (not root), why?

Submitted by andreychek on Tue, 05/21/2013 - 09:19

Is Usermin running as a user or as root (and then applies kind of a shell to make it only for a logged in user)?

The primary Usermin process runs as root. I believe I see it spawning processes owned as the user when I login.

Usermin -> Applications -> MySQL Database shows all databases on the server when logged in as a user (not root), why?

Hmm, I don't have an "Applications" menu item, is that a separate module that you installed?

Ilia's picture
Submitted by Ilia on Tue, 05/21/2013 - 12:58

Hmm, I don't have an "Applications" menu item, is that a separate module that you installed?

I went to Webmin -> Usermin Configuration - > Available Modules -> MySQL Database

No it went pre-installed?

Submitted by andreychek on Tue, 05/21/2013 - 13:06

Hmm, when I enable that module, and then log in as a user, I only see the MySQL databases that particular user has rights to see.

Do you have phpMyAdmin setup on your server? If so, and you log in as that same user, does it show the same databases as you see in Usermin?

Ilia's picture
Submitted by Ilia on Tue, 05/21/2013 - 13:51

Yes, I have it. So far, I can see only my db, not all of them. But if I install MyPhpAdmin with Virtualmin and chose and option to have access to all db, not only mine, then I can see all under the same username?

Please, go to MySQL Database Server -> Database Permissions -> CLICK ON YOUR DATABASE NAME -> Database permission options? What do you have in Database permission options under Databases? Is it any, selected or Matching pattern?

Ilia's picture
Submitted by Ilia on Tue, 05/21/2013 - 13:59

I found out why! If in Webmin -> Servers -> Mysql -> User Permissions -> for particular user you set permissions (by default they are set to none), let's say you set them to Select | Insert | Update | Delete | Create | Drop THEN that user gets these settings applied globally for some reason? Is this a bug, correct?

Submitted by andreychek on Tue, 05/21/2013 - 14:02

It depends on the database... some are set to "Selected", others are set to "Matching pattern".

But in either case, I haven't been able to reproduce the issue you're describing.

Ilia's picture
Submitted by Ilia on Tue, 05/21/2013 - 14:32

I could again reproduce it!? Try to give a user, that you're signing in with to Usermin, a permission to select (In Webmin MySQL module in User Permissions) and you should see all table displaying in Usermin MySQL module?

Submitted by andreychek on Tue, 05/21/2013 - 19:49

The User Permissions screen isn't where you would want to setup permissions for one user for a single database.

The User Permissions screen intentionally grants users permissions to all databases.

You can review details regarding how that works by clicking the "Help" link at the top of the User Permissions screen.

It's usually not necessary to use Webmin to grant permissions to a database when using Virtualmin.

If you need to grant access to a database, you can do that in Virtualmin by going into Edit Users -> USERNAME -> Other User Permissions, and there you can set what databases the user should have access to in the "Allow access to databases" field.