[Dbmail] dbmail error?

2006-11-01 Thread Jim Douglas
I upgraded to Fedora 6, downloaded installed the most recent _2_2_branch. I can't recieve emails and this is the dbmail.err file, *** glibc detected *** dbmail-lmtpd: munmap_chunk(): invalid pointer: 0x007c56ec *** === Backtrace: = /lib/libc.so.6(cfree+0x1bb)[0x17967b] /lib/libglib

[Dbmail] DBMail error logs

2007-05-09 Thread Alex McAuley
Can anyone tell me where the logs are for dbmail , my imapd isnt starting and i cant figure out why, maybe the logs will tell me Thanks in advance ALex___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail] DBMail error logs

2007-05-09 Thread Aleksander
Alex McAuley wrote: Can anyone tell me where the logs are for dbmail , my imapd isnt starting and i cant figure out why, maybe the logs will tell me /var/log/maillog ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/

[Dbmail] DBMAIL error on SELECT

2009-09-09 Thread David Young
Hi, I recently upgraded my dbmail to 2.2.11 and decided to create a new email account/mailbox to make sure everything is working correctly. I sent myself an email and retrieved it via outlook using dbmail-imapd. Below is the error I received in dbmail.err The email displays correctly, but wonder

Re: [Dbmail] DBMAIL error on SELECT

2009-09-09 Thread Jonathan Feally
What database server and version are you using? This seems like an older database not able to handle that query. -Jon David Young wrote: > Hi, I recently upgraded my dbmail to 2.2.11 and decided to create a > new email account/mailbox to make sure everything is working > correctly. I sent mys

Re: [Dbmail] DBMAIL error on SELECT

2009-09-09 Thread David Young
Running CentOS 5.2, Postgres 8.3.7. On Wed, Sep 9, 2009 at 8:24 PM, Jonathan Feally wrote: > What database server and version are you using? This seems like an older > database not able to handle that query. > > -Jon > > David Young wrote: > > Hi, I recently upgraded my dbmail to 2.2.11 and deci

Re: [Dbmail] DBMAIL error on SELECT

