Dbmail is the name of a group of programs that enable the possiblilty of storing and retrieving mail messages from a database using POP3 or IMAP4rev1 ()

headers marek | 2 Jan 2010 23:06

I would need to signup for DBMail Bug Tracker to report bug, but it only
shows the message:

Invalid e-mail address.

Regards
Marv

Apparently, /etc/resolv.conf is broken on the machine involved. I'll
notify the system administrators.

For the time being, I've disabled checking MX records for newly
registered users' addresses.

marek <at> manet.cz wrote:
> I would need to signup for DBMail Bug Tracker to report bug, but it only
> shows the message:
> 
> Invalid e-mail address.
> 
> Regards
> Marv
> 
> _______________________________________________
> DBmail mailing list
> DBmail <at> dbmail.org
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
> 

--

-- 
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl

I filed a bug about a week ago [1], and I did some more tests and am still
mystified as to what could be causing this. I would like to know if someone
else has seen such problems before, it might be something as simple as
a misconfigured mysql on my part. All details and log excerpts are in the
bugreport.

[1] http://www.dbmail.org/mantis/view.php?id=824

_______________________________________________
DBmail mailing list
DBmail <at> dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Jorge, Peter,

I don't believe there's a problem with the query.

Peter, try connection to the remove database using the mysql client
(mysql -h somehost...) and run the query mentioned below. That way you
will evade any dbmail issues.

My guess is this is a libmysqlclient versioning issue.

Jorge Bastos wrote:
> 
> 
> H i peter ,
> 
>> [1] http://www.dbmail.o rg/mantis/view.php?id=824
> <http://www.dbmail.org/mantis/view.php?id=824>
> 
> I ' m with a bit of time today, and I saw:
> 
> Dec 25 20:38:57 Arzamas postfix/pipe[8407]: 4DACB17077F: to=<sales <at> <
> redacted>.net>, relay=dbmail-pipe, delay=18432,
> delays=18432/0.12/0/0.16, dsn=4.3.0, status=deferred (temporary failure.
> Command output: Dec 25 * ** 20:38:57 Arzamas dbmail-smtp[8411]:
> Error:[sql] dbmysql.c,db_query(+290): [You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version
> for the right syntax to use near '' at line 1] * [SELECT physmessage_id
> FROM dbmail_messages WHERE message_idnr = 3812926] Dec 25 20:38:57
> Arzamas dbmail-smtp[8411]: Error:[db] db.c,db_get_physm essage_id(+341):
> error getting physmessage_id Dec 25 20:38:57 Arzamas dbmail-smtp[8411]:
> Error:[delivery] pipe.c,insert_messages(+545): failed to store temporary
> message. Dec 25 20:38:57 Arzamas dbmail-smtp[8411]: Error:[smtp]
> main.c,main(+343): insert_me s sages failed Dec 25 20:38:57 Arzamas
> dbmail-smtp[8411]: Warning:[smtp] main.c,main(+391): exit code [75]
> because something went wrong; turn up trace level for more detail )
> 
> A nd I see a query failing.
> 
> I see the version 2.2.11 on the tracker, can you update to the latest
> 2.2x version? I think I hit that query failin g when I used 2.2x also,
> but if it is what I ’ m thinking, it was solved long time ago.
> 
> I f possible update DBMail and tell us the feedb ack.
> 
> J orge,
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> DBmail mailing list
> DBmail <at> dbmail.org
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

--

-- 
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl

Paul J Stevens wrote:
> Jorge, Peter,
> 
> I don't believe there's a problem with the query.
> 
> Peter, try connection to the remove database using the mysql client
> (mysql -h somehost...) and run the query mentioned below. That way you
> will evade any dbmail issues.
> 
> My guess is this is a libmysqlclient versioning issue.
> 

Nope, all queries are running fine standalone. In fact as you can see in the
full dbmail-util log in the bugreport, the same query runs *several times*
before actually failing.

Any other ideas on how to pin this down?

I don't have a clue. I use non-local tcp connections from dbmail-2.2 to
mysql servers (32bit) all the time without any problems like this.

Only thing I havent tested is connecting from a 32bit mysql client to a
64 bit mysql server....

