DEFAULT CHARSET=latin1

all your tables have the wrong encoding.

Stop openMeetings, stop MySQL,
open my.cnf for editing
add (in case its Mysql 5.5) in the appropriate section:
server-character-set=utf8
restart Mysql,
drop the db openmeetings
restart openmeetings/red5
delete the file: openmeetings-red5/webapps/openmeetings/conf/install.xml
rerun the openmeetings web-installer

Sebastian

2011/9/15 john felipe urrego mejia <[email protected]>

> Hi, yes, please view attach, but refresh
> http://192.168.1.1:5081/openmeetings/install?command=step2, and increase
> some tables
>
> Tnks
>
> 2011/9/15 [email protected] <[email protected]>
>
>> are the tables created in the database?
>>
>> if not then either user/host/pass are wrong or the DB does not listen to
>> TCP/IP connections.
>>
>> Sebastian
>>
>> 2011/9/15 john felipe urrego mejia <[email protected]>
>>
>>> Hi,
>>> C:\red5\webapps\openmeetings\WEB-INF\classes\META-INF\persistence.xml:
>>>
>>> <properties>
>>>                 <property name="openjpa.ConnectionProperties"
>>> value="DriverClassName=com.mysql.jdbc.Driver,
>>> Url=jdbc:mysql://localhost:3306/openmeetings?autoReconnect=true&amp;useUnicode=true&amp;createDatabaseIfNotExist=true&amp;characterEncoding=utf-8&amp;connectionCollation=utf8_general_ci&amp;cachePrepStmts=true&amp;cacheCallableStatements=true&amp;cacheServerConfiguration=true&amp;useLocalSessionState=true&amp;elideSetAutoCommits=true&amp;alwaysSendSetIsolation=false&amp;enableQueryTimeouts=false&amp;prepStmtCacheSize=3000&amp;prepStmtCacheSqlLimit=1000,
>>> MaxActive=100, MaxWait=10000, TestOnBorrow=true,
>>> poolPreparedStatements=true,  Username=root, Password=laconstraseña"/>
>>>                 <property name="openjpa.jdbc.SynchronizeMappings"
>>> value="buildSchema"/>
>>>                 <property name="openjpa.RuntimeUnenhancedClasses"
>>> value="unsupported"/>
>>>                   <property name="openjpa.Log" value="DefaultLevel=WARN,
>>> Tool=INFO" />
>>>                 <property name="openjpa.ConnectionDriverName"
>>> value="org.apache.commons.dbcp.BasicDataSource"/>
>>>                 <property name="openjpa.DataCache" value="true"/>
>>>                 <property name="openjpa.QueryCache" value="true"/>
>>>                 <property name="openjpa.jdbc.DBDictionary"
>>> value="batchLimit=100,tableType=myisam"/>
>>>                 <property name="openjpa.jdbc.QuerySQLCache"
>>> value="false"/>
>>>         </properties>
>>>
>>> What i do?
>>>
>>> Tnks
>>>
>>> 2011/9/15 [email protected] <[email protected]>
>>>
>>>> please check you persistance.xml + the logfile
>>>> Maybe you did not configure the database to use utf as
>>>> default-character-set. Are the tables in the database already created by
>>>> openmeetings? What collation/charatcter set do they have?
>>>>
>>>> Sebastian
>>>>
>>>> 2011/9/15 ingenierofelipeurrego <[email protected]>
>>>>
>>>>> Hi, please share me database in .sql, because install process stop in
>>>>> openmeetings/install?command=step2.
>>>>>
>>>>> Tnks
>>>>>
>>>>> --
>>>>> 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.
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> 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.
>>>>
>>>
>>>  --
>>> 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.
>>>
>>
>>
>>
>> --
>> 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.
>>
>
>


-- 
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.

Reply via email to