Hello Mikael, I can point to the 2 MySQL advantages: 1 it performs faster 2 you can query it while OM is running :)
If you don't like MySQL you can use postgres or oracle, or write persistence.xml to the DB of your choice :) I never saw timeout issues with MySQL. But feel free to file JIRA issue if you feel you found a bug :) On Dec 10, 2012 7:57 PM, "Mikael Kurula" <alcar...@gmail.com> wrote: > Hi again! > > Now I had no problems with recordings and mysql timeouts, even if I don't > think the OM server has been used for days. > > Anyway, since poor reliability was the only reason for me to switch away > from the previous web conference software I was using, I'm not happy with > the prospect of losing OM-recordings because of mysql timeouts. Therefore I > now ask: why is mysql recommended? What are the drawbacks of using the > default derby persistence? > > Another question: I find it a bit difficult to follow the discussions here > in the mailing list. Besides, this seems to be a clear bug, not an issue > about how to use OM. Should I file a bug report in the issue tracker? Also, > after some testing I might have a few other bugs and feature requests to > report. > > Friendly greetings, > Mikael > > > On 2012.4.12, at 10:44, Mikael Kurula wrote: > > > That's unfortunate... If it's of any help, then I'm using a CentOS 6 > server with the following version of mysql: > > > > mysql Ver 14.14 Distrib 5.1.66, for redhat-linux-gnu (x86_64) using > readline 5.1 > > > > My version of openmeetings is this: > > apache-openmeetings-incubating-2.0.0.r1361497-14-07-2012_1108.tar.gz > > > > and the version of the J connector is mysql-connector-java-5.1.22.tar.gz > > > > Mikael > > > > > > On 4 December 2012 10:16, Maxim Solodovnik <solomax...@gmail.com> wrote: > > We are using OpenJPA (not Hibernate) > > and already have "TestOnBorrow=true" and DB connection pool :( > > not sure what else can be done ... Never saw such exception on my > machines :( > > > > > > On Tue, Dec 4, 2012 at 3:03 PM, Mikael Kurula <alcar...@gmail.com> > wrote: > > Good morning! > > > > Very nice to see that this issue generates interest. By googling I found > these discussions: > > > > http://wiki.pentaho.com/display/ServerDoc2x/Configuring+for+MySQL > > > http://www.coderanch.com/t/564390/Tomcat/CommunicationsException-tomcat-mysql > > > > I would assume this is the problem. Can the solution outlined in the > first link solve the problem for OM as well? > > > > Friendly greetings, > > Mikael > > > > > > > > On 3 December 2012 20:08, Mahmut TEKER <teker.mah...@gmail.com> wrote: > > Hi, > > > > There is a connection between this error (or info) and recording and > sharing of the OM (or I guess like that). I have the same problem on > recordings and I am taking same response about com.mysql.jdbc... kind of > reports from the system. I have also checked that "autoReconnect=true" > option is already given on the connection string and also checked the > permission or the connection of mysql server but could not find a proper > solution. Is there a bit more specific information about error message? > > > > Thanks, > > > > _Mahmut > > > > > > On 12/3/2012 2:25 PM, Mikael Kurula wrote: > > Hi again! > > > > > > Today I have another question. As I understand, it is recommended to > integrate OpenMeetings with MySQL. This I did, but it seems I run into > problems with MySQL timeouts because of inactivity overnight, getting the > following error message in the openmeetings.log: > > > > Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The > last packet successfully received from the server was 90,881,924 > milliseconds ago. The last packet sent successfully to the server was > 90,881,924 milliseconds ago. is longer than the server configured value of > 'wait_timeout'. You should consider either expiring and/or testing > connection validity before use in your application, increasing the server > configured values for client timeouts, or using the Connector/J connection > property 'autoReconnect=true' to avoid this problem. > > > > I found rather conflicting information on the appropriateness of setting > autoReconnect=true when I googled. What is the recommended way of dealing > with this in OpenMeetings? > > > > > > I don't know if it is related or not, but these errors showed up when I > finished a test recording. Then when I tried to go and watch the recording, > I only get "The recording is not yet ready for watching" and it seems the > recording didn't consume any disk space. > > > > > > Id' be most grateful for any help! > > > > Mikael > > > > > > > > > > > > > > > > > > -- > > WBR > > Maxim aka solomax > > > >
