Thank you very much for replying Mr Oli. Ummm Im confused. Could you please kindly mention as to how I should mention the user query? If I may speak though following are the mysql statements I used to create the tables n etc..
GRANT SELECT ON mailserver.* TO 'mailuser'@'127.0.0.1' IDENTIFIED BY 'mailuser2011'; CREATE TABLE `virtual_domains` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `virtual_users` ( `id` int(11) NOT NULL auto_increment, `domain_id` int(11) NOT NULL, `password` varchar(32) NOT NULL, `email` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), FOREIGN KEY (domain_id) REFERENCES virtual_domains(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `virtual_aliases` ( `id` int(11) NOT NULL auto_increment, `domain_id` int(11) NOT NULL, `source` varchar(100) NOT NULL, `destination` varchar(100) NOT NULL, PRIMARY KEY (`id`), FOREIGN KEY (domain_id) REFERENCES virtual_domains(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; But in that dovecot link you've sent me mention of a home that my db doesnt know about. SELECT home, uid, gid FROM users WHERE userid = '%n' AND domain = '%d' Please help sir. This is just a general question. if at all possible could you please point me to a good working guide related to this whole attempt. Thats is "postfix+dovecot-2.0+mysql+TLS" ? I'm yet to find a good source in order to get there.Problem is whatever you find is postfix with dovecot1.X implementation. thanks and Regards On Thu, Mar 28, 2013 at 12:55 PM, Oli Schacher <dove...@lists.wgwh.ch>wrote: > On Thu, 28 Mar 2013 11:48:42 +0530 > Vimuth <vimu...@gmail.com> wrote: > > > Mar 26 07:00:44 box1 dovecot: auth: Error: sql(vim...@mydomain.rock): > > User query failed: Table 'mailserver.users' doesn't exist (using > > built-in default user_query: SELECT home, uid, gid FROM users WHERE > > username = '%n' AND domain = '%d') > > > > > > > here's *"/etc/dovecot/dovecot-sql.conf.ext"* > > > > >driver = mysql > >connect = host=127.0.0.1 dbname=mailserver user=mailuser > >password=redhat > >default_pass_scheme = MD5 > >password_query = SELECT email as user, password FROM virtual_users > >WHERE > >email='%u'; > > looks like the "user_query" is missing in this file and therefore > dovecot uses a builtin query which uses a different table name > > http://wiki2.dovecot.org/AuthDatabase/SQL > > >
