You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Murat Tamer Ataol <Ta...@saglik.gov.tr> on 2014/08/25 10:22:39 UTC
Openmeetings problem
Hello,
I have a problem after installation. Installation completes ok. After that when I hit the "Enter the Application" link notinited page comes. I tried writing localhost:5080/openmeetings on the address bar. It didnt work. I couldnt find how to come to login page. Login page never comes.
Can you be of any help?
Kind regards,
Tamer Ataol
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:image3ca3dd.JPG@6f242a32.46a25eb7]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
YASAL UYARI:
Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere) gizlidir. T.C. Sağlık Bakanlığı onayı olmaksızın içeriği kopyalanamaz, üçüncü kişilere açıklanamaz veya iletilemez . Bu mesajın gönderilmek istendiği kişi değilseniz (ya da bu e-posta'yı yanlışlıkla aldıysanız), lütfen yollayan kişiyi haberdar ediniz ve mesajı sisteminizden derhal siliniz. T.C. Sağlık Bakanlığı bu mesajın içerdiği bilgilerin doğruluğu veya eksiksiz olduğu konusunda bir garanti vermemektedir. Bu nedenle, bilgilerin ne şekilde olursa olsun içeriğinden, iletilmesinden, alınmasından, saklanmasından T.C. sağlık Bakanlığı sorumlu değildir. Bu mesajın içeriği yazarına ait olup, T.C. Sağlık Bakanlığı görüşlerini içermeyebilir.
Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır.
DISCLAIMER:
This e-mail (including any attachments) may contain confidential and/or privileged information. Copying, disclosure or distribution of the material in this e-mail without The Ministry of Health of Turkey's authority is strictly forbidden. If you are not the intended recipient (or have received this e-mail in error), please notify the sender and delete it from your system immediately. The Ministry of Health of Turkey makes no warranty as to the accuracy or completeness of any information contained in this message and hereby excludes any liability of any kind for the information contained therein or for the information transmission, reception, storage or use of such in any way whatsoever. Any opinions expressed in this message are those of the author and may not necessarily reflect the opinions of The Ministry of Health of Turkey.
This e-mail has been scanned for all computer viruses known to us.
________________________________
YNT: Openmeetings problem
Posted by Murat Tamer Ataol <Ta...@saglik.gov.tr>.
Hello,
I am using Openmeetings 3.0.2. And using mysql.
Kind regards,
Tamer Ataol
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:imagea36489.JPG@cecbb7bd.40837e1e]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Maxim Solodovnik [solomax666@gmail.com]
Gönderildi: 25 Ağustos 2014 Pazartesi 11:43
Kime: Openmeetings user-list
Konu: Re: Openmeetings problem
What OM version are you using?
What DB?
On 25 August 2014 15:38, Murat Tamer Ataol <Ta...@saglik.gov.tr>> wrote:
Hello,
I checked the log files. There is one error in openmeetings.log.
----------------------------------------------------------------------------------------
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'openmeetings.appointments' doesn't exist {prepstmnt 641714439 SELECT t0.id<http://t0.id>, t1.id<http://t1.id>, t1.comment_field, t1.deleted, t1.name<http://t1.name>, t1.starttime, t1.updatetime, t2.id<http://t2.id>, t2.activatehash, t3.id<http://t3.id>, t3.additionalname, t3.comment_field, t3.deleted, t3.email, t3.fax, t3.phone, t3.starttime, t4.id<http://t4.id>, t4.code, t4.deleted, t4.name<http://t4.name>, t4.shortName, t4.starttime, t4.updatetime, t3.street, t3.town, t3.updatetime, t3.zip, t2.age, t2.availible, t2.deleted, t2.externalUserId, t2.externalUserType, t2.firstname, t2.forceTimeZoneCheck, t2.language_id, t2.lastlogin, t2.lastname, t2.lasttrans, t2.level_id, t2.login, t2.owner_id, t2.pictureuri, t2.regdate, t2.resethash, t2.salutations_id, t2.sendSMS, t2.show_contact_data, t2.show_contact_data_to_contacts, t5.id<http://t5.id>, t5.allow, t5.callbackextension, t5.context, t5.defaultuser, t5.fullcontact, t5.host, t5.ipaddr, t5.lastms, t5.md5secret, t5.name<http://t5.name>, t5.nat, t5.port, t5.regseconds, t5.regserver, t5.secret, t5.type, t5.useragent, t2.starttime, t2.status, t2.time_zone_id, t2.type, t2.updatetime, t2.user_offers, t2.user_searchs, t0.is_connected_event, t0.deleted, t0.description, t0.appointment_endtime, t0.icalId, t0.starttime, t0.isdaily, t0.ismonthly, t0.isweekly, t0.isyearly, t0.language_id, t0.location, t6.id<http://t6.id>, t6.activatehash, t6.adresses_id, t6.age, t6.availible, t6.deleted, t6.externalUserId, t6.externalUserType, t6.firstname, t6.forceTimeZoneCheck, t6.language_id, t6.lastlogin, t6.lastname, t6.lasttrans, t6.level_id, t6.login, t6.owner_id, t6.pictureuri, t6.regdate, t6.resethash, t6.salutations_id, t6.sendSMS, t6.show_contact_data, t6.show_contact_data_to_contacts, t6.sip_user_id, t6.starttime, t6.status, t6.time_zone_id, t6.type, t6.updatetime, t6.user_offers, t6.user_searchs, t0.password, t0.is_password_protected, t7.id<http://t7.id>, t7.deleted, t7.fieldvalues_id, t7.name<http://t7.name>, t7.starttime, t7.updatetime, t8.id<http://t8.id>, t8.activatehash, t8.adresses_id, t8.age, t8.availible, t8.deleted, t8.externalUserId, t8.externalUserType, t8.firstname, t8.forceTimeZoneCheck, t8.language_id, t8.lastlogin, t8.lastname, t8.lasttrans, t8.level_id, t8.login, t8.owner_id, t8.pictureuri, t8.regdate, t8.resethash, t8.salutations_id, t8.sendSMS, t8.show_contact_data, t8.show_contact_data_to_contacts, t8.sip_user_id, t8.starttime, t8.status, t8.time_zone_id, t8.type, t8.updatetime, t8.user_offers, t8.user_searchs, t0.is_reminder_email_send, t9.id<http://t9.id>, t9.allow_font_styles, t9.allow_recording, t9.allow_user_questions, t9.appointment, t9.auto_video_select, t9.chat_moderated, t9.chat_opened, t9.comment_field, t9.confno, t9.deleted, t9.demo_time, t9.externalRoomId, t9.externalRoomType, t9.files_opened, t9.hide_actions_menu, t9.hide_activities_and_actions, t9.hide_chat, t9.hide_files_explorer, t9.hide_screen_sharing, t9.hide_top_bar, t9.hide_whiteboard, t9.is_audio_only, t9.is_closed, t9.isdemoroom, t9.ismoderatedroom, t9.ispublic, t9.name<http://t9.name>, t9.numberOfPartizipants, t9.owner_id, t9.pin, t9.redirect_url, t9.roomtypes_id, t9.show_microphone_status, t9.sip_enabled, t9.starttime, t9.updatetime, t9.wait_for_recording, t0.appointment_starttime, t0.appointmentname, t0.updatetime FROM appointments t0 LEFT OUTER JOIN appointmentcategory t1 ON t0.category_id = t1.id<http://t1.id> LEFT OUTER JOIN om_user t6 ON t0.user_id = t6.id<http://t6.id> LEFT OUTER JOIN appointmentremindertyps t7 ON t0.remind_id = t7.id<http://t7.id> LEFT OUTER JOIN room t9 ON t0.room_id = t9.id<http://t9.id> LEFT OUTER JOIN om_user t2 ON t1.user_id = t2.id<http://t2.id> LEFT OUTER JOIN om_user t8 ON t7.user_id = t8.id<http://t8.id> LEFT OUTER JOIN address t3 ON t2.adresses_id = t3.id<http://t3.id> LEFT OUTER JOIN sipusers t5 ON t2.sip_user_id = t5.id<http://t5.id> LEFT OUTER JOIN state t4 ON t3.state_id = t4.id<http://t4.id> WHERE (t0.deleted = ? AND t0.is_reminder_email_send = ? AND (t0.remind_id = ? OR t0.remind_id = ?) AND (t0.appointment_starttime >= ? AND t0.appointment_starttime <= ? OR t0.appointment_endtime >= ? AND t0.appointment_endtime <= ? OR t0.appointment_starttime < ? AND t0.appointment_endtime > ?))} [code=1146, state=42S02]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268) ~[openjpa-bundle-2.2.2.jar:2.2.2]
-----------------------------------------------------------------------------------
I dont exacly know why this table is not there. Installation didnt give any problem. How can I fix this one?
Kind regards,
Tamer Ataol
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:image6b1a0d.JPG@3c1015a6.48a81f1b]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 11:26
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: Openmeetings problem
Hello Tamer Ataol,
Please check log files in the log directory.
Thanks,
Vasiliy
On 25.08.2014 15:22, Murat Tamer Ataol wrote:
Hello,
I have a problem after installation. Installation completes ok. After that when I hit the "Enter the Application" link notinited page comes. I tried writing localhost:5080/openmeetings on the address bar. It didnt work. I couldnt find how to come to login page. Login page never comes.
Can you be of any help?
Kind regards,
Tamer Ataol
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part1.01060904.06000207@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
YASAL UYARI:
Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere) gizlidir. T.C. Sağlık Bakanlığı onayı olmaksızın içeriği kopyalanamaz, üçüncü kişilere açıklanamaz veya iletilemez . Bu mesajın gönderilmek istendiği kişi değilseniz (ya da bu e-posta'yı yanlışlıkla aldıysanız), lütfen yollayan kişiyi haberdar ediniz ve mesajı sisteminizden derhal siliniz. T.C. Sağlık Bakanlığı bu mesajın içerdiği bilgilerin doğruluğu veya eksiksiz olduğu konusunda bir garanti vermemektedir. Bu nedenle, bilgilerin ne şekilde olursa olsun içeriğinden, iletilmesinden, alınmasından, saklanmasından T.C. sağlık Bakanlığı sorumlu değildir. Bu mesajın içeriği yazarına ait olup, T.C. Sağlık Bakanlığı görüşlerini içermeyebilir.
Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır.
DISCLAIMER:
This e-mail (including any attachments) may contain confidential and/or privileged information. Copying, disclosure or distribution of the material in this e-mail without The Ministry of Health of Turkey's authority is strictly forbidden. If you are not the intended recipient (or have received this e-mail in error), please notify the sender and delete it from your system immediately. The Ministry of Health of Turkey makes no warranty as to the accuracy or completeness of any information contained in this message and hereby excludes any liability of any kind for the information contained therein or for the information transmission, reception, storage or use of such in any way whatsoever. Any opinions expressed in this message are those of the author and may not necessarily reflect the opinions of The Ministry of Health of Turkey.
This e-mail has been scanned for all computer viruses known to us.
________________________________
--
WBR
Maxim aka solomax
Re: Openmeetings problem
Posted by Maxim Solodovnik <so...@gmail.com>.
What OM version are you using?
What DB?
On 25 August 2014 15:38, Murat Tamer Ataol <Ta...@saglik.gov.tr>
wrote:
> Hello,
>
> I checked the log files. There is one error in openmeetings.log.
>
> ----------------------------------------------------------------------------------------
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table
> 'openmeetings.appointments' doesn't exist {prepstmnt 641714439 SELECT
> t0.id, t1.id, t1.comment_field, t1.deleted, t1.name, t1.starttime,
> t1.updatetime, t2.id, t2.activatehash, t3.id, t3.additionalname,
> t3.comment_field, t3.deleted, t3.email, t3.fax, t3.phone, t3.starttime,
> t4.id, t4.code, t4.deleted, t4.name, t4.shortName, t4.starttime,
> t4.updatetime, t3.street, t3.town, t3.updatetime, t3.zip, t2.age,
> t2.availible, t2.deleted, t2.externalUserId, t2.externalUserType,
> t2.firstname, t2.forceTimeZoneCheck, t2.language_id, t2.lastlogin,
> t2.lastname, t2.lasttrans, t2.level_id, t2.login, t2.owner_id,
> t2.pictureuri, t2.regdate, t2.resethash, t2.salutations_id, t2.sendSMS,
> t2.show_contact_data, t2.show_contact_data_to_contacts, t5.id, t5.allow,
> t5.callbackextension, t5.context, t5.defaultuser, t5.fullcontact, t5.host,
> t5.ipaddr, t5.lastms, t5.md5secret, t5.name, t5.nat, t5.port,
> t5.regseconds, t5.regserver, t5.secret, t5.type, t5.useragent,
> t2.starttime, t2.status, t2.time_zone_id, t2.type, t2.updatetime,
> t2.user_offers, t2.user_searchs, t0.is_connected_event, t0.deleted,
> t0.description, t0.appointment_endtime, t0.icalId, t0.starttime,
> t0.isdaily, t0.ismonthly, t0.isweekly, t0.isyearly, t0.language_id,
> t0.location, t6.id, t6.activatehash, t6.adresses_id, t6.age,
> t6.availible, t6.deleted, t6.externalUserId, t6.externalUserType,
> t6.firstname, t6.forceTimeZoneCheck, t6.language_id, t6.lastlogin,
> t6.lastname, t6.lasttrans, t6.level_id, t6.login, t6.owner_id,
> t6.pictureuri, t6.regdate, t6.resethash, t6.salutations_id, t6.sendSMS,
> t6.show_contact_data, t6.show_contact_data_to_contacts, t6.sip_user_id,
> t6.starttime, t6.status, t6.time_zone_id, t6.type, t6.updatetime,
> t6.user_offers, t6.user_searchs, t0.password, t0.is_password_protected,
> t7.id, t7.deleted, t7.fieldvalues_id, t7.name, t7.starttime,
> t7.updatetime, t8.id, t8.activatehash, t8.adresses_id, t8.age,
> t8.availible, t8.deleted, t8.externalUserId, t8.externalUserType,
> t8.firstname, t8.forceTimeZoneCheck, t8.language_id, t8.lastlogin,
> t8.lastname, t8.lasttrans, t8.level_id, t8.login, t8.owner_id,
> t8.pictureuri, t8.regdate, t8.resethash, t8.salutations_id, t8.sendSMS,
> t8.show_contact_data, t8.show_contact_data_to_contacts, t8.sip_user_id,
> t8.starttime, t8.status, t8.time_zone_id, t8.type, t8.updatetime,
> t8.user_offers, t8.user_searchs, t0.is_reminder_email_send, t9.id,
> t9.allow_font_styles, t9.allow_recording, t9.allow_user_questions,
> t9.appointment, t9.auto_video_select, t9.chat_moderated, t9.chat_opened,
> t9.comment_field, t9.confno, t9.deleted, t9.demo_time, t9.externalRoomId,
> t9.externalRoomType, t9.files_opened, t9.hide_actions_menu,
> t9.hide_activities_and_actions, t9.hide_chat, t9.hide_files_explorer,
> t9.hide_screen_sharing, t9.hide_top_bar, t9.hide_whiteboard,
> t9.is_audio_only, t9.is_closed, t9.isdemoroom, t9.ismoderatedroom,
> t9.ispublic, t9.name, t9.numberOfPartizipants, t9.owner_id, t9.pin,
> t9.redirect_url, t9.roomtypes_id, t9.show_microphone_status,
> t9.sip_enabled, t9.starttime, t9.updatetime, t9.wait_for_recording,
> t0.appointment_starttime, t0.appointmentname, t0.updatetime FROM
> appointments t0 LEFT OUTER JOIN appointmentcategory t1 ON t0.category_id =
> t1.id LEFT OUTER JOIN om_user t6 ON t0.user_id = t6.id LEFT OUTER JOIN
> appointmentremindertyps t7 ON t0.remind_id = t7.id LEFT OUTER JOIN room
> t9 ON t0.room_id = t9.id LEFT OUTER JOIN om_user t2 ON t1.user_id = t2.id
> LEFT OUTER JOIN om_user t8 ON t7.user_id = t8.id LEFT OUTER JOIN address
> t3 ON t2.adresses_id = t3.id LEFT OUTER JOIN sipusers t5 ON
> t2.sip_user_id = t5.id LEFT OUTER JOIN state t4 ON t3.state_id = t4.id
> WHERE (t0.deleted = ? AND t0.is_reminder_email_send = ? AND (t0.remind_id =
> ? OR t0.remind_id = ?) AND (t0.appointment_starttime >= ? AND
> t0.appointment_starttime <= ? OR t0.appointment_endtime >= ? AND
> t0.appointment_endtime <= ? OR t0.appointment_starttime < ? AND
> t0.appointment_endtime > ?))} [code=1146, state=42S02]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>
> -----------------------------------------------------------------------------------
>
> I dont exacly know why this table is not there. Installation didnt give
> any problem. How can I fix this one?
>
> Kind regards,
> Tamer Ataol
>
>
>
> Murat Tamer Ataol
> Sistem Yönetimi Daire Başkanlığı
>
> Sağlık Bakanlığı
> Sağlık Bilgi sistemleri Genel Müdürlüğü
> Mithatpaşa Cad. No:3 Çankaya / Ankara
>
> Yasal Uyarı :
> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
> Şartlar dokümanına tabidir :
> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>
> ------------------------------
> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
> *Gönderildi:* 25 Ağustos 2014 Pazartesi 11:26
> *Kime:* user@openmeetings.apache.org
> *Konu:* Re: Openmeetings problem
>
> Hello Tamer Ataol,
>
> Please check log files in the log directory.
>
> Thanks,
> Vasiliy
>
>
> On 25.08.2014 15:22, Murat Tamer Ataol wrote:
>
> Hello,
>
> I have a problem after installation. Installation completes ok. After that
> when I hit the "Enter the Application" link notinited page comes. I tried
> writing localhost:5080/openmeetings on the address bar. It didnt work. I
> couldnt find how to come to login page. Login page never comes.
>
> Can you be of any help?
>
> Kind regards,
> Tamer Ataol
>
>
>
> Murat Tamer Ataol
> Sistem Yönetimi Daire Başkanlığı
>
> Sağlık Bakanlığı
> Sağlık Bilgi sistemleri Genel Müdürlüğü
> Mithatpaşa Cad. No:3 Çankaya / Ankara
>
> Yasal Uyarı :
> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
> Şartlar dokümanına tabidir :
> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>
>
>
>
> ------------------------------
>
> YASAL UYARI:
> Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere) gizlidir.
> T.C. Sağlık Bakanlığı onayı olmaksızın içeriği kopyalanamaz, üçüncü
> kişilere açıklanamaz veya iletilemez . Bu mesajın gönderilmek istendiği
> kişi değilseniz (ya da bu e-posta'yı yanlışlıkla aldıysanız), lütfen
> yollayan kişiyi haberdar ediniz ve mesajı sisteminizden derhal siliniz.
> T.C. Sağlık Bakanlığı bu mesajın içerdiği bilgilerin doğruluğu veya
> eksiksiz olduğu konusunda bir garanti vermemektedir. Bu nedenle, bilgilerin
> ne şekilde olursa olsun içeriğinden, iletilmesinden, alınmasından,
> saklanmasından T.C. sağlık Bakanlığı sorumlu değildir. Bu mesajın içeriği
> yazarına ait olup, T.C. Sağlık Bakanlığı görüşlerini içermeyebilir.
>
> Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır.
>
> DISCLAIMER:
> This e-mail (including any attachments) may contain confidential and/or
> privileged information. Copying, disclosure or distribution of the material
> in this e-mail without The Ministry of Health of Turkey's authority is
> strictly forbidden. If you are not the intended recipient (or have received
> this e-mail in error), please notify the sender and delete it from your
> system immediately. The Ministry of Health of Turkey makes no warranty as
> to the accuracy or completeness of any information contained in this
> message and hereby excludes any liability of any kind for the information
> contained therein or for the information transmission, reception, storage
> or use of such in any way whatsoever. Any opinions expressed in this
> message are those of the author and may not necessarily reflect the
> opinions of The Ministry of Health of Turkey.
>
> This e-mail has been scanned for all computer viruses known to us.
> ------------------------------
>
>
>
>
>
>
>
>
--
WBR
Maxim aka solomax
Re: YNT: YNT: YNT: YNT: YNT: Openmeetings problem
Posted by Vasiliy Degtyarev <va...@unipro.ru>.
Also i found the next error:
ERROR 08-25 12:22:43.880 o.a.o.w.c.ErrorMessagePanel:38
[http-nio-0.0.0.0-5080-exec-1] - Error while running installer, please
check your installation
org.dom4j.DocumentException: languages/languages.xml (No such file or
directory) Nested exception: languages/languages.xml (No such file or
directory)
What language you select while installing OM?
On 25.08.2014 19:17, Murat Tamer Ataol wrote:
> If this is a connection failure to the database, how can I fix it? Any
> suggestions?
>
> Murat Tamer Ataol
> Sistem Yönetimi Daire Başkanlığı
>
> Sağlık Bakanlığı
> Sağlık Bilgi sistemleri Genel Müdürlüğü
> Mithatpaşa Cad. No:3 Çankaya / Ankara
>
> Yasal Uyarı :
> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
> Şartlar dokümanına tabidir :
> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>
> ------------------------------------------------------------------------
> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
> *Gönderildi:* 25 Ağustos 2014 Pazartesi 14:32
> *Kime:* user@openmeetings.apache.org
> *Konu:* Re: YNT: YNT: YNT: YNT: Openmeetings problem
>
> I suppose that this is problem of connection to openmeetins database:
>
> ERROR 08-25 12:22:50.369 o.a.o.r.r.ScopeApplicationAdapter:151
> [Launcher:/openmeetings] - [appStart]
> org.springframework.transaction.CannotCreateTransactionException:
> Could not open JPA EntityManager for transaction; nested exception is
> <openjpa-2.2.2-r422266:1468616 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Communications
> link failure
>
> Vasiliy
>
>
>
>
> On 25.08.2014 18:10, Murat Tamer Ataol wrote:
>> Here are the log files. error.log has 0 bytes in it. So there is no
>> error in the error.log.
>>
>> Murat Tamer Ataol
>> Sistem Yönetimi Daire Başkanlığı
>>
>> Sağlık Bakanlığı
>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>
>> Yasal Uyarı :
>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>> Şartlar dokümanına tabidir :
>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>
>> ------------------------------------------------------------------------
>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 13:23
>> *Kime:* user@openmeetings.apache.org
>> *Konu:* Re: YNT: YNT: YNT: Openmeetings problem
>>
>> Please send log files.
>>
>>
>>
>> On 25.08.2014 16:26, Murat Tamer Ataol wrote:
>>> I did what you said to create database and reinstalled the
>>> application. Still appoinments table is not there. Same message
>>> appears in the log and the login screen doesnt come.
>>>
>>> Murat Tamer Ataol
>>> Sistem Yönetimi Daire Başkanlığı
>>>
>>> Sağlık Bakanlığı
>>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>>
>>> Yasal Uyarı :
>>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>>> Şartlar dokümanına tabidir :
>>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>>
>>> ------------------------------------------------------------------------
>>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 12:10
>>> *Kime:* user@openmeetings.apache.org
>>> *Konu:* Re: YNT: YNT: Openmeetings problem
>>>
>>> You should not create tables, you should create database use this
>>> command:
>>> CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
>>>
>>> If you update openmeeting you should make backup and import.
>>>
>>> Thanks,
>>> Vasiliy
>>>
>>>
>>> On 25.08.2014 16:02, Murat Tamer Ataol wrote:
>>>> I am following the Installation of Apache OpenMeetings 2.x or 3.x
>>>> in CentOS 6.5 guide from cwiki.apache.org.
>>>>
>>>> I am not creating the tables by myself. Installation did that. And
>>>> there were no errors in the installation.
>>>>
>>>>
>>>> Murat Tamer Ataol
>>>> Sistem Yönetimi Daire Başkanlığı
>>>>
>>>> Sağlık Bakanlığı
>>>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>>>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>>>
>>>> Yasal Uyarı :
>>>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>>>> Şartlar dokümanına tabidir :
>>>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>>>
>>>> ------------------------------------------------------------------------
>>>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>>>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 11:50
>>>> *Kime:* user@openmeetings.apache.org
>>>> *Konu:* Re: YNT: Openmeetings problem
>>>>
>>>> What sql server you use?
>>>> What command you use to create openmeetings database.
>>>>
>>>> Please send full log files.
>>>>
>>>> Vasiliy
>>>>
>>>> On 25.08.2014 15:38, Murat Tamer Ataol wrote:
>>>>> Hello,
>>>>>
>>>>> I checked the log files. There is one error in openmeetings.log.
>>>>> ----------------------------------------------------------------------------------------
>>>>> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException:
>>>>> Table 'openmeetings.appointments' doesn't exist {prepstmnt
>>>>> 641714439 SELECT t0.id, t1.id, t1.comment_field, t1.deleted,
>>>>> t1.name, t1.starttime, t1.updatetime, t2.id, t2.activatehash,
>>>>> t3.id, t3.additionalname, t3.comment_field, t3.deleted, t3.email,
>>>>> t3.fax, t3.phone, t3.starttime, t4.id, t4.code, t4.deleted,
>>>>> t4.name, t4.shortName, t4.starttime, t4.updatetime, t3.street,
>>>>> t3.town, t3.updatetime, t3.zip, t2.age, t2.availible, t2.deleted,
>>>>> t2.externalUserId, t2.externalUserType, t2.firstname,
>>>>> t2.forceTimeZoneCheck, t2.language_id, t2.lastlogin, t2.lastname,
>>>>> t2.lasttrans, t2.level_id, t2.login, t2.owner_id, t2.pictureuri,
>>>>> t2.regdate, t2.resethash, t2.salutations_id, t2.sendSMS,
>>>>> t2.show_contact_data, t2.show_contact_data_to_contacts, t5.id,
>>>>> t5.allow, t5.callbackextension, t5.context, t5.defaultuser,
>>>>> t5.fullcontact, t5.host, t5.ipaddr, t5.lastms, t5.md5secret,
>>>>> t5.name, t5.nat, t5.port, t5.regseconds, t5.regserver, t5.secret,
>>>>> t5.type, t5.useragent, t2.starttime, t2.status, t2.time_zone_id,
>>>>> t2.type, t2.updatetime, t2.user_offers, t2.user_searchs,
>>>>> t0.is_connected_event, t0.deleted, t0.description,
>>>>> t0.appointment_endtime, t0.icalId, t0.starttime, t0.isdaily,
>>>>> t0.ismonthly, t0.isweekly, t0.isyearly, t0.language_id,
>>>>> t0.location, t6.id, t6.activatehash, t6.adresses_id, t6.age,
>>>>> t6.availible, t6.deleted, t6.externalUserId, t6.externalUserType,
>>>>> t6.firstname, t6.forceTimeZoneCheck, t6.language_id, t6.lastlogin,
>>>>> t6.lastname, t6.lasttrans, t6.level_id, t6.login, t6.owner_id,
>>>>> t6.pictureuri, t6.regdate, t6.resethash, t6.salutations_id,
>>>>> t6.sendSMS, t6.show_contact_data,
>>>>> t6.show_contact_data_to_contacts, t6.sip_user_id, t6.starttime,
>>>>> t6.status, t6.time_zone_id, t6.type, t6.updatetime,
>>>>> t6.user_offers, t6.user_searchs, t0.password,
>>>>> t0.is_password_protected, t7.id, t7.deleted, t7.fieldvalues_id,
>>>>> t7.name, t7.starttime, t7.updatetime, t8.id, t8.activatehash,
>>>>> t8.adresses_id, t8.age, t8.availible, t8.deleted,
>>>>> t8.externalUserId, t8.externalUserType, t8.firstname,
>>>>> t8.forceTimeZoneCheck, t8.language_id, t8.lastlogin, t8.lastname,
>>>>> t8.lasttrans, t8.level_id, t8.login, t8.owner_id, t8.pictureuri,
>>>>> t8.regdate, t8.resethash, t8.salutations_id, t8.sendSMS,
>>>>> t8.show_contact_data, t8.show_contact_data_to_contacts,
>>>>> t8.sip_user_id, t8.starttime, t8.status, t8.time_zone_id, t8.type,
>>>>> t8.updatetime, t8.user_offers, t8.user_searchs,
>>>>> t0.is_reminder_email_send, t9.id, t9.allow_font_styles,
>>>>> t9.allow_recording, t9.allow_user_questions, t9.appointment,
>>>>> t9.auto_video_select, t9.chat_moderated, t9.chat_opened,
>>>>> t9.comment_field, t9.confno, t9.deleted, t9.demo_time,
>>>>> t9.externalRoomId, t9.externalRoomType, t9.files_opened,
>>>>> t9.hide_actions_menu, t9.hide_activities_and_actions,
>>>>> t9.hide_chat, t9.hide_files_explorer, t9.hide_screen_sharing,
>>>>> t9.hide_top_bar, t9.hide_whiteboard, t9.is_audio_only,
>>>>> t9.is_closed, t9.isdemoroom, t9.ismoderatedroom, t9.ispublic,
>>>>> t9.name, t9.numberOfPartizipants, t9.owner_id, t9.pin,
>>>>> t9.redirect_url, t9.roomtypes_id, t9.show_microphone_status,
>>>>> t9.sip_enabled, t9.starttime, t9.updatetime,
>>>>> t9.wait_for_recording, t0.appointment_starttime,
>>>>> t0.appointmentname, t0.updatetime FROM appointments t0 LEFT OUTER
>>>>> JOIN appointmentcategory t1 ON t0.category_id = t1.id LEFT OUTER
>>>>> JOIN om_user t6 ON t0.user_id = t6.id LEFT OUTER JOIN
>>>>> appointmentremindertyps t7 ON t0.remind_id = t7.id LEFT OUTER JOIN
>>>>> room t9 ON t0.room_id = t9.id LEFT OUTER JOIN om_user t2 ON
>>>>> t1.user_id = t2.id LEFT OUTER JOIN om_user t8 ON t7.user_id =
>>>>> t8.id LEFT OUTER JOIN address t3 ON t2.adresses_id = t3.id LEFT
>>>>> OUTER JOIN sipusers t5 ON t2.sip_user_id = t5.id LEFT OUTER JOIN
>>>>> state t4 ON t3.state_id = t4.id WHERE (t0.deleted = ? AND
>>>>> t0.is_reminder_email_send = ? AND (t0.remind_id = ? OR
>>>>> t0.remind_id = ?) AND (t0.appointment_starttime >= ? AND
>>>>> t0.appointment_starttime <= ? OR t0.appointment_endtime >= ? AND
>>>>> t0.appointment_endtime <= ? OR t0.appointment_starttime < ? AND
>>>>> t0.appointment_endtime > ?))} [code=1146, state=42S02]
>>>>> at
>>>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
>>>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>>>> at
>>>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203)
>>>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>>>> at
>>>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59)
>>>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>>>> at
>>>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118)
>>>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>>>> at
>>>>> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268)
>>>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>>>> -----------------------------------------------------------------------------------
>>>>>
>>>>> I dont exacly know why this table is not there. Installation didnt
>>>>> give any problem. How can I fix this one?
>>>>>
>>>>> Kind regards,
>>>>> Tamer Ataol
>>>>>
>>>>> Murat Tamer Ataol
>>>>> Sistem Yönetimi Daire Başkanlığı
>>>>>
>>>>> Sağlık Bakanlığı
>>>>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>>>>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>>>>
>>>>> Yasal Uyarı :
>>>>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul
>>>>> ve Şartlar dokümanına tabidir :
>>>>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>>>>
>>>>> ------------------------------------------------------------------------
>>>>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>>>>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 11:26
>>>>> *Kime:* user@openmeetings.apache.org
>>>>> *Konu:* Re: Openmeetings problem
>>>>>
>>>>> Hello Tamer Ataol,
>>>>>
>>>>> Please check log files in the log directory.
>>>>>
>>>>> Thanks,
>>>>> Vasiliy
>>>>>
>>>>>
>>>>> On 25.08.2014 15:22, Murat Tamer Ataol wrote:
>>>>>> Hello,
>>>>>>
>>>>>> I have a problem after installation. Installation completes ok.
>>>>>> After that when I hit the "Enter the Application" link notinited
>>>>>> page comes. I tried writing localhost:5080/openmeetings on the
>>>>>> address bar. It didnt work. I couldnt find how to come to login
>>>>>> page. Login page never comes.
>>>>>>
>>>>>> Can you be of any help?
>>>>>>
>>>>>> Kind regards,
>>>>>> Tamer Ataol
>>>>>>
>>>>>> Murat Tamer Ataol
>>>>>> Sistem Yönetimi Daire Başkanlığı
>>>>>>
>>>>>> Sağlık Bakanlığı
>>>>>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>>>>>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>>>>>
>>>>>> Yasal Uyarı :
>>>>>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul
>>>>>> ve Şartlar dokümanına tabidir :
>>>>>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>>>>>
>>>>>> ------------------------------------------------------------------------
>>>>>>
>>>>>> YASAL UYARI:
>>>>>> Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere)
>>>>>> gizlidir. T.C. Sağlık Bakanlığı onayı olmaksızın içeriği
>>>>>> kopyalanamaz, üçüncü kişilere açıklanamaz veya iletilemez . Bu
>>>>>> mesajın gönderilmek istendiği kişi değilseniz (ya da bu
>>>>>> e-posta'yı yanlışlıkla aldıysanız), lütfen yollayan kişiyi
>>>>>> haberdar ediniz ve mesajı sisteminizden derhal siliniz. T.C.
>>>>>> Sağlık Bakanlığı bu mesajın içerdiği bilgilerin doğruluğu veya
>>>>>> eksiksiz olduğu konusunda bir garanti vermemektedir. Bu nedenle,
>>>>>> bilgilerin ne şekilde olursa olsun içeriğinden, iletilmesinden,
>>>>>> alınmasından, saklanmasından T.C. sağlık Bakanlığı sorumlu
>>>>>> değildir. Bu mesajın içeriği yazarına ait olup, T.C. Sağlık
>>>>>> Bakanlığı görüşlerini içermeyebilir.
>>>>>>
>>>>>> Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı
>>>>>> taranmıştır.
>>>>>>
>>>>>> DISCLAIMER:
>>>>>> This e-mail (including any attachments) may contain confidential
>>>>>> and/or privileged information. Copying, disclosure or
>>>>>> distribution of the material in this e-mail without The Ministry
>>>>>> of Health of Turkey's authority is strictly forbidden. If you are
>>>>>> not the intended recipient (or have received this e-mail in
>>>>>> error), please notify the sender and delete it from your system
>>>>>> immediately. The Ministry of Health of Turkey makes no warranty
>>>>>> as to the accuracy or completeness of any information contained
>>>>>> in this message and hereby excludes any liability of any kind for
>>>>>> the information contained therein or for the information
>>>>>> transmission, reception, storage or use of such in any way
>>>>>> whatsoever. Any opinions expressed in this message are those of
>>>>>> the author and may not necessarily reflect the opinions of The
>>>>>> Ministry of Health of Turkey.
>>>>>>
>>>>>> This e-mail has been scanned for all computer viruses known to us.
>>>>>>
>>>>>> ------------------------------------------------------------------------
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
Re: YNT: YNT: YNT: YNT: Openmeetings problem
Posted by Maxim Solodovnik <so...@gmail.com>.
were you using command line or web installer after unpacking?
Have you dropped and re-created old DB before running OM?
On 25 August 2014 20:03, Murat Tamer Ataol <Ta...@saglik.gov.tr>
wrote:
> Thank you for all your answers, I switched back to openmeetings 2.2.0
> and the installation was successful.
>
> There may be a bug in openmeetings 3.0.2.
>
> The link I have downloaded it from is
>
> http://www.eu.apache.org/dist/openmeetings/3.0.2/bin/
>
>
>
>
> Murat Tamer Ataol
> Sistem Yönetimi Daire Başkanlığı
>
> Sağlık Bakanlığı
> Sağlık Bilgi sistemleri Genel Müdürlüğü
> Mithatpaşa Cad. No:3 Çankaya / Ankara
>
> Yasal Uyarı :
> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
> Şartlar dokümanına tabidir :
> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>
> ------------------------------
> *Kimden:* Maxim Solodovnik [solomax666@gmail.com]
> *Gönderildi:* 25 Ağustos 2014 Pazartesi 15:50
> *Kime:* Openmeetings user-list
> *Konu:* Re: YNT: YNT: YNT: YNT: Openmeetings problem
>
> your installation was not successful
> could you please share the link you were using to download OM?
>
>
> On 25 August 2014 19:43, Murat Tamer Ataol <Ta...@saglik.gov.tr>
> wrote:
>
>> DB server is up and running. It is creating 48 tables out of 49 in the
>> install. mysql*.jar file is there. Telnet is connecting from 3306. I have
>> the line in the persistence.xml.
>>
>> I am installing the default language (english).
>>
>> Is there anything else I should check for. By the way I reinstalled
>> openmeetings and it gives exacly the same error.
>>
>>
>>
>>
>>
>> Murat Tamer Ataol
>> Sistem Yönetimi Daire Başkanlığı
>>
>> Sağlık Bakanlığı
>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>
>> Yasal Uyarı :
>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>> Şartlar dokümanına tabidir :
>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>
>> ------------------------------
>> *Kimden:* Maxim Solodovnik [solomax666@gmail.com]
>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 15:32
>> *Kime:* Openmeetings user-list
>> *Konu:* Re: YNT: YNT: YNT: YNT: Openmeetings problem
>>
>> first of all check if DB server is up and you able to connect it
>> in your persistence.xml you have the line:
>> *Url=jdbc:mysql://your_server:3306/openmeetings*
>>
>> start terminal and type:
>> *telnet* *your_server 3306*
>>
>> if connection is successful then check if mysql*jar driver is present
>> in webapps/WEB-INF/lib folder
>>
>>
>>
>> On 25 August 2014 19:17, Murat Tamer Ataol <Ta...@saglik.gov.tr>
>> wrote:
>>
>>> If this is a connection failure to the database, how can I fix it?
>>> Any suggestions?
>>>
>>>
>>>
>>> Murat Tamer Ataol
>>> Sistem Yönetimi Daire Başkanlığı
>>>
>>> Sağlık Bakanlığı
>>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>>
>>> Yasal Uyarı :
>>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>>> Şartlar dokümanına tabidir :
>>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>>
>>> ------------------------------
>>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 14:32
>>> *Kime:* user@openmeetings.apache.org
>>> *Konu:* Re: YNT: YNT: YNT: YNT: Openmeetings problem
>>>
>>> I suppose that this is problem of connection to openmeetins database:
>>>
>>> ERROR 08-25 12:22:50.369 o.a.o.r.r.ScopeApplicationAdapter:151
>>> [Launcher:/openmeetings] - [appStart]
>>> org.springframework.transaction.CannotCreateTransactionException: Could
>>> not open JPA EntityManager for transaction; nested exception is
>>> <openjpa-2.2.2-r422266:1468616 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Communications link
>>> failure
>>>
>>> Vasiliy
>>>
>>>
>>>
>>>
>>> On 25.08.2014 18:10, Murat Tamer Ataol wrote:
>>>
>>> Here are the log files. error.log has 0 bytes in it. So there is no
>>> error in the error.log.
>>>
>>>
>>>
>>> Murat Tamer Ataol
>>> Sistem Yönetimi Daire Başkanlığı
>>>
>>> Sağlık Bakanlığı
>>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>>
>>> Yasal Uyarı :
>>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>>> Şartlar dokümanına tabidir :
>>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>>
>>> ------------------------------
>>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 13:23
>>> *Kime:* user@openmeetings.apache.org
>>> *Konu:* Re: YNT: YNT: YNT: Openmeetings problem
>>>
>>> Please send log files.
>>>
>>>
>>>
>>> On 25.08.2014 16:26, Murat Tamer Ataol wrote:
>>>
>>> I did what you said to create database and reinstalled the application.
>>> Still appoinments table is not there. Same message appears in the log and
>>> the login screen doesnt come.
>>>
>>>
>>>
>>> Murat Tamer Ataol
>>> Sistem Yönetimi Daire Başkanlığı
>>>
>>> Sağlık Bakanlığı
>>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>>
>>> Yasal Uyarı :
>>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>>> Şartlar dokümanına tabidir :
>>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>>
>>> ------------------------------
>>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 12:10
>>> *Kime:* user@openmeetings.apache.org
>>> *Konu:* Re: YNT: YNT: Openmeetings problem
>>>
>>> You should not create tables, you should create database use this
>>> command:
>>> CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
>>>
>>> If you update openmeeting you should make backup and import.
>>>
>>> Thanks,
>>> Vasiliy
>>>
>>>
>>> On 25.08.2014 16:02, Murat Tamer Ataol wrote:
>>>
>>> I am following the Installation of Apache OpenMeetings 2.x or 3.x in
>>> CentOS 6.5 guide from cwiki.apache.org.
>>>
>>> I am not creating the tables by myself. Installation did that. And there
>>> were no errors in the installation.
>>>
>>>
>>>
>>>
>>> Murat Tamer Ataol
>>> Sistem Yönetimi Daire Başkanlığı
>>>
>>> Sağlık Bakanlığı
>>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>>
>>> Yasal Uyarı :
>>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>>> Şartlar dokümanına tabidir :
>>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>>
>>> ------------------------------
>>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 11:50
>>> *Kime:* user@openmeetings.apache.org
>>> *Konu:* Re: YNT: Openmeetings problem
>>>
>>> What sql server you use?
>>> What command you use to create openmeetings database.
>>>
>>> Please send full log files.
>>>
>>> Vasiliy
>>>
>>> On 25.08.2014 15:38, Murat Tamer Ataol wrote:
>>>
>>> Hello,
>>>
>>> I checked the log files. There is one error in openmeetings.log.
>>>
>>> ----------------------------------------------------------------------------------------
>>> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table
>>> 'openmeetings.appointments' doesn't exist {prepstmnt 641714439 SELECT
>>> t0.id, t1.id, t1.comment_field, t1.deleted, t1.name, t1.starttime,
>>> t1.updatetime, t2.id, t2.activatehash, t3.id, t3.additionalname,
>>> t3.comment_field, t3.deleted, t3.email, t3.fax, t3.phone, t3.starttime,
>>> t4.id, t4.code, t4.deleted, t4.name, t4.shortName, t4.starttime,
>>> t4.updatetime, t3.street, t3.town, t3.updatetime, t3.zip, t2.age,
>>> t2.availible, t2.deleted, t2.externalUserId, t2.externalUserType,
>>> t2.firstname, t2.forceTimeZoneCheck, t2.language_id, t2.lastlogin,
>>> t2.lastname, t2.lasttrans, t2.level_id, t2.login, t2.owner_id,
>>> t2.pictureuri, t2.regdate, t2.resethash, t2.salutations_id, t2.sendSMS,
>>> t2.show_contact_data, t2.show_contact_data_to_contacts, t5.id,
>>> t5.allow, t5.callbackextension, t5.context, t5.defaultuser, t5.fullcontact,
>>> t5.host, t5.ipaddr, t5.lastms, t5.md5secret, t5.name, t5.nat, t5.port,
>>> t5.regseconds, t5.regserver, t5.secret, t5.type, t5.useragent,
>>> t2.starttime, t2.status, t2.time_zone_id, t2.type, t2.updatetime,
>>> t2.user_offers, t2.user_searchs, t0.is_connected_event, t0.deleted,
>>> t0.description, t0.appointment_endtime, t0.icalId, t0.starttime,
>>> t0.isdaily, t0.ismonthly, t0.isweekly, t0.isyearly, t0.language_id,
>>> t0.location, t6.id, t6.activatehash, t6.adresses_id, t6.age,
>>> t6.availible, t6.deleted, t6.externalUserId, t6.externalUserType,
>>> t6.firstname, t6.forceTimeZoneCheck, t6.language_id, t6.lastlogin,
>>> t6.lastname, t6.lasttrans, t6.level_id, t6.login, t6.owner_id,
>>> t6.pictureuri, t6.regdate, t6.resethash, t6.salutations_id, t6.sendSMS,
>>> t6.show_contact_data, t6.show_contact_data_to_contacts, t6.sip_user_id,
>>> t6.starttime, t6.status, t6.time_zone_id, t6.type, t6.updatetime,
>>> t6.user_offers, t6.user_searchs, t0.password, t0.is_password_protected,
>>> t7.id, t7.deleted, t7.fieldvalues_id, t7.name, t7.starttime,
>>> t7.updatetime, t8.id, t8.activatehash, t8.adresses_id, t8.age,
>>> t8.availible, t8.deleted, t8.externalUserId, t8.externalUserType,
>>> t8.firstname, t8.forceTimeZoneCheck, t8.language_id, t8.lastlogin,
>>> t8.lastname, t8.lasttrans, t8.level_id, t8.login, t8.owner_id,
>>> t8.pictureuri, t8.regdate, t8.resethash, t8.salutations_id, t8.sendSMS,
>>> t8.show_contact_data, t8.show_contact_data_to_contacts, t8.sip_user_id,
>>> t8.starttime, t8.status, t8.time_zone_id, t8.type, t8.updatetime,
>>> t8.user_offers, t8.user_searchs, t0.is_reminder_email_send, t9.id,
>>> t9.allow_font_styles, t9.allow_recording, t9.allow_user_questions,
>>> t9.appointment, t9.auto_video_select, t9.chat_moderated, t9.chat_opened,
>>> t9.comment_field, t9.confno, t9.deleted, t9.demo_time, t9.externalRoomId,
>>> t9.externalRoomType, t9.files_opened, t9.hide_actions_menu,
>>> t9.hide_activities_and_actions, t9.hide_chat, t9.hide_files_explorer,
>>> t9.hide_screen_sharing, t9.hide_top_bar, t9.hide_whiteboard,
>>> t9.is_audio_only, t9.is_closed, t9.isdemoroom, t9.ismoderatedroom,
>>> t9.ispublic, t9.name, t9.numberOfPartizipants, t9.owner_id, t9.pin,
>>> t9.redirect_url, t9.roomtypes_id, t9.show_microphone_status,
>>> t9.sip_enabled, t9.starttime, t9.updatetime, t9.wait_for_recording,
>>> t0.appointment_starttime, t0.appointmentname, t0.updatetime FROM
>>> appointments t0 LEFT OUTER JOIN appointmentcategory t1 ON t0.category_id =
>>> t1.id LEFT OUTER JOIN om_user t6 ON t0.user_id = t6.id LEFT OUTER JOIN
>>> appointmentremindertyps t7 ON t0.remind_id = t7.id LEFT OUTER JOIN room
>>> t9 ON t0.room_id = t9.id LEFT OUTER JOIN om_user t2 ON t1.user_id =
>>> t2.id LEFT OUTER JOIN om_user t8 ON t7.user_id = t8.id LEFT OUTER JOIN
>>> address t3 ON t2.adresses_id = t3.id LEFT OUTER JOIN sipusers t5 ON
>>> t2.sip_user_id = t5.id LEFT OUTER JOIN state t4 ON t3.state_id = t4.id
>>> WHERE (t0.deleted = ? AND t0.is_reminder_email_send = ? AND (t0.remind_id =
>>> ? OR t0.remind_id = ?) AND (t0.appointment_starttime >= ? AND
>>> t0.appointment_starttime <= ? OR t0.appointment_endtime >= ? AND
>>> t0.appointment_endtime <= ? OR t0.appointment_starttime < ? AND
>>> t0.appointment_endtime > ?))} [code=1146, state=42S02]
>>> at
>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>> at
>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203)
>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>> at
>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59)
>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>> at
>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118)
>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>> at
>>> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268)
>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>>
>>> -----------------------------------------------------------------------------------
>>>
>>> I dont exacly know why this table is not there. Installation didnt give
>>> any problem. How can I fix this one?
>>>
>>> Kind regards,
>>> Tamer Ataol
>>>
>>>
>>>
>>> Murat Tamer Ataol
>>> Sistem Yönetimi Daire Başkanlığı
>>>
>>> Sağlık Bakanlığı
>>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>>
>>> Yasal Uyarı :
>>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>>> Şartlar dokümanına tabidir :
>>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>>
>>> ------------------------------
>>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 11:26
>>> *Kime:* user@openmeetings.apache.org
>>> *Konu:* Re: Openmeetings problem
>>>
>>> Hello Tamer Ataol,
>>>
>>> Please check log files in the log directory.
>>>
>>> Thanks,
>>> Vasiliy
>>>
>>>
>>> On 25.08.2014 15:22, Murat Tamer Ataol wrote:
>>>
>>> Hello,
>>>
>>> I have a problem after installation. Installation completes ok. After
>>> that when I hit the "Enter the Application" link notinited page comes. I
>>> tried writing localhost:5080/openmeetings on the address bar. It didnt
>>> work. I couldnt find how to come to login page. Login page never comes.
>>>
>>> Can you be of any help?
>>>
>>> Kind regards,
>>> Tamer Ataol
>>>
>>>
>>>
>>> Murat Tamer Ataol
>>> Sistem Yönetimi Daire Başkanlığı
>>>
>>> Sağlık Bakanlığı
>>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>>
>>> Yasal Uyarı :
>>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>>> Şartlar dokümanına tabidir :
>>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>>
>>>
>>>
>>>
>>> ------------------------------
>>>
>>> YASAL UYARI:
>>> Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere) gizlidir.
>>> T.C. Sağlık Bakanlığı onayı olmaksızın içeriği kopyalanamaz, üçüncü
>>> kişilere açıklanamaz veya iletilemez . Bu mesajın gönderilmek istendiği
>>> kişi değilseniz (ya da bu e-posta'yı yanlışlıkla aldıysanız), lütfen
>>> yollayan kişiyi haberdar ediniz ve mesajı sisteminizden derhal siliniz.
>>> T.C. Sağlık Bakanlığı bu mesajın içerdiği bilgilerin doğruluğu veya
>>> eksiksiz olduğu konusunda bir garanti vermemektedir. Bu nedenle, bilgilerin
>>> ne şekilde olursa olsun içeriğinden, iletilmesinden, alınmasından,
>>> saklanmasından T.C. sağlık Bakanlığı sorumlu değildir. Bu mesajın içeriği
>>> yazarına ait olup, T.C. Sağlık Bakanlığı görüşlerini içermeyebilir.
>>>
>>> Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır.
>>>
>>> DISCLAIMER:
>>> This e-mail (including any attachments) may contain confidential and/or
>>> privileged information. Copying, disclosure or distribution of the material
>>> in this e-mail without The Ministry of Health of Turkey's authority is
>>> strictly forbidden. If you are not the intended recipient (or have received
>>> this e-mail in error), please notify the sender and delete it from your
>>> system immediately. The Ministry of Health of Turkey makes no warranty as
>>> to the accuracy or completeness of any information contained in this
>>> message and hereby excludes any liability of any kind for the information
>>> contained therein or for the information transmission, reception, storage
>>> or use of such in any way whatsoever. Any opinions expressed in this
>>> message are those of the author and may not necessarily reflect the
>>> opinions of The Ministry of Health of Turkey.
>>>
>>> This e-mail has been scanned for all computer viruses known to us.
>>> ------------------------------
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>>
>>
>>
>
>
> --
> WBR
> Maxim aka solomax
>
>
>
>
--
WBR
Maxim aka solomax
YNT: YNT: YNT: YNT: YNT: Openmeetings problem
Posted by Murat Tamer Ataol <Ta...@saglik.gov.tr>.
Thank you for all your answers, I switched back to openmeetings 2.2.0 and the installation was successful.
There may be a bug in openmeetings 3.0.2.
The link I have downloaded it from is
http://www.eu.apache.org/dist/openmeetings/3.0.2/bin/
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:image99db2c.JPG@81eedd4a.42bdae6e]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Maxim Solodovnik [solomax666@gmail.com]
Gönderildi: 25 Ağustos 2014 Pazartesi 15:50
Kime: Openmeetings user-list
Konu: Re: YNT: YNT: YNT: YNT: Openmeetings problem
your installation was not successful
could you please share the link you were using to download OM?
On 25 August 2014 19:43, Murat Tamer Ataol <Ta...@saglik.gov.tr>> wrote:
DB server is up and running. It is creating 48 tables out of 49 in the install. mysql*.jar file is there. Telnet is connecting from 3306. I have the line in the persistence.xml.
I am installing the default language (english).
Is there anything else I should check for. By the way I reinstalled openmeetings and it gives exacly the same error.
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:imageb426dd.JPG@75ced64c.4aa25054]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Maxim Solodovnik [solomax666@gmail.com<ma...@gmail.com>]
Gönderildi: 25 Ağustos 2014 Pazartesi 15:32
Kime: Openmeetings user-list
Konu: Re: YNT: YNT: YNT: YNT: Openmeetings problem
first of all check if DB server is up and you able to connect it
in your persistence.xml you have the line: Url=jdbc:mysql://your_server:3306/openmeetings
start terminal and type:
telnet your_server 3306
if connection is successful then check if mysql*jar driver is present in webapps/WEB-INF/lib folder
On 25 August 2014 19:17, Murat Tamer Ataol <Ta...@saglik.gov.tr>> wrote:
If this is a connection failure to the database, how can I fix it? Any suggestions?
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:image8520a5.JPG@513316a0.4d9d4dbe]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 14:32
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: YNT: YNT: YNT: YNT: Openmeetings problem
I suppose that this is problem of connection to openmeetins database:
ERROR 08-25 12:22:50.369 o.a.o.r.r.ScopeApplicationAdapter:151 [Launcher:/openmeetings] - [appStart]
org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is <openjpa-2.2.2-r422266:1468616 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Communications link failure
Vasiliy
On 25.08.2014 18:10, Murat Tamer Ataol wrote:
Here are the log files. error.log has 0 bytes in it. So there is no error in the error.log.
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part1.01020801.06070201@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 13:23
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: YNT: YNT: YNT: Openmeetings problem
Please send log files.
On 25.08.2014 16:26, Murat Tamer Ataol wrote:
I did what you said to create database and reinstalled the application. Still appoinments table is not there. Same message appears in the log and the login screen doesnt come.
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part3.05040906.06050305@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 12:10
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: YNT: YNT: Openmeetings problem
You should not create tables, you should create database use this command:
CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
If you update openmeeting you should make backup and import.
Thanks,
Vasiliy
On 25.08.2014 16:02, Murat Tamer Ataol wrote:
I am following the Installation of Apache OpenMeetings 2.x or 3.x in CentOS 6.5 guide from cwiki.apache.org<http://cwiki.apache.org>.
I am not creating the tables by myself. Installation did that. And there were no errors in the installation.
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part7.06020707.06040506@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 11:50
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: YNT: Openmeetings problem
What sql server you use?
What command you use to create openmeetings database.
Please send full log files.
Vasiliy
On 25.08.2014 15:38, Murat Tamer Ataol wrote:
Hello,
I checked the log files. There is one error in openmeetings.log.
----------------------------------------------------------------------------------------
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'openmeetings.appointments' doesn't exist {prepstmnt 641714439 SELECT t0.id<http://t0.id>, t1.id<http://t1.id>, t1.comment_field, t1.deleted, t1.name<http://t1.name>, t1.starttime, t1.updatetime, t2.id<http://t2.id>, t2.activatehash, t3.id<http://t3.id>, t3.additionalname, t3.comment_field, t3.deleted, t3.email, t3.fax, t3.phone, t3.starttime, t4.id<http://t4.id>, t4.code, t4.deleted, t4.name<http://t4.name>, t4.shortName, t4.starttime, t4.updatetime, t3.street, t3.town, t3.updatetime, t3.zip, t2.age, t2.availible, t2.deleted, t2.externalUserId, t2.externalUserType, t2.firstname, t2.forceTimeZoneCheck, t2.language_id, t2.lastlogin, t2.lastname, t2.lasttrans, t2.level_id, t2.login, t2.owner_id, t2.pictureuri, t2.regdate, t2.resethash, t2.salutations_id, t2.sendSMS, t2.show_contact_data, t2.show_contact_data_to_contacts, t5.id<http://t5.id>, t5.allow, t5.callbackextension, t5.context, t5.defaultuser, t5.fullcontact, t5.host, t5.ipaddr, t5.lastms, t5.md5secret, t5.name<http://t5.name>, t5.nat, t5.port, t5.regseconds, t5.regserver, t5.secret, t5.type, t5.useragent, t2.starttime, t2.status, t2.time_zone_id, t2.type, t2.updatetime, t2.user_offers, t2.user_searchs, t0.is_connected_event, t0.deleted, t0.description, t0.appointment_endtime, t0.icalId, t0.starttime, t0.isdaily, t0.ismonthly, t0.isweekly, t0.isyearly, t0.language_id, t0.location, t6.id<http://t6.id>, t6.activatehash, t6.adresses_id, t6.age, t6.availible, t6.deleted, t6.externalUserId, t6.externalUserType, t6.firstname, t6.forceTimeZoneCheck, t6.language_id, t6.lastlogin, t6.lastname, t6.lasttrans, t6.level_id, t6.login, t6.owner_id, t6.pictureuri, t6.regdate, t6.resethash, t6.salutations_id, t6.sendSMS, t6.show_contact_data, t6.show_contact_data_to_contacts, t6.sip_user_id, t6.starttime, t6.status, t6.time_zone_id, t6.type, t6.updatetime, t6.user_offers, t6.user_searchs, t0.password, t0.is_password_protected, t7.id<http://t7.id>, t7.deleted, t7.fieldvalues_id, t7.name<http://t7.name>, t7.starttime, t7.updatetime, t8.id<http://t8.id>, t8.activatehash, t8.adresses_id, t8.age, t8.availible, t8.deleted, t8.externalUserId, t8.externalUserType, t8.firstname, t8.forceTimeZoneCheck, t8.language_id, t8.lastlogin, t8.lastname, t8.lasttrans, t8.level_id, t8.login, t8.owner_id, t8.pictureuri, t8.regdate, t8.resethash, t8.salutations_id, t8.sendSMS, t8.show_contact_data, t8.show_contact_data_to_contacts, t8.sip_user_id, t8.starttime, t8.status, t8.time_zone_id, t8.type, t8.updatetime, t8.user_offers, t8.user_searchs, t0.is_reminder_email_send, t9.id<http://t9.id>, t9.allow_font_styles, t9.allow_recording, t9.allow_user_questions, t9.appointment, t9.auto_video_select, t9.chat_moderated, t9.chat_opened, t9.comment_field, t9.confno, t9.deleted, t9.demo_time, t9.externalRoomId, t9.externalRoomType, t9.files_opened, t9.hide_actions_menu, t9.hide_activities_and_actions, t9.hide_chat, t9.hide_files_explorer, t9.hide_screen_sharing, t9.hide_top_bar, t9.hide_whiteboard, t9.is_audio_only, t9.is_closed, t9.isdemoroom, t9.ismoderatedroom, t9.ispublic, t9.name<http://t9.name>, t9.numberOfPartizipants, t9.owner_id, t9.pin, t9.redirect_url, t9.roomtypes_id, t9.show_microphone_status, t9.sip_enabled, t9.starttime, t9.updatetime, t9.wait_for_recording, t0.appointment_starttime, t0.appointmentname, t0.updatetime FROM appointments t0 LEFT OUTER JOIN appointmentcategory t1 ON t0.category_id = t1.id<http://t1.id> LEFT OUTER JOIN om_user t6 ON t0.user_id = t6.id<http://t6.id> LEFT OUTER JOIN appointmentremindertyps t7 ON t0.remind_id = t7.id<http://t7.id> LEFT OUTER JOIN room t9 ON t0.room_id = t9.id<http://t9.id> LEFT OUTER JOIN om_user t2 ON t1.user_id = t2.id<http://t2.id> LEFT OUTER JOIN om_user t8 ON t7.user_id = t8.id<http://t8.id> LEFT OUTER JOIN address t3 ON t2.adresses_id = t3.id<http://t3.id> LEFT OUTER JOIN sipusers t5 ON t2.sip_user_id = t5.id<http://t5.id> LEFT OUTER JOIN state t4 ON t3.state_id = t4.id<http://t4.id> WHERE (t0.deleted = ? AND t0.is_reminder_email_send = ? AND (t0.remind_id = ? OR t0.remind_id = ?) AND (t0.appointment_starttime >= ? AND t0.appointment_starttime <= ? OR t0.appointment_endtime >= ? AND t0.appointment_endtime <= ? OR t0.appointment_starttime < ? AND t0.appointment_endtime > ?))} [code=1146, state=42S02]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268) ~[openjpa-bundle-2.2.2.jar:2.2.2]
-----------------------------------------------------------------------------------
I dont exacly know why this table is not there. Installation didnt give any problem. How can I fix this one?
Kind regards,
Tamer Ataol
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part11.03060603.06040904@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 11:26
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: Openmeetings problem
Hello Tamer Ataol,
Please check log files in the log directory.
Thanks,
Vasiliy
On 25.08.2014 15:22, Murat Tamer Ataol wrote:
Hello,
I have a problem after installation. Installation completes ok. After that when I hit the "Enter the Application" link notinited page comes. I tried writing localhost:5080/openmeetings on the address bar. It didnt work. I couldnt find how to come to login page. Login page never comes.
Can you be of any help?
Kind regards,
Tamer Ataol
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part15.02060303.03050508@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
YASAL UYARI:
Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere) gizlidir. T.C. Sağlık Bakanlığı onayı olmaksızın içeriği kopyalanamaz, üçüncü kişilere açıklanamaz veya iletilemez . Bu mesajın gönderilmek istendiği kişi değilseniz (ya da bu e-posta'yı yanlışlıkla aldıysanız), lütfen yollayan kişiyi haberdar ediniz ve mesajı sisteminizden derhal siliniz. T.C. Sağlık Bakanlığı bu mesajın içerdiği bilgilerin doğruluğu veya eksiksiz olduğu konusunda bir garanti vermemektedir. Bu nedenle, bilgilerin ne şekilde olursa olsun içeriğinden, iletilmesinden, alınmasından, saklanmasından T.C. sağlık Bakanlığı sorumlu değildir. Bu mesajın içeriği yazarına ait olup, T.C. Sağlık Bakanlığı görüşlerini içermeyebilir.
Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır.
DISCLAIMER:
This e-mail (including any attachments) may contain confidential and/or privileged information. Copying, disclosure or distribution of the material in this e-mail without The Ministry of Health of Turkey's authority is strictly forbidden. If you are not the intended recipient (or have received this e-mail in error), please notify the sender and delete it from your system immediately. The Ministry of Health of Turkey makes no warranty as to the accuracy or completeness of any information contained in this message and hereby excludes any liability of any kind for the information contained therein or for the information transmission, reception, storage or use of such in any way whatsoever. Any opinions expressed in this message are those of the author and may not necessarily reflect the opinions of The Ministry of Health of Turkey.
This e-mail has been scanned for all computer viruses known to us.
________________________________
--
WBR
Maxim aka solomax
--
WBR
Maxim aka solomax
Re: YNT: YNT: YNT: YNT: Openmeetings problem
Posted by Maxim Solodovnik <so...@gmail.com>.
your installation was not successful
could you please share the link you were using to download OM?
On 25 August 2014 19:43, Murat Tamer Ataol <Ta...@saglik.gov.tr>
wrote:
> DB server is up and running. It is creating 48 tables out of 49 in the
> install. mysql*.jar file is there. Telnet is connecting from 3306. I have
> the line in the persistence.xml.
>
> I am installing the default language (english).
>
> Is there anything else I should check for. By the way I reinstalled
> openmeetings and it gives exacly the same error.
>
>
>
>
>
> Murat Tamer Ataol
> Sistem Yönetimi Daire Başkanlığı
>
> Sağlık Bakanlığı
> Sağlık Bilgi sistemleri Genel Müdürlüğü
> Mithatpaşa Cad. No:3 Çankaya / Ankara
>
> Yasal Uyarı :
> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
> Şartlar dokümanına tabidir :
> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>
> ------------------------------
> *Kimden:* Maxim Solodovnik [solomax666@gmail.com]
> *Gönderildi:* 25 Ağustos 2014 Pazartesi 15:32
> *Kime:* Openmeetings user-list
> *Konu:* Re: YNT: YNT: YNT: YNT: Openmeetings problem
>
> first of all check if DB server is up and you able to connect it
> in your persistence.xml you have the line:
> *Url=jdbc:mysql://your_server:3306/openmeetings*
>
> start terminal and type:
> *telnet* *your_server 3306*
>
> if connection is successful then check if mysql*jar driver is present in
> webapps/WEB-INF/lib folder
>
>
>
> On 25 August 2014 19:17, Murat Tamer Ataol <Ta...@saglik.gov.tr>
> wrote:
>
>> If this is a connection failure to the database, how can I fix it? Any
>> suggestions?
>>
>>
>>
>> Murat Tamer Ataol
>> Sistem Yönetimi Daire Başkanlığı
>>
>> Sağlık Bakanlığı
>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>
>> Yasal Uyarı :
>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>> Şartlar dokümanına tabidir :
>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>
>> ------------------------------
>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 14:32
>> *Kime:* user@openmeetings.apache.org
>> *Konu:* Re: YNT: YNT: YNT: YNT: Openmeetings problem
>>
>> I suppose that this is problem of connection to openmeetins database:
>>
>> ERROR 08-25 12:22:50.369 o.a.o.r.r.ScopeApplicationAdapter:151
>> [Launcher:/openmeetings] - [appStart]
>> org.springframework.transaction.CannotCreateTransactionException: Could
>> not open JPA EntityManager for transaction; nested exception is
>> <openjpa-2.2.2-r422266:1468616 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Communications link
>> failure
>>
>> Vasiliy
>>
>>
>>
>>
>> On 25.08.2014 18:10, Murat Tamer Ataol wrote:
>>
>> Here are the log files. error.log has 0 bytes in it. So there is no error
>> in the error.log.
>>
>>
>>
>> Murat Tamer Ataol
>> Sistem Yönetimi Daire Başkanlığı
>>
>> Sağlık Bakanlığı
>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>
>> Yasal Uyarı :
>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>> Şartlar dokümanına tabidir :
>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>
>> ------------------------------
>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 13:23
>> *Kime:* user@openmeetings.apache.org
>> *Konu:* Re: YNT: YNT: YNT: Openmeetings problem
>>
>> Please send log files.
>>
>>
>>
>> On 25.08.2014 16:26, Murat Tamer Ataol wrote:
>>
>> I did what you said to create database and reinstalled the application.
>> Still appoinments table is not there. Same message appears in the log and
>> the login screen doesnt come.
>>
>>
>>
>> Murat Tamer Ataol
>> Sistem Yönetimi Daire Başkanlığı
>>
>> Sağlık Bakanlığı
>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>
>> Yasal Uyarı :
>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>> Şartlar dokümanına tabidir :
>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>
>> ------------------------------
>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 12:10
>> *Kime:* user@openmeetings.apache.org
>> *Konu:* Re: YNT: YNT: Openmeetings problem
>>
>> You should not create tables, you should create database use this
>> command:
>> CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
>>
>> If you update openmeeting you should make backup and import.
>>
>> Thanks,
>> Vasiliy
>>
>>
>> On 25.08.2014 16:02, Murat Tamer Ataol wrote:
>>
>> I am following the Installation of Apache OpenMeetings 2.x or 3.x in
>> CentOS 6.5 guide from cwiki.apache.org.
>>
>> I am not creating the tables by myself. Installation did that. And there
>> were no errors in the installation.
>>
>>
>>
>>
>> Murat Tamer Ataol
>> Sistem Yönetimi Daire Başkanlığı
>>
>> Sağlık Bakanlığı
>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>
>> Yasal Uyarı :
>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>> Şartlar dokümanına tabidir :
>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>
>> ------------------------------
>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 11:50
>> *Kime:* user@openmeetings.apache.org
>> *Konu:* Re: YNT: Openmeetings problem
>>
>> What sql server you use?
>> What command you use to create openmeetings database.
>>
>> Please send full log files.
>>
>> Vasiliy
>>
>> On 25.08.2014 15:38, Murat Tamer Ataol wrote:
>>
>> Hello,
>>
>> I checked the log files. There is one error in openmeetings.log.
>>
>> ----------------------------------------------------------------------------------------
>> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table
>> 'openmeetings.appointments' doesn't exist {prepstmnt 641714439 SELECT
>> t0.id, t1.id, t1.comment_field, t1.deleted, t1.name, t1.starttime,
>> t1.updatetime, t2.id, t2.activatehash, t3.id, t3.additionalname,
>> t3.comment_field, t3.deleted, t3.email, t3.fax, t3.phone, t3.starttime,
>> t4.id, t4.code, t4.deleted, t4.name, t4.shortName, t4.starttime,
>> t4.updatetime, t3.street, t3.town, t3.updatetime, t3.zip, t2.age,
>> t2.availible, t2.deleted, t2.externalUserId, t2.externalUserType,
>> t2.firstname, t2.forceTimeZoneCheck, t2.language_id, t2.lastlogin,
>> t2.lastname, t2.lasttrans, t2.level_id, t2.login, t2.owner_id,
>> t2.pictureuri, t2.regdate, t2.resethash, t2.salutations_id, t2.sendSMS,
>> t2.show_contact_data, t2.show_contact_data_to_contacts, t5.id, t5.allow,
>> t5.callbackextension, t5.context, t5.defaultuser, t5.fullcontact, t5.host,
>> t5.ipaddr, t5.lastms, t5.md5secret, t5.name, t5.nat, t5.port,
>> t5.regseconds, t5.regserver, t5.secret, t5.type, t5.useragent,
>> t2.starttime, t2.status, t2.time_zone_id, t2.type, t2.updatetime,
>> t2.user_offers, t2.user_searchs, t0.is_connected_event, t0.deleted,
>> t0.description, t0.appointment_endtime, t0.icalId, t0.starttime,
>> t0.isdaily, t0.ismonthly, t0.isweekly, t0.isyearly, t0.language_id,
>> t0.location, t6.id, t6.activatehash, t6.adresses_id, t6.age,
>> t6.availible, t6.deleted, t6.externalUserId, t6.externalUserType,
>> t6.firstname, t6.forceTimeZoneCheck, t6.language_id, t6.lastlogin,
>> t6.lastname, t6.lasttrans, t6.level_id, t6.login, t6.owner_id,
>> t6.pictureuri, t6.regdate, t6.resethash, t6.salutations_id, t6.sendSMS,
>> t6.show_contact_data, t6.show_contact_data_to_contacts, t6.sip_user_id,
>> t6.starttime, t6.status, t6.time_zone_id, t6.type, t6.updatetime,
>> t6.user_offers, t6.user_searchs, t0.password, t0.is_password_protected,
>> t7.id, t7.deleted, t7.fieldvalues_id, t7.name, t7.starttime,
>> t7.updatetime, t8.id, t8.activatehash, t8.adresses_id, t8.age,
>> t8.availible, t8.deleted, t8.externalUserId, t8.externalUserType,
>> t8.firstname, t8.forceTimeZoneCheck, t8.language_id, t8.lastlogin,
>> t8.lastname, t8.lasttrans, t8.level_id, t8.login, t8.owner_id,
>> t8.pictureuri, t8.regdate, t8.resethash, t8.salutations_id, t8.sendSMS,
>> t8.show_contact_data, t8.show_contact_data_to_contacts, t8.sip_user_id,
>> t8.starttime, t8.status, t8.time_zone_id, t8.type, t8.updatetime,
>> t8.user_offers, t8.user_searchs, t0.is_reminder_email_send, t9.id,
>> t9.allow_font_styles, t9.allow_recording, t9.allow_user_questions,
>> t9.appointment, t9.auto_video_select, t9.chat_moderated, t9.chat_opened,
>> t9.comment_field, t9.confno, t9.deleted, t9.demo_time, t9.externalRoomId,
>> t9.externalRoomType, t9.files_opened, t9.hide_actions_menu,
>> t9.hide_activities_and_actions, t9.hide_chat, t9.hide_files_explorer,
>> t9.hide_screen_sharing, t9.hide_top_bar, t9.hide_whiteboard,
>> t9.is_audio_only, t9.is_closed, t9.isdemoroom, t9.ismoderatedroom,
>> t9.ispublic, t9.name, t9.numberOfPartizipants, t9.owner_id, t9.pin,
>> t9.redirect_url, t9.roomtypes_id, t9.show_microphone_status,
>> t9.sip_enabled, t9.starttime, t9.updatetime, t9.wait_for_recording,
>> t0.appointment_starttime, t0.appointmentname, t0.updatetime FROM
>> appointments t0 LEFT OUTER JOIN appointmentcategory t1 ON t0.category_id =
>> t1.id LEFT OUTER JOIN om_user t6 ON t0.user_id = t6.id LEFT OUTER JOIN
>> appointmentremindertyps t7 ON t0.remind_id = t7.id LEFT OUTER JOIN room
>> t9 ON t0.room_id = t9.id LEFT OUTER JOIN om_user t2 ON t1.user_id = t2.id
>> LEFT OUTER JOIN om_user t8 ON t7.user_id = t8.id LEFT OUTER JOIN address
>> t3 ON t2.adresses_id = t3.id LEFT OUTER JOIN sipusers t5 ON
>> t2.sip_user_id = t5.id LEFT OUTER JOIN state t4 ON t3.state_id = t4.id
>> WHERE (t0.deleted = ? AND t0.is_reminder_email_send = ? AND (t0.remind_id =
>> ? OR t0.remind_id = ?) AND (t0.appointment_starttime >= ? AND
>> t0.appointment_starttime <= ? OR t0.appointment_endtime >= ? AND
>> t0.appointment_endtime <= ? OR t0.appointment_starttime < ? AND
>> t0.appointment_endtime > ?))} [code=1146, state=42S02]
>> at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>> at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203)
>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>> at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59)
>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>> at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118)
>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>> at
>> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268)
>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>
>> -----------------------------------------------------------------------------------
>>
>> I dont exacly know why this table is not there. Installation didnt give
>> any problem. How can I fix this one?
>>
>> Kind regards,
>> Tamer Ataol
>>
>>
>>
>> Murat Tamer Ataol
>> Sistem Yönetimi Daire Başkanlığı
>>
>> Sağlık Bakanlığı
>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>
>> Yasal Uyarı :
>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>> Şartlar dokümanına tabidir :
>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>
>> ------------------------------
>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 11:26
>> *Kime:* user@openmeetings.apache.org
>> *Konu:* Re: Openmeetings problem
>>
>> Hello Tamer Ataol,
>>
>> Please check log files in the log directory.
>>
>> Thanks,
>> Vasiliy
>>
>>
>> On 25.08.2014 15:22, Murat Tamer Ataol wrote:
>>
>> Hello,
>>
>> I have a problem after installation. Installation completes ok. After
>> that when I hit the "Enter the Application" link notinited page comes. I
>> tried writing localhost:5080/openmeetings on the address bar. It didnt
>> work. I couldnt find how to come to login page. Login page never comes.
>>
>> Can you be of any help?
>>
>> Kind regards,
>> Tamer Ataol
>>
>>
>>
>> Murat Tamer Ataol
>> Sistem Yönetimi Daire Başkanlığı
>>
>> Sağlık Bakanlığı
>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>
>> Yasal Uyarı :
>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>> Şartlar dokümanına tabidir :
>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>
>>
>>
>>
>> ------------------------------
>>
>> YASAL UYARI:
>> Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere) gizlidir.
>> T.C. Sağlık Bakanlığı onayı olmaksızın içeriği kopyalanamaz, üçüncü
>> kişilere açıklanamaz veya iletilemez . Bu mesajın gönderilmek istendiği
>> kişi değilseniz (ya da bu e-posta'yı yanlışlıkla aldıysanız), lütfen
>> yollayan kişiyi haberdar ediniz ve mesajı sisteminizden derhal siliniz.
>> T.C. Sağlık Bakanlığı bu mesajın içerdiği bilgilerin doğruluğu veya
>> eksiksiz olduğu konusunda bir garanti vermemektedir. Bu nedenle, bilgilerin
>> ne şekilde olursa olsun içeriğinden, iletilmesinden, alınmasından,
>> saklanmasından T.C. sağlık Bakanlığı sorumlu değildir. Bu mesajın içeriği
>> yazarına ait olup, T.C. Sağlık Bakanlığı görüşlerini içermeyebilir.
>>
>> Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır.
>>
>> DISCLAIMER:
>> This e-mail (including any attachments) may contain confidential and/or
>> privileged information. Copying, disclosure or distribution of the material
>> in this e-mail without The Ministry of Health of Turkey's authority is
>> strictly forbidden. If you are not the intended recipient (or have received
>> this e-mail in error), please notify the sender and delete it from your
>> system immediately. The Ministry of Health of Turkey makes no warranty as
>> to the accuracy or completeness of any information contained in this
>> message and hereby excludes any liability of any kind for the information
>> contained therein or for the information transmission, reception, storage
>> or use of such in any way whatsoever. Any opinions expressed in this
>> message are those of the author and may not necessarily reflect the
>> opinions of The Ministry of Health of Turkey.
>>
>> This e-mail has been scanned for all computer viruses known to us.
>> ------------------------------
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
> --
> WBR
> Maxim aka solomax
>
>
>
>
--
WBR
Maxim aka solomax
YNT: YNT: YNT: YNT: YNT: Openmeetings problem
Posted by Murat Tamer Ataol <Ta...@saglik.gov.tr>.
DB server is up and running. It is creating 48 tables out of 49 in the install. mysql*.jar file is there. Telnet is connecting from 3306. I have the line in the persistence.xml.
I am installing the default language (english).
Is there anything else I should check for. By the way I reinstalled openmeetings and it gives exacly the same error.
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:imageb426dd.JPG@75ced64c.4aa25054]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Maxim Solodovnik [solomax666@gmail.com]
Gönderildi: 25 Ağustos 2014 Pazartesi 15:32
Kime: Openmeetings user-list
Konu: Re: YNT: YNT: YNT: YNT: Openmeetings problem
first of all check if DB server is up and you able to connect it
in your persistence.xml you have the line: Url=jdbc:mysql://your_server:3306/openmeetings
start terminal and type:
telnet your_server 3306
if connection is successful then check if mysql*jar driver is present in webapps/WEB-INF/lib folder
On 25 August 2014 19:17, Murat Tamer Ataol <Ta...@saglik.gov.tr>> wrote:
If this is a connection failure to the database, how can I fix it? Any suggestions?
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:image8520a5.JPG@513316a0.4d9d4dbe]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 14:32
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: YNT: YNT: YNT: YNT: Openmeetings problem
I suppose that this is problem of connection to openmeetins database:
ERROR 08-25 12:22:50.369 o.a.o.r.r.ScopeApplicationAdapter:151 [Launcher:/openmeetings] - [appStart]
org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is <openjpa-2.2.2-r422266:1468616 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Communications link failure
Vasiliy
On 25.08.2014 18:10, Murat Tamer Ataol wrote:
Here are the log files. error.log has 0 bytes in it. So there is no error in the error.log.
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part1.01020801.06070201@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 13:23
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: YNT: YNT: YNT: Openmeetings problem
Please send log files.
On 25.08.2014 16:26, Murat Tamer Ataol wrote:
I did what you said to create database and reinstalled the application. Still appoinments table is not there. Same message appears in the log and the login screen doesnt come.
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part3.05040906.06050305@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 12:10
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: YNT: YNT: Openmeetings problem
You should not create tables, you should create database use this command:
CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
If you update openmeeting you should make backup and import.
Thanks,
Vasiliy
On 25.08.2014 16:02, Murat Tamer Ataol wrote:
I am following the Installation of Apache OpenMeetings 2.x or 3.x in CentOS 6.5 guide from cwiki.apache.org<http://cwiki.apache.org>.
I am not creating the tables by myself. Installation did that. And there were no errors in the installation.
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part7.06020707.06040506@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 11:50
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: YNT: Openmeetings problem
What sql server you use?
What command you use to create openmeetings database.
Please send full log files.
Vasiliy
On 25.08.2014 15:38, Murat Tamer Ataol wrote:
Hello,
I checked the log files. There is one error in openmeetings.log.
----------------------------------------------------------------------------------------
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'openmeetings.appointments' doesn't exist {prepstmnt 641714439 SELECT t0.id<http://t0.id>, t1.id<http://t1.id>, t1.comment_field, t1.deleted, t1.name<http://t1.name>, t1.starttime, t1.updatetime, t2.id<http://t2.id>, t2.activatehash, t3.id<http://t3.id>, t3.additionalname, t3.comment_field, t3.deleted, t3.email, t3.fax, t3.phone, t3.starttime, t4.id<http://t4.id>, t4.code, t4.deleted, t4.name<http://t4.name>, t4.shortName, t4.starttime, t4.updatetime, t3.street, t3.town, t3.updatetime, t3.zip, t2.age, t2.availible, t2.deleted, t2.externalUserId, t2.externalUserType, t2.firstname, t2.forceTimeZoneCheck, t2.language_id, t2.lastlogin, t2.lastname, t2.lasttrans, t2.level_id, t2.login, t2.owner_id, t2.pictureuri, t2.regdate, t2.resethash, t2.salutations_id, t2.sendSMS, t2.show_contact_data, t2.show_contact_data_to_contacts, t5.id<http://t5.id>, t5.allow, t5.callbackextension, t5.context, t5.defaultuser, t5.fullcontact, t5.host, t5.ipaddr, t5.lastms, t5.md5secret, t5.name<http://t5.name>, t5.nat, t5.port, t5.regseconds, t5.regserver, t5.secret, t5.type, t5.useragent, t2.starttime, t2.status, t2.time_zone_id, t2.type, t2.updatetime, t2.user_offers, t2.user_searchs, t0.is_connected_event, t0.deleted, t0.description, t0.appointment_endtime, t0.icalId, t0.starttime, t0.isdaily, t0.ismonthly, t0.isweekly, t0.isyearly, t0.language_id, t0.location, t6.id<http://t6.id>, t6.activatehash, t6.adresses_id, t6.age, t6.availible, t6.deleted, t6.externalUserId, t6.externalUserType, t6.firstname, t6.forceTimeZoneCheck, t6.language_id, t6.lastlogin, t6.lastname, t6.lasttrans, t6.level_id, t6.login, t6.owner_id, t6.pictureuri, t6.regdate, t6.resethash, t6.salutations_id, t6.sendSMS, t6.show_contact_data, t6.show_contact_data_to_contacts, t6.sip_user_id, t6.starttime, t6.status, t6.time_zone_id, t6.type, t6.updatetime, t6.user_offers, t6.user_searchs, t0.password, t0.is_password_protected, t7.id<http://t7.id>, t7.deleted, t7.fieldvalues_id, t7.name<http://t7.name>, t7.starttime, t7.updatetime, t8.id<http://t8.id>, t8.activatehash, t8.adresses_id, t8.age, t8.availible, t8.deleted, t8.externalUserId, t8.externalUserType, t8.firstname, t8.forceTimeZoneCheck, t8.language_id, t8.lastlogin, t8.lastname, t8.lasttrans, t8.level_id, t8.login, t8.owner_id, t8.pictureuri, t8.regdate, t8.resethash, t8.salutations_id, t8.sendSMS, t8.show_contact_data, t8.show_contact_data_to_contacts, t8.sip_user_id, t8.starttime, t8.status, t8.time_zone_id, t8.type, t8.updatetime, t8.user_offers, t8.user_searchs, t0.is_reminder_email_send, t9.id<http://t9.id>, t9.allow_font_styles, t9.allow_recording, t9.allow_user_questions, t9.appointment, t9.auto_video_select, t9.chat_moderated, t9.chat_opened, t9.comment_field, t9.confno, t9.deleted, t9.demo_time, t9.externalRoomId, t9.externalRoomType, t9.files_opened, t9.hide_actions_menu, t9.hide_activities_and_actions, t9.hide_chat, t9.hide_files_explorer, t9.hide_screen_sharing, t9.hide_top_bar, t9.hide_whiteboard, t9.is_audio_only, t9.is_closed, t9.isdemoroom, t9.ismoderatedroom, t9.ispublic, t9.name<http://t9.name>, t9.numberOfPartizipants, t9.owner_id, t9.pin, t9.redirect_url, t9.roomtypes_id, t9.show_microphone_status, t9.sip_enabled, t9.starttime, t9.updatetime, t9.wait_for_recording, t0.appointment_starttime, t0.appointmentname, t0.updatetime FROM appointments t0 LEFT OUTER JOIN appointmentcategory t1 ON t0.category_id = t1.id<http://t1.id> LEFT OUTER JOIN om_user t6 ON t0.user_id = t6.id<http://t6.id> LEFT OUTER JOIN appointmentremindertyps t7 ON t0.remind_id = t7.id<http://t7.id> LEFT OUTER JOIN room t9 ON t0.room_id = t9.id<http://t9.id> LEFT OUTER JOIN om_user t2 ON t1.user_id = t2.id<http://t2.id> LEFT OUTER JOIN om_user t8 ON t7.user_id = t8.id<http://t8.id> LEFT OUTER JOIN address t3 ON t2.adresses_id = t3.id<http://t3.id> LEFT OUTER JOIN sipusers t5 ON t2.sip_user_id = t5.id<http://t5.id> LEFT OUTER JOIN state t4 ON t3.state_id = t4.id<http://t4.id> WHERE (t0.deleted = ? AND t0.is_reminder_email_send = ? AND (t0.remind_id = ? OR t0.remind_id = ?) AND (t0.appointment_starttime >= ? AND t0.appointment_starttime <= ? OR t0.appointment_endtime >= ? AND t0.appointment_endtime <= ? OR t0.appointment_starttime < ? AND t0.appointment_endtime > ?))} [code=1146, state=42S02]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268) ~[openjpa-bundle-2.2.2.jar:2.2.2]
-----------------------------------------------------------------------------------
I dont exacly know why this table is not there. Installation didnt give any problem. How can I fix this one?
Kind regards,
Tamer Ataol
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part11.03060603.06040904@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 11:26
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: Openmeetings problem
Hello Tamer Ataol,
Please check log files in the log directory.
Thanks,
Vasiliy
On 25.08.2014 15:22, Murat Tamer Ataol wrote:
Hello,
I have a problem after installation. Installation completes ok. After that when I hit the "Enter the Application" link notinited page comes. I tried writing localhost:5080/openmeetings on the address bar. It didnt work. I couldnt find how to come to login page. Login page never comes.
Can you be of any help?
Kind regards,
Tamer Ataol
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part15.02060303.03050508@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
YASAL UYARI:
Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere) gizlidir. T.C. Sağlık Bakanlığı onayı olmaksızın içeriği kopyalanamaz, üçüncü kişilere açıklanamaz veya iletilemez . Bu mesajın gönderilmek istendiği kişi değilseniz (ya da bu e-posta'yı yanlışlıkla aldıysanız), lütfen yollayan kişiyi haberdar ediniz ve mesajı sisteminizden derhal siliniz. T.C. Sağlık Bakanlığı bu mesajın içerdiği bilgilerin doğruluğu veya eksiksiz olduğu konusunda bir garanti vermemektedir. Bu nedenle, bilgilerin ne şekilde olursa olsun içeriğinden, iletilmesinden, alınmasından, saklanmasından T.C. sağlık Bakanlığı sorumlu değildir. Bu mesajın içeriği yazarına ait olup, T.C. Sağlık Bakanlığı görüşlerini içermeyebilir.
Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır.
DISCLAIMER:
This e-mail (including any attachments) may contain confidential and/or privileged information. Copying, disclosure or distribution of the material in this e-mail without The Ministry of Health of Turkey's authority is strictly forbidden. If you are not the intended recipient (or have received this e-mail in error), please notify the sender and delete it from your system immediately. The Ministry of Health of Turkey makes no warranty as to the accuracy or completeness of any information contained in this message and hereby excludes any liability of any kind for the information contained therein or for the information transmission, reception, storage or use of such in any way whatsoever. Any opinions expressed in this message are those of the author and may not necessarily reflect the opinions of The Ministry of Health of Turkey.
This e-mail has been scanned for all computer viruses known to us.
________________________________
--
WBR
Maxim aka solomax
Re: YNT: YNT: YNT: YNT: Openmeetings problem
Posted by Maxim Solodovnik <so...@gmail.com>.
first of all check if DB server is up and you able to connect it
in your persistence.xml you have the line:
*Url=jdbc:mysql://your_server:3306/openmeetings*
start terminal and type:
*telnet* *your_server 3306*
if connection is successful then check if mysql*jar driver is present in
webapps/WEB-INF/lib folder
On 25 August 2014 19:17, Murat Tamer Ataol <Ta...@saglik.gov.tr>
wrote:
> If this is a connection failure to the database, how can I fix it? Any
> suggestions?
>
>
>
> Murat Tamer Ataol
> Sistem Yönetimi Daire Başkanlığı
>
> Sağlık Bakanlığı
> Sağlık Bilgi sistemleri Genel Müdürlüğü
> Mithatpaşa Cad. No:3 Çankaya / Ankara
>
> Yasal Uyarı :
> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
> Şartlar dokümanına tabidir :
> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>
> ------------------------------
> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
> *Gönderildi:* 25 Ağustos 2014 Pazartesi 14:32
> *Kime:* user@openmeetings.apache.org
> *Konu:* Re: YNT: YNT: YNT: YNT: Openmeetings problem
>
> I suppose that this is problem of connection to openmeetins database:
>
> ERROR 08-25 12:22:50.369 o.a.o.r.r.ScopeApplicationAdapter:151
> [Launcher:/openmeetings] - [appStart]
> org.springframework.transaction.CannotCreateTransactionException: Could
> not open JPA EntityManager for transaction; nested exception is
> <openjpa-2.2.2-r422266:1468616 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Communications link
> failure
>
> Vasiliy
>
>
>
>
> On 25.08.2014 18:10, Murat Tamer Ataol wrote:
>
> Here are the log files. error.log has 0 bytes in it. So there is no error
> in the error.log.
>
>
>
> Murat Tamer Ataol
> Sistem Yönetimi Daire Başkanlığı
>
> Sağlık Bakanlığı
> Sağlık Bilgi sistemleri Genel Müdürlüğü
> Mithatpaşa Cad. No:3 Çankaya / Ankara
>
> Yasal Uyarı :
> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
> Şartlar dokümanına tabidir :
> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>
> ------------------------------
> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
> *Gönderildi:* 25 Ağustos 2014 Pazartesi 13:23
> *Kime:* user@openmeetings.apache.org
> *Konu:* Re: YNT: YNT: YNT: Openmeetings problem
>
> Please send log files.
>
>
>
> On 25.08.2014 16:26, Murat Tamer Ataol wrote:
>
> I did what you said to create database and reinstalled the application.
> Still appoinments table is not there. Same message appears in the log and
> the login screen doesnt come.
>
>
>
> Murat Tamer Ataol
> Sistem Yönetimi Daire Başkanlığı
>
> Sağlık Bakanlığı
> Sağlık Bilgi sistemleri Genel Müdürlüğü
> Mithatpaşa Cad. No:3 Çankaya / Ankara
>
> Yasal Uyarı :
> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
> Şartlar dokümanına tabidir :
> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>
> ------------------------------
> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
> *Gönderildi:* 25 Ağustos 2014 Pazartesi 12:10
> *Kime:* user@openmeetings.apache.org
> *Konu:* Re: YNT: YNT: Openmeetings problem
>
> You should not create tables, you should create database use this
> command:
> CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
>
> If you update openmeeting you should make backup and import.
>
> Thanks,
> Vasiliy
>
>
> On 25.08.2014 16:02, Murat Tamer Ataol wrote:
>
> I am following the Installation of Apache OpenMeetings 2.x or 3.x in
> CentOS 6.5 guide from cwiki.apache.org.
>
> I am not creating the tables by myself. Installation did that. And there
> were no errors in the installation.
>
>
>
>
> Murat Tamer Ataol
> Sistem Yönetimi Daire Başkanlığı
>
> Sağlık Bakanlığı
> Sağlık Bilgi sistemleri Genel Müdürlüğü
> Mithatpaşa Cad. No:3 Çankaya / Ankara
>
> Yasal Uyarı :
> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
> Şartlar dokümanına tabidir :
> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>
> ------------------------------
> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
> *Gönderildi:* 25 Ağustos 2014 Pazartesi 11:50
> *Kime:* user@openmeetings.apache.org
> *Konu:* Re: YNT: Openmeetings problem
>
> What sql server you use?
> What command you use to create openmeetings database.
>
> Please send full log files.
>
> Vasiliy
>
> On 25.08.2014 15:38, Murat Tamer Ataol wrote:
>
> Hello,
>
> I checked the log files. There is one error in openmeetings.log.
>
> ----------------------------------------------------------------------------------------
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table
> 'openmeetings.appointments' doesn't exist {prepstmnt 641714439 SELECT
> t0.id, t1.id, t1.comment_field, t1.deleted, t1.name, t1.starttime,
> t1.updatetime, t2.id, t2.activatehash, t3.id, t3.additionalname,
> t3.comment_field, t3.deleted, t3.email, t3.fax, t3.phone, t3.starttime,
> t4.id, t4.code, t4.deleted, t4.name, t4.shortName, t4.starttime,
> t4.updatetime, t3.street, t3.town, t3.updatetime, t3.zip, t2.age,
> t2.availible, t2.deleted, t2.externalUserId, t2.externalUserType,
> t2.firstname, t2.forceTimeZoneCheck, t2.language_id, t2.lastlogin,
> t2.lastname, t2.lasttrans, t2.level_id, t2.login, t2.owner_id,
> t2.pictureuri, t2.regdate, t2.resethash, t2.salutations_id, t2.sendSMS,
> t2.show_contact_data, t2.show_contact_data_to_contacts, t5.id, t5.allow,
> t5.callbackextension, t5.context, t5.defaultuser, t5.fullcontact, t5.host,
> t5.ipaddr, t5.lastms, t5.md5secret, t5.name, t5.nat, t5.port,
> t5.regseconds, t5.regserver, t5.secret, t5.type, t5.useragent,
> t2.starttime, t2.status, t2.time_zone_id, t2.type, t2.updatetime,
> t2.user_offers, t2.user_searchs, t0.is_connected_event, t0.deleted,
> t0.description, t0.appointment_endtime, t0.icalId, t0.starttime,
> t0.isdaily, t0.ismonthly, t0.isweekly, t0.isyearly, t0.language_id,
> t0.location, t6.id, t6.activatehash, t6.adresses_id, t6.age,
> t6.availible, t6.deleted, t6.externalUserId, t6.externalUserType,
> t6.firstname, t6.forceTimeZoneCheck, t6.language_id, t6.lastlogin,
> t6.lastname, t6.lasttrans, t6.level_id, t6.login, t6.owner_id,
> t6.pictureuri, t6.regdate, t6.resethash, t6.salutations_id, t6.sendSMS,
> t6.show_contact_data, t6.show_contact_data_to_contacts, t6.sip_user_id,
> t6.starttime, t6.status, t6.time_zone_id, t6.type, t6.updatetime,
> t6.user_offers, t6.user_searchs, t0.password, t0.is_password_protected,
> t7.id, t7.deleted, t7.fieldvalues_id, t7.name, t7.starttime,
> t7.updatetime, t8.id, t8.activatehash, t8.adresses_id, t8.age,
> t8.availible, t8.deleted, t8.externalUserId, t8.externalUserType,
> t8.firstname, t8.forceTimeZoneCheck, t8.language_id, t8.lastlogin,
> t8.lastname, t8.lasttrans, t8.level_id, t8.login, t8.owner_id,
> t8.pictureuri, t8.regdate, t8.resethash, t8.salutations_id, t8.sendSMS,
> t8.show_contact_data, t8.show_contact_data_to_contacts, t8.sip_user_id,
> t8.starttime, t8.status, t8.time_zone_id, t8.type, t8.updatetime,
> t8.user_offers, t8.user_searchs, t0.is_reminder_email_send, t9.id,
> t9.allow_font_styles, t9.allow_recording, t9.allow_user_questions,
> t9.appointment, t9.auto_video_select, t9.chat_moderated, t9.chat_opened,
> t9.comment_field, t9.confno, t9.deleted, t9.demo_time, t9.externalRoomId,
> t9.externalRoomType, t9.files_opened, t9.hide_actions_menu,
> t9.hide_activities_and_actions, t9.hide_chat, t9.hide_files_explorer,
> t9.hide_screen_sharing, t9.hide_top_bar, t9.hide_whiteboard,
> t9.is_audio_only, t9.is_closed, t9.isdemoroom, t9.ismoderatedroom,
> t9.ispublic, t9.name, t9.numberOfPartizipants, t9.owner_id, t9.pin,
> t9.redirect_url, t9.roomtypes_id, t9.show_microphone_status,
> t9.sip_enabled, t9.starttime, t9.updatetime, t9.wait_for_recording,
> t0.appointment_starttime, t0.appointmentname, t0.updatetime FROM
> appointments t0 LEFT OUTER JOIN appointmentcategory t1 ON t0.category_id =
> t1.id LEFT OUTER JOIN om_user t6 ON t0.user_id = t6.id LEFT OUTER JOIN
> appointmentremindertyps t7 ON t0.remind_id = t7.id LEFT OUTER JOIN room
> t9 ON t0.room_id = t9.id LEFT OUTER JOIN om_user t2 ON t1.user_id = t2.id
> LEFT OUTER JOIN om_user t8 ON t7.user_id = t8.id LEFT OUTER JOIN address
> t3 ON t2.adresses_id = t3.id LEFT OUTER JOIN sipusers t5 ON
> t2.sip_user_id = t5.id LEFT OUTER JOIN state t4 ON t3.state_id = t4.id
> WHERE (t0.deleted = ? AND t0.is_reminder_email_send = ? AND (t0.remind_id =
> ? OR t0.remind_id = ?) AND (t0.appointment_starttime >= ? AND
> t0.appointment_starttime <= ? OR t0.appointment_endtime >= ? AND
> t0.appointment_endtime <= ? OR t0.appointment_starttime < ? AND
> t0.appointment_endtime > ?))} [code=1146, state=42S02]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>
> -----------------------------------------------------------------------------------
>
> I dont exacly know why this table is not there. Installation didnt give
> any problem. How can I fix this one?
>
> Kind regards,
> Tamer Ataol
>
>
>
> Murat Tamer Ataol
> Sistem Yönetimi Daire Başkanlığı
>
> Sağlık Bakanlığı
> Sağlık Bilgi sistemleri Genel Müdürlüğü
> Mithatpaşa Cad. No:3 Çankaya / Ankara
>
> Yasal Uyarı :
> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
> Şartlar dokümanına tabidir :
> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>
> ------------------------------
> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
> *Gönderildi:* 25 Ağustos 2014 Pazartesi 11:26
> *Kime:* user@openmeetings.apache.org
> *Konu:* Re: Openmeetings problem
>
> Hello Tamer Ataol,
>
> Please check log files in the log directory.
>
> Thanks,
> Vasiliy
>
>
> On 25.08.2014 15:22, Murat Tamer Ataol wrote:
>
> Hello,
>
> I have a problem after installation. Installation completes ok. After that
> when I hit the "Enter the Application" link notinited page comes. I tried
> writing localhost:5080/openmeetings on the address bar. It didnt work. I
> couldnt find how to come to login page. Login page never comes.
>
> Can you be of any help?
>
> Kind regards,
> Tamer Ataol
>
>
>
> Murat Tamer Ataol
> Sistem Yönetimi Daire Başkanlığı
>
> Sağlık Bakanlığı
> Sağlık Bilgi sistemleri Genel Müdürlüğü
> Mithatpaşa Cad. No:3 Çankaya / Ankara
>
> Yasal Uyarı :
> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
> Şartlar dokümanına tabidir :
> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>
>
>
>
> ------------------------------
>
> YASAL UYARI:
> Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere) gizlidir.
> T.C. Sağlık Bakanlığı onayı olmaksızın içeriği kopyalanamaz, üçüncü
> kişilere açıklanamaz veya iletilemez . Bu mesajın gönderilmek istendiği
> kişi değilseniz (ya da bu e-posta'yı yanlışlıkla aldıysanız), lütfen
> yollayan kişiyi haberdar ediniz ve mesajı sisteminizden derhal siliniz.
> T.C. Sağlık Bakanlığı bu mesajın içerdiği bilgilerin doğruluğu veya
> eksiksiz olduğu konusunda bir garanti vermemektedir. Bu nedenle, bilgilerin
> ne şekilde olursa olsun içeriğinden, iletilmesinden, alınmasından,
> saklanmasından T.C. sağlık Bakanlığı sorumlu değildir. Bu mesajın içeriği
> yazarına ait olup, T.C. Sağlık Bakanlığı görüşlerini içermeyebilir.
>
> Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır.
>
> DISCLAIMER:
> This e-mail (including any attachments) may contain confidential and/or
> privileged information. Copying, disclosure or distribution of the material
> in this e-mail without The Ministry of Health of Turkey's authority is
> strictly forbidden. If you are not the intended recipient (or have received
> this e-mail in error), please notify the sender and delete it from your
> system immediately. The Ministry of Health of Turkey makes no warranty as
> to the accuracy or completeness of any information contained in this
> message and hereby excludes any liability of any kind for the information
> contained therein or for the information transmission, reception, storage
> or use of such in any way whatsoever. Any opinions expressed in this
> message are those of the author and may not necessarily reflect the
> opinions of The Ministry of Health of Turkey.
>
> This e-mail has been scanned for all computer viruses known to us.
> ------------------------------
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
--
WBR
Maxim aka solomax
YNT: YNT: YNT: YNT: YNT: Openmeetings problem
Posted by Murat Tamer Ataol <Ta...@saglik.gov.tr>.
If this is a connection failure to the database, how can I fix it? Any suggestions?
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:image8520a5.JPG@513316a0.4d9d4dbe]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru]
Gönderildi: 25 Ağustos 2014 Pazartesi 14:32
Kime: user@openmeetings.apache.org
Konu: Re: YNT: YNT: YNT: YNT: Openmeetings problem
I suppose that this is problem of connection to openmeetins database:
ERROR 08-25 12:22:50.369 o.a.o.r.r.ScopeApplicationAdapter:151 [Launcher:/openmeetings] - [appStart]
org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is <openjpa-2.2.2-r422266:1468616 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Communications link failure
Vasiliy
On 25.08.2014 18:10, Murat Tamer Ataol wrote:
Here are the log files. error.log has 0 bytes in it. So there is no error in the error.log.
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part1.01020801.06070201@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 13:23
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: YNT: YNT: YNT: Openmeetings problem
Please send log files.
On 25.08.2014 16:26, Murat Tamer Ataol wrote:
I did what you said to create database and reinstalled the application. Still appoinments table is not there. Same message appears in the log and the login screen doesnt come.
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part3.05040906.06050305@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 12:10
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: YNT: YNT: Openmeetings problem
You should not create tables, you should create database use this command:
CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
If you update openmeeting you should make backup and import.
Thanks,
Vasiliy
On 25.08.2014 16:02, Murat Tamer Ataol wrote:
I am following the Installation of Apache OpenMeetings 2.x or 3.x in CentOS 6.5 guide from cwiki.apache.org.
I am not creating the tables by myself. Installation did that. And there were no errors in the installation.
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part7.06020707.06040506@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 11:50
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: YNT: Openmeetings problem
What sql server you use?
What command you use to create openmeetings database.
Please send full log files.
Vasiliy
On 25.08.2014 15:38, Murat Tamer Ataol wrote:
Hello,
I checked the log files. There is one error in openmeetings.log.
----------------------------------------------------------------------------------------
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'openmeetings.appointments' doesn't exist {prepstmnt 641714439 SELECT t0.id, t1.id, t1.comment_field, t1.deleted, t1.name, t1.starttime, t1.updatetime, t2.id, t2.activatehash, t3.id, t3.additionalname, t3.comment_field, t3.deleted, t3.email, t3.fax, t3.phone, t3.starttime, t4.id, t4.code, t4.deleted, t4.name, t4.shortName, t4.starttime, t4.updatetime, t3.street, t3.town, t3.updatetime, t3.zip, t2.age, t2.availible, t2.deleted, t2.externalUserId, t2.externalUserType, t2.firstname, t2.forceTimeZoneCheck, t2.language_id, t2.lastlogin, t2.lastname, t2.lasttrans, t2.level_id, t2.login, t2.owner_id, t2.pictureuri, t2.regdate, t2.resethash, t2.salutations_id, t2.sendSMS, t2.show_contact_data, t2.show_contact_data_to_contacts, t5.id, t5.allow, t5.callbackextension, t5.context, t5.defaultuser, t5.fullcontact, t5.host, t5.ipaddr, t5.lastms, t5.md5secret, t5.name, t5.nat, t5.port, t5.regseconds, t5.regserver, t5.secret, t5.type, t5.useragent, t2.starttime, t2.status, t2.time_zone_id, t2.type, t2.updatetime, t2.user_offers, t2.user_searchs, t0.is_connected_event, t0.deleted, t0.description, t0.appointment_endtime, t0.icalId, t0.starttime, t0.isdaily, t0.ismonthly, t0.isweekly, t0.isyearly, t0.language_id, t0.location, t6.id, t6.activatehash, t6.adresses_id, t6.age, t6.availible, t6.deleted, t6.externalUserId, t6.externalUserType, t6.firstname, t6.forceTimeZoneCheck, t6.language_id, t6.lastlogin, t6.lastname, t6.lasttrans, t6.level_id, t6.login, t6.owner_id, t6.pictureuri, t6.regdate, t6.resethash, t6.salutations_id, t6.sendSMS, t6.show_contact_data, t6.show_contact_data_to_contacts, t6.sip_user_id, t6.starttime, t6.status, t6.time_zone_id, t6.type, t6.updatetime, t6.user_offers, t6.user_searchs, t0.password, t0.is_password_protected, t7.id, t7.deleted, t7.fieldvalues_id, t7.name, t7.starttime, t7.updatetime, t8.id, t8.activatehash, t8.adresses_id, t8.age, t8.availible, t8.deleted, t8.externalUserId, t8.externalUserType, t8.firstname, t8.forceTimeZoneCheck, t8.language_id, t8.lastlogin, t8.lastname, t8.lasttrans, t8.level_id, t8.login, t8.owner_id, t8.pictureuri, t8.regdate, t8.resethash, t8.salutations_id, t8.sendSMS, t8.show_contact_data, t8.show_contact_data_to_contacts, t8.sip_user_id, t8.starttime, t8.status, t8.time_zone_id, t8.type, t8.updatetime, t8.user_offers, t8.user_searchs, t0.is_reminder_email_send, t9.id, t9.allow_font_styles, t9.allow_recording, t9.allow_user_questions, t9.appointment, t9.auto_video_select, t9.chat_moderated, t9.chat_opened, t9.comment_field, t9.confno, t9.deleted, t9.demo_time, t9.externalRoomId, t9.externalRoomType, t9.files_opened, t9.hide_actions_menu, t9.hide_activities_and_actions, t9.hide_chat, t9.hide_files_explorer, t9.hide_screen_sharing, t9.hide_top_bar, t9.hide_whiteboard, t9.is_audio_only, t9.is_closed, t9.isdemoroom, t9.ismoderatedroom, t9.ispublic, t9.name, t9.numberOfPartizipants, t9.owner_id, t9.pin, t9.redirect_url, t9.roomtypes_id, t9.show_microphone_status, t9.sip_enabled, t9.starttime, t9.updatetime, t9.wait_for_recording, t0.appointment_starttime, t0.appointmentname, t0.updatetime FROM appointments t0 LEFT OUTER JOIN appointmentcategory t1 ON t0.category_id = t1.id LEFT OUTER JOIN om_user t6 ON t0.user_id = t6.id LEFT OUTER JOIN appointmentremindertyps t7 ON t0.remind_id = t7.id LEFT OUTER JOIN room t9 ON t0.room_id = t9.id LEFT OUTER JOIN om_user t2 ON t1.user_id = t2.id LEFT OUTER JOIN om_user t8 ON t7.user_id = t8.id LEFT OUTER JOIN address t3 ON t2.adresses_id = t3.id LEFT OUTER JOIN sipusers t5 ON t2.sip_user_id = t5.id LEFT OUTER JOIN state t4 ON t3.state_id = t4.id WHERE (t0.deleted = ? AND t0.is_reminder_email_send = ? AND (t0.remind_id = ? OR t0.remind_id = ?) AND (t0.appointment_starttime >= ? AND t0.appointment_starttime <= ? OR t0.appointment_endtime >= ? AND t0.appointment_endtime <= ? OR t0.appointment_starttime < ? AND t0.appointment_endtime > ?))} [code=1146, state=42S02]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268) ~[openjpa-bundle-2.2.2.jar:2.2.2]
-----------------------------------------------------------------------------------
I dont exacly know why this table is not there. Installation didnt give any problem. How can I fix this one?
Kind regards,
Tamer Ataol
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part11.03060603.06040904@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 11:26
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: Openmeetings problem
Hello Tamer Ataol,
Please check log files in the log directory.
Thanks,
Vasiliy
On 25.08.2014 15:22, Murat Tamer Ataol wrote:
Hello,
I have a problem after installation. Installation completes ok. After that when I hit the "Enter the Application" link notinited page comes. I tried writing localhost:5080/openmeetings on the address bar. It didnt work. I couldnt find how to come to login page. Login page never comes.
Can you be of any help?
Kind regards,
Tamer Ataol
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part15.02060303.03050508@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
YASAL UYARI:
Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere) gizlidir. T.C. Sağlık Bakanlığı onayı olmaksızın içeriği kopyalanamaz, üçüncü kişilere açıklanamaz veya iletilemez . Bu mesajın gönderilmek istendiği kişi değilseniz (ya da bu e-posta'yı yanlışlıkla aldıysanız), lütfen yollayan kişiyi haberdar ediniz ve mesajı sisteminizden derhal siliniz. T.C. Sağlık Bakanlığı bu mesajın içerdiği bilgilerin doğruluğu veya eksiksiz olduğu konusunda bir garanti vermemektedir. Bu nedenle, bilgilerin ne şekilde olursa olsun içeriğinden, iletilmesinden, alınmasından, saklanmasından T.C. sağlık Bakanlığı sorumlu değildir. Bu mesajın içeriği yazarına ait olup, T.C. Sağlık Bakanlığı görüşlerini içermeyebilir.
Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır.
DISCLAIMER:
This e-mail (including any attachments) may contain confidential and/or privileged information. Copying, disclosure or distribution of the material in this e-mail without The Ministry of Health of Turkey's authority is strictly forbidden. If you are not the intended recipient (or have received this e-mail in error), please notify the sender and delete it from your system immediately. The Ministry of Health of Turkey makes no warranty as to the accuracy or completeness of any information contained in this message and hereby excludes any liability of any kind for the information contained therein or for the information transmission, reception, storage or use of such in any way whatsoever. Any opinions expressed in this message are those of the author and may not necessarily reflect the opinions of The Ministry of Health of Turkey.
This e-mail has been scanned for all computer viruses known to us.
________________________________
Re: YNT: YNT: YNT: YNT: Openmeetings problem
Posted by Vasiliy Degtyarev <va...@unipro.ru>.
I suppose that this is problem of connection to openmeetins database:
ERROR 08-25 12:22:50.369 o.a.o.r.r.ScopeApplicationAdapter:151
[Launcher:/openmeetings] - [appStart]
org.springframework.transaction.CannotCreateTransactionException: Could
not open JPA EntityManager for transaction; nested exception is
<openjpa-2.2.2-r422266:1468616 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Communications link
failure
Vasiliy
On 25.08.2014 18:10, Murat Tamer Ataol wrote:
> Here are the log files. error.log has 0 bytes in it. So there is no
> error in the error.log.
>
> Murat Tamer Ataol
> Sistem Yönetimi Daire Başkanlığı
>
> Sağlık Bakanlığı
> Sağlık Bilgi sistemleri Genel Müdürlüğü
> Mithatpaşa Cad. No:3 Çankaya / Ankara
>
> Yasal Uyarı :
> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
> Şartlar dokümanına tabidir :
> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>
> ------------------------------------------------------------------------
> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
> *Gönderildi:* 25 Ağustos 2014 Pazartesi 13:23
> *Kime:* user@openmeetings.apache.org
> *Konu:* Re: YNT: YNT: YNT: Openmeetings problem
>
> Please send log files.
>
>
>
> On 25.08.2014 16:26, Murat Tamer Ataol wrote:
>> I did what you said to create database and reinstalled the
>> application. Still appoinments table is not there. Same message
>> appears in the log and the login screen doesnt come.
>>
>> Murat Tamer Ataol
>> Sistem Yönetimi Daire Başkanlığı
>>
>> Sağlık Bakanlığı
>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>
>> Yasal Uyarı :
>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>> Şartlar dokümanına tabidir :
>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>
>> ------------------------------------------------------------------------
>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 12:10
>> *Kime:* user@openmeetings.apache.org
>> *Konu:* Re: YNT: YNT: Openmeetings problem
>>
>> You should not create tables, you should create database use this
>> command:
>> CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
>>
>> If you update openmeeting you should make backup and import.
>>
>> Thanks,
>> Vasiliy
>>
>>
>> On 25.08.2014 16:02, Murat Tamer Ataol wrote:
>>> I am following the Installation of Apache OpenMeetings 2.x or 3.x in
>>> CentOS 6.5 guide from cwiki.apache.org.
>>>
>>> I am not creating the tables by myself. Installation did that. And
>>> there were no errors in the installation.
>>>
>>>
>>> Murat Tamer Ataol
>>> Sistem Yönetimi Daire Başkanlığı
>>>
>>> Sağlık Bakanlığı
>>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>>
>>> Yasal Uyarı :
>>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>>> Şartlar dokümanına tabidir :
>>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>>
>>> ------------------------------------------------------------------------
>>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 11:50
>>> *Kime:* user@openmeetings.apache.org
>>> *Konu:* Re: YNT: Openmeetings problem
>>>
>>> What sql server you use?
>>> What command you use to create openmeetings database.
>>>
>>> Please send full log files.
>>>
>>> Vasiliy
>>>
>>> On 25.08.2014 15:38, Murat Tamer Ataol wrote:
>>>> Hello,
>>>>
>>>> I checked the log files. There is one error in openmeetings.log.
>>>> ----------------------------------------------------------------------------------------
>>>> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table
>>>> 'openmeetings.appointments' doesn't exist {prepstmnt 641714439
>>>> SELECT t0.id, t1.id, t1.comment_field, t1.deleted, t1.name,
>>>> t1.starttime, t1.updatetime, t2.id, t2.activatehash, t3.id,
>>>> t3.additionalname, t3.comment_field, t3.deleted, t3.email, t3.fax,
>>>> t3.phone, t3.starttime, t4.id, t4.code, t4.deleted, t4.name,
>>>> t4.shortName, t4.starttime, t4.updatetime, t3.street, t3.town,
>>>> t3.updatetime, t3.zip, t2.age, t2.availible, t2.deleted,
>>>> t2.externalUserId, t2.externalUserType, t2.firstname,
>>>> t2.forceTimeZoneCheck, t2.language_id, t2.lastlogin, t2.lastname,
>>>> t2.lasttrans, t2.level_id, t2.login, t2.owner_id, t2.pictureuri,
>>>> t2.regdate, t2.resethash, t2.salutations_id, t2.sendSMS,
>>>> t2.show_contact_data, t2.show_contact_data_to_contacts, t5.id,
>>>> t5.allow, t5.callbackextension, t5.context, t5.defaultuser,
>>>> t5.fullcontact, t5.host, t5.ipaddr, t5.lastms, t5.md5secret,
>>>> t5.name, t5.nat, t5.port, t5.regseconds, t5.regserver, t5.secret,
>>>> t5.type, t5.useragent, t2.starttime, t2.status, t2.time_zone_id,
>>>> t2.type, t2.updatetime, t2.user_offers, t2.user_searchs,
>>>> t0.is_connected_event, t0.deleted, t0.description,
>>>> t0.appointment_endtime, t0.icalId, t0.starttime, t0.isdaily,
>>>> t0.ismonthly, t0.isweekly, t0.isyearly, t0.language_id,
>>>> t0.location, t6.id, t6.activatehash, t6.adresses_id, t6.age,
>>>> t6.availible, t6.deleted, t6.externalUserId, t6.externalUserType,
>>>> t6.firstname, t6.forceTimeZoneCheck, t6.language_id, t6.lastlogin,
>>>> t6.lastname, t6.lasttrans, t6.level_id, t6.login, t6.owner_id,
>>>> t6.pictureuri, t6.regdate, t6.resethash, t6.salutations_id,
>>>> t6.sendSMS, t6.show_contact_data, t6.show_contact_data_to_contacts,
>>>> t6.sip_user_id, t6.starttime, t6.status, t6.time_zone_id, t6.type,
>>>> t6.updatetime, t6.user_offers, t6.user_searchs, t0.password,
>>>> t0.is_password_protected, t7.id, t7.deleted, t7.fieldvalues_id,
>>>> t7.name, t7.starttime, t7.updatetime, t8.id, t8.activatehash,
>>>> t8.adresses_id, t8.age, t8.availible, t8.deleted,
>>>> t8.externalUserId, t8.externalUserType, t8.firstname,
>>>> t8.forceTimeZoneCheck, t8.language_id, t8.lastlogin, t8.lastname,
>>>> t8.lasttrans, t8.level_id, t8.login, t8.owner_id, t8.pictureuri,
>>>> t8.regdate, t8.resethash, t8.salutations_id, t8.sendSMS,
>>>> t8.show_contact_data, t8.show_contact_data_to_contacts,
>>>> t8.sip_user_id, t8.starttime, t8.status, t8.time_zone_id, t8.type,
>>>> t8.updatetime, t8.user_offers, t8.user_searchs,
>>>> t0.is_reminder_email_send, t9.id, t9.allow_font_styles,
>>>> t9.allow_recording, t9.allow_user_questions, t9.appointment,
>>>> t9.auto_video_select, t9.chat_moderated, t9.chat_opened,
>>>> t9.comment_field, t9.confno, t9.deleted, t9.demo_time,
>>>> t9.externalRoomId, t9.externalRoomType, t9.files_opened,
>>>> t9.hide_actions_menu, t9.hide_activities_and_actions, t9.hide_chat,
>>>> t9.hide_files_explorer, t9.hide_screen_sharing, t9.hide_top_bar,
>>>> t9.hide_whiteboard, t9.is_audio_only, t9.is_closed, t9.isdemoroom,
>>>> t9.ismoderatedroom, t9.ispublic, t9.name, t9.numberOfPartizipants,
>>>> t9.owner_id, t9.pin, t9.redirect_url, t9.roomtypes_id,
>>>> t9.show_microphone_status, t9.sip_enabled, t9.starttime,
>>>> t9.updatetime, t9.wait_for_recording, t0.appointment_starttime,
>>>> t0.appointmentname, t0.updatetime FROM appointments t0 LEFT OUTER
>>>> JOIN appointmentcategory t1 ON t0.category_id = t1.id LEFT OUTER
>>>> JOIN om_user t6 ON t0.user_id = t6.id LEFT OUTER JOIN
>>>> appointmentremindertyps t7 ON t0.remind_id = t7.id LEFT OUTER JOIN
>>>> room t9 ON t0.room_id = t9.id LEFT OUTER JOIN om_user t2 ON
>>>> t1.user_id = t2.id LEFT OUTER JOIN om_user t8 ON t7.user_id = t8.id
>>>> LEFT OUTER JOIN address t3 ON t2.adresses_id = t3.id LEFT OUTER
>>>> JOIN sipusers t5 ON t2.sip_user_id = t5.id LEFT OUTER JOIN state t4
>>>> ON t3.state_id = t4.id WHERE (t0.deleted = ? AND
>>>> t0.is_reminder_email_send = ? AND (t0.remind_id = ? OR t0.remind_id
>>>> = ?) AND (t0.appointment_starttime >= ? AND
>>>> t0.appointment_starttime <= ? OR t0.appointment_endtime >= ? AND
>>>> t0.appointment_endtime <= ? OR t0.appointment_starttime < ? AND
>>>> t0.appointment_endtime > ?))} [code=1146, state=42S02]
>>>> at
>>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
>>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>>> at
>>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203)
>>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>>> at
>>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59)
>>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>>> at
>>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118)
>>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>>> at
>>>> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268)
>>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>>> -----------------------------------------------------------------------------------
>>>>
>>>> I dont exacly know why this table is not there. Installation didnt
>>>> give any problem. How can I fix this one?
>>>>
>>>> Kind regards,
>>>> Tamer Ataol
>>>>
>>>> Murat Tamer Ataol
>>>> Sistem Yönetimi Daire Başkanlığı
>>>>
>>>> Sağlık Bakanlığı
>>>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>>>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>>>
>>>> Yasal Uyarı :
>>>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>>>> Şartlar dokümanına tabidir :
>>>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>>>
>>>> ------------------------------------------------------------------------
>>>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>>>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 11:26
>>>> *Kime:* user@openmeetings.apache.org
>>>> *Konu:* Re: Openmeetings problem
>>>>
>>>> Hello Tamer Ataol,
>>>>
>>>> Please check log files in the log directory.
>>>>
>>>> Thanks,
>>>> Vasiliy
>>>>
>>>>
>>>> On 25.08.2014 15:22, Murat Tamer Ataol wrote:
>>>>> Hello,
>>>>>
>>>>> I have a problem after installation. Installation completes ok.
>>>>> After that when I hit the "Enter the Application" link notinited
>>>>> page comes. I tried writing localhost:5080/openmeetings on the
>>>>> address bar. It didnt work. I couldnt find how to come to login
>>>>> page. Login page never comes.
>>>>>
>>>>> Can you be of any help?
>>>>>
>>>>> Kind regards,
>>>>> Tamer Ataol
>>>>>
>>>>> Murat Tamer Ataol
>>>>> Sistem Yönetimi Daire Başkanlığı
>>>>>
>>>>> Sağlık Bakanlığı
>>>>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>>>>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>>>>
>>>>> Yasal Uyarı :
>>>>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul
>>>>> ve Şartlar dokümanına tabidir :
>>>>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>>>>
>>>>> ------------------------------------------------------------------------
>>>>>
>>>>> YASAL UYARI:
>>>>> Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere)
>>>>> gizlidir. T.C. Sağlık Bakanlığı onayı olmaksızın içeriği
>>>>> kopyalanamaz, üçüncü kişilere açıklanamaz veya iletilemez . Bu
>>>>> mesajın gönderilmek istendiği kişi değilseniz (ya da bu e-posta'yı
>>>>> yanlışlıkla aldıysanız), lütfen yollayan kişiyi haberdar ediniz ve
>>>>> mesajı sisteminizden derhal siliniz. T.C. Sağlık Bakanlığı bu
>>>>> mesajın içerdiği bilgilerin doğruluğu veya eksiksiz olduğu
>>>>> konusunda bir garanti vermemektedir. Bu nedenle, bilgilerin ne
>>>>> şekilde olursa olsun içeriğinden, iletilmesinden, alınmasından,
>>>>> saklanmasından T.C. sağlık Bakanlığı sorumlu değildir. Bu mesajın
>>>>> içeriği yazarına ait olup, T.C. Sağlık Bakanlığı görüşlerini
>>>>> içermeyebilir.
>>>>>
>>>>> Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır.
>>>>>
>>>>> DISCLAIMER:
>>>>> This e-mail (including any attachments) may contain confidential
>>>>> and/or privileged information. Copying, disclosure or distribution
>>>>> of the material in this e-mail without The Ministry of Health of
>>>>> Turkey's authority is strictly forbidden. If you are not the
>>>>> intended recipient (or have received this e-mail in error), please
>>>>> notify the sender and delete it from your system immediately. The
>>>>> Ministry of Health of Turkey makes no warranty as to the accuracy
>>>>> or completeness of any information contained in this message and
>>>>> hereby excludes any liability of any kind for the information
>>>>> contained therein or for the information transmission, reception,
>>>>> storage or use of such in any way whatsoever. Any opinions
>>>>> expressed in this message are those of the author and may not
>>>>> necessarily reflect the opinions of The Ministry of Health of Turkey.
>>>>>
>>>>> This e-mail has been scanned for all computer viruses known to us.
>>>>>
>>>>> ------------------------------------------------------------------------
>>>>>
>>>>>
>>>>
>>>
>>
>
YNT: YNT: YNT: YNT: Openmeetings problem
Posted by Murat Tamer Ataol <Ta...@saglik.gov.tr>.
Here are the log files. error.log has 0 bytes in it. So there is no error in the error.log.
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:imagec87bf4.JPG@5d394a72.45a59d25]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru]
Gönderildi: 25 Ağustos 2014 Pazartesi 13:23
Kime: user@openmeetings.apache.org
Konu: Re: YNT: YNT: YNT: Openmeetings problem
Please send log files.
On 25.08.2014 16:26, Murat Tamer Ataol wrote:
I did what you said to create database and reinstalled the application. Still appoinments table is not there. Same message appears in the log and the login screen doesnt come.
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part1.04080104.08040406@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 12:10
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: YNT: YNT: Openmeetings problem
You should not create tables, you should create database use this command:
CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
If you update openmeeting you should make backup and import.
Thanks,
Vasiliy
On 25.08.2014 16:02, Murat Tamer Ataol wrote:
I am following the Installation of Apache OpenMeetings 2.x or 3.x in CentOS 6.5 guide from cwiki.apache.org.
I am not creating the tables by myself. Installation did that. And there were no errors in the installation.
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part3.01060108.05050001@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 11:50
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: YNT: Openmeetings problem
What sql server you use?
What command you use to create openmeetings database.
Please send full log files.
Vasiliy
On 25.08.2014 15:38, Murat Tamer Ataol wrote:
Hello,
I checked the log files. There is one error in openmeetings.log.
----------------------------------------------------------------------------------------
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'openmeetings.appointments' doesn't exist {prepstmnt 641714439 SELECT t0.id, t1.id, t1.comment_field, t1.deleted, t1.name, t1.starttime, t1.updatetime, t2.id, t2.activatehash, t3.id, t3.additionalname, t3.comment_field, t3.deleted, t3.email, t3.fax, t3.phone, t3.starttime, t4.id, t4.code, t4.deleted, t4.name, t4.shortName, t4.starttime, t4.updatetime, t3.street, t3.town, t3.updatetime, t3.zip, t2.age, t2.availible, t2.deleted, t2.externalUserId, t2.externalUserType, t2.firstname, t2.forceTimeZoneCheck, t2.language_id, t2.lastlogin, t2.lastname, t2.lasttrans, t2.level_id, t2.login, t2.owner_id, t2.pictureuri, t2.regdate, t2.resethash, t2.salutations_id, t2.sendSMS, t2.show_contact_data, t2.show_contact_data_to_contacts, t5.id, t5.allow, t5.callbackextension, t5.context, t5.defaultuser, t5.fullcontact, t5.host, t5.ipaddr, t5.lastms, t5.md5secret, t5.name, t5.nat, t5.port, t5.regseconds, t5.regserver, t5.secret, t5.type, t5.useragent, t2.starttime, t2.status, t2.time_zone_id, t2.type, t2.updatetime, t2.user_offers, t2.user_searchs, t0.is_connected_event, t0.deleted, t0.description, t0.appointment_endtime, t0.icalId, t0.starttime, t0.isdaily, t0.ismonthly, t0.isweekly, t0.isyearly, t0.language_id, t0.location, t6.id, t6.activatehash, t6.adresses_id, t6.age, t6.availible, t6.deleted, t6.externalUserId, t6.externalUserType, t6.firstname, t6.forceTimeZoneCheck, t6.language_id, t6.lastlogin, t6.lastname, t6.lasttrans, t6.level_id, t6.login, t6.owner_id, t6.pictureuri, t6.regdate, t6.resethash, t6.salutations_id, t6.sendSMS, t6.show_contact_data, t6.show_contact_data_to_contacts, t6.sip_user_id, t6.starttime, t6.status, t6.time_zone_id, t6.type, t6.updatetime, t6.user_offers, t6.user_searchs, t0.password, t0.is_password_protected, t7.id, t7.deleted, t7.fieldvalues_id, t7.name, t7.starttime, t7.updatetime, t8.id, t8.activatehash, t8.adresses_id, t8.age, t8.availible, t8.deleted, t8.externalUserId, t8.externalUserType, t8.firstname, t8.forceTimeZoneCheck, t8.language_id, t8.lastlogin, t8.lastname, t8.lasttrans, t8.level_id, t8.login, t8.owner_id, t8.pictureuri, t8.regdate, t8.resethash, t8.salutations_id, t8.sendSMS, t8.show_contact_data, t8.show_contact_data_to_contacts, t8.sip_user_id, t8.starttime, t8.status, t8.time_zone_id, t8.type, t8.updatetime, t8.user_offers, t8.user_searchs, t0.is_reminder_email_send, t9.id, t9.allow_font_styles, t9.allow_recording, t9.allow_user_questions, t9.appointment, t9.auto_video_select, t9.chat_moderated, t9.chat_opened, t9.comment_field, t9.confno, t9.deleted, t9.demo_time, t9.externalRoomId, t9.externalRoomType, t9.files_opened, t9.hide_actions_menu, t9.hide_activities_and_actions, t9.hide_chat, t9.hide_files_explorer, t9.hide_screen_sharing, t9.hide_top_bar, t9.hide_whiteboard, t9.is_audio_only, t9.is_closed, t9.isdemoroom, t9.ismoderatedroom, t9.ispublic, t9.name, t9.numberOfPartizipants, t9.owner_id, t9.pin, t9.redirect_url, t9.roomtypes_id, t9.show_microphone_status, t9.sip_enabled, t9.starttime, t9.updatetime, t9.wait_for_recording, t0.appointment_starttime, t0.appointmentname, t0.updatetime FROM appointments t0 LEFT OUTER JOIN appointmentcategory t1 ON t0.category_id = t1.id LEFT OUTER JOIN om_user t6 ON t0.user_id = t6.id LEFT OUTER JOIN appointmentremindertyps t7 ON t0.remind_id = t7.id LEFT OUTER JOIN room t9 ON t0.room_id = t9.id LEFT OUTER JOIN om_user t2 ON t1.user_id = t2.id LEFT OUTER JOIN om_user t8 ON t7.user_id = t8.id LEFT OUTER JOIN address t3 ON t2.adresses_id = t3.id LEFT OUTER JOIN sipusers t5 ON t2.sip_user_id = t5.id LEFT OUTER JOIN state t4 ON t3.state_id = t4.id WHERE (t0.deleted = ? AND t0.is_reminder_email_send = ? AND (t0.remind_id = ? OR t0.remind_id = ?) AND (t0.appointment_starttime >= ? AND t0.appointment_starttime <= ? OR t0.appointment_endtime >= ? AND t0.appointment_endtime <= ? OR t0.appointment_starttime < ? AND t0.appointment_endtime > ?))} [code=1146, state=42S02]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268) ~[openjpa-bundle-2.2.2.jar:2.2.2]
-----------------------------------------------------------------------------------
I dont exacly know why this table is not there. Installation didnt give any problem. How can I fix this one?
Kind regards,
Tamer Ataol
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part7.01080000.09030000@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 11:26
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: Openmeetings problem
Hello Tamer Ataol,
Please check log files in the log directory.
Thanks,
Vasiliy
On 25.08.2014 15:22, Murat Tamer Ataol wrote:
Hello,
I have a problem after installation. Installation completes ok. After that when I hit the "Enter the Application" link notinited page comes. I tried writing localhost:5080/openmeetings on the address bar. It didnt work. I couldnt find how to come to login page. Login page never comes.
Can you be of any help?
Kind regards,
Tamer Ataol
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part11.02060004.00020602@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
YASAL UYARI:
Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere) gizlidir. T.C. Sağlık Bakanlığı onayı olmaksızın içeriği kopyalanamaz, üçüncü kişilere açıklanamaz veya iletilemez . Bu mesajın gönderilmek istendiği kişi değilseniz (ya da bu e-posta'yı yanlışlıkla aldıysanız), lütfen yollayan kişiyi haberdar ediniz ve mesajı sisteminizden derhal siliniz. T.C. Sağlık Bakanlığı bu mesajın içerdiği bilgilerin doğruluğu veya eksiksiz olduğu konusunda bir garanti vermemektedir. Bu nedenle, bilgilerin ne şekilde olursa olsun içeriğinden, iletilmesinden, alınmasından, saklanmasından T.C. sağlık Bakanlığı sorumlu değildir. Bu mesajın içeriği yazarına ait olup, T.C. Sağlık Bakanlığı görüşlerini içermeyebilir.
Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır.
DISCLAIMER:
This e-mail (including any attachments) may contain confidential and/or privileged information. Copying, disclosure or distribution of the material in this e-mail without The Ministry of Health of Turkey's authority is strictly forbidden. If you are not the intended recipient (or have received this e-mail in error), please notify the sender and delete it from your system immediately. The Ministry of Health of Turkey makes no warranty as to the accuracy or completeness of any information contained in this message and hereby excludes any liability of any kind for the information contained therein or for the information transmission, reception, storage or use of such in any way whatsoever. Any opinions expressed in this message are those of the author and may not necessarily reflect the opinions of The Ministry of Health of Turkey.
This e-mail has been scanned for all computer viruses known to us.
________________________________
Re: YNT: YNT: YNT: Openmeetings problem
Posted by Vasiliy Degtyarev <va...@unipro.ru>.
Please send log files.
On 25.08.2014 16:26, Murat Tamer Ataol wrote:
> I did what you said to create database and reinstalled the
> application. Still appoinments table is not there. Same message
> appears in the log and the login screen doesnt come.
>
> Murat Tamer Ataol
> Sistem Yönetimi Daire Başkanlığı
>
> Sağlık Bakanlığı
> Sağlık Bilgi sistemleri Genel Müdürlüğü
> Mithatpaşa Cad. No:3 Çankaya / Ankara
>
> Yasal Uyarı :
> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
> Şartlar dokümanına tabidir :
> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>
> ------------------------------------------------------------------------
> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
> *Gönderildi:* 25 Ağustos 2014 Pazartesi 12:10
> *Kime:* user@openmeetings.apache.org
> *Konu:* Re: YNT: YNT: Openmeetings problem
>
> You should not create tables, you should create database use this command:
> CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
>
> If you update openmeeting you should make backup and import.
>
> Thanks,
> Vasiliy
>
>
> On 25.08.2014 16:02, Murat Tamer Ataol wrote:
>> I am following the Installation of Apache OpenMeetings 2.x or 3.x in
>> CentOS 6.5 guide from cwiki.apache.org.
>>
>> I am not creating the tables by myself. Installation did that. And
>> there were no errors in the installation.
>>
>>
>> Murat Tamer Ataol
>> Sistem Yönetimi Daire Başkanlığı
>>
>> Sağlık Bakanlığı
>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>
>> Yasal Uyarı :
>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>> Şartlar dokümanına tabidir :
>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>
>> ------------------------------------------------------------------------
>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 11:50
>> *Kime:* user@openmeetings.apache.org
>> *Konu:* Re: YNT: Openmeetings problem
>>
>> What sql server you use?
>> What command you use to create openmeetings database.
>>
>> Please send full log files.
>>
>> Vasiliy
>>
>> On 25.08.2014 15:38, Murat Tamer Ataol wrote:
>>> Hello,
>>>
>>> I checked the log files. There is one error in openmeetings.log.
>>> ----------------------------------------------------------------------------------------
>>> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table
>>> 'openmeetings.appointments' doesn't exist {prepstmnt 641714439
>>> SELECT t0.id, t1.id, t1.comment_field, t1.deleted, t1.name,
>>> t1.starttime, t1.updatetime, t2.id, t2.activatehash, t3.id,
>>> t3.additionalname, t3.comment_field, t3.deleted, t3.email, t3.fax,
>>> t3.phone, t3.starttime, t4.id, t4.code, t4.deleted, t4.name,
>>> t4.shortName, t4.starttime, t4.updatetime, t3.street, t3.town,
>>> t3.updatetime, t3.zip, t2.age, t2.availible, t2.deleted,
>>> t2.externalUserId, t2.externalUserType, t2.firstname,
>>> t2.forceTimeZoneCheck, t2.language_id, t2.lastlogin, t2.lastname,
>>> t2.lasttrans, t2.level_id, t2.login, t2.owner_id, t2.pictureuri,
>>> t2.regdate, t2.resethash, t2.salutations_id, t2.sendSMS,
>>> t2.show_contact_data, t2.show_contact_data_to_contacts, t5.id,
>>> t5.allow, t5.callbackextension, t5.context, t5.defaultuser,
>>> t5.fullcontact, t5.host, t5.ipaddr, t5.lastms, t5.md5secret,
>>> t5.name, t5.nat, t5.port, t5.regseconds, t5.regserver, t5.secret,
>>> t5.type, t5.useragent, t2.starttime, t2.status, t2.time_zone_id,
>>> t2.type, t2.updatetime, t2.user_offers, t2.user_searchs,
>>> t0.is_connected_event, t0.deleted, t0.description,
>>> t0.appointment_endtime, t0.icalId, t0.starttime, t0.isdaily,
>>> t0.ismonthly, t0.isweekly, t0.isyearly, t0.language_id, t0.location,
>>> t6.id, t6.activatehash, t6.adresses_id, t6.age, t6.availible,
>>> t6.deleted, t6.externalUserId, t6.externalUserType, t6.firstname,
>>> t6.forceTimeZoneCheck, t6.language_id, t6.lastlogin, t6.lastname,
>>> t6.lasttrans, t6.level_id, t6.login, t6.owner_id, t6.pictureuri,
>>> t6.regdate, t6.resethash, t6.salutations_id, t6.sendSMS,
>>> t6.show_contact_data, t6.show_contact_data_to_contacts,
>>> t6.sip_user_id, t6.starttime, t6.status, t6.time_zone_id, t6.type,
>>> t6.updatetime, t6.user_offers, t6.user_searchs, t0.password,
>>> t0.is_password_protected, t7.id, t7.deleted, t7.fieldvalues_id,
>>> t7.name, t7.starttime, t7.updatetime, t8.id, t8.activatehash,
>>> t8.adresses_id, t8.age, t8.availible, t8.deleted, t8.externalUserId,
>>> t8.externalUserType, t8.firstname, t8.forceTimeZoneCheck,
>>> t8.language_id, t8.lastlogin, t8.lastname, t8.lasttrans,
>>> t8.level_id, t8.login, t8.owner_id, t8.pictureuri, t8.regdate,
>>> t8.resethash, t8.salutations_id, t8.sendSMS, t8.show_contact_data,
>>> t8.show_contact_data_to_contacts, t8.sip_user_id, t8.starttime,
>>> t8.status, t8.time_zone_id, t8.type, t8.updatetime, t8.user_offers,
>>> t8.user_searchs, t0.is_reminder_email_send, t9.id,
>>> t9.allow_font_styles, t9.allow_recording, t9.allow_user_questions,
>>> t9.appointment, t9.auto_video_select, t9.chat_moderated,
>>> t9.chat_opened, t9.comment_field, t9.confno, t9.deleted,
>>> t9.demo_time, t9.externalRoomId, t9.externalRoomType,
>>> t9.files_opened, t9.hide_actions_menu,
>>> t9.hide_activities_and_actions, t9.hide_chat,
>>> t9.hide_files_explorer, t9.hide_screen_sharing, t9.hide_top_bar,
>>> t9.hide_whiteboard, t9.is_audio_only, t9.is_closed, t9.isdemoroom,
>>> t9.ismoderatedroom, t9.ispublic, t9.name, t9.numberOfPartizipants,
>>> t9.owner_id, t9.pin, t9.redirect_url, t9.roomtypes_id,
>>> t9.show_microphone_status, t9.sip_enabled, t9.starttime,
>>> t9.updatetime, t9.wait_for_recording, t0.appointment_starttime,
>>> t0.appointmentname, t0.updatetime FROM appointments t0 LEFT OUTER
>>> JOIN appointmentcategory t1 ON t0.category_id = t1.id LEFT OUTER
>>> JOIN om_user t6 ON t0.user_id = t6.id LEFT OUTER JOIN
>>> appointmentremindertyps t7 ON t0.remind_id = t7.id LEFT OUTER JOIN
>>> room t9 ON t0.room_id = t9.id LEFT OUTER JOIN om_user t2 ON
>>> t1.user_id = t2.id LEFT OUTER JOIN om_user t8 ON t7.user_id = t8.id
>>> LEFT OUTER JOIN address t3 ON t2.adresses_id = t3.id LEFT OUTER JOIN
>>> sipusers t5 ON t2.sip_user_id = t5.id LEFT OUTER JOIN state t4 ON
>>> t3.state_id = t4.id WHERE (t0.deleted = ? AND
>>> t0.is_reminder_email_send = ? AND (t0.remind_id = ? OR t0.remind_id
>>> = ?) AND (t0.appointment_starttime >= ? AND t0.appointment_starttime
>>> <= ? OR t0.appointment_endtime >= ? AND t0.appointment_endtime <= ?
>>> OR t0.appointment_starttime < ? AND t0.appointment_endtime > ?))}
>>> [code=1146, state=42S02]
>>> at
>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>> at
>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203)
>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>> at
>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59)
>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>> at
>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118)
>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>> at
>>> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268)
>>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>>> -----------------------------------------------------------------------------------
>>>
>>> I dont exacly know why this table is not there. Installation didnt
>>> give any problem. How can I fix this one?
>>>
>>> Kind regards,
>>> Tamer Ataol
>>>
>>> Murat Tamer Ataol
>>> Sistem Yönetimi Daire Başkanlığı
>>>
>>> Sağlık Bakanlığı
>>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>>
>>> Yasal Uyarı :
>>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>>> Şartlar dokümanına tabidir :
>>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>>
>>> ------------------------------------------------------------------------
>>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 11:26
>>> *Kime:* user@openmeetings.apache.org
>>> *Konu:* Re: Openmeetings problem
>>>
>>> Hello Tamer Ataol,
>>>
>>> Please check log files in the log directory.
>>>
>>> Thanks,
>>> Vasiliy
>>>
>>>
>>> On 25.08.2014 15:22, Murat Tamer Ataol wrote:
>>>> Hello,
>>>>
>>>> I have a problem after installation. Installation completes ok.
>>>> After that when I hit the "Enter the Application" link notinited
>>>> page comes. I tried writing localhost:5080/openmeetings on the
>>>> address bar. It didnt work. I couldnt find how to come to login
>>>> page. Login page never comes.
>>>>
>>>> Can you be of any help?
>>>>
>>>> Kind regards,
>>>> Tamer Ataol
>>>>
>>>> Murat Tamer Ataol
>>>> Sistem Yönetimi Daire Başkanlığı
>>>>
>>>> Sağlık Bakanlığı
>>>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>>>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>>>
>>>> Yasal Uyarı :
>>>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>>>> Şartlar dokümanına tabidir :
>>>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>>>
>>>> ------------------------------------------------------------------------
>>>>
>>>> YASAL UYARI:
>>>> Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere)
>>>> gizlidir. T.C. Sağlık Bakanlığı onayı olmaksızın içeriği
>>>> kopyalanamaz, üçüncü kişilere açıklanamaz veya iletilemez . Bu
>>>> mesajın gönderilmek istendiği kişi değilseniz (ya da bu e-posta'yı
>>>> yanlışlıkla aldıysanız), lütfen yollayan kişiyi haberdar ediniz ve
>>>> mesajı sisteminizden derhal siliniz. T.C. Sağlık Bakanlığı bu
>>>> mesajın içerdiği bilgilerin doğruluğu veya eksiksiz olduğu
>>>> konusunda bir garanti vermemektedir. Bu nedenle, bilgilerin ne
>>>> şekilde olursa olsun içeriğinden, iletilmesinden, alınmasından,
>>>> saklanmasından T.C. sağlık Bakanlığı sorumlu değildir. Bu mesajın
>>>> içeriği yazarına ait olup, T.C. Sağlık Bakanlığı görüşlerini
>>>> içermeyebilir.
>>>>
>>>> Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır.
>>>>
>>>> DISCLAIMER:
>>>> This e-mail (including any attachments) may contain confidential
>>>> and/or privileged information. Copying, disclosure or distribution
>>>> of the material in this e-mail without The Ministry of Health of
>>>> Turkey's authority is strictly forbidden. If you are not the
>>>> intended recipient (or have received this e-mail in error), please
>>>> notify the sender and delete it from your system immediately. The
>>>> Ministry of Health of Turkey makes no warranty as to the accuracy
>>>> or completeness of any information contained in this message and
>>>> hereby excludes any liability of any kind for the information
>>>> contained therein or for the information transmission, reception,
>>>> storage or use of such in any way whatsoever. Any opinions
>>>> expressed in this message are those of the author and may not
>>>> necessarily reflect the opinions of The Ministry of Health of Turkey.
>>>>
>>>> This e-mail has been scanned for all computer viruses known to us.
>>>>
>>>> ------------------------------------------------------------------------
>>>>
>>>>
>>>
>>
>
YNT: YNT: YNT: Openmeetings problem
Posted by Murat Tamer Ataol <Ta...@saglik.gov.tr>.
I did what you said to create database and reinstalled the application. Still appoinments table is not there. Same message appears in the log and the login screen doesnt come.
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:imagecce816.JPG@62932dbb.4a8d822e]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru]
Gönderildi: 25 Ağustos 2014 Pazartesi 12:10
Kime: user@openmeetings.apache.org
Konu: Re: YNT: YNT: Openmeetings problem
You should not create tables, you should create database use this command:
CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
If you update openmeeting you should make backup and import.
Thanks,
Vasiliy
On 25.08.2014 16:02, Murat Tamer Ataol wrote:
I am following the Installation of Apache OpenMeetings 2.x or 3.x in CentOS 6.5 guide from cwiki.apache.org.
I am not creating the tables by myself. Installation did that. And there were no errors in the installation.
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part1.04050709.03000009@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 11:50
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: YNT: Openmeetings problem
What sql server you use?
What command you use to create openmeetings database.
Please send full log files.
Vasiliy
On 25.08.2014 15:38, Murat Tamer Ataol wrote:
Hello,
I checked the log files. There is one error in openmeetings.log.
----------------------------------------------------------------------------------------
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'openmeetings.appointments' doesn't exist {prepstmnt 641714439 SELECT t0.id, t1.id, t1.comment_field, t1.deleted, t1.name, t1.starttime, t1.updatetime, t2.id, t2.activatehash, t3.id, t3.additionalname, t3.comment_field, t3.deleted, t3.email, t3.fax, t3.phone, t3.starttime, t4.id, t4.code, t4.deleted, t4.name, t4.shortName, t4.starttime, t4.updatetime, t3.street, t3.town, t3.updatetime, t3.zip, t2.age, t2.availible, t2.deleted, t2.externalUserId, t2.externalUserType, t2.firstname, t2.forceTimeZoneCheck, t2.language_id, t2.lastlogin, t2.lastname, t2.lasttrans, t2.level_id, t2.login, t2.owner_id, t2.pictureuri, t2.regdate, t2.resethash, t2.salutations_id, t2.sendSMS, t2.show_contact_data, t2.show_contact_data_to_contacts, t5.id, t5.allow, t5.callbackextension, t5.context, t5.defaultuser, t5.fullcontact, t5.host, t5.ipaddr, t5.lastms, t5.md5secret, t5.name, t5.nat, t5.port, t5.regseconds, t5.regserver, t5.secret, t5.type, t5.useragent, t2.starttime, t2.status, t2.time_zone_id, t2.type, t2.updatetime, t2.user_offers, t2.user_searchs, t0.is_connected_event, t0.deleted, t0.description, t0.appointment_endtime, t0.icalId, t0.starttime, t0.isdaily, t0.ismonthly, t0.isweekly, t0.isyearly, t0.language_id, t0.location, t6.id, t6.activatehash, t6.adresses_id, t6.age, t6.availible, t6.deleted, t6.externalUserId, t6.externalUserType, t6.firstname, t6.forceTimeZoneCheck, t6.language_id, t6.lastlogin, t6.lastname, t6.lasttrans, t6.level_id, t6.login, t6.owner_id, t6.pictureuri, t6.regdate, t6.resethash, t6.salutations_id, t6.sendSMS, t6.show_contact_data, t6.show_contact_data_to_contacts, t6.sip_user_id, t6.starttime, t6.status, t6.time_zone_id, t6.type, t6.updatetime, t6.user_offers, t6.user_searchs, t0.password, t0.is_password_protected, t7.id, t7.deleted, t7.fieldvalues_id, t7.name, t7.starttime, t7.updatetime, t8.id, t8.activatehash, t8.adresses_id, t8.age, t8.availible, t8.deleted, t8.externalUserId, t8.externalUserType, t8.firstname, t8.forceTimeZoneCheck, t8.language_id, t8.lastlogin, t8.lastname, t8.lasttrans, t8.level_id, t8.login, t8.owner_id, t8.pictureuri, t8.regdate, t8.resethash, t8.salutations_id, t8.sendSMS, t8.show_contact_data, t8.show_contact_data_to_contacts, t8.sip_user_id, t8.starttime, t8.status, t8.time_zone_id, t8.type, t8.updatetime, t8.user_offers, t8.user_searchs, t0.is_reminder_email_send, t9.id, t9.allow_font_styles, t9.allow_recording, t9.allow_user_questions, t9.appointment, t9.auto_video_select, t9.chat_moderated, t9.chat_opened, t9.comment_field, t9.confno, t9.deleted, t9.demo_time, t9.externalRoomId, t9.externalRoomType, t9.files_opened, t9.hide_actions_menu, t9.hide_activities_and_actions, t9.hide_chat, t9.hide_files_explorer, t9.hide_screen_sharing, t9.hide_top_bar, t9.hide_whiteboard, t9.is_audio_only, t9.is_closed, t9.isdemoroom, t9.ismoderatedroom, t9.ispublic, t9.name, t9.numberOfPartizipants, t9.owner_id, t9.pin, t9.redirect_url, t9.roomtypes_id, t9.show_microphone_status, t9.sip_enabled, t9.starttime, t9.updatetime, t9.wait_for_recording, t0.appointment_starttime, t0.appointmentname, t0.updatetime FROM appointments t0 LEFT OUTER JOIN appointmentcategory t1 ON t0.category_id = t1.id LEFT OUTER JOIN om_user t6 ON t0.user_id = t6.id LEFT OUTER JOIN appointmentremindertyps t7 ON t0.remind_id = t7.id LEFT OUTER JOIN room t9 ON t0.room_id = t9.id LEFT OUTER JOIN om_user t2 ON t1.user_id = t2.id LEFT OUTER JOIN om_user t8 ON t7.user_id = t8.id LEFT OUTER JOIN address t3 ON t2.adresses_id = t3.id LEFT OUTER JOIN sipusers t5 ON t2.sip_user_id = t5.id LEFT OUTER JOIN state t4 ON t3.state_id = t4.id WHERE (t0.deleted = ? AND t0.is_reminder_email_send = ? AND (t0.remind_id = ? OR t0.remind_id = ?) AND (t0.appointment_starttime >= ? AND t0.appointment_starttime <= ? OR t0.appointment_endtime >= ? AND t0.appointment_endtime <= ? OR t0.appointment_starttime < ? AND t0.appointment_endtime > ?))} [code=1146, state=42S02]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268) ~[openjpa-bundle-2.2.2.jar:2.2.2]
-----------------------------------------------------------------------------------
I dont exacly know why this table is not there. Installation didnt give any problem. How can I fix this one?
Kind regards,
Tamer Ataol
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part3.01050101.05020305@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 11:26
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: Openmeetings problem
Hello Tamer Ataol,
Please check log files in the log directory.
Thanks,
Vasiliy
On 25.08.2014 15:22, Murat Tamer Ataol wrote:
Hello,
I have a problem after installation. Installation completes ok. After that when I hit the "Enter the Application" link notinited page comes. I tried writing localhost:5080/openmeetings on the address bar. It didnt work. I couldnt find how to come to login page. Login page never comes.
Can you be of any help?
Kind regards,
Tamer Ataol
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part7.08060107.07080306@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
YASAL UYARI:
Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere) gizlidir. T.C. Sağlık Bakanlığı onayı olmaksızın içeriği kopyalanamaz, üçüncü kişilere açıklanamaz veya iletilemez . Bu mesajın gönderilmek istendiği kişi değilseniz (ya da bu e-posta'yı yanlışlıkla aldıysanız), lütfen yollayan kişiyi haberdar ediniz ve mesajı sisteminizden derhal siliniz. T.C. Sağlık Bakanlığı bu mesajın içerdiği bilgilerin doğruluğu veya eksiksiz olduğu konusunda bir garanti vermemektedir. Bu nedenle, bilgilerin ne şekilde olursa olsun içeriğinden, iletilmesinden, alınmasından, saklanmasından T.C. sağlık Bakanlığı sorumlu değildir. Bu mesajın içeriği yazarına ait olup, T.C. Sağlık Bakanlığı görüşlerini içermeyebilir.
Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır.
DISCLAIMER:
This e-mail (including any attachments) may contain confidential and/or privileged information. Copying, disclosure or distribution of the material in this e-mail without The Ministry of Health of Turkey's authority is strictly forbidden. If you are not the intended recipient (or have received this e-mail in error), please notify the sender and delete it from your system immediately. The Ministry of Health of Turkey makes no warranty as to the accuracy or completeness of any information contained in this message and hereby excludes any liability of any kind for the information contained therein or for the information transmission, reception, storage or use of such in any way whatsoever. Any opinions expressed in this message are those of the author and may not necessarily reflect the opinions of The Ministry of Health of Turkey.
This e-mail has been scanned for all computer viruses known to us.
________________________________
Re: YNT: YNT: Openmeetings problem
Posted by Vasiliy Degtyarev <va...@unipro.ru>.
You should not create tables, you should create database use this command:
CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
If you update openmeeting you should make backup and import.
Thanks,
Vasiliy
On 25.08.2014 16:02, Murat Tamer Ataol wrote:
> I am following the Installation of Apache OpenMeetings 2.x or 3.x in
> CentOS 6.5 guide from cwiki.apache.org.
>
> I am not creating the tables by myself. Installation did that. And
> there were no errors in the installation.
>
>
> Murat Tamer Ataol
> Sistem Yönetimi Daire Başkanlığı
>
> Sağlık Bakanlığı
> Sağlık Bilgi sistemleri Genel Müdürlüğü
> Mithatpaşa Cad. No:3 Çankaya / Ankara
>
> Yasal Uyarı :
> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
> Şartlar dokümanına tabidir :
> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>
> ------------------------------------------------------------------------
> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
> *Gönderildi:* 25 Ağustos 2014 Pazartesi 11:50
> *Kime:* user@openmeetings.apache.org
> *Konu:* Re: YNT: Openmeetings problem
>
> What sql server you use?
> What command you use to create openmeetings database.
>
> Please send full log files.
>
> Vasiliy
>
> On 25.08.2014 15:38, Murat Tamer Ataol wrote:
>> Hello,
>>
>> I checked the log files. There is one error in openmeetings.log.
>> ----------------------------------------------------------------------------------------
>> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table
>> 'openmeetings.appointments' doesn't exist {prepstmnt 641714439 SELECT
>> t0.id, t1.id, t1.comment_field, t1.deleted, t1.name, t1.starttime,
>> t1.updatetime, t2.id, t2.activatehash, t3.id, t3.additionalname,
>> t3.comment_field, t3.deleted, t3.email, t3.fax, t3.phone,
>> t3.starttime, t4.id, t4.code, t4.deleted, t4.name, t4.shortName,
>> t4.starttime, t4.updatetime, t3.street, t3.town, t3.updatetime,
>> t3.zip, t2.age, t2.availible, t2.deleted, t2.externalUserId,
>> t2.externalUserType, t2.firstname, t2.forceTimeZoneCheck,
>> t2.language_id, t2.lastlogin, t2.lastname, t2.lasttrans, t2.level_id,
>> t2.login, t2.owner_id, t2.pictureuri, t2.regdate, t2.resethash,
>> t2.salutations_id, t2.sendSMS, t2.show_contact_data,
>> t2.show_contact_data_to_contacts, t5.id, t5.allow,
>> t5.callbackextension, t5.context, t5.defaultuser, t5.fullcontact,
>> t5.host, t5.ipaddr, t5.lastms, t5.md5secret, t5.name, t5.nat,
>> t5.port, t5.regseconds, t5.regserver, t5.secret, t5.type,
>> t5.useragent, t2.starttime, t2.status, t2.time_zone_id, t2.type,
>> t2.updatetime, t2.user_offers, t2.user_searchs,
>> t0.is_connected_event, t0.deleted, t0.description,
>> t0.appointment_endtime, t0.icalId, t0.starttime, t0.isdaily,
>> t0.ismonthly, t0.isweekly, t0.isyearly, t0.language_id, t0.location,
>> t6.id, t6.activatehash, t6.adresses_id, t6.age, t6.availible,
>> t6.deleted, t6.externalUserId, t6.externalUserType, t6.firstname,
>> t6.forceTimeZoneCheck, t6.language_id, t6.lastlogin, t6.lastname,
>> t6.lasttrans, t6.level_id, t6.login, t6.owner_id, t6.pictureuri,
>> t6.regdate, t6.resethash, t6.salutations_id, t6.sendSMS,
>> t6.show_contact_data, t6.show_contact_data_to_contacts,
>> t6.sip_user_id, t6.starttime, t6.status, t6.time_zone_id, t6.type,
>> t6.updatetime, t6.user_offers, t6.user_searchs, t0.password,
>> t0.is_password_protected, t7.id, t7.deleted, t7.fieldvalues_id,
>> t7.name, t7.starttime, t7.updatetime, t8.id, t8.activatehash,
>> t8.adresses_id, t8.age, t8.availible, t8.deleted, t8.externalUserId,
>> t8.externalUserType, t8.firstname, t8.forceTimeZoneCheck,
>> t8.language_id, t8.lastlogin, t8.lastname, t8.lasttrans, t8.level_id,
>> t8.login, t8.owner_id, t8.pictureuri, t8.regdate, t8.resethash,
>> t8.salutations_id, t8.sendSMS, t8.show_contact_data,
>> t8.show_contact_data_to_contacts, t8.sip_user_id, t8.starttime,
>> t8.status, t8.time_zone_id, t8.type, t8.updatetime, t8.user_offers,
>> t8.user_searchs, t0.is_reminder_email_send, t9.id,
>> t9.allow_font_styles, t9.allow_recording, t9.allow_user_questions,
>> t9.appointment, t9.auto_video_select, t9.chat_moderated,
>> t9.chat_opened, t9.comment_field, t9.confno, t9.deleted,
>> t9.demo_time, t9.externalRoomId, t9.externalRoomType,
>> t9.files_opened, t9.hide_actions_menu,
>> t9.hide_activities_and_actions, t9.hide_chat, t9.hide_files_explorer,
>> t9.hide_screen_sharing, t9.hide_top_bar, t9.hide_whiteboard,
>> t9.is_audio_only, t9.is_closed, t9.isdemoroom, t9.ismoderatedroom,
>> t9.ispublic, t9.name, t9.numberOfPartizipants, t9.owner_id, t9.pin,
>> t9.redirect_url, t9.roomtypes_id, t9.show_microphone_status,
>> t9.sip_enabled, t9.starttime, t9.updatetime, t9.wait_for_recording,
>> t0.appointment_starttime, t0.appointmentname, t0.updatetime FROM
>> appointments t0 LEFT OUTER JOIN appointmentcategory t1 ON
>> t0.category_id = t1.id LEFT OUTER JOIN om_user t6 ON t0.user_id =
>> t6.id LEFT OUTER JOIN appointmentremindertyps t7 ON t0.remind_id =
>> t7.id LEFT OUTER JOIN room t9 ON t0.room_id = t9.id LEFT OUTER JOIN
>> om_user t2 ON t1.user_id = t2.id LEFT OUTER JOIN om_user t8 ON
>> t7.user_id = t8.id LEFT OUTER JOIN address t3 ON t2.adresses_id =
>> t3.id LEFT OUTER JOIN sipusers t5 ON t2.sip_user_id = t5.id LEFT
>> OUTER JOIN state t4 ON t3.state_id = t4.id WHERE (t0.deleted = ? AND
>> t0.is_reminder_email_send = ? AND (t0.remind_id = ? OR t0.remind_id =
>> ?) AND (t0.appointment_starttime >= ? AND t0.appointment_starttime <=
>> ? OR t0.appointment_endtime >= ? AND t0.appointment_endtime <= ? OR
>> t0.appointment_starttime < ? AND t0.appointment_endtime > ?))}
>> [code=1146, state=42S02]
>> at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>> at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203)
>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>> at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59)
>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>> at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118)
>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>> at
>> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268)
>> ~[openjpa-bundle-2.2.2.jar:2.2.2]
>> -----------------------------------------------------------------------------------
>>
>> I dont exacly know why this table is not there. Installation didnt
>> give any problem. How can I fix this one?
>>
>> Kind regards,
>> Tamer Ataol
>>
>> Murat Tamer Ataol
>> Sistem Yönetimi Daire Başkanlığı
>>
>> Sağlık Bakanlığı
>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>
>> Yasal Uyarı :
>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>> Şartlar dokümanına tabidir :
>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>
>> ------------------------------------------------------------------------
>> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
>> *Gönderildi:* 25 Ağustos 2014 Pazartesi 11:26
>> *Kime:* user@openmeetings.apache.org
>> *Konu:* Re: Openmeetings problem
>>
>> Hello Tamer Ataol,
>>
>> Please check log files in the log directory.
>>
>> Thanks,
>> Vasiliy
>>
>>
>> On 25.08.2014 15:22, Murat Tamer Ataol wrote:
>>> Hello,
>>>
>>> I have a problem after installation. Installation completes ok.
>>> After that when I hit the "Enter the Application" link notinited
>>> page comes. I tried writing localhost:5080/openmeetings on the
>>> address bar. It didnt work. I couldnt find how to come to login
>>> page. Login page never comes.
>>>
>>> Can you be of any help?
>>>
>>> Kind regards,
>>> Tamer Ataol
>>>
>>> Murat Tamer Ataol
>>> Sistem Yönetimi Daire Başkanlığı
>>>
>>> Sağlık Bakanlığı
>>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>>
>>> Yasal Uyarı :
>>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>>> Şartlar dokümanına tabidir :
>>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>>
>>> ------------------------------------------------------------------------
>>>
>>> YASAL UYARI:
>>> Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere)
>>> gizlidir. T.C. Sağlık Bakanlığı onayı olmaksızın içeriği
>>> kopyalanamaz, üçüncü kişilere açıklanamaz veya iletilemez . Bu
>>> mesajın gönderilmek istendiği kişi değilseniz (ya da bu e-posta'yı
>>> yanlışlıkla aldıysanız), lütfen yollayan kişiyi haberdar ediniz ve
>>> mesajı sisteminizden derhal siliniz. T.C. Sağlık Bakanlığı bu
>>> mesajın içerdiği bilgilerin doğruluğu veya eksiksiz olduğu konusunda
>>> bir garanti vermemektedir. Bu nedenle, bilgilerin ne şekilde olursa
>>> olsun içeriğinden, iletilmesinden, alınmasından, saklanmasından T.C.
>>> sağlık Bakanlığı sorumlu değildir. Bu mesajın içeriği yazarına ait
>>> olup, T.C. Sağlık Bakanlığı görüşlerini içermeyebilir.
>>>
>>> Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır.
>>>
>>> DISCLAIMER:
>>> This e-mail (including any attachments) may contain confidential
>>> and/or privileged information. Copying, disclosure or distribution
>>> of the material in this e-mail without The Ministry of Health of
>>> Turkey's authority is strictly forbidden. If you are not the
>>> intended recipient (or have received this e-mail in error), please
>>> notify the sender and delete it from your system immediately. The
>>> Ministry of Health of Turkey makes no warranty as to the accuracy or
>>> completeness of any information contained in this message and hereby
>>> excludes any liability of any kind for the information contained
>>> therein or for the information transmission, reception, storage or
>>> use of such in any way whatsoever. Any opinions expressed in this
>>> message are those of the author and may not necessarily reflect the
>>> opinions of The Ministry of Health of Turkey.
>>>
>>> This e-mail has been scanned for all computer viruses known to us.
>>>
>>> ------------------------------------------------------------------------
>>>
>>>
>>
>
YNT: YNT: Openmeetings problem
Posted by Murat Tamer Ataol <Ta...@saglik.gov.tr>.
I am following the Installation of Apache OpenMeetings 2.x or 3.x in CentOS 6.5 guide from cwiki.apache.org.
I am not creating the tables by myself. Installation did that. And there were no errors in the installation.
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:imagea780fe.JPG@2f4ba288.44ba798e]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru]
Gönderildi: 25 Ağustos 2014 Pazartesi 11:50
Kime: user@openmeetings.apache.org
Konu: Re: YNT: Openmeetings problem
What sql server you use?
What command you use to create openmeetings database.
Please send full log files.
Vasiliy
On 25.08.2014 15:38, Murat Tamer Ataol wrote:
Hello,
I checked the log files. There is one error in openmeetings.log.
----------------------------------------------------------------------------------------
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'openmeetings.appointments' doesn't exist {prepstmnt 641714439 SELECT t0.id, t1.id, t1.comment_field, t1.deleted, t1.name, t1.starttime, t1.updatetime, t2.id, t2.activatehash, t3.id, t3.additionalname, t3.comment_field, t3.deleted, t3.email, t3.fax, t3.phone, t3.starttime, t4.id, t4.code, t4.deleted, t4.name, t4.shortName, t4.starttime, t4.updatetime, t3.street, t3.town, t3.updatetime, t3.zip, t2.age, t2.availible, t2.deleted, t2.externalUserId, t2.externalUserType, t2.firstname, t2.forceTimeZoneCheck, t2.language_id, t2.lastlogin, t2.lastname, t2.lasttrans, t2.level_id, t2.login, t2.owner_id, t2.pictureuri, t2.regdate, t2.resethash, t2.salutations_id, t2.sendSMS, t2.show_contact_data, t2.show_contact_data_to_contacts, t5.id, t5.allow, t5.callbackextension, t5.context, t5.defaultuser, t5.fullcontact, t5.host, t5.ipaddr, t5.lastms, t5.md5secret, t5.name, t5.nat, t5.port, t5.regseconds, t5.regserver, t5.secret, t5.type, t5.useragent, t2.starttime, t2.status, t2.time_zone_id, t2.type, t2.updatetime, t2.user_offers, t2.user_searchs, t0.is_connected_event, t0.deleted, t0.description, t0.appointment_endtime, t0.icalId, t0.starttime, t0.isdaily, t0.ismonthly, t0.isweekly, t0.isyearly, t0.language_id, t0.location, t6.id, t6.activatehash, t6.adresses_id, t6.age, t6.availible, t6.deleted, t6.externalUserId, t6.externalUserType, t6.firstname, t6.forceTimeZoneCheck, t6.language_id, t6.lastlogin, t6.lastname, t6.lasttrans, t6.level_id, t6.login, t6.owner_id, t6.pictureuri, t6.regdate, t6.resethash, t6.salutations_id, t6.sendSMS, t6.show_contact_data, t6.show_contact_data_to_contacts, t6.sip_user_id, t6.starttime, t6.status, t6.time_zone_id, t6.type, t6.updatetime, t6.user_offers, t6.user_searchs, t0.password, t0.is_password_protected, t7.id, t7.deleted, t7.fieldvalues_id, t7.name, t7.starttime, t7.updatetime, t8.id, t8.activatehash, t8.adresses_id, t8.age, t8.availible, t8.deleted, t8.externalUserId, t8.externalUserType, t8.firstname, t8.forceTimeZoneCheck, t8.language_id, t8.lastlogin, t8.lastname, t8.lasttrans, t8.level_id, t8.login, t8.owner_id, t8.pictureuri, t8.regdate, t8.resethash, t8.salutations_id, t8.sendSMS, t8.show_contact_data, t8.show_contact_data_to_contacts, t8.sip_user_id, t8.starttime, t8.status, t8.time_zone_id, t8.type, t8.updatetime, t8.user_offers, t8.user_searchs, t0.is_reminder_email_send, t9.id, t9.allow_font_styles, t9.allow_recording, t9.allow_user_questions, t9.appointment, t9.auto_video_select, t9.chat_moderated, t9.chat_opened, t9.comment_field, t9.confno, t9.deleted, t9.demo_time, t9.externalRoomId, t9.externalRoomType, t9.files_opened, t9.hide_actions_menu, t9.hide_activities_and_actions, t9.hide_chat, t9.hide_files_explorer, t9.hide_screen_sharing, t9.hide_top_bar, t9.hide_whiteboard, t9.is_audio_only, t9.is_closed, t9.isdemoroom, t9.ismoderatedroom, t9.ispublic, t9.name, t9.numberOfPartizipants, t9.owner_id, t9.pin, t9.redirect_url, t9.roomtypes_id, t9.show_microphone_status, t9.sip_enabled, t9.starttime, t9.updatetime, t9.wait_for_recording, t0.appointment_starttime, t0.appointmentname, t0.updatetime FROM appointments t0 LEFT OUTER JOIN appointmentcategory t1 ON t0.category_id = t1.id LEFT OUTER JOIN om_user t6 ON t0.user_id = t6.id LEFT OUTER JOIN appointmentremindertyps t7 ON t0.remind_id = t7.id LEFT OUTER JOIN room t9 ON t0.room_id = t9.id LEFT OUTER JOIN om_user t2 ON t1.user_id = t2.id LEFT OUTER JOIN om_user t8 ON t7.user_id = t8.id LEFT OUTER JOIN address t3 ON t2.adresses_id = t3.id LEFT OUTER JOIN sipusers t5 ON t2.sip_user_id = t5.id LEFT OUTER JOIN state t4 ON t3.state_id = t4.id WHERE (t0.deleted = ? AND t0.is_reminder_email_send = ? AND (t0.remind_id = ? OR t0.remind_id = ?) AND (t0.appointment_starttime >= ? AND t0.appointment_starttime <= ? OR t0.appointment_endtime >= ? AND t0.appointment_endtime <= ? OR t0.appointment_starttime < ? AND t0.appointment_endtime > ?))} [code=1146, state=42S02]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268) ~[openjpa-bundle-2.2.2.jar:2.2.2]
-----------------------------------------------------------------------------------
I dont exacly know why this table is not there. Installation didnt give any problem. How can I fix this one?
Kind regards,
Tamer Ataol
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part1.04000706.01070101@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru<ma...@unipro.ru>]
Gönderildi: 25 Ağustos 2014 Pazartesi 11:26
Kime: user@openmeetings.apache.org<ma...@openmeetings.apache.org>
Konu: Re: Openmeetings problem
Hello Tamer Ataol,
Please check log files in the log directory.
Thanks,
Vasiliy
On 25.08.2014 15:22, Murat Tamer Ataol wrote:
Hello,
I have a problem after installation. Installation completes ok. After that when I hit the "Enter the Application" link notinited page comes. I tried writing localhost:5080/openmeetings on the address bar. It didnt work. I couldnt find how to come to login page. Login page never comes.
Can you be of any help?
Kind regards,
Tamer Ataol
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part3.07020205.02020507@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
YASAL UYARI:
Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere) gizlidir. T.C. Sağlık Bakanlığı onayı olmaksızın içeriği kopyalanamaz, üçüncü kişilere açıklanamaz veya iletilemez . Bu mesajın gönderilmek istendiği kişi değilseniz (ya da bu e-posta'yı yanlışlıkla aldıysanız), lütfen yollayan kişiyi haberdar ediniz ve mesajı sisteminizden derhal siliniz. T.C. Sağlık Bakanlığı bu mesajın içerdiği bilgilerin doğruluğu veya eksiksiz olduğu konusunda bir garanti vermemektedir. Bu nedenle, bilgilerin ne şekilde olursa olsun içeriğinden, iletilmesinden, alınmasından, saklanmasından T.C. sağlık Bakanlığı sorumlu değildir. Bu mesajın içeriği yazarına ait olup, T.C. Sağlık Bakanlığı görüşlerini içermeyebilir.
Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır.
DISCLAIMER:
This e-mail (including any attachments) may contain confidential and/or privileged information. Copying, disclosure or distribution of the material in this e-mail without The Ministry of Health of Turkey's authority is strictly forbidden. If you are not the intended recipient (or have received this e-mail in error), please notify the sender and delete it from your system immediately. The Ministry of Health of Turkey makes no warranty as to the accuracy or completeness of any information contained in this message and hereby excludes any liability of any kind for the information contained therein or for the information transmission, reception, storage or use of such in any way whatsoever. Any opinions expressed in this message are those of the author and may not necessarily reflect the opinions of The Ministry of Health of Turkey.
This e-mail has been scanned for all computer viruses known to us.
________________________________
Re: YNT: Openmeetings problem
Posted by Vasiliy Degtyarev <va...@unipro.ru>.
What sql server you use?
What command you use to create openmeetings database.
Please send full log files.
Vasiliy
On 25.08.2014 15:38, Murat Tamer Ataol wrote:
> Hello,
>
> I checked the log files. There is one error in openmeetings.log.
> ----------------------------------------------------------------------------------------
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table
> 'openmeetings.appointments' doesn't exist {prepstmnt 641714439 SELECT
> t0.id, t1.id, t1.comment_field, t1.deleted, t1.name, t1.starttime,
> t1.updatetime, t2.id, t2.activatehash, t3.id, t3.additionalname,
> t3.comment_field, t3.deleted, t3.email, t3.fax, t3.phone,
> t3.starttime, t4.id, t4.code, t4.deleted, t4.name, t4.shortName,
> t4.starttime, t4.updatetime, t3.street, t3.town, t3.updatetime,
> t3.zip, t2.age, t2.availible, t2.deleted, t2.externalUserId,
> t2.externalUserType, t2.firstname, t2.forceTimeZoneCheck,
> t2.language_id, t2.lastlogin, t2.lastname, t2.lasttrans, t2.level_id,
> t2.login, t2.owner_id, t2.pictureuri, t2.regdate, t2.resethash,
> t2.salutations_id, t2.sendSMS, t2.show_contact_data,
> t2.show_contact_data_to_contacts, t5.id, t5.allow,
> t5.callbackextension, t5.context, t5.defaultuser, t5.fullcontact,
> t5.host, t5.ipaddr, t5.lastms, t5.md5secret, t5.name, t5.nat, t5.port,
> t5.regseconds, t5.regserver, t5.secret, t5.type, t5.useragent,
> t2.starttime, t2.status, t2.time_zone_id, t2.type, t2.updatetime,
> t2.user_offers, t2.user_searchs, t0.is_connected_event, t0.deleted,
> t0.description, t0.appointment_endtime, t0.icalId, t0.starttime,
> t0.isdaily, t0.ismonthly, t0.isweekly, t0.isyearly, t0.language_id,
> t0.location, t6.id, t6.activatehash, t6.adresses_id, t6.age,
> t6.availible, t6.deleted, t6.externalUserId, t6.externalUserType,
> t6.firstname, t6.forceTimeZoneCheck, t6.language_id, t6.lastlogin,
> t6.lastname, t6.lasttrans, t6.level_id, t6.login, t6.owner_id,
> t6.pictureuri, t6.regdate, t6.resethash, t6.salutations_id,
> t6.sendSMS, t6.show_contact_data, t6.show_contact_data_to_contacts,
> t6.sip_user_id, t6.starttime, t6.status, t6.time_zone_id, t6.type,
> t6.updatetime, t6.user_offers, t6.user_searchs, t0.password,
> t0.is_password_protected, t7.id, t7.deleted, t7.fieldvalues_id,
> t7.name, t7.starttime, t7.updatetime, t8.id, t8.activatehash,
> t8.adresses_id, t8.age, t8.availible, t8.deleted, t8.externalUserId,
> t8.externalUserType, t8.firstname, t8.forceTimeZoneCheck,
> t8.language_id, t8.lastlogin, t8.lastname, t8.lasttrans, t8.level_id,
> t8.login, t8.owner_id, t8.pictureuri, t8.regdate, t8.resethash,
> t8.salutations_id, t8.sendSMS, t8.show_contact_data,
> t8.show_contact_data_to_contacts, t8.sip_user_id, t8.starttime,
> t8.status, t8.time_zone_id, t8.type, t8.updatetime, t8.user_offers,
> t8.user_searchs, t0.is_reminder_email_send, t9.id,
> t9.allow_font_styles, t9.allow_recording, t9.allow_user_questions,
> t9.appointment, t9.auto_video_select, t9.chat_moderated,
> t9.chat_opened, t9.comment_field, t9.confno, t9.deleted, t9.demo_time,
> t9.externalRoomId, t9.externalRoomType, t9.files_opened,
> t9.hide_actions_menu, t9.hide_activities_and_actions, t9.hide_chat,
> t9.hide_files_explorer, t9.hide_screen_sharing, t9.hide_top_bar,
> t9.hide_whiteboard, t9.is_audio_only, t9.is_closed, t9.isdemoroom,
> t9.ismoderatedroom, t9.ispublic, t9.name, t9.numberOfPartizipants,
> t9.owner_id, t9.pin, t9.redirect_url, t9.roomtypes_id,
> t9.show_microphone_status, t9.sip_enabled, t9.starttime,
> t9.updatetime, t9.wait_for_recording, t0.appointment_starttime,
> t0.appointmentname, t0.updatetime FROM appointments t0 LEFT OUTER JOIN
> appointmentcategory t1 ON t0.category_id = t1.id LEFT OUTER JOIN
> om_user t6 ON t0.user_id = t6.id LEFT OUTER JOIN
> appointmentremindertyps t7 ON t0.remind_id = t7.id LEFT OUTER JOIN
> room t9 ON t0.room_id = t9.id LEFT OUTER JOIN om_user t2 ON t1.user_id
> = t2.id LEFT OUTER JOIN om_user t8 ON t7.user_id = t8.id LEFT OUTER
> JOIN address t3 ON t2.adresses_id = t3.id LEFT OUTER JOIN sipusers t5
> ON t2.sip_user_id = t5.id LEFT OUTER JOIN state t4 ON t3.state_id =
> t4.id WHERE (t0.deleted = ? AND t0.is_reminder_email_send = ? AND
> (t0.remind_id = ? OR t0.remind_id = ?) AND (t0.appointment_starttime
> >= ? AND t0.appointment_starttime <= ? OR t0.appointment_endtime >= ?
> AND t0.appointment_endtime <= ? OR t0.appointment_starttime < ? AND
> t0.appointment_endtime > ?))} [code=1146, state=42S02]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> -----------------------------------------------------------------------------------
>
> I dont exacly know why this table is not there. Installation didnt
> give any problem. How can I fix this one?
>
> Kind regards,
> Tamer Ataol
>
> Murat Tamer Ataol
> Sistem Yönetimi Daire Başkanlığı
>
> Sağlık Bakanlığı
> Sağlık Bilgi sistemleri Genel Müdürlüğü
> Mithatpaşa Cad. No:3 Çankaya / Ankara
>
> Yasal Uyarı :
> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
> Şartlar dokümanına tabidir :
> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>
> ------------------------------------------------------------------------
> *Kimden:* Vasiliy Degtyarev [vasya@unipro.ru]
> *Gönderildi:* 25 Ağustos 2014 Pazartesi 11:26
> *Kime:* user@openmeetings.apache.org
> *Konu:* Re: Openmeetings problem
>
> Hello Tamer Ataol,
>
> Please check log files in the log directory.
>
> Thanks,
> Vasiliy
>
>
> On 25.08.2014 15:22, Murat Tamer Ataol wrote:
>> Hello,
>>
>> I have a problem after installation. Installation completes ok. After
>> that when I hit the "Enter the Application" link notinited page
>> comes. I tried writing localhost:5080/openmeetings on the address
>> bar. It didnt work. I couldnt find how to come to login page. Login
>> page never comes.
>>
>> Can you be of any help?
>>
>> Kind regards,
>> Tamer Ataol
>>
>> Murat Tamer Ataol
>> Sistem Yönetimi Daire Başkanlığı
>>
>> Sağlık Bakanlığı
>> Sağlık Bilgi sistemleri Genel Müdürlüğü
>> Mithatpaşa Cad. No:3 Çankaya / Ankara
>>
>> Yasal Uyarı :
>> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
>> Şartlar dokümanına tabidir :
>> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>>
>> ------------------------------------------------------------------------
>>
>> YASAL UYARI:
>> Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere)
>> gizlidir. T.C. Sağlık Bakanlığı onayı olmaksızın içeriği
>> kopyalanamaz, üçüncü kişilere açıklanamaz veya iletilemez . Bu
>> mesajın gönderilmek istendiği kişi değilseniz (ya da bu e-posta'yı
>> yanlışlıkla aldıysanız), lütfen yollayan kişiyi haberdar ediniz ve
>> mesajı sisteminizden derhal siliniz. T.C. Sağlık Bakanlığı bu mesajın
>> içerdiği bilgilerin doğruluğu veya eksiksiz olduğu konusunda bir
>> garanti vermemektedir. Bu nedenle, bilgilerin ne şekilde olursa olsun
>> içeriğinden, iletilmesinden, alınmasından, saklanmasından T.C. sağlık
>> Bakanlığı sorumlu değildir. Bu mesajın içeriği yazarına ait olup,
>> T.C. Sağlık Bakanlığı görüşlerini içermeyebilir.
>>
>> Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır.
>>
>> DISCLAIMER:
>> This e-mail (including any attachments) may contain confidential
>> and/or privileged information. Copying, disclosure or distribution of
>> the material in this e-mail without The Ministry of Health of
>> Turkey's authority is strictly forbidden. If you are not the intended
>> recipient (or have received this e-mail in error), please notify the
>> sender and delete it from your system immediately. The Ministry of
>> Health of Turkey makes no warranty as to the accuracy or completeness
>> of any information contained in this message and hereby excludes any
>> liability of any kind for the information contained therein or for
>> the information transmission, reception, storage or use of such in
>> any way whatsoever. Any opinions expressed in this message are those
>> of the author and may not necessarily reflect the opinions of The
>> Ministry of Health of Turkey.
>>
>> This e-mail has been scanned for all computer viruses known to us.
>>
>> ------------------------------------------------------------------------
>>
>>
>
YNT: Openmeetings problem
Posted by Murat Tamer Ataol <Ta...@saglik.gov.tr>.
Hello,
I checked the log files. There is one error in openmeetings.log.
----------------------------------------------------------------------------------------
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'openmeetings.appointments' doesn't exist {prepstmnt 641714439 SELECT t0.id, t1.id, t1.comment_field, t1.deleted, t1.name, t1.starttime, t1.updatetime, t2.id, t2.activatehash, t3.id, t3.additionalname, t3.comment_field, t3.deleted, t3.email, t3.fax, t3.phone, t3.starttime, t4.id, t4.code, t4.deleted, t4.name, t4.shortName, t4.starttime, t4.updatetime, t3.street, t3.town, t3.updatetime, t3.zip, t2.age, t2.availible, t2.deleted, t2.externalUserId, t2.externalUserType, t2.firstname, t2.forceTimeZoneCheck, t2.language_id, t2.lastlogin, t2.lastname, t2.lasttrans, t2.level_id, t2.login, t2.owner_id, t2.pictureuri, t2.regdate, t2.resethash, t2.salutations_id, t2.sendSMS, t2.show_contact_data, t2.show_contact_data_to_contacts, t5.id, t5.allow, t5.callbackextension, t5.context, t5.defaultuser, t5.fullcontact, t5.host, t5.ipaddr, t5.lastms, t5.md5secret, t5.name, t5.nat, t5.port, t5.regseconds, t5.regserver, t5.secret, t5.type, t5.useragent, t2.starttime, t2.status, t2.time_zone_id, t2.type, t2.updatetime, t2.user_offers, t2.user_searchs, t0.is_connected_event, t0.deleted, t0.description, t0.appointment_endtime, t0.icalId, t0.starttime, t0.isdaily, t0.ismonthly, t0.isweekly, t0.isyearly, t0.language_id, t0.location, t6.id, t6.activatehash, t6.adresses_id, t6.age, t6.availible, t6.deleted, t6.externalUserId, t6.externalUserType, t6.firstname, t6.forceTimeZoneCheck, t6.language_id, t6.lastlogin, t6.lastname, t6.lasttrans, t6.level_id, t6.login, t6.owner_id, t6.pictureuri, t6.regdate, t6.resethash, t6.salutations_id, t6.sendSMS, t6.show_contact_data, t6.show_contact_data_to_contacts, t6.sip_user_id, t6.starttime, t6.status, t6.time_zone_id, t6.type, t6.updatetime, t6.user_offers, t6.user_searchs, t0.password, t0.is_password_protected, t7.id, t7.deleted, t7.fieldvalues_id, t7.name, t7.starttime, t7.updatetime, t8.id, t8.activatehash, t8.adresses_id, t8.age, t8.availible, t8.deleted, t8.externalUserId, t8.externalUserType, t8.firstname, t8.forceTimeZoneCheck, t8.language_id, t8.lastlogin, t8.lastname, t8.lasttrans, t8.level_id, t8.login, t8.owner_id, t8.pictureuri, t8.regdate, t8.resethash, t8.salutations_id, t8.sendSMS, t8.show_contact_data, t8.show_contact_data_to_contacts, t8.sip_user_id, t8.starttime, t8.status, t8.time_zone_id, t8.type, t8.updatetime, t8.user_offers, t8.user_searchs, t0.is_reminder_email_send, t9.id, t9.allow_font_styles, t9.allow_recording, t9.allow_user_questions, t9.appointment, t9.auto_video_select, t9.chat_moderated, t9.chat_opened, t9.comment_field, t9.confno, t9.deleted, t9.demo_time, t9.externalRoomId, t9.externalRoomType, t9.files_opened, t9.hide_actions_menu, t9.hide_activities_and_actions, t9.hide_chat, t9.hide_files_explorer, t9.hide_screen_sharing, t9.hide_top_bar, t9.hide_whiteboard, t9.is_audio_only, t9.is_closed, t9.isdemoroom, t9.ismoderatedroom, t9.ispublic, t9.name, t9.numberOfPartizipants, t9.owner_id, t9.pin, t9.redirect_url, t9.roomtypes_id, t9.show_microphone_status, t9.sip_enabled, t9.starttime, t9.updatetime, t9.wait_for_recording, t0.appointment_starttime, t0.appointmentname, t0.updatetime FROM appointments t0 LEFT OUTER JOIN appointmentcategory t1 ON t0.category_id = t1.id LEFT OUTER JOIN om_user t6 ON t0.user_id = t6.id LEFT OUTER JOIN appointmentremindertyps t7 ON t0.remind_id = t7.id LEFT OUTER JOIN room t9 ON t0.room_id = t9.id LEFT OUTER JOIN om_user t2 ON t1.user_id = t2.id LEFT OUTER JOIN om_user t8 ON t7.user_id = t8.id LEFT OUTER JOIN address t3 ON t2.adresses_id = t3.id LEFT OUTER JOIN sipusers t5 ON t2.sip_user_id = t5.id LEFT OUTER JOIN state t4 ON t3.state_id = t4.id WHERE (t0.deleted = ? AND t0.is_reminder_email_send = ? AND (t0.remind_id = ? OR t0.remind_id = ?) AND (t0.appointment_starttime >= ? AND t0.appointment_starttime <= ? OR t0.appointment_endtime >= ? AND t0.appointment_endtime <= ? OR t0.appointment_starttime < ? AND t0.appointment_endtime > ?))} [code=1146, state=42S02]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268) ~[openjpa-bundle-2.2.2.jar:2.2.2]
-----------------------------------------------------------------------------------
I dont exacly know why this table is not there. Installation didnt give any problem. How can I fix this one?
Kind regards,
Tamer Ataol
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:image6b1a0d.JPG@3c1015a6.48a81f1b]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
Kimden: Vasiliy Degtyarev [vasya@unipro.ru]
Gönderildi: 25 Ağustos 2014 Pazartesi 11:26
Kime: user@openmeetings.apache.org
Konu: Re: Openmeetings problem
Hello Tamer Ataol,
Please check log files in the log directory.
Thanks,
Vasiliy
On 25.08.2014 15:22, Murat Tamer Ataol wrote:
Hello,
I have a problem after installation. Installation completes ok. After that when I hit the "Enter the Application" link notinited page comes. I tried writing localhost:5080/openmeetings on the address bar. It didnt work. I couldnt find how to come to login page. Login page never comes.
Can you be of any help?
Kind regards,
Tamer Ataol
Murat Tamer Ataol
Sistem Yönetimi Daire Başkanlığı
Sağlık Bakanlığı
Sağlık Bilgi sistemleri Genel Müdürlüğü
Mithatpaşa Cad. No:3 Çankaya / Ankara
[cid:part1.01060904.06000207@unipro.ru]
Yasal Uyarı :
Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve Şartlar dokümanına tabidir :
http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
________________________________
YASAL UYARI:
Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere) gizlidir. T.C. Sağlık Bakanlığı onayı olmaksızın içeriği kopyalanamaz, üçüncü kişilere açıklanamaz veya iletilemez . Bu mesajın gönderilmek istendiği kişi değilseniz (ya da bu e-posta'yı yanlışlıkla aldıysanız), lütfen yollayan kişiyi haberdar ediniz ve mesajı sisteminizden derhal siliniz. T.C. Sağlık Bakanlığı bu mesajın içerdiği bilgilerin doğruluğu veya eksiksiz olduğu konusunda bir garanti vermemektedir. Bu nedenle, bilgilerin ne şekilde olursa olsun içeriğinden, iletilmesinden, alınmasından, saklanmasından T.C. sağlık Bakanlığı sorumlu değildir. Bu mesajın içeriği yazarına ait olup, T.C. Sağlık Bakanlığı görüşlerini içermeyebilir.
Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır.
DISCLAIMER:
This e-mail (including any attachments) may contain confidential and/or privileged information. Copying, disclosure or distribution of the material in this e-mail without The Ministry of Health of Turkey's authority is strictly forbidden. If you are not the intended recipient (or have received this e-mail in error), please notify the sender and delete it from your system immediately. The Ministry of Health of Turkey makes no warranty as to the accuracy or completeness of any information contained in this message and hereby excludes any liability of any kind for the information contained therein or for the information transmission, reception, storage or use of such in any way whatsoever. Any opinions expressed in this message are those of the author and may not necessarily reflect the opinions of The Ministry of Health of Turkey.
This e-mail has been scanned for all computer viruses known to us.
________________________________
Re: Openmeetings problem
Posted by Vasiliy Degtyarev <va...@unipro.ru>.
Hello Tamer Ataol,
Please check log files in the log directory.
Thanks,
Vasiliy
On 25.08.2014 15:22, Murat Tamer Ataol wrote:
> Hello,
>
> I have a problem after installation. Installation completes ok. After
> that when I hit the "Enter the Application" link notinited page comes.
> I tried writing localhost:5080/openmeetings on the address bar. It
> didnt work. I couldnt find how to come to login page. Login page never
> comes.
>
> Can you be of any help?
>
> Kind regards,
> Tamer Ataol
>
> Murat Tamer Ataol
> Sistem Yönetimi Daire Başkanlığı
>
> Sağlık Bakanlığı
> Sağlık Bilgi sistemleri Genel Müdürlüğü
> Mithatpaşa Cad. No:3 Çankaya / Ankara
>
> Yasal Uyarı :
> Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve
> Şartlar dokümanına tabidir :
> http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html
>
> ------------------------------------------------------------------------
>
> YASAL UYARI:
> Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere)
> gizlidir. T.C. Sağlık Bakanlığı onayı olmaksızın içeriği kopyalanamaz,
> üçüncü kişilere açıklanamaz veya iletilemez . Bu mesajın gönderilmek
> istendiği kişi değilseniz (ya da bu e-posta'yı yanlışlıkla
> aldıysanız), lütfen yollayan kişiyi haberdar ediniz ve mesajı
> sisteminizden derhal siliniz. T.C. Sağlık Bakanlığı bu mesajın
> içerdiği bilgilerin doğruluğu veya eksiksiz olduğu konusunda bir
> garanti vermemektedir. Bu nedenle, bilgilerin ne şekilde olursa olsun
> içeriğinden, iletilmesinden, alınmasından, saklanmasından T.C. sağlık
> Bakanlığı sorumlu değildir. Bu mesajın içeriği yazarına ait olup, T.C.
> Sağlık Bakanlığı görüşlerini içermeyebilir.
>
> Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır.
>
> DISCLAIMER:
> This e-mail (including any attachments) may contain confidential
> and/or privileged information. Copying, disclosure or distribution of
> the material in this e-mail without The Ministry of Health of Turkey's
> authority is strictly forbidden. If you are not the intended recipient
> (or have received this e-mail in error), please notify the sender and
> delete it from your system immediately. The Ministry of Health of
> Turkey makes no warranty as to the accuracy or completeness of any
> information contained in this message and hereby excludes any
> liability of any kind for the information contained therein or for the
> information transmission, reception, storage or use of such in any way
> whatsoever. Any opinions expressed in this message are those of the
> author and may not necessarily reflect the opinions of The Ministry of
> Health of Turkey.
>
> This e-mail has been scanned for all computer viruses known to us.
>
> ------------------------------------------------------------------------
>
>