[26656] in Perl-Users-Digest
Perl-Users Digest, Issue: 8763 Volume: 10
daemon@ATHENA.MIT.EDU (Perl-Users Digest)
Wed Dec 14 18:05:17 2005
Date: Wed, 14 Dec 2005 15:05:04 -0800 (PST)
From: Perl-Users Digest <Perl-Users-Request@ruby.OCE.ORST.EDU>
To: Perl-Users@ruby.OCE.ORST.EDU (Perl-Users Digest)
Perl-Users Digest Wed, 14 Dec 2005 Volume: 10 Number: 8763
Today's topics:
Re: Problem with Perl DBI - IO::Socket::INET: <pr0fess0r _at_ mac.com>
Writing SMPP client <samwun@telpacific.com.au>
Digest Administrivia (Last modified: 6 Apr 01) (Perl-Users-Digest Admin)
----------------------------------------------------------------------
Date: Thu, 15 Dec 2005 08:59:05 +1300
From: Lucas Young <pr0fess0r _at_ mac.com>
Subject: Re: Problem with Perl DBI - IO::Socket::INET:
Message-Id: <43a07ae5@news.orcon.net.nz>
On 2005-12-12 00:09:42 +1300, Mark Clements
<mark.clementsREMOVETHIS@wanadoo.fr> said:
> John Bokma wrote:
>> Lucas Young <lucas _a_t_ digitalus _dot_ co _dot_ nz> wrote:
>>
>>> Hi all
>>>
>>> I'm trying to setup a connection to a Hypersonic SQL database on
>>> Ubuntu Linux. I've installed HSQLDB-BER from
>>> http://sourceforge.net/projects/hsqldb-ber/ and the server seems to
>>> start OK, but I get this error running the sample.pl script:
>>>
>>> DBI connect('hostname=localhost:9111;url=ber:hsqldb:play','sa',...)
>>> failed: Failed to open socket to server: IO::Socket::INET: connect:
>>> Connection refused at sample.pl line 27
>>> Failed to connect: (104) Failed to open socket to server:
>>> IO::Socket::INET: connect: Connection refused
>>>
>>> The line of code is:
>>>
>>> $dsn = "dbi:JDBC:hostname=localhost:9111;url=ber:hsqldb:play";
>>
>> I doubt if that's line 27, unless $dsn has some magic.
>>
>
> Vim tells me it's line 24 :)
>
> $dsn = "dbi:JDBC:hostname=localhost:9111;url=ber:hsqldb:play";
> my %null;
>
> $dbh = DBI->connect($dsn, "sa", "", \%null)
> or ( die("Failed to connect: ($DBI::err) $DBI::errstr\n"));
>
> Lucas: you need to verify that the server is running, and that it is
> listening on the port on which you think it is running. If it produces
> error logs, what is in them? Have you verified that there is a process
> listening on the port to which the sample script is trying to connect
> ie does
>
> telnet localhost 9111
>
> connect or do you get connection refused? lsof is also good for
> diagnosing (among other things) what process is listening on which
> port. What does
>
> lsof -i :9111
>
> return?
>
>
> What is in the error logs for the server?
>
> Mark
Hi Guys
Silly me, I didnt have a server running :) Now the sample is working fine.
What I'd like to be aable to do is connect to the Hypersonic SQL
database that comes with Readerware (Readerware lets you scan
book/dvd/cd barcodes, it looks them up on Amazon etc and stores them in
a database). The developer has provided the database info:
Readerware uses Hypersonic SQL.
The JDBC driver is distributed with Readerware in lib\hsql.jar
Login Name: sa
Password:
(Leave the password field blank)
URL: jdbc:HypersonicSQL:C:\Readerware\RWareDB.rwd
Driver: org.hsql.jdbcDriver
Driver Location: C:\Readerware\lib\hsql.jar
How could I configure the sample to connect to this database? I'd be a
very happy camper after that :)
Thanks for all the help
Lucas
------------------------------
Date: Thu, 15 Dec 2005 08:32:32 +1100
From: sam <samwun@telpacific.com.au>
Subject: Writing SMPP client
Message-Id: <43a08f70$1@news.rivernet.com.au>
Hi,
I want to use Net::SMPP implement a client send PDU to a server. The
server is written with normal socket APIs, that is listen, bind, accept.
So in the server side, I need to somehow decode the PDU message sent by
the smpp client. How can the general purpose server decode the PDU
message sent by the SMPP client?
Thanks
Sam
------------------------------
Date: 6 Apr 2001 21:33:47 GMT (Last modified)
From: Perl-Users-Request@ruby.oce.orst.edu (Perl-Users-Digest Admin)
Subject: Digest Administrivia (Last modified: 6 Apr 01)
Message-Id: <null>
Administrivia:
#The Perl-Users Digest is a retransmission of the USENET newsgroup
#comp.lang.perl.misc. For subscription or unsubscription requests, send
#the single line:
#
# subscribe perl-users
#or:
# unsubscribe perl-users
#
#to almanac@ruby.oce.orst.edu.
NOTE: due to the current flood of worm email banging on ruby, the smtp
server on ruby has been shut off until further notice.
To submit articles to comp.lang.perl.announce, send your article to
clpa@perl.com.
#To request back copies (available for a week or so), send your request
#to almanac@ruby.oce.orst.edu with the command "send perl-users x.y",
#where x is the volume number and y is the issue number.
#For other requests pertaining to the digest, send mail to
#perl-users-request@ruby.oce.orst.edu. Do not waste your time or mine
#sending perl questions to the -request address, I don't have time to
#answer them even if I did know the answer.
------------------------------
End of Perl-Users Digest V10 Issue 8763
***************************************
