DBI Proxy: Constructor didn't return a handle

Hi!

I tried to connect to an Oracle database using DBI Proxy, but when I ran
the script in the client side, it gave this error:

DBI->connect(hostname=x.x.x;port=3012;dsn=DBI:Oracle:host=x.x.x;sid=xsid)
failed: Constructor didn't return a handle:  at ./search.pl line 62

The Oracle part using DBD::Oracle has been tried both locally and
remotely. I tried to run the script from the same machine (the database
server) with same error. I confirmed that dbiproxy is running. I tried
mode=single & mode=fork with no change.

I use RedHat Linux 7, perl-5.6.0-9, perl-DBI-1.14-8 (ProxyServer 0.2003),
PlRPC-0.2014, Net-Daemon-0.34, Storable-1.0.10, DBD-Oracle-1.06, Oracle
8.1.6.

Here is the line from the script:

my $db= DBI->connect("DBI:Proxy:hostname=x.x.x;port=3012;".
                     "dsn=DBI:Oracle:host=x.x.x;sid=xtir", 
                     $user, $pwd) || err_db();

Here is configuration file for dbiproxy:

{
    'facility' => 'daemon',
    'pidfile' => '/var/run/dbiproxy.pid',
    'user' => 'nobody',
    'group' => 'nobody',
    'localport' => 3012,   
    'logfile' => '/var/log/dbiproxy.log',
    'maxmessage'=> 1073741824,
    'mode' => 'single',
    'clients' =>
        [
         {
             'mask' => '^192\.168\.100\.\d+$',
             'accept' => 1,
         },
         {
             'mask' => '.*',
             'accept' => 0,
         },
         ],
}

Actually, on compilation PlRPC had a little problem: make test falled:

t/base..............ok                                                       
t/client............Use of uninitialized value in concatenation (.) at
t/lib.pl line 30.
Use of uninitialized value in concatenation (.) at t/lib.pl line 31.
Use of uninitialized value in concatenation (.) at t/lib.pl line 32.
t/client............NOK 10FAILED tests 1-10                                  
        Failed 10/10 tests, 0.00% okay
t/compress..........skipped test on this platform
t/crypt.............skipped test on this platform
t/methods...........Use of uninitialized value in concatenation (.) at
t/lib.pl line 30.
Use of uninitialized value in concatenation (.) at t/lib.pl line 31.
Use of uninitialized value in concatenation (.) at t/lib.pl line 32.
t/methods...........ok 11/11FAILED tests 1-9                                 
        Failed 9/11 tests, 18.18% okay
Failed Test  Status Wstat Total Fail  Failed  List of failed
-------------------------------------------------------------------------------
t/client.t                   10   10 100.00%  1-10
t/methods.t                  11    9  81.82%  1-9
2 tests skipped.
Failed 2/5 test scripts, 60.00% okay. 19/24 subtests failed, 20.83% okay.

But somebody said to go on, so I installed it anyway.

-- 
                                   S P Arif Sahari Wibowo
  _____  _____  _____  _____ 
 /____  /____/ /____/ /____          arifsaha@yahoo.com
_____/ /      /    / _____/       http://www.arifsaha.com/

• DBI Proxy: Constructor didn't return a handle by S P Arif Sahari Wibowo
• Re: DBI Proxy: Constructor didn't return a handle by Thomas A . Lowery