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 
}}}

email2trac option ticket_permission_system: trac is not working.

Aug 5 04:56:23 monitor-vm Trac[env] INFO: -------------------------------- environment startup [Trac 0.12.2] -------------------------------- Aug 5 04:56:23 monitor-vm email2trac sinonet: subject: test Aug 5 04:56:24 monitor-vm email2trac sinonet: Traceback (most recent call last): Aug 5 04:56:24 monitor-vm email2trac sinonet: File "/usr/local/email2trac/bin/email2trac", line 2467, in ? tktparser.parse(sys.stdin) Aug 5 04:56:24 monitor-vm email2trac sinonet: File "/usr/local/email2trac/bin/email2trac", line 1660, in parse self.new_ticket(m, subject, spam_msg) Aug 5 04:56:24 monitor-vm email2trac sinonet: File "/usr/local/email2trac/bin/email2trac", line 1069, in new_ticket if not self.check_permission(tkt, 'TICKET_CREATE'): Aug 5 04:56:24 monitor-vm email2trac sinonet: File "/usr/local/email2trac/bin/email2trac", line 693, in check_permission if perm.check_permission(action, self.author): Aug 5 04:56:24 monitor-vm email2trac sinonet: File "build/bdist.linux-i686/egg/trac/perm.py", line 454, in check_permission Aug 5 04:56:24 monitor-vm email2trac sinonet: File "build/bdist.linux-i686/egg/privatetickets/policy.py", line 32, in check_permission Aug 5 04:56:24 monitor-vm email2trac sinonet: TypeError?: iterable argument required

I am running fetchmail on Ubuntu 8.04 with the following /etc/fetchmailrc

server mail.zzz.yy
proto pop3
user trac@somewhere.yy
pass mypassword
is www-data here
mda "email2trac"

Therefore, email2trac runs as user fetchmail.

Apache runs as www-data, the trac-directory is owend by www-data:wwwdata, ug+rwx.

As I expected, I get The user fetchmail requires read _and_ write permissions to the database file /yyy/trac/test/db/trac.db and the directory it is located in.

If I add the fetchmail-user to the www-data secondary group, tickets are created nicely. However, in the attachments directory, the subdirectories are owned by fetchmail:nogroup and as a result, I get Attachment ... not found errors.

Of course, I can "chown www-data -R /yyy/trac/" and then it works.

run_email2trac fails with an fetchmail: Query status=6 (IOERR) and is set to ---s--x--x 1 root root

How can I make email2trac run as www-data?

This is my /etc/email2trac.conf

[DEFAULT]
project: /yyy/trac/test
debug: 1
umask: 022
spam_level: 5
reply_all : 0
mailto_link: 0
umask: 022
email_header: 0
trac_version: 0.12
alternate_notify_template :
alternate_notify_template_update :
drop_spam : 0
verbatim_format: 1
strip_signature: 1
email_quote: >
strip_quotes: 0
ignore_trac_user_settings: 0
black_list: MAILER-DAEMON@
drop_alternative_html_version: 1
log_file: /tmp/email2trac.log
log_level: info
mta_user : fetchmail
trac_user : www-data

[test]
project: /yyy/trac/test
spam_level: 1