Simplest way to connect from remote computer to Informix 15 server
Answered: green (solid confidence) — Markus gave the REMOTE_SERVER_CFG / S6_USE_REMOTE_SERVER_CFG approach with an authfile; the asker confirmed he got it working with REMOTE_SERVER_CFG pointing at hosts.equiv.
Advisory only.
Posted in 2025
Topics: Installation, Setup & Upgrades, Security, Permissions & Auditing
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
------------------------------
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 ------------------------------
Thanks Markus!
If figured that out yesterday, using
REMOTE_SERVER_CFG hosts.equivwith hosts.equiv under INFORMIXDIR/etc and 644 permissions.
Seb
------------------------------
Sebastien FLAESCH
------------------------------