Problème d'initialisation de la base harvester

user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '4:df3ea10aa88b25360fb16891e3f42e0f' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 27.
user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: UPDATE cache_filter SET data = '<div class=\"emailFilter\">Bonjour,\nLa catégorie \"5 Pédagogique\" (Educational) du LOM donne la suite \nd\'éléments :\nlom:interactivityType | lom:learningResourceType | \nlom:interactivityLevel | lom:semanticDensity | lom:intendedEndUserRole | \nlom:context | lom:typicalAgeRange | lom:difficulty | \nlom:typicalLearningTime | lom:description | lom:language\nOr dans l\'éditeur (v 1.1.1), pour les fichiers \n\"\\lom-full\\c\n</div>\n', created = 1507747566, expire = 1507833966, headers = '', serialized = 0 WHERE cid = '4:df3ea10aa88b25360fb16891e3f42e0f' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 112.
user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '4:df3ea10aa88b25360fb16891e3f42e0f' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 27.
user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: UPDATE cache_filter SET data = '<div class=\"emailFilter\">Bonjour,\nLa catégorie \"5 Pédagogique\" (Educational) du LOM donne la suite \nd\'éléments :\nlom:interactivityType | lom:learningResourceType | \nlom:interactivityLevel | lom:semanticDensity | lom:intendedEndUserRole | \nlom:context | lom:typicalAgeRange | lom:difficulty | \nlom:typicalLearningTime | lom:description | lom:language\nOr dans l\'éditeur (v 1.1.1), pour les fichiers \n\"\\lom-full\\c\n</div>\n', created = 1507747566, expire = 1507833966, headers = '', serialized = 0 WHERE cid = '4:df3ea10aa88b25360fb16891e3f42e0f' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 112.
user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '4:06cb160eb283122a2ac3c451e9056cd4' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 27.
user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: UPDATE cache_filter SET data = '<div class=\"emailFilter\">Bonjour,\nJ\'ai un soucis avec le ant init-harvester. \nJ\'obtiens le résultat mis à la fin du message. \nLa ligne qui m\'interpelle est : \n [java] oriharvester: 0 \norg.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78) \n - Unknown initial character set index \'192\' received from server. Initial \nclient character set can be forced via the \'characterEncoding\' property.\nAprès une recherche sur le net, j\'ai suivi les solutions proposées pour ce \ntype d\'erreur à savoir mettre les lignes suivantes dans /etc/my.cnf : \ncharacter_set_server=utf8 \ncollation_server=utf8_unicode_ci\nrien n\'y fait..... \nQuelqu\'un a-t-il une idée ?\nCordialement \nElyes Soumrani\nBuildfile: build.xml\nprepareBuild:\ncompile: \n [javac] Compiling 8 source files to \n/usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes \n [javac] \n/usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:46: \nwarning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and \nmay be removed in a future release \n [javac] import com.sun.org.apache.xpath.internal.XPathAPI; \n [javac] ^ \n [javac] \n/usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:289: \nwarning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and \nmay be removed in a future release \n [javac] return XPathAPI.eval(getDocument(), xpath, \nnamespaceElement).str(); \n [javac] ^ \n [javac] \n/usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:308: \nwarning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and \nmay be removed in a future release \n [javac] return XPathAPI.selectNodeList(getDocument(), xpath, \nnamespaceElement); \n [javac] ^ \n [javac] Note: Some input files use unchecked or unsafe operations. \n [javac] Note: Recompile with -Xlint:unchecked for details. \n [javac] 3 warnings \n [echo] on change les paramètres dans build/WEB-INF/classes/properties ... \n [copy] Copying 1 file to \n/usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes/properties \n [echo] création du fichier de configuration ori.properties ... \n [copy] Copying 1 file to \n/usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes/properties \n [echo] Will log in /usr/local/ori/tomcat-harvester/logs, using prod mode. \n [copy] Copying 1 file to \n/usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes\ninit: \n [if] \n [if] Warning. You\'re going to initialize/erase SQL \n [if] DataBase of ORI-OAI-Harvester \n[y,N] \ny \n [java] init \n [java] oriharvester: 0 \norg.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78) \n - Unknown initial character set index \'192\' received from server. Initial \nclient character set can be forced via the \'characterEncoding\' property. \n [java] oriharvester: 10 \norg.orioai.harvesting.domain.service.InitDatabaseService.main(InitDatabaseService.java:34) \n - can\'t init dabatabase \n [java] org.springframework.beans.factory.BeanCreationException: Error \ncreating bean with name \'hibernateTemplate\' defined in class path resource \n[properties/spring/common/dao/dao.xml]: Cannot resolve reference to bean \n\'sessionFactory\' while setting bean property \'sessionFactory\'; nested exception \nis org.springframework.beans.factory.BeanCreationException: Error creating bean \nwith name \'sessionFactory\' defined in class path resource \n[properties/spring/common/dao/dao.xml]: Invocation of init method failed; \nnested exception is org.hibernate.HibernateException: Hibernate Dialect must be \nexplicitly set \n [java] Caused by: \n [java] org.springframework.beans.factory.BeanCreationException: Error \ncreating bean with name \'sessionFactory\' defined in class path resource \n[properties/spring/common/dao/dao.xml]: Invocation of init method failed; \nnested exception is org.hibernate.HibernateException: Hibernate Dialect must be \nexplicitly set \n [java] Caused by: \n [java] org.hibernate.HibernateException: Hibernate Dialect must be \nexplicitly set \n [java] at \norg.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:57) \n [java] at \norg.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39) \n [java] at \norg.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426) \n [java] at \norg.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128) \n [java] at \norg.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073) \n [java] at \norg.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298) \n [java] at \norg.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:807) \n [java] at \norg.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:740) \n [java] at \norg.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:131) \n [java] at \norg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1062) \n [java] at \norg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1029) \n [java] at \norg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:420) \n [java] at \norg.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245) \n [java] at \norg.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) \n [java] at \norg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242) \n [java] at \norg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156) \n [java] at \norg.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:246) \n [java] at \norg.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:128) \n [java] at \norg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:955) \n [java] at \norg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:729) \n [java] at \norg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:416) \n [java] at \norg.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245) \n [java] at \norg.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) \n [java] at \norg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242) \n [java] at \norg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156) \n [java] at \norg.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:290) \n [java] at \norg.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:348) \n [java] at \norg.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:89) \n [java] at \norg.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:74) \n [java] at \norg.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:65) \n [java] at org.orioai.utils.BeanUtils.initBeanFactory(BeanUtils.java:21) \n [java] at org.orioai.utils.BeanUtils.getBeanFactory(BeanUtils.java:39) \n [java] at \norg.orioai.harvesting.domain.service.InitDatabaseService.getFactory(InitDatabaseService.java:82) \n [java] at \norg.orioai.harvesting.domain.service.InitDatabaseService.initSpring(InitDatabaseService.java:92) \n [java] at \norg.orioai.harvesting.domain.service.InitDatabaseService.execute(InitDatabaseService.java:56) \n [java] at \norg.orioai.harvesting.domain.service.InitDatabaseService.main(InitDatabaseService.java:31)\nBUILD SUCCESSFUL \nTotal time: 8 seconds\n-- \nCe message a été vérifié par MailScanner \npour des virus ou des polluriels et rien de \nsuspect n\'a été trouvé.\n</div>\n', created = 1507747566, expire = 1507833966, headers = '', serialized = 0 WHERE cid = '4:06cb160eb283122a2ac3c451e9056cd4' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 112.
user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '4:23d4bf3a8898711a2b1db2b26a90bba5' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 27.
user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: UPDATE cache_filter SET data = '<div class=\"emailFilter\">Bonjour,\nA priori vous installez ORI-OAI via la procédure quickinstall (ce qui \nest le plus commode). \nUn système de propagation de configuration est en place dans cette \nprocédure.\nIci en résumé :\n* Cf l\'erreur, la propriété \"Hibernate Dialect\" pose problème donc dans \nle fichier properties/spring/common/dao/dao.xml \n* Dans dao.xml, on trouve \n<prop \nkey=\"hibernate.dialect\">${hibernate.properties.dialect}</prop>\n* hibernate.properties.dialect est une propriété spring remplacée \ndynamiquement à l\'exécution par ce que l\'on trouve ici dans \nori.properties - par défaut on a \nhibernate.properties.dialect=[HARVESTER_SQL_DIALECT] \n* [HARVESTER_SQL_DIALECT] est configuré dans le \ncommons-parameters.properties du QuickInstall. Cela étant propagé par la \ntarget init-build-harvester.\n=> 1ère question, après avoir configuré entre autre le \nHARVESTER_SQL_DIALECT depuis commons-parameters.properties du \nQuickInstall, avez vous bien fait avant le ant init-harvester un ant \ninit-build-all ou au moins un ant init-build-harvester ? \nCF \n<a href=\"http://sourcesup.cru.fr/ori-oai-commons/quick-install/1.1.1/installation.html#1.2.2\" title=\"http://sourcesup.cru.fr/ori-oai-commons/quick-install/1.1.1/installation.html#1.2.2\">http://sourcesup.cru.fr/ori-oai-commons/quick-install/1.1.1/installation...</a>\nCordialement, \nVincent Bonamy.\nElyes Soumrani wrote: \n<div class=\"emailFilter_Toggle\">\n<blockquote class=\"emailFilter_Author_0\">> Bonjour, \n> \n> J\'ai un soucis avec le ant init-harvester. \n> J\'obtiens le résultat mis à la fin du message. \n> La ligne qui m\'interpelle est : \n> [java] oriharvester: 0 \n> org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78) \n> - Unknown initial character set index \'192\' received from server. Initial \n> client character set can be forced via the \'characterEncoding\' property. \n> \n> Après une recherche sur le net, j\'ai suivi les solutions proposées pour ce \n> type d\'erreur à savoir mettre les lignes suivantes dans /etc/my.cnf : \n> character_set_server=utf8 \n> collation_server=utf8_unicode_ci \n> \n> rien n\'y fait..... \n> Quelqu\'un a-t-il une idée ? \n> \n> Cordialement \n> Elyes Soumrani \n> \n> \n> Buildfile: build.xml \n> \n> prepareBuild: \n> \n> compile: \n> [javac] Compiling 8 source files to \n> /usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes \n> [javac] \n> /usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:46: \n> warning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and \n> may be removed in a future release \n> [javac] import com.sun.org.apache.xpath.internal.XPathAPI; \n> [javac] ^ \n> [javac] \n> /usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:289: \n> warning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and \n> may be removed in a future release \n> [javac] return XPathAPI.eval(getDocument(), xpath, \n> namespaceElement).str(); \n> [javac] ^ \n> [javac] \n> /usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:308: \n> warning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and \n> may be removed in a future release \n> [javac] return XPathAPI.selectNodeList(getDocument(), xpath, \n> namespaceElement); \n> [javac] ^ \n> [javac] Note: Some input files use unchecked or unsafe operations. \n> [javac] Note: Recompile with -Xlint:unchecked for details. \n> [javac] 3 warnings \n> [echo] on change les paramètres dans build/WEB-INF/classes/properties ... \n> [copy] Copying 1 file to \n> /usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes/properties \n> [echo] création du fichier de configuration ori.properties ... \n> [copy] Copying 1 file to \n> /usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes/properties \n> [echo] Will log in /usr/local/ori/tomcat-harvester/logs, using prod mode. \n> [copy] Copying 1 file to \n> /usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes \n> \n> init: \n> [if] \n> [if] Warning. You\'re going to initialize/erase SQL \n> [if] DataBase of ORI-OAI-Harvester \n> [y,N] \n> y \n> [java] init \n> [java] oriharvester: 0 \n> org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78) \n> - Unknown initial character set index \'192\' received from server. Initial \n> client character set can be forced via the \'characterEncoding\' property. \n> [java] oriharvester: 10 \n> org.orioai.harvesting.domain.service.InitDatabaseService.main(InitDatabaseService.java:34) \n> - can\'t init dabatabase \n> [java] org.springframework.beans.factory.BeanCreationException: Error \n> creating bean with name \'hibernateTemplate\' defined in class path resource \n> [properties/spring/common/dao/dao.xml]: Cannot resolve reference to bean \n> \'sessionFactory\' while setting bean property \'sessionFactory\'; nested exception \n> is org.springframework.beans.factory.BeanCreationException: Error creating bean \n> with name \'sessionFactory\' defined in class path resource \n> [properties/spring/common/dao/dao.xml]: Invocation of init method failed; \n> nested exception is org.hibernate.HibernateException: Hibernate Dialect must be \n> explicitly set \n> [java] Caused by: \n> [java] org.springframework.beans.factory.BeanCreationException: Error \n> creating bean with name \'sessionFactory\' defined in class path resource \n> [properties/spring/common/dao/dao.xml]: Invocation of init method failed; \n> nested exception is org.hibernate.HibernateException: Hibernate Dialect must be \n> explicitly set \n> [java] Caused by: \n> [java] org.hibernate.HibernateException: Hibernate Dialect must be \n> explicitly set \n> [java] at \n> org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:57) \n> [java] at \n> org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39) \n> [java] at \n> org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426) \n> [java] at \n> org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128) \n> [java] at \n> org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073) \n> [java] at \n> org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298) \n> [java] at \n> org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:807) \n> [java] at \n> org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:740) \n> [java] at \n> org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:131) \n> [java] at \n> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1062) \n> [java] at \n> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1029) \n> [java] at \n> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:420) \n> [java] at \n> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245) \n> [java] at \n> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) \n> [java] at \n> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242) \n> [java] at \n> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156) \n> [java] at \n> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:246) \n> [java] at \n> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:128) \n> [java] at \n> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:955) \n> [java] at \n> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:729) \n> [java] at \n> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:416) \n> [java] at \n> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245) \n> [java] at \n> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) \n> [java] at \n> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242) \n> [java] at \n> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156) \n> [java] at \n> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:290) \n> [java] at \n> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:348) \n> [java] at \n> org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:89) \n> [java] at \n> org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:74) \n> [java] at \n> org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:65) \n> [java] at org.orioai.utils.BeanUtils.initBeanFactory(BeanUtils.java:21) \n> [java] at org.orioai.utils.BeanUtils.getBeanFactory(BeanUtils.java:39) \n> [java] at \n> org.orioai.harvesting.domain.service.InitDatabaseService.getFactory(InitDatabaseService.java:82) \n> [java] at \n> org.orioai.harvesting.domain.service.InitDatabaseService.initSpring(InitDatabaseService.java:92) \n> [java] at \n> org.orioai.harvesting.domain.service.InitDatabaseService.execute(InitDatabaseService.java:56) \n> [java] at \n> org.orioai.harvesting.domain.service.InitDatabaseService.main(InitDatabaseService.java:31) \n> \n> BUILD SUCCESSFUL \n> Total time: 8 seconds \n> \n> </div>\n</blockquote>\n-- \nCe message a été vérifié par MailScanner \npour des virus ou des polluriels et rien de \nsuspect n\'a été trouvé.\n</div>\n', created = 1507747567, expire = 1507833967, headers = '', serialized = 0 WHERE cid = '4:23d4bf3a8898711a2b1db2b26a90bba5' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 112.
user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '4:fc20fa4e818301c412282d7a3897ed46' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 27.
user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: UPDATE cache_filter SET data = '<div class=\"emailFilter\">Bonjour,\nElyes Soumrani a écrit : \n<div class=\"emailFilter_Toggle\">\n<blockquote class=\"emailFilter_Author_0\">> Bonjour, \n> \n> J\'ai un soucis avec le ant init-harvester. \n> J\'obtiens le résultat mis à la fin du message. \n> La ligne qui m\'interpelle est : \n> [java] oriharvester: 0 \n> org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78) \n> - Unknown initial character set index \'192\' received from server. Initial \n> client character set can be forced via the \'characterEncoding\' property. \n> \n> Après une recherche sur le net, j\'ai suivi les solutions proposées pour ce \n> type d\'erreur à savoir mettre les lignes suivantes dans /etc/my.cnf : \n> character_set_server=utf8 \n> collation_server=utf8_unicode_ci \n> \n> </div>\n</blockquote>\nDiagnostic :\nCette manip ne va pas, je pense, modifier l\'encodage des bases déjà \ncrées, mais juste définir un encodage par défaut pour la création des \nbases et tables, donc c\'est normal que vous n\'ayez aucun changement.\nPour vérifier cela, et diagnostiquer le pb d\'encodage lié à la connexion \nMySQL, vous devez voir quel est l\'encodage réel de votre base harvester, \nà l\'aide de commande SQL :\nUSE ori-harvester;\nSHOW VARIABLES LIKE \"character_set_database\"; \nCela affiche l\'encodage de la base (utf8, latin1 ...) \n(Vu l\'excepetion dans votre cas, ça ne m\'étonnerais pas que votre base \nsoit en latin1)\nSHOW VARIABLES LIKE \"collation_database\";\nSolution proposée :\nVous pouvez tenter d\'ajouter un paramètre characterEncoding à l\'URL de \nconnection à la base, en utilisant la valeur renvoyée par la commande \nSQL, ou en essyant les valeurs utf-8, puis iso-8859-1 si ça ne marche pas\n1. Si vous utilisez le quic-install : \nfichier : commons-parameters.properties\n# SQL server used for ori-oai-harvester persistence \nHARVESTER_SQL_CONNECTION_URL=jdbc:mysql://localhost/ori-harvester?characterEncoding \n=utf8 \nou \nHARVESTER_SQL_CONNECTION_URL=jdbc:mysql://localhost/ori-harvester?characterEncoding \n=latin1 \n2. Si non : \nfichier : conf/properties/ori.properties \nhibernate.connection.url=jdbc:mysql://localhost/ori-harvester?characterEncoding \n=utf8 \nou \nhibernate.connection.url=jdbc:mysql://localhost/ori-harvester?characterEncoding \n=latin1\nCordialement,\nFrançois\n<div class=\"emailFilter_Toggle\">\n<blockquote class=\"emailFilter_Author_0\">> rien n\'y fait..... \n> Quelqu\'un a-t-il une idée ? \n> \n> Cordialement \n> Elyes Soumrani \n> \n> \n> Buildfile: build.xml \n> \n> prepareBuild: \n> \n> compile: \n> [javac] Compiling 8 source files to \n> /usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes \n> [javac] \n> /usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:46: \n> warning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and \n> may be removed in a future release \n> [javac] import com.sun.org.apache.xpath.internal.XPathAPI; \n> [javac] ^ \n> [javac] \n> /usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:289: \n> warning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and \n> may be removed in a future release \n> [javac] return XPathAPI.eval(getDocument(), xpath, \n> namespaceElement).str(); \n> [javac] ^ \n> [javac] \n> /usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:308: \n> warning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and \n> may be removed in a future release \n> [javac] return XPathAPI.selectNodeList(getDocument(), xpath, \n> namespaceElement); \n> [javac] ^ \n> [javac] Note: Some input files use unchecked or unsafe operations. \n> [javac] Note: Recompile with -Xlint:unchecked for details. \n> [javac] 3 warnings \n> [echo] on change les paramètres dans build/WEB-INF/classes/properties ... \n> [copy] Copying 1 file to \n> /usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes/properties \n> [echo] création du fichier de configuration ori.properties ... \n> [copy] Copying 1 file to \n> /usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes/properties \n> [echo] Will log in /usr/local/ori/tomcat-harvester/logs, using prod mode. \n> [copy] Copying 1 file to \n> /usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes \n> \n> init: \n> [if] \n> [if] Warning. You\'re going to initialize/erase SQL \n> [if] DataBase of ORI-OAI-Harvester \n> [y,N] \n> y \n> [java] init \n> [java] oriharvester: 0 \n> org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78) \n> - Unknown initial character set index \'192\' received from server. Initial \n> client character set can be forced via the \'characterEncoding\' property. \n> [java] oriharvester: 10 \n> org.orioai.harvesting.domain.service.InitDatabaseService.main(InitDatabaseService.java:34) \n> - can\'t init dabatabase \n> [java] org.springframework.beans.factory.BeanCreationException: Error \n> creating bean with name \'hibernateTemplate\' defined in class path resource \n> [properties/spring/common/dao/dao.xml]: Cannot resolve reference to bean \n> \'sessionFactory\' while setting bean property \'sessionFactory\'; nested exception \n> is org.springframework.beans.factory.BeanCreationException: Error creating bean \n> with name \'sessionFactory\' defined in class path resource \n> [properties/spring/common/dao/dao.xml]: Invocation of init method failed; \n> nested exception is org.hibernate.HibernateException: Hibernate Dialect must be \n> explicitly set \n> [java] Caused by: \n> [java] org.springframework.beans.factory.BeanCreationException: Error \n> creating bean with name \'sessionFactory\' defined in class path resource \n> [properties/spring/common/dao/dao.xml]: Invocation of init method failed; \n> nested exception is org.hibernate.HibernateException: Hibernate Dialect must be \n> explicitly set \n> [java] Caused by: \n> [java] org.hibernate.HibernateException: Hibernate Dialect must be \n> explicitly set \n> [java] at \n> org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:57) \n> [java] at \n> org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39) \n> [java] at \n> org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426) \n> [java] at \n> org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128) \n> [java] at \n> org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073) \n> [java] at \n> org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298) \n> [java] at \n> org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:807) \n> [java] at \n> org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:740) \n> [java] at \n> org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:131) \n> [java] at \n> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1062) \n> [java] at \n> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1029) \n> [java] at \n> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:420) \n> [java] at \n> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245) \n> [java] at \n> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) \n> [java] at \n> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242) \n> [java] at \n> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156) \n> [java] at \n> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:246) \n> [java] at \n> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:128) \n> [java] at \n> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:955) \n> [java] at \n> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:729) \n> [java] at \n> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:416) \n> [java] at \n> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245) \n> [java] at \n> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) \n> [java] at \n> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242) \n> [java] at \n> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156) \n> [java] at \n> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:290) \n> [java] at \n> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:348) \n> [java] at \n> org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:89) \n> [java] at \n> org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:74) \n> [java] at \n> org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:65) \n> [java] at org.orioai.utils.BeanUtils.initBeanFactory(BeanUtils.java:21) \n> [java] at org.orioai.utils.BeanUtils.getBeanFactory(BeanUtils.java:39) \n> [java] at \n> org.orioai.harvesting.domain.service.InitDatabaseService.getFactory(InitDatabaseService.java:82) \n> [java] at \n> org.orioai.harvesting.domain.service.InitDatabaseService.initSpring(InitDatabaseService.java:92) \n> [java] at \n> org.orioai.harvesting.domain.service.InitDatabaseService.execute(InitDatabaseService.java:56) \n> [java] at \n> org.orioai.harvesting.domain.service.InitDatabaseService.main(InitDatabaseService.java:31) \n> \n> BUILD SUCCESSFUL \n> Total time: 8 seconds \n> \n> </div>\n</blockquote>\n-- \nCe message a été vérifié par MailScanner \npour des virus ou des polluriels et rien de \nsuspect n\'a été trouvé.\n</div>\n', created = 1507747567, expire = 1507833967, headers = '', serialized = 0 WHERE cid = '4:fc20fa4e818301c412282d7a3897ed46' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 112.
user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '4:2714be66b6a14fa3ceda54a84045a019' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 27.
user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: UPDATE cache_filter SET data = '<div class=\"emailFilter\"><!DOCTYPE html PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">\n<html>\n<head>\n <meta content=\"text/html;charset=ISO-8859-1\" http-equiv=\"Content-Type\">\n</head>\n<body bgcolor=\"#ffffff\" text=\"#3333ff\">\nBonjour, \n \nDésolé pour le retour tardif, j\'ai mis du temps à essayer vos\nsolutions.... \n \n@ Vincent : j\'avais effectivement négligé l\'importance du ant\ninit-build-all..... \nDans un 1er temps ça n\'avait pas réglé mon problème car à force de\nchercher j\'ai touché un peu à tout.... \nPuis quand j\'ai remis mes fichiers de config d\'aplomb et créé ma\nnouvelle base, je me suis rendu compte de son importance ! \n \n@ François : mes bases étaient bien en utf8 mais rien à faire ! J\'ai\nl\'impression que le nom choisi pour la base (ori-harvester) posait\nproblème.... \nJe l\'ai donc supprimé, puis j\'en ai créé une nouvelle : \ncreate database `harvest` DEFAULT CHARACTER SET utf8 COLLATE\nutf8_general_ci; \n \nTout est rentré dans l\'ordre ! \nMerci encore pour vos explications très utiles ! \nCordialement \nElyes \n \nFrançois Jannin a écrit :\n<div class=\"emailFilter_Toggle\"><div class=\"emailFilter_Author_0\"><blockquote>Bonjour,\n \n \nElyes Soumrani a écrit :\n \n <div class=\"emailFilter_Author_1\"><blockquote type=\"cite\">Bonjour,\n \n \nJ\'ai un soucis avec le ant init-harvester.\n \nJ\'obtiens le résultat mis à la fin du message.\n \nLa ligne qui m\'interpelle est :\n \n [java] oriharvester: 0\n \norg.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78)\n \n - Unknown initial character set index \'192\' received from server.\nInitial\n \nclient character set can be forced via the \'characterEncoding\'\nproperty.\n \n \nAprès une recherche sur le net, j\'ai suivi les solutions proposées pour\nce\n \ntype d\'erreur à savoir mettre les lignes suivantes dans /etc/my.cnf :\n \ncharacter_set_server=utf8\n \ncollation_server=utf8_unicode_ci\n \n \n  </blockquote></div>\nDiagnostic :\n \n \nCette manip ne va pas, je pense, modifier l\'encodage des bases déjà\ncrées, mais juste définir un encodage par défaut pour la création des\nbases et tables, donc c\'est normal que vous n\'ayez aucun changement.\n \n \nPour vérifier cela, et diagnostiquer le pb d\'encodage lié à la\nconnexion MySQL, vous devez voir quel est l\'encodage réel de votre base\nharvester, à l\'aide de commande SQL :\n \n \nUSE ori-harvester;\n \n \nSHOW VARIABLES LIKE  \"character_set_database\";\n \nCela affiche l\'encodage de la base (utf8, latin1 ...)\n \n(Vu l\'excepetion dans votre cas, ça ne m\'étonnerais pas que votre base\nsoit en latin1)\n \n \nSHOW VARIABLES LIKE \"collation_database\";\n \n \nSolution proposée :\n \n \nVous pouvez  tenter d\'ajouter un paramètre characterEncoding à l\'URL de\nconnection à la base, en utilisant la valeur renvoyée par la commande\nSQL, ou en essyant les valeurs utf-8, puis iso-8859-1 si ça ne marche\npas\n \n \n1. Si vous utilisez le quic-install :\n \nfichier : commons-parameters.properties\n \n \n# SQL server used for ori-oai-harvester persistence\n \nHARVESTER_SQL_CONNECTION_URL=jdbc:mysql://localhost/ori-harvester?characterEncoding\n=utf8\n \nou\n \nHARVESTER_SQL_CONNECTION_URL=jdbc:mysql://localhost/ori-harvester?characterEncoding\n=latin1\n \n2. Si non :\n \nfichier : conf/properties/ori.properties\n \nhibernate.connection.url=jdbc:mysql://localhost/ori-harvester?characterEncoding\n=utf8\n \nou\n \nhibernate.connection.url=jdbc:mysql://localhost/ori-harvester?characterEncoding\n=latin1\n \n \n \nCordialement,\n \n \nFrançois\n \n \n \n \n \n \n \n \n <div class=\"emailFilter_Author_1\"><blockquote type=\"cite\">rien n\'y fait.....\n \nQuelqu\'un a-t-il une idée ?\n \n \nCordialement\n \nElyes Soumrani\n \n \n \nBuildfile: build.xml\n \n \nprepareBuild:\n \n \ncompile:\n \n    [javac] Compiling 8 source files to\n \n/usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes\n \n    [javac]\n \n/usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:46:\n \nwarning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary\nAPI and\n \nmay be removed in a future release\n \n    [javac] import com.sun.org.apache.xpath.internal.XPathAPI;\n \n    [javac]                                         ^\n \n    [javac]\n \n/usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:289:\n \nwarning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary\nAPI and\n \nmay be removed in a future release\n \n    [javac]         return XPathAPI.eval(getDocument(), xpath,\n \nnamespaceElement).str();\n \n    [javac]                ^\n \n    [javac]\n \n/usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:308:\n \nwarning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary\nAPI and\n \nmay be removed in a future release\n \n    [javac]         return XPathAPI.selectNodeList(getDocument(),\nxpath,\n \nnamespaceElement);\n \n    [javac]                ^\n \n    [javac] Note: Some input files use unchecked or unsafe operations.\n \n    [javac] Note: Recompile with -Xlint:unchecked for details.\n \n    [javac] 3 warnings\n \n     [echo] on change les paramètres dans\nbuild/WEB-INF/classes/properties ...\n \n     [copy] Copying 1 file to\n \n/usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes/properties\n \n     [echo] création du fichier de configuration ori.properties ...\n \n     [copy] Copying 1 file to\n \n/usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes/properties\n \n     [echo] Will log in /usr/local/ori/tomcat-harvester/logs, using\nprod mode.\n \n     [copy] Copying 1 file to\n \n/usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes\n \n \ninit:\n \n       [if]\n \n       [if] Warning. You\'re going to initialize/erase SQL\n \n       [if]                                     DataBase of\nORI-OAI-Harvester\n \n[y,N]\n \ny\n \n     [java] init\n \n     [java] oriharvester: 0\n \norg.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78)\n \n - Unknown initial character set index \'192\' received from server.\nInitial\n \nclient character set can be forced via the \'characterEncoding\'\nproperty.\n \n     [java]  oriharvester: 10\n \norg.orioai.harvesting.domain.service.InitDatabaseService.main(InitDatabaseService.java:34)\n \n - can\'t init dabatabase\n \n     [java]  org.springframework.beans.factory.BeanCreationException:\nError\n \ncreating bean with name \'hibernateTemplate\' defined in class path\nresource\n \n[properties/spring/common/dao/dao.xml]: Cannot resolve reference to\nbean\n \n\'sessionFactory\' while setting bean property \'sessionFactory\'; nested\nexception\n \nis org.springframework.beans.factory.BeanCreationException: Error\ncreating bean\n \nwith name \'sessionFactory\' defined in class path resource\n \n[properties/spring/common/dao/dao.xml]: Invocation of init method\nfailed;\n \nnested exception is org.hibernate.HibernateException: Hibernate Dialect\nmust be\n \nexplicitly set\n \n     [java] Caused by:\n \n     [java] org.springframework.beans.factory.BeanCreationException:\nError\n \ncreating bean with name \'sessionFactory\' defined in class path resource\n \n[properties/spring/common/dao/dao.xml]: Invocation of init method\nfailed;\n \nnested exception is org.hibernate.HibernateException: Hibernate Dialect\nmust be\n \nexplicitly set\n \n     [java] Caused by:\n \n     [java] org.hibernate.HibernateException: Hibernate Dialect must be\n \nexplicitly set\n \n     [java]     at\n \norg.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:57)\n \n     [java]     at\n \norg.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)\n \n     [java]     at\n \norg.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426)\n \n     [java]     at\n \norg.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128)\n \n     [java]     at\n \norg.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073)\n \n     [java]     at\n \norg.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)\n \n     [java]     at\n \norg.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:807)\n \n     [java]     at\n \norg.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:740)\n \n     [java]     at\n \norg.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:131)\n \n     [java]     at\n \norg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1062)\n \n     [java]     at\n \norg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1029)\n \n     [java]     at\n \norg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:420)\n \n     [java]     at\n \norg.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)\n \n     [java]     at\n \norg.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)\n \n     [java]     at\n \norg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)\n \n     [java]     at\n \norg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156)\n \n     [java]     at\n \norg.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:246)\n \n     [java]     at\n \norg.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:128)\n \n     [java]     at\n \norg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:955)\n \n     [java]     at\n \norg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:729)\n \n     [java]     at\n \norg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:416)\n \n     [java]     at\n \norg.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)\n \n     [java]     at\n \norg.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)\n \n     [java]     at\n \norg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)\n \n     [java]     at\n \norg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156)\n \n     [java]     at\n \norg.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:290)\n \n     [java]     at\n \norg.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:348)\n \n     [java]     at\n \norg.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:89)\n \n     [java]     at\n \norg.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:74)\n \n     [java]     at\n \norg.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:65)\n \n     [java]     at\norg.orioai.utils.BeanUtils.initBeanFactory(BeanUtils.java:21)\n \n     [java]     at\norg.orioai.utils.BeanUtils.getBeanFactory(BeanUtils.java:39)\n \n     [java]     at\n \norg.orioai.harvesting.domain.service.InitDatabaseService.getFactory(InitDatabaseService.java:82)\n \n     [java]     at\n \norg.orioai.harvesting.domain.service.InitDatabaseService.initSpring(InitDatabaseService.java:92)\n \n     [java]     at\n \norg.orioai.harvesting.domain.service.InitDatabaseService.execute(InitDatabaseService.java:56)\n \n     [java]     at\n \norg.orioai.harvesting.domain.service.InitDatabaseService.main(InitDatabaseService.java:31)\n \n \nBUILD SUCCESSFUL\n \nTotal time: 8 seconds\n \n \n  </blockquote></div>\n \n</blockquote></div></div>\n</body>\n -- \n Ce message a été vérifié par\n pour des virus ou des polluriels et rien de\n suspect n\'a été trouvé.\n</html>\n\n\n\n</div>', created = 1507747567, expire = 1507833967, headers = '', serialized = 0 WHERE cid = '4:2714be66b6a14fa3ceda54a84045a019' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 112.

