晕了 HP UNIX的用户名密码怪问题，要吐血了

woshiyiziyu

晕了 HP UNIX的用户名密码怪问题，要吐血了

本帖最后由 woshiyiziyu 于 2009-10-21 21:15 编辑 我有两台HP-UX的机器192.168.100.228和192.168.100.232，两台机器上装的hp-unix操作系统的版本是一样的 192.168.100.228 hp8420a1[/]#uname -a HP-UX hp8420a1 B.11.11 U 9000/800 1571746837 unlimited-user license 192.168.100.232 [hp8420a3]/#uname -a HP-UX hp8420a3 B.11.11 U 9000/800 1571746837 unlimited-user license 在这两台机器上我都安装了sybase数据库，数据库的版本也是一样的，都是12.5.0.3. $ dataserver -v Adaptive Server Enterprise/12.5.0.3/EBF 11447 ESD#4/P/HP9000-879/HP-UX 11.0/rel12503/1939/64-bit/FBO/Sun Sep 21 06:02:05 2003 Confidential property of Sybase, Inc. Copyright 1987, 2003 Sybase, Inc.  All rights reserved. Unpublished rights reserved under U.S. copyright laws. This software contains confidential and trade secret information of Sybase, Inc.   Use,  duplication or disclosure of the software and documentation by the  U.S.  Government  is  subject  to  restrictions set forth in a license agreement  between  the  Government  and  Sybase,  Inc.  or  other  written agreement  specifying  the  Government\'s rights to use the software and any applicable FAR provisions, for example, FAR 52.227-19. Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA 一件很奇怪的事情发生了 在192.168.100.228上我可以正常登陆 $ isql -Usa -PPos@07 -Smkt07                                           1> 但是在192.168.100.232上则不可以， $ isql -Usa -PPos@10 -Smkt10 sh: Mkt10:  not found. 经过仔细的研究发现是HP-UNIX操作系统的问题，192.168.100.232不识别特殊字符@，需要进行转义处理---在@前加反斜杠即可 $ isql -Usa -PPos\\@Mkt10 -Smkt10 1> 192.168.100.228的环境变量 $ env _=/usr/bin/env MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/upgrade/share/man/%L:/opt/upgrade/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/mx/share/man:/opt/resmon/share/man:/usr/dt/share/man:/opt/samba/man:/opt/gnome/man:/opt/perl/man:/opt/wbem/share/man:/opt/openssl/man:/opt/openssl/prngd/man:/opt/hparray/share/man/%L:/opt/hparray/share/man:/opt/graphics/common/man:/opt/perf/man/%L:/opt/perf/man SYBASE_SYSAM=SYSAM-1_0 SYBASE_FTS=EFTS-12_5 SHLIB_PATH=/sybase/ASE-12_5/lib:/sybase/OCS-12_5/lib:/sybase/OCS-12_5/lib3p:/sybase/EFTS-12_5/lib PATH=/sybase/ASE-12_5/bin:/sybase/OCS-12_5/bin:/sybase/CFG-1_0/bin:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/upgrade/bin:/opt/fcms/bin:/opt/pd/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/resmon/bin:/opt/mx/bin:/opt/gnome/bin:/opt/mozilla:/opt/perl/bin:/opt/wbem/bin:/opt/wbem/sbin:/usr/sbin/diag/contrib:/opt/graphics/common/bin:/opt/ignite/bin:/opt/perf/bin:. COLUMNS=125 EDITOR=vi SYBASE_JRE=/sybase/shared-1_0/jre1.2.2 LOGNAME=sybase ERASE=^H SYBASE=/sybase SHELL=/usr/bin/sh HOME=/sybase SYBASE_ASE=ASE-12_5 LD_LIBRARY_PATH=/sybase/OCS-12_5/lib:/sybase/OCS-12_5/lib3p64 TERM=vt100 PWD=/sybase TZ=EAT-8 SYBASE_OCS=OCS-12_5 LINES=40 192.168.100.232的环境变量 $ env _=/usr/bin/env MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/upgrade/share/man/%L:/opt/upgrade/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/mx/share/man:/opt/resmon/share/man:/usr/dt/share/man:/opt/samba/man:/opt/gnome/man:/opt/perl/man:/opt/wbem/share/man:/opt/openssl/man:/opt/openssl/prngd/man:/opt/hparray/share/man/%L:/opt/hparray/share/man:/opt/graphics/common/man:/opt/perf/man/%L:/opt/perf/man SYBASE_SYSAM=SYSAM-1_0 SYBASE_FTS=EFTS-12_5 SHLIB_PATH=/sybase/ASE-12_5/lib:/sybase/OCS-12_5/lib:/sybase/OCS-12_5/lib3p:/sybase/EFTS-12_5/lib: PATH=/sybase/ASE-12_5/bin:/sybase/OCS-12_5/bin:/sybase/CFG-1_0/bin:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/upgrade/bin:/opt/fcms/bin:/opt/pd/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/resmon/bin:/opt/mx/bin:/opt/gnome/bin:/opt/mozilla:/opt/perl/bin:/opt/wbem/bin:/opt/wbem/sbin:/usr/sbin/diag/contrib:/opt/graphics/common/bin:/opt/ignite/bin:/opt/perf/bin COLUMNS=125 LM_LICENSE_FILE=/sybase/SYSAM-1_0/licenses/license.dat: SYBASE_JRE=/sybase/shared-1_0/jre1.2.2 LOGNAME=sybase ERASE=^H SYBASE=/sybase SHELL=/sbin/sh HOME=/sybase SYBASE_ASE=ASE-12_5 LD_LIBRARY_PATH=/sybase/OCS-12_5/lib:/sybase/OCS-12_5/lib3p64: TERM=vt100 PWD=/sybase/ASE-12_5/bin TZ=EAT-8 SYBASE_OCS=OCS-12_5 LINES=40 经过仔细的对比我没有看出这两台机器的sybase用户环境变量有什么“本质”的区别，有可能是我没有看出来。 此外我还做了如下实验，在192.168.100.228（包含@但是可以正常登陆的服务器）上添加了一个测试帐户 hp8420a1[/]#useradd suncs hp8420a1[/]#passwd suncs Changing password for suncs New password: Re-enter new password: Passwd successfully changed   （密码是qazwsx） 新开一个窗口使用用户suncs可以正常登陆192.168.100.228 再次更改suncs的密码 hp8420a1[/]#useradd suncs hp8420a1[/]#passwd suncs Changing password for suncs New password: Re-enter new password: Passwd successfully changed    （密码是pos@sun) 再次用suncs登陆系统的时候输入密码[email=pos@sun]pos@sun[/email]不能登陆，输入pos\\@sun可以正常登陆。 我最终的问题是为什么我的机器一台可以正常登陆，另一台却必须要在@前加上\\号才可以正常登陆呢？

