Kevin - You may well remember that we are in the process of trying to get
2.1-rc7 running on SUSE Linux 9.1 with Postgresql 8.0.8 and Zope 2.8.8. We
have the system running. However, getMail is erroring out trying to process
any message it finds in the account's inbox. I am attaching the event.log
entry. We think it is telling us that there is a database function missing that
mailmanager porvides (mailmanager.ts_aggregate(integer)).
NOTE: We had to downgrade Zope from 2.9 to 2.8.8 at onetime. Therefore, we
thought it best to attempt removing mailmanager, deleting all of the tables it
created and reinstalling MailManager. We did this and it solved nothing. We
have replaced the Zope_Scheduler with ClockServer and were able to get
"getMail" to trigger by specifying method "/mailmanager/getMail" every 10
minutes. However, if mail is in the Account's INBOX this error occurs.
Dick Calhoun
InterMedi@ Marketing Solutions
Ofc. Ph: 610-701-9654
------
2006-09-06T18:10:13 INFO event.mailmanager.getmail INFO(20) MailManager:
getIMAP: Fetching 1 message(s) from /mailmanager IMAP server, account [EMAIL
PROTECTED]
------
2006-09-06T18:10:13 INFO event.mailmanager.getmail INFO(20) MailManager:
getIMAP: Processing incoming message idx 1 of 1 from /mailmanager IMAP server,
account [EMAIL PROTECTED]
------
2006-09-06T18:10:13 INFO event.mailmanager.process INFO(20) MailManager:
process: Message from "Dick Calhoun - Imm" <[EMAIL PROTECTED]>
------
2006-09-06T18:10:13 ERROR Zope.SiteErrorLog
http://mailmanager/mailmanager/getMail
Traceback (most recent call last):
File "/opt/Zope-2.8.8/lib/python/ZPublisher/Publish.py", line 114, in publish
request, bind=1)
File "/opt/Zope-2.8.8/lib/python/ZPublisher/mapply.py", line 88, in mapply
if debug is not None: return debug(object,args,context)
File "/opt/Zope-2.8.8/lib/python/ZPublisher/Publish.py", line 40, in
call_object
result=apply(object,args) # Type s<cr> to step into published object.
File "/opt/Zope-2.8.8/lib/python/Products/MailManager/MailManager.py", line
1376, in getMail
rets = [self.account(email=accountname)[0].getMail()
File
"/opt/Zope-2.8.8/lib/python/Products/MailManager/Extensions/AccountPluggableBrain.py",
line 601, in getMail
ret = self._getIMAP()
File
"/opt/Zope-2.8.8/lib/python/Products/MailManager/Extensions/AccountPluggableBrain.py",
line 701, in _getIMAP
rets.append(self.process(data[0][1]))
File
"/opt/Zope-2.8.8/lib/python/Products/MailManager/Extensions/AccountPluggableBrain.py",
line 200, in process
self.process_addMsgToTicket(msg, ticket_id)
File
"/opt/Zope-2.8.8/lib/python/Products/MailManager/Extensions/AccountPluggableBrain.py",
line 273, in process_addMsgToTicket
self.addMessageToTicket(ticket_id, msg)
File "/opt/Zope-2.8.8/lib/python/Products/MailManager/MailManager.py", line
1533, in addMessageToTicket
sqv_html_body=html_body)
File "/opt/Zope-2.8.8/lib/python/Products/MailManager/sql/__init__.py", line
152, in __call__
return FSZSQLMethod.__call__(self, *args, **convkw)
File "/opt/Zope-2.8.8/lib/python/Shared/DC/ZRDB/DA.py", line 454, in __call__
else: result=DB__.query(query, self.max_rows_)
File "/opt/Zope-2.8.8/lib/python/Products/ZPsycopgDA/db.py", line 246, in
query
raise err
ProgrammingError: ERROR: could not find tsearch config by locale
INSERT INTO mm_message (id, ticket_id, message_id, from_name,
from_email, subject, msg_date,
msg_to, cc, bcc, reply_to, raw_headers,
body, html_body)
VALUES (2,
2,
'<[EMAIL PROTECTED]>',
'Dick Calhoun - Imm',
'[EMAIL PROTECTED]',
'TEST',
'2006-09-05T19:55:39',
'"MailManager Admin" <[EMAIL PROTECTED]>',
'',
'',
'',
'Received: from localhost (localhost.localdomain
[127.0.0.1])\\012\\011by mail.imminc.com (Postfix) with ESMTP id
68D1C6BD060\\012\\011for <[EMAIL PROTECTED]>; Tue, 5 Sep 2006 15:56:08 -0400
(EDT)\\012Received: from mail.imminc.com ([127.0.0.1])\\012\\011by localhost
(mail.imminc.com [127.0.0.1]) (amavisd-new, port 10024)\\012\\011with ESMTP id
23605-10 for <[EMAIL PROTECTED]>;\\012\\011Tue, 5 Sep 2006 15:56:07 -0400
(EDT)\\012Received: from sccrmhc13.comcast.net (sccrmhc13.comcast.net
[204.127.200.83])\\012\\011by mail.imminc.com (Postfix) with ESMTP id
935A46BD05D\\012\\011for <[EMAIL PROTECTED]>; Tue, 5 Sep 2006 15:56:07 -0400
(EDT)\\012Received: from ibmlaptop
(host220.imminc.com?[63.65.26.220])\\012\\011by comcast.net (sccrmhc13) with
SMTP\\012\\011id <20060905195607013006qb1ee>; Tue, 5 Sep 2006 19:56:07
+0000\\012Message-ID: <[EMAIL PROTECTED]>\\012From: "Dick Calhoun - Imm"
<[EMAIL PROTECTED]>\\012To: "MailManager Admin" <[EMAIL
PROTECTED]>\\012Subject: TEST\\012Date: Tue, 5 Sep 2006 15:55:39
-0400\\012MIME-Version: 1.0\\012Content-Type:
multipart/alternative;\\012\\011boundary="----=_NextPart_000_0005_01C6D103.BC19EAC0"\\012X-Priority:
3\\012X-MSMail-Priority: Normal\\012X-Mailer: Microsoft Outlook Express
6.00.2900.2869\\012X-MimeOLE: Produced By Microsoft MimeOLE
V6.00.2900.2869\\012X-DSPAM-Result: Innocent\\012X-DSPAM-Processed: Tue Sep 5
15:56:08 2006\\012X-DSPAM-Confidence: 0.9996\\012X-DSPAM-Probability:
0.0000\\012X-DSPAM-Signature: 44fdd657258341614319555\\012X-DSPAM-Factors:
27,\\012X-Virus-Scanned: amavisd-new at \\012X-Spam-Status: No, score=2.425
tagged_above=-10 required=6.6 autolearn=no\\012\\011tests=[AWL=0.109,
BAYES_20=-0.74, DNS_FROM_RFC_POST=1.708,\\012\\011DNS_FROM_RFC_WHOIS=1.447,
DSPAM_HAM=-0.1, HTML_MESSAGE=0.001]\\012X-Spam-Score: 2.425\\012X-Spam-Level:
**\\012\\012'::bytea,
'TEST - TEST - 2 for Linux MailManager.',
'<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2912" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>TEST - TEST - 2 for Linux
MailManager.</FONT></DIV></BODY></HTML>
')
------
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Mailmanager-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mailmanager-users
