[Geoserver-users] Problem with GeoServer 2.8 SpatiaLite extension

I am having troubles making GeoServer 2.8 SpatiaLite extension to work. I’ve instaled TomCat 7 with JRE (32 bits), but I can only see SpatiaLite (JNDI) and not SpatiaLite WareHouse.

If I use Geoserver 2.5 all works fine, but with GeoServer 2.6, 2.7 and 2.8 it doesn´t work. I’ve observed that GeoServer SpatiaLite extension in version 2.5 includes two libraries:

  • sqlite-jdbc-spatialite-3.7.2-2.4.jar

  • gt-jdbc-spatialite-9.0.jar

But from version 2.6 onwards there’s only one library:

  • gt-jdbc-spatialite-12.0.jar

Could it be a missing library?

Thanks in advance

···

http://www.tragsa.es/SiteCollectionImages/Relaciones%20Institucionales%20(Prensa)/FIRMA%20OUTLOOK/Tragsatec.png

http://www.tragsa.es/SiteCollectionImages/Relaciones%20Institucionales%20(Prensa)/FIRMA%20OUTLOOK/cenefa.png

Pedro Briones Garcia
JGAP Sist Inform Geográfica
S.Información Geográfica / G.Sist.Inf. Geografica

Grupo Tragsa - SEPI

http://www.tragsa.es/SiteCollectionImages/Relaciones%20Institucionales%20(Prensa)/FIRMA%20OUTLOOK/Tragsatec_SEPI.png

Calle Julián Camarillo 6 B - 28037 Madrid
Tel.: 913226489 - 88216 - Fax: 913226005
pbg@anonymised.com
www.tragsa.es

En beneficio del medio ambiente, imprime este e-mail sólo si realmente es necesario
For the benefit of the environment, print this e-mail only if you really need to

On Mon, Feb 29, 2016 at 7:02 PM, Pedro Briones Garcia <pbg@anonymised.com> wrote:

I am having troubles making GeoServer 2.8 SpatiaLite extension to work.
I’ve instaled TomCat 7 with JRE (*32 bits*), but I can only see
SpatiaLite (JNDI) and not SpatiaLite WareHouse.

If I use Geoserver 2.5 all works fine, but with GeoServer 2.6, 2.7 and
2.8 it doesn´t work. I’ve observed that GeoServer SpatiaLite extension in
version 2.5 includes two libraries:

- sqlite-jdbc-spatialite-3.7.2-2.4.jar

- gt-jdbc-spatialite-9.0.jar

But from version 2.6 onwards there’s only one library:

- gt-jdbc-spatialite-12.0.jar

Could it be a missing library?

It certainly looks that way. As far as I can see the module still needs the
same library as
the old one, so you can pick the jar in the old zip file.

It's weird, the module packaging instructions seems to be including that
library as
a requirement, and yet it's not found... maybe Justin (cc'ed) knows what's
going on

Cheers
Andrea

--

GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.

The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

-------------------------------------------------------

On 04/03/16 07:27, Andrea Aime wrote:

On Mon, Feb 29, 2016 at 7:02 PM, Pedro Briones Garcia <pbg@anonymised.com> wrote:

Could it be a missing library?

It certainly looks that way.

On 12 Feb 2014, Justin switched GeoTools gt-jdbc-spatialite to use a renamed artifact:
https://github.com/geotools/geotools/commit/69f638cb72c6754b2cccc1998024da0b2b5cc9b5

This change was not applied to the configuration of the GeoServer spatialite plugin. As the old jar is no longer a dependency, it is not included in the plugin.

As I have been doing a bit of plugin weeding, I will fix this now on master, 2.8.x, and 2.7.x.

Kind regards,

--
Ben Caradoc-Davies <ben@anonymised.com>
Director
Transient Software Limited <http://transient.nz/&gt;
New Zealand

On 04/03/16 09:36, Ben Caradoc-Davies wrote:

As I have been doing a bit of plugin weeding, I will fix this now on
master, 2.8.x, and 2.7.x.

Even worse, we are currently shipping gt-jdbc-spatialite-12.0.jar in the spatialite plugin for 2.7.x, 2.8.x, and master (should be 13-SNAPSHOT, 14-SNAPSHOT, and 15-SNAPSHOT respectively).

--
Ben Caradoc-Davies <ben@anonymised.com>
Director
Transient Software Limited <http://transient.nz/&gt;
New Zealand

Pedro,

this issue should now be fixed on master, 2.8.x, and 2.7.x.

