Jump to content

How to: Install using existing MYSQL


Recommended Posts

Hi team,

 

I try to install using existing MYSQL but have a message about ODBC require. ODBC is installed already and I created the user DSN and system DSN for Olympus in the ODBC Manager but the message "ODBC require" appear again.

 

There is no information about this in the documentation. Nothing that explains the process of connecting to MYSQL and continuing with the installation of Olympus. How to do?

 

Regards

Link to comment

Hi team,

 

I try to install using existing MYSQL but have a message about ODBC require. ODBC is installed already and I created the user DSN and system DSN for Olympus in the ODBC Manager but the message "ODBC require" appear again.

 

There is no information about this in the documentation. Nothing that explains the process of connecting to MYSQL and continuing with the installation of Olympus. How to do?

 

Regards

 

The solution (today April, 04) is to install ODBC driver version 32 bit.  (driver for 64-bit DO NOT WORK)

 

post-13747-0-61658900-1554398034_thumb.jpg

 

This worked for me:

 

Once you have installed it, the Olympus installation will continue without problems

 

post-13747-0-82646500-1554398460_thumb.jpg

 

I hope it helps  :rolleyes:

Link to comment

I have another error with launch https://localhost:3000

 

post-13747-0-59609400-1554402493_thumb.jpg

 

Two errors are shown: one about the stopped service error and the other about an authentication error

 

But Core Services are running and username /password are correct.

 

I check service before and after login. It stopped after login and does not recognize the username and password that I have established (uninstall and install more than 6 times)

 

There is any log to see? Any suggestion?  :wacko:

Link to comment

Please try restarting the Network Olympus services.

 

If the problem persists, follow these steps:

1. Please send us all log files that you can find in the following folder (you can archive the whole folder):
C:\Program Files (x86)\Network Olympus\Bin\Logs
2. Let us know if the program is installed on a physical or virtual machine. Let us know the OS version.
3. Let us know the subnet mask that is used in the network where Network Olympus is installed.
4. Make sure to add the Network Olympus executable to the antivirus and firewall whitelist.

Link to comment

Please try restarting the Network Olympus services.

 

If the problem persists, follow these steps:

1. Please send us all log files that you can find in the following folder (you can archive the whole folder):

C:\Program Files (x86)\Network Olympus\Bin\Logs

2. Let us know if the program is installed on a physical or virtual machine. Let us know the OS version.

3. Let us know the subnet mask that is used in the network where Network Olympus is installed.

4. Make sure to add the Network Olympus executable to the antivirus and firewall whitelist.

 

Hi Alex:

 

I restarted service and again (lost the count)

 

Installed on a physical machine Win 10 PRO x64 build 17763, localhost subnet 255.255.255.0, antivirus and firewall down for a while  :ph34r:

 

LOGS (only with data):

 

- OlympusScanner.DcpModule

[2019-04-05 13:34:39.617830] [014816] [info] Operation timed out.
[2019-04-05 13:34:41.647825] [014816] [info] Operation timed out. 

- OlympusScanner.DcpModule.1

[2019-04-04 15:19:53.668804] [004816] [info] Networking config: SECURE=[YES] CERTIFICATES=[YES]
[2019-04-04 15:19:55.696465] [014816] [info] Operation timed out.

- OlympusGui.Server.js 

2019-04-04 15:21:04.385 - info: [Server.js] OLYMPUS server will be started in the production mode.
2019-04-04 15:21:04.415 - info: [Server.js] HHTPS server is running. Rest API - 3000.
2019-04-04 15:22:48.961 - error: [Server.js] SYSTEM ERROR Network Olympus storage does not ready!

- OlympusGui.WebServer.js

2019-04-04 15:22:48.960 - info: [WebServer.js] Incoming ajax query PATH=/api/isAuthorized
2019-04-04 15:22:49.203 - info: [WebServer.js] Incoming ajax query PATH=/api/licenseinformation

- OlympusCore

[2019-04-04 15:19:52.112755] [012932] [OdbcAdapter] [error] Unsupported type [CODBCFieldInfo::m_nSQLType=-1] of field [data].
[2019-04-04 15:19:52.114583] [012932] [OdbcAdapter] [error] Failed verification of the table [actioninstance].
[2019-04-04 15:20:21.871589] [015268] [SystemService] [critical] Can't connect to database

- OlympusCore.SystemService

[2019-04-04 15:20:21.871589] [015268] [critical] Can't connect to database

- OlympusCore.OdbcAdapter

[2019-04-04 15:19:52.112755] [012932] [error] Unsupported type [CODBCFieldInfo::m_nSQLType=-1] of field [data].
[2019-04-04 15:19:52.114583] [012932] [error] Failed verification of the table [actioninstance].

- OlympusCore.DcpModule

[2019-04-04 15:19:51.044922] [003764] [info] Networking config: SECURE=[YES] CERTIFICATES=[YES]

- OControl.DcpModule

[2019-04-04 15:19:54.315142] [013624] [info] Networking config: SECURE=[YES] CERTIFICATES=[YES]
[2019-04-04 15:19:56.342811] [011968] [info] Operation timed out.

- OlympusGui.DcpDataListener.js

2019-04-04 15:21:04.415 - info: [DcpDataListener.js] [DCP onDataListener] DCP onData HANDLER IS REGISTERED.

- OlympusGui.DcpDataSender.js

2019-04-04 15:21:04.415 - info: [DcpDataSender.js] [DCP Connect] SEND REQUEST TO OLYMPUS CORE. OPERATION=connect

- OlympusGui.SilCommunicationService

2019-04-04 15:21:04.415 - error: [SilCommunicationService] [CHECK UPLOAD PATH] Upload path does not exist and has been created. errno=-4058, code=ENOENT, syscall=stat, path=C:\Program Files (x86)\Network Olympus\uploads

- OlympusGui.SocketServer.js

2019-04-04 15:21:04.415 - info: [SocketServer.js] [webSocketServer] CREATE SECURE WEB SOCKET SERVER. WS_PORT=3000

- OlympusScanner.SystemService

[2019-04-04 15:19:53.351741] [008752] [info] Service has been installed
[2019-04-04 15:19:53.660127] [008752] [info] Service has been started
Link to comment
Hello.

 

Thanks for the information.

 

Which version of MySQL do you have? Let us know what it's used for, and if you've modified any settings from default. Can you reinstall the database from scratch?

 

If nothing helps, please consider reinstalling Network Olympus with Postgresql.

Link to comment

5.7.24 - MySQL[/size]
 


Hello.
 
Thanks for the information.
 
Which version of MySQL do you have? Let us know what it's used for, and if you've modified any settings from default. Can you reinstall the database from scratch?
 
If nothing helps, please consider reinstalling Network Olympus with Postgresql.

 
5.7.24 - MySQL
 
NOTE: olympus database was created correctly during the installation process and I can access it and explore its tables from database manager

Link to comment
  • 2 weeks later...
  • 4 weeks later...

Hi Richardmax,

 

The development team has confirmed this limitation for MySQL databases. The latest driver version is not yet supported.

 

This issue will be solved in one of the updates. Meanwhile we can only use the driver version 5.3.6 for MySQL or install the Postgresql database. We apologize for the inconvenience.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...