Hahaha, sorry about that - yes, I meant writes :) When I enter a change I enter information in the description, title and justification fields. I click SAVE the system pauses for about 15 seconds then returns the error. When I go back to Changes|Overview, my change is there only without the detail I added in the description, title and justification fields! If I edit that record and enter my details, the dbase accepts the changes without issue. However, if I try to make changes to an existing change by adding a workorder or condition the error returns. Can you connect to postgres?
Yes, I can connect to postgres and was able to get to MySQL before when I used that.
Will postgres accept connections from the OTRS (user/pass correct, ACL correct)?
It seems to accept all users and the permissions I set in OTRS seem to be valid (ei: I can see everything I am supposed to see)
What does PostGres' logs indicate?
I didn't see anything in the event viewer at all. I changed postregresql.conf to write (not right :) ) to a CSV moving forward. I will post results when I get them!
Is the OTRS DB connection correct (hostname, etc. etc.)?
The DB was installed on the same machine as the application. Localhost is correct - hostname identified in the install of OTRS is correct.
Thanks again for your help. Jose From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of LQ Marshall Sent: Monday, August 19, 2013 9:52 AM To: 'User questions and discussions about OTRS.' Subject: Re: [otrs] Script failed to send data - WITS END! "the system rights my change into the database, just without my changes" I assume that you ment writes rather than rights. In either case I don't understand what it meant by this? Can you connect to postgres? Will postgres accept connections from the OTRS (user/pass correct, ACL correct)? What does PostGres' logs indicate? Is the OTRS DB connection correct (hostname, etc. etc.)? From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of jose.salviati@accenture.commailto:jose.salviati@accenture.com Sent: Monday, August 19, 2013 12:40 PM To: otrs@otrs.orgmailto:otrs@otrs.org Subject: Re: [otrs] Script failed to send data - WITS END! I agree it's a simple enough error to diagnose, and I'm sorry for not being more clear but PostGres IS running, just like MySQL was running before when I used it. Another issue is that even though that error occurs, the system rights my change into the database, just without my changes. I assumed that postgres and/or sql was configured by OTRS to listen on the localhost/127.0.0.1 - is that an incorrect assumption? My firewall is off and has been off since install. If I need to make some additional change to the database to get it to listen on the localhost please let me know. Thank you! From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of LQ Marshall Sent: Monday, August 19, 2013 9:26 AM To: 'User questions and discussions about OTRS.' Subject: Re: [otrs] Script failed to send data - WITS END! This error message is self explainatory. OTRS is unable to connect to the database... possible causes include postgres isn't running, postgres isn't listening on the localhost/127.0.0.1, firewall is blocking the connection. From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of jose.salviati@accenture.commailto:jose.salviati@accenture.com Sent: Monday, August 19, 2013 11:51 AM To: otrs@otrs.orgmailto:otrs@otrs.org Subject: [otrs] Script failed to send data - WITS END! I pulled this from the OTRS log in \OTRS\var [Mon Aug 19 08:43:52 2013][Error][Kernel::System::DB::new][224] could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? [Mon Aug 19 08:45:14 2013][Notice][ ________________________________ This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy. ______________________________________________________________________________________ www.accenture.comhttp://www.accenture.com