update qso with external mysql

[iz1jup]

Hello
I'm using log4om with external database (connect with ADSL) because the db is shared with many operator, for special event multioperator. With the last version 1.18 I've two main problems: the qso aren't updated in log4om client automatically and in the same way hamqth isn't too
with the past version (maybe 1.16) all goes well.
Someone can help me?

TIA
73

[IW3HMH]

Hi, QSO are not updated by external database changes. There is not a triggerable event in Log4OM / MySQL i can use to detect a change on MySQL side.
Searches will work on the very last database, last QSO list will be refreshed on demand or when adding a new QSO from the current log writer, but a poller on db that periodically update data will be really expensive in terms of performances (constant DB polling is "heavy" for connection and CPU)

Nothing has changed on that from 1.16, so i'm probably missing something on your request.
QSO upload to hamqth should be set on each Log4OM installation. There is not a central instance that manages all inserted logs, and hamqth upload is not done by database but by application on qso save.

[iz1jup]

I try to better explain:
the mysql is on remote server and users connect the db by ADSL
when someone add qso others can see new qso only after press refresh button. In the past version automatically all client refresh qso.
ok for hamqth.

I'll make further test to see if this will repeat or is only a momentary problem and I'll write here
tnx for the moment
73

PS I like log4om for all his features and hope to introduce it for all ham I know

[IW3HMH]

when someone add qso others can see new qso only after press refresh button. In the past version automatically all client refresh qso.

This is the part that create more "doubts"... there is nothing on Log4OM that polls for changes in mySql right now.
And nothing changed on that part since 1.16 as far as i can remember...
Probably you independently made a refresh of the main screen, and this loaded also QSO from other guys...
anyway i'll check for the possibility to add this feature.

[iz1jup]

this is good idea because I think that is very usefull to see log upadate in realtime in multioperator environment to avoid duplicate qso.
another feature (may be bad forum section, then I'll repost in the right one) would be to "massive" upload log to online log: I didn't see this.
tnx
73

[G4POP]

this is good idea because I think that is very usefull to see log upadate in realtime in multioperator environment to avoid duplicate qso.
another feature (may be bad forum section, then I'll repost in the right one) would be to "massive" upload log to online log: I didn't see this.
tnx
73

Which online log?

[iz1jup]

hamqth/clublog
tnx
73

[G4POP]

At this time upload to those are both by an ADIF export from Log4OM and import into HamQTH and Clublog.

However we do have a bulk upload planned for the future

[iz1jup]

tnx Terry
yes now I use this method to upload to log online
I'll hope to see this feature in next release

tnx again
73