Connect to Informix remote DB

[James Xie]

I have two Linux (Redhat 6.0) boxes both have Apache 1.3.12 and mod_perl
1.23 installed, one of them (let's call  it A box) also has Informix 7.3
installed.  I installed DBI module and Informix DBD (1.0) on both machines,
On B box, "make test"  for informix DBD went through ok against the database
on A box. 

The following DBI script went through ok on A Box, but it failed on B box. 

        ....            
        my $host = $r->get_remote_host;
        my $dbh = DBI->connect("DBI:Informix:esorn");
        my $sth = $dbh->prepare("SELECT * FROM user" ); 
        .....

Here is what I got from the error_log on B box: 
        DBI->connect failed: SQL: -951: Incorrect password or user webuser
is not known on the database server. at /usr/local/esorn/lib
        /perl/Apache/TestDBI.pm line 12        
        
        webuser is the account I run Apache process. 


When I change the script as following:
        ....            
        my $host = $r->get_remote_host;
        my $dbh = DBI->connect("DBI:Informix:esorn","informix","informix");
        my $sth = $dbh->prepare("SELECT * FROM user" ); 
        .....

Here is what I got from the error_log on B box: 
        DBI->connect failed: SQL: -952: User's password is not correct for
the database server.

        The user "informix" with password "informix" do exist on A box. 


How do I fix this problem ?

Thanks

James