Install MsSQL Driver

[tuwaga]

Does anyone has success install driver for MsSQL in Kloxo-MR 7 ?



Thanks.

[MRatWork]

For MS SQL server, serve by Microsoft for CentOS 7 only.

[tuwaga]

Hi pak MR,

MS SQL already installed on seperated server under Centos 7.

Our plan was in Kloxo-MR 7 installed for application only but the driver for MS SQL cannot installed related request PHP 5.3 for Centos 6.8.

Here are php -v and sysinfo.

# php -v
PHP 5.4.45 (cli) (built: Sep  4 2015 15:40:18)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies
    with the ionCube PHP Loader (enabled) + Intrusion Protection from ioncube24.com (unconfigured) v5.0.18, Copyright (c) 2002-2015, by ionCube Ltd.
# sh /script/sysinfo
A. Control Panel:
   - Kloxo-MR: 7.0.0.b-2016120101
   - Web: hiawatha-10.4.0-f.1.mr.el6.x86_64
   - PHP: php54s-5.4.45-1.ius.el6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.8 (Final) x86_64
   - Hostname: XX-XXX-XX-XX
C. Services:
   1. MySQL: --uninstalled--
   2. PHP:
      - Installed:
        - Branch: --uninstalled--
        - Multiple:
          * php52m-5.2.17-102.mr.el6
          * php53m-5.3.29-1.ius.el6
          * php54m-5.4.45-1.ius.el6
          * php55m-5.5.32-1.ius.el6
          * php56m-5.6.18-1.ius.el6
          * php70m-Could not get metalink https://mirrors.fedoraproject.org/metalink?repo=epel-6&arch=x86_64 error was14: PYCURL ERROR 6 - "Couldn't resolve host 'mirrors.fedoraproject.org'"7.0.3-1.w6
      - Used: --PHP Branch--
      - Multiple: enable
   3. Web Used: apache
     - Hiawatha: hiawatha-10.4.0-f.1.mr.el6.x86_64
     - Lighttpd: --uninstalled--
     - Nginx: nginx-1.11.6-1.el6.ngx.x86_64
     - Apache: --uninstalled--
       - PHP Type: php-fpm_event
       - Secondary PHP: on
   4. WebCache: none
     - ATS: --uninstalled--
     - Squid: --uninstalled--
     - Varnish: --uninstalled--
   5. Dns: nsd
     - Bind: --uninstalled--
     - DJBDns: --uninstalled--
     - NSD: nsd-4.1.13-1.el6.x86_64
     - PowerDNS: --uninstalled--
     - Yadifa: --uninstalled--
   6. Mail: qmail-toaster-1.03-1.3.55.mr.el6.x86_64
      - pop3/imap4: courier-imap-toaster-4.1.2-1.3.20.mr.el6.x86_64
      - smtp: qmail-toaster-1.03-1.3.55.mr.el6.x86_64
      - spam: bogofilter-1.2.4-1.el6.x86_64
   7. Stats: awstats
D. Memory:
                total       used       free     shared    buffers     cached
   Mem:          3832       3523        309         33        202       2163
   -/+ buffers/cache:       1157       2675
   Swap:         3967          1       3966

Thanks.

[MRatWork]

1. For 'multiple php', enable 'mssql' in 'php module status' for certain/all php version. And then click 'restart'
2. For 'php branch', run 'yum install php54-mssql -y; sh /script/restart-web'.

[tuwaga]

Hi pak MR,

Right now we able to activated mssql driver in PHP 5.6 but how to change freetds version from 4.2 into version 8.0 in Kloxo-MR 7.0.0.b-2016121602

]# /etc/freetds.conf
-bash: /etc/freetds.conf: Permission denied
# cat /etc/freetds.conf
#   $Id: freetds.conf,v 1.12 2007/12/25 06:02:36 jklowden Exp $
#
# This file is installed by FreeTDS if no file by the same
# name is found in the installation directory.
#
# For information about the layout of this file and its settings,
# see the freetds.conf manpage "man freetds.conf".

# Global settings are overridden by those in a database
# server specific section
[global]
        # TDS protocol version
;       tds version = 4.2

        # Whether to write a TDSDUMP file for diagnostic purposes
        # (setting this to /tmp is insecure on a multi-user system)
;       dump file = /tmp/freetds.log
;       debug flags = 0xffff

        # Command and connection timeouts
;       timeout = 10
;       connect timeout = 10

        # If you get out-of-memory errors, it may mean that your client
        # is trying to allocate a huge buffer for a TEXT field.
        # Try setting 'text size' to a more reasonable limit
        text size = 64512
        host = xx.xx.xx.xx
        port = 1433
        tds version = 8.0
        client charset = UTF-8
# A typical Sybase server
[egServer50]
        host = symachine.domain.com
        port = 5000
        tds version = 5.0

# A typical Microsoft server
[egServer70]
        host = xx.xx.xx.xx
        port = 1433
        tds version = 8.0 <----
        client charset = UTF-8
        text size = 20971520
# tsql -C
Compile-time settings (established with the "configure" script)
                            Version: freetds v0.91
             freetds.conf directory: /etc
     MS db-lib source compatibility: yes
        Sybase binary compatibility: yes
                      Thread safety: yes
                      iconv library: yes
                        TDS version: 4.2 <----
                              iODBC: no
                           unixodbc: yes
              SSPI "trusted" logins: no
                           Kerberos: yes

Thanks.