Custom Query (332 matches)

Hi,

installed email2trac: ./configure -with-trac_user=apache --with-mta_user=nobody

in to /etc/alias file I put: msupport: "|/usr/local/bin/run_email2trac --project=margusja"

[14:52:53 root@arendus bin :/usr/local/bin]# /usr/local/bin/email2trac < /tmp/msg.txt saving email to /tmp/tmppyJ_Ff.email2trac writing body to /tmp/tmpNSvy4Q.email2trac [14:53:21 root@arendus bin :/usr/local/bin] And a new ticket appears into database.

And the typical case - I can't create ticket via e-mail.

here is my email2trac.conf:

[DEFAULT]
project: /var/www/trac/margusja
debug: 99
log_type: file
log_file: /tmp/email2trac.log
log_level: DEBUG
umask: 022
spam_level: 5
reply_all : 0
mailto_link: 0
umask: 022
email_header: 0
trac_version: 0.12
enable_syslog : 1
alternate_notify_template :
alternate_notify_template_update :
drop_spam : 0
verbatim_format: 1
strip_signature: 0
email_quote: >
strip_quotes: 0
ignore_trac_user_settings: 0
lack_list: MAILER-DAEMON@
drop_alternative_html_version: 1
python_egg_cache: /tmp

[margusja]
project: /var/www/trac/margusja/
spam_level: 5

[okia]
project: /var/www/trac/okia/
spam_level: 5

in maillog:

2011-07-29T14:32:08.816598+03:00 arendus postfix/local[12388]: 4E942398018: to=<msupport@arendus.okia.ee>, relay=local, delay=0.5, delays=0.01/0.01/0/0.48, dsn=5.3.0, status=bounced (Command died with status 1: "/usr/local/bin/run_email2trac --project=margusja". Command output: saving email to /tmp/tmpUSSSI_.email2trac writing body to /tmp/tmphDAvFH.email2trac saving email to /tmp/tmpRcebZ9.email2trac writing body to /tmp/tmpZH0dUJ.email2trac )}}}

