ajitdixit, Member
This is copied from output of phpinfo
This program makes use of the Zend Scripting Language Engine:
Zend Engine v3.0.0, Copyright (c) 1998-2016 Zend Technologies
with the ionCube PHP Loader (enabled) + Intrusion Protection from ioncube24.com (unconfigured) v6.0.5, Copyright (c) 2002-2016, by ionCube Ltd.
PHP Version : PHP Version 7.0.11
php.ini
zend_extension = "/usr/local/lib/php/extensions/ioncube_loader_lin_7.0_ts.so"
Mydbr do not recognize ioncube
Pl help
myDBR Team, Key Master
Make sure you have the correct version of ionCube loader selected (thread safe / non-thread safe). Comment out the zend_extension from php.ini and use the ionCube loader install Wizard.
What is th error you are getting from myDBR? As for PHP 7, make sure you are using the PHP 7 compatible version of myDBR.
--
myDBR Team
ajitdixit, Member
ionCube Loader Wizard
Loader Installed
The ionCube Loader version 6.0.5 for PHP 7.0 is already installed and encoded files should run without problems.
The Loader wizard is showing OK
But still Mydbr is not recognizing
Do we have to checkl specific extension for this to work ?
myDBR Team, Key Master
Before running the Loader Wizard, comment out the current one and restart your web server. This will allow the Loader Wizard to recommend the correct loader version for you.
When loader is not recognized, no myDBR code is run, so most likely you just have incorrect version of the loader installed (thread safe vs non-thread safe).
You are using the Thread Safe version of the ionCube loader (ioncube_loader_lin_7.0_ts.so), just check that the loader page in myDBR shows excactly this instead of the more common non-thread safe in Linux (ioncube_loader_lin_7.0.so).
--
myDBR Team
ajitdixit, Member
Mydbr is suggesting for following loader version
ioncube_loader_lin_7.0.so
Actually with help of ionCube following is installed
ioncube_loader_lin_7.0_ts.so
The loader page in MyDBR is not showing correct version
myDBR Team, Key Master
with help of ionCube following is installed
a) What does "help of ionCube" mean?
b) What does your phpinfo()'s Thread Safety section show?
--
myDBR Team
ajitdixit, Member
Output of phpInfo()
Thread Safety enabled
ajitdixit, Member
I have tried to install mydbr with Mysql on the same server. It works
The problem is I have compiled php 7 with following flag
--with-pdo-dblib=/usr/local/freetds
there is no mssql flag which was earlier in php 5
Mydbr does not understand the php mssql support
I do not knoe what connection parameters should I pass ?
Regards ,
Ajit
myDBR Team, Key Master
a) What does "help of ionCube" mean?
--
myDBR Team
ajitdixit, Member
Help of ioncube means using ionCube loader install Wizard.
myDBR Team, Key Master
So you got the myDBR working in the server? The problem was not in the ionCube loader?
The mssql-extension was dropped from PHP 7 core.
Microsoft is working on the sqlsrv driver for Linux with Early Technical Preview available for selected Linux distributions in GitHub.
The thread safety detection issue in loader error page has been corrected in the latest build.
--
myDBR Team
ajitdixit, Member
Can you please suggest how can I work with freeTDS with MyDBR
I was able to work in PHP-5.6
I am able to work with Zend_db as I was working earlier with PHP 5
myDBR Team, Key Master
MS SQL Server with FreeTDS is supported by PHP up to PHP 5.6. As said, PHP developers decided to drop the support for mssql extension (=including FreeTDS) from PHP core.
The future (PHP>=7.0) with MS SQL Server with PHP is with sqlsrv-driver. myDBR does support the sqlsrv-driver.
--
myDBR Team
ajitdixit, Member
Do you have any link how to compile sqlsrv and pdo-sqlsrv with php 7
My all applications based on Zend_db are working very fine with my source compilation of freetds
Then where is withdrawal of support ?
I am working with Zend_db with following connection string ;
$mssqlconfig = new Zend_Config(
array(
'database' => array(
'adapter' => 'PDO_MSSQL',
'params' => array(
'pdoType' => 'dblib',
'host' => 'MIRRORSERVER' ,
'dbname' => 'LIMS_LIVE' ,
'username' => 'XXXXXX',
'password' => 'XXXXXXXXXXXX',
)
)
)
);
$zmssqldb = Zend_Db::factory($mssqlconfig->database);
$zmssqldb->setFetchMode(Zend_Db::FETCH_ASSOC);
Can pdo_dblib based connection which is same as mssql be allowed by MyDBR ?
myDBR Team, Key Master
Then where is withdrawal of support ?
Can you rephrase the question?
The precompiled sqlsrv drivers can be found at the GitHub link provided above (cannot provide support for your own application). Please note that the drivers are still considered as Early Technical Preview.
--
myDBR Team
ajitdixit, Member
I was able to configure MyDBR with sqlsrv on PHP 7 on RHEL 7.2
Thanks
You must log in to post.