Jump to content


Photo

How to: Install using existing MYSQL


  • Please log in to reply
9 replies to this topic

#1 Richardmax

Richardmax

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 03 April 2019 - 02:07 PM

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



#2 Alex

Alex

    Support

  • Administrators
  • PipPipPip
  • 195 posts
  • Gender:Male

Posted 04 April 2019 - 01:57 AM

Hi Richardmax,

 

Please try reinstalling the ODBC driver. You can download it here:

https://www.microsof...s.aspx?id=36434

 

Try installing the x86 version of the driver.

This may solve the problem.



#3 Richardmax

Richardmax

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 04 April 2019 - 08:32 AM

Hi Richardmax,

 

Please try reinstalling the ODBC driver. You can download it here:

https://www.microsof...s.aspx?id=36434

 

Try installing the x86 version of the driver.

This may solve the problem.

Hi Alex, 

 

I get it now. Show solution as another replay

 

Thank you very much



#4 Richardmax

Richardmax

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 04 April 2019 - 09:23 AM

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)

 

olympus-odbc fail.jpg

 

This worked for me:
 

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

 

olympus-odbc-ok.jpg

 

I hope it helps  :rolleyes:



#5 Richardmax

Richardmax

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 04 April 2019 - 10:38 AM

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

 

olympus-gui-error-starting.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:



#6 Alex

Alex

    Support

  • Administrators
  • PipPipPip
  • 195 posts
  • Gender:Male

Posted 05 April 2019 - 12:03 AM

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.



#7 Richardmax

Richardmax

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 05 April 2019 - 08:46 AM

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


#8 Armo

Armo

    Support

  • Administrators
  • PipPipPip
  • 85 posts
  • Gender:Male

Posted 08 April 2019 - 02:06 AM

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.


#9 Richardmax

Richardmax

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 08 April 2019 - 06:05 AM

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



#10 Richardmax

Richardmax

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 18 April 2019 - 05:39 AM

News?  :unsure:






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users