The next 2.8.x nightly build should be available at about 16:22 on 4 March 2016 UTC (in about 16.5 hours):
http://ares.opengeo.org/geoserver/2.8.x/community-latest/

Please test the new spatialite plugin and report back.

Kind regards,
Ben.

On 04/03/16 09:36, Ben Caradoc-Davies wrote:

As I have been doing a bit of plugin weeding, I will fix this now on
master, 2.8.x, and 2.7.x.

--
Ben Caradoc-Davies <ben@anonymised.com>
Director
Transient Software Limited <http://transient.nz/&gt;
New Zealand

Hi, Ben.

I'll try ASAP and I'll report.

Regards

Pedro Briones Garcia
JGAP Sist Inform Geográfica
S.Información Geográfica / G.Sist.Inf. Geografica
Grupo Tragsa - SEPI
    
    Calle Julián Camarillo 6 B - 28037 Madrid
Tel.: 913226489 - 88216 - Fax: 913226005
pbg@...3477...
www.tragsa.es

En beneficio del medio ambiente, imprime este e-mail sólo si realmente es necesario
For the benefit of the environment, print this e-mail only if you really need to
-----Mensaje original-----
De: Ben Caradoc-Davies [mailto:ben@…6881…]
Enviado el: viernes, 04 de marzo de 2016 0:53
Para: Andrea Aime
CC: Pedro Briones Garcia; Justin Deoliveira; geoserver-users@lists.sourceforge.net
Asunto: Re: [Geoserver-users] Problem with GeoServer 2.8 SpatiaLite extension

Pedro,

this issue should now be fixed on master, 2.8.x, and 2.7.x.

The next 2.8.x nightly build should be available at about 16:22 on 4 March 2016 UTC (in about 16.5 hours):
http://ares.opengeo.org/geoserver/2.8.x/community-latest/

Please test the new spatialite plugin and report back.

Kind regards,
Ben.

On 04/03/16 09:36, Ben Caradoc-Davies wrote:

As I have been doing a bit of plugin weeding, I will fix this now on
master, 2.8.x, and 2.7.x.

--
Ben Caradoc-Davies <ben@...6881...>
Director
Transient Software Limited <http://transient.nz/&gt; New Zealand

**********************************************************************************************
El consumo de papel es perjudicial para el medio ambiente. Por favor, téngalo en cuenta antes de imprimir este mensaje.

AVISO LEGAL: Este mensaje y sus anexos pueden contener información confidencial o legalmente protegida. Está dirigido únicamente a la persona o entidad indicada como destinatarios del mensaje. Si este mensaje le hubiera llegado por error, por favor elimínelo sin revisarlo ni reenviarlo y notifíquelo inmediatamente al remitente.
**********************************************************************************************

Hi Ben, I have the same problem and I've tested Spatialite extension on
GeoServer 2.8.3(Released on March 23, 2016). Still, I can only see
Spatialite(JNDI) there. Thanks in advance.

Ben Caradoc-Davies-2 wrote

Pedro,

this issue should now be fixed on master, 2.8.x, and 2.7.x.

The next 2.8.x nightly build should be available at about 16:22 on 4
March 2016 UTC (in about 16.5 hours):
http://ares.opengeo.org/geoserver/2.8.x/community-latest/

Please test the new spatialite plugin and report back.

Kind regards,
Ben.

On 04/03/16 09:36, Ben Caradoc-Davies wrote:

As I have been doing a bit of plugin weeding, I will fix this now on
master, 2.8.x, and 2.7.x.

--
Ben Caradoc-Davies &lt;

ben@

&gt;
Director
Transient Software Limited &lt;http://transient.nz/&gt;
New Zealand

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Geoserver-users mailing list

Geoserver-users@anonymised.com

https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Problem-with-GeoServer-2-8-SpatiaLite-extension-tp5253443p5258109.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Hi,
after about a year, I also have the same problem with Geoserver 2.10
installed on Ubuntu 16 (with Tomcat 8): I can only see SpatiaLite (JNDI) and
not SpatiaLite WareHouse.

I downloaded the spatialite plugin from
http://ares.boundlessgeo.com/geoserver/2.10.x/community-latest/
and then I extracted the contents of the archive(2 .jar files) into the
WEB-INF/lib directory of the GeoServer installation.

I also tried to install the native library for Java (GEOS and PROJ) in the
"user/local/lib" folder. But it's the same: I always see only SpatiaLite
(JNDI) item.

Any ideas about the solution?

