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.
Thread Tools Display Modes
Old 11th August 2009, 03:07
klonos klonos is offline
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
Old 11th August 2009, 10:55
till till is offline
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts

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
Old 11th August 2009, 11: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

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


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 14:08
421 Unexpected failure Lizard King Installation/Configuration 20 7th July 2009 21:43
Postfix not responding to telnet CarbonCopy Server Operation 6 8th May 2009 06:39
just the last step...and it works. Postfix...need help config. ubuntusr Installation/Configuration 1 5th January 2009 10:50
Can't login SquirrelMail satimis Server Operation 23 10th June 2008 14:51

All times are GMT +2. The time now is 23:05.

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