Hello Tom. the steps are simple: 1) go to your current OM folder 2) go to webapps/openmeetings/WEB-INF/classes/META-INF/ 3) print file persistence.xml (using tail or cat for ex.) 4) check the line: " Url=jdbc:mysql://localhost:3306/openmeetings? .............................."
In this URL: jdbc:mysql://localhost:3306/*openmeetings * openmeetings is the name of DB You might have multiple DBes hosted on same MySQL server :) On Wed, Jun 14, 2017 at 12:59 PM, Tom Wagner <[email protected]> wrote: > Thank you, Maxim. > > Looks like it's time to expand the limits of my understanding of mySQL. I > did wonder if I had somehow acquired another database process, perhaps in > the upgrade(s), but I could only find one mysql instance in the system > process list. > > I'm not familiar with the terms "DB nodes" and "active persistence.xml", > but I will research them. I certainly didn't intentionally create them if > I do in fact have them, but the OM server is definitely running--quite > happily it appears--on some other set of tables that I can't see when > logged in as root. > > Thanks for these clues. I will go away and perhaps be back with better > questions, or post my resolution. It's certainly not on your plate to > teach me advanced mySQL admin. :-) > > Best, > > =tew= > > On 06/13/2017 10:44 PM, Maxim Solodovnik wrote: > > Hello Tom, > > Nothing has changed (I'm using "raw DB access" to check things. > Maybe you have several DB nodes? Could you check using your active > persistence.xml? > > On Tue, Jun 13, 2017 at 12:04 AM, Tom Wagner <[email protected]> wrote: > >> Has something changed radically in the way OM stores data. >> >> Previously I could log into mySQL (MariaDB) on the server (localhost) as >> root with the web admin tool phpMyAdmin and browse/query data---like the >> *conferencelog* (for attendance verification) and the *invitations* >> table (for hashes to mail merge into prettier reminders for our attendees). >> >> Now however, I see no records beyond a dated prior to the upgrade from >> 3.0. Very, very strange---as the server performs normally, calendars and >> hosts conferences, and records new user entries as expected according to >> the web GUI. >> >> For example, I've entered a number of new users this year who show in the >> web GUI, and can participate normally in conferences. But when I browse >> the *om_users* table, they are nowhere to be seen and the latest record >> was inserted on 2015-07-15. !! >> >> Any light you can shed / what have I missed? >> >> -Tom Wagner, Jackson Orthopedic Foundation IT >> > > > > -- > WBR > Maxim aka solomax > > > -- WBR Maxim aka solomax
