Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Tips/Tricks/Mods

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 11th August 2009, 02:07
klonos klonos is offline
Member
 
Join Date: Apr 2007
Posts: 78
Thanks: 5
Thanked 3 Times in 3 Posts
Wink Easy mail account add/edit/delete for non-admins! Now, here's an idea...

It was relatively easy to install the latest 0.3 version of RoundCube in ISPConfig 3:

- add new site
- get latest version of roundcube
- extract it under new site
- run the install script from the browser
- ...fiddle around with some settings to fine-tune it.

Then, I came across this article. This guy has made a RoundCube plugin that works with PostfixAdmin and adds the following feature:

- gives certain users (mail accounts) admin rights.
- when these users log in their RoundCube webmail and visit their 'Preferences' tab, a new 'User Admin' option is made available to them.
- there they can perform very simple/basic actions on accounts like add, edit or delete.

This is exactly what I was looking for!...

Use case: Some admins go away on vacation and leave a guy behind in their shoes. These guys don't usually know that much about system/network administration, but they are the next best thing to the admin of the company. So, what they need is a very-very simple, easy-to-use and familiar looking ('pretty') interface to perform these actions.

The admins on the other hand, are not that comfortable with giving full access to the ISPConfig interface to these people, but they are left with no other option.

Now, if we could make this roundcube plugin work with the ISPConfig database, it would be something! Wouldn't it?

So far I managed to discover the following:

1. For this plugin to work with postfixadmin, you have to add a new field with the name 'is_admin ' (tinyint, not null) to the 'mailbox' table of the postfixadmin's database.

This field can also be added to the 'mail_user' table in the ISPConfig's database. Not sure how this will effect user selecting mysql scripts(?)

2. It also needs a new table to be created called 'quotacron'. This is probably used for quota display... not sure how it works exactly yet though.

You have to create a cronjob that executes a quota_cron.php file

*/5 * * * * cd /path/to/roundcube/plugins/manage_users/; php quota_cron.php

3. ...

[I will be editing this post as I go, but any help is welcome. Also let me know if you like this idea]
__________________
You can support Howtoforge and all the people behind it too. Consider becoming a supporter. It only costs a few and has to offer so much more than it already does. Take a look here
Reply With Quote
Sponsored Links
  #2  
Old 11th August 2009, 09:55
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,405
Thanks: 834
Thanked 5,496 Times in 4,326 Posts
Default

Quote:
This field can also be added to the 'mail_user' table in the ISPConfig's database. Not sure how this will effect user selecting mysql scripts(?)
Do not add this field or you will loose the ability to update ispconfig in future. If you would try to update, you would loose the database as the db schema is incompatible with the updated version. Same for the quotacron table.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 11th August 2009, 10:59
Horfic Horfic is offline
Senior Member
 
Join Date: Mar 2009
Location: Austria
Posts: 325
Thanks: 55
Thanked 95 Times in 60 Posts
Send a message via Skype™ to Horfic
 
Default

I would just use the frontend of the script, would add the new field "is_admin" in the roundcube user table and would recode the backend yourself. Then you would have a nice integration in ISPConfig.

PS: You wouldn't need the Cronjob and the cronjob field, because ISPConfig does that for you and it shouldn't take more than two hours.
__________________
web wack creations - We create your custom web application
Mailuser interface for ISPConfig 3

Last edited by Horfic; 11th August 2009 at 11:09.
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
Not receiving any incoming mail. Jcorrea920 General 11 3rd April 2010 13:08
421 Unexpected failure Lizard King Installation/Configuration 20 7th July 2009 20:43
Postfix not responding to telnet CarbonCopy Server Operation 6 8th May 2009 05:39
just the last step...and it works. Postfix...need help config. ubuntusr Installation/Configuration 1 5th January 2009 09:50
Can't login SquirrelMail satimis Server Operation 23 10th June 2008 13:51


All times are GMT +2. The time now is 03:43.


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