4 messages / 0 nouveaux

Sujet clos

Dernière contribution

29 novembre 2008 - 5:42pm

elyessoumrani

Problème d'initialisation de la base harvester

Bonjour,

J'ai un soucis avec le ant init-harvester.
J'obtiens le résultat mis à la fin du message.
La ligne qui m'interpelle est :
[java] oriharvester: 0
org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78)
- Unknown initial character set index '192' received from server. Initial
client character set can be forced via the 'characterEncoding' property.

Après une recherche sur le net, j'ai suivi les solutions proposées pour ce
type d'erreur à savoir mettre les lignes suivantes dans /etc/my.cnf :
character_set_server=utf8
collation_server=utf8_unicode_ci

rien n'y fait.....
Quelqu'un a-t-il une idée ?

Cordialement
Elyes Soumrani

Buildfile: build.xml

prepareBuild:

compile:
[javac] Compiling 8 source files to
/usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes
[javac]
/usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:46:
warning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and
may be removed in a future release
[javac] import com.sun.org.apache.xpath.internal.XPathAPI;
[javac] ^
[javac]
/usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:289:
warning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and
may be removed in a future release
[javac] return XPathAPI.eval(getDocument(), xpath,
namespaceElement).str();
[javac] ^
[javac]
/usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:308:
warning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and
may be removed in a future release
[javac] return XPathAPI.selectNodeList(getDocument(), xpath,
namespaceElement);
[javac] ^
[javac] Note: Some input files use unchecked or unsafe operations.
[javac] Note: Recompile with -Xlint:unchecked for details.
[javac] 3 warnings
[echo] on change les paramètres dans build/WEB-INF/classes/properties ...
[copy] Copying 1 file to
/usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes/properties
[echo] création du fichier de configuration ori.properties ...
[copy] Copying 1 file to
/usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes/properties
[echo] Will log in /usr/local/ori/tomcat-harvester/logs, using prod mode.
[copy] Copying 1 file to
/usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes

