Hello everyone !
I am new user of GN, from France. I want to use version 3, I have installed
them. Wow ! Great tool !
But I can not install with MySQL, and I do not really find precisely doc
about this issue.
I tried to change the jdbc.properties file (in config-db) and restart GN
via Tomcat, but without success.
Have you ever installed GN with MySQL ?
Thank you!
Hi Georges
You need to change also WEB-INF/config-node/srv.xml, to comment the H2
include and uncomment the mysql one.
Regards,
Jose García
On Thu, May 7, 2015 at 3:03 PM, Georges H <georges.hinot@anonymised.com> wrote:
Hello everyone !
I am new user of GN, from France. I want to use version 3, I have installed
them. Wow ! Great tool !But I can not install with MySQL, and I do not really find precisely doc
about this issue.I tried to change the jdbc.properties file (in config-db) and restart GN
via Tomcat, but without success.Have you ever installed GN with MySQL ?
Thank you!
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork
--
*GeoCat Bridge for ArcGIS allows instant publishing of data and metadata on
GeoServer and GeoNetwork. Visit http://geocat.net/> for
details. _________________________Jose GarcíaGeoCat bvVeenderweg 136721 WD
BennekomThe Netherlandshttp://GeoCat.net/>*
OK Thanks !
I have changed them, but I have had a new error about Bootstrap after first
restart of Tomcat.
I have restart GN a second time, and now I have an error of PermGen.
2015-05-07 15:07 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
Hi Georges
You need to change also WEB-INF/config-node/srv.xml, to comment the H2
include and uncomment the mysql one.Regards,
Jose GarcíaOn Thu, May 7, 2015 at 3:03 PM, Georges H <georges.hinot@anonymised.com> wrote:
Hello everyone !
I am new user of GN, from France. I want to use version 3, I have
installed
them. Wow ! Great tool !But I can not install with MySQL, and I do not really find precisely doc
about this issue.I tried to change the jdbc.properties file (in config-db) and restart GN
via Tomcat, but without success.Have you ever installed GN with MySQL ?
Thank you!
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork--
*GeoCat Bridge for ArcGIS allows instant publishing of data and metadata
on GeoServer and GeoNetwork. Visit http://geocat.net
<http://geocat.net/> for details. _________________________Jose
GarcíaGeoCat bvVeenderweg 136721 WD BennekomThe
Netherlandshttp://GeoCat.net/>*
--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>
Hi Georges
Check the JAVA_OPTS memory settings, if you have enough memory, I guess
something like this should work fine: -Xmx1024m -XX:MaxPermSize=256m
Regards,
Jose García
On Thu, May 7, 2015 at 5:02 PM, Georges H <georges.hinot@anonymised.com> wrote:
OK Thanks !
I have changed them, but I have had a new error about Bootstrap after
first restart of Tomcat.I have restart GN a second time, and now I have an error of PermGen.
2015-05-07 15:07 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
Hi Georges
You need to change also WEB-INF/config-node/srv.xml, to comment the H2
include and uncomment the mysql one.Regards,
Jose GarcíaOn Thu, May 7, 2015 at 3:03 PM, Georges H <georges.hinot@anonymised.com>
wrote:Hello everyone !
I am new user of GN, from France. I want to use version 3, I have
installed
them. Wow ! Great tool !But I can not install with MySQL, and I do not really find precisely doc
about this issue.I tried to change the jdbc.properties file (in config-db) and restart GN
via Tomcat, but without success.Have you ever installed GN with MySQL ?
Thank you!
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork--
*GeoCat Bridge for ArcGIS allows instant publishing of data and metadata
on GeoServer and GeoNetwork. Visit http://geocat.net
<http://geocat.net/> for details. _________________________Jose
GarcíaGeoCat bvVeenderweg 136721 WD BennekomThe
Netherlandshttp://GeoCat.net/>*--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>
--
*GeoCat Bridge for ArcGIS allows instant publishing of data and metadata on
GeoServer and GeoNetwork. Visit http://geocat.net/> for
details. _________________________Jose GarcíaGeoCat bvVeenderweg 136721 WD
BennekomThe Netherlandshttp://GeoCat.net/>*
OK but where do I run theses lines ? At the root of the server ?
Also, how can I check the JAVA_OPTS memory settings ? Tomcat has already
theses settings :
JVM
Free memory: 1436.90 MB Total memory: 1939.00 MB Max memory: 1939.00 MB
Please note thate I have this error also : "Table
'hinot_geonetwork_haisoft.settings' doesn't exist"
While, my DB has been created, and a table called "Settings" exists (with a
big "S"), but it is empty.
2015-05-07 17:05 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
Hi Georges
Check the JAVA_OPTS memory settings, if you have enough memory, I guess
something like this should work fine: -Xmx1024m -XX:MaxPermSize=256mRegards,
Jose GarcíaOn Thu, May 7, 2015 at 5:02 PM, Georges H <georges.hinot@anonymised.com> wrote:
OK Thanks !
I have changed them, but I have had a new error about Bootstrap after
first restart of Tomcat.I have restart GN a second time, and now I have an error of PermGen.
2015-05-07 15:07 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
Hi Georges
You need to change also WEB-INF/config-node/srv.xml, to comment the H2
include and uncomment the mysql one.Regards,
Jose GarcíaOn Thu, May 7, 2015 at 3:03 PM, Georges H <georges.hinot@anonymised.com>
wrote:Hello everyone !
I am new user of GN, from France. I want to use version 3, I have
installed
them. Wow ! Great tool !But I can not install with MySQL, and I do not really find precisely doc
about this issue.I tried to change the jdbc.properties file (in config-db) and restart GN
via Tomcat, but without success.Have you ever installed GN with MySQL ?
Thank you!
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork--
*GeoCat Bridge for ArcGIS allows instant publishing of data and metadata
on GeoServer and GeoNetwork. Visit http://geocat.net
<http://geocat.net/> for details. _________________________Jose
GarcíaGeoCat bvVeenderweg 136721 WD BennekomThe
Netherlandshttp://GeoCat.net/>*--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>--
*GeoCat Bridge for ArcGIS allows instant publishing of data and metadata
on GeoServer and GeoNetwork. Visit http://geocat.net
<http://geocat.net/> for details. _________________________Jose
GarcíaGeoCat bvVeenderweg 136721 WD BennekomThe
Netherlandshttp://GeoCat.net/>*
--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>
Hi Georges
Usually that parameters are configured in tomcat startup scripts, check the
documentation of tomcat for your environment. But in any case, seem the
memory assigned is pretty high, so not really sure why the memory issue.
Related to MySQL, seem table names are case sensitive and if the case
differs in the queries causes this issue. Check about the
lower_case_table_names parameter in
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
Regards,
Jose García
On Thu, May 7, 2015 at 5:12 PM, Georges H <georges.hinot@anonymised.com> wrote:
OK but where do I run theses lines ? At the root of the server ?
Also, how can I check the JAVA_OPTS memory settings ? Tomcat has already
theses settings :
JVMFree memory: 1436.90 MB Total memory: 1939.00 MB Max memory: 1939.00 MB
Please note thate I have this error also : "Table
'hinot_geonetwork_haisoft.settings' doesn't exist"While, my DB has been created, and a table called "Settings" exists (with
a big "S"), but it is empty.2015-05-07 17:05 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
Hi Georges
Check the JAVA_OPTS memory settings, if you have enough memory, I guess
something like this should work fine: -Xmx1024m -XX:MaxPermSize=256mRegards,
Jose GarcíaOn Thu, May 7, 2015 at 5:02 PM, Georges H <georges.hinot@anonymised.com>
wrote:OK Thanks !
I have changed them, but I have had a new error about Bootstrap after
first restart of Tomcat.I have restart GN a second time, and now I have an error of PermGen.
2015-05-07 15:07 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
Hi Georges
You need to change also WEB-INF/config-node/srv.xml, to comment the H2
include and uncomment the mysql one.Regards,
Jose GarcíaOn Thu, May 7, 2015 at 3:03 PM, Georges H <georges.hinot@anonymised.com>
wrote:Hello everyone !
I am new user of GN, from France. I want to use version 3, I have
installed
them. Wow ! Great tool !But I can not install with MySQL, and I do not really find precisely
doc
about this issue.I tried to change the jdbc.properties file (in config-db) and restart
GN
via Tomcat, but without success.Have you ever installed GN with MySQL ?
Thank you!
------------------------------------------------------------------------------
One dashboard for servers and applications across
Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable
Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork--
*GeoCat Bridge for ArcGIS allows instant publishing of data and
metadata on GeoServer and GeoNetwork. Visit http://geocat.net
<http://geocat.net/> for details. _________________________Jose
GarcíaGeoCat bvVeenderweg 136721 WD BennekomThe
Netherlandshttp://GeoCat.net/>*--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>--
*GeoCat Bridge for ArcGIS allows instant publishing of data and metadata
on GeoServer and GeoNetwork. Visit http://geocat.net
<http://geocat.net/> for details. _________________________Jose
GarcíaGeoCat bvVeenderweg 136721 WD BennekomThe
Netherlandshttp://GeoCat.net/>*--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>
--
*GeoCat Bridge for ArcGIS allows instant publishing of data and metadata on
GeoServer and GeoNetwork. Visit http://geocat.net/> for
details. _________________________Jose GarcíaGeoCat bvVeenderweg 136721 WD
BennekomThe Netherlandshttp://GeoCat.net/>*
Ok thanks
So you think the error is rather due to MySQL tables names ?
Typically, do MySQL tables of a GeoNetwork use uppercase ?
If couyd help, I copy here the errors from Tomcat :
_________________________________________
*Exception*
java.lang.RuntimeException: java.lang.RuntimeException:
javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute
statement
*Message*
java.lang.RuntimeException: javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute
statement
*Handler*
org.fao.geonet.Geonetwork
*Stack*
java.lang.RuntimeException: java.lang.RuntimeException:
javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute
statement
at org.fao.geonet.Geonetwork.importDatabaseData(Geonetwork.java:531)
at org.fao.geonet.Geonetwork.start(Geonetwork.java:198)
at jeeves.server.JeevesEngine.initAppHandler(JeevesEngine.java:452)
at jeeves.server.JeevesEngine.init(JeevesEngine.java:173)
at jeeves.server.sources.http.JeevesServlet.init(JeevesServlet.java:82)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1206)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1026)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4421)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4734)
at org.apache.catalina.core.StandardContext.reload(StandardContext.java:3461)
at org.apache.catalina.manager.ManagerServlet.reload(ManagerServlet.java:943)
at org.apache.catalina.manager.HTMLManagerServlet.reload(HTMLManagerServlet.java:557)
at org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:121)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:193)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException:
javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute
statement
at org.fao.geonet.lib.DbLib.runSQL(DbLib.java:122)
at org.fao.geonet.lib.DbLib.access$000(DbLib.java:50)
at org.fao.geonet.lib.DbLib$1.doInTransaction(DbLib.java:70)
at jeeves.transaction.TransactionManager.runInTransaction(TransactionManager.java:63)
at org.fao.geonet.lib.DbLib.insertData(DbLib.java:65)
at org.fao.geonet.Geonetwork.importDatabaseData(Geonetwork.java:521)
... 31 more
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute
statement
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1771)
at org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:87)
at org.fao.geonet.lib.DbLib.runSQL(DbLib.java:116)
... 36 more
Caused by: org.hibernate.exception.SQLGrammarException: could not
execute statement
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
at org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:211)
at org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)
at org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:389)
at org.hibernate.jpa.internal.QueryImpl.internalExecuteUpdate(QueryImpl.java:371)
at org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:78)
... 37 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Table 'hinot_geonetwork_haisoft.settings' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2460)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2377)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2361)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
... 42 more
___________________________________________________________________
Thanks !
2015-05-07 17:42 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
Hi Georges
Usually that parameters are configured in tomcat startup scripts, check
the documentation of tomcat for your environment. But in any case, seem the
memory assigned is pretty high, so not really sure why the memory issue.Related to MySQL, seem table names are case sensitive and if the case
differs in the queries causes this issue. Check about the
lower_case_table_names parameter in
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.htmlRegards,
Jose GarcíaOn Thu, May 7, 2015 at 5:12 PM, Georges H <georges.hinot@anonymised.com> wrote:
OK but where do I run theses lines ? At the root of the server ?
Also, how can I check the JAVA_OPTS memory settings ? Tomcat has already
theses settings :
JVMFree memory: 1436.90 MB Total memory: 1939.00 MB Max memory: 1939.00 MB
Please note thate I have this error also : "Table
'hinot_geonetwork_haisoft.settings' doesn't exist"While, my DB has been created, and a table called "Settings" exists (with
a big "S"), but it is empty.2015-05-07 17:05 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
Hi Georges
Check the JAVA_OPTS memory settings, if you have enough memory, I guess
something like this should work fine: -Xmx1024m -XX:MaxPermSize=256mRegards,
Jose GarcíaOn Thu, May 7, 2015 at 5:02 PM, Georges H <georges.hinot@anonymised.com>
wrote:OK Thanks !
I have changed them, but I have had a new error about Bootstrap after
first restart of Tomcat.I have restart GN a second time, and now I have an error of PermGen.
2015-05-07 15:07 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
Hi Georges
You need to change also WEB-INF/config-node/srv.xml, to comment the H2
include and uncomment the mysql one.Regards,
Jose GarcíaOn Thu, May 7, 2015 at 3:03 PM, Georges H <georges.hinot@anonymised.com>
wrote:Hello everyone !
I am new user of GN, from France. I want to use version 3, I have
installed
them. Wow ! Great tool !But I can not install with MySQL, and I do not really find precisely
doc
about this issue.I tried to change the jdbc.properties file (in config-db) and restart
GN
via Tomcat, but without success.Have you ever installed GN with MySQL ?
Thank you!
------------------------------------------------------------------------------
One dashboard for servers and applications across
Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable
Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork--
*GeoCat Bridge for ArcGIS allows instant publishing of data and
metadata on GeoServer and GeoNetwork. Visit http://geocat.net
<http://geocat.net/> for details. _________________________Jose
GarcíaGeoCat bvVeenderweg 136721 WD BennekomThe
Netherlandshttp://GeoCat.net/>*--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>--
*GeoCat Bridge for ArcGIS allows instant publishing of data and metadata
on GeoServer and GeoNetwork. Visit http://geocat.net
<http://geocat.net/> for details. _________________________Jose
GarcíaGeoCat bvVeenderweg 136721 WD BennekomThe
Netherlandshttp://GeoCat.net/>*--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>--
*GeoCat Bridge for ArcGIS allows instant publishing of data and metadata
on GeoServer and GeoNetwork. Visit http://geocat.net
<http://geocat.net/> for details. _________________________Jose
GarcíaGeoCat bvVeenderweg 136721 WD BennekomThe
Netherlandshttp://GeoCat.net/>*
--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>
Hi
I have tried to install GN on another engine (Debian, previously on Centos)
and another MySQL server (with MySQL last version), but I have already the
same error, here :
http://geo-ids.fr:9322/geonetwork/srv/fre/catalog.search
Any idea ?
Thanks !
2015-05-07 17:54 GMT+02:00 Georges H <georges.hinot@anonymised.com>:
Ok thanks
So you think the error is rather due to MySQL tables names ?
Typically, do MySQL tables of a GeoNetwork use uppercase ?If couyd help, I copy here the errors from Tomcat :
_________________________________________
*Exception*java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
*Message*
java.lang.RuntimeException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
*Handler*
org.fao.geonet.Geonetwork
*Stack*
java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.fao.geonet.Geonetwork.importDatabaseData(Geonetwork.java:531)
at org.fao.geonet.Geonetwork.start(Geonetwork.java:198)
at jeeves.server.JeevesEngine.initAppHandler(JeevesEngine.java:452)
at jeeves.server.JeevesEngine.init(JeevesEngine.java:173)
at jeeves.server.sources.http.JeevesServlet.init(JeevesServlet.java:82)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1206)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1026)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4421)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4734)
at org.apache.catalina.core.StandardContext.reload(StandardContext.java:3461)
at org.apache.catalina.manager.ManagerServlet.reload(ManagerServlet.java:943)
at org.apache.catalina.manager.HTMLManagerServlet.reload(HTMLManagerServlet.java:557)
at org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:121)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:193)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.fao.geonet.lib.DbLib.runSQL(DbLib.java:122)
at org.fao.geonet.lib.DbLib.access$000(DbLib.java:50)
at org.fao.geonet.lib.DbLib$1.doInTransaction(DbLib.java:70)
at jeeves.transaction.TransactionManager.runInTransaction(TransactionManager.java:63)
at org.fao.geonet.lib.DbLib.insertData(DbLib.java:65)
at org.fao.geonet.Geonetwork.importDatabaseData(Geonetwork.java:521)
... 31 more
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1771)
at org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:87)
at org.fao.geonet.lib.DbLib.runSQL(DbLib.java:116)
... 36 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
at org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:211)
at org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)
at org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:389)
at org.hibernate.jpa.internal.QueryImpl.internalExecuteUpdate(QueryImpl.java:371)
at org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:78)
... 37 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hinot_geonetwork_haisoft.settings' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2460)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2377)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2361)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
... 42 more___________________________________________________________________
Thanks !
2015-05-07 17:42 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
Hi Georges
Usually that parameters are configured in tomcat startup scripts, check
the documentation of tomcat for your environment. But in any case, seem the
memory assigned is pretty high, so not really sure why the memory issue.Related to MySQL, seem table names are case sensitive and if the case
differs in the queries causes this issue. Check about the
lower_case_table_names parameter in
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.htmlRegards,
Jose GarcíaOn Thu, May 7, 2015 at 5:12 PM, Georges H <georges.hinot@anonymised.com>
wrote:OK but where do I run theses lines ? At the root of the server ?
Also, how can I check the JAVA_OPTS memory settings ? Tomcat has already
theses settings :
JVMFree memory: 1436.90 MB Total memory: 1939.00 MB Max memory: 1939.00 MB
Please note thate I have this error also : "Table
'hinot_geonetwork_haisoft.settings' doesn't exist"While, my DB has been created, and a table called "Settings" exists
(with a big "S"), but it is empty.2015-05-07 17:05 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
Hi Georges
Check the JAVA_OPTS memory settings, if you have enough memory, I guess
something like this should work fine: -Xmx1024m -XX:MaxPermSize=256mRegards,
Jose GarcíaOn Thu, May 7, 2015 at 5:02 PM, Georges H <georges.hinot@anonymised.com>
wrote:OK Thanks !
I have changed them, but I have had a new error about Bootstrap after
first restart of Tomcat.I have restart GN a second time, and now I have an error of PermGen.
2015-05-07 15:07 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
Hi Georges
You need to change also WEB-INF/config-node/srv.xml, to comment the
H2 include and uncomment the mysql one.Regards,
Jose GarcíaOn Thu, May 7, 2015 at 3:03 PM, Georges H <georges.hinot@anonymised.com>
wrote:Hello everyone !
I am new user of GN, from France. I want to use version 3, I have
installed
them. Wow ! Great tool !But I can not install with MySQL, and I do not really find precisely
doc
about this issue.I tried to change the jdbc.properties file (in config-db) and
restart GN
via Tomcat, but without success.Have you ever installed GN with MySQL ?
Thank you!
------------------------------------------------------------------------------
One dashboard for servers and applications across
Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable
Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork--
*GeoCat Bridge for ArcGIS allows instant publishing of data and
metadata on GeoServer and GeoNetwork. Visit http://geocat.net
<http://geocat.net/> for details. _________________________Jose
GarcíaGeoCat bvVeenderweg 136721 WD BennekomThe
Netherlandshttp://GeoCat.net/>*--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>--
*GeoCat Bridge for ArcGIS allows instant publishing of data and
metadata on GeoServer and GeoNetwork. Visit http://geocat.net
<http://geocat.net/> for details. _________________________Jose
GarcíaGeoCat bvVeenderweg 136721 WD BennekomThe
Netherlandshttp://GeoCat.net/>*--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>--
*GeoCat Bridge for ArcGIS allows instant publishing of data and metadata
on GeoServer and GeoNetwork. Visit http://geocat.net
<http://geocat.net/> for details. _________________________Jose
GarcíaGeoCat bvVeenderweg 136721 WD BennekomThe
Netherlandshttp://GeoCat.net/>*--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>
--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>
Hello.
I do not recommend to start a catalog with MySQL.
Based on the reading of the issues on github and my personnal experience (migration 2.9 -> 2.11), developpers might to not support so long MySQL.
See : https://github.com/geosource-catalogue/core-geonetwork/issues/205
I strongly recommend to start with a postgresql database.
best regards,
Maël REBOUX
Service SIG mutualisé Ville de Rennes / Rennes Métropole
Chargé de mission "diffusion"
02 99 86 63 71
Twitter : mael_reboux_ig
-----Message d'origine-----
De : Jose Garcia [mailto:jose.garcia@…444…]
Envoyé : jeudi 7 mai 2015 15:07
À : Georges H
Cc : geonetwork-users@lists.sourceforge.net
Objet : Re: [GeoNetwork-users] To install GeoNetwork with MySQL
Hi Georges
You need to change also WEB-INF/config-node/srv.xml, to comment the H2 include and uncomment the mysql one.
Regards,
Jose García
On Thu, May 7, 2015 at 3:03 PM, Georges H <georges.hinot@...54...> wrote:
Hello everyone !
I am new user of GN, from France. I want to use version 3, I have
installed them. Wow ! Great tool !But I can not install with MySQL, and I do not really find precisely
doc about this issue.I tried to change the jdbc.properties file (in config-db) and restart
GN via Tomcat, but without success.Have you ever installed GN with MySQL ?
Thank you!
----------------------------------------------------------------------
-------- One dashboard for servers and applications across
Physical-Virtual-Cloud Widest out-of-the-box monitoring support with
50+ applications Performance metrics, stats and reports that give you
Actionable Insights Deep dive visibility with transaction tracing
using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork
--
*GeoCat Bridge for ArcGIS allows instant publishing of data and metadata on GeoServer and GeoNetwork. Visit http://geocat.net/> for details. _________________________Jose GarcíaGeoCat bvVeenderweg 136721 WD BennekomThe Netherlandshttp://geocat.net/>*