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:[email protected]]
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 [[email protected]]
Gönderildi: 25 Ağustos 2014 Pazartesi 11:26
Kime: [email protected]
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:[email protected]]
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.
________________________________
