Jump to content

Error: Admin connection not working. Unable to continue

chetankb1
 Share

Recommended Posts

chetankb1

chetankb1 2

Posted
Posted

Dear All,

 

I am trying to install ERA Server 6.3 on SUSE Linux Enterprise Server 11 SP4(64 bit).

 

I have installed MySQL and MySQL ODBC and its running.

 

While installing ERA Server, I am getting an error ::

Checking database connection . . . failure

Error: Admin connection not working. Unable to continue.

 

I am not able to locate libmyodbc.so & libodbcmyS.so files anywhere in the system to make below changes in odbcinst.ini

 

[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
FileUsage = 1

 

Please let me know what I am supposed do further.

 

Please find the attached ERA Server Installation Logs.

Link to comment
Share on other sites
  • ESET Staff
MartinK

MartinK 383

Posted
  • ESET Staff
Posted

There is strange error in installation log:

[unixODBC][MySQL][ODBC 5.1 Driver]Host 'Eset.suse' is not allowed to connect to this MySQL server

which indicates, that there are some permissions issues.

 

I guess root user you provided to installation script is not configured to be connecting from current host. See MySQL server management.

Link to comment
Share on other sites
chetankb1

chetankb1 2

Posted
  • Author
Posted

Hi all,

 

Now I am getting different error with the same installation;

 

-cert-hostname=192.168.1.236;sles114.suse' is not a package name or capability.

Link to comment
Share on other sites
  • ESET Staff
MartinK

MartinK 383

Posted
  • ESET Staff
Posted

Hi all,

 

Now I am getting different error with the same installation;

 

-cert-hostname=192.168.1.236;sles114.suse' is not a package name or capability.

 

Never seen such error - maybe only installation command line is malformed or containing special characters without escaping that could break installation script? Please check proper characters are used in command line, for example double dash "--" may have been accidentally replaced with one long dash "—" (this happens especially when copying from HTML documents) and that could cause errors like this.

 

There may be more information in installer log: /var/log/eset/RemoteAdministrator/EraServerInstaller.log. You may also try to execute installer script with tracing, i.e. "sh -x <commands>"

Link to comment
Share on other sites
chetankb1

chetankb1 2

Posted
  • Author
Posted

I think I have entered commands correctly!. I tried below commands;

 

sles114:~ # sudo zypper install /root/downloads/Server-Linux-x86_64.sh \
> --skip-license \
> --db-driver=MySQL \
> --db-hostname=192.168.1.236 \
> --db-port=3306 \
> --db-admin-username=root \
> --db-admin-password=Sakri@123 \
> --server-root-password=Sakri@123 \
> --db-user-username=root \
> --db-user-password=Sakri@123 \
> --cert-hostname="192.168.1.236;sles114.suse"
Loading repository data...
Reading installed packages...
'-cert-hostname=192.168.1.236;sles114.suse' is not a package name or capability.
sles114:~ #
 
EraServerInstaller.log logs not generated.
Link to comment
Share on other sites
  • ESET Staff
MartinK

MartinK 383

Posted
  • ESET Staff
Posted (edited)

 

I think I have entered commands correctly!. I tried below commands;

 

sles114:~ # sudo zypper install /root/downloads/Server-Linux-x86_64.sh \
> --skip-license \
> --db-driver=MySQL \
> --db-hostname=192.168.1.236 \
> --db-port=3306 \
> --db-admin-username=root \
> --db-admin-password=Sakri@123 \
> --server-root-password=Sakri@123 \
> --db-user-username=root \
> --db-user-password=Sakri@123 \
> --cert-hostname="192.168.1.236;sles114.suse"
Loading repository data...
Reading installed packages...
'-cert-hostname=192.168.1.236;sles114.suse' is not a package name or capability.
sles114:~ #
 
EraServerInstaller.log logs not generated.

 

 

Try to start your command with sudo /root/downloads/Server-Linux-x86_64.sh instead of sudo zypper install /root/downloads/Server-Linux-x86_64.sh. You were actually not starting ERA installer, but rather program called zypper with parameters unknown for it.

 

EDIT: previous command also expects that download ERA installer is marked as executable, which can be set using command: sudo chmod +x /root/downloads/Server-Linux-x86_64.sh

Edited by MartinK
Link to comment
Share on other sites
chetankb1

chetankb1 2

Posted
  • Author
Posted (edited)

EraServerInstaller.logThis time new error...
 
sles114:~ # sudo '/root/Downloads/Server-Linux-x86_64.sh' --skip-license --db-driver=MySQL --db-hostname=192.168.1.236 --db-port=3306 --db-admin-username=root --db-admin-password=**********--server-root-password=********** --db-user-username=root --db-user-password=**********--cert-hostname="192.168.1.236;sles114.suse"

ESET Remote Administrator Server Installer (version: 6.3.148.0), Copyright © 1992-2016 ESET, spol. s r.o. - All rights reserved.

Extracting archive, please wait...
Archive extracted to /tmp/tmp.Aoqanv3Ymv.
Checking OpenSSL ... done [OpenSSL 0.9.8j-fips 07 Jan 2009]
Reading previous installation settings ... failure
Checking installed version... done
Status of current installation is: NEW
Checking database connection ... failure

Error: An error occurred while trying to connect to the database. Error code: (1130). Unable to continue.
sles114:~ #

Edited by chetankb1
Link to comment
Share on other sites
chetankb1

chetankb1 2

Posted
  • Author
Posted (edited) 
Hi,After executing below command, I got new error message.mysql -u root -p -h localhost -P 3306>use mysql>GRANT ALL ON *.* to root@'%' IDENTIFIED BY 'pass';>FLUSH PRIVILEGES;Here is the output of the installation;ESET Remote Administrator Server Installer (version: 6.3.148.0), Copyright � 1992-2016 ESET, spol. s r.o. - All rights reserved.Extracting archive, please wait...Archive extracted to /tmp/tmp.6m9r8DJDLd.Checking OpenSSL ... done [OpenSSL 0.9.8j-fips 07 Jan 2009]Reading previous installation settings ... failureChecking installed version... doneStatus of current installation is: NEWChecking database connection ... failureError: (Error 65534) ODBC connector compatibility check failed (error 65534). Database connector with 64bit wide SQLLEN/SQLULEN types is needed. Please check the prerequisites section for Linux installation in the documentation.sles114:~ #

Please help..

Edited by chetankb1
Link to comment
Share on other sites
  • ESET Staff
MartinK

MartinK 383

Posted
  • ESET Staff
Posted (edited) 
Error: (Error 65534) ODBC connector compatibility check failed (error 65534). Database connector with 64bit wide SQLLEN/SQLULEN types is needed. Please check the prerequisites section for Linux installation in the documentation.sles114:~ #

 

Unfortunately you have chosen most problematic linux distribution for ERA deployment.

 

This error means that your MySQL driver is not compatible with unixODBC package you have currently installed. What is exact package name of unixODBC and MySQL driver you installed? If I recall correctly, SuSe has two distinct unixODBC packages, and one of them named unixODBC_23 -> which I guess is the correct one, but it may depend on source of your MySQL driver.

 

Just found this hidden in ERA documentation:

NOTE: You should use unixODBC_23 package (not the default unixODBC) in order for the ERA Server to connect to the MySQL database without any issues. This is especially true for SUSE Linux
Edited by MartinK
Link to comment
Share on other sites
chetankb1

chetankb1 2

Posted
  • Author
Posted

Hi,

 

1) I have done installation of mysql-community-server & unixODBC from "Install/Remove Software".

 

