mail2ticket.py script not building queue with SQLAlchemy v0.4.9
nexco - July 19, 2009 - 09:41
| Project: | Trouble ticketing system to support Computer Network Operations |
| Version: | 6.x-3.0-rc3 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
We have installed the new release of SQLAlchemy v0.5.5 (released July 13) but cannot get the incoming emails to register in the ticket system queue. We have used the various scripts in the email directory and they do forward the email to the proper email address, but the script does not appear to be hitting the database to insert the email in the queue. There are no error logs to show a problem. Just seems not to be saving to the database.
Are we restricted to using version 0.3x or 0.4x of SQLAlchemy with the mail2ticket script? Do you support v0.5x?
Thank you.
Gregg
#1
We have down-graded to SQLAlchemy version 0.4.9 and we are still unable to get emails added to the queue. The script is successfully forwarding the email to both the "to" address in the script and the "tickets" email address. However, the script does not appear to be updating the MySQL database.
We are using Qmail for this installation not SendMail - could that be the issue? We are running a Linux box administered by Plesk that uses Qmail. In our install, the script is placed in
/var/qmail/mailnames/domainname.com/tickets
and looks like this
| /usr/local/bin/mail2ticket.py tickets@domainname.com
Will the script work with Qmail?
Thank you,
Gregg
#2
Dear nexco,
The mail address should be an alias what is for incoming mails. The alias setup is in the ticketing's admin documentation
http://www.niif.hu/en/1_installing_trouble_ticketing_system
Here you can see examples about aliases:
http://drupal.org/node/508248
If it will also not working then try to watch the log file of the mail server. Please send to us the error messages.
The SQLAlchemy v0.4.4 version is enough for the the ticketing system. It is working with it well.
#3