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
  • 1.  REMOTE_SERVER_CFG issue/question

    Posted 2 hours ago

    All,

     

    I tried posting this via the web, but every time I click on the "Post" link, I get a pop-up stating:

    Access Denied

    You don't have permission to access "http://community.ibm.com/higherlogic/ui/mvc/contributedcontent/contributedcontent/createQuestion" on this server.

    Reference #18.9e0c0317.1766436968.5bb9eaa4

    https://errors.edgesuite.net/18.9e0c0317.1766436968.5bb9eaa4

     

    Yes, I've logged in at TechXchange.  Maybe I'm cursed right now and that's the reason I'm having the issue described below.  I just wanted to state up front that since this is being posted via email, some of the formatting below may get lost.  I'm hoping it is readable whatever the format.

     

    Anyway, the problem I'm having involves IDS 14.10.FC11W1 on RHEL 8.10.  One server (appserver1) is our application server, connecting to our test database server (dbsrv1).  Trying to connect to the database via dbaccess gives a -956 "Client or user is not trusted by server".  The user has entries in /etc/passwd on both appserver1 and dbsrv1, and the instance is configured to use the REMOTE_SERVER_CFG file to allow authentication based on client servername.  

     

    The value of REMOTE_SERVER_CFG for this instance:

     

    [informix]$ onstat -c REMOTE_SERVER_CFG

    test_remote_servers

     

    The contents of $INFORMIXDIR/etc/test_remote_servers:

     

    lgcyserver1.companyname.corp

    lgcy_server1

    webapp1.companyname.corp

    webapp1

    dbsrv2.companyname.corp

    dbsrv2

    dbsrv3.companyname.corp

    dbsrv3

    appserver1.companyname.corp

    appserver1

     

    I suspect that I don't technically need both the long and short versions of each server's name, but that's not the key point here.  In online.log, the error is logged as:

     

    2025-12-22 10:07:19.133  listener-thread: err = -956: oserr = 0: errstr = userabc1@10.15.20.30[appserver1.companyname.corp]: Client host or user userabc1@10.15.20.30[appserver1.companyname.corp] is not trusted by the server.

     

    To get around this, I added the IP address for the server to the test_remote_servers file.  Once that was done, user userabc1 was able to connect to the database with no issues.

     

    But unless I'm mistaken, I shouldn't have to do this workaround.  The hostname should be the correct value to put in REMOTE_SERVER_CFG.  And based on the error message, the instance is able to resolve the IP address to the servername.  So why is this not working in this case?  What do I need to check?

     

    And if anyone has any suggestions on how to clear up the "ACCESS DENIED" error I'm getting on the TechXchange website, please pass that along as well.

     

    Thanks.

     

     

    Mark



  • 2.  RE: REMOTE_SERVER_CFG issue/question

    Posted an hour ago
    re: your REMOTE_CFG issue I always add the hostname, fqdn and ip for reasons lost in the mist of time.

    looks like your onstat -m

    10.15.20.30[appserver1.companyname.corp]

    is telling you it needs the IP and FQDN.  Maybe resolv.conf/DNS thing


    Cheers
    Paul




    On 12/22/2025 3:01 PM, mark collins via IBM TechXchange Community wrote:
    0100019b47ddc415-43660b5a-de71-4f4f-8987-d441f0199168-000000@email.amazonses.com">
    All, I tried posting this via the web, but every time I click on the "Post" link, I get a pop-up stating: Access Denied You don't have...





  • 3.  RE: REMOTE_SERVER_CFG issue/question

    Posted an hour ago

    Hi Paul,

     

    Thanks.  I do have both the short name and the FQDN for the host.  I just was hoping not to have to include the IP address.  Otherwise, what's the point of DNS in the first place?  And the fact that the onstat -m output includes both the IP address and the FQDN makes me believe that the address-to-hostname resolution process was successful.

     

     

     

    Mark

     






  • 4.  RE: REMOTE_SERVER_CFG issue/question

    Posted an hour ago
    My guess as to 'why' is the resolv.conf file

    On 12/22/2025 3:53 PM, mark collins via IBM TechXchange Community wrote:
    0100019b480d8f5c-04059240-ba50-4c63-8f01-a9583e2914a2-000000@email.amazonses.com">
    Hi Paul, Thanks. I do have both the short name and the FQDN for the host. I just was hoping not to have to include the IP address. ... -posted to the "Informix" group





  • 5.  RE: REMOTE_SERVER_CFG issue/question

    Posted 49 minutes ago

    Hi Paul,

     

    The contents of /etc/resolv.conf are:

     

    # Generated by NetworkManager

    search companyname.corp

    nameserver 10.0.5.3

    nameserver 10.0.5.6

     

     

    The two IP addresses point to our AD servers:

     

    [informix]$ nslookup 10.0.5.3

    3.5.0.10.in-addr.arpa   name = dnsAD01.companyname.corp.

    [informix]$ nslookup 10.0.5.6

    6.5.0.10.in-addr.arpa   name = dnsAD02.companyname.corp.

     

     

    Running nslookup from my PC confirms that at least the 10.0.5.6 address is being used for DNS:

     

    C:\Users\mark >nslookup appserver1.companyname.corp

    Server:  dnsAD02.companyname.corp

    Address:  10.0.5.6

     

    Name:    nslookup appserver1.companyname.corp

    Address:  10.15.20.30

     

     

    That's about the limit of my access for checking DNS and resolv.conf.  I can check with the sysadm tomorrow to see if he can get any further with it.

     

     

     

    Mark