<div dir="ltr">Thanks everyone for your help with my Net::HL7::Connection issue. I tried netstat and adjusting firewall settings, telnetting to the server with the port and all came up empty. Then a colleague suggested checking the database server to see if it had an HL7 service running, and yep, hl7d was running. I restarted that. and. it. worked! Ahhem. Thanks everyone! :)</div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Oct 6, 2014 at 3:00 PM, <span dir="ltr"><<a href="mailto:baltimore-pm-request@pm.org" target="_blank">baltimore-pm-request@pm.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send Baltimore-pm mailing list submissions to<br>
<a href="mailto:baltimore-pm@pm.org">baltimore-pm@pm.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://mail.pm.org/mailman/listinfo/baltimore-pm" target="_blank">http://mail.pm.org/mailman/listinfo/baltimore-pm</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:baltimore-pm-request@pm.org">baltimore-pm-request@pm.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:baltimore-pm-owner@pm.org">baltimore-pm-owner@pm.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Baltimore-pm digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: help with Net::HL7::Connection (Stephen Belcher)<br>
2. Re: help with Net::HL7::Connection (Zachary Zebrowski)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Mon, 6 Oct 2014 10:36:09 -0400<br>
From: Stephen Belcher <<a href="mailto:sbelcher@gmail.com">sbelcher@gmail.com</a>><br>
To: Baltimore Perl Mongers <<a href="mailto:baltimore-pm@pm.org">baltimore-pm@pm.org</a>><br>
Subject: Re: [baltimorepm] help with Net::HL7::Connection<br>
Message-ID:<br>
<<a href="mailto:CAA1vO_7b4txrNu5jFAPhzyRBE4oUWkSv8_m7gvw-kdAKPMwpbQ@mail.gmail.com">CAA1vO_7b4txrNu5jFAPhzyRBE4oUWkSv8_m7gvw-kdAKPMwpbQ@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
FWIW, on CentOS, it seems that the `netstat -en` command doesn't list<br>
listening sockets, for that you'll need to add the `-l` flag (which then<br>
seems to list *only* listening sockets, not sure how to get both).<br>
Additionally, you can `grep` that output for the port you're trying to<br>
connect on to see if it's open, instead of parsing the whole output, *e.g.*,<br>
`netstat -len | grep :12345` (not 12345, natch, just whatever the port is).<br>
I was hoping there was a way to instruct `netstat` to only care about<br>
particular ports, but I can't seem to find that.<br>
<br>
--Stephen<br>
<br>
On Mon, Oct 6, 2014 at 10:13 AM, Bernie Simon <<a href="mailto:bsimon@stsci.edu">bsimon@stsci.edu</a>> wrote:<br>
<br>
> The standard command to check for open ports is<br>
><br>
> netstat -en<br>
><br>
> More information can be found on the web. Don?t know how this stuff in<br>
> configured under Windows.<br>
><br>
> From: Dawn Wallis <<a href="mailto:wallisds@gmail.com">wallisds@gmail.com</a>><br>
> Reply-To: Baltimore Perl Mongers <<a href="mailto:baltimore-pm@pm.org">baltimore-pm@pm.org</a>><br>
> Date: Monday, October 6, 2014 at 9:48 AM<br>
> To: "<a href="mailto:baltimore-pm@pm.org">baltimore-pm@pm.org</a>" <<a href="mailto:baltimore-pm@pm.org">baltimore-pm@pm.org</a>><br>
> Subject: [baltimorepm] help with Net::HL7::Connection<br>
><br>
> At work we had a Windows XP computer setup to collect lab results from<br>
> Quest. That data was parsed and transferred to our mysql database (on a<br>
> CentOS server) using Net::HL7::Connection. Recently we had to upgrade to<br>
> Windows 7 for the capturing computer. So I'm using Windows 7 to collect<br>
> blood work data from Quest.<br>
><br>
> The scripts that were on the XP machine seem to work pretty well on the<br>
> 7 box too, so I am able to get the data parsed and ready for transport to<br>
> my mysql database server, but it doesn't send.<br>
><br>
> I am getting a "Could not connect. No connection could be made because<br>
> the target machine actively refused it" error.<br>
><br>
> Net::HL7::Connection takes a host and port but no password or anything.<br>
> I figure I'm supposed to open a port on the db server to allow this<br>
> incoming connection, but I'm having trouble figuring that part out. I don't<br>
> know where to look on the centos server to see if a port is open for the<br>
> other xp computer, what file to edit... etc.<br>
><br>
> Any suggestions?<br>
><br>
><br>
><br>
> Thanks,<br>
> Dawn<br>
><br>
> _______________________________________________<br>
> Baltimore-pm mailing list<br>
> <a href="mailto:Baltimore-pm@pm.org">Baltimore-pm@pm.org</a><br>
> <a href="http://mail.pm.org/mailman/listinfo/baltimore-pm" target="_blank">http://mail.pm.org/mailman/listinfo/baltimore-pm</a><br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://mail.pm.org/pipermail/baltimore-pm/attachments/20141006/2696ad5f/attachment-0001.html" target="_blank">http://mail.pm.org/pipermail/baltimore-pm/attachments/20141006/2696ad5f/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Mon, 6 Oct 2014 10:50:01 -0400<br>
From: Zachary Zebrowski <<a href="mailto:zak.zebrowski@gmail.com">zak.zebrowski@gmail.com</a>><br>
To: Baltimore Perl Mongers <<a href="mailto:baltimore-pm@pm.org">baltimore-pm@pm.org</a>><br>
Subject: Re: [baltimorepm] help with Net::HL7::Connection<br>
Message-ID:<br>
<CAO3DSneu2ga=eSXfN=w8NnF-QvSd=<a href="mailto:5q3wObYiQJ463sSq05b7Q@mail.gmail.com">5q3wObYiQJ463sSq05b7Q@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Also, it could be a firewall issue. Some OS's block all ports by default<br>
for inbound connections. I don't know the correct invocation on centos to<br>
see what the firewall settings are, but if centos uses ufw. See if you can<br>
do a:<br>
<br>
sudo ufw status<br>
<br>
if you see it enabled, do a sudo ufw disable and then see if you can<br>
connect in... Obviously, the correct solution then is to figure out what<br>
ports the application is using and then enable those in the firewall, and<br>
re-enable the firewall if this is the case...<br>
<br>
Good luck<br>
<br>
Zak<br>
<br>
<br>
On Mon, Oct 6, 2014 at 10:36 AM, Stephen Belcher <<a href="mailto:sbelcher@gmail.com">sbelcher@gmail.com</a>> wrote:<br>
<br>
> FWIW, on CentOS, it seems that the `netstat -en` command doesn't list<br>
> listening sockets, for that you'll need to add the `-l` flag (which then<br>
> seems to list *only* listening sockets, not sure how to get both).<br>
> Additionally, you can `grep` that output for the port you're trying to<br>
> connect on to see if it's open, instead of parsing the whole output,<br>
> *e.g.*, `netstat -len | grep :12345` (not 12345, natch, just whatever the<br>
> port is). I was hoping there was a way to instruct `netstat` to only care<br>
> about particular ports, but I can't seem to find that.<br>
><br>
> --Stephen<br>
><br>
> On Mon, Oct 6, 2014 at 10:13 AM, Bernie Simon <<a href="mailto:bsimon@stsci.edu">bsimon@stsci.edu</a>> wrote:<br>
><br>
>> The standard command to check for open ports is<br>
>><br>
>> netstat -en<br>
>><br>
>> More information can be found on the web. Don?t know how this stuff in<br>
>> configured under Windows.<br>
>><br>
>> From: Dawn Wallis <<a href="mailto:wallisds@gmail.com">wallisds@gmail.com</a>><br>
>> Reply-To: Baltimore Perl Mongers <<a href="mailto:baltimore-pm@pm.org">baltimore-pm@pm.org</a>><br>
>> Date: Monday, October 6, 2014 at 9:48 AM<br>
>> To: "<a href="mailto:baltimore-pm@pm.org">baltimore-pm@pm.org</a>" <<a href="mailto:baltimore-pm@pm.org">baltimore-pm@pm.org</a>><br>
>> Subject: [baltimorepm] help with Net::HL7::Connection<br>
>><br>
>> At work we had a Windows XP computer setup to collect lab results from<br>
>> Quest. That data was parsed and transferred to our mysql database (on a<br>
>> CentOS server) using Net::HL7::Connection. Recently we had to upgrade to<br>
>> Windows 7 for the capturing computer. So I'm using Windows 7 to collect<br>
>> blood work data from Quest.<br>
>><br>
>> The scripts that were on the XP machine seem to work pretty well on the<br>
>> 7 box too, so I am able to get the data parsed and ready for transport to<br>
>> my mysql database server, but it doesn't send.<br>
>><br>
>> I am getting a "Could not connect. No connection could be made because<br>
>> the target machine actively refused it" error.<br>
>><br>
>> Net::HL7::Connection takes a host and port but no password or anything.<br>
>> I figure I'm supposed to open a port on the db server to allow this<br>
>> incoming connection, but I'm having trouble figuring that part out. I don't<br>
>> know where to look on the centos server to see if a port is open for the<br>
>> other xp computer, what file to edit... etc.<br>
>><br>
>> Any suggestions?<br>
>><br>
>><br>
>><br>
>> Thanks,<br>
>> Dawn<br>
>><br>
>> _______________________________________________<br>
>> Baltimore-pm mailing list<br>
>> <a href="mailto:Baltimore-pm@pm.org">Baltimore-pm@pm.org</a><br>
>> <a href="http://mail.pm.org/mailman/listinfo/baltimore-pm" target="_blank">http://mail.pm.org/mailman/listinfo/baltimore-pm</a><br>
>><br>
><br>
><br>
> _______________________________________________<br>
> Baltimore-pm mailing list<br>
> <a href="mailto:Baltimore-pm@pm.org">Baltimore-pm@pm.org</a><br>
> <a href="http://mail.pm.org/mailman/listinfo/baltimore-pm" target="_blank">http://mail.pm.org/mailman/listinfo/baltimore-pm</a><br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://mail.pm.org/pipermail/baltimore-pm/attachments/20141006/3cd119b3/attachment-0001.html" target="_blank">http://mail.pm.org/pipermail/baltimore-pm/attachments/20141006/3cd119b3/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
Baltimore-pm mailing list<br>
<a href="mailto:Baltimore-pm@pm.org">Baltimore-pm@pm.org</a><br>
<a href="http://mail.pm.org/mailman/listinfo/baltimore-pm" target="_blank">http://mail.pm.org/mailman/listinfo/baltimore-pm</a><br>
<br>
------------------------------<br>
<br>
End of Baltimore-pm Digest, Vol 41, Issue 3<br>
*******************************************<br>
</blockquote></div><br></div>