标题: db2inst1用户无法登录EXTRA
aheng
LU新生
Rank: 1



UID 2362
精华 0
积分 11
帖子 21
活跃指数 0
LU金币 2007 个
LU金条 0 个
阅读权限 10
注册 2003-11-13
 
发表于 2003-11-19 14:43  资料  个人空间  短消息  加为好友 
在rs6000(aix5.1)安装db2数据库,数据库用户db2inst1无法登录EXTRA,提示见附件,我安照提示修改db2$home/.dtprofile增加下面一行
export DT_TTSESSION_TIMEOUT=120
重新登录依然失败。



 附件: 您所在的用户组无法下载或查看附件
顶部
燕狂徒
版主
Rank: 15Rank: 15Rank: 15Rank: 15Rank: 15


LU爱心使者  
UID 59
精华 14
积分 1707
帖子 3208
活跃指数 155
LU金币 4924 个
LU金条 616 个
阅读权限 210
注册 2003-9-19
 
发表于 2003-11-19 15:17  资料  个人空间  主页 短消息  加为好友 
这个是老问题,用户不能登录CDE
你别的用户登录有问题不,把db2inst的。profile贴出来看看
另外就是你的/etc/hosts
主要检查你的网络设置





http://www.100c.com.cn/oblog/user1/1/index.html
顶部
workaholic
荣誉斑竹
Rank: 14Rank: 14Rank: 14Rank: 14


LU爱心使者  
UID 124
精华 40
积分 1857
帖子 3422
活跃指数 231
LU金币 9244 个
LU金条 1486 个
阅读权限 200
注册 2003-9-25
 
发表于 2003-11-19 15:36  资料  个人空间  主页 短消息  加为好友  添加 workaholic 为MSN好友 通过MSN和 workaholic 交谈
提问题的时候为什么不首先在论坛里SEARCH一下?该问题曾经有过专门的讨论的。





mail & msn : workaholic@yeah.net
顶部
aheng
LU新生
Rank: 1



UID 2362
精华 0
积分 11
帖子 21
活跃指数 0
LU金币 2007 个
LU金条 0 个
阅读权限 10
注册 2003-11-13
 
发表于 2003-11-21 11:44  资料  个人空间  短消息  加为好友 
对不起,我没有查询到。其他用户可以登录,下面是db2inst1用户的.profile
set vi -r
PATH=/usr/lpp/cics/bin/:/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.

export PATH

if [ -s "$MAIL" ] # This is at Shell startup. In normal
then echo "$MAILMSG" # operation, the Shell checks
fi # periodically.

# The following three lines have been added by UDB DB2.
if [ -f /home/db2inst1/sqllib/db2profile ]; then
. /home/db2inst1/sqllib/db2profile
fi

顶部
larryh
超级版主
Rank: 17Rank: 17Rank: 17Rank: 17Rank: 17



LU爱心使者  
UID 133
精华 29
积分 3988
帖子 7367
活跃指数 258
LU金币 3710 个
LU金条 5409 个
阅读权限 251
注册 2003-9-26
 
发表于 2003-11-21 12:01  资料  个人空间  短消息  加为好友 
1. 贴出/home/db2inst1/sqllib/db2profile
2. 贴出/home/db2inst1/.dt/startlog

顶部
aheng
LU新生
Rank: 1



UID 2362
精华 0
积分 11
帖子 21
活跃指数 0
LU金币 2007 个
LU金条 0 个
阅读权限 10
注册 2003-11-13
 
发表于 2003-11-21 12:57  资料  个人空间  短消息  加为好友 
db2profle:
----------------------------------------------------------------------
#
#############################################################################
#
# Licensed Materials - Property of IBM
#
# 5724-B62
# © COPYRIGHT International Business Machines Corp. 1993, 2002
#
# 5724-D54
# © COPYRIGHT International Business Machines Corp. 1993, 2002
#
# 5765-F35
# © COPYRIGHT International Business Machines Corp. 1993, 2002
#
# 5765-F43
# © COPYRIGHT International Business Machines Corp. 1993, 2002
#
# 5765-F41
# © COPYRIGHT International Business Machines Corp. 1993, 2002
#
# 5765-F30
# © COPYRIGHT International Business Machines Corp. 1993, 2002
#
# 5765-F34
# © COPYRIGHT International Business Machines Corp. 1993, 2002
#
# 5765-F31
# © COPYRIGHT International Business Machines Corp. 1993, 2002
#
# 5765-F42
# © COPYRIGHT International Business Machines Corp. 1993, 2002
#
# All Rights Reserved
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
#############################################################################
#
# NAME: db2profile
#
# FUNCTION: This script sets up a default database environment for
# Bourne shell or Korn shell users.
#
# USAGE: . db2profile
# This script can either be invoked directly as above or
# it can be added to the user's .profile file so that the
# database environment is established during login.
#
# #### DO NOT EDIT THIS FILE ####
#
#############################################################################

