Create and use MYSQL Database

Post Reply
hb9cat
Advanced Class
Posts: 39
Joined: 12 May 2014, 05:57

Create and use MYSQL Database

Post 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
User avatar
IW3HMH
Site Admin
Posts: 2925
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: Create and use MYSQL Database

Post 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
Daniele Pistollato - IW3HMH
hb9cat
Advanced Class
Posts: 39
Joined: 12 May 2014, 05:57

Re: Create and use MYSQL Database

Post 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
User avatar
IW3HMH
Site Admin
Posts: 2925
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: Create and use MYSQL Database

Post by IW3HMH »

Good :)
Daniele Pistollato - IW3HMH
Post Reply