debug:
{{{
2011-07-29 14:57:52,378 email2trac : Found trac version: 0.12
2011-07-29 14:57:52,515 email2trac : Loading environment /var/www/trac/margusja/
2011-07-29 14:57:52,616 email2trac : Main function parse
2011-07-29 14:57:52,626 email2trac : function get_message_parts()
2011-07-29 14:57:52,626 email2trac : 	 Message part: Main-Type: text
2011-07-29 14:57:52,626 email2trac : 	 Message part: Content-Type: text/plain
2011-07-29 14:57:52,626 email2trac : function inline_part()
2011-07-29 14:57:52,627 email2trac : function unique_attachment_names()
2011-07-29 14:57:52,627 email2trac : function get_body_text()
2011-07-29 14:57:52,628 email2trac : function debug_attachments
2011-07-29 14:57:52,630 email2trac : function email_to_unicode
2011-07-29 14:57:52,630 email2trac : function email_to_unicode
2011-07-29 14:57:52,632 email2trac : function email_header_acl: white_list
2011-07-29 14:57:52,632 email2trac : white_list not defined, all messages are allowed.
2011-07-29 14:57:52,632 email2trac : function email_header_acl: black_list
2011-07-29 14:57:52,632 email2trac : black_list not defined, all messages are allowed.
2011-07-29 14:57:52,633 email2trac : function email_header_acl: recipient_list
2011-07-29 14:57:52,633 email2trac : recipient_list not defined, all messages are allowed.
2011-07-29 14:57:52,633 email2trac : function email_to_unicode
2011-07-29 14:57:52,633 email2trac : subject: test
2011-07-29 14:57:52,634 email2trac : function ticket_update_by_subject
2011-07-29 14:57:52,634 email2trac : function new_ticket
2011-07-29 14:57:52,643 email2trac : function set_reply_fields
2011-07-29 14:57:52,643 email2trac : function set_ticket_fields
2011-07-29 14:57:52,643 email2trac : trac[summary] = 
2011-07-29 14:57:52,643 email2trac : trac[reporter] = 
2011-07-29 14:57:52,644 email2trac : trac[owner] = 
2011-07-29 14:57:52,644 email2trac : trac[description] = 
2011-07-29 14:57:52,644 email2trac : trac[type] = defect
2011-07-29 14:57:52,644 email2trac : used type = defect
2011-07-29 14:57:52,644 email2trac : trac[status] = 
2011-07-29 14:57:52,644 email2trac : trac[priority] = major
2011-07-29 14:57:52,644 email2trac : used priority = major
2011-07-29 14:57:52,645 email2trac : trac[milestone] = 
2011-07-29 14:57:52,645 email2trac : trac[component] = 
2011-07-29 14:57:52,645 email2trac : trac[resolution] = None
2011-07-29 14:57:52,645 email2trac : trac[keywords] = 
2011-07-29 14:57:52,645 email2trac : trac[cc] = 
2011-07-29 14:57:52,645 email2trac : trac[time] = 
2011-07-29 14:57:52,645 email2trac : trac[changetime] = 
2011-07-29 14:57:52,646 email2trac : trac[estimatedhours] = 0
2011-07-29 14:57:52,646 email2trac : used estimatedhours = 0
2011-07-29 14:57:52,646 email2trac : trac[hours] = 0
2011-07-29 14:57:52,646 email2trac : used hours = 0
2011-07-29 14:57:52,646 email2trac : trac[billable] = 1
2011-07-29 14:57:52,646 email2trac : used billable = 1
2011-07-29 14:57:52,646 email2trac : trac[totalhours] = 0
2011-07-29 14:57:52,647 email2trac : used totalhours = 0
2011-07-29 14:57:52,647 email2trac : function update_ticket_fields
2011-07-29 14:57:52,647 email2trac : user_field	 totalhours = 0
2011-07-29 14:57:52,647 email2trac : ticket_field	 totalhours = 0
2011-07-29 14:57:52,647 email2trac : user_field	 hours = 0
2011-07-29 14:57:52,647 email2trac : ticket_field	 hours = 0
2011-07-29 14:57:52,647 email2trac : user_field	 priority = major
2011-07-29 14:57:52,647 email2trac : ticket_field	 priority = major
2011-07-29 14:57:52,648 email2trac : user_field	 billable = 1
2011-07-29 14:57:52,648 email2trac : ticket_field	 billable = 1
2011-07-29 14:57:52,648 email2trac : user_field	 estimatedhours = 0
2011-07-29 14:57:52,648 email2trac : ticket_field	 estimatedhours = 0
2011-07-29 14:57:52,648 email2trac : user_field	 type = defect
2011-07-29 14:57:52,648 email2trac : ticket_field	 type = defect
2011-07-29 14:57:52,648 email2trac : function get_message_parts()
2011-07-29 14:57:52,649 email2trac : 	 Message part: Main-Type: text
2011-07-29 14:57:52,649 email2trac : 	 Message part: Content-Type: text/plain
2011-07-29 14:57:52,649 email2trac : function inline_part()
2011-07-29 14:57:52,649 email2trac : function unique_attachment_names()
2011-07-29 14:57:52,649 email2trac : function get_body_text()
2011-07-29 14:57:52,655 email2trac : Traceback (most recent call last):

2011-07-29 14:57:52,655 email2trac :   File "/usr/local/bin/email2trac", line 2467, in <module>
    tktparser.parse(sys.stdin)

2011-07-29 14:57:52,655 email2trac :   File "/usr/local/bin/email2trac", line 1660, in parse
    self.new_ticket(m, subject, spam_msg)

2011-07-29 14:57:52,655 email2trac :   File "/usr/local/bin/email2trac", line 1125, in new_ticket
    self.id = tkt.insert()

2011-07-29 14:57:52,655 email2trac :   File "/usr/lib/python2.5/site-packages/trac/ticket/model.py", line 226, in insert
    @self.env.with_transaction(db)

2011-07-29 14:57:52,655 email2trac :   File "/usr/lib/python2.5/site-packages/trac/db/api.py", line 82, in transaction_wrapper
    ldb.rollback()

2011-07-29 14:57:52,655 email2trac :   File "/usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py", line 286, in rollback
    self.cnx.rollback()

2011-07-29 14:57:52,656 email2trac : OperationalError: SQL logic error or missing database

2011-07-29 14:57:52,657 email2trac : function get_message_parts()
2011-07-29 14:57:52,657 email2trac : 	 Message part: Main-Type: text
2011-07-29 14:57:52,658 email2trac : 	 Message part: Content-Type: text/plain
2011-07-29 14:57:52,658 email2trac : function inline_part()
2011-07-29 14:57:52,658 email2trac : function unique_attachment_names()
2011-07-29 14:57:52,658 email2trac : function get_body_text()
2011-07-29 14:57:52,659 email2trac : function debug_attachments 
}}}

I set only one account in the recipient_list. When the users sends an issue to our support email which is in the recipient_list but they put another email before the support email in the to-field, a ticket is not created. log message says that the other email is not in the recipient list. Is there any work around to check all the emails in the to-field?

I set om@… as my recipient_list.And we have another email aom@…. When i send an email to aom@… from om@…, a ticket is created. is it because of the aom/om? or just a matter of misconfiguration.