# Default DB2 product directory
DB2DIR="/usr/opt/db2_08_01"

# Function to avoid repetitive environment variable entries
AddtoString()
{
var=$1
addme=$2
awkval='$1 != "'${addme?}'"{print $0}'
newval=`eval /usr/bin/echo \\${$var} | /usr/bin/awk "${awkval?}" RS=:`
eval ${var?}=`/usr/bin/echo $newval | /usr/bin/sed 's/ /:/g'`:${addme?}
unset var addme awkval newval
}

#-----------------------------------------------------------------------
# DB2INSTANCE [Default null, values: Any valid instance name]
# Specifies the instance that is active by default.
#-----------------------------------------------------------------------
DB2INSTANCE=db2inst1
export DB2INSTANCE

INSTHOME=/home/db2inst1

#-----------------------------------------------------------------------
# First remove any sqllib entries from the user's path.
# Add the directories:
# INSTHOME/sqllib/bin - database executables
# INSTHOME/sqllib/adm - sysadm executables
# INSTHOME/sqllib/misc - miscellaneous utilities
# to the user's PATH.
#-----------------------------------------------------------------------

AddtoString PATH ${INSTHOME?}/sqllib/bin
AddtoString PATH ${INSTHOME?}/sqllib/adm
AddtoString PATH ${INSTHOME?}/sqllib/misc
export PATH

#-----------------------------------------------------------------------
# UDB Extender initialization
#-----------------------------------------------------------------------
if [ -f ${INSTHOME}/dmb/dmbprofile ]; then
. ${INSTHOME}/dmb/dmbprofile
fi

#-----------------------------------------------------------------------
# The following variables are used for JDBC support
#-----------------------------------------------------------------------
CLASSPATH=${CLASSPATH:-""}

if [ -f ${INSTHOME?}/sqllib/java/db2java.zip ]; then
AddtoString CLASSPATH ${INSTHOME?}/sqllib/java/db2java.zip
fi
if [ -f ${INSTHOME?}/sqllib/java/db2jcc.jar ]; then
AddtoString CLASSPATH ${INSTHOME?}/sqllib/java/db2jcc.jar
fi
if [ -f ${INSTHOME?}/sqllib/java/sqlj.zip ]; then
AddtoString CLASSPATH ${INSTHOME?}/sqllib/java/sqlj.zip
fi
if [ -d ${INSTHOME?}/sqllib/function ]; then
AddtoString CLASSPATH ${INSTHOME?}/sqllib/function
fi

AddtoString CLASSPATH .
export CLASSPATH

#-----------------------------------------------------------------------
# The following variables are used for Data Warehouse support
#-----------------------------------------------------------------------
if [ -d ${INSTHOME?}/sqllib/templates ]; then
VWS_TEMPLATES=${INSTHOME?}/sqllib/templates
export VWS_TEMPLATES
fi
if [ -d ${INSTHOME?}/sqllib/logging ]; then
VWS_LOGGING=${INSTHOME?}/sqllib/logging
export VWS_LOGGING
fi
VWSPATH=${INSTHOME?}/sqllib
export VWSPATH

LD_LIBRARY_PATH=${LD_LIBRARY_PATH:-""}
AddtoString LD_LIBRARY_PATH ${INSTHOME}/sqllib/lib
export LD_LIBRARY_PATH

LIBPATH=${LIBPATH:-"/usr/lib:/lib"}
AddtoString LIBPATH ${INSTHOME}/sqllib/lib
export LIBPATH

# Any user changes to the environment goes into userprofile. Modifications
# to db2profile may be overwritten in fixpaks.
if [ -f ${INSTHOME?}/sqllib/userprofile ]
then
. ${INSTHOME?}/sqllib/userprofile
fi
---------------------------------------------------------------------
startlog
--- Wed Nov 19 07:45:01 BEIST 2003
--- /usr/dt/bin/Xsession starting...
--- Xsession started by dtlogin
--- sourcing /home/db2inst1/.dtprofile...
--- sourcing /usr/dt/config/Xsession.d/0010.dtpaths...
--- sourcing /usr/dt/config/Xsession.d/0030.dttmpdir...
--- sourcing /usr/dt/config/Xsession.d/0040.xmbind...
--- sourcing /usr/dt/config/Xsession.d/0050.dtxmodmap...
--- starting /usr/dt/bin/dthello &
--- starting /usr/dt/bin/dtsearchpath
/usr/dt/bin/dthello: display 192.168.100.90:0.0 doesn't know font -dt-interface system-medium-r-normal-l*-*-*-*-*-*-*-*-*
--- starting /usr/dt/bin/dtappgather &
--- execing /usr/dt/bin/dtsession using /home/db2inst1/.profile...

