RE: [Dbmail] Squirrelmail charset problem?

2004-05-13 Thread Marc-David Meijer
Thank you for the information. Since setting the charset to us-ascii in Squirrelmail did not seem to have any effect, I decide to make a small change to the source code, it works like a charm now :-) Thanks again, Marc-David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTEC

Re: [Dbmail] Is there a nead for a users description table

2004-05-13 Thread Will Berry
Feargal Reilly wrote: ... it's then up to the end-user as to how they use it ... Since the exact format and treatment of a 'gecos' field would be defined by the application, I think it's best to use the client_idnr field in the user table as a pointer to any application-specific data in ano

Re: [Dbmail] Operation timed out (port 25)

2004-05-13 Thread Ilja Booij
this looks like a posting that would better be sent to the postfix-users list. Ilja Jan-Kees Fels wrote: Hello, I don’t seem to be able to send email anymore when I change my dns and gateway address. However receiving email keeps working. (I use dynamic dns, so it takes only 5 minute

[Dbmail] Operation timed out (port 25)

2004-05-13 Thread Jan-Kees Fels
Hello, I don't seem to be able to send email anymore when I change my dns and gateway address. However receiving email keeps working. (I use dynamic dns, so it takes only 5 minutes to update the dns record). When I change the dns/gateway address back, everything works again. Its driving

[Dbmail] Re: postgresql: ERROR: parser: unterminated quoted string at or near

2004-05-13 Thread Sergey Spiridonov
Sergey Spiridonov wrote: Ilja Booij wrote: It can be that PostgreSQL cuts a piece of the query when sending the error message. That's why we need the original query. Now, I got what you mean... Just a second. Yes, closing <<')>> is missed. Look below debug output: May 13 15:49:04 james db

[Dbmail] Re: postgresql: ERROR: parser: unterminated quoted string at or near

2004-05-13 Thread Sergey Spiridonov
Ilja Booij wrote: It can be that PostgreSQL cuts a piece of the query when sending the error message. That's why we need the original query. Now, I got what you mean... Just a second. -- Best regards, Sergey Spiridonov

Re: [Dbmail] Re: postgresql: ERROR: parser: unterminated quoted string at or near

2004-05-13 Thread Ilja Booij
It can be that PostgreSQL cuts a piece of the query when sending the error message. That's why we need the original query. Ilja Sergey Spiridonov wrote: I think I see the problem The query is printed as trace(TRACE_ERROR, "%s, %s: " "Error executing query [%s] :

[Dbmail] Re: postgresql: ERROR: parser: unterminated quoted string at or near

