openerp-india team mailing list archive

["Grzegorz Grzelak \(OpenGLOBE.pl\)" <grzegorz@xxxxxxxxxxxx>]

I am sorry for so late answer.

It seems that my cooperation with that customer has finished.  Also
because of strange behaviour of fetchmail module. Before that customer
used in ver5.0 module mail_gateway with fetchmail set in command line.
And it worked fine for him.

In 6.0.2 we have switched to module fetchmail with settings of POP
server in graphical user interface. And this way worked much worse.
First of all when arrive an email with something not recognised (as in
this bug) it stopped to fetch any other mails. It seems that it should
simply omit wrong mail and fetch next in queue. But it stopped at wrong
mail and next time repeated the same procedure not fetching anything
until you manually remove unrecognised mail from mailbox.

In that case above I seem that customer used time settings for Poland.
But I don't think it is a problem with time settings. The mail arrived
with some text %AMS_MESSAGE_DATE% in date field instead of date and this
text should be replaced to some date (probably current) by mail fetcher.
It seems that fetchmail module doesn't do that. Anyway it should omit
not parsed mail and go to next one to clean up the queue.

By now I have no contact with the customer and I am not able to generate
such strange mails to provide more information.

Please close the bug. I will reopen it when it is something new.

I apologize to take your time.

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/927556

Title:
  [6-stab] fetchmail crashs when AMS_MESSAGE_DATE

Status in OpenERP Addons (modules):
  Incomplete

Bug description:
  It is part of log when strange SPAM message arrives. And it locks
  message receiving. Addresses in log are edited to not disclosure
  customer data.

  I see that fetchmail tries to enter some agregated date
  %AMS_MESSAGE_DATE% to field date. It seems that it should be replaced
  before INSERT command.

  [2012-02-05 11:28:18,851][ipl] ERROR:db.cursor:bad query: insert into "mailgate_message"
  (id,"description","server_type","email_bcc","email_to","references","date","partner_id","server_id","user_id","name","message_id","email_cc","model","res_id","email_from","history",create_uid,create_date)
  values (75936,E' * Ne manquez pas l''evenement ,toute l''equipe commerciale d''Horizons expo (groupe SOGEFOIRES) est à votre disposition pour vous
  informer et préparer avec vous votre participation à INPACK 2012. Pour plus d''information veuillez contacter: Mr CHAOUACHI ASSILA:GSM 26838111
  ',E'pop',NULL,E'info@xxxxxxx',NULL,E'%AMS_MESSAGE_DATE%',NULL,6,1,E'[SPAM] Salon International de l''hotellerie et de la Restauration SIHER
  2012',E'<auto-000545479634@xxxxxxxxxxxxxxxxxx>',NULL,E'crm.lead',16099,E'"Groupe sogefoires" <contact@xxxxxxxxxxxxxxxx>',E'True',1,now())
  Traceback (most recent call last):
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  DataError: invalid input syntax for type timestamp: "%AMS_MESSAGE_DATE%"
  LINE 3: ',E'pop',NULL,E'info@xxxxxxx',NULL,E'%AMS_MESSAGE_DATE%'...
                                                 ^

  [2012-02-05 11:28:18,852][ipl] WARNING:pop:[01]: invalid input syntax for type timestamp: "%AMS_MESSAGE_DATE%"
  [2012-02-05 11:28:18,852][ipl] WARNING:pop:[02]: LINE 3: ',E'pop',NULL,E'info@xxxxxxx',NULL,E'%AMS_MESSAGE_DATE%'...
  [2012-02-05 11:28:18,852][ipl] WARNING:pop:[03]:                                                ^
  [2012-02-05 11:28:18,866][ipl] ERROR:db.cursor:bad query: update ir_cron set nextcall=E'2012-02-05 11:33:13', numbercall=-1 where id=6
  Traceback (most recent call last):
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  InternalError: current transaction is aborted, commands ignored until end of transaction block

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/927556/+subscriptions