init:
[if]
[if] Warning. You're going to initialize/erase SQL
[if] DataBase of ORI-OAI-Harvester
[y,N]
y
[java] init
[java] oriharvester: 0
org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78)
- Unknown initial character set index '192' received from server. Initial
client character set can be forced via the 'characterEncoding' property.
[java] oriharvester: 10
org.orioai.harvesting.domain.service.InitDatabaseService.main(InitDatabaseService.java:34)
- can't init dabatabase
[java] org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'hibernateTemplate' defined in class path resource
[properties/spring/common/dao/dao.xml]: Cannot resolve reference to bean
'sessionFactory' while setting bean property 'sessionFactory'; nested exception
is org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'sessionFactory' defined in class path resource
[properties/spring/common/dao/dao.xml]: Invocation of init method failed;
nested exception is org.hibernate.HibernateException: Hibernate Dialect must be
explicitly set
[java] Caused by:
[java] org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'sessionFactory' defined in class path resource
[properties/spring/common/dao/dao.xml]: Invocation of init method failed;
nested exception is org.hibernate.HibernateException: Hibernate Dialect must be
explicitly set
[java] Caused by:
[java] org.hibernate.HibernateException: Hibernate Dialect must be
explicitly set
[java] at
org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:57)
[java] at
org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)
[java] at
org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426)
[java] at
org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128)
[java] at
org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073)
[java] at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)
[java] at
org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:807)
[java] at
org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:740)
[java] at
org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:131)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1062)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1029)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:420)
[java] at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)
[java] at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)
[java] at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)
[java] at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156)
[java] at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:246)
[java] at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:128)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:955)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:729)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:416)
[java] at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)
[java] at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)
[java] at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)
[java] at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156)
[java] at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:290)
[java] at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:348)
[java] at
org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:89)
[java] at
org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:74)
[java] at
org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:65)
[java] at org.orioai.utils.BeanUtils.initBeanFactory(BeanUtils.java:21)
[java] at org.orioai.utils.BeanUtils.getBeanFactory(BeanUtils.java:39)
[java] at
org.orioai.harvesting.domain.service.InitDatabaseService.getFactory(InitDatabaseService.java:82)
[java] at
org.orioai.harvesting.domain.service.InitDatabaseService.initSpring(InitDatabaseService.java:92)
[java] at
org.orioai.harvesting.domain.service.InitDatabaseService.execute(InitDatabaseService.java:56)
[java] at
org.orioai.harvesting.domain.service.InitDatabaseService.main(InitDatabaseService.java:31)