Best regards
Nino

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Problem-with-GeoServer-2-8-SpatiaLite-extension-tp5253443p5327112.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

I downloaded the spatialite plugin from
http://ares.boundlessgeo.com/geoserver/2.10.x/community-latest/
and then I extracted the contents of the archive(2 .jar files) into the
WEB-INF/lib directory of the GeoServer installation.

It has to match the installed version - so if you have 2.10.1 installed,
then you need the jars for the 2.10.1 version (not later, or any other 2.10
version).

I also tried to install the native library for Java (GEOS and PROJ) in the
"user/local/lib" folder. But it's the same: I always see only SpatiaLite
(JNDI) item.

Did you mean "/usr/local/lib"? Is that in the Tomcat user's library path?

Any ideas about the solution?

Anything relevant in the logs?

Brad

Hi Brad,

Brad Hards wrote

It has to match the installed version - so if you have 2.10.1 installed,
then you need the jars for the 2.10.1 version (not later, or any other
2.10
version).

I have installed Geoserver 2.10.3 version, but in
http://ares.boundlessgeo.com/geoserver/ there are plugins only for generic
2.8.x, 2.9.x, 2.10.x, ... etc versions.
I did'nt find anything specifically for the 2.10.3 versions !

Brad Hards wrote

I also tried to install the native library for Java (GEOS and PROJ) in
the
"user/local/lib" folder. But it's the same: I always see only SpatiaLite
(JNDI) item.

Did you mean "/usr/local/lib"? Is that in the Tomcat user's library path?

Yes sorry, I mean "/usr/local/lib" folder; this is the absolute path (it'snt
in the Tomcat user's library path).

cheers
Nino

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html

Geoserver-users@anonymised.com
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Problem-with-GeoServer-2-8-SpatiaLite-extension-tp5253443p5327157.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

On Sun, Jul 9, 2017 at 5:25 PM, nformica <ninofor60@anonymised.com> wrote:

I have installed Geoserver 2.10.3 version, but in
http://ares.boundlessgeo.com/geoserver/ there are plugins only for
generic
2.8.x, 2.9.x, 2.10.x, ... etc versions.
I did'nt find anything specifically for the 2.10.3 versions !

No worries, that is normal, only supported modules get tagged for a
specific release,
community (unsupported) modules are available as part of the nightly builds
for
the adventorous to try out :slight_smile:

Brad is giving you good questions, please share the logs, from the
description it seems that GeoServer is not finding the native library
it's looking for.

Cheers
Andrea

--

Regards,

Andrea Aime

==
GeoServer Professional Services from the experts! Visit http://goo.gl/it488V
for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

AVVERTENZE AI SENSI DEL D.Lgs. 196/2003

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.

The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

geowolf wrote

Brad is giving you good questions, please share the logs, from the
description it seems that GeoServer is not finding the native library
it's looking for.

This is my system configuration:
- Ubuntu 16.04
- Tomcat 8
- Java 8 openjdk
- Geoserver 2.10.3

I have downloaded native library from:
http://docs.geotools.org/latest/userguide/library/jdbc/spatialite.html#native-libraries
precisely the linux 64 bit version:
http://ares.boundlessgeo.com/geotools/spatialite-libs-linux-x86_64.zip

Then I have extracted lib (in zip file) in a folder named "spatialite-libs"
and I put it in /usr/local/lib/ folder.

I restart Tomcat 8 and run Geoserver; this is the log file:
https://drive.google.com/open?id=0B5Doub2YiDSednFrUGVoVm9Cc1E

... thanks!
Nino

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Problem-with-GeoServer-2-8-SpatiaLite-extension-tp5253443p5327285.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

I remember vaguely that you may need to define this variable too on Linux:
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib

On 07/10/2017 07:27 PM, nformica wrote:

geowolf wrote

Brad is giving you good questions, please share the logs, from the
description it seems that GeoServer is not finding the native library
it's looking for.

This is my system configuration:
- Ubuntu 16.04
- Tomcat 8
- Java 8 openjdk
- Geoserver 2.10.3

I have downloaded native library from:
http://docs.geotools.org/latest/userguide/library/jdbc/spatialite.html#native-libraries
precisely the linux 64 bit version:
http://ares.boundlessgeo.com/geotools/spatialite-libs-linux-x86_64.zip

Then I have extracted lib (in zip file) in a folder named "spatialite-libs"
and I put it in /usr/local/lib/ folder.

I restart Tomcat 8 and run Geoserver; this is the log file:
https://drive.google.com/open?id=0B5Doub2YiDSednFrUGVoVm9Cc1E

... thanks!
Nino

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Problem-with-GeoServer-2-8-SpatiaLite-extension-tp5253443p5327285.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:
- Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Regards,
Nuno Oliveira

GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information.

Nuno Miguel Carvalho Oliveira
@nmcoliveira
Software Engineer

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------
AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
  The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc.

Yes, I already did . but It does’nt change anything!
I guess that the indications:

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
java -Djava.library.path=/usr/local/lib
···

are incorrect or ambiguous !

Nino

Il 12 lug 2017 9:47 AM, “Nuno Oliveira” <nuno.oliveira@…1107…> ha scritto:

I remember vaguely that you may need to define this variable too on Linux:
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib

On 07/10/2017 07:27 PM, nformica wrote:

geowolf wrote

Brad is giving you good questions, please share the logs, from the
description it seems that GeoServer is not finding the native library
it’s looking for.

This is my system configuration:

  • Ubuntu 16.04
  • Tomcat 8
  • Java 8 openjdk
  • Geoserver 2.10.3

I have downloaded native library from:
http://docs.geotools.org/latest/userguide/library/jdbc/spatialite.html#native-libraries
precisely the linux 64 bit version:
http://ares.boundlessgeo.com/geotools/spatialite-libs-linux-x86_64.zip

Then I have extracted lib (in zip file) in a folder named “spatialite-libs”
and I put it in /usr/local/lib/ folder.

I restart Tomcat 8 and run Geoserver; this is the log file:
https://drive.google.com/open?id=0B5Doub2YiDSednFrUGVoVm9Cc1E

… thanks!
Nino


View this message in context: http://osgeo-org.1560.x6.nabble.com/Problem-with-GeoServer-2-8-SpatiaLite-extension-tp5253443p5327285.html
Sent from the GeoServer - User mailing list archive at Nabble.com.


Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

Geoserver-users@anonymised.comrge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Regards,
Nuno Oliveira

==
GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information.

Nuno Miguel Carvalho Oliveira
@nmcoliveira
Software Engineer

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)

