Hi, Thank you for the prompt answer! One small correction to your files is that in the okm_app.linux must have in the beggining. CREATE DATABASE /*!32312 IF NOT EXISTS*/`okm_app` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */; USE `okm_app`; Now my server is up and running with another error that I will describe it with a later mail. Thank you so much Kind Regards Christos Prassas Γραφείο Ανάπτυξης Ιστοσελίδας Περιφερειακής Δ/σης Πρωτοβάθμιας & Δευτεροβάθμιας Εκπ/σης Θεσσαλίας Υπεύθυνος: Πρασσάς Χρήστος Τηλ. επικοινωνίας: 2410539222 ή 2410539226 http://thess.pde.sch.gr ----- Original Message ----- From: Ιωσήφ Καραγιαννόπουλος To: Scriptum users Sent: Tuesday, October 04, 2011 12:23 PM Subject: Re: Πρόβλημα λειτουργίας Scriptum (MySQL Table issue) Hi, this is a problem with linux and case sensitivity and OpenKM. In linux / Unix the MySQL table names are case sensitive while in windows they are not. OpenKM requires upper case table names for linux. I have already informed the development team and they are currently preparing a new version that address this problem. In the mean time you can use the attached files to properly create the OpenKM tables for linux. Just move them in the scriptum install folder (replace the script file) update your root password and execute the script. 2011/10/4 Γραφείο Ανάπτυξης Ιστοσελίδας ΠΔΕ Θεσσαλίας <webmaster [ at ] thess [ dot ] pde [ dot ] sch [ dot ] gr> Καλημέρα σας, Έκανα εγκατάσταση σε Ubuntu 10.04.3 LTS κανονικά και όταν κάνω RUN τον server στο log file εχω σφάλματα (errors) και δεν μπορώ να συνδεθώ με τους αρχικούς κωδικούς ούτε στο eProtocol ούτε στο OpenKM (μου εμφανίζει Authentication Error). Να σημειώσω ότι όταν δοκίμασα την εγκατάσταση σε Windows δούλεψε κανονικά.... Δοκίμασα τα εξής: Διέγραψα την βάση δεδομένων από την MySQL και έκανα τα sql script κατευθείαν import στην βάση μήπως ΄παρουσιάζει πρόβλημα το install script.. χωρίς αποτέλεσμα. Αν πρέπει να κάνω upgrade σε καινούργια έκδοση ή αν έχετε συγκεκριμένη έκδοση Ubuntu να προτείνετε παρακαλώ να με ενημερώσετε. Να σημειώσω ότι η προσπάθεια εγκατάστασης και ορθής εκκίνησης χωρίς σφάλματα έγινε αρκετές φορές και αρκετές φορές έγινε και επανεγκατάσταση του Ubuntu Server 10.04.3 Τα σφάλματα που έχω στο log file τα χώρισα σε δύο ομάδες: Α. Ομάδα (όσα αφορούν πίνακες που το σύστημα λέει ότι δεν υπάρχουν) Line 6123: 2011-10-04 10:34:30,463 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_USER_ITEMS' doesn't exist Line 6280: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_USER_ITEMS' doesn't exist Line 6303: 2011-10-04 10:34:30,794 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_MIME_TYPE' doesn't exist Line 6460: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_MIME_TYPE' doesn't exist Line 6483: 2011-10-04 10:34:30,824 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't exist Line 6504: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.JBPM_JOB' doesn't exist Line 6530: 2011-10-04 10:34:30,910 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_ACTIVITY' doesn't exist Line 6562: 2011-10-04 10:34:35,858 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't exist Line 6583: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.JBPM_JOB' doesn't exist Line 6923: 2011-10-04 10:34:45,913 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't exist Line 6944: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.JBPM_JOB' doesn't exist Line 15990: 2011-10-04 10:35:00,696 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 16010: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 16059: 2011-10-04 10:35:06,086 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't exist Line 16082: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.JBPM_JOB' doesn't exist Line 17232: 2011-10-04 10:35:46,115 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't exist Line 17253: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.JBPM_JOB' doesn't exist Line 17276: 2011-10-04 10:36:00,019 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17296: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17426: 2011-10-04 10:37:00,022 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17446: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17469: 2011-10-04 10:37:06,131 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't exist Line 17490: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.JBPM_JOB' doesn't exist Line 17615: 2011-10-04 10:38:00,019 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17635: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17760: 2011-10-04 10:39:00,019 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17780: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17905: 2011-10-04 10:39:46,145 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't exist Line 17926: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.JBPM_JOB' doesn't exist Line 17949: 2011-10-04 10:40:00,020 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17969: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 18094: 2011-10-04 10:41:00,019 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 18114: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 18424: 2011-10-04 10:41:59,242 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_USER_DOCUMENT' doesn't exist Line 18522: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_USER_DOCUMENT' doesn't exist Line 18556: 2011-10-04 10:41:59,803 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_ACTIVITY' doesn't exist Οι πίνακες φυσικά υπάρχουν στην βάση... Β. Ομάδα (Όλα όσα έχουν error) Line 592: 2011-10-04 10:33:41,343 DEBUG [org.jboss.system.ServiceConfigurator] SuppressTransformationErrors set to true in jboss.aop:service=AspectManager Line 4819: at org.hsqldb.jdbc.Util.throwError(Unknown Source) Line 4938: at org.hsqldb.jdbc.Util.throwError(Unknown Source) Line 6122: 2011-10-04 10:34:30,462 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 6123: 2011-10-04 10:34:30,463 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_USER_ITEMS' doesn't exist Line 6280: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_USER_ITEMS' doesn't exist Line 6287: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 6287: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 6288: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) Line 6289: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) Line 6302: 2011-10-04 10:34:30,794 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 6303: 2011-10-04 10:34:30,794 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_MIME_TYPE' doesn't exist Line 6304: 2011-10-04 10:34:30,802 ERROR [com.openkm.core.Config] could not execute query Line 6460: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_MIME_TYPE' doesn't exist Line 6467: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 6467: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 6468: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) Line 6469: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) Line 6482: 2011-10-04 10:34:30,811 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 6483: 2011-10-04 10:34:30,824 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't exist Line 6484: 2011-10-04 10:34:30,824 ERROR [org.jbpm.db.JobSession] org.hibernate.exception.SQLGrammarException: could not execute query Line 6485: 2011-10-04 10:34:30,832 ERROR [org.jbpm.job.executor.JobExecutorThread] exception in job executor thread. waiting 5000 milliseconds Line 6504: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.JBPM_JOB' doesn't exist Line 6511: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 6511: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 6512: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) Line 6513: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) Line 6529: 2011-10-04 10:34:30,910 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 6530: 2011-10-04 10:34:30,910 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_ACTIVITY' doesn't exist Line 6531: 2011-10-04 10:34:30,914 ERROR [com.openkm.util.UserActivity] could not insert: [com.openkm.dao.bean.Activity] Line 6561: 2011-10-04 10:34:35,844 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 6562: 2011-10-04 10:34:35,858 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't exist Line 6563: 2011-10-04 10:34:35,858 ERROR [org.jbpm.db.JobSession] org.hibernate.exception.SQLGrammarException: could not execute query Line 6564: 2011-10-04 10:34:35,860 ERROR [org.jbpm.job.executor.JobExecutorThread] exception in job executor thread. waiting 10000 milliseconds Line 6583: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.JBPM_JOB' doesn't exist Line 6590: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 6590: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 6591: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) Line 6592: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) Line 6922: 2011-10-04 10:34:45,884 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 6923: 2011-10-04 10:34:45,913 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't exist Line 6924: 2011-10-04 10:34:45,913 ERROR [org.jbpm.db.JobSession] org.hibernate.exception.SQLGrammarException: could not execute query Line 6925: 2011-10-04 10:34:46,029 ERROR [org.jbpm.job.executor.JobExecutorThread] exception in job executor thread. waiting 20000 milliseconds Line 6944: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.JBPM_JOB' doesn't exist Line 6951: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 6951: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 6952: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) Line 6953: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) Line 15989: 2011-10-04 10:35:00,681 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 15990: 2011-10-04 10:35:00,696 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 15991: 2011-10-04 10:35:00,696 ERROR [com.openkm.core.Cron] could not execute query Line 16010: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 16017: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 16017: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 16018: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) Line 16019: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) Line 16058: 2011-10-04 10:35:06,071 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 16059: 2011-10-04 10:35:06,086 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't exist Line 16060: 2011-10-04 10:35:06,086 ERROR [org.jbpm.db.JobSession] org.hibernate.exception.SQLGrammarException: could not execute query Line 16063: 2011-10-04 10:35:06,092 ERROR [org.jbpm.job.executor.JobExecutorThread] exception in job executor thread. waiting 40000 milliseconds Line 16082: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.JBPM_JOB' doesn't exist Line 16089: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 16089: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 16090: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) Line 16091: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) Line 16500: 2011-10-04 10:35:31,686 INFO [org.springframework.security.config.http.HttpSecurityBeanDefinitionParser] Checking sorted filter chain: [<zkDesktopReuseFilter>, order = -2147483648, Root bean: class [org.springframework.security.web.context.SecurityContextPersistenceFilter]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null, order = 300, Root bean: class [org.springframework.security.web.authentication.logout.LogoutFilter]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null, order = 400, <zkError403Filter>, order = 401, <zkDisableSessionInvalidateFilter>, order = 799, Root bean: class [org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter]; scope=; abstract=f... Line 16502: 2011-10-04 10:35:31,800 DEBUG [org.springframework.web.context.support.XmlWebApplicationContext] Bean factory for Root WebApplicationContext: org.springframework.beans.factory.support.DefaultListableBeanFactory@1abd6b0: defining beans [scriptumUserDetailsService,sriptumLogoutSuccessHandler,org.springframework.security.web.PortMapperImpl#0,org.springframework.security.web.context.HttpSessionSecurityContextRepository#0,org.springframework.security.web.authentication.session.SessionFixationProtectionStrategy#0,org.springframework.security.authentication.ProviderManager#0,org.springframework.security.access.vote.AffirmativeBased#0,org.springframework.security.web.access.intercept.FilterSecurityInterceptor#0,org.springframework.security.web.access.DefaultWebInvocationPrivilegeEvaluator#0,org.springframework.security.authentication.AnonymousAuthenticationProvider#0,org.springframework.security.web.savedrequest.HttpSessionRequestCache#0,org.springframework.security.web.authentication.www.BasicAuth... Line 16510: 2011-10-04 10:35:32,185 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1abd6b0: defining beans [scriptumUserDetailsService,sriptumLogoutSuccessHandler,org.springframework.security.web.PortMapperImpl#0,org.springframework.security.web.context.HttpSessionSecurityContextRepository#0,org.springframework.security.web.authentication.session.SessionFixationProtectionStrategy#0,org.springframework.security.authentication.ProviderManager#0,org.springframework.security.access.vote.AffirmativeBased#0,org.springframework.security.web.access.intercept.FilterSecurityInterceptor#0,org.springframework.security.web.access.DefaultWebInvocationPrivilegeEvaluator#0,org.springframework.security.authentication.AnonymousAuthenticationProvider#0,org.springframework.security.web.savedrequest.HttpSessionRequestCache#0,org.springframework.security.web.authentication.www.BasicAuthenticatio... Line 16758: 2011-10-04 10:35:32,748 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Creating shared instance of singleton bean 'zkError403Filter' Line 16759: 2011-10-04 10:35:32,748 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Creating instance of bean 'zkError403Filter' Line 16760: 2011-10-04 10:35:32,753 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Eagerly caching bean 'zkError403Filter' to allow for resolving potential circular references Line 16763: 2011-10-04 10:35:32,758 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Invoking afterPropertiesSet() on bean with name 'zkError403Filter' Line 16764: 2011-10-04 10:35:32,758 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Finished creating instance of bean 'zkError403Filter' Line 16831: 2011-10-04 10:35:32,854 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'zkError403Filter' Line 16853: 2011-10-04 10:35:33,016 ERROR [STDERR] Oct 4, 2011 10:35:32 AM org.zkoss.zk.ui.http.WebManager <init>:111 Line 16855: 2011-10-04 10:35:33,058 ERROR [STDERR] Oct 4, 2011 10:35:33 AM org.zkoss.zk.ui.sys.ConfigParser parseConfigXml:148 Line 16857: 2011-10-04 10:35:33,269 ERROR [STDERR] Oct 4, 2011 10:35:33 AM org.zkoss.zk.ui.sys.ConfigParser parse:259 Line 17083: <element maxOccurs='1' minOccurs='0' name='error' type='string'/> Line 17231: 2011-10-04 10:35:46,110 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 17232: 2011-10-04 10:35:46,115 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't exist Line 17233: 2011-10-04 10:35:46,115 ERROR [org.jbpm.db.JobSession] org.hibernate.exception.SQLGrammarException: could not execute query Line 17234: 2011-10-04 10:35:46,121 ERROR [org.jbpm.job.executor.JobExecutorThread] exception in job executor thread. waiting 80000 milliseconds Line 17253: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.JBPM_JOB' doesn't exist Line 17260: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 17260: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 17261: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) Line 17262: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) Line 17275: 2011-10-04 10:36:00,018 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 17276: 2011-10-04 10:36:00,019 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17277: 2011-10-04 10:36:00,019 ERROR [com.openkm.core.Cron] could not execute query Line 17296: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17303: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 17303: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 17304: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) Line 17305: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) Line 17327: 2011-10-04 10:36:24,499 ERROR [STDERR] Oct 4, 2011 10:36:24 AM gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl getInstance Line 17374: 2011-10-04 10:36:25,573 ERROR [org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS] SOAP request exception Line 17401: at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) Line 17401: at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) Line 17421: 2011-10-04 10:36:25,917 ERROR [STDERR] Oct 4, 2011 10:36:25 AM gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse Line 17421: 2011-10-04 10:36:25,917 ERROR [STDERR] Oct 4, 2011 10:36:25 AM gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse Line 17424: 2011-10-04 10:36:25,918 ERROR [gr.scriptum.eprotocol.mailclients.FetchIncomingMailsWork] java.lang.Exception: Response [requestId=6fc71d80-716a-463d-bd67-cd8dcea71314, completed=Tue Oct 04 10:36:25 EEST 2011, eCode=0001, eMessage=java.lang.NullPointerException] Line 17425: 2011-10-04 10:37:00,020 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 17426: 2011-10-04 10:37:00,022 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17427: 2011-10-04 10:37:00,023 ERROR [com.openkm.core.Cron] could not execute query Line 17446: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17453: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 17453: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 17454: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) Line 17455: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) Line 17468: 2011-10-04 10:37:06,131 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 17469: 2011-10-04 10:37:06,131 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't exist Line 17470: 2011-10-04 10:37:06,131 ERROR [org.jbpm.db.JobSession] org.hibernate.exception.SQLGrammarException: could not execute query Line 17471: 2011-10-04 10:37:06,135 ERROR [org.jbpm.job.executor.JobExecutorThread] exception in job executor thread. waiting 160000 milliseconds Line 17490: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.JBPM_JOB' doesn't exist Line 17497: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 17497: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 17498: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) Line 17499: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) Line 17521: 2011-10-04 10:37:26,030 ERROR [STDERR] Oct 4, 2011 10:37:26 AM gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl getInstance Line 17563: 2011-10-04 10:37:26,062 ERROR [org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS] SOAP request exception Line 17590: at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) Line 17590: at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) Line 17610: 2011-10-04 10:37:26,081 ERROR [STDERR] Oct 4, 2011 10:37:26 AM gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse Line 17610: 2011-10-04 10:37:26,081 ERROR [STDERR] Oct 4, 2011 10:37:26 AM gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse Line 17613: 2011-10-04 10:37:26,081 ERROR [gr.scriptum.eprotocol.mailclients.FetchIncomingMailsWork] java.lang.Exception: Response [requestId=37dbe7c5-2f3e-4891-abff-355d8ba4fd7d, completed=Tue Oct 04 10:37:26 EEST 2011, eCode=0001, eMessage=java.lang.NullPointerException] Line 17614: 2011-10-04 10:38:00,019 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 17615: 2011-10-04 10:38:00,019 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17616: 2011-10-04 10:38:00,019 ERROR [com.openkm.core.Cron] could not execute query Line 17635: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17642: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 17642: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 17643: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) Line 17644: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) Line 17666: 2011-10-04 10:38:26,121 ERROR [STDERR] Oct 4, 2011 10:38:26 AM gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl getInstance Line 17708: 2011-10-04 10:38:26,134 ERROR [org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS] SOAP request exception Line 17735: at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) Line 17735: at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) Line 17755: 2011-10-04 10:38:26,145 ERROR [STDERR] Oct 4, 2011 10:38:26 AM gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse Line 17755: 2011-10-04 10:38:26,145 ERROR [STDERR] Oct 4, 2011 10:38:26 AM gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse Line 17758: 2011-10-04 10:38:26,145 ERROR [gr.scriptum.eprotocol.mailclients.FetchIncomingMailsWork] java.lang.Exception: Response [requestId=6019eb35-d7e8-40f7-afac-64495208cd31, completed=Tue Oct 04 10:38:26 EEST 2011, eCode=0001, eMessage=java.lang.NullPointerException] Line 17759: 2011-10-04 10:39:00,018 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 17760: 2011-10-04 10:39:00,019 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17761: 2011-10-04 10:39:00,019 ERROR [com.openkm.core.Cron] could not execute query Line 17780: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17787: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 17787: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 17788: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) Line 17789: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) Line 17811: 2011-10-04 10:39:26,195 ERROR [STDERR] Oct 4, 2011 10:39:26 AM gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl getInstance Line 17853: 2011-10-04 10:39:26,209 ERROR [org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS] SOAP request exception Line 17880: at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) Line 17880: at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) Line 17900: 2011-10-04 10:39:26,219 ERROR [STDERR] Oct 4, 2011 10:39:26 AM gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse Line 17900: 2011-10-04 10:39:26,219 ERROR [STDERR] Oct 4, 2011 10:39:26 AM gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse Line 17903: 2011-10-04 10:39:26,220 ERROR [gr.scriptum.eprotocol.mailclients.FetchIncomingMailsWork] java.lang.Exception: Response [requestId=d36e7457-60c6-4378-95cf-55d0079d5c50, completed=Tue Oct 04 10:39:26 EEST 2011, eCode=0001, eMessage=java.lang.NullPointerException] Line 17904: 2011-10-04 10:39:46,144 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 17905: 2011-10-04 10:39:46,145 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't exist Line 17906: 2011-10-04 10:39:46,145 ERROR [org.jbpm.db.JobSession] org.hibernate.exception.SQLGrammarException: could not execute query Line 17907: 2011-10-04 10:39:46,148 ERROR [org.jbpm.job.executor.JobExecutorThread] exception in job executor thread. waiting 320000 milliseconds Line 17926: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.JBPM_JOB' doesn't exist Line 17933: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 17933: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 17934: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) Line 17935: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) Line 17948: 2011-10-04 10:40:00,019 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 17949: 2011-10-04 10:40:00,020 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17950: 2011-10-04 10:40:00,021 ERROR [com.openkm.core.Cron] could not execute query Line 17969: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 17976: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 17976: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 17977: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) Line 17978: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) Line 18000: 2011-10-04 10:40:26,257 ERROR [STDERR] Oct 4, 2011 10:40:26 AM gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl getInstance Line 18042: 2011-10-04 10:40:26,270 ERROR [org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS] SOAP request exception Line 18069: at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) Line 18069: at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) Line 18089: 2011-10-04 10:40:26,281 ERROR [STDERR] Oct 4, 2011 10:40:26 AM gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse Line 18089: 2011-10-04 10:40:26,281 ERROR [STDERR] Oct 4, 2011 10:40:26 AM gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse Line 18092: 2011-10-04 10:40:26,281 ERROR [gr.scriptum.eprotocol.mailclients.FetchIncomingMailsWork] java.lang.Exception: Response [requestId=70249393-75c4-4e84-8d67-d1e381cf746d, completed=Tue Oct 04 10:40:26 EEST 2011, eCode=0001, eMessage=java.lang.NullPointerException] Line 18093: 2011-10-04 10:41:00,018 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 18094: 2011-10-04 10:41:00,019 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 18095: 2011-10-04 10:41:00,019 ERROR [com.openkm.core.Cron] could not execute query Line 18114: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_CRON_TAB' doesn't exist Line 18120: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 18120: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 18121: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) Line 18122: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) Line 18144: 2011-10-04 10:41:26,373 ERROR [STDERR] Oct 4, 2011 10:41:26 AM gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl getInstance Line 18186: 2011-10-04 10:41:26,415 ERROR [org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS] SOAP request exception Line 18213: at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) Line 18213: at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) Line 18233: 2011-10-04 10:41:26,437 ERROR [STDERR] Oct 4, 2011 10:41:26 AM gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse Line 18233: 2011-10-04 10:41:26,437 ERROR [STDERR] Oct 4, 2011 10:41:26 AM gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse Line 18236: 2011-10-04 10:41:26,438 ERROR [gr.scriptum.eprotocol.mailclients.FetchIncomingMailsWork] java.lang.Exception: Response [requestId=0b085f71-9b97-4aa4-b638-ed6dd2ad97af, completed=Tue Oct 04 10:41:26 EEST 2011, eCode=0001, eMessage=java.lang.NullPointerException] Line 18282: 2011-10-04 10:41:57,288 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1abd6b0: defining beans [scriptumUserDetailsService,sriptumLogoutSuccessHandler,org.springframework.security.web.PortMapperImpl#0,org.springframework.security.web.context.HttpSessionSecurityContextRepository#0,org.springframework.security.web.authentication.session.SessionFixationProtectionStrategy#0,org.springframework.security.authentication.ProviderManager#0,org.springframework.security.access.vote.AffirmativeBased#0,org.springframework.security.web.access.intercept.FilterSecurityInterceptor#0,org.springframework.security.web.access.DefaultWebInvocationPrivilegeEvaluator#0,org.springframework.security.authentication.AnonymousAuthenticationProvider#0,org.springframework.security.web.savedrequest.HttpSessionRequestCache#0,org.springframework.security.web.authentication.www.BasicAuthenticationEntryP... Line 18301: 2011-10-04 10:41:57,299 DEBUG [org.springframework.beans.factory.support.DisposableBeanAdapter] Invoking destroy() on bean with name 'zkError403Filter' Line 18302: 2011-10-04 10:41:57,299 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Retrieved dependent beans for bean '(inner bean)#61': [zkError403Filter] Line 18423: 2011-10-04 10:41:59,242 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 18424: 2011-10-04 10:41:59,242 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_USER_DOCUMENT' doesn't exist Line 18522: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_USER_DOCUMENT' doesn't exist Line 18528: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 18528: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) Line 18529: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) Line 18530: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) Line 18555: 2011-10-04 10:41:59,803 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 Line 18556: 2011-10-04 10:41:59,803 ERROR [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_ACTIVITY' doesn't exist Line 18557: 2011-10-04 10:41:59,815 ERROR [com.openkm.util.UserActivity] could not insert: [com.openkm.dao.bean.Activity] Με εκτίμηση Χρήστος Πρασσάς Γραφείο Ανάπτυξης Ιστοσελίδας Περιφερειακής Δ/σης Πρωτοβάθμιας & Δευτεροβάθμιας Εκπ/σης Θεσσαλίας Υπεύθυνος: Πρασσάς Χρήστος Τηλ. επικοινωνίας: 2410539222 ή 2410539226 http://thess.pde.sch.gr _______________________________________________ scriptum-users mailing list scriptum-users [ at ] ellak [ dot ] gr http://lists.ellak.gr/listinfo/scriptum-users -- Ιωσήφ Καραγιαννόπουλος Τεχνική υποστήριξη. Email: ict2 [ at ] antiproedros [ dot ] gov [ dot ] gr Phone: +30 213 150 2122 / 2100 ------------------------------------------------------------------------------ _______________________________________________ scriptum-users mailing list scriptum-users [ at ] ellak [ dot ] gr http://lists.ellak.gr/listinfo/scriptum-users