woshiyiziyu

补充终端设置，没有区别。
192.168.100.228
$ stty -a
speed 9600 baud; line = 0;
rows = 40; columns = 125
min = 1; time = 0;
intr = ^C; quit = ^\\; erase = ^H; kill = ^U
eof = ^D; eol = ^@; eol2 <undef>; swtch <undef>
stop = ^S; start = ^Q; susp <undef>; dsusp <undef>
werase <undef>; lnext <undef>
parenb -parodd cs7 -cstopb hupcl -cread -clocal -loblk -crts
-ignbrk brkint ignpar -parmrk -inpck istrip -inlcr -igncr icrnl -iuclc
ixon -ixany ixoff -imaxbel -rtsxoff -ctsxon -ienqak
isig icanon -iexten -xcase echo echoe echok -echonl -noflsh
-echoctl -echoprt -echoke -flusho -pendin
opost -olcuc onlcr -ocrnl -onocr -onlret -ofill -ofdel -tostop

192.168.100.232
$ stty -a
speed 9600 baud; line = 0;
rows = 40; columns = 125
min = 4; time = 0;
intr = ^C; quit = ^\\; erase = ^H; kill = ^U
eof = ^D; eol = ^@; eol2 <undef>; swtch <undef>
stop = ^S; start = ^Q; susp <undef>; dsusp <undef>
werase <undef>; lnext <undef>
parenb -parodd cs7 -cstopb hupcl -cread -clocal -loblk -crts
-ignbrk brkint ignpar -parmrk -inpck istrip -inlcr -igncr icrnl -iuclc
ixon -ixany ixoff -imaxbel -rtsxoff -ctsxon -ienqak
isig icanon -iexten -xcase echo echoe echok -echonl -noflsh
-echoctl -echoprt -echoke -flusho -pendin
opost -olcuc onlcr -ocrnl -onocr -onlret -ofill -ofdel -tostop

woshiyiziyu

