Page 1 of 1

Create and use MYSQL Database

Posted: 15 Jan 2020, 18:19
by hb9cat
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

Re: Create and use MYSQL Database

Posted: 15 Jan 2020, 18:42
by IW3HMH
when you switch you should see the connection parameters in the bottom right area of the main USER INTERFACE.
What did you see there? Did you saved configuration at the end of the process? switch is applied on SETTINGS SAVE

Re: Create and use MYSQL Database

Posted: 15 Jan 2020, 23:50
by hb9cat
You're right, I didn't save the configuration correctly; I guess I just did save & exit

Now I see 127.0.0.1:3306 bottom right with a green dot, and the ADIF Import is working.

Thanks !
Marco

Re: Create and use MYSQL Database

Posted: 16 Jan 2020, 11:54
by IW3HMH
Good :)