Custom Query (332 matches)

Filters
 
Or
 
  
 
Columns

Show under each result:

Results (88 - 90 of 332)

← 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 →
Ticket Resolution Summary Owner Reporter
#258 duplicate email2trac : OperationalError: SQL logic error or missing database bas margus@…
Description

email2trac : OperationalError?: SQL logic error or missing database

#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 
}}}
#256 fixed to env or not to env .. that is the question.. bas edward.b.matheson@…
Description

So I am getting this in the output logs

2011-07-28 13:52:54,438 email2trac atol: Loading environment /var/trac/atol 2011-07-28 13:52:54,577 email2trac atol: Trac project does not exists: /var/trac/atol

  • email2trac.conf 
    [DEFAULT]
parentdir: /var/trac
project: /var/trac/atol
debug: 1
log_type: file
log_level: DEBUG
log_file: /tmp/email2trac.log
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: 1
email_quote: >
strip_quotes: 0
ignore_trac_user_settings: 0
black_list: MAILER-DAEMON@
drop_alternative_html_version: 1
ticket_update: 1
strip_signature: 1
html2text_cmd: /usr/bin/html2text -nobs
trac_version: 0.12

[atol]
d318support_component : Branch_Support
d318support_ttd : D318-support

atolsupport_component : ATOLNet
atolsupport_ttd : atol-support
  • aliases 
    trac: "| /usr/local/bin/email2trac --project=atol"
d318-support: "| /usr/local/bin/email2trac --project=atol --ticket_prefix=d318support"
atol-support: "| /usr/local/bin/email2trac --project=atol --ticket_prefix=atolsupport"
  • using trac .0.12.2
  • I can't get any of the aliases working.. help?
← 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 →
Note: See TracQuery for help on using queries.