Martin Nedbal:
> Hi,
> I'm running linux mail server, I have Postfix-20010228-pl05 with
> MySQL and Cyrus as imap/pop3 daemon. I have to add virtual
> domain, the domain was theinvestmentupdate.com. It does'no work.
> I found the problem quickly, it lies in src/util/dict_mysql.c on
> line 162:
>
> query = vstring_alloc(24);

vstrings grow on demand. The 24 is only the initial size.

> Problem is in the fact that the query
>
> vstring_sprintf(query, "select %s from %s where %s = '%s' %s",
> dict_mysql->ndict_mysql->name->table, dict_mysql->name-
> >where_field, name_escaped,dict_mysql->name-
> >additional_conditions);
>
> will be much longer, of course :)
> I recommed allocating more space for the string.

vstring_sprintf() expands the string buffer when more space is needed.

In order to debug the mysql queries, I suggest that you test it with:

    postmap -v -q querystring mysql:filename

This will show the full mysql query and reply.

        Wietse

        Wietse
-
To unsubscribe, send mail to majordomopostfix.org with content
(not subject): unsubscribe postfix-users

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]