Hi Horace, I think the connection URL looks different from yours.
Seach for some sample MWSql configs, the URL normally looks quite different then that: <property name="connection.url">jdbc:sqlserver:// 127.0.0.1:1433 ;databaseName=openmeetings;autoReconnect=true;useUnicode=true;createDatabaseIfNotExist=true;characterEncoding=utf-8</ property> Sebastian 2010/9/23 HMiles <[email protected]> > I have just installed the latest version of Openmeetings > 1_4_rc1_r3326. I am connecting to a MS SQL server. > I have ensure the sqljdbc.jar was copied to the the webinf/lib folder > I have changed hybernate.conf.xml to reflect the correct user and > passwor and correct connection strings for sql server. (those that > have worked in the past) > I have reset my password on the MSSql server to match what is in the > hibernate.conf.xml file. > I have change conf.xml to point to the correct IP: > > extract from config.xml > <?xml version="1.0" encoding="UTF-8" ?> > <config> > > <!-- URL/IP to use for the Server > if this value is empty it will try to connect to the > domain-name the OpenMeetings-Client has been loading from > --> > <!--<rtmphostlocal>216.161.170.249</rtmphostlocal>--> > <rtmphostlocal>216.161.170.249</rtmphostlocal> > > extract from hibernate.config.xml > > > <?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<http://hibernate.sourceforge.net/hibernate-%0Aconfiguration-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">xx</property> > <property name="connection.password">xxxxxx</property> > - <!-- Database Settings > --> > <property > > name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</ > property> > - <!-- for performance reasons changed to MyISAM from > org.hibernate.dialect.MySQLInnoDBDialect > --> > <property name="dialect">org.hibernate.dialect.SQLServerDialect</ > property> > <property name="connection.url">jdbc:sqlserver:// > 127.0.0.1:1433 > ;databaseName=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/ > LdapConfig.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/ > SOAPLogin.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/flvrecord/ > FlvRecording.hbm.xml"/> > <mapping resource="org/openmeetings/app/hibernate/beans/flvrecord/ > FlvRecordingLog.hbm.xml"/> > <mapping resource="org/openmeetings/app/hibernate/beans/flvrecord/ > FlvRecordingMetaData.hbm.xml"/> > <mapping resource="org/openmeetings/app/hibernate/beans/flvrecord/ > FlvRecordingMetaDelta.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/ > RoomModerators.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/sip/ > OpenXGReturnObject.hbm.xml"/> > <mapping resource="org/openmeetings/app/hibernate/beans/user/ > Salutations.hbm.xml"/> > <mapping resource="org/openmeetings/app/hibernate/beans/user/ > UserSipData.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> > > etract from error log > 2010-09-22 15:10:47,703 [main] ERROR org.red5.server.jmx.JMXAgent - {} > java.io.IOException: Cannot bind to URL [rmi://:9999/red5]: > javax.naming.ServiceUnavailableException [Root exception is > java.rmi.ConnectException: Connection refused to host: > 216.161.170.249; nested exception is: > java.net.ConnectException: Connection refused: connect] > > I can telenet to the server and it responds. I just cant make red5 > bind to it. > > I know this is saying the SQL server is refusing connection, but I > have searched, rechecked and reloaded and can not get past this. > Anyone have a clue as to what I might check next. > > -- > 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]<openmeetings-user%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/openmeetings-user?hl=en. > > -- Sebastian Wagner http://www.webbase-design.de http://openmeetings.googlecode.com http://www.wagner-sebastian.com [email protected] -- 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.
