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">
<!-- 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].
For more options, visit this group at
http://groups.google.com/group/openmeetings-user?hl=en.
