Hi, fetch ENVELOPE doesn't seem to print out anything at all while running under a Oracle DB. The exact query give me the correct response when ran from other tools. Tracing on the DB shows that it returns the correct data when I try to fetch the envelope.
The same installation works just fine on postgresql and sqlite databases with the exact same data. Logs show: Jan 28 13:05:14.286 dbmail01.test.s dbmail-imapd[62401]: [0xdff4b0] Database:[db] db_query(+363): [0xbfebd0] [SELECT message_idnr,envelope FROM dbmail_envelope e LEFT JOIN dbmail_messages m USING (physmessage_id) WHERE m.mailbox_idnr = 15 AND message_idnr = 21] Jan 28 13:05:14.294 dbmail01.test.s dbmail-imapd[62401]: [0xdff4b0] Database:[db] log_query_time(+307): last query took [0.007] seconds Jan 28 13:05:14.295 dbmail01.test.s dbmail-imapd[62401]: [0xdff4b0] Database:[db] db_con_close(+291): [0xbfebd0] connection to pool Jan 28 13:05:14.295 dbmail01.test.s dbmail-imapd[62401]: [0xdff4b0] Debug:[imap] _fetch_envelopes(+979): Variables: s: (null) s?s: Jan 28 13:05:14.295 dbmail01.test.s dbmail-imapd[62401]: [0xdff4b0] Debug:[MailboxState] MailboxState_flush_recent(+971): flush [0] recent messages Jan 28 13:05:14.295 dbmail01.test.s dbmail-imapd[62401]: [0xbd0230] Debug:[clientbase] ci_write(+343): [0x7f79e3f18010] S > [23/23:* 1 FETCH (ENVELOPE ) ] Has anyone else encountered this? Doesn't really seem like there is anything wrong with the application. This happens with DBmail 3.1.9, 3.1.10, libzdb-2.8.1 and Oracle Instantclient 12.1. Thank you very much for any help! Regards, Mats Christensen
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