BUILD SUCCESSFUL
Total time: 8 seconds

--
Ce message a été vérifié par MailScanner
pour des virus ou des polluriels et rien de
suspect n'a été trouvé.

3 décembre 2008 - 11:22am

vincentbonamy

Bonjour,

A priori vous installez ORI-OAI via la procédure quickinstall (ce qui
est le plus commode).
Un système de propagation de configuration est en place dans cette
procédure.

Ici en résumé :

* Cf l'erreur, la propriété "Hibernate Dialect" pose problème donc dans
le fichier properties/spring/common/dao/dao.xml
* Dans dao.xml, on trouve
key="hibernate.dialect">${hibernate.properties.dialect} * hibernate.properties.dialect est une propriété spring remplacée
dynamiquement à l'exécution par ce que l'on trouve ici dans
ori.properties - par défaut on a
hibernate.properties.dialect=[HARVESTER_SQL_DIALECT]
* [HARVESTER_SQL_DIALECT] est configuré dans le
commons-parameters.properties du QuickInstall. Cela étant propagé par la
target init-build-harvester.

=> 1ère question, après avoir configuré entre autre le
HARVESTER_SQL_DIALECT depuis commons-parameters.properties du
QuickInstall, avez vous bien fait avant le ant init-harvester un ant
init-build-all ou au moins un ant init-build-harvester ?
CF
http://sourcesup.cru.fr/ori-oai-commons/quick-install/1.1.1/installation...

