Hi, I also have the same issue with Kishor gupta but I still haven't found
out how to fix it.
I'm installing OpenMeetings 1.6 rc1 with MySQL 5.5.8 on Windows 7. I've
followed the installation guide
http://code.google.com/p/openmeetings/wiki/InstallationOpenMeetings ,
completed dependency installations. MySQL haved been configured to listen
TCP/IP port and character_set = utf8.
I also renamed file mysql_hibernate.cfg.xml to hibernate.cfg.xml
(after copied the old hibernate.cfg.xml to another folder to backup) and
edited the new hibernate.cfg.xml with:
<!-- User / Password -->
<property name="connection.username">root</property>
<property name="connection.password">*******</property>
<property
name="connection.url">jbdc:mysql://localhost/openmeetings</property>
<!-- Database Settings -->
...
but then when I run the red5.bat, I had errors in error.log of red5 like:
*Unsuccessful: create table adresses (adresses_id bigint not null,
additionalname varchar(255), comment_field varchar(255), fax varchar(255),
starttime datetime, state_id bigint, street varchar(255), town varchar(255),
updatetime datetime, zip varchar(255), deleted varchar(255), email
varchar(255), phone varchar(255), primary key (adresses_id)) type=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'type=MyISAM' at
line 1
Unsuccessful: create table appointmentcategory (category_id bigint not null,
name varchar(255), user_id bigint, starttime datetime, updatetime datetime,
deleted varchar(255), comment_field varchar(255), primary key (category_id))
type=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'type=MyISAM' at
line 1
....*
I checked MySQL Database and there exist a DB named *openmeetings* with no
table, view and routine.
When I try http://localhost:5080/openmeetings/install, the result is the
same with Kishor gupta.
Did I do something wrong with hibernate.cfg.xml? Or the version of MySQL is
not compatible with Openmeetings?
Please help me.
Thanks
Alex Do
--
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.
