[Dovecot] allow_nets and mysql question

[Alex Samorukov]

Alex Samorukov wrote:
> Hi.
> I want to use allow_nets in my configuration, but i have some troubles
> which i cant resolve.
> To use allow_nets i creates `allow_nets` text field in my mysql users
> table. My query is:
>
> from: dovecot/sql.conf:
>
> password_query = SELECT crypt as password,  maildir as userdb_mail, 6 AS
> userdb_uid,6  AS userdb_gid, allow_nets FROM users WHERE id = '%u'
>
> from dovecot.conf:
> auth default {
>  mechanisms = plain
>  passdb sql {
>    args = /usr/local/etc/dovecot/sql.conf
>  }
>  userdb prefetch {
>  }
>  user = root
> }
>
I tried to change userdb from "prefetch" to "sql" but this change 
nothing. It seems that result of the allow_net checking simply ignored :(
> To