UPDATE - Perl/SSL - Script failed to send data - WITS END!!

Moderator: crythias

Locked
JoseSalviati
Znuny newbie
Posts: 3
Joined: 19 Aug 2013, 18:01
Znuny Version: 3.2.7
Real Name: Jose Salviati
Company: Accenture

UPDATE - Perl/SSL - Script failed to send data - WITS END!!

Post by JoseSalviati »

I am using OTRS Version: 3.2.7
I am using OS: Windows 7
I am using Database: ProstgreSQL
I have this problem: Error saving Changes
I am encountering my issue on this screen: Creation of Change screen
I can replicate the issue by: After the issue starts, it occurs on 100% of changes I attempt to create
This is what I've tried: Different OS (Suse Linux), different db (mySQL) and multiple posts on other forums
These are the posts I've found that are relevant, but don't seem to answer my question: It happens only within the ITSM - Change component. Appears to lose connection to the database.
I've looked at the HowTos on this: Several forums - I disabled JSON and YMAL based on suggestions, which did resolve other issues, but not this one.
I've looked at the Docs.: Docs werent very helpful
The logs say: See below
I've done a non-specific generic search for the error message and it says: Lost connection to dbase
That doesn't apply to me because: I can still get to the dbase AND the change I made when I get the error IS saved - just without the detail I inputted.
My question is: How can I get this to work?

Here is my original post:

Ok, as sold as I am on OTRS (and I am sold, love it – wish I could implement it here!!) I am ready to walk away. I have worked through every issue and am fairly confident I have the one that has been causing me grief all along identified.

When I install ITSM and create a new Change I get an error. This is consistent now on multiple versions (Windows, Linux) and multiple DB versions (MySQL, PostreSQL). The error will vary depending on the browser but the cause seems to be an inability to get to the database. I either get “Script failed to send data” or just a standard website not available. This happens when I create a change. I have been able to create as many as two before the error shows up. Sometimes, it shows up immediately. The odd part is that the record IS created, but not with any of the detail I entered.

Might this be a problem with the ITSM component?

I am running OTRS ITSM 3.2.7 – currently on Windows 7 and PostreSQL. Any guidance you can provide is very appreciated!
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][
Last edited by JoseSalviati on 21 Aug 2013, 19:22, edited 1 time in total.
JoseSalviati
Znuny newbie
Posts: 3
Joined: 19 Aug 2013, 18:01
Znuny Version: 3.2.7
Real Name: Jose Salviati
Company: Accenture

UPDATE - Re: Script failed to send data - WITS END!!

Post by JoseSalviati »

I feel as if I have finally found the root cause of all my issues. I found this in the PerlEX log: Can someone tell me how to force Perl to not require SSL or configure OTRS to use it? I would much rather NOT use it, but finding the “off” switch in Perl has proven troublesome. As always, any assistance you can provide is very appreciated.

*** 'C:\otrs\OTRS\bin\cgi-bin\index.pl' log message at: 2013/08/21 07:10:26
[Wed Aug 21 07:09:37 2013] -e: *******************************************************************
[Wed Aug 21 07:09:37 2013] -e: Using the default of SSL_verify_mode of SSL_VERIFY_NONE for client
[Wed Aug 21 07:09:37 2013] -e: is deprecated! Please set SSL_verify_mode to SSL_VERIFY_PEER
[Wed Aug 21 07:09:37 2013] -e: together with SSL_ca_file|SSL_ca_path for verification.
[Wed Aug 21 07:09:37 2013] -e: If you really don't want to verify the certificate and keep the
[Wed Aug 21 07:09:37 2013] -e: connection open to Man-In-The-Middle attacks please set
[Wed Aug 21 07:09:37 2013] -e: SSL_verify_mode explicitly to SSL_VERIFY_NONE in your application.
[Wed Aug 21 07:09:37 2013] -e: *******************************************************************
Locked