Jabber Interface Sucess - Mailing list pgsql-general

 Dear Bruce and others ,

 Thanks For the responce and your kind help
 I have a little problem i hope you would be intrested in troubleshooting it

 I am using plperl  and
 NET::Jabber  for the postgresql  connection to jabber and walah!! it realy
 connects and sends messages to all the targets users.

 I have created a function
 pgjabber(text,text) as following
 <code>
 CREATE FUNCTION "public"."pgjabber" (text, text) RETURNS text AS'
 #This module helps to deliver message to the jabber user
 #usage pgjabber(touser@server,message);
 use Net::Jabber qw(Client);
 $toid = $_[0]; # the target uset
$body = $_[1]; # the message for that ass
 my $jabconn = Net::Jabber::Client->new();
 $jabconn->Connect( "hostname" => "someserver.who","port" => 5222 ) or die
"Cannot connect ($!)\\n";
 my @result = $jabconn->AuthSend( "username" =>
 ''sender@some.who'',"password" => "why_to_tell '',"resource" => ''work'' );
 my $msg = Net::Jabber::Message->new();
 $msg->SetMessage( "to"=> $toid,"subject" => "Money Deduction","body"=>
 $body );
 $jabconn->Send($msg);
 $jabconn->Disconnect();
 return sucess;
 'LANGUAGE 'plperl' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;
 </code>
 Yes the  the langauge was duly created  and instaled perl is 5.6.1 on RH
7.2
 i386 ,gcc 3.x, Postgresql 7.3.4

 Now My problem is that if i use this function pgjabber(text,text) for
 sending 1 message at a time then it works
 if I use this function in a loop of      plpgsql function   it does not
 executes more than 4  times also
 if i do "Select pgjabber(someplace@server,message); " 10 number of times as
 a consecutive query it only executes and delivers message for 4 time and at
 5 instance it returns the error
 <error>

 plperl: error from function:    (in cleanup) Cannot connect ()

 </error>




Would be greatful to any soul who comes to help :-)))



 Regards to All readers,
 Aspire .


>
>
>
>
>
>
> ----- Original Message -----
> From: "Bruce Momjian" <pgman@candle.pha.pa.us>
> To: "Aspire" <aspire@mail15.com>
> Cc: <pgsql-general@postgresql.org>
> Sent: Saturday, July 26, 2003 02:44
> Subject: Re: [GENERAL] Jabber Interface
>
>
> >
> > You can use one of the server-side languages, like plperl, or use plsh,
> > which I think is on gborg.  Either can call a shell script.
> >
>
> --------------------------------------------------------------------------
> -
> >
> > Aspire wrote:
> > > Dear all ,
> > >
> > > This could have been a wish list but ..
> > >
> > >
> > > Do any one have any idea how could one send messages to jabber server
> via
> > > postgresql i.e a trigr function that if invoked sends a message to
> specific
> > > user.
> > >
> > >
> > > Please all information provided would be apreciated
> > >
> > >
> > > Regards,
> > > V Kashyap
> > >
> > >
> > > ---------------------------(end of
broadcast)---------------------------
> > > TIP 3: if posting/reading through Usenet, please send an appropriate
> > >       subscribe-nomail command to majordomo@postgresql.org so that
your
> > >       message can get through to the mailing list cleanly
> > >
> >
> > --
> >   Bruce Momjian                        |  http://candle.pha.pa.us
> >   pgman@candle.pha.pa.us               |  (610) 359-1001
> >   +  If your life is a hard drive,     |  13 Roberts Road
> >   +  Christ can be your backup.        |  Newtown Square, Pennsylvania
> 19073
> >
>