Is it possible for the security auditing to log the user IP or
terminal? I guess it could be since he uses a socket to connect to the
dbms server?

The SXF audit record structure is declared in src/back/hdr/hdr/sxf.h
(SXF_AUDIT_REC).
I don't see any field names that suggest the tty or IP of the end user
is recorded.


--
hanal04

On Nov 11, 6:59*pm, Ingres Forums <info-
ing... (AT) kettleriverconsulting (DOT) com> wrote:
thanks a lot for looking it up.Good to know , so I will have to rely
on other tricks to get the IP.
I have two scenarios :
1.a Windows fat client Openroad application
2.Unix/Linux terminals who connect to a ABF application

Since Openroad interops with COM+, I was thinking of writting a COM+
server object which would essentially be a wrapper on winsock
functions.So the client would interogate the object first, get the IP
and then log it into a table with a custom made query.I've seen
somewhere that Openroad supports automation,right?? if that is so I
could write the server in a language that supports automation like
Perl which will make my life easier than playing with the com C++
interfaces.

As far as the latter goes,I haven't looked into it yet but I guess
that I will have to parse the utmp Unix struct

Do you have any suggestions on it?

nikosv wrote:

Without knowing why you want the IP address I'm unsure if this idea is
helpful or not.

Instead of building a big wobbly pile of diverse software layers using
different languages, APIs and operating system services, you can get
the name (if not the IP address) of the host machine your client is
running on very easily using just SQL. Look at the client_host
attribute in the ima_server_sessions table in imadb. (You can always
register the ima_server_sessions table in your production database if
that makes it easier to query with the application.)

--
Roy

UK Ingres User Association Conference 2011 will be on Tuesday June 7 2011.
Put the date in your diary today.

Roy,great advice (as always I must add!)
I will look into it.thanks