Discussion:
Blocking informix net connections from a SQL Server (using 2.9SDK Connect) when AIX is inhibited
(too old to reply)
b***@gmail.com
2017-03-10 22:26:36 UTC
Permalink
Raw Message
Hi all,

Struggling with this one. Apologies if this is already documented. The search returned nothing.

I made a nasty discovery a few weeks ago where a web server using SQL queries that use Informix net to connect to my AIX box was able to run those queries even though it was inhibited. I cannot find any info on what I could do to the sqlexecd process (is killing it the method perhaps?) to break connections and not allow any new ones. My inhibit and uninhibit scripts are under my control.

Any help would be appreciated.

I'm running Informix SE 7 (yes that old) on AIX 5.3.

Thanks,
Brian.
Spokey Wheeler
2017-03-10 22:47:30 UTC
Permalink
Raw Message
Right, you need sqlexecd only for remote access. If your normal application access (presumably 4GL) is on the same box, you don’t need sqlexecd. If you DO need it for 4GL, you’re pretty much… sexually intercoursed.

You might be able to do something with hosts.deny, I don’t know.
Post by b***@gmail.com
Hi all,
Struggling with this one. Apologies if this is already documented. The search returned nothing.
I made a nasty discovery a few weeks ago where a web server using SQL queries that use Informix net to connect to my AIX box was able to run those queries even though it was inhibited. I cannot find any info on what I could do to the sqlexecd process (is killing it the method perhaps?) to break connections and not allow any new ones. My inhibit and uninhibit scripts are under my control.
Any help would be appreciated.
I'm running Informix SE 7 (yes that old) on AIX 5.3.
Thanks,
Brian.
_______________________________________________
Informix-list mailing list
http://members.iiug.org/mailman/listinfo/informix-list
Clive Eisen
2017-03-11 18:17:31 UTC
Permalink
Raw Message
Post by b***@gmail.com
Hi all,
Struggling with this one. Apologies if this is already documented. The search returned nothing.
I made a nasty discovery a few weeks ago where a web server using SQL queries that use Informix net to connect to my AIX box was able to run those queries even though it was inhibited. I cannot find any info on what I could do to the sqlexecd process (is killing it the method perhaps?) to break connections and not allow any new ones. My inhibit and uninhibit scripts are under my control.
What do you mean by inhibit?

Do you mean you have written a script that you THOUGHT would block connections, but doesn’t?

I suppose you could use AIX filters to block the incoming TCP connections.

—
Clive

Loading...