Able to start ANI DB with HOST=server_name, instead of LOCALHOST?

sirbaughmf · ‎03-06-2008

I am trying get information from three different ANI databases using a Perl script that uses the perl module. In the perl file I am specifying which database to go to with connect($dsn,"UID=xxxx;PWD=xxxx;LINKS=tcpip(host=server_name;port=43443). This is failing because the database start up with LOCALHOST as the host, /opt/CSCOpx/objects/db/bin/dbsrv9 -x tcpip{HOST=localhost;DOBROADCAST=NO;Server. Is there a way to start the DB with servername instead of localhost?

yjdabear · ‎03-06-2008

Just a thought: In case it's not possible to have dbsrv9 start with host=HOSTNAME, maybe the script can use a CPAN module such as Net::Telnet or Net-SSH-Perl that can let it telnet/ssh into each server and query each LOCALHOST that way.

Joe Clarke · ‎03-06-2008

Direct database access is not supported, and using localhost just adds one more layer of security. Depending on the data you want, there may be a supported way (i.e. using DEE) to get to it.