mclusky 0 Posted May 7, 2015 Share Posted May 7, 2015 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 ? Link to comment Share on other sites More sharing options...
Former ESET Employees Timos 8 Posted May 7, 2015 Former ESET Employees Share Posted May 7, 2015 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 Link to comment Share on other sites More sharing options...
Former ESET Employees Timos 8 Posted May 7, 2015 Former ESET Employees Share Posted May 7, 2015 Try to use --db-type="MS SQL Server" because default is MySQL Link to comment Share on other sites More sharing options...
Recommended Posts