ifx
编码问题
字符编码及Informix中文支持配置方法
951错误
特殊字符处理
常用脚本与sql
unload相关
本文档使用 MrDoc 发布
-
+
首页
951错误
> 摘自IBM官网 # How to fix Informix® error -951 when clients try to connect ## Question & Answer ### Question When client connections try to reach the Informix instance, the error -951 (User username is not known on the database server/User is not known on remote host) is raised, avoiding clients to connect. ### Cause You see errors like this in the online.log file: ```rst 13:14:57 Get Shadow Password for user [username] failed! 13:14:57 Check for password aging/account lock-out. 13:14:57 listener-thread: err = -951: oserr = 0: errstr = username@::ffff:10.10.10.31[server.host.net]: Incorrect password or user username@::ffff:10.10.10.31[server.host.net] is not known on the database server. ``` Several symptoms can cause such behaviour: 1. SQLHOSTS file mispelled entries; 2. DBSERVERNAME or DBSERVERALIASES onconfig parameters have no related entries in the SQLHOSTS file; 3. NIS or LDAP servers misconfiguration or maintenance; 4. INFORMIXDIR filesystem and/or its subdirectories have wrong permissions or ownership; 5. User is locked or expired; 6. oninit binary is somehow damaged or have wrong permissions. /*较为常见,直接停库改权限`chown root:informix oninit;chmod 6754 oninit;` ## Answer Here's a list of things to check when facing such a problem: 1) Double-check the SQLHOSTS file for missing or mispelled entries regarding the DBSERVERNAME and DBSERVERALIASES onconfig parameter values; 2) Validate with the OS staff changes in the LDAP or NIS servers; If none of the above were causing the issue, check the INFORMIXDIR filesystem for proper permissions and/or ownership: 1) Collect an ls -ltrR output from the INFORMIXDIR filesystem and compare its contents with the $INFORMIXDIR/etc/IIFfiles file; 2) Check for onwership too; If the contents of the ls -ltrR diverges from the $INFORMIXDIR/etc/IIFfiles file, consider doing one of following: 1) Fix manually the missing permissions or ownership of every file/subdirectory; 2) Copy the INFORMIXDIR filesystem from another validated non-productive host; 3) Restore this filesystem from backup; 4) Re-install the Informix Server binaries. In any of the options above, make proper backups of critical files like the onconfig, sqlhosts and ixbar files. **Important**: these are just a few probable causes for this problem, if this document didn't solve your issue, consider calling IBM Informix Technical Support for assistance.
major
2024年6月4日 14:46
转发文档
收藏文档
上一篇
下一篇
手机扫码
复制链接
手机扫一扫转发分享
复制链接
Markdown文件
PDF文档(打印)
分享
链接
类型
密码
更新密码