Custom Query (332 matches)
Results (85 - 87 of 332)
Ticket | Resolution | Summary | Owner | Reporter |
---|---|---|---|---|
#140 | duplicate | email2trac not parsing emails | bas | delpheye@… |
Description |
I have fetchmail and procmail installed and configured correctly(I assume) to process mail sent to trac for the mta_user. [mta_user@boxbox ~]$ cat .procmailrc PATH=/bin:/usr/bin:/usr/bin MAILDIR=$HOME/Mail #better make sure it exists DEFAULT=$MAILDIR/mbox #completely optional LOGFILE=$MAILDIR/from #recommended :0 h b
[mta_user@boxbox ~]$ cat .fetchmailrc poll imap.mydomain.com proto pop3 user mta_user pass "password" mda "/usr/bin/procmail" [root@boxbox ~]# cat /etc/email2trac.conf [DEFAULT] project: /var/www/html/trac debug: 0 umask: 022 spam_level: 5 reply_all : 0 mailto_link: 0 umask: 022 email_header: 0 trac_version: 0.11 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 black_list: MAILER-DAEMON@ I have verified the paths in these two files and have verified that mail is being correctly delivered to the user's local mbox file. strace on the run_email2trac binary doesn't return any errors so I assume it's working correctly. Is there something else I'm missing? |
|||
#182 | fixed | Email2trac on Dreamhost | bas | shildebrand@… |
Description |
I'm trying to install on Dreamhost but having trouble. Would it be possible to get into this deeper with you to try and figure out what's going on? |
|||
#257 | fixed | email2trac : OperationalError: SQL logic error or missing database | bas | anonymous |
Description |
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 }}} |