Ingres Tech Support Issue 141589
From PTAGISWiki
| Day, Ryan F | 12/14/2009 01:53 pm | Log Comment I ran netutil as root on the failing client and found a spurious private vnode entry for user root. I removed that vnode entry and now the application behaves as expected.
Our procedure is to always run netutil as user ingres, so I did not see the private vnode entry for root until now. Thank you for your help resolving this issue. |
| Day, Ryan F | 12/11/2009 01:54 pm | Log Comment the failing script runs as root on the client |
| Day, Ryan F | 12/11/2009 01:40 pm | Log Comment Connecting via sql at the command prompt as user ingres works from both clients:
Working client bay:ingres: > sql -upittag blueback::ptagis3 INGRES TERMINAL MONITOR Copyright 2007 Ingres Corporation Ingres 2006 Release 2 SPARC SOLARIS Version II 9.1.1 (su9.us5/103) login Fri Dec 11 13:39:14 2009 continue * \q Ingres 2006 Release 2 Version II 9.1.1 (su9.us5/103) logout Fri Dec 11 13:39:18 2009 Broken client jack:ingres: > sql -upittag blueback::ptagis3 INGRES TERMINAL MONITOR Copyright 2007 Ingres Corporation Ingres 2006 Release 2 SPARC SOLARIS Version II 9.1.1 (su9.us5/103) login Fri Dec 11 13:39:39 2009 continue * \q Ingres 2006 Release 2 Version II 9.1.1 (su9.us5/103) logout Fri Dec 11 13:41:08 2009 But connecting via the sql command prompt as user root only works on one client. Working client bay:D2:root: > sql -upittag blueback::ptagis3 INGRES TERMINAL MONITOR Copyright 2007 Ingres Corporation Ingres 2006 Release 2 SPARC SOLARIS Version II 9.1.1 (su9.us5/103) login Fri Dec 11 13:41:51 2009 continue * \q Ingres 2006 Release 2 Version II 9.1.1 (su9.us5/103) logout Fri Dec 11 13:41:52 2009 Broken client
jack:D2:root: > sql -upittag blueback::ptagis3
INGRES TERMINAL MONITOR Copyright 2007 Ingres Corporation
E_LC0001 GCA protocol service (GCA_REQUEST) failure.
Internal service status E_GC0142 -- The installation password for the
remote vnode is invalid..
E_LQ0001 Failed to connect to DBMS session.
|
| Day, Ryan F | 12/11/2009 01:36 pm | Log Comment Here is the output of ingprenv for various machines:
Server BLUEBACK:ingres: > pwd /usr/ingres BLUEBACK:ingres: > ingprenv ING_ABFDIR=/usr/ing2006r2/ingUI/ingres/abf II_LP64_ENABLED=TRUE II_CONFIG=/usr/ing2006r2/ingUI/ingres/files II_INSTALLATION=UI II_GCNUI_LCL_VNODE=blueback II_DATABASE=/usr/db4/ingUI II_CHECKPOINT=/usr/ckp/ingUI II_JOURNAL=/usr/arch/ingUI II_DUMP=/usr/arch/ingUI II_WORK=/usr/arch/ingUI II_NUM_OF_PROCESSORS=8 II_MAX_SEM_LOOPS=2000 II_TIMEZONE_NAME=NA-PACIFIC II_CHARSETUI=ISO88591 II_TEMPORARY=/tmp ING_EDIT=/usr/bin/vi II_GCNUI_PORT=/ii/ii.8282 II_SHADOW_PWD=/usr/ing2006r2/ingUI/ingres/bin/ingvalidpw II_INSTALL_CTL=/usr/ing2006r2/ingUI/ingres/install/control II_PATCH_BACKUP=/usr/ing2006r2/ingUI/ingres/install/backup II_GC_PROT=UNIX II_GC_PORT=/ii/ II_DATE_CENTURY_BOUNDARY=80 II_LG_MEMSIZE=152510464 Working client bay:ingres: > ingprenv II_CHARSETD2=ISO88591 II_TIMEZONE_NAME=na-pacific II_INSTALLATION=D2 II_TEMPORARY=/tmp ING_EDIT=/usr/bin/vi II_GCND2_PORT=64155 II_INSTALL_CTL=/usr/ingres/ing2006r2/ingD2/ingres/install/control II_PATCH_BACKUP=/usr/ingres/ing2006r2/ingD2/ingres/install/backup Broken client jack:ingres: > ingprenv II_CHARSETD2=ISO88591 II_TIMEZONE_NAME=na-pacific II_INSTALLATION=D2 II_TEMPORARY=/tmp ING_EDIT=/usr/bin/vi II_GCND2_PORT=61452 II_INSTALL_CTL=/usr/ingres/ing2006r2/ingD2/ingres/install/control II_PATCH_BACKUP=/usr/ingres/ing2006r2/ingD2/ingres/install/backup II_SHADOW_PWD=/usr/ingres/ing2006r2/ingD2/ingres/bin/ingvalidpw |
| Ianculovici, Cristia | 12/11/2009 12:34 pm | Email Hi Ryan,
This error is related to using installation passwords. Is this the case with your vnodes on both the environment that works and the one that does not work? If it is, can you connect to the server using the sql command: sql -u... vnode::database_name from both clients, the one that works and the one that doesn't. If not, could you please try to recreate the installation password vnode from the server? If none of these work, but the sonnection via sq prompt works on both clients, please let me have a sample .pl script that does the connection. I would like to try that in my environment. Regards, Cristian Ianculovici Ingres Specialist Ingres Corporation www.ingres.com PHONE +1 877.346.4737 (+1-877-3-INGRES) This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system. |
| Ianculovici, Cristia | 12/11/2009 12:28 pm | Email Hi Ryan,
Could you please post the outputs of ingprenv for both, the client and the server? Thank you, Cristian Ianculovici Ingres Specialist Ingres Corporation www.ingres.com PHONE +1 877.346.4737 (+1-877-3-INGRES) This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system. |
| Day, Ryan F | 12/11/2009 12:07 pm | Initial Contact: Day, Ryan F
Phone: +1 503-595-3141 Email: rday@psmfc.org |