MySQL Version : 5.5.43-0.7.3

unixODBC: 2.3.1-0.9.40

 

2) After installation of unixODBC driver, I only found "libodbcmyS.so" on this location /usr/lib64/unixODBC/ (not libmyodbc).

3) Then I have installed mysql-connector-odbc-5.2.7-1.sles11.x86_64.rpm & found libmyodbc5a.so & libmyodbc5w.so under /usr/lib64/

4) Then I made changes in odbcinst.ini accordingly.

______________________________________________________________________________________________

 

 

Also find the output for below commands;

sles114:~ # odbcinst -q -d

[MySQL ODBC 5.2 Unicode Driver]

[MySQL ODBC 5.2 ANSI Driver]

[MySQL]

sles114:~ # odbcinst -j

unixODBC 2.2.12

DRIVERS............: /etc/unixODBC/odbcinst.ini

SYSTEM DATA SOURCES: /etc/unixODBC/odbc.ini

USER DATA SOURCES..: /root/.odbc.ini

sles114:~ # odbcinst -j | grep '^DRIVERS' | awk '{print $2}' | xargs cat

[MySQL ODBC 5.2 Unicode Driver]

Driver          = /usr/lib64/libmyodbc5w.so

UsageCount              = 1

[MySQL ODBC 5.2 ANSI Driver]

Driver          = /usr/lib64/libmyodbc5a.so

UsageCount              = 1

[MySQL]

Description = ODBC for MySQL

Driver = /usr/lib64/libmyodbc5a.so

Setup = /usr/lib64/unixODBC/libodbcmyS.so

FileUsage = 1

sles114:~ #

Link to comment
Share on other sites
  • 3 weeks later...
chetankb1

chetankb1 2

Posted
  • Author
Posted
Hello,

 

I have changed the password for MySQL database password(it was containing special character) & installed ODBC driver(mysql-connector-odbc-5.3.4-1.el6.x86_64.rpm). Now it has been installed successfully.

 

Then I have installed JAVA & Tomcat(version 6), installed from install/remove software.

 

After Tomcat installation (/var/lib/tomcat/webapps/) this folder is not generated. Not I don't know where I supposed to copy era.war.

 

Please help for further configuration. 

Link to comment
Share on other sites
  • ESET Staff
MartinK

MartinK 383

Posted
  • ESET Staff
Posted

After Tomcat installation (/var/lib/tomcat/webapps/) this folder is not generated. Not I don't know where I supposed to copy era.war.

 

Location of webapps directory varies from distribution to distribution and version to version... I guess it will be /usr/share/tomcat6/webapps in "SUSE Linux Enterprise Server 11".

Link to comment
Share on other sites
chetankb1

chetankb1 2

Posted
  • Author
Posted

Hi all,

 

My ESET Remote Administrator is installed successfully and working.

 

I am able to login web console from local(same) system only, but how can I configure it to access web console from other LAN system as well.

Link to comment
Share on other sites
  • ESET Staff
MartinK

MartinK 383

Posted
  • ESET Staff
Posted

Hi all,

 

My ESET Remote Administrator is installed successfully and working.

 

I am able to login web console from local(same) system only, but how can I configure it to access web console from other LAN system as well.

 

Maybe it is only firewall blocking access to port you are using? Apache Tomcat should be by default configured to listen on all interfaces (in case you installed it by ERA all-in-one installer).

Link to comment
Share on other sites
chetankb1

chetankb1 2

Posted
  • Author
Posted (edited)

Thank you,

 

I will check the firewall rules.

 

This installation is on SUSE Linux Enterprise Server, I think I need to configure Apache Tomcat manually. 

Edited by chetankb1
Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...