Hi
I have an error when the DataServer try to connect to our mysql database:
2022-01-26 20:34:57.5931|INFO|Flexmonster.DataServer.HostedServices.MonitorUserUpdateService|Monitor User Storage Service is running
2022-01-26 20:34:58.1328|INFO|Flexmonster.DataServer.FlexmonsterPrepopulatingCacheService|Prepopulation service start working
2022-01-26 20:34:58.1479|INFO|Flexmonster.DataServer.Core.DataStorages.DataStorage|Start loading index index_database
2022-01-26 20:34:58.2441|ERROR|Flexmonster.DataServer.Core.IPrepopulatingService|Index index_database cannot be loaded. Details: Cannot load data from database executing query "SELECT ID,NAME FROM TASK LIMIT 10;". Please check query or connection string.
at Flexmonster.DataServer.Core.DataLoaders.DataLoader.Load(String index)
at Flexmonster.DataServer.Core.DataStorages.DataStorage.GetOrAddAsync(String cacheKey)
at Flexmonster.DataServer.FlexmonsterPrepopulatingCacheService.<>c__DisplayClass4_0.<<Prepopulate>b__1>d.MoveNext()
2022-01-26 20:34:58.2857|INFO|Flexmonster.DataServer.Startup|Flexmonster Data Server v. 2.9.17
2022-01-26 20:34:58.3076|INFO|Flexmonster.DataServer.Startup|Flexmonster Data Server is now listening on: http://localhost:9500
2022-01-26 20:34:58.3076|INFO|Flexmonster.DataServer.Startup|Application started. Press Ctrl+C to shut down
2022-01-26 20:34:58.3076|INFO|Flexmonster.DataServer.Startup|Hosting environment: Production
2022-01-26 20:34:58.3076|INFO|Flexmonster.DataServer.Startup|Content root path: /data/BeOtic/flexmonster
My flexmonster-config.json:
{
"DataSources": [{
"Type": "database",
"DatabaseType": "mysql",
"ConnectionString":
"Server=localhost;Port=3306;Database=beop362;Uid=MyUSer;Pwd=MyPassword;PipeName=MYSQL;CommandTimeout=200;",
"Indexes": {
"index_database": {
"Query": "SELECT ID,NAME FROM TASK LIMIT 10;"
}
}
}],
"Security":
{
"Authorization":
{
"Enabled": false
},
"CORS":
{
"AllowOrigin": "*"
}
},
"DataStorageOptions":
{
"DataRefreshTime": "60"
},
"Port": "9500"
}
I already check my mysql server using connexion from native mysql client or from tomcat (localhost, port, user, password)
Hello,
Thank you for providing detailed information.
We haven’t managed to reproduce the issue on our side. However, a similar case was resolved recently: https://www.flexmonster.com/question/unable-to-load-mysql-data-since-version-2-9-1/. We kindly suggest trying the approaches mentioned in the thread above.
Please let us know if it helps.
Kind regards,
Nadia