hi, i think, it isnt necessary to check the existence of the columns, as the tables are created correctly...
-> OpenMeetings requieres UTF-8 encoding - did u create your database with UTF-8 encoding ( has your mysql server UTF-8 as default encoding for new databases?) -> if the encoding is correct, i would recommend to drop database once more, recreate it. -> restart red5 and watch out for possible errors on startup (-> concerning openmeetings, especially InstallServlet) -> call install servlet and in case of errors, please post the red5.log... see ya Smoeker On 11 Mrz., 10:25, Allan Pinto <[email protected]> wrote: > hi smoeker, > yes, i cp'ed the mysql_hibera... to hibernate.cfg.xml, > i dont know exactly how to check the tables and columns completely , > but a show tables show this. > mysql> use openmeetings; > Database changed > mysql> show tables; > +---------------------------+ > | Tables_in_openmeetings | > +---------------------------+ > | adresses | > | appointmentcategory | > | appointmentremindertyps | > | appointments | > | conferencelog | > | conferencelogtype | > | configuration | > | errortypes | > | errorvalues | > | fieldlanguage | > | fieldlanguagesvalues | > | fieldvalues | > | invitations | > | meeting_members | > | naviglobal | > | navimain | > | navisub | > | organisation | > | organisation_users | > | recording | > | recording_chatvaluesevent | > | recording_conversion_job | > | recording_roomstream | > | recording_whiteboardevent | > | recordingclient | > | roomclient | > | roomrecording | > | rooms | > | rooms_organisation | > | roomtypes | > | salutations | > | sessiondata | > | states | > | userdata | > | usergroups | > | userlevel | > | users | > | users_usergroups | > +--------------------------- > > . > > > > On Wed, Mar 11, 2009 at 8:42 AM, smoeker <[email protected]> wrote: > > > hi, > > > you edited the mysql.hiber... and renamed it to hibernate.cfg.xml > > under RED5_HOME/webapps/openmeetings/conf/hibernate.cfg.xml? > > > -> the tables and columns were created correctly? > > > see ya > > > Smoeker > > > On 11 Mrz., 09:30, deadwait <[email protected]> wrote: > >> here it is. > >> i using mysql, and i have created the database openmeetings. > > >> <?xml version="1.0" encoding="UTF-8"?> > >> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate > >> Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate- > >> configuration-3.0.dtd"> > > >> <!-- Generated file - Do not edit! --> > > >> <hibernate-configuration> > > >> <!-- a SessionFactory instance listed as /jndi/name --> > >> <session-factory> > > >> <!-- User / Password --> > >> <property name="connection.username">root</property> > >> <property name="connection.password"></property> > > >> <!-- Database Settings --> > >> <property > >> name="connection.driver_class">com.mysql.jdbc.Driver</ > >> property> > >> <!-- for performance reasons changed to MyISAM from > >> org.hibernate.dialect.MySQLInnoDBDialect --> > >> <property > >> name="dialect">org.hibernate.dialect.MySQLMyISAMDialect</ > >> property> > >> <property > >> name="connection.url">jdbc:mysql://localhost/openmeetings? > >> autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8</ > >> property> > > >> <property > >> name="hibernate.connection.CharSet">utf8</property> > >> <property > >> name="hibernate.connection.characterEncoding">utf8</ > >> property> > >> <property > >> name="hibernate.connection.useUnicode">true</property> > > >> <!-- Database Scheme Auto Update --> > >> <property name="hbm2ddl.auto">update</property> > > >> <!-- properties --> > > >> <property name="show_sql">false</property> > >> <property name="use_outer_join">false</property> > >> <property > >> name="hibernate.query.factory_class">org.hibernate.hql.ast.ASTQueryTranslatorFactory</ > >> property> > >> <property > >> name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</ > >> property> > >> <!-- > >> <property name="connection.provider_class > >> ">org.hibernate.connection.C3P0ConnectionProvider</property> > >> --> > >> <property > >> name="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</ > >> property> > >> <property name="hibernate.cache.use_query_cache">false</ > >> property> > >> <property name="hibernate.cache.use_second_level_cache">false</ > >> property> > >> <property name="hibernate.generate_statistics">false</ > >> property> > >> <property name="hibernate.cache.use_structured_entries">false</ > >> property> > > >> <property name="c3p0.max_size">20</property> > >> <property name="c3p0.min_size">2</property> > >> <property name="c3p0.idle_test_period">100</property> > >> <property name="c3p0.max_statements">100</property> > >> <property name="c3p0.timeout">100</property> > > >> <!-- mapping files --> > >> <mapping resource="org/openmeetings/app/hibernate/beans/adresses/ > >> Adresses.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/adresses/ > >> States.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/basic/ > >> Configuration.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/basic/ > >> ErrorType.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/basic/ > >> ErrorValues.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/basic/ > >> Naviglobal.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/basic/ > >> Navimain.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/basic/ > >> Navisub.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/basic/ > >> Sessiondata.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/calendar/ > >> Appointment.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/calendar/ > >> AppointmentCategory.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/calendar/ > >> AppointmentReminderTyps.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/calendar/ > >> MeetingMember.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/domain/ > >> Organisation.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/domain/ > >> Organisation_Users.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/invitation/ > >> Invitations.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/lang/ > >> FieldLanguage.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/lang/ > >> Fieldlanguagesvalues.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/lang/ > >> Fieldvalues.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/logs/ > >> ConferenceLog.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/logs/ > >> ConferenceLogType.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/recording/ > >> ChatvaluesEvent.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/recording/ > >> Recording.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/recording/ > >> RecordingClient.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/recording/ > >> RecordingConversionJob.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/recording/ > >> RoomClient.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/recording/ > >> RoomRecording.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/recording/ > >> RoomStream.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/recording/ > >> WhiteBoardEvent.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/rooms/ > >> RoomTypes.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/rooms/ > >> Rooms.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/rooms/ > >> Rooms_Organisation.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/user/ > >> Salutations.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/user/ > >> Userdata.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/user/ > >> Usergroups.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/user/ > >> Userlevel.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/user/ > >> Users.hbm.xml"/> > >> <mapping resource="org/openmeetings/app/hibernate/beans/user/ > >> Users_Usergroups.hbm.xml"/> > >> </session-factory> > > >> </hibernate-configuration> > > >> On Mar 11, 12:47 pm, smoeker <[email protected]> wrote: > > >> > hi, > > >> > can you post your hibernate.cfg.xml? > > >> > see ya > > >> > Smoeker > > >> > On 11 Mrz., 08:05, Allan Pinto <[email protected]> wrote: > > >> > > hi , > > >> > > im trying to install the svn version, ( because of jrdesktop, as im > >> > > getting bad bandwidth errors in 0.7rc2) > >> > > im using red5-0.8rc2 and openlaszlo 4.2.x . > >> > > i also copied the contents of the openlaszlo client directory into the > >> > > webapps/openmeeting directory, after which i got > >> > > the install page, but step 2 comes as a blank page, > >> > > i could.nt capture the errors properly in the red5 console , but it > >> > > looks like this > >> > > Caused by: java.sql.BatchUpdateException: Incorrect > > ... > > Erfahren Sie mehr »- Zitierten Text ausblenden - > > - Zitierten Text anzeigen - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "OpenMeetings User" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/openmeetings-user?hl=en -~----------~----~----~----~------~----~------~--~---