Cordialement,
Vincent Bonamy.

Elyes Soumrani wrote:

> Bonjour,
>
> J'ai un soucis avec le ant init-harvester.
> J'obtiens le résultat mis à la fin du message.
> La ligne qui m'interpelle est :
> [java] oriharvester: 0
> org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78)
> - Unknown initial character set index '192' received from server. Initial
> client character set can be forced via the 'characterEncoding' property.
>
> Après une recherche sur le net, j'ai suivi les solutions proposées pour ce
> type d'erreur à savoir mettre les lignes suivantes dans /etc/my.cnf :
> character_set_server=utf8
> collation_server=utf8_unicode_ci
>
> rien n'y fait.....
> Quelqu'un a-t-il une idée ?
>
> Cordialement
> Elyes Soumrani
>
>
> Buildfile: build.xml
>
> prepareBuild:
>
> compile:
> [javac] Compiling 8 source files to
> /usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes
> [javac]
> /usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:46:
> warning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and
> may be removed in a future release
> [javac] import com.sun.org.apache.xpath.internal.XPathAPI;
> [javac] ^
> [javac]
> /usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:289:
> warning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and
> may be removed in a future release
> [javac] return XPathAPI.eval(getDocument(), xpath,
> namespaceElement).str();
> [javac] ^
> [javac]
> /usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:308:
> warning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and
> may be removed in a future release
> [javac] return XPathAPI.selectNodeList(getDocument(), xpath,
> namespaceElement);
> [javac] ^
> [javac] Note: Some input files use unchecked or unsafe operations.
> [javac] Note: Recompile with -Xlint:unchecked for details.
> [javac] 3 warnings
> [echo] on change les paramètres dans build/WEB-INF/classes/properties ...
> [copy] Copying 1 file to
> /usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes/properties
> [echo] création du fichier de configuration ori.properties ...
> [copy] Copying 1 file to
> /usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes/properties
> [echo] Will log in /usr/local/ori/tomcat-harvester/logs, using prod mode.
> [copy] Copying 1 file to
> /usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes
>
> init:
> [if]
> [if] Warning. You're going to initialize/erase SQL
> [if] DataBase of ORI-OAI-Harvester
> [y,N]
> y
> [java] init
> [java] oriharvester: 0
> org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78)
> - Unknown initial character set index '192' received from server. Initial
> client character set can be forced via the 'characterEncoding' property.
> [java] oriharvester: 10
> org.orioai.harvesting.domain.service.InitDatabaseService.main(InitDatabaseService.java:34)
> - can't init dabatabase
> [java] org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name 'hibernateTemplate' defined in class path resource
> [properties/spring/common/dao/dao.xml]: Cannot resolve reference to bean
> 'sessionFactory' while setting bean property 'sessionFactory'; nested exception
> is org.springframework.beans.factory.BeanCreationException: Error creating bean
> with name 'sessionFactory' defined in class path resource
> [properties/spring/common/dao/dao.xml]: Invocation of init method failed;
> nested exception is org.hibernate.HibernateException: Hibernate Dialect must be
> explicitly set
> [java] Caused by:
> [java] org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name 'sessionFactory' defined in class path resource
> [properties/spring/common/dao/dao.xml]: Invocation of init method failed;
> nested exception is org.hibernate.HibernateException: Hibernate Dialect must be
> explicitly set
> [java] Caused by:
> [java] org.hibernate.HibernateException: Hibernate Dialect must be
> explicitly set
> [java] at
> org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:57)
> [java] at
> org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)
> [java] at
> org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426)
> [java] at
> org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128)
> [java] at
> org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073)
> [java] at
> org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)
> [java] at
> org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:807)
> [java] at
> org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:740)
> [java] at
> org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:131)
> [java] at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1062)
> [java] at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1029)
> [java] at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:420)
> [java] at
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)
> [java] at
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)
> [java] at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)
> [java] at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156)
> [java] at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:246)
> [java] at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:128)
> [java] at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:955)
> [java] at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:729)
> [java] at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:416)
> [java] at
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)
> [java] at
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)
> [java] at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)
> [java] at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156)
> [java] at
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:290)
> [java] at
> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:348)
> [java] at
> org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:89)
> [java] at
> org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:74)
> [java] at
> org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:65)
> [java] at org.orioai.utils.BeanUtils.initBeanFactory(BeanUtils.java:21)
> [java] at org.orioai.utils.BeanUtils.getBeanFactory(BeanUtils.java:39)
> [java] at
> org.orioai.harvesting.domain.service.InitDatabaseService.getFactory(InitDatabaseService.java:82)
> [java] at
> org.orioai.harvesting.domain.service.InitDatabaseService.initSpring(InitDatabaseService.java:92)
> [java] at
> org.orioai.harvesting.domain.service.InitDatabaseService.execute(InitDatabaseService.java:56)
> [java] at
> org.orioai.harvesting.domain.service.InitDatabaseService.main(InitDatabaseService.java:31)
>
> BUILD SUCCESSFUL
> Total time: 8 seconds
>
>