2009-09-10 Thread Michael Monnerie
On Donnerstag 10 September 2009 David Young wrote: > Sep 10 00:39:49 node1.the.matrix dbmail-imapd[4957]: Error:[sql] > dbpgsql.c,db_query(+287): query failed [SELECT m.message_idnr, > v.header value, k.messageblk FROM dbmail_messageblks k JOIN > dbmail_physmessage p ON k.physmessage_id=p.id JOIN d

Re: [Dbmail] DBMAIL error on SELECT

2009-09-10 Thread Michael Monnerie
On Donnerstag 10 September 2009 Michael Monnerie wrote: > PostgreSQL 8.3 issue Interesting, I got this answer from a PG dev: There has *never* been a Postgres release that accepted bytea ILIKE something. I'm not sure what you were really doing before, but that wasn't it.

Re: [Dbmail] DBMAIL error on SELECT

2009-09-10 Thread David Young
First I created a new user on dbmail with dbmail-user with the following options (-a -s -w -p MD5-HASH). DBMAIL created the new user/mailbox successfully. Next, I created an IMAP mailbox using Outlook 2003 SP3. Connected to dbmail-imapd. Outlook showed a single mailbox (Inbox). I sent an email

Re: [Dbmail] DBMAIL error on SELECT

2009-09-10 Thread David Young
I reproduced the problem again by doing the same thing.  Here's the FULL error log. Sorry for the SPAM. Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[sql] dbpgsql.c,db_query(+287): query failed [SELECT m.message_idnr, v.headervalue, k.messageblk FROM dbmail_messageblks k JOIN dbmail_physmessage p

Re: [Dbmail] DBMAIL error on SELECT

2009-09-10 Thread James Cloos
> "Michael" == Michael Monnerie > writes: Michael> How did you make dbmail run such a query? Looks like via a Michael> search, but I guess that never worked and would be a bug Michael> then. So please, how can I reproduce that query? That block is in mailbox_search() (and the query is e

Re: [Dbmail] DBMAIL error on SELECT

2009-09-15 Thread Michael Monnerie
On Donnerstag 10 September 2009 Michael Monnerie wrote: > So, this is the query you posted stripped down: > SELECT k.messageblk FROM dbmail_messageblks k WHERE > k.messageblk ILIKE '%multipart/encrypted%'; > > He's right, that query doesn't work on PG 8.1 either. OK, this is a bug in dbmail, whic

Re: [Dbmail] DBMAIL error on SELECT

2009-09-16 Thread James Cloos
> "Michael" == Michael Monnerie > writes: Michael> I would have thought convert_from, possibly combined with Michael> convert, would do it. And this should really do the magic, Michael> but I'm on 8.1 today, will test on 8.3 soon. Indeed, convert_from() can be used to coerce the messag

Re: [Dbmail] DBMAIL error on SELECT

2009-09-17 Thread Paul J Stevens
James Cloos wrote: > This query in psql does give me the header of a message sent to this > group: > > , > | select physmessage_id from dbmail_messageblks where is_header = 1 > |and convert_from(messageblk,'SQL_ASCII') ~ 'dbmail-dev' limit 1; > ` > > It is, however, as one might expec

Re: [Dbmail] DBMAIL error on SELECT

2009-09-17 Thread Michael Monnerie
On Donnerstag 17 September 2009 Paul J Stevens wrote: > No way around that without full text indexing. Any chance to have FTI support? PostgreSQL 8.3 has that built-in AFAIK, so it could be interesting. Dbmail could support it if the DB supports it, I just don't know how much effort that would b

Re: [Dbmail] DBMAIL error on SELECT

2009-09-17 Thread Jonathan Feally
Michael Monnerie wrote: > On Donnerstag 17 September 2009 Paul J Stevens wrote: > >> No way around that without full text indexing. >> > > Any chance to have FTI support? PostgreSQL 8.3 has that built-in AFAIK, > so it could be interesting. Dbmail could support it if the DB supports > it,

Re: [Dbmail] DBMAIL error on SELECT

2009-09-17 Thread Michael Monnerie
On Donnerstag 17 September 2009 Jonathan Feally wrote: > FTI would help searching greatly, however on MySQL the default is to > only index words 4 chars or longer. Thus it makes it unreliable when > searching for a small word of 3 chars or less. You can change it to > index 3 chars, which would pro

Re: [Dbmail] DBMAIL error on SELECT

2009-09-17 Thread Aaron Stone
On Thu, 17 Sep 2009 23:52:24 +0200, Michael Monnerie wrote: > On Donnerstag 17 September 2009 Jonathan Feally wrote: >> FTI would help searching greatly, however on MySQL the default is to >> only index words 4 chars or longer. Thus it makes it unreliable when >> searching for a small word of 3 ch

Re: [Dbmail] DBMAIL error on SELECT

2009-09-18 Thread Paul J Stevens
Jonathan Feally wrote: > Michael Monnerie wrote: >> On Donnerstag 17 September 2009 Paul J Stevens wrote: >> >>> No way around that without full text indexing. >>> >> Any chance to have FTI support? PostgreSQL 8.3 has that built-in AFAIK, >> so it could be interesting. Dbmail could support

Re: [Dbmail] DBMAIL error on SELECT

2009-09-18 Thread Paul J Stevens
Aaron Stone wrote: > I don't think any database's own full text index will really do what we > want for IMAP. I'd love to bolt on Sphinx or something like it and have it > manage the search index out of band. http://www.sphinxsearch.com/ Dude, you read my mind again? (or did I read yours...) I wa

[Dbmail] DBMail Error:[imapsession], but imap daemon still work

2007-07-17 Thread umask
Hi, I noticed next message in maillog: Jul 17 06:40:32 test dbmail/imap4d[3849]: Error:[imapsession] dbmail-imapsession.c,dbmail_imap_session_readln(+1512): timeout occurred in dbmail_imap_session_readln Jul 17 06:40:32 test dbmail/imap4d[3847]: Error:[imapsession] dbmail-imapsession.c,dbmail_

Re: [Dbmail] DBMail Error:[imapsession], but imap daemon still work

2007-07-18 Thread umask
Hi! Can anybody explain me that means this error? 17.07.07, 13:57, umask <[EMAIL PROTECTED]>: > Hi, > I noticed next message in maillog: > Jul 17 06:40:32 test dbmail/imap4d[3849]: Error:[imapsession] > dbmail-imapsession.c,dbmail_imap_session_readln(+1512): timeout occurred in > dbmail_imap

Re: [Dbmail] DBMail Error:[imapsession], but imap daemon still work

2007-07-19 Thread Paul J Stevens
umask wrote: > Hi! > > Can anybody explain me that means this error? It means a client tells dbmail to expect a certain amount of data, but the client stops before sending all data. for instance when a client appends a message using imap/store: C: A001 STORE "mailbox" {10} S: * OK gimme that da