Italy
phone: +39 0584 962313
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it


AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy’s New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc.


Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

Geoserver-users@anonymised.comrge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

I just give it a try with last GeoServer trunk and is working:

I have two possible differences from your setup, I’m using Oracle JDK 8
and I have spatialite Ubuntu packages installed (this should not make
any difference):

ii libspatialite-dev:amd64 4.3.0a-5 amd64 Geospatial extension for SQLite - development files
ii libspatialite7:amd64 4.3.0a-5 amd64 Geospatial extension for SQLite - libraries
ii python-pyspatialite 3.0.1-10 amd64 Python interface to Spatialite
ii spatialite-bin 4.3.0-2 amd64 Geospatial extension for SQLite - tools
ii spatialite-gui 2.0.0~devel2-2 amd64 user-friendly graphical user interface for SpatiaLite

If you are curious the code that checks if the JDBC driver and natives libraries are available:
https://github.com/nmco/geotools/blob/7d4dcbfba9b67ab6aae0b5b65f5366334249147b/modules/library/jdbc/src/main/java/org/geotools/jdbc/JDBCDataStoreFactory.java#L402-L410
https://github.com/nmco/geotools/blob/bd04ccd3f3b7f633f596f3ff93464a8d4a13853c/modules/plugin/jdbc/jdbc-spatialite/src/main/java/org/geotools/data/spatialite/SpatiaLiteDataStoreFactory.java#L74-L80

Hope this helps.

···

On 07/12/2017 02:40 PM, nino formica wrote:

Yes, I already did . but It does’nt change anything!
I guess that the indications:

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
java -Djava.library.path=/usr/local/lib

are incorrect or ambiguous !

Nino

Il 12 lug 2017 9:47 AM, “Nuno Oliveira” <nuno.oliveira@anonymised.com> ha scritto:

I remember vaguely that you may need to define this variable too on Linux:
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib

On 07/10/2017 07:27 PM, nformica wrote:

geowolf wrote

Brad is giving you good questions, please share the logs, from the
description it seems that GeoServer is not finding the native library
it’s looking for.

This is my system configuration:

  • Ubuntu 16.04
  • Tomcat 8
  • Java 8 openjdk
  • Geoserver 2.10.3

I have downloaded native library from:
http://docs.geotools.org/latest/userguide/library/jdbc/spatialite.html#native-libraries
precisely the linux 64 bit version:
http://ares.boundlessgeo.com/geotools/spatialite-libs-linux-x86_64.zip