2004-05-13 Thread Sergey Spiridonov
I think I see the problem The query is printed as trace(TRACE_ERROR, "%s, %s: " "Error executing query [%s] : [%s]\n", So, it is started and finished with []. May 13 14:17:42 james dbmail/smtp[15206]: dbpgsql.c, db_query: Error executing query [INSERT INTO message

Re: [Dbmail] Is there a nead for a users description table

2004-05-13 Thread Jacques Beaudoin
Hi all If there is a field like GECOS in dbmail i will use it in many ways. Bien à vous Jacques Selon Feargal Reilly <[EMAIL PROTECTED]>: > On Thu, 13 May 2004 09:49:18 +0200 > Ilja Booij <[EMAIL PROTECTED]> wrote: > > > I don't know if this should be a part of DBMail itself. I can see it how

Re: [Dbmail] Re: postgresql: ERROR: parser: unterminated quoted string at or near

2004-05-13 Thread Sergey Spiridonov
One more thing, which I get: if I copy this broken email into the Maildir of another user, everything works just fine - fetchmail fetches it, feeds it to dbmail-smtp and dbmail-smtp inserts it without any problem! I do not understans this at all, it seems that dbmail-smtp dies depending on th

Re: [Dbmail] Re: postgresql: ERROR: parser: unterminated quoted string at or near

2004-05-13 Thread Sergey Spiridonov
Feargal Reilly wrote: On Thu, 13 May 2004 13:36:44 +0200 Sergey Spiridonov <[EMAIL PROTECTED]> wrote: May 13 10:50:48 james CC: [EMAIL PROTECTED] Subject: Re: RES: > Notebook PC''s References: <[EMAIL PROTECTED] Could the PC''s bit be the cause of the problem? Perhaps only one ' is bein

Re: [Dbmail] Re: postgresql: ERROR: parser: unterminated quoted string at or near

2004-05-13 Thread Sergey Spiridonov
I increased trace level, but did not get something additional But I did get something additional from fetchmail: # fetchmail 1 message for costa at legba.gamic.com (355833 octets). reading message [EMAIL PROTECTED]:1 of 1 (355833 octets) fetchmail: SIGPIPE thrown from an MDA or a stream socket

[Dbmail] Re: postgresql: ERROR: parser: unterminated quoted string at or near

2004-05-13 Thread Sergey Spiridonov
Ilja Booij wrote: I have a hard time seeing anything wrong with this query.. But there must be something wrong. Sergey, can you give some more log output. More specifically, can you send the lines where the query is executed. Sorry, that is all of what I have. Probably the reason is that tra

Re: [Dbmail] Is there a nead for a users description table

2004-05-13 Thread Feargal Reilly
On Thu, 13 May 2004 12:43:03 +0100 Feargal Reilly <[EMAIL PROTECTED]> wrote: > Like you I'm not convinced as to whether it belongs in dbmail itself, but if > it did, the cleanest solution would be a single 'class' field in the user > table. Meant to add that it's then up to the end-user as to h

Re: [Dbmail] Re: postgresql: ERROR: parser: unterminated quoted string at or near

2004-05-13 Thread Feargal Reilly
On Thu, 13 May 2004 13:36:44 +0200 Sergey Spiridonov <[EMAIL PROTECTED]> wrote: > May 13 10:50:48 james CC: [EMAIL PROTECTED] Subject: Re: RES: > Notebook > PC''s References: <[EMAIL PROTECTED] Could the PC''s bit be the cause of the problem? Perhaps only one ' is being escaped? -fr? -- Fea

Re: [Dbmail] Is there a nead for a users description table

2004-05-13 Thread Feargal Reilly
On Thu, 13 May 2004 09:49:18 +0200 Ilja Booij <[EMAIL PROTECTED]> wrote: > I don't know if this should be a part of DBMail itself. I can see it how > it would be useful, but I don't think it should be a part of dbmail proper. Actually, when you consider dbmail is replacing the need for system us

Re: [Dbmail] Re: postgresql: ERROR: parser: unterminated quoted string at or near

2004-05-13 Thread Ilja Booij
I have a hard time seeing anything wrong with this query.. But there must be something wrong. Sergey, can you give some more log output. More specifically, can you send the lines where the query is executed. Ilja Sergey Spiridonov wrote: Ilja Booij wrote: can you rewind the log a bit

Re: [Dbmail] Re: postgresql: ERROR: parser: unterminated quoted string at or near

2004-05-13 Thread Sergey Spiridonov
Ilja Booij wrote: can you rewind the log a bit more, to see what the exact query was? I fetch some lines before and afer: May 13 10:50:30 james dbmail/imap4d[14068]: COMMAND: [4 noop] May 13 10:50:30 james dbmail/imap4d[14068]: COMMAND: [5 UID fetch 29175:* (FLAGS)] May 13 10:50:31 james

Re: [Dbmail] Re: postgresql: ERROR: parser: unterminated quoted string at or near

2004-05-13 Thread Ilja Booij
can you rewind the log a bit more, to see what the exact query was? Ilja Sergey Spiridonov wrote: This is extract from /var/log/messages May 13 10:50:54 james dbmail/imap4d[14064]: COMMAND: [4 noop] May 13 10:50:54 james dbmail/imap4d[14064]: COMMAND: [5 UID fetch 26872:* (FLAGS)] May 13 10:

[Dbmail] Re: postgresql: ERROR: parser: unterminated quoted string at or near

2004-05-13 Thread Sergey Spiridonov
This is extract from /var/log/messages May 13 10:50:54 james dbmail/imap4d[14064]: COMMAND: [4 noop] May 13 10:50:54 james dbmail/imap4d[14064]: COMMAND: [5 UID fetch 26872:* (FLAGS)] May 13 10:51:10 james dbmail/smtp[14225]: dbpgsql.c, db_query: Error executing query [INSERT INTO messageblks(mes

[Dbmail] postgresql: ERROR: parser: unterminated quoted string at or near

2004-05-13 Thread Sergey Spiridonov
Hi, I use dbmail from CVS. Everything works fine till today's night. I use fetchmail to fetch mails and insert them with fetchmail option fetchall mda "dbmail-smtp -u <>" Today I got email which can not be inserted. I am able to insert it manualy with the command cat broken_email.txt | dbmail-

Re: [Dbmail] Backing up dbmail mysql innodb with mysqldump

2004-05-13 Thread Paul J Stevens
Ah, silly me. please to: cat dbmail.preload.mysql dbmail.sql | mysql dbmail in stead. mysql -e dbmail.restore.preload dbmail -p < dbmail.sql Always results in: ERROR 1064 at line 1: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the

Re: [Dbmail] Is there a nead for a users description table

2004-05-13 Thread Ilja Booij
I don't know if this should be a part of DBMail itself. I can see it how it would be useful, but I don't think it should be a part of dbmail proper. Ilja Jacques Beaudoin wrote: Hi all Some time i wish i could have some fields in dbmail where i could input users specific data like - is supe