Page 1 of 1

Error Loggin into Log4omV2 with MySQL DB

Posted: 27 May 2023, 03:28
by N3AIR
We just setup a multi-station off Log4OMV2 using MySQL. JTAlert will talk to MySQL via the test. But can not log the QSO. I have used the same settings as I have many times over when using SQLite on a single computer. I have found some old articles around this error but nothing recent. I don't know which side the issue is on here but any help will be appreciated.
error1.png
error1.png (9.86 KiB) Viewed 1266 times
error2.png
error2.png (19.18 KiB) Viewed 1266 times
error3.png
error3.png (30.25 KiB) Viewed 1266 times

Re: Error Loggin into Log4omV2 with MySQL DB

Posted: 27 May 2023, 03:28
by N3AIR
error4.png
error4.png (24.69 KiB) Viewed 1265 times

Re: Error Loggin into Log4omV2 with MySQL DB

Posted: 27 May 2023, 09:08
by G4POP
Have you asked this question of JTAlert? as it seems more on their side than Log4OM

Re: Error Loggin into Log4omV2 with MySQL DB

Posted: 28 May 2023, 01:10
by N3AIR
I have, current thought is UDP issue into Log4om and/or something to do with MySQL. Going to setup the computer to user SQLite instead of MySQL for testing and see if it works without issue.

Re: Error Loggin into Log4omV2 with MySQL DB

Posted: 28 May 2023, 08:15
by G4POP
Unless you have special requirements SQLITE is fine for up to about 130k QSO's

Re: Error Loggin into Log4omV2 with MySQL DB

Posted: 08 Jun 2023, 00:32
by N3AIR
We are using MySQL for multiple computers and putting data into our website. The issue ended up being using another port from 2236 to make it work. The port is not in use anywhere but after trying to change the DB type and reconfiguring everything several times, ended up changing the port to fix it.