Then I have extracted lib (in zip file) in a folder named “spatialite-libs”
and I put it in /usr/local/lib/ folder.

I restart Tomcat 8 and run Geoserver; this is the log file:
https://drive.google.com/open?id=0B5Doub2YiDSednFrUGVoVm9Cc1E

… thanks!
Nino


View this message in context: http://osgeo-org.1560.x6.nabble.com/Problem-with-GeoServer-2-8-SpatiaLite-extension-tp5253443p5327285.html
Sent from the GeoServer - User mailing list archive at Nabble.com.


Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

Geoserver-users@anonymised.comrge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Regards,
Nuno Oliveira

==
GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information.

Nuno Miguel Carvalho Oliveira
@nmcoliveira
Software Engineer

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)

Italy
phone: +39 0584 962313
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it


AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy’s New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc.


Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

Geoserver-users@anonymised.comrge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

-- 
Regards,
Nuno Oliveira
==
GeoServer Professional Services from the experts! Visit [http://goo.gl/it488V](http://goo.gl/it488V) for more information.
==

Nuno Miguel Carvalho Oliveira
@nmcoliveira
Software Engineer

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax:      +39 0584 1660272

[http://www.geo-solutions.it](http://www.geo-solutions.it)
[http://twitter.com/geosolutions_it](http://twitter.com/geosolutions_it)

-------------------------------------------------------
AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
 
The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility  for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc.

Hi Nuno,

Really I’m not very practical about java (I have basic knowledge), but I guess my java installation (JRE) on Ubuntu 16.04 isn’t good or it is not well configured ! So I want to try again.

I’m looking for and I found this guide:
https://www.digitalocean.com/community/tutorials/how-to-install-java-with-apt-get-on-ubuntu-16-04

what do you think about ? … or have you other tips ?

best regards
Nino

knbicgbfkkfkdaec.png

···

2017-07-12 19:59 GMT+02:00 Nuno Oliveira <nuno.oliveira@anonymised.com>:

I just give it a try with last GeoServer trunk and is working:

I have two possible differences from your setup, I’m using Oracle JDK 8
and I have spatialite Ubuntu packages installed (this should not make
any difference):

ii libspatialite-dev:amd64 4.3.0a-5 amd64 Geospatial extension for SQLite - development files
ii libspatialite7:amd64 4.3.0a-5 amd64 Geospatial extension for SQLite - libraries
ii python-pyspatialite 3.0.1-10 amd64 Python interface to Spatialite
ii spatialite-bin 4.3.0-2 amd64 Geospatial extension for SQLite - tools
ii spatialite-gui 2.0.0~devel2-2 amd64 user-friendly graphical user interface for SpatiaLite

If you are curious the code that checks if the JDBC driver and natives libraries are available:
https://github.com/nmco/geotools/blob/7d4dcbfba9b67ab6aae0b5b65f5366334249147b/modules/library/jdbc/src/main/java/org/geotools/jdbc/JDBCDataStoreFactory.java#L402-L410
https://github.com/nmco/geotools/blob/bd04ccd3f3b7f633f596f3ff93464a8d4a13853c/modules/plugin/jdbc/jdbc-spatialite/src/main/java/org/geotools/data/spatialite/SpatiaLiteDataStoreFactory.java#L74-L80

Hope this helps.

On 07/12/2017 02:40 PM, nino formica wrote:

Yes, I already did . but It does’nt change anything!
I guess that the indications:

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
java -Djava.library.path=/usr/local/lib
-- 
Regards,
Nuno Oliveira
==
GeoServer Professional Services from the experts! Visit [http://goo.gl/it488V](http://goo.gl/it488V) for more information.
==

Nuno Miguel Carvalho Oliveira
@nmcoliveira
Software Engineer

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax:      +39 0584 1660272

[http://www.geo-solutions.it](http://www.geo-solutions.it)
[http://twitter.com/geosolutions_it](http://twitter.com/geosolutions_it)

-------------------------------------------------------
AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
 
The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility  for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc.

are incorrect or ambiguous !

Nino

Il 12 lug 2017 9:47 AM, “Nuno Oliveira” <nuno.oliveira@anonymised.comit> ha scritto:

I remember vaguely that you may need to define this variable too on Linux:
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib

On 07/10/2017 07:27 PM, nformica wrote:

geowolf wrote

Brad is giving you good questions, please share the logs, from the
description it seems that GeoServer is not finding the native library
it’s looking for.

This is my system configuration:

  • Ubuntu 16.04
  • Tomcat 8
  • Java 8 openjdk
  • Geoserver 2.10.3

I have downloaded native library from:
http://docs.geotools.org/latest/userguide/library/jdbc/spatialite.html#native-libraries
precisely the linux 64 bit version:
http://ares.boundlessgeo.com/geotools/spatialite-libs-linux-x86_64.zip

Then I have extracted lib (in zip file) in a folder named “spatialite-libs”
and I put it in /usr/local/lib/ folder.

I restart Tomcat 8 and run Geoserver; this is the log file:
https://drive.google.com/open?id=0B5Doub2YiDSednFrUGVoVm9Cc1E

… thanks!
Nino


View this message in context: http://osgeo-org.1560.x6.nabble.com/Problem-with-GeoServer-2-8-SpatiaLite-extension-tp5253443p5327285.html
Sent from the GeoServer - User mailing list archive at Nabble.com.


Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

Geoserver-users@anonymised.comrge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Regards,
Nuno Oliveira

==
GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information.

Nuno Miguel Carvalho Oliveira
@nmcoliveira
Software Engineer

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)

Italy
phone: +39 0584 962313
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it


AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy’s New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc.


Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

Geoserver-users@anonymised.comrge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Nino,

if you are not already using it, I recommend using the OpenJDK 8 provided for Ubuntu 16.04 as this will have best compatibility with native libraries installed on your system. It is up to date (8u131):
https://packages.ubuntu.com/xenial/openjdk-8-jdk

apt-get update
apt-get install openjdk-8-jdk

OpenJDK is build from the same source as Oracle JDK, and lacks only a few non-free and very new components (fonts, a few audio codecs, and JavaFX). An Oracle JDK for Ubuntu 16.04 should work just as well, so you can skip to the next step if you have one installed.

Likewise, you should be able to install the Ubuntu spatialite libraries with:

apt-get install libspatialite7

The Ubuntu 16.04 version is also up to date (4.3.0a, same a Nuno):
https://packages.ubuntu.com/xenial/libspatialite7

If you use the Ubuntu spatialite libraries, you should not have to set LD_LIBRARY_PATH.

Using the spatialite library compiled for Ubuntu 16.04 will ensure that library loading does not fail because of, for example, missing or renamed dependent libraries.

Kind regards,
Ben.

On 14/07/17 06:12, nino formica wrote:

Hi Nuno,

Really I'm not very practical about java (I have basic knowledge), but I
guess my java installation (JRE) on Ubuntu 16.04 isn't good or it is not
well configured ! So I want to try again.

I'm looking for and I found this guide:
https://www.digitalocean.com/community/tutorials/how-to-install-java-with-apt-get-on-ubuntu-16-04

what do you think about ? .. or have you other tips ?

best regards
Nino

2017-07-12 19:59 GMT+02:00 Nuno Oliveira <nuno.oliveira@anonymised.com>:

I just give it a try with last GeoServer trunk and is working:

I have two possible differences from your setup, I'm using Oracle JDK 8
and I have spatialite Ubuntu packages installed (this should not make
any difference):

ii libspatialite-dev:amd64 4.3.0a-5 amd64 Geospatial
extension for SQLite - development files
ii libspatialite7:amd64 4.3.0a-5 amd64
Geospatial extension for SQLite - libraries
ii python-pyspatialite 3.0.1-10 amd64 Python
interface to Spatialite
ii spatialite-bin 4.3.0-2 amd64
Geospatial extension for SQLite - tools
ii spatialite-gui 2.0.0~devel2-2 amd64
user-friendly graphical user interface for SpatiaLite

If you are curious the code that checks if the JDBC driver and natives
libraries are available:
https://github.com/nmco/geotools/blob/7d4dcbfba9b67ab6aae0b5b65f5366
334249147b/modules/library/jdbc/src/main/java/org/geotools/jdbc/
JDBCDataStoreFactory.java#L402-L410
https://github.com/nmco/geotools/blob/bd04ccd3f3b7f633f596f3ff93464a
8d4a13853c/modules/plugin/jdbc/jdbc-spatialite/src/main/
java/org/geotools/data/spatialite/SpatiaLiteDataStoreFactory.java#L74-L80

Hope this helps.

On 07/12/2017 02:40 PM, nino formica wrote:

Yes, I already did . but It does'nt change anything!
I guess that the indications:

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
java -Djava.library.path=/usr/local/lib

are incorrect or ambiguous !

Nino

Il 12 lug 2017 9:47 AM, "Nuno Oliveira" <nuno.oliveira@anonymised.com>
ha scritto:

I remember vaguely that you may need to define this variable too on Linux:
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib

On 07/10/2017 07:27 PM, nformica wrote:

geowolf wrote

Brad is giving you good questions, please share the logs, from the
description it seems that GeoServer is not finding the native library
it's looking for.

This is my system configuration:
- Ubuntu 16.04
- Tomcat 8
- Java 8 openjdk
- Geoserver 2.10.3

I have downloaded native library from:
http://docs.geotools.org/latest/userguide/library/jdbc/spati
alite.html#native-libraries
precisely the linux 64 bit version:
http://ares.boundlessgeo.com/geotools/spatialite-libs-linux-x86_64.zip

Then I have extracted lib (in zip file) in a folder named
"spatialite-libs"
and I put it in /usr/local/lib/ folder.

I restart Tomcat 8 and run Geoserver; this is the log file:
https://drive.google.com/open?id=0B5Doub2YiDSednFrUGVoVm9Cc1E

... thanks!
Nino

--
View this message in context: http://osgeo-org.1560.x6.nabbl
e.com/Problem-with-GeoServer-2-8-SpatiaLite-extension-tp5253
443p5327285.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

------------------------------------------------------------
------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to
this list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Regards,
Nuno Oliveira

==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.

Nuno Miguel Carvalho Oliveira
@nmcoliveira
Software Engineer

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
Italy

phone: +39 0584 962313
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------

AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.
  The information in this message and/or attachments, is intended solely
for the attention and use of the named addressee(s) and may be confidential
or proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

------------------------------------------------------------
------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to
this list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Regards,
Nuno Oliveira

GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information.

Nuno Miguel Carvalho Oliveira
@nmcoliveira
Software Engineer

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
Italy
phone: +39 0584 962313 <+39%200584%20962313>
fax: +39 0584 1660272 <+39%200584%20166%200272>
http://www.geo-solutions.ithttp://twitter.com/geosolutions_it

-------------------------------------------------------
AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.

The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc.

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot

_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:
- Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Ben Caradoc-Davies <ben@anonymised.com>
Director
Transient Software Limited <http://transient.nz/&gt;
New Zealand

Hi,

Ben mails give good suggestions, I will first try to install spatialite libs and only bother with the Java version after (I doubt the Java version will have any impact).

knbicgbfkkfkdaec.png

···

On 07/13/2017 07:12 PM, nino formica wrote:

Hi Nuno,

Really I’m not very practical about java (I have basic knowledge), but I guess my java installation (JRE) on Ubuntu 16.04 isn’t good or it is not well configured ! So I want to try again.

I’m looking for and I found this guide:
https://www.digitalocean.com/community/tutorials/how-to-install-java-with-apt-get-on-ubuntu-16-04

what do you think about ? … or have you other tips ?

best regards
Nino

2017-07-12 19:59 GMT+02:00 Nuno Oliveira <nuno.oliveira@anonymised.com>:

I just give it a try with last GeoServer trunk and is working:

I have two possible differences from your setup, I’m using Oracle JDK 8
and I have spatialite Ubuntu packages installed (this should not make
any difference):

ii libspatialite-dev:amd64 4.3.0a-5 amd64 Geospatial extension for SQLite - development files
ii libspatialite7:amd64 4.3.0a-5 amd64 Geospatial extension for SQLite - libraries
ii python-pyspatialite 3.0.1-10 amd64 Python interface to Spatialite
ii spatialite-bin 4.3.0-2 amd64 Geospatial extension for SQLite - tools
ii spatialite-gui 2.0.0~devel2-2 amd64 user-friendly graphical user interface for SpatiaLite

If you are curious the code that checks if the JDBC driver and natives libraries are available:
https://github.com/nmco/geotools/blob/7d4dcbfba9b67ab6aae0b5b65f5366334249147b/modules/library/jdbc/src/main/java/org/geotools/jdbc/JDBCDataStoreFactory.java#L402-L410
https://github.com/nmco/geotools/blob/bd04ccd3f3b7f633f596f3ff93464a8d4a13853c/modules/plugin/jdbc/jdbc-spatialite/src/main/java/org/geotools/data/spatialite/SpatiaLiteDataStoreFactory.java#L74-L80

Hope this helps.

On 07/12/2017 02:40 PM, nino formica wrote:

Yes, I already did . but It does’nt change anything!
I guess that the indications:

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
java -Djava.library.path=/usr/local/lib

are incorrect or ambiguous !

Nino

Il 12 lug 2017 9:47 AM, “Nuno Oliveira” <nuno.oliveira@anonymised.comit> ha scritto:

I remember vaguely that you may need to define this variable too on Linux:
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib

On 07/10/2017 07:27 PM, nformica wrote:

geowolf wrote

Brad is giving you good questions, please share the logs, from the
description it seems that GeoServer is not finding the native library
it’s looking for.

This is my system configuration:

  • Ubuntu 16.04
  • Tomcat 8
  • Java 8 openjdk
  • Geoserver 2.10.3

I have downloaded native library from:
http://docs.geotools.org/latest/userguide/library/jdbc/spatialite.html#native-libraries
precisely the linux 64 bit version:
http://ares.boundlessgeo.com/geotools/spatialite-libs-linux-x86_64.zip

Then I have extracted lib (in zip file) in a folder named “spatialite-libs”
and I put it in /usr/local/lib/ folder.

I restart Tomcat 8 and run Geoserver; this is the log file:
https://drive.google.com/open?id=0B5Doub2YiDSednFrUGVoVm9Cc1E

… thanks!
Nino


View this message in context: http://osgeo-org.1560.x6.nabble.com/Problem-with-GeoServer-2-8-SpatiaLite-extension-tp5253443p5327285.html
Sent from the GeoServer - User mailing list archive at Nabble.com.


Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

Geoserver-users@anonymised.comrge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Regards,
Nuno Oliveira

==
GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information.

Nuno Miguel Carvalho Oliveira
@nmcoliveira
Software Engineer

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)

Italy
phone: +39 0584 962313
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it


AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy’s New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc.


Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

Geoserver-users@anonymised.comrge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

-- 
Regards,
Nuno Oliveira
==
GeoServer Professional Services from the experts! Visit [http://goo.gl/it488V](http://goo.gl/it488V) for more information.
==

Nuno Miguel Carvalho Oliveira
@nmcoliveira
Software Engineer

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax:      +39 0584 1660272

[http://www.geo-solutions.it](http://www.geo-solutions.it)
[http://twitter.com/geosolutions_it](http://twitter.com/geosolutions_it)

-------------------------------------------------------
AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
 
The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility  for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc.

-- 
Regards,
Nuno Oliveira
==
GeoServer Professional Services from the experts! Visit [http://goo.gl/it488V](http://goo.gl/it488V) for more information.
==

Nuno Miguel Carvalho Oliveira
@nmcoliveira
Software Engineer

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax:      +39 0584 1660272

[http://www.geo-solutions.it](http://www.geo-solutions.it)
[http://twitter.com/geosolutions_it](http://twitter.com/geosolutions_it)

-------------------------------------------------------
AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
 
The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility  for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc.

Hi Ben,

Ben Caradoc-Davies-2 wrote

Likewise, you should be able to install the Ubuntu spatialite libraries
with:
apt-get install libspatialite7

The Ubuntu 16.04 version is also up to date (4.3.0a, same a Nuno):
https://packages.ubuntu.com/xenial/libspatialite7

I think libspatialite7 is already installed in my system ... I'll check it!

Ben Caradoc-Davies-2 wrote

If you use the Ubuntu spatialite libraries, you should not have to set
LD_LIBRARY_PATH.

ok, I understand !
But do I still have to run :
java -Djava.library.path=/usr/local/spatialite-lib ??

being "spatialite-libs" the folder name where I extracted the "lib" from
http://ares.boundlessgeo.com/geotools/spatialite-libs-linux-x86_64.zip

many thanks
Nino

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Problem-with-GeoServer-2-8-SpatiaLite-extension-tp5253443p5327965.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

On 15/07/17 08:51, nformica wrote:

Ben Caradoc-Davies wrote

If you use the Ubuntu spatialite libraries, you should not have to set
LD_LIBRARY_PATH.

ok, I understand !
But do I still have to run :
java -Djava.library.path=/usr/local/spatialite-lib ??
being "spatialite-libs" the folder name where I extracted the "lib" from
http://ares.boundlessgeo.com/geotools/spatialite-libs-linux-x86_64.zip

I advise against it. I recommend using the Ubuntu libspatialite7 only, and this will be on the system library path and should be found automatically. Using the path configuration commands will cause two different versions to be visible, which will likely cause problems. With no path options, only the Ubuntu version will be used.

Kind regards,

--
Ben Caradoc-Davies <ben@anonymised.com>
Director
Transient Software Limited <http://transient.nz/&gt;
New Zealand