Remote MSSQL database connection failure installing ERA Server 6 on linux

[mclusky 0]

I successfully deployed 3 other ERA 6 Servers on linux with MySQL local database engine.

Now I need to install Era Server 6 on 32b Linux Ubuntu 12.04 Server with database located on 64b Windows Server 2008 R2 SQL 2012.

I configured ODBC under Linux and I successfully obtain connection to MS SQL Server with isql or sqsh command (with the same credentials as passed to ERA installer script).

But running ERA 6 Server installation fails on 'Checking database connection ... failure'.

Log file EraServerInstaller.log contains:

2015-05-07 11:18:42 Information: DbCheckConnection: Set output property: P_DB_ADMIN_CONNECTION_STATUS = 65535
2015-05-07 11:18:42 Information: ERROR: DatabaseException with error code '65535' and message - [unixODBC][FreeTDS][SQL Server]Login failed for user ''.
2015-05-07 11:18:42 Information: DbCheckConnection: Return code: 0
2015-05-07 11:18:42 Information: Installer: Admin connection check failed. Unable to continue.
2015-05-07 11:18:42 Information: Installer: Error: Admin connection not working. Unable to continue.

I installed all (I hope) additional packages: unixodbc unixodbc-dev freetds-dev sqsh tdsodbc

 

My DB related installer options are:

--db-driver=FreeTDS --db-hostname=192.168.18.5 --db-port=1433 --db-admin-username=sa --db-admin-password=<my pass>

 

My configuration files:

/etc/freetds/freetds.conf:

[server]
  host = 192.168.18.5
  port = 1433
  tds version = 7.0 

/etc/odbcinst.ini:

[FreeTDS]
Description = ODBC for MS SQL
Driver = /usr/lib/i386-linux-gnu/odbc/libtdsodbc.so
Setup = /usr/lib/i386-linux-gnu/odbc/libtdsS.so
FileUsage = 1

/etc/odbc.ini:

[server]
Driver = FreeTDS
Description = ODBC connection via FreeTDS
Trace = No
Servername = server

I hope there is someone who successfully deployed ERA Server with external database. Is it possible I should use different value for '--db-driver=' option ?

[Timos 8]

The only supported ODBC driver for linux is this 64bit https://www.microsoft.com/en-us/download/details.aspx?id=28160

ERA Server may work with other drivers, but I never tried it, so I cannot help you.

 

Here are my old notes from installation on Ubuntu x64, hope it helps.

 

Ubuntu:

 

cd /tmp/

wget hxxp://download.microsoft.com/download/6/A/B/6AB27E13-46AE-4CE9-AFFD-406367CADC1D/Linux6/sqlncli-11.0.1790.0.tar.gz

tar xvf sqlncli-11.0.1790.0.tar.gz

 

sudo apt-get update

sudo apt-get install unixodbc

sudo apt-get install libssl-dev libssl1.0.0 libssl1.0.0-dbg

 

Ubuntu:

sudo ln -s /lib/x86_64-linux-gnu/libssl.so.1.0.0 /usr/lib/libssl.so.10

sudo ln -s /lib/x86_64-linux-gnu/libcrypto.so.1.0.0 /usr/lib/libcrypto.so.10

Debian:

sudo ln -s /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0 /usr/lib/libssl.so.10

sudo ln -s /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0 /usr/lib/libcrypto.so.10

 

ldd sqlncli-11.0.1790.0/lib64/libsqlncli-11.0.so.1790.0

sudo ldconfig /usr/local/lib

 

cd sqlncli-11.0.1790.0/

sudo bash ./install.sh install --accept-license --force

 

Driver name can be found at /etc/odbcinst.ini

 

 

 

[Timos 8]

Try to use --db-type="MS SQL Server"

because default is MySQL