Linux 查看数据库驱动 & pyodbc

vi /etc/odbcinst.ini

[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

[ODBC Driver 13 for SQL Server]
Description=Microsoft ODBC Driver 13 for SQL Server
Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.1.so.9.2
UsageCount=1

install pyodbc

1. Install Microsoft ODBC Driver for SQL Server on Linux (https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017)

- curl -k https://packages.microsoft.com/config/rhel/7/prod.repo > /tmp/mssql-release.repo    
- sudo cp /tmp/mssql-release.repo /etc/yum.repos.d/mssql-release.repo
- sudo yum -y remove unixODBC-utf16 unixODBC-utf16-devel
- sudo ACCEPT_EULA=Y yum -y install msodbcsql
- echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
- echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
- sudo yum -y install unixODBC-devel
2. Install pyodbc (https://github.com/mkleehammer/pyodbc/wiki/Install)

- sudo yum install epel-release
- sudo yum install gcc-c++ python-devel unixODBC-devel
- sudo python3.6 -m pip install pyodbc

3. Kerberos(使用trusted_connection认证)
 

- sudo yum install krb5-workstation krb5-libs krb5-auth-dialog
- create a crontab job to renew the tickets
    - setup credential-renew.sh

        ::

                #!/bin/bash

                echo `date`
                kinit <<EOF
                {password}

                EOF

    -  chmod +x credential-renew.sh
    -  setup credential-renew cron job
        -  crontab -e
            ::

                */4 * * * *  /home/{home_dir}/credential-renew.sh >> /home/{home_dir}/kinit.log

 

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值