Create and use MYSQL Database
Posted: 15 Jan 2020, 18:19
I have created the new MySQL Database, log looks OK:
2020-01-15 18:05:50.8834 INFO: [DbMysql] : MYSQL deploying database log4omnext START
2020-01-15 18:05:50.8944 INFO: [DbMysql] : Connection string: Server=127.0.0.1;Port=3308;User ID=hb9cat;Password=teresina;Pooling=false;SslMode=None
2020-01-15 18:05:50.9124 INFO: [DbMysql] : Script loaded
2020-01-15 18:05:50.9354 INFO: [DbMysql] : MySQL creation file is saved here: C:\Users\marco\AppData\Roaming\Log4OM2\log\createDatabase_log4omnext.sql
2020-01-15 18:05:50.9474 INFO: [DbMysql] : Opening connection...
2020-01-15 18:05:50.9694 INFO: [DbMysql] : Running script...
2020-01-15 18:05:51.4844 INFO: [DbMysql] : MYSQL database CREATED SUCCESSFULLY (43)
2020-01-15 18:06:03.7636 INFO: [DatabaseManagement] : Connection Valid
2020-01-15 18:06:08.3517 INFO: [DatabaseManagement] : Connection Valid
Problem: trying to import an ADIF file I get a "Not connected to a valid database" error
The 2 last log rows above are the feedback from:
- Check Connection
- Switch to MySQL
My feeling: the "Switch to MySQL" is just doing the same as the "Check Connection" button; in Version 1 it took quite some processing and resulted on "Connected"
73
Marco HB9CAT
2020-01-15 18:05:50.8834 INFO: [DbMysql] : MYSQL deploying database log4omnext START
2020-01-15 18:05:50.8944 INFO: [DbMysql] : Connection string: Server=127.0.0.1;Port=3308;User ID=hb9cat;Password=teresina;Pooling=false;SslMode=None
2020-01-15 18:05:50.9124 INFO: [DbMysql] : Script loaded
2020-01-15 18:05:50.9354 INFO: [DbMysql] : MySQL creation file is saved here: C:\Users\marco\AppData\Roaming\Log4OM2\log\createDatabase_log4omnext.sql
2020-01-15 18:05:50.9474 INFO: [DbMysql] : Opening connection...
2020-01-15 18:05:50.9694 INFO: [DbMysql] : Running script...
2020-01-15 18:05:51.4844 INFO: [DbMysql] : MYSQL database CREATED SUCCESSFULLY (43)
2020-01-15 18:06:03.7636 INFO: [DatabaseManagement] : Connection Valid
2020-01-15 18:06:08.3517 INFO: [DatabaseManagement] : Connection Valid
Problem: trying to import an ADIF file I get a "Not connected to a valid database" error
The 2 last log rows above are the feedback from:
- Check Connection
- Switch to MySQL
My feeling: the "Switch to MySQL" is just doing the same as the "Check Connection" button; in Version 1 it took quite some processing and resulted on "Connected"
73
Marco HB9CAT