951: Incorrect password error after Big Fix.
Posted in 2011
Topics: High Availability & Replication, Stored Procedures & SPL, Server Administration, Security, Permissions & Auditing
IDS: 10.00.UC6
OS: SunOS 5.8
=20
I'm getting a -951 error on only one application database, in one of
three instances. This was after a Big Fix was performed on the OS
password file. I can get to the catalog databases, but not the
application database. I can't even get to the tables logged on as
informix. This is the primary of an HDR pair and the secondary gives me
the same error on the same database for informix.
=20
Do I need to bounce the server? I bounce the primary and secondary
instances multiple times.=20
=20
INFO - dbaparts.prtdtpr_prt_rsh: ... References Status cOnstraints
...
Display status information for a table.=20
=20
----------------------- pdcc_rpt@ifmx00172 ----- Press CTRL-W for Help
--------
=20
951: Incorrect password or user informix@scihodb1.credit.sears.com isnot known to database server
=20
Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings - BU: I & T Group
3333 Beverly Rd.
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Email: Ernest.Knox@searshc.com <mailto:Ernest.Knox@searshc.com>=20
Blackberry: 2244650553@messaging.sprintpcs.com
<mailto:2244650553@messaging.sprintpcs.com>=20
Informix Email: ifmxdba@searshc.com <mailto:ifmxdba@searshc.com> and
Team: InformixDBA@searshc.com <mailto:InformixDBA@searshc.com>=20
Informix Primary: INFORMIXDBAPrimaryPager@searshc.com
<mailto:INFORMIXDBAPrimaryPager@searshc.com>=20
Informix Secondary: INFORMIXDBASecondaryPager@searshc.com
<mailto:INFORMIXDBASecondaryPager@searshc.com>=20
MySQL Email: MySQLDBA2@searshc.com <mailto:MySQLDBA2@searshc.com>=20
MySQL Primary: MYSQLDBAPrimaryPager@searshc.com
<mailto:MYSQLDBAPrimaryPager@searshc.com>=20
MySQL Secondary: MYSQLDBASecondaryPager@searshc.com
<mailto:MYSQLDBASecondaryPager@searshc.com>=20
=20
" Yes we can make a Change! "
" It's always a great day to watch Sports: "
" Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! "
" Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! "
GSU
*******************************************************************
=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.
1) check $INFORMIXDIR/bin/oninit permission, it should be like
-rwsr-sr-x 2 root informix 155243027 Jun 27 14:52 oninit
2) can you log in the machine with user 'informix'?
We had the Big Fix reverted back to the original password file on 107 serve=
rs. That fixed the issue with the userid logins. It also affected the inf=
ormix ID against the database.
We are good now. Watch out for Big Fixes against the /etc/passwd file.
Thanks,
*******************************************************************
Ernie Knox
IT Database=A0Administrator Specialist
Sears Holdings - BU: I & T Group
3333 Beverly Rd.
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Email: Ernest.Knox@searshc.com
Blackberry:=A02244650553@messaging.sprintpcs.com
Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com
Informix Primary: INFORMIXDBAPrimaryPager@searshc.com
Informix Secondary: INFORMIXDBASecondaryPager@searshc.com
MySQL Email: MySQLDBA2@searshc.com
MySQL Primary: MYSQLDBAPrimaryPager@searshc.com
MySQL Secondary: MYSQLDBASecondaryPager@searshc.com
" Yes we can make a Change! "
" It's always a great day to watch=A0Sports: "
" Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! "
" Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! "
GSU
*******************************************************************
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JINMI=
NG XIAO
Sent: Thursday, July 21, 2011 9:59 PM
To: ids@iiug.org
Subject: Re: 951: Incorrect password error after Big Fix. [24431]
1) check $INFORMIXDIR/bin/oninit permission, it should be like -rwsr-sr-x 2=
root informix 155243027 Jun 27 14:52 oninit=20
2) can you log in the machine with user 'informix'?=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.
Just for curiosity, what is a "big fix"?
Regards.
On Fri, Jul 22, 2011 at 3:02 AM, Knox, Ernest <Ernest.Knox@searshc.com>wrote:
> We had the Big Fix reverted back to the original password file on 107
> serve=
> rs. That fixed the issue with the userid logins. It also affected the inf=
> ormix ID against the database.
>
> We are good now. Watch out for Big Fixes against the /etc/passwd file.
>
> Thanks,
> *******************************************************************
> Ernie Knox
> IT Database=A0Administrator Specialist
> Sears Holdings - BU: I & T Group
> 3333 Beverly Rd.
> Hoffman Estates, IL. 60179
> Office: (847) 286-5735
> Email: Ernest.Knox@searshc.com
> Blackberry:=A02244650553@messaging.sprintpcs.com
> Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com
> Informix Primary: INFORMIXDBAPrimaryPager@searshc.com
> Informix Secondary: INFORMIXDBASecondaryPager@searshc.com
> MySQL Email: MySQLDBA2@searshc.com
> MySQL Primary: MYSQLDBAPrimaryPager@searshc.com
> MySQL Secondary: MYSQLDBASecondaryPager@searshc.com
>
> " Yes we can make a Change! "
> " It's always a great day to watch=A0Sports: "
> " Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! "
> " Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! "
> GSU
> *******************************************************************
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> JINMI=
> NG XIAO
> Sent: Thursday, July 21, 2011 9:59 PM
> To: ids@iiug.org
> Subject: Re: 951: Incorrect password error after Big Fix. [24431]
>
> 1) check $INFORMIXDIR/bin/oninit permission, it should be like -rwsr-sr-x
> 2=
> root informix 155243027 Jun 27 14:52 oninit=20
>
> 2) can you log in the machine with user 'informix'?=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.
>
>
>
>
*******************************************************************************
> 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...
--0016367d5fde6b94cb04a8afe2f9
A Big Fix is a process that one of our SA team uses to flash out fixes/patc=
hes/etc to servers. I've seen Big Fix products on some window servers, whi=
ch monitors and provides updates for you. Like MS updates.
Thanks,
*******************************************************************
Ernie Knox
IT Database=A0Administrator Specialist
Sears Holdings - BU: I & T Group
3333 Beverly Rd.
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Email: Ernest.Knox@searshc.com
Blackberry:=A02244650553@messaging.sprintpcs.com
Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com
Informix Primary: INFORMIXDBAPrimaryPager@searshc.com
Informix Secondary: INFORMIXDBASecondaryPager@searshc.com
MySQL Email: MySQLDBA2@searshc.com
MySQL Primary: MYSQLDBAPrimaryPager@searshc.com
MySQL Secondary: MYSQLDBASecondaryPager@searshc.com
" Yes we can make a Change! "
" It's always a great day to watch=A0Sports: "
" Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! "
" Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! "
GSU
*******************************************************************
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Ferna=
ndo Nunes
Sent: Friday, July 22, 2011 6:21 PM
To: ids@iiug.org
Subject: Re: 951: Incorrect password error after Big Fix. [24448]
Just for curiosity, what is a "big fix"?=20
Regards.=20
On Fri, Jul 22, 2011 at 3:02 AM, Knox, Ernest <Ernest.Knox@searshc.com>wrot=
e:=20
> We had the Big Fix reverted back to the original password file on 107=20
> serve=3D rs. That fixed the issue with the userid logins. It also=20
> affected the inf=3D ormix ID against the database.
>=20
> We are good now. Watch out for Big Fixes against the /etc/passwd file.=20
>=20
> Thanks,
> *******************************************************************
> Ernie Knox
> IT Database=3DA0Administrator Specialist Sears Holdings - BU: I & T=20
> Group
> 3333 Beverly Rd.=20
> Hoffman Estates, IL. 60179
> Office: (847) 286-5735
> Email: Ernest.Knox@searshc.com
> Blackberry:=3DA02244650553@messaging.sprintpcs.com
> Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com=20
> Informix Primary: INFORMIXDBAPrimaryPager@searshc.com
> Informix Secondary: INFORMIXDBASecondaryPager@searshc.com
> MySQL Email: MySQLDBA2@searshc.com
> MySQL Primary: MYSQLDBAPrimaryPager@searshc.com MySQL Secondary:=20
> MYSQLDBASecondaryPager@searshc.com
>=20
> " Yes we can make a Change! "=20
> " It's always a great day to watch=3DA0Sports: "=20
> " Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! "=20
> " Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! "=20
> GSU
> *******************************************************************
>=20
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of=20
> JINMI=3D NG XIAO
> Sent: Thursday, July 21, 2011 9:59 PM
> To: ids@iiug.org
> Subject: Re: 951: Incorrect password error after Big Fix. [24431]
>=20
> 1) check $INFORMIXDIR/bin/oninit permission, it should be like=20
> -rwsr-sr-x 2=3D root informix 155243027 Jun 27 14:52 oninit=3D20
>=20
> 2) can you log in the machine with user 'informix'?=3D20
>=20
>=20
> **********************************************************************
> *****=3D
> ****
> Forum Note: Use "Reply" to post a response in the discussion forum.=3D20
>=20
> This message, including any attachments, is the property of Sears=20
> Holdings =3D Corporation and/or one of its subsidiaries. It is=20
> confidential and may cont=3D ain proprietary or legally privileged=20
> information. If you are not the inten=3D ded recipient, please delete it=
=20
> without reading the contents. Thank you.
>=20
>=20
>=20
>=20
***************************************************************************=
****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>=20
>=20
--
Fernando Nunes
Portugal=20
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...=20
--0016367d5fde6b94cb04a8afe2f9=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.