SatRDA文档

# Linux版本配置

随着国家的软件国产化政策，开源的Linux系统将逐渐成为主流。SatRDA支持跨平台，可以在Linux中运行，下面我们以Centos为例，看看SatRDA如何运行在Linux中。

# centos7配置上网

  1. 编辑 ect/sysconfig/network-scripts/ifcfg-net33 修改ONBOOT=yes
  2. 重启网络服务 service network restart
  3. 输入ip addr可以看到ip
  4. 通过yum install wget安装wget

# 运行并配置satserver

  1. 将satrda_for_linux.tgz放到目录，如/home
  2. 运行tar -zxvf satrda_for_linux.tgz解压
  3. 进入目录cd satrda_for_linux
  4. 执行程序 ./satserver
  5. 在浏览器输入 http://127.0.0.1:5555/admin (opens new window) 进行后台配置，具体可参考后台配置

# 安装配置unixODBC和mysql驱动

  1. yum install unixODBC mysql-connector-odbc 安装odbc和mysql驱动
  2. 配置odbc驱动
    vi /etc/odbcinst.ini 查看到驱动
# Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
[MySQL]
Description     = ODBC for MySQL
Driver          = /usr/lib/libmyodbc5.so
Setup           = /usr/lib/libodbcmyS.so
Driver64        = /usr/lib64/libmyodbc5.so
Setup64         = /usr/lib64/libodbcmyS.so
FileUsage       = 1

添加unicode驱动
[MySQLW]
Description     = ODBC for MySQL
Driver64        = /usr/lib64/libmyodbc5w.so
Setup64         = /usr/lib64/libodbcmyS.so
FileUsage       = 1

保存并退出 :wq
  1. 添加驱动 vi /etc/odbc.ini 输入
[mysql-test]
Driver = mysql
Description = MyODBC 5 Driver
SERVER = 192.168.145.134    #要连接的数据库信息
PORT = 3306
USER = root
Password =sql
Database = test
OPTION = 3
charset=UTF8
保存并退出 :wq
  1. 输入isql -v mysql-test root sql查看连接信息，连接正常显示
[root@localhost ~]# isql -v mysql-test root sql
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
  1. 配置后台管理mycon3 dsn为mysql-test

# 配置oracle驱动

  1. 从SatRDA QQ群:345559891 下载oracle驱动到/home/driver目录
  2. 运行命令
cd /home/driver
unzip instantclient-basic-linux.x64-12.2.0.1.0.zip
unzip instantclient-odbc-linux.x64-12.2.0.1.0-2
  1. cd instantclient_12_2
vi odbc_update_ini.sh
修改
if [ ! "$1" ]
then
   echo " *** Please pass ODBCDM_HOME as arg-1, and optional arguments -"
   echo " *** Install location (arg-2), Driver name (arg-3) & DSN (arg-4) & ODBCINI (arg-5)."
   echo " *** Usage:  odbc_update_ini.sh <ODBCDM_Home> [<Install_Location>] [<Driver_Name>] [<DSN>] [<ODBCINI>]"
   exit
else
   ODBCDM_HOME="$1"
为
if [ ! "$1" ]
then
   ODBCDM_HOME=""
else
   ODBCDM_HOME="$1"

修改   
# ODBCINI environment variable is the location of .odbc.ini,if not passed
#then default is $HOME/.odbc.ini
if [ ! "$5" ]
then
    echo " *** ODBCINI environment variable not set,defaulting it to HOME directory!"
    ODBCINI_PATH=$HOME/.odbc.ini
else
    ODBCINI_PATH="$5"
为
# ODBCINI environment variable is the location of .odbc.ini,if not passed
#then default is $HOME/.odbc.ini
if [ ! "$5" ]
then
    ODBCINI_PATH=/etc/odbc.ini
else
    ODBCINI_PATH="$5"

export LD_LIBRARY_PATH=/home/driver/instantclient_12_2:$LD_LIBRARY_PATH

← 常见问题 →