--- Tooltalk Message Server did not start within timeout specified.
--- Launching Xfailsafe_tooltalk_error to correct problems.
Warning: Cannot convert string "-dt-interface system-medium-r-normal-s*-*-*-*-*-*-*-*-*" to type FontStruct
Warning: Missing charsets in String to FontSet conversion
Warning: Cannot convert string "-dt-interface system-medium-r-normal-s*-*-*-*-*-*-*-*-*" to type FontSet
Warning: Missing charsets in String to FontSet conversion
Warning: Cannot convert string "-dt-interface user-medium-r-normal-m*-*-*-*-*-*-*-*-*" to type FontSet

顶部
[广告] 记录自己的思想火花,留住每日的技术积累,尽在拥有属于自己独立域名的博客。
larryh
超级版主
Rank: 17Rank: 17Rank: 17Rank: 17Rank: 17



LU爱心使者  
UID 133
精华 29
积分 3988
帖子 7367
活跃指数 258
LU金币 3710 个
LU金条 5409 个
阅读权限 251
注册 2003-9-26
 
发表于 2003-11-21 14:13  资料  个人空间  短消息  加为好友 
好像这个dtprofile有问题,因为是执行了.profile并由它调用dtprofile后才执行dtsession的,只有这个用户启动dtsession有问题,说明和.profile也就是dtprofile有关,应该是环境变量被dtprofile搞出问题了。
我试了试,dtprofile的模块AddtoString会将原来的环境变量内容删除再加上指定的内容,而其作用应该是在原有的后面加:
CODE

AddtoString()
{
var=$1
addme=$2
awkval='$1 != "'${addme?}'"{print $1}'
newval=`eval /usr/bin/echo \\${$var} | /usr/bin/awk "${awkval?}" RS=:`
eval ${var?}=`/usr/bin/echo $newval | /usr/bin/sed 's/ /:/g'`:${addme?}
unset var addme awkval newval
}

AddtoString OO 888

echo $OO

OO=/pp
./uu
执行结果是
:888
而正常应该是
/pp:888

顶部
[广告] 记录自己的思想火花,留住每日的技术积累,尽在拥有属于自己独立域名的博客。
aheng
LU新生
Rank: 1



UID 2362
精华 0
积分 11
帖子 21
活跃指数 0
LU金币 2007 个
LU金条 0 个
阅读权限 10
注册 2003-11-13
 
发表于 2003-11-21 15:00  资料  个人空间  短消息  加为好友 
我无法解决这个问题,请求帮助.

顶部
[广告] 记录自己的思想火花,留住每日的技术积累,尽在拥有属于自己独立域名的博客。
aheng
LU新生
Rank: 1



UID 2362
精华 0
积分 11
帖子 21
活跃指数 0
LU金币 2007 个
LU金条 0 个
阅读权限 10
注册 2003-11-13
 
发表于 2003-11-21 15:00  资料  个人空间  短消息  加为好友 
我无法解决这个问题,请求帮助.

顶部
[广告] 记录自己的思想火花,留住每日的技术积累,尽在拥有属于自己独立域名的博客。
larryh
超级版主
Rank: 17Rank: 17Rank: 17Rank: 17Rank: 17



LU爱心使者  
UID 133
精华 29
积分 3988
帖子 7367
活跃指数 258
LU金币 3710 个
LU金条 5409 个
阅读权限 251
注册 2003-9-26
 
发表于 2003-11-21 15:48  资料  个人空间  短消息  加为好友 
由看了看,我搞错,试验的时候应当把OO=/pp放在脚本里就没问题。
最好把dtprofile从.profile里拿掉,看能否登录进CDE

顶部
[广告] 土人
aheng
LU新生
Rank: 1



UID 2362
精华 0
积分 11
帖子 21
活跃指数 0
LU金币 2007 个
LU金条 0 个
阅读权限 10
注册 2003-11-13
 
发表于 2003-11-26 12:51  资料  个人空间  短消息  加为好友 
不能登录,谁有高招?

顶部
[广告] 土人
 



当前时区 GMT+8, 现在时间是 2008-8-22 05:48
乐悠LoveUnix论坛-京ICP备05005823号

Thanks to Discuz!  © 2001-2007    Power by LoveUnix.net
Processed in 0.057602 second(s), 6 queries , Gzip enabled

清除 Cookies - 联系我们 - 乐悠LoveUnix - Archiver