【linux】centos7下使用和客户端远程链接sybase

小慌慌

已于 2022-03-22 12:50:55 修改

阅读量2.3k

点赞数

分类专栏： linux 文章标签： sybase

于 2022-03-22 00:44:32 首次发布

本文为博主「小慌慌」原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。--by 留白

本文链接：https://blog.csdn.net/whowhowhoisimportant/article/details/123649806

版权

linux 专栏收录该内容

57 篇文章 8 订阅

订阅专栏

linux下使用和客户端远程链接sybase

（1）interface文件里的localhost要改成ip地址，才能通过client访问

（2）检查网络联通性，端口是否开发，或者防火墙状态

1、注意事项

Linux注意事项

（1）编码格式
（2）检查服务端口是否启动成功

1、设置为自启动

在/etc/rc.d/rc.local文件加入一行：

su - sybase -c "/opt/sybase/ASE-15_0/install/startserver -f /opt/sybase/ASE-15_0/install/RUN_liubai -f /opt/sybase/ASE-15_0/install/RUN_liubai_back &"

2、设置用户环境变量，修改/opte/sybase/.bashrc，加入以下三行：

LANG=C
export LANG
./sybase/SYBASE.sh

ifconfig

[root@localhost ~]# env|grep LANG
LANG=zh_CN.UTF-8
[root@localhost ~]#

不设置的话，可能报错：

[sybase@localhost bin]$ ./isql64 -Usa -PFfcsip_19*@nimda -Sliubai


The context allocation routine failed when it tried to load localization files!!
One or more following problems may caused the failure

Your sybase home directory is /home/sybase. Check the environment variable SYBASE if it is not the one you want!
Cannot access file /home/sybase/locales/locales.dat
An error occurred when attempting to allocate localization-related structures.

远程连接注意事项

（1）interface文件里的localhost要改成ip地址，才能通过client访问

改成以下这样：

[sybase@localhost sybase]$ pwd
/opt/sybase
[sybase@localhost sybase]$ cat interfaces

liubai
	master tcp ether 192.168.113.151 5000
	query tcp ether 192.168.113.151 5000


liubai_BS
	master tcp ether 192.168.113.151 5001
	query tcp ether 192.168.113.151 5001


LIUBAI_XP
	master tcp ether 192.168.113.151 5002
	query tcp ether 192.168.113.151 5002


[sybase@localhost sybase]$

不改的话，客户端会报错

eclipse.buildId=unknown
java.version=11.0.11
java.vendor=AdoptOpenJDK
BootLoader constants: OS=macosx, ARCH=x86_64, WS=cocoa, NL=zh_CN_#Hans
Framework arguments:  -keyring /Users/liubai/.eclipse_keyring
Command-line arguments:  -os macosx -ws cocoa -arch x86_64 -keyring /Users/liubai/.eclipse_keyring

org.jkiss.dbeaver.model
错误
Tue Mar 22 11:02:28 CST 2022
JZ006: Caught IOException: java.net.ConnectException: Connection refused (Connection refused)

（2）检查网络联通性，端口是否开发，或者防火墙状态

可参考以下2篇文章

【centos7】如何开发8080端口的防火墙_小慌慌的博客-CSDN博客_防火墙如何开放8080端口1、连接centos7服务器；2、我们可以输入命令查看防火墙的状态；firewall-cmd --state3、如果上一步处于关闭状态，输入命令：systemctl start firewalld.service4、开启8080端口，输入命令：firewall-cmd --zone=public --add-port=8080/tcp --permanent5、让我们来解释一下上一个命令：--zone=public：表示作用域为公共的-.https://blog.csdn.net/whowhowhoisimportant/article/details/121703308?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522164792432416780274156668%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fblog.%2522%257D&request_id=164792432416780274156668&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~blog~first_rank_ecpm_v1~rank_v31_ecpm-1-121703308.nonecase&utm_term=%E9%98%B2%E7%81%AB%E5%A2%99&spm=1018.2226.3001.4450

【Linux】Centos防火墙常用操作命令_小慌慌的博客-CSDN博客https://blog.csdn.net/whowhowhoisimportant/article/details/107905109?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522164792432416780274156668%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fblog.%2522%257D&request_id=164792432416780274156668&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~blog~first_rank_ecpm_v1~rank_v31_ecpm-2-107905109.nonecase&utm_term=%E9%98%B2%E7%81%AB%E5%A2%99&spm=1018.2226.3001.4450