I work in a MS Sql shop. I need to get MantisBT working against MS SQL Server running some flavor of Windows server from a Dockerized CentOS nginx / php-fpm installation. I'm uncertain what I'm missing. Here's where things are at:
Here's output from the MantisBT /admin/install.php . Notice "mssqlnative extension not installed".
Check and Install Database
Checking Installation
mssqlnative extension not installed
Setting Database Type GOOD
Checking PHP support for database type BAD
database is not supported by PHP. Check that it has been compiled into your server.
Checking ADOdb Library version is at least 5.20.2 GOOD
Setting Database Hostname GOOD
Setting Database Username GOOD
Setting Database Password GOOD
Setting Database Name GOOD
Setting Admin Username POSSIBLE PROBLEM
admin user name is blank, using database user instead
Setting Admin Password POSSIBLE PROBLEM
admin user password is blank, using database user password instead
Attempting to connect to database as admin
Some relevant stuff from phpinfo
Additional .ini files parsed /etc/php.d/10-opcache.ini, /etc/php.d/20-bcmath.ini, /etc/php.d/20-bz2.ini, /etc/php.d/20-calendar.ini, /etc/php.d/20-ctype.ini, /etc/php.d/20-curl.ini, /etc/php.d/20-dom.ini, /etc/php.d/20-exif.ini, /etc/php.d/20-fileinfo.ini, /etc/php.d/20-ftp.ini, /etc/php.d/20-gd.ini, /etc/php.d/20-gettext.ini, /etc/php.d/20-iconv.ini, /etc/php.d/20-intl.ini, /etc/php.d/20-mbstring.ini, /etc/php.d/20-mcrypt.ini, /etc/php.d/20-mssql.ini, /etc/php.d/20-mysqlnd.ini, /etc/php.d/20-pdo.ini, /etc/php.d/20-phar.ini, /etc/php.d/20-posix.ini, /etc/php.d/20-shmop.ini, /etc/php.d/20-simplexml.ini, /etc/php.d/20-sockets.ini, /etc/php.d/20-sqlite3.ini, /etc/php.d/20-sybase_ct.ini, /etc/php.d/20-sysvmsg.ini, /etc/php.d/20-sysvsem.ini, /etc/php.d/20-sysvshm.ini, /etc/php.d/20-tokenizer.ini, /etc/php.d/20-xml.ini, /etc/php.d/20-xmlwriter.ini, /etc/php.d/20-xsl.ini, /etc/php.d/30-mysql.ini, /etc/php.d/30-mysqli.ini, /etc/php.d/30-pdo_dblib.ini, /etc/php.d/30-pdo_mysql.ini, /etc/php.d/30-pdo_sqlite.ini, /etc/php.d/30-wddx.ini, /etc/php.d/30-xmlreader.ini, /etc/php.d/40-json.ini, /etc/php.d/40-zip.ini
mssql
MSSQL Support enabled
Active Persistent Links 0
Active Links 0
Library version FreeTDS
Directive Local Value Master Value
mssql.allow_persistent On On
mssql.batchsize 0 0
mssql.charset no value no value
mssql.compatability_mode Off Off
mssql.compatibility_mode Off Off
mssql.connect_timeout 5 5
mssql.datetimeconvert On On
mssql.max_links Unlimited Unlimited
mssql.max_persistent Unlimited Unlimited
mssql.max_procs Unlimited Unlimited
mssql.min_error_severity 10 10
mssql.min_message_severity 10 10
mssql.secure_connection Off Off
mssql.textlimit Server default Server default
mssql.textsize Server default Server default
mssql.timeout 60 60
I know I'm missing something stupidly obvious. I'm just too fried to see it at this point.
Help!
centos 7, nginx, php-fpm, mantis, sqlserver
Moderators: Developer, Contributor
Re: centos 7, nginx, php-fpm, mantis, sqlserver
In short, apparently the sqlserver drivers as installed are somehow inappropriate. The following cleared up my situation in my instance.
Now on to the NEXT problem...
Code: Select all
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo
ACCEPT_EULA=Y yum install -y msodbcsql17
ACCEPT_EULA=Y yum install -y mssql-tools
yum install -y unixODBC-devel
Re: centos 7, nginx, php-fpm, mantis, sqlserver
As expected, next stupid hurdle...
Checking Installation
Setting Database Type GOOD
Checking PHP support for database type GOOD
Checking ADOdb Library version is at least 5.20.2 GOOD
Setting Database Hostname GOOD
Setting Database Username GOOD
Setting Database Password GOOD
Setting Database Name GOOD
Setting Admin Username GOOD
Setting Admin Password GOOD
Attempting to connect to database as admin BAD
Does administrative user have access to the database? ( Connection refused )
The short answer to the last line there is YES. For simplicity, the user was given full rights. From the docker instance running MantisBT, I was able to connect to the sql box using sqlcmd, attach to the db, and create a simple 1 column table.
Thoughts?
Checking Installation
Setting Database Type GOOD
Checking PHP support for database type GOOD
Checking ADOdb Library version is at least 5.20.2 GOOD
Setting Database Hostname GOOD
Setting Database Username GOOD
Setting Database Password GOOD
Setting Database Name GOOD
Setting Admin Username GOOD
Setting Admin Password GOOD
Attempting to connect to database as admin BAD
Does administrative user have access to the database? ( Connection refused )
The short answer to the last line there is YES. For simplicity, the user was given full rights. From the docker instance running MantisBT, I was able to connect to the sql box using sqlcmd, attach to the db, and create a simple 1 column table.
Thoughts?
Re: centos 7, nginx, php-fpm, mantis, sqlserver
In trying to figure out what's going on, I checked on the box to print sql statements instead of executing them. I get the same result - and I don't get the sql statements.
Re: centos 7, nginx, php-fpm, mantis, sqlserver
OK. This is incredibly lame, but there was someone making conflicting changes to an internal dependent Docker image that was breaking / conflicting with my Mantis stuff.
All is working as expected - at least in this regard...
All is working as expected - at least in this regard...