DB taking delay of 15 min to get connected. Answered: green (solid confidence) — Asker confirms 'I figured it out, thank you for the help!!' after being pointed to the NS_CACHE onconfig parameter as the likely cause of the 15-minute password-sync delay.

Advisory only.

Posted in 2016

Summary

Siddharth Ravindran reported Informix connections taking 15 minutes after a password change on a two-node setup. Edcel Barcena pointed to the NS_CACHE onconfig parameter (11.7 and later), for example user=900. Siddharth said he figured it out; the exact change was not stated.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Security, Permissions & Auditing

SIDDHARTH RAVINDRAN — Tue, 05 Jan 2016 05:32:01 — source: IIUG Forums & Mailing Lists

Hi, Informix database is taking 15 minutes to get connected after changing the password and this behaviour is consistent.It looks like the new password is not getting updated in the DB. The setup is a two node setup. I would like to know if this behaviour from the informix Db side ? Is there any parameter that specifies the password to be synched ? Looking forward to your inputs regarding this issue. Thanks, Siddharth Ravindran

↪ replying to SIDDHARTH RAVINDRAN

Edcel Barcena — Tue, 05 Jan 2016 06:40:09 — source: IIUG Forums & Mailing Lists

Hi Siddharth, Not sure which version of Informix you're using but for v11.7 and later, you may want to look at the NS_CACHE configuration parameter. NS_CACHE host=900,service=900,user=900,group=900 Regards, Edcel Sent from my iPhone > On Jan 5, 2016, at 4:32 PM, SIDDHARTH RAVINDRAN <siravind@cisco.com> wrote: > > Hi, > > Informix database is taking 15 minutes to get connected after changing the > password and this behaviour is consistent.It looks like the new password is > not getting updated in the DB. The setup is a two node setup. I would like to > know if this behaviour from the informix Db side ? Is there any parameter that > specifies the password to be synched ? Looking forward to your inputs > regarding this issue. > > Thanks, > Siddharth Ravindran > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Edcel Barcena

SIDDHARTH — Tue, 05 Jan 2016 06:56:56 — source: IIUG Forums & Mailing Lists

Hi Edcel, Thank you for the swift response, could you please let me know where I can find the configuration parameter NS_CACHE ? Thanks, Siddharth

↪ replying to SIDDHARTH

Edcel Barcena — Tue, 05 Jan 2016 07:38:40 — source: IIUG Forums & Mailing Lists

It's in the ONCONFIG file. Sent from my iPhone > On Jan 5, 2016, at 5:57 PM, SIDDHARTH RAVINDRAN <siravind@cisco.com> wrote: > > Hi Edcel, > > Thank you for the swift response, could you please let me know where I can > find the configuration parameter NS_CACHE ? > > Thanks, > Siddharth > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Edcel Barcena

SIDDHARTH — Tue, 05 Jan 2016 07:48:05 — source: IIUG Forums & Mailing Lists

Hi, I figured it out, thank you for the help !! Thanks, Siddharth

DB taking delay of 15 min to get connected. ✓ Answered: green (solid confidence) — Asker confirms 'I figured it out, thank you for the help!!' after being pointed to the NS_CACHE onconfig parameter as the likely cause of the 15-minute password-sync delay.Advisory only.

DB taking delay of 15 min to get connected. Answered: green (solid confidence) — Asker confirms 'I figured it out, thank you for the help!!' after being pointed to the NS_CACHE onconfig parameter as the likely cause of the 15-minute password-sync delay.

Advisory only.