Hi,

I sent the message below a few days ago ...

I have since discovered another more serious problem where date fields are
being corrupted.

Please - take this as a warning - do not execute IBperl scripts from uux
.....

I am going to re-engineer the transfer mechanism ....

thanks
bill

Bill Katelis wrote:

> Platform SCO OpenServer 5
>
> Hi,
>
> I have been looking at this for the past day and I am stumped !!!
>
> On Server A: I have a wrapper script which executes a perl script to
> connect to a db.
> When I execute this script as user uucp on the server everything works
> fine.
>
> However, when I uux a command to execute this script from another host -
> the database connection fails !!!
> No error information is printed.
>
> uucp Permissions have been checked and are ok.
>
> Now, if I was to change the following line in the perl program from:
> Path=>"$ENV{MY_DATABASE}",
> to:
> Path=>"/usr/local/bin/www.gdb",
>
> everything works fine.
>
> Please, can anybody help?
>
> thanks
> bill
>
> Script a.sh:
> --------
>
> #! /bin/sh
>
> MY_DATABASE=/usr/local/bin/www.gdb
> export MY_DATABASE
> /usr/local/bin/a.pl
>
> # end of a.sh
>
> Perl program a.pl:
> -------------
> #! /usr/local/bin/perl -w
>
> use strict;
> use IBPerl;
>
> my ($db, $tr, $st, %row);
>
> $db = new IBPerl::Connection(
> Path=>"$ENV{MY_DATABASE}",
> User=>'user',
> Password=>'password'
> );
>
> if ($db->{Handle} < 0) { die "Error in connection was: $db->{'Error'}" }
>
> # end of a.pl
>
> _______________________________________________
> Interbase mailing list
> Interbase@...
> http://mers.com/mailman/listinfo/interbase
> InterBase Search Engine - http://www.mers.com/searchsite.html