Jump to content

Archived

This topic is now archived and is closed to further replies.

mclusky

Remote MSSQL database connection failure installing ERA Server 6 on linux

Recommended Posts

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 ?

Share this post


Link to post
Share on other sites

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/
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
 
 
 

Share this post


Link to post
Share on other sites

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

because default is MySQL

Share this post


Link to post
Share on other sites

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...