Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

Simplest way to connect from remote computer to Informix 15 server

  • 1.  Simplest way to connect from remote computer to Informix 15 server

    Posted Wed January 08, 2025 09:53 AM

    Hello!  Happy new year to all!

    What is the easiest solution to allow a remote connection to Informix 15, without having to specify a password for the (OS) current user?

    My client machine hostname is ida with domain strasbourg.4js.com

    I have tried INFORMIXDIR/etc/host.equiv with:

    ida
    ida.strasbourg.4js.com
    ida.strasbourg.4js.com[ida]

    But I get this error:

    -951  Incorrect password or user sf@ida.strasbourg.4js.com[ida] is not known on the database server.

    The client machine is a Windows 10 with Informix CSDK 4.50.FC8 installed ...

    This is for testing purpose in our local network without any sensitive data, so the solution can be non-secure.

    I know I can create internal-authenticated users with
      CREATE USER xxx WITH PASSWORD zzz
     and this is what we will use for most tests by doing
      CONNECT TO dbname USER xxx USING zzz

    But we also have several tests doing directly
      DATABASE dbname
    or
      CREATE DATABASE dbname ...
    without any user login / password

    Seb



    ------------------------------
    Sebastien FLAESCH
    ------------------------------


  • 2.  RE: Simplest way to connect from remote computer to Informix 15 server

    Posted Wed January 08, 2025 10:42 AM

    Hello Sebastien,

    I think you need to set REMOTE_SERVER_CFG to authfile.$INFORMIXSERVER and S6_USE_REMOTE_SERVER_CFG to 1 in ONCONFIG.
    Than add the hosts you are trust to $INFORMIXDIR/etc/authfile.$INFORMIXSERVER (with domainname).
    Note: The file is only read during startup...

    Cheers,
    Markus



    ------------------------------
    Markus Holzbauer
    ------------------------------

    Original Message


  • 3.  RE: Simplest way to connect from remote computer to Informix 15 server

    Posted Wed January 08, 2025 11:13 AM

    Thanks Markus!

    If figured that out yesterday, using

       REMOTE_SERVER_CFG     hosts.equiv

    with hosts.equiv under INFORMIXDIR/etc and 644 permissions.

    Seb



    ------------------------------
    Sebastien FLAESCH
    ------------------------------

    Original Message


Related Content