persistence.xml and mysql-persistence.xml have errors and corruptions.

[ShanghaiTimes]

Tracking this baby down.

I did a diff on persistence and mysql-persistence and discovered that the mysql-persistence.xml file was corrupted. I opened it in Notepad which doesn't change anything. No wordwrapping etc, and it appeared to be fine. However, in diff, it showed considerable difference to the head of the "comes-with-openmeetings" persistence file. I tidied it up in the diff engine so now it looks ok. The DIFF program is Windows, "Beyond Compare 3" ... oh how I miss Unix.

It may well have been corrupted by either the download or the text editor I used (TextPad) or Gremlins ...

Carefully waded through both files, and in persistence.xml, the line create=true appears twice in succession.

                    Url=jdbc:derby:openmeetings;create=true, 

                                  create=true,

                 MaxActive=100, 

Anyway, to cut a long story short - I replaced the persistence.xml with the mysql-persistence.xml, ran red5.bat, did localhost:5080/openmeetings/install and after a time - up it came.

So theoretically I'm now using the mysql engine. 

[seba....@gmail.com]

Hi Robert,

you can be 100% sure that if you have in your persistence.xml written:
Url=jdbc:derby:openmeetings
That it will NOT connect to MySQL.

The default persistence.xml that ships with OpenMeetings_1_8_x.zip is using Apache Derby and not MySQL.
mysl_persistence.xml of course has differences to persistence.xml as it actually are two configuration files for different database vendors.

See:
http://code.google.com/p/openmeetings/wiki/InstallationOpenMeetings#Recommendation_for_production_environment
http://code.google.com/p/openmeetings/wiki/Configuration_Mysql

Sebastian

2011/11/16 ShanghaiTimes <robert.a...@gmail.com>

--
You received this message because you are subscribed to the Google Groups "OpenMeetings User" group.
To view this discussion on the web visit https://groups.google.com/d/msg/openmeetings-user/-/wj-tVftEbgwJ.
To post to this group, send email to openmeet...@googlegroups.com.
To unsubscribe from this group, send email to openmeetings-u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/openmeetings-user?hl=en.

--
Sebastian Wagner
http://www.openmeetings.de
http://www.webbase-design.de
http://www.wagner-sebastian.com
seba....@gmail.com

[Robert Chalmers]

Hi Sebastian,

This message was just a heads up about problems in the two different files.

I fixed the problems in the mysql file, and reinstalled using it. It now works well.

The only seeming problem I have now is the failure of the batch file to process the profile picture. Its breaking on the space between 'Program' & 'Files'

Fantastic program which I really look forward to using in the Institute.

Cheers

Robert

PinPoint Premium. All new release. iPhone app. http://itunes.apple.com/us/app/pin-point-premium/id467970377?ls=1&mt=8