FAQ Search Today's Posts Mark Forums Read
» Video Reviews

» Linux Archive

Linux-archive is a website aiming to archive linux email lists and to make them easily accessible for linux users/developers.

» Sponsor

» Partners

» Sponsor

Go Back   Linux Archive > Ubuntu > Ubuntu User

LinkBack Thread Tools
Old 11-23-2010, 01:28 PM
maykel franco
Default About mailserver ISPMAIL

Hello, I'm Maykel and I'm spanish. I follow the manual http://workaround.org/ispmail/lenny , it's works perfectly with john@example.com. But I want also to authenticate users with an alternate user name without @example.com, for example with called user zjv009.

I added the column to the table virtual_users user, being as follows:







** 1
****** john@example.com
**** zjv009

So I changed the files:


query = SELECT email FROM virtual_users WHERE email = '% s' OR user = '% s'


query = SELECT 1 FROM virtual_users WHERE email = '% s OR' user = '% s'

and dovecot file:


password_query = SELECT email, password FROM virtual_users WHERE email = '% u' OR user = '% u'

To dovecot-sql.conf, I also tested:

password_query = SELECT email, password FROM virtual_users WHERE email = '% u' OR user = '% n'

I restarted the services:

/ Etc / init.d / postfix restart

/ Etc / init.d / dovecot restart

When I zjv009 authenticates the user enters a different mailbox.

Need to be so, because I want to migrate a mail server system.

But I've failed. What am I doing wrong? anyone can help me? thanks in advance

ubuntu-users mailing list
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

Thread Tools

All times are GMT. The time now is 06:40 PM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright 2007 - 2008, www.linux-archive.org