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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 20th December 2006, 02:37
shinzou shinzou is offline
Junior Member
Join Date: Dec 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts

thanks for creating this option desmondk! however, I can't get it to work

I've read the other posts and made sure to make the spaces into tabs but can't authenticate with the user@domain.com style.

I commented out the makeuserdb line, so I could edit the userdb file beforehand. I stripped it down to one account for testing purposes, then ran the makeuserdb command.

Any ideas? Thanks in advance.
Reply With Quote
Sponsored Links
Old 27th December 2006, 14:30
ciprianz ciprianz is offline
Junior Member
Join Date: Dec 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts

i think it will be easier if this authentification metod will be allowed direct from ispconfig
for example it would be nice to have in System Config/Isp Manager User Sufix
then this chat about how to make user auth. with user@domain will not even be here
Reply With Quote
Old 28th December 2006, 00:00
ciprianz ciprianz is offline
Junior Member
Join Date: Dec 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Lightbulb ispconfig user@domain

I was just wondering if the following method (see link)
could be combined with ISP config by adding a new field in table isp_isp_user
and use that field straight in the configuration of postfix
If anyone understands what I mean pls try..
I will test it tommorow
I'm sleepy now
I'll post tommorow ...
It must work
Reply With Quote
Old 28th December 2006, 09:58
ciprianz ciprianz is offline
Junior Member
Join Date: Dec 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Arrow a solution

I just found another solution for user@domain.tld

here's the link:

check it out!
Reply With Quote
Old 30th December 2006, 16:33
Daisy Daisy is offline
Senior Member
Join Date: Dec 2006
Posts: 112
Thanks: 0
Thanked 3 Times in 1 Post

has there been any talk about how to do this with dovecot yet?
Reply With Quote
Old 31st December 2006, 21:17
falko falko is offline
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts

Originally Posted by Daisy
has there been any talk about how to do this with dovecot yet?
No, not that I know.
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Old 1st January 2007, 13:26
ciprianz ciprianz is offline
Junior Member
Join Date: Dec 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts

I haven't been succesuful to use user@domain.tld aplying any of the ideea found in the forum.
I would like to use the authentification method provided in Tutorial: ISP-style Email Service with Debian-Sarge and Postfix 2.1
I was interested in special on
Step 8: Configure the POP3 / IMAP service
that will allow authentification based on information found in a table
as you may see in tutorial we need the following information
MYSQL_SERVER localhost
MYSQL_USERNAME provider_admin
#MYSQL_CRYPT_PWFIELD (comment this out)
MYSQL_HOME_FIELD "/home/vmail"
#MYSQL_NAME_FIELD (comment this out)

some of the fields are missing in our isp_isp_user table

for quick testing I added the fields missing above like this:

1. Go to ISP Config -> Management - > Form designer -> Edit form
2. Search for isp - ISP User: [Edit] [Delete]
3. Click on [Edit]
4. Choose from Add dropdown menu: Short Textfield and press OK
5. complete the field according to your needs
example: to add a field that will contain username
write to
Fieldname: username
Title: Username (courier) (or whatever you want to see when you add new user, I choosed like that because I wanted to know that it is the field added by me for courier-authmysql method
all the other fields are optional

I created the following fields with the method described above:
password, gid, username,usermaildir
these fields will be used with

Fields explained:
MYSQL_SERVER, MYSQL_USERNAME, MYSQL_PASSWORD -these are easy: i modified only the MYSQL_USERNAME and MYSQL_PASSWORD, use your own user and password to connect to your mysql server.
MYSQL_PORT 0 i didnt' modified anything
MYSQL_DATABASE is the database that contains your ispconfig tables, you specified this database when you have installed your ispconfig, in my case was ispconfig
MYSQL_USER_TABLE in our case that table should be isp_isp_user
MYSQL_CLEAR_PWFIELD is the field that contains the user password, altough in isp_isp_user exists user_passwort that fields gets empty for security reason. so you have to create another one: userpassword that should contain the user password
MYSQL_UID_FIELD -this field could be generated from the isp_isp_user, there is doc_id field that contains the user id in the table but what we need is the user id used in linux, the linux userid is build like this: userid+doc_id where userid it is set in ispconfig under management -> server -> settings -> Other -> "Userid from" . The default value for "Userid from" is 10000 so we could build MYSQL_UID_FIELD like this 10000+doc_id
MYSQL_GID_FIELD - this is a little bit harder to build from what I see the group id is the same for all user from a Site. so MYSQL_GID_FIELD should be something like this 10000+[WEBID]
MYSQL_HOME_FIELD "/var/www/"

I will continue later, all I said until now was theory, I didn't test it yet.
I don't know english very well.
I'm from Romania and I'm sorry if I write in english so bad.

Last edited by ciprianz; 1st January 2007 at 13:29.
Reply With Quote
Old 7th January 2007, 21:06
cotthemh cotthemh is offline
Junior Member
Join Date: Dec 2006
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default the same with dovecot works nicely

you can do this very easily with dovecot :

change ispconfig so that it prefixes with [DOMAIN]_

then change the line in the /etc/dovecot.conf file


next of course make sure all you're userid's are lowercase (otherwise just juse ="%Ld_%n") but the first solution avoids any typos in the login.

the nice thing is that squirrelmail works like a breeze,

have fun
Reply With Quote
Old 9th January 2007, 10:53
alex916 alex916 is offline
Join Date: Dec 2005
Posts: 52
Thanks: 0
Thanked 0 Times in 0 Posts

This Mod is very good.
Thanks Desmondk.
Is There a way to use this auth also with smtp-aut?

Reply With Quote
Old 9th January 2007, 19:29
jerry3687 jerry3687 is offline
Junior Member
Join Date: Sep 2006
Posts: 4
Thanks: 0
Thanked 1 Time in 1 Post
Default Log in as a system user

> Quote:
> Originally Posted by Rustin
> To log into ispconfig one would have to use <domain>_<username> I assume?
>No, only customers, resellers and admin can log into ISPConfig, not system users.

> Falko

Hi Falco....

Actually, an individual email user *CAN* log into ispconfig to maintain his own email account. 2.2.x of ispconfig required.

To enable this, the Administrator goes in to web configuration and checks "mailuser login".

Now the email user can log in with his username and password to change his own password, set up autoresponders, antivirus and spam filtering, etc.

Reply With Quote
The Following User Says Thank You to jerry3687 For This Useful Post:
SneakyWho_am_i (15th June 2008)


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
Cannot send email from OE through ISPconfig site tomd General 10 12th March 2009 07:05
SP-Server Setup - Ubuntu 5.10 "Breezy Badger" - Page 6 (changes) LuisC-SM HOWTO-Related Questions 0 21st April 2006 16:16
ISPConfig 2.2.0 problem with email addresses DataJet General 1 29th March 2006 14:29
Debian Sarge, ISPConfig, perfect setup followed, email can't login! Zoon Installation/Configuration 3 12th February 2006 21:58
ISP-Ubuntu breezy ispconfig dns email e-mail working finally yellowjelly HOWTO-Related Questions 0 19th November 2005 21:30

All times are GMT +2. The time now is 02:24.

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