Peter Rabbitson wrote:
> Paul J Stevens wrote:
>> Jorge, Peter,
>>
>> I don't believe there's a problem with the query.
>>
>> Peter, try connection to the remove database using the mysql client
>> (mysql -h somehost...) and run the query mentioned below. That way you
>> will evade any dbmail issues.
>>
>> My guess is this is a libmysqlclient versioning issue.
>>
> 
> Nope, all queries are running fine standalone. In fact as you can see in the
> full dbmail-util log in the bugreport, the same query runs *several times*
> before actually failing.
> 
> Any other ideas on how to pin this down?
> _______________________________________________
> DBmail mailing list
> DBmail <at> dbmail.org
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
> 

--

-- 
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl

Paul J Stevens wrote:
> I don't have a clue. I use non-local tcp connections from dbmail-2.2 to
> mysql servers (32bit) all the time without any problems like this.
> 
> Only thing I havent tested is connecting from a 32bit mysql client to a
> 64 bit mysql server....
> 
> 

Upgrading to 5.1 seems to make the issue disappear entirely. Now all I need
to know if mysql 5.1 is still a disaster a year after it was released. If it
performs acceptably - I'll just close the bug and move on.

_______________________________________________
DBmail mailing list
DBmail <at> dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Eric Hiller wrote:
> I want to forbid the user from deleting or renaming a certain folder.
> According the IMAP specs I need to take away the right for:
> 
>    x - delete mailbox (DELETE mailbox, old mailbox name in RENAME)
> 
> But I do not see this in ACL. Does dbmail support this and I am just looking in the wrong location?

This particular permission is supported in dbmail-2.3+. But the owner of
a mailbox always has the 'a' permission (administer).

For dbmail-2.2 the 'd' - delete permission is used to control access
during the IMAP DELETE command. But again the owner of a mailbox always
has that right.

If you need to prevent deletion of a mailbox owned by a user, you need
to set the mailbox read-only in the dbmail_mailboxes table by setting
the permission field to 1 instead of 2.

--

-- 
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl

Mon	Tue	Wed	Thu	Fri	Sat	Sun

				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30	31

53	June 2013
36	May 2013
40	April 2013
37	March 2013
31	February 2013
29	January 2013
23	December 2012
20	November 2012
38	October 2012
19	September 2012
76	August 2012
21	July 2012
42	June 2012
47	May 2012
95	April 2012
59	March 2012
191	February 2012
56	January 2012
9	December 2011
8	November 2011
26	October 2011
49	September 2011
59	August 2011
22	July 2011
28	June 2011
67	May 2011
23	April 2011
35	March 2011
32	February 2011
53	January 2011
33	December 2010
30	November 2010
53	October 2010
43	September 2010
60	August 2010
43	July 2010
29	June 2010
28	May 2010
25	April 2010
36	March 2010
43	February 2010
44	January 2010
83	December 2009
38	November 2009
51	October 2009
99	September 2009
77	August 2009
54	July 2009
73	June 2009
77	May 2009
64	April 2009
81	March 2009
145	February 2009
225	January 2009
101	December 2008
67	November 2008
192	October 2008
61	September 2008
145	August 2008
78	July 2008
101	June 2008
144	May 2008
143	April 2008
131	March 2008
180	February 2008
149	January 2008
205	December 2007
147	November 2007
205	October 2007
203	September 2007
212	August 2007
423	July 2007
412	June 2007
382	May 2007
160	April 2007
339	March 2007
145	February 2007
267	January 2007
429	December 2006
504	November 2006
223	October 2006
173	September 2006
237	August 2006
296	July 2006
247	June 2006
310	May 2006
242	April 2006
251	March 2006
119	February 2006
154	January 2006
209	December 2005
171	November 2005
77	October 2005
154	September 2005
185	August 2005
161	July 2005
185	June 2005
103	May 2005
223	April 2005
218	March 2005
100	February 2005
129	January 2005
168	December 2004
150	November 2004
173	October 2004
172	September 2004
102	August 2004
138	July 2004
124	June 2004
229	May 2004
162	April 2004
231	March 2004
231	February 2004
103	January 2004
100	December 2003

Signup for DBMail Bug Tracker

Re: Signup for DBMail Bug Tracker

Problems working with a non-local (tcp-reachable) mysql database

Re: Problems working with a non-local (tcp-reachable) mysql database

Re: Problems working with a non-local (tcp-reachable) mysql database

Re: Problems working with a non-local (tcp-reachable) mysql database

Re: Problems working with a non-local (tcp-reachable) mysql database

Re: Problems working with a non-local (tcp-reachable) mysql database

Forbid user from deleting folder.

Re: Forbid user from deleting folder.