--
Ce message a été vérifié par MailScanner
pour des virus ou des polluriels et rien de
suspect n'a été trouvé.

3 décembre 2008 - 12:05pm

francoisjannin

Bonjour,

Elyes Soumrani a écrit :

> Bonjour,
>
> J'ai un soucis avec le ant init-harvester.
> J'obtiens le résultat mis à la fin du message.
> La ligne qui m'interpelle est :
> [java] oriharvester: 0
> org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78)
> - Unknown initial character set index '192' received from server. Initial
> client character set can be forced via the 'characterEncoding' property.
>
> Après une recherche sur le net, j'ai suivi les solutions proposées pour ce
> type d'erreur à savoir mettre les lignes suivantes dans /etc/my.cnf :
> character_set_server=utf8
> collation_server=utf8_unicode_ci
>
>

Diagnostic :

Cette manip ne va pas, je pense, modifier l'encodage des bases déjà
crées, mais juste définir un encodage par défaut pour la création des
bases et tables, donc c'est normal que vous n'ayez aucun changement.

Pour vérifier cela, et diagnostiquer le pb d'encodage lié à la connexion
MySQL, vous devez voir quel est l'encodage réel de votre base harvester,
à l'aide de commande SQL :

USE ori-harvester;

SHOW VARIABLES LIKE "character_set_database";
Cela affiche l'encodage de la base (utf8, latin1 ...)
(Vu l'excepetion dans votre cas, ça ne m'étonnerais pas que votre base
soit en latin1)

