[Dovecot] FreeBSD Ports Issues
Installed dovecot for the first time, using the FreeBSD port. Found 2 issues with the port, and I've only been able to resolve one of them.
First of all, the port, (or perhaps dovecot) does work with mysql 4.1 encryption. I had to create a user with access to the mysql table, then do 'set password = old_password('password');' in order to get dovecot to talk to the server.
The second issue, is that dovecot seems to be ignoring my user_query settings. I have the following in dovecot-sql.conf:
password_query = SELECT password FROM mailbox WHERE username = '%u' user_query = SELECT maildir, 125 as uid, 125 as gid FROM mailbox WHERE username = '%u'
The password query works, however the user query seems to default to something else, and no matter how I change the user_query line in dovecot-sql.conf, it uses the same query. Here's an excerpt from my logs:
dovecot: Oct 11 03:19:30 Info: Dovecot v1.0.alpha3 starting up dovecot: Oct 11 03:19:31 Info: auth-worker(default): mysql: Connected to (null) (postfix) dovecot: Oct 11 03:19:35 Info: auth-worker(default): sql(user@example.com,1.2.3.4): query: SELECT password FROM mailbox WHERE username = 'user@example.com' dovecot: Oct 11 03:19:35 Info: auth(default): client in: AUTH 1 PLAIN service=IMAP secured lip=5.6.7.8 rip=1.2.3.4 resp=AGJqZXVuZ0Bjb2JhbHQtaXQuY29tAHRlc3Q= dovecot: Oct 11 03:19:35 Info: auth(default): client out: OK 1 user=user@example.com dovecot: Oct 11 03:19:35 Info: auth(default): master in: REQUEST 1 13590 1 dovecot: Oct 11 03:19:35 Info: auth-worker(default): sql(user@example.com,1.2.3.4): SELECT home, uid, gid FROM users WHERE userid = 'user@example.com' dovecot: Oct 11 03:19:35 Error: auth-worker(default): sql(user@example.com,1.2.3.4): User query failed: Table 'postfix.users' doesn't exist dovecot: Oct 11 03:19:35 Info: imap-login: Internal login failure: user=<user@example.com>, method=PLAIN, rip=67.188.145.230, lip=209.25.157.150, TLS
So obviously the query fails because that table doesn't exist. However that's not the query that I have in the configuration file. As a matter of fact, I have no idea where it's pulling that query from. Any pointers would be greatly appreciated.
I can't figure out the SQL issue either
I don't think its a FreeBSD issue though -- I think its because most
documentation (official, wiki, 3rd party) is for the 0.9x branch,
and there's virtually nothing regarding using sql out there for the
1.x branch. (there were a lot of configuration changes and, what
seems like general logic changes in regards to authentication ,
between the .9x and 1.x branches)
I posted an almost identical sql issue yesterday. I'm hoping someone
will clarify one of our issues.
On Oct 11, 2005, at 6:12 PM, Barry Jeung wrote:
The second issue, is that dovecot seems to be ignoring my user_query settings. I have the following in dovecot-sql.conf:
On Tue, Oct 11, 2005 at 03:12:58PM -0700, Barry Jeung wrote: snip
The second issue, is that dovecot seems to be ignoring my user_query settings. I have the following in dovecot-sql.conf:
password_query = SELECT password FROM mailbox WHERE username = '%u' user_query = SELECT maildir, 125 as uid, 125 as gid FROM mailbox WHERE username = '%u'
The password query works, however the user query seems to default to something else, and no matter how I change the user_query line in dovecot-sql.conf, it uses the same query. Here's an excerpt from my logs:
snip
dovecot: Oct 11 03:19:35 Info: auth-worker(default): sql(user@example.com,1.2.3.4): SELECT home, uid, gid FROM users WHERE userid = 'user@example.com'
snip
So obviously the query fails because that table doesn't exist. However that's not the query that I have in the configuration file. As a matter of fact, I have no idea where it's pulling that query from. Any pointers would be greatly appreciated.
The query perfectly matches the last example in the dovecot-sql.conf file. In my copy, that's the last line in in the file. Did you uncomment that line?
Did you do a search in the file for "SELECT home, uid, gid" to see if there's an uncommented line containing that query?
On Tue, 2005-10-11 at 15:12 -0700, Barry Jeung wrote:
The password query works, however the user query seems to default to something else, and no matter how I change the user_query line in dovecot-sql.conf, it uses the same query. Here's an excerpt from my logs:
Well, are you sure you're modifying the right file? :) If you change connect settings, do they work?
Only other reason that I can think of is that the query line is commented out.
In all other cases you should get an error message, or it should work.
The user query that you're getting is anyway the default that's built into dovecot-auth binary. Although I'm not sure if it's of any use in there.. Maybe I should remove it.
participants (4)
-
Barry Jeung
-
Bob Hall
-
Jonathan
-
Timo Sirainen