ONLINE.LOG verbosity and logging successful authen
Jonathan Smaby asked whether the ONCONFIG could make ONLINE.LOG record successful authentications, not just failures like -951. Art Kagel said no, but a sysdbopen() SPL function owned by public could log each connection to a table or via SYSTEM. Fernando suggested enabling auditing with the _default mask set to STSN (start session). Jonathan thanked both.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Informix community, Is there is setting in the ONCONFIG file to change verbosity of the ONLINE-LOG? Specifically I'm looking to log successfully authentication with Informix, not just failed authentication attempts like -951 errors. Thank-you in advance for any insight. V/r, Jonathan B. Smaby Pomona College (909) 621-8506 -- "If people stop bringing you problems, you've stopped leading." - LTG Jeffrey W. Talley, US Army Reserve
Can't do it that way, no. However, you can create a sysdbopen() SPL function owned by "public" in each database and it will execute for each successful connection to that database. In there you can log the user's connection into a table with SQL or by using the SYSTEM command to execute an external program (like SYSTEM "echo "||user||current year to second||" >>some.logfile". Similarly you can use a sysdbclose() function to log the users' log out event. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Aug 25, 2014 at 4:32 PM, Jonathan Smaby <Jonathan.Smaby@pomona.edu> wrote: > Informix community, > > Is there is setting in the ONCONFIG file to change verbosity of the > ONLINE-LOG? Specifically I'm looking to log successfully authentication > with > Informix, not just failed authentication attempts like -951 errors. > > Thank-you in advance for any insight. > > V/r, > > Jonathan B. Smaby > Pomona College > (909) 621-8506 > -- > "If people stop bringing you problems, you've stopped leading." - LTG > Jeffrey > W. Talley, US Army Reserve > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0158b6e888b9ac05017a2f56
Probably the easiest way it to activate auditing and create the default mask (_default) with STSN (start session). The audit logs will contain all the sessions created (who, when, from where...) Regards On Mon, Aug 25, 2014 at 10:32 PM, Jonathan Smaby <Jonathan.Smaby@pomona.edu> wrote: > Informix community, > > Is there is setting in the ONCONFIG file to change verbosity of the > ONLINE-LOG? Specifically I'm looking to log successfully authentication > with > Informix, not just failed authentication attempts like -951 errors. > > Thank-you in advance for any insight. > > V/r, > > Jonathan B. Smaby > Pomona College > (909) 621-8506 > -- > "If people stop bringing you problems, you've stopped leading." - LTG > Jeffrey > W. Talley, US Army Reserve > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --047d7b10ce91132eea05017a76d4
Thank-you Art and Fernando for the tips. V/r Jonathan B. Smaby Pomona College (909) 621-8506 -- "If people stop bringing you problems, you've stopped leading." - LTG Jeffrey W. Talley, US Army Reserve -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Fernando Nunes Sent: Monday, August 25, 2014 1:59 PM To: ids@iiug.org Subject: Re: ONLINE.LOG verbosity and logging successfu.... [33594] Probably the easiest way it to activate auditing and create the default mask (_default) with STSN (start session). The audit logs will contain all the sessions created (who, when, from where...) Regards On Mon, Aug 25, 2014 at 10:32 PM, Jonathan Smaby <Jonathan.Smaby@pomona.edu> wrote: > Informix community, > > Is there is setting in the ONCONFIG file to change verbosity of the > ONLINE-LOG? Specifically I'm looking to log successfully > authentication with Informix, not just failed authentication attempts > like -951 errors. > > Thank-you in advance for any insight. > > V/r, > > Jonathan B. Smaby > Pomona College > (909) 621-8506 > -- > "If people stop bringing you problems, you've stopped leading." - LTG > Jeffrey W. Talley, US Army Reserve > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --047d7b10ce91132eea05017a76d4 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.