Welcome to Centmin Mod Community
Register Now

Beta Branch Add MSSQL PHP driver support via PHPMSSQL variable 123.09beta01

Discussion in 'Centmin Mod Github Commits' started by eva2000, Jul 1, 2016.

  1. eva2000

    eva2000 Administrator Staff Member

    29,051
    6,593
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,789
    Local Time:
    1:13 PM
    Nginx 1.13.x
    MariaDB 5.5
    Add MSSQL PHP driver support via PHPMSSQL variable 123.09beta01

    Discussed at Question about mssql or odbc or pdo drivers. | Centmin Mod Community Added MS SQL server driver support via PDO_ODBC driver for unixODBC PHP: ODBC and DB2 (PDO) - Manual as per recommendations at PHP: MS SQL Server (PDO) - Manual To enable MSSQL PHP driver support via PDO_ODBC, create or append to your persistent config file /etc/centminmod/custom_config.inc the variable below:

    Code (Text):
    PHPMSSQL='y'
    


    Then run centmin.sh menu option 5 and recompile your PHP version specified i.e. 5.6.23.

    Continue reading...

    123.09beta01 branch
     
  2. eva2000

    eva2000 Administrator Staff Member

    29,051
    6,593
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,789
    Local Time:
    1:13 PM
    Nginx 1.13.x
    MariaDB 5.5
    After PHP recompile, you can confirm if PDO_ODBC driver was enabled via command
    Code (Text):
    php --ri pdo
    

    output
    Code (Text):
    php --ri pdo
    
    PDO
    
    PDO support => enabled
    PDO drivers => mysql, odbc, sqlite
    

    list the modules loaded by php and find PDO_ODBC
    Code (Text):
    php -m
    [PHP Modules]
    bcmath
    bz2
    calendar
    Core
    ctype
    curl
    date
    dom
    enchant
    ereg
    exif
    filter
    ftp
    gd
    geoip
    gettext
    gmp
    hash
    iconv
    igbinary
    imagick
    imap
    intl
    json
    libxml
    mailparse
    mbstring
    mcrypt
    memcache
    memcached
    mhash
    mysql
    mysqli
    mysqlnd
    openssl
    pcntl
    pcre
    PDO
    pdo_mysql
    PDO_ODBC
    pdo_sqlite
    Phar
    posix
    pspell
    readline
    redis
    Reflection
    session
    shmop
    SimpleXML
    snmp
    soap
    sockets
    SPL
    sqlite3
    standard
    sysvmsg
    sysvsem
    sysvshm
    tidy
    tokenizer
    xml
    xmlreader
    xmlrpc
    xmlwriter
    xsl
    Zend OPcache
    zip
    zlib
    
    [Zend Modules]
    Zend OPcache

    specifics
    Code (Text):
    php --ri PDO_ODBC
    
    PDO_ODBC
    
    PDO Driver for ODBC (unixODBC) => enabled
    ODBC Connection Pooling => Enabled, strict matching
     
    Last edited: Jul 1, 2016