SHOW VARIABLES LIKE "collation_database";

Solution proposée :

Vous pouvez tenter d'ajouter un paramètre characterEncoding à l'URL de
connection à la base, en utilisant la valeur renvoyée par la commande
SQL, ou en essyant les valeurs utf-8, puis iso-8859-1 si ça ne marche pas

1. Si vous utilisez le quic-install :
fichier : commons-parameters.properties

# SQL server used for ori-oai-harvester persistence
HARVESTER_SQL_CONNECTION_URL=jdbc:mysql://localhost/ori-harvester?characterEncoding
=utf8
ou
HARVESTER_SQL_CONNECTION_URL=jdbc:mysql://localhost/ori-harvester?characterEncoding
=latin1
2. Si non :
fichier : conf/properties/ori.properties
hibernate.connection.url=jdbc:mysql://localhost/ori-harvester?characterEncoding
=utf8
ou
hibernate.connection.url=jdbc:mysql://localhost/ori-harvester?characterEncoding
=latin1

Cordialement,

François

> rien n'y fait.....
> Quelqu'un a-t-il une idée ?
>
> Cordialement
> Elyes Soumrani
>
>
> Buildfile: build.xml
>
> prepareBuild:
>
> compile:
> [javac] Compiling 8 source files to
> /usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes
> [javac]
> /usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:46:
> warning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and
> may be removed in a future release
> [javac] import com.sun.org.apache.xpath.internal.XPathAPI;
> [javac] ^
> [javac]
> /usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:289:
> warning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and
> may be removed in a future release
> [javac] return XPathAPI.eval(getDocument(), xpath,
> namespaceElement).str();
> [javac] ^
> [javac]
> /usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:308:
> warning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and
> may be removed in a future release
> [javac] return XPathAPI.selectNodeList(getDocument(), xpath,
> namespaceElement);
> [javac] ^
> [javac] Note: Some input files use unchecked or unsafe operations.
> [javac] Note: Recompile with -Xlint:unchecked for details.
> [javac] 3 warnings
> [echo] on change les paramètres dans build/WEB-INF/classes/properties ...
> [copy] Copying 1 file to
> /usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes/properties
> [echo] création du fichier de configuration ori.properties ...
> [copy] Copying 1 file to
> /usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes/properties
> [echo] Will log in /usr/local/ori/tomcat-harvester/logs, using prod mode.
> [copy] Copying 1 file to
> /usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes
>
> init:
> [if]
> [if] Warning. You're going to initialize/erase SQL
> [if] DataBase of ORI-OAI-Harvester
> [y,N]
> y
> [java] init
> [java] oriharvester: 0
> org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78)
> - Unknown initial character set index '192' received from server. Initial
> client character set can be forced via the 'characterEncoding' property.
> [java] oriharvester: 10
> org.orioai.harvesting.domain.service.InitDatabaseService.main(InitDatabaseService.java:34)
> - can't init dabatabase
> [java] org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name 'hibernateTemplate' defined in class path resource
> [properties/spring/common/dao/dao.xml]: Cannot resolve reference to bean
> 'sessionFactory' while setting bean property 'sessionFactory'; nested exception
> is org.springframework.beans.factory.BeanCreationException: Error creating bean
> with name 'sessionFactory' defined in class path resource
> [properties/spring/common/dao/dao.xml]: Invocation of init method failed;
> nested exception is org.hibernate.HibernateException: Hibernate Dialect must be
> explicitly set
> [java] Caused by:
> [java] org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name 'sessionFactory' defined in class path resource
> [properties/spring/common/dao/dao.xml]: Invocation of init method failed;
> nested exception is org.hibernate.HibernateException: Hibernate Dialect must be
> explicitly set
> [java] Caused by:
> [java] org.hibernate.HibernateException: Hibernate Dialect must be
> explicitly set
> [java] at
> org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:57)
> [java] at
> org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)
> [java] at
> org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426)
> [java] at
> org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128)
> [java] at
> org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073)
> [java] at
> org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)
> [java] at
> org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:807)
> [java] at
> org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:740)
> [java] at
> org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:131)
> [java] at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1062)
> [java] at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1029)
> [java] at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:420)
> [java] at
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)
> [java] at
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)
> [java] at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)
> [java] at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156)
> [java] at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:246)
> [java] at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:128)
> [java] at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:955)
> [java] at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:729)
> [java] at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:416)
> [java] at
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)
> [java] at
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)
> [java] at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)
> [java] at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156)
> [java] at
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:290)
> [java] at
> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:348)
> [java] at
> org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:89)
> [java] at
> org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:74)
> [java] at
> org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:65)
> [java] at org.orioai.utils.BeanUtils.initBeanFactory(BeanUtils.java:21)
> [java] at org.orioai.utils.BeanUtils.getBeanFactory(BeanUtils.java:39)
> [java] at
> org.orioai.harvesting.domain.service.InitDatabaseService.getFactory(InitDatabaseService.java:82)
> [java] at
> org.orioai.harvesting.domain.service.InitDatabaseService.initSpring(InitDatabaseService.java:92)
> [java] at
> org.orioai.harvesting.domain.service.InitDatabaseService.execute(InitDatabaseService.java:56)
> [java] at
> org.orioai.harvesting.domain.service.InitDatabaseService.main(InitDatabaseService.java:31)
>
> BUILD SUCCESSFUL
> Total time: 8 seconds
>
>

--
Ce message a été vérifié par MailScanner
pour des virus ou des polluriels et rien de
suspect n'a été trouvé.

8 décembre 2008 - 2:40pm

