Modify

Opened 9 years ago

Closed 9 years ago

#258 closed defect (duplicate)

email2trac : OperationalError: SQL logic error or missing database

Reported by: margus@… Owned by: bas
Priority: major Milestone:
Component: run_emailtrac Version: 2.1.0
Keywords: Cc:

Description

email2trac : OperationalError?: SQL logic error or missing database

Attachments (0)

Change History (2)

comment:1 Changed 9 years ago by margus@…

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

comment:2 Changed 9 years ago by bas

  • Resolution set to duplicate
  • Status changed from new to closed

Add Comment

Modify Ticket

Change Properties
Action
as closed The owner will remain bas.
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.