search for: sql_db

...6 00:38:43 *************** *** 470,480 **** echo '/* this file automatically generated by Makefile */' >$@ echo '#include "lib.h"' >>$@ echo '#include "sql-api.h"' >>$@ ! for i in $(sql_drivers) ; do \ echo "extern struct sql_db driver_$${i}_db;" >>$@ ; \ done echo 'void sql_drivers_register_all(void) {' >>$@ ! for i in $(sql_drivers) ; do \ echo "sql_driver_register(&driver_$${i}_db);" >>$@ ; \ done echo '}' >>$@ --- 470,480 ---- echo '/* t...

...ound that by removing the reference to the convert plugin from src/plugins/Makefile.am. After that, the autogen process completes and I get the previously discussed shell error when running make: if [ "" != "" ]; then \ for i in ; do \ echo "extern struct sql_db driver_${i}_db;" >>sql-drivers-register.c ; \ done \ fi /bin/bash: -c: line 1: syntax error near unexpected token `;' /bin/bash: -c: line 1: `if [ "" != "" ]; then for i in ; do echo "extern struct sql_db driver_${i}_db;" >>sql-driver...

...l_transaction_context *x_ctx) +{ + init_transaction_query(&qry->super, + &sync_transaction_query_vtable, x_ctx); +} + +/** pgc (connection) code */ +struct multi_pgsql_pgc { + struct multi_pgsql_pgc *p; + + char *connect_string; + PGconn *pgc; + PGresult *pgr; + struct multi_pgsql_db *pgdb; + struct multi_pgsql_query *qry; + struct io *io; + struct timeout *timeout; +}; + +/*** misc */ +static void start_pgc_connect(struct multi_pgsql_pgc *); + +static void init_pgc(struct multi_pgsql_pgc *pgc, + struct multi_pgsql_db *pgdb, char *connect_string) +{ + pgc->connect_str...

...the configuration. There are mainly 3 config files I'm thinking about: dict-sql, passdb/userdb sql, passdb/userdb ldap. The dict-sql is something I think needs a bigger redesign (mentioned above in "Metadata" section), but the sql/ldap auth configs could be merged. One way could be: sql_db sqlmails { # most settings from dovecot-sql.conf.ext, except for queries driver = mysql connect = ... } ldap_db ldapmails { # most settings from dovecot-ldap.conf.ext, except attributes/filters } passdb { driver = sql db = sqlmails sql_query = select password from users where userna...

Hi, I want to log some informations about a mail in a mysql database when the mail is saved to inbox (for a groupware). I use Dovecot 1.2.16 and the log message "msgid=<xxx>: saved mail to inbox" is generated in deliver.c. I find all the needed data in that file. But I'am not sure how to use the functions in sql-api.h or sql-api-private.h to send a simple SQL insert statement

Hello, I'm trying to build another antispam plugin, but some things are a bit unclear. In backend_handle_mail I put store the signature returned from signature_extract into my antispam_transaction_context. In backend_commit it appears that the signature is empty. (It wasn't in backend_handle_mail). Somehow between backend_handle_mail en backend_commit it has been cleared... When I use

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I'm using a postgres dict for ACL, when when use deleteacl or setacl I get a "not connected" error and (v2.2) Panic: file driver-pgsql.c: line 84 (driver_pgsql_set_state): assertion failed: (state == SQL_DB_STATE_BUSY || db->cur_result == NULL) and a rawdump eventually. You can trigger the error with the "dict" socket easily: while true; do ( echo -en "H2\t0\t0\t\tacl\nI1\tshared/shared-boxes/\n" sleep 1 ) | socat - unix:/var/run/dovecot2.2/dict done I interprete H2...