(Répondre à #3) #4

elyessoumrani

Bonjour,

Désolé pour le retour tardif, j'ai mis du temps à essayer vos solutions....

@ Vincent : j'avais effectivement négligé l'importance du ant init-build-all.....
Dans un 1er temps ça n'avait pas réglé mon problème car à force de chercher j'ai touché un peu à tout....
Puis quand j'ai remis mes fichiers de config d'aplomb et créé ma nouvelle base, je me suis rendu compte de son importance !

@ François : mes bases étaient bien en utf8 mais rien à faire ! J'ai l'impression que le nom choisi pour la base (ori-harvester) posait problème....
Je l'ai donc supprimé, puis j'en ai créé une nouvelle :
create database `harvest` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Tout est rentré dans l'ordre !
Merci encore pour vos explications très utiles !
Cordialement
Elyes

François Jannin a écrit :

Bonjour,

Elyes Soumrani a écrit :

Bonjour,

J'ai un soucis avec le ant init-harvester.
J'obtiens le résultat mis à la fin du message.
La ligne qui m'interpelle est :
[java] oriharvester: 0
org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78)
- Unknown initial character set index '192' received from server. Initial
client character set can be forced via the 'characterEncoding' property.

Après une recherche sur le net, j'ai suivi les solutions proposées pour ce
type d'erreur à savoir mettre les lignes suivantes dans /etc/my.cnf :
character_set_server=utf8
collation_server=utf8_unicode_ci

Diagnostic :

Cette manip ne va pas, je pense, modifier l'encodage des bases déjà crées, mais juste définir un encodage par défaut pour la création des bases et tables, donc c'est normal que vous n'ayez aucun changement.

Pour vérifier cela, et diagnostiquer le pb d'encodage lié à la connexion MySQL, vous devez voir quel est l'encodage réel de votre base harvester, à l'aide de commande SQL :

USE ori-harvester;

SHOW VARIABLES LIKE "character_set_database";
Cela affiche l'encodage de la base (utf8, latin1 ...)
(Vu l'excepetion dans votre cas, ça ne m'étonnerais pas que votre base soit en latin1)

SHOW VARIABLES LIKE "collation_database";

Solution proposée :

Vous pouvez tenter d'ajouter un paramètre characterEncoding à l'URL de connection à la base, en utilisant la valeur renvoyée par la commande SQL, ou en essyant les valeurs utf-8, puis iso-8859-1 si ça ne marche pas

1. Si vous utilisez le quic-install :
fichier : commons-parameters.properties

# SQL server used for ori-oai-harvester persistence
HARVESTER_SQL_CONNECTION_URL=jdbc:mysql://localhost/ori-harvester?characterEncoding =utf8
ou
HARVESTER_SQL_CONNECTION_URL=jdbc:mysql://localhost/ori-harvester?characterEncoding =latin1
2. Si non :
fichier : conf/properties/ori.properties
hibernate.connection.url=jdbc:mysql://localhost/ori-harvester?characterEncoding =utf8
ou
hibernate.connection.url=jdbc:mysql://localhost/ori-harvester?characterEncoding =latin1

Cordialement,

François

rien n'y fait.....
Quelqu'un a-t-il une idée ?

Cordialement
Elyes Soumrani

Buildfile: build.xml

prepareBuild:

compile:
 [javac] Compiling 8 source files to
/usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes
 [javac]
/usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:46:
warning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and
may be removed in a future release
 [javac] import com.sun.org.apache.xpath.internal.XPathAPI;
 [javac] ^
 [javac]
/usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:289:
warning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and
may be removed in a future release
 [javac] return XPathAPI.eval(getDocument(), xpath,
namespaceElement).str();
 [javac] ^
 [javac]
/usr/local/ori/src/ori-oai-harvester-svn/ExternalSource/oclcharverster2/org/oclc/oai/harvester2/verb/HarvesterVerb.java:308:
warning: com.sun.org.apache.xpath.internal.XPathAPI is Sun proprietary API and
may be removed in a future release
 [javac] return XPathAPI.selectNodeList(getDocument(), xpath,
namespaceElement);
 [javac] ^
 [javac] Note: Some input files use unchecked or unsafe operations.
 [javac] Note: Recompile with -Xlint:unchecked for details.
 [javac] 3 warnings
 [echo] on change les paramètres dans build/WEB-INF/classes/properties ...
 [copy] Copying 1 file to
/usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes/properties
 [echo] création du fichier de configuration ori.properties ...
 [copy] Copying 1 file to
/usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes/properties
 [echo] Will log in /usr/local/ori/tomcat-harvester/logs, using prod mode.
 [copy] Copying 1 file to
/usr/local/ori/src/ori-oai-harvester-svn/build/WEB-INF/classes

init:
 [if]
 [if] Warning. You're going to initialize/erase SQL
 [if] DataBase of ORI-OAI-Harvester
[y,N]
y
 [java] init
 [java] oriharvester: 0
org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78)
- Unknown initial character set index '192' received from server. Initial
client character set can be forced via the 'characterEncoding' property.
 [java] oriharvester: 10
org.orioai.harvesting.domain.service.InitDatabaseService.main(InitDatabaseService.java:34)
- can't init dabatabase
 [java] org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'hibernateTemplate' defined in class path resource
[properties/spring/common/dao/dao.xml]: Cannot resolve reference to bean
'sessionFactory' while setting bean property 'sessionFactory'; nested exception
is org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'sessionFactory' defined in class path resource
[properties/spring/common/dao/dao.xml]: Invocation of init method failed;
nested exception is org.hibernate.HibernateException: Hibernate Dialect must be
explicitly set
 [java] Caused by:
 [java] org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'sessionFactory' defined in class path resource
[properties/spring/common/dao/dao.xml]: Invocation of init method failed;
nested exception is org.hibernate.HibernateException: Hibernate Dialect must be
explicitly set
 [java] Caused by:
 [java] org.hibernate.HibernateException: Hibernate Dialect must be
explicitly set
 [java] at
org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:57)
 [java] at
org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)
 [java] at
org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426)
 [java] at
org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128)
 [java] at
org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073)
 [java] at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)
 [java] at
org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:807)
 [java] at
org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:740)
 [java] at
org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:131)
 [java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1062)
 [java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1029)
 [java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:420)
 [java] at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)
 [java] at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)
 [java] at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)
 [java] at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156)
 [java] at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:246)
 [java] at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:128)
 [java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:955)
 [java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:729)
 [java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:416)
 [java] at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)
 [java] at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)
 [java] at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)
 [java] at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156)
 [java] at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:290)
 [java] at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:348)
 [java] at
org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:89)
 [java] at
org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:74)
 [java] at
org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:65)
 [java] at org.orioai.utils.BeanUtils.initBeanFactory(BeanUtils.java:21)
 [java] at org.orioai.utils.BeanUtils.getBeanFactory(BeanUtils.java:39)
 [java] at
org.orioai.harvesting.domain.service.InitDatabaseService.getFactory(InitDatabaseService.java:82)
 [java] at
org.orioai.harvesting.domain.service.InitDatabaseService.initSpring(InitDatabaseService.java:92)
 [java] at
org.orioai.harvesting.domain.service.InitDatabaseService.execute(InitDatabaseService.java:56)
 [java] at
org.orioai.harvesting.domain.service.InitDatabaseService.main(InitDatabaseService.java:31)

BUILD SUCCESSFUL
Total time: 8 seconds

--
Ce message a été vérifié par
pour des virus ou des polluriels et rien de
suspect n'a été trouvé.

Sujet clos

Valoriser le patrimoine numérique scientifique, pédagogique et documentaire des universités et le partager par un réseau de portails communicants en OAI

Traduction auto Google

Aide

Options d'affichage des commentaires