More about errors -951 / -952
User asked if errors -951/-952 (authentication failures from ODBC clients) can be suppressed from Informix 11.70 logs on HP-UX. Multiple respondents confirmed there is no direct way to exclude these messages. Suggestions included using named pipes for MSGLOG, enabling traces with onmode -I to debug the application, or using alarmprogram/grep to filter logs. No resolution to suppress the errors was provided.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, HP-UX 11.31 Informix 11.70 FC8W1 I have a legacy windows application (it is not possible to modify code). This app uses ODBC and when the PC user is trying to connect to the unix server with a incorrect combination of user / password, then one of following lines are written to the log file <instance>.log: listener-thread: err = -952: oserr = 0: errstr = <user@domain>: User <user@domain>'s password is not correct for the database server. listener-thread: err = -951: oserr = 0: errstr = <user@domain>: Incorrect password or user <user@domain> is not known on the database server. These errors are repeated several times a day and are not relevant, but they're annoying. My question is: Is there any way of do an "acknowledgement of these errors" and no longer show up ? Is there a way of avoid these messages in the log ? Exclude these error codes ? Thanks in advance.
Not that I am aware of but you might be able to make the MSGLOG a named pipe and do something clever -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ROGER VILCA Sent: Monday, July 25, 2016 4:30 PM To: ids@iiug.org Subject: More about errors -951 / -952 [37481] Hi, HP-UX 11.31 Informix 11.70 FC8W1 I have a legacy windows application (it is not possible to modify code). This app uses ODBC and when the PC user is trying to connect to the unix server with a incorrect combination of user / password, then one of following lines are written to the log file <instance>.log: listener-thread: err = -952: oserr = 0: errstr = <user@domain>: User <user@domain>'s password is not correct for the database server. listener-thread: err = -951: oserr = 0: errstr = <user@domain>: Incorrect password or user <user@domain> is not known on the database server. These errors are repeated several times a day and are not relevant, but they're annoying. My question is: Is there any way of do an "acknowledgement of these errors" and no longer show up ? Is there a way of avoid these messages in the log ? Exclude these error codes ? Thanks in advance. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.
No, these kind of errors are directly related to database securiry.
You can turn on a trace through onmode -I [errnum] to help you to find where
the application is going wrong, and correct it.
Hope it helps.
Best regards.
Em 25/07/2016 6:38 PM, Paul Watson <paul@oninit.com> escreveu:
Not that I am aware of but you might be able to make the MSGLOG a named
pipe and do something clever
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ROGER
VILCA
Sent: Monday, July 25, 2016 4:30 PM
To: ids@iiug.org
Subject: More about errors -951 / -952 [37481]
Hi,
HP-UX 11.31
Informix 11.70 FC8W1
I have a legacy windows application (it is not possible to modify code).
This
app uses ODBC and when the PC user is trying to connect to the unix server
with a incorrect combination of user / password, then one of following lines
are written to the log file <instance>.log:
listener-thread: err = -952: oserr = 0: errstr = <user@domain>: User
<user@domain>'s password is not correct for the database server.
listener-thread: err = -951: oserr = 0: errstr = <user@domain>: Incorrect
password or user <user@domain> is not known on the database server.
These errors are repeated several times a day and are not relevant, but
they're annoying.
My question is:
Is there any way of do an "acknowledgement of these errors" and no longer
show
up ?
Is there a way of avoid these messages in the log ? Exclude these error
codes
?
Thanks in advance.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
No... But your concern with them suggest either/both: 1- They are very frequent 2- You spend too much time looking at online.log For 2) you should setup the alarmprogram to process the relevant events and send you emaisl or SMS or some other alert tool... and you can "grep" them out of course... Regards. On Mon, Jul 25, 2016 at 10:29 PM, ROGER VILCA <rvilca@luzdelsur.com.pe> wrote: > Hi, > > HP-UX 11.31 > Informix 11.70 FC8W1 > > I have a legacy windows application (it is not possible to modify code). > This > app uses ODBC and when the PC user is trying to connect to the unix server > with a incorrect combination of user / password, then one of following > lines > are written to the log file <instance>.log: > > listener-thread: err = -952: oserr = 0: errstr = <user@domain>: User > <user@domain>'s password is not correct for the database server. > > listener-thread: err = -951: oserr = 0: errstr = <user@domain>: Incorrect > password or user <user@domain> is not known on the database server. > > These errors are repeated several times a day and are not relevant, but > they're annoying. > > My question is: > > Is there any way of do an "acknowledgement of these errors" and no longer > show > up ? > > Is there a way of avoid these messages in the log ? Exclude these error > codes > ? > > Thanks in advance. > > > > ******************************************************************************* > 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... --001a113f8aaeb8897405387d2473
Simple answer? No. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com 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, Jul 25, 2016 at 5:29 PM, ROGER VILCA <rvilca@luzdelsur.com.pe> wrote: > Hi, > > HP-UX 11.31 > Informix 11.70 FC8W1 > > I have a legacy windows application (it is not possible to modify code). > This > app uses ODBC and when the PC user is trying to connect to the unix server > with a incorrect combination of user / password, then one of following > lines > are written to the log file <instance>.log: > > listener-thread: err = -952: oserr = 0: errstr = <user@domain>: User > <user@domain>'s password is not correct for the database server. > > listener-thread: err = -951: oserr = 0: errstr = <user@domain>: Incorrect > password or user <user@domain> is not known on the database server. > > These errors are repeated several times a day and are not relevant, but > they're annoying. > > My question is: > > Is there any way of do an "acknowledgement of these errors" and no longer > show > up ? > > Is there a way of avoid these messages in the log ? Exclude these error > codes > ? > > Thanks in advance. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --94eb2c05f97e17a01305387d8417
You should want to see and review these, in case of access violations. Oth= erwise ignore them, since they are in the online.log, which hopefully you a= re not reviewing much anyway. If you are, then just look in there for what is relevant to you and ignore = the rest. You need to find the issue and resolve it, if necessary. If it's password,= then fix it. If it's trust, then fix that. Get the ID removed from the remote server that it's coming from, etc. Thanks, ***************************************************************************= *************** Ernie Knox Sr. Technologist, Member Technology - Database Management Sears Holdings Management Corp 3333 Beverly Rd. Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Cell: (847) 665-0722 Corp. Cell: 224-465-0553=A0 Corp. Text: 2244650553@txt.att.net Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com Informix Primary: INFORMIXDBAPrimaryPager@searshc.com Informix Secondary: INFORMIXDBASecondaryPager@searshc.com MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com MySQL Primary: MYSQLDBAPrimaryPager@searshc.com MySQL Secondary: MYSQLDBASecondaryPager@searshc.com For more information, view our DBA Wiki page link below: http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= t#DatabaseManagement For creating ServiceNow request, use the link below: https://sears.service-now.com Have I provided a WOW member experience today? Send a Members' First Recognition to this Associate Nominate this Associate for a Technology Excellence Award My Area: " Yes we can make a Change! " " IF you can think it, you can do it! " " Sometimes to secure the future, you have to let go of the past! " " IT'S always a great day to watch=A0Sports: FOOTBALL " GSU MISSION: " The focus of my life begins at home with family, loved ones, and friends.= =A0 I want to use my resources to create a secure environment that fosters love, learning, laughter, and mutual succes= s.=A0 I will protect and value integrity.=A0 I will admit and quickly correct my mistakes.=A0 I will be a self-starter.=A0= I will be a caring person.=A0 I will be a good listener with an open mind.=A0 I will continue to grow and learn.=A0 I will facilita= te and celebrate the success of others. " ***************************************************************************= *************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art K= agel Sent: Monday, July 25, 2016 5:44 PM To: ids@iiug.org Subject: Re: More about errors -951 / -952 [37485] Simple answer? No.=20 Art=20 Art S. Kagel, President and Principal Consultant ASK Database Management ww= w.askdbmgt.com=20 Blog: http://informix-myview.blogspot.com/=20 Disclaimer: Please keep in mind that my own opinions are my own opinions an= d do not reflect on the IIUG, nor any other organization with which I am as= sociated either explicitly, implicitly, or by inference. Neither do those o= pinions reflect those of other individuals affiliated with any entity with = which I am affiliated nor those of the entities themselves.=20 On Mon, Jul 25, 2016 at 5:29 PM, ROGER VILCA <rvilca@luzdelsur.com.pe> wrote:=20 > Hi, >=20 > HP-UX 11.31 > Informix 11.70 FC8W1 >=20 > I have a legacy windows application (it is not possible to modify code).= =20 > This > app uses ODBC and when the PC user is trying to connect to the unix=20 > server with a incorrect combination of user / password, then one of=20 > following lines are written to the log file <instance>.log: >=20 > listener-thread: err =3D -952: oserr =3D 0: errstr =3D <user@domain>: Use= r=20 > <user@domain>'s password is not correct for the database server. >=20 > listener-thread: err =3D -951: oserr =3D 0: errstr =3D <user@domain>:=20 > Incorrect password or user <user@domain> is not known on the database ser= ver. >=20 > These errors are repeated several times a day and are not relevant,=20 > but they're annoying. >=20 > My question is:=20 >=20 > Is there any way of do an "acknowledgement of these errors" and no=20 > longer show up ? >=20 > Is there a way of avoid these messages in the log ? Exclude these=20 > error codes ? >=20 > Thanks in advance.=20 >=20 >=20 >=20 >=20 ***************************************************************************= ****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 --94eb2c05f97e17a01305387d8417=20 ***************************************************************************= **** Forum Note: Use "Reply" to post a response in the discussion forum.=20 This message, including any attachments, is the property of Sears Holdings = Corporation and/or one of its subsidiaries. It is confidential and may cont= ain proprietary or legally privileged information. If you are not the inten= ded recipient, please delete it without reading the contents. Thank you.