Integrate existed DB(MySql)

Integrate existed DB(MySql)

  

Hi guys!

I have successfully installed MySQL on my machine .

Outsystems 10(personal enviroment)

MySql 5.6.3.4.

mysql-connector-net-6.9.9

I try to create [database connection] in service center. 

-----------------------------------------------

[Basic Configuration]

Server      127.0.0.1

Schema    mysql

Username  root 

Password   mypassword

--------------------------------------------------

but it prompted me an error: Unable to connect to any of the specified MySQL hosts.

eSpace:
ServiceCenter
Tenant:
ServiceCenter
User:
Session Id:
Server:
S1OAB-LT2DFL
Module:
Service Center
Message:
Unable to connect to any of the specified MySQL hosts.
Environment InformationeSpaceVer: 0 (Id=1, PubId=1, CompiledWith=10.0.200.2)
RequestUrl:  (Method: )
AppDomain: /LM/W3SVC/38/ROOT/ServiceCenter-2-131279478927334358
Path: C:\OutSystems\Sandboxes\UH1EWF035\Platform Server\running\ServiceCenter\
Locale:
DateFormat: yyyy-MM-dd
PID: 30768 ('w3wp', Started='1/3/2017 8:11:13 PM', Priv=756Mb, Virt=18341Mb)
TID: 41
Thread Name:
.NET: 4.0.30319.42000
Stack:
Unable to connect to any of the specified MySQL hosts.
   at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at OutSystems.HubEdition.Extensibility.Data.TransactionService.BaseTransactionService.GetConnection()
   at OutSystems.HubEdition.Extensibility.Data.TransactionService.BaseTransactionService.CreateConnection(Int32 numRetries)
   at #e7c.#d7c.#86c(IIntegrationDatabaseConfiguration dbConfig, String& message)

----------------------------------------------------------------------------------

I need for assistance in connecting to MySQL successfully.

Cheers,

hon

Hi Hon Jianbai,


In order to connect to MySql, you will need to ensure the following:

  • the user is authorised to connect to MySql from the IP (grants and privileges, MySql configuration)
  • the password is correct
  • MySql is reachable from that IP (network configuration)


After reading your post, it looks like you are using a personal environment (remote, on the cloud), trying to connect to your local MySql installation.

If that is the case, you can't use 127.0.0.1 as the address for the MySql server, as that address is only accessible from your local machine. Instead you will need to use your public IP address (you can check it at http://whatismyip.org/) and ensure that your router is configured to forward the requests to your MySql server (this configuration depends on your router).

If that is not the case, please provide more details regarding your setup, so that we can help you further.

Regards,
Ricardo

Solution

Hi Ricardo Marques,


thank you for the prompt reply.


>If that is the case, you can't use 127.0.0.1 as the address for the MySql server,

It is this case.

I will check the configuration of router.


hon

Solution