补充一下：
在192.168.100.232下先使用用户名sybase登陆，然后su - root,然后再exit，然后再
isql -Usa -PPos@Mkt10 -Smkt10，可以登陆。
$ isql -Usa -PPos@Mkt10 -Smkt10
1>
也就是必须先用root用户登陆一下，再\"su - sybase\"才可以正常登陆。
root用户环境变量如下：
[hp8420a3]/#env
_=/usr/bin/env
MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/upgrade/share/man/%L:/opt/upgrade/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/mx/share/man:/opt/resmon/share/man:/usr/dt/share/man:/opt/samba/man:/opt/gnome/man:/opt/perl/man:/opt/wbem/share/man:/opt/openssl/man:/opt/openssl/prngd/man:/opt/hparray/share/man/%L:/opt/hparray/share/man:/opt/graphics/common/man:/opt/perf/man/%L:/opt/perf/man
PATH=/usr/sbin:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/upgrade/bin:/opt/fcms/bin:/opt/pd/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/resmon/bin:/opt/mx/bin:/opt/gnome/bin:/opt/mozilla:/opt/perl/bin:/opt/wbem/bin:/opt/wbem/sbin:/usr/sbin/diag/contrib:/opt/graphics/common/bin:/opt/ignite/bin:/opt/perf/bin:/sbin:/home/root
COLUMNS=125
EDITOR=vi
LOGNAME=root
ERASE=^H
PS1=[hp8420a3\\]$PWD#
SHELL=/sbin/sh
TERM=vt100
PWD=/
TZ=EAT-8我又怀疑是用户的shell问题
192.168.100.232
$ cat /etc/passwd
sybase:AjArFjChsfsC2:105:103::/sybase:/sbin/sh
192.168.100.228
$ cat /etc/passwd
sybase:zGtYjhPNQNwE2:105:20:,,,:/sybase:/usr/bin/sh
所以我在192.168.100.232上chsh sybase /usr/bin/sh ,然后打开一个新窗口（连接工具为securt 5.5），看到虽然用户的shell改变了，但是问题依然没有解决。
LINES=40

woshiyiziyu

[hp8420a3]/#chsh sybase /usr/bin/sh
[hp8420a3]/#finger sybase
Login name: sybase      (messages off)
Directory: /sybase                      Shell: /usr/bin/sh
On since Oct 22 08:53:47 on pts/ta from 192.168.116.37
6 minutes 2 seconds Idle Time
New mail received Mon Nov 12 16:39:52 2007;
unread since Thu Oct 22 09:06:31 2009
No Plan.

Login name: sybase      (messages off)
Directory: /sybase                      Shell: /usr/bin/sh
On since Oct 22 09:06:31 on pts/tc from 192.168.116.24
新开一个窗口
$ isql -Usa -PPoos@Mkt10 -Smkt10
sh: Mkt10:  not found.
$ isql -Usa -PPoos\\@Mkt10 -Smkt10
1>
问题依然如此。

woshiyiziyu

在同一个窗口下修改了shell也不行
$ chsh sybase /usr/bin/sh
$ finger sybase
Login name: sybase      (messages off)  
Directory: /sybase                      Shell: /usr/bin/sh
On since Oct 22 08:53:47 on pts/ta from 192.168.116.37
14 minutes Idle Time
New mail received Mon Nov 12 16:39:52 2007;
unread since Thu Oct 22 09:16:49 2009
No Plan.

Login name: sybase      (messages off)  
Directory: /sybase                      Shell: /usr/bin/sh
On since Oct 22 09:06:31 on pts/tc from 192.168.116.24
19 seconds Idle Time

Login name: sybase      (messages off)  
Directory: /sybase                      Shell: /usr/bin/sh
On since Oct 22 09:09:16 on pts/td from 192.168.116.24
7 minutes 14 seconds Idle Time

Login name: sybase      (messages off)  
Directory: /sybase                      Shell: /usr/bin/sh
On since Oct 22 09:16:49 on pts/th from 192.168.116.24

$ isql -Usa -PPoos@Mkt10 -Smkt10
sh: Mkt10:  not found.
$ isql -Usa -PPoos\\@Mkt10 -Smkt10
1>

woshiyiziyu

经过仔细的研究发现是HP-UNIX操作系统的问题，192.168.100.232不识别特殊字符@，需要进行转义处理---在@前加反斜杠即可
$ isql -Usa -PPos\\@Mkt10 -Smkt10
1>
就是说为什么在sybase数据库的密码中包含@符号时需要在前面加\\号，系统才能识别？又为什么在su - root之后在su - sybase 之后系统就能识别了呢？

michael1983

兄弟真是执着
知道答案了吗