Re: [Geoserver-users] SQL Server Store

[Parker, Peter R (OIT)]

Thanks so much Matt that appears to be the problem. I installed using the 7.2 
version of the mssql driver and now the MSSQL source appears in the Stores.

Peter

From: Matt Barclay 
Sent: Thursday, April 25, 2019 4:50 PM
To: Parker, Peter R (OIT) 
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] SQL Server Store

Hi Peter,

I just started using SQL Server with GeoServer (2.15.0).  What worked for me 
was grabbing the latest MS JDBC driver:

https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-2017

Make sure that goes in your webapps/geoserver/WEB-INF/lib directory along side 
the gt-jdbc-sqlserver extension.  After a restart, you should see SQL Server on 
the "Add new Store" page.

But also check your console log to see if there are any exceptions being thrown 
due to missing libraries.  I hit more than a few issues where the MS JDBC 
driver wanted some other library installed.

Regards,
Matt


On Thu, Apr 25, 2019 at 1:35 PM Parker, Peter R (OIT) 
mailto:peter.par...@alaska.gov>> wrote:
Using GeoServer 2.14.3 running on RedHat Linux. Installed the appropriate SQL 
Server Drivers (sqljdbc42.jar and gt-jdbc-sqlserver-20.3.jar ) but when I go to 
the Stores Admin in the UI I do not see an option for MS SQL Server.
I use Oracle as well and  with those driver installed, I see the Vector 
Datasource for Oracle in the Stores – New data source page.
Any ideas why I am not seeing the SQL Server option? Thank you!  Peter
___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


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

Re: [Geoserver-users] /data directory not writeable

[Andrea Aime]

Strange... the error message comes from GeoWebCache:

https://github.com/GeoWebCache/geowebcache/blob/5e913193ff50a61ef9dd63a87887189352fa6b21/geowebcache/core/src/main/java/org/geowebcache/storage/DefaultStorageFinder.java#L124

but a "blame" shows this code has not been touched in 10 years:

https://github.com/GeoWebCache/geowebcache/blame/5e913193ff50a61ef9dd63a87887189352fa6b21/geowebcache/core/src/main/java/org/geowebcache/storage/DefaultStorageFinder.java#L124

So yes, maybe a java 11 thing, though I don't know what exactly.

Cheers
Andrea


On Fri, Apr 26, 2019 at 11:00 AM Russ Hore  wrote:

> OK. I have not solved it but have done some research;
> 1) Installed clean Ubuntu 18.04.2
> 2) apt-get update / upgrade etc
> 3) Installed tomcat9
> 4) Copied 2.15 GeoServer.war to /var/lib/tomcat9/webapps
> GeoServer started
> 5) created /data, chown tomcat:tomcat /data/
> 6) restarted tomcat9, and got the original error “which is not writeable”
> 7) Installed GeoServer 2.14
> 8) It won’t run under java 11 I assume
> 9) Installed OpenJDK 1.8.0_191
> 10) Installed tomcat8
> 11) Installed GeoServer.war
> 12) Edited web.xml to set DATA_DIR
> 13) GeoServer started and used /data as DATA dir.
>
> I am not sure where to look now but if anybody has things they want me to
> look at I have some spare time.
>
> I may try tomcat8/Java 8 on Ubuntu 19.04 later.
>
> Russ
>
> On 26 Apr 2019, at 08:42, Russ Hore  wrote:
>
> Hi Benoit,
>
> Good suggestion, (and I might be missing something obvious),  but I am
> using an absolute path.
>
> /data exists under the root filesystem
>
> This is the way I have set up GeoServer before so I can easily upgrade.
> Maybe something has changed between Ubuntu 18 & 19
>
> I am about to do a clean install of Ubuntu 18 so will ley the list know.
>
> Russ
>
> On 26 Apr 2019, at 08:18, DEGRÈVE Benoît  wrote:
>
> Hi all,
>
> Russ, I would like to help but I may be wrong : have you already tried an
> absolute path instead ?
>
> I say that because I’ve recently change my web.xml to direct Geoserver to
> save cached tiles in a geoserver (+tomcat) subdirectory and I used an
> absolute path, and it works without changing anything else.
>
> And if you want to use a relative path, maybe you should use « ./data/ »
> instead of « /data/ »
>
> Hope it helps,
>
>
> *Benoît DEGRÈVE*
> Risques sous-sols et cartographie
>
> Bachelier en gestion de données et cartographie
>
>
> *De :* Russ Hore [mailto:r...@russ-hore.co.uk ]
> *Envoyé :* jeudi 25 avril 2019 18:52
> *À :* Ian Turton
> *Cc :* geoserver-users@lists.sourceforge.net
> *Objet :* Re: [Geoserver-users] /data directory not writeable
>
> # ls -ld /data
> drwxrwxrwx 2 tomcat tomcat 4096 Apr 25 15:10 /data
>
>
> For info.,
>
> # ps -efl |grep tomcat
> 4 S tomcat1232 1 49  80   0 - 1716271 futex_ 16:49 ?  00:00:46
> /usr/lib/jvm/default-java/bin/java
> -Djava.util.logging.config.file=/var/lib/tomcat9/conf/logging.properties
> -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
> -Djava.awt.headless=true -XX:+UseG1GC -Djdk.tls.ephemeralDHKeySize=2048
> -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
> -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
> -DGEOSERVER_DATA_DIR=/data -Dignore.endorsed.dirs= -classpath
> /usr/share/tomcat9/bin/bootstrap.jar:/usr/share/tomcat9/bin/tomcat-juli.jar
> -Dcatalina.base=/var/lib/tomcat9 -Dcatalina.home=/usr/share/tomcat9
> -Djava.io.tmpdir=/tmp org.apache.catalina.startup.Bootstrap start
>
> Russ
>
>
> On 25 Apr 2019, at 17:22, Ian Turton  wrote:
>
> can you paste the result of "ls -ld /data" in here, I suspect that is
> isn't what you think it is
>
> Ian
>
> On Thu, 25 Apr 2019 at 17:05, Russ Hore  wrote:
>
> I have just done a clean installation of Ubuntu 19.04, installed Tomcat 9,
> installed OpenJDK 11 and installed GS 2.15
>
> I have a folder called /data to which I point GeoServer by editing web.xml
>
>
>GEOSERVER_DATA_DIR
>/data/
> 
>
> Now when I start GeoServer I get an error in /var/log/syslog saying /data
> is not writeable !
>
> Apr 25 15:14:05 hostname tomcat9[13480]: 25 Apr 15:14:05 ERROR
> [storage.DefaultStorageFinder] - Found Servlet context parameter
> GEOSERVER_DATA_DIR set to /data/ , which is not writeable
>
> Tomcat is running as user ‘tomcat’. The /data folder is owned by tomcat
> with permissions 777 (I know that is not the best but I am trying to get
> things working)
>
> I have tried setting the data folder in her setclasspath.sh
>
> CATALINA_OPTS="-DGEOSERVER_DATA_DIR=/data"
>
> But I get the same error.
>
> Has anybody else seen this?
>
> Russ
> ___
> 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
>
>

Re: [Geoserver-users] /data directory not writeable

[Russ Hore]

OK. I have not solved it but have done some research;
1) Installed clean Ubuntu 18.04.2
2) apt-get update / upgrade etc
3) Installed tomcat9
4) Copied 2.15 GeoServer.war to /var/lib/tomcat9/webapps
GeoServer started
5) created /data, chown tomcat:tomcat /data/
6) restarted tomcat9, and got the original error “which is not writeable”
7) Installed GeoServer 2.14
8) It won’t run under java 11 I assume
9) Installed OpenJDK 1.8.0_191
10) Installed tomcat8
11) Installed GeoServer.war
12) Edited web.xml to set DATA_DIR
13) GeoServer started and used /data as DATA dir.

I am not sure where to look now but if anybody has things they want me to look 
at I have some spare time.

I may try tomcat8/Java 8 on Ubuntu 19.04 later.

Russ

> On 26 Apr 2019, at 08:42, Russ Hore  wrote:
> 
> Hi Benoit,
> 
> Good suggestion, (and I might be missing something obvious),  but I am using 
> an absolute path.
> 
> /data exists under the root filesystem
> 
> This is the way I have set up GeoServer before so I can easily upgrade. Maybe 
> something has changed between Ubuntu 18 & 19
> 
> I am about to do a clean install of Ubuntu 18 so will ley the list know.
> 
> Russ
>> On 26 Apr 2019, at 08:18, DEGRÈVE Benoît > > wrote:
>> 
>> Hi all,
>>  
>> Russ, I would like to help but I may be wrong : have you already tried an 
>> absolute path instead ?
>>  
>> I say that because I’ve recently change my web.xml to direct Geoserver to 
>> save cached tiles in a geoserver (+tomcat) subdirectory and I used an 
>> absolute path, and it works without changing anything else.
>>  
>> And if you want to use a relative path, maybe you should use « ./data/ » 
>> instead of « /data/ »
>>  
>> Hope it helps,
>>  
>> Benoît DEGRÈVE
>> Risques sous-sols et cartographie
>> 
>> Bachelier en gestion de données et cartographie
>> 
>> 
>>  
>> De : Russ Hore [mailto:r...@russ-hore.co.uk ] 
>> Envoyé : jeudi 25 avril 2019 18:52
>> À : Ian Turton
>> Cc : geoserver-users@lists.sourceforge.net 
>> 
>> Objet : Re: [Geoserver-users] /data directory not writeable
>>  
>> # ls -ld /data
>> drwxrwxrwx 2 tomcat tomcat 4096 Apr 25 15:10 /data
>>  
>>  
>> For info.,
>>  
>> # ps -efl |grep tomcat
>> 4 S tomcat1232 1 49  80   0 - 1716271 futex_ 16:49 ?  00:00:46 
>> /usr/lib/jvm/default-java/bin/java 
>> -Djava.util.logging.config.file=/var/lib/tomcat9/conf/logging.properties 
>> -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 
>> -Djava.awt.headless=true -XX:+UseG1GC -Djdk.tls.ephemeralDHKeySize=2048 
>> -Djava.protocol.handler.pkgs=org.apache.catalina.webresources 
>> -Dorg.apache.catalina.security.SecurityListener.UMASK=0027 
>> -DGEOSERVER_DATA_DIR=/data -Dignore.endorsed.dirs= -classpath 
>> /usr/share/tomcat9/bin/bootstrap.jar:/usr/share/tomcat9/bin/tomcat-juli.jar 
>> -Dcatalina.base=/var/lib/tomcat9 -Dcatalina.home=/usr/share/tomcat9 
>> -Djava.io.tmpdir=/tmp org.apache.catalina.startup.Bootstrap start
>>  
>> Russ
>> 
>> 
>> On 25 Apr 2019, at 17:22, Ian Turton > > wrote:
>>  
>> can you paste the result of "ls -ld /data" in here, I suspect that is isn't 
>> what you think it is
>>  
>> Ian
>>  
>> On Thu, 25 Apr 2019 at 17:05, Russ Hore > > wrote:
>> I have just done a clean installation of Ubuntu 19.04, installed Tomcat 9, 
>> installed OpenJDK 11 and installed GS 2.15
>>  
>> I have a folder called /data to which I point GeoServer by editing web.xml
>>  
>>
>>GEOSERVER_DATA_DIR
>>/data/
>> 
>>  
>> Now when I start GeoServer I get an error in /var/log/syslog saying /data is 
>> not writeable !
>>  
>> Apr 25 15:14:05 hostname tomcat9[13480]: 25 Apr 15:14:05 ERROR 
>> [storage.DefaultStorageFinder] - Found Servlet context parameter 
>> GEOSERVER_DATA_DIR set to /data/ , which is not writeable
>>  
>> Tomcat is running as user ‘tomcat’. The /data folder is owned by tomcat with 
>> permissions 777 (I know that is not the best but I am trying to get things 
>> working)
>>  
>> I have tried setting the data folder in her setclasspath.sh
>>  
>> CATALINA_OPTS="-DGEOSERVER_DATA_DIR=/data"
>>  
>> But I get the same error.
>>  
>> Has anybody else seen this?
>>  
>> Russ
>> ___
>> 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 
>> 
>> 
>> If you want to request a feature or an improvement, also see this: 
>> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoSe

Re: [Geoserver-users] /data directory not writeable

[Russ Hore]

Hi Benoit,

Good suggestion, (and I might be missing something obvious),  but I am using an 
absolute path.

/data exists under the root filesystem

This is the way I have set up GeoServer before so I can easily upgrade. Maybe 
something has changed between Ubuntu 18 & 19

I am about to do a clean install of Ubuntu 18 so will ley the list know.

Russ
> On 26 Apr 2019, at 08:18, DEGRÈVE Benoît  wrote:
> 
> Hi all,
>  
> Russ, I would like to help but I may be wrong : have you already tried an 
> absolute path instead ?
>  
> I say that because I’ve recently change my web.xml to direct Geoserver to 
> save cached tiles in a geoserver (+tomcat) subdirectory and I used an 
> absolute path, and it works without changing anything else.
>  
> And if you want to use a relative path, maybe you should use « ./data/ » 
> instead of « /data/ »
>  
> Hope it helps,
>  
> Benoît DEGRÈVE
> Risques sous-sols et cartographie
> 
> Bachelier en gestion de données et cartographie
> 
> 
>  
> De : Russ Hore [mailto:r...@russ-hore.co.uk] 
> Envoyé : jeudi 25 avril 2019 18:52
> À : Ian Turton
> Cc : geoserver-users@lists.sourceforge.net
> Objet : Re: [Geoserver-users] /data directory not writeable
>  
> # ls -ld /data
> drwxrwxrwx 2 tomcat tomcat 4096 Apr 25 15:10 /data
>  
>  
> For info.,
>  
> # ps -efl |grep tomcat
> 4 S tomcat1232 1 49  80   0 - 1716271 futex_ 16:49 ?  00:00:46 
> /usr/lib/jvm/default-java/bin/java 
> -Djava.util.logging.config.file=/var/lib/tomcat9/conf/logging.properties 
> -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 
> -Djava.awt.headless=true -XX:+UseG1GC -Djdk.tls.ephemeralDHKeySize=2048 
> -Djava.protocol.handler.pkgs=org.apache.catalina.webresources 
> -Dorg.apache.catalina.security.SecurityListener.UMASK=0027 
> -DGEOSERVER_DATA_DIR=/data -Dignore.endorsed.dirs= -classpath 
> /usr/share/tomcat9/bin/bootstrap.jar:/usr/share/tomcat9/bin/tomcat-juli.jar 
> -Dcatalina.base=/var/lib/tomcat9 -Dcatalina.home=/usr/share/tomcat9 
> -Djava.io.tmpdir=/tmp org.apache.catalina.startup.Bootstrap start
>  
> Russ
> 
> 
> On 25 Apr 2019, at 17:22, Ian Turton  > wrote:
>  
> can you paste the result of "ls -ld /data" in here, I suspect that is isn't 
> what you think it is
>  
> Ian
>  
> On Thu, 25 Apr 2019 at 17:05, Russ Hore  > wrote:
> I have just done a clean installation of Ubuntu 19.04, installed Tomcat 9, 
> installed OpenJDK 11 and installed GS 2.15
>  
> I have a folder called /data to which I point GeoServer by editing web.xml
>  
>
>GEOSERVER_DATA_DIR
>/data/
> 
>  
> Now when I start GeoServer I get an error in /var/log/syslog saying /data is 
> not writeable !
>  
> Apr 25 15:14:05 hostname tomcat9[13480]: 25 Apr 15:14:05 ERROR 
> [storage.DefaultStorageFinder] - Found Servlet context parameter 
> GEOSERVER_DATA_DIR set to /data/ , which is not writeable
>  
> Tomcat is running as user ‘tomcat’. The /data folder is owned by tomcat with 
> permissions 777 (I know that is not the best but I am trying to get things 
> working)
>  
> I have tried setting the data folder in her setclasspath.sh
>  
> CATALINA_OPTS="-DGEOSERVER_DATA_DIR=/data"
>  
> But I get the same error.
>  
> Has anybody else seen this?
>  
> Russ
> ___
> 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 
> 
> 
> If you want to request a feature or an improvement, also see this: 
> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>  
> 
> 
> 
> Geoserver-users@lists.sourceforge.net 
> 
> https://lists.sourceforge.net/lists/listinfo/geoserver-users 
> 
> 
>  
> -- 
> Ian Turton

___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.ne

Re: [Geoserver-users] /data directory not writeable

[Russ Hore]

Hi Panagiotis,

Good idea but it is tomcat;

# cat /etc/shadow|grep tom
tomcat:!!:18011::
# 

Russ

> On 26 Apr 2019, at 08:13, Panagiotis Kountouris  
> wrote:
> 
> Hi Russ,
> 
> could you please list your users with a "sudo less /etc/shadow" ? I think you 
> will see that your user is tomcat9 and not tomcat. If thats the case try to 
> change ownership of your data folder by sudo chown -R tomcat9:tomcat9 /data
> 
> hope that helps.
> 
> Best regards,
> 
> Panagiotis
> 
> 
> 
> 
> 
> On 26.04.19 08:48, Russ Hore wrote:
>> I will try a clean install to Ubuntu 18.04 with the same Java etc and see 
>> what happens.
>> 
>> Russ
>> 
>>> On 25 Apr 2019, at 17:51, Russ Hore >> > wrote:
>>> 
>>> # ls -ld /data
>>> drwxrwxrwx 2 tomcat tomcat 4096 Apr 25 15:10 /data
>>> 
>>> 
>>> For info.,
>>> 
>>> # ps -efl |grep tomcat
>>> 4 S tomcat1232 1 49  80   0 - 1716271 futex_ 16:49 ?  00:00:46 
>>> /usr/lib/jvm/default-java/bin/java 
>>> -Djava.util.logging.config.file=/var/lib/tomcat9/conf/logging.properties 
>>> -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 
>>> -Djava.awt.headless=true -XX:+UseG1GC -Djdk.tls.ephemeralDHKeySize=2048 
>>> -Djava.protocol.handler.pkgs=org.apache.catalina.webresources 
>>> -Dorg.apache.catalina.security.SecurityListener.UMASK=0027 
>>> -DGEOSERVER_DATA_DIR=/data -Dignore.endorsed.dirs= -classpath 
>>> /usr/share/tomcat9/bin/bootstrap.jar:/usr/share/tomcat9/bin/tomcat-juli.jar 
>>> -Dcatalina.base=/var/lib/tomcat9 -Dcatalina.home=/usr/share/tomcat9 
>>> -Djava.io.tmpdir=/tmp org.apache.catalina.startup.Bootstrap start
>>> 
>>> Russ
>>> 
 On 25 Apr 2019, at 17:22, Ian Turton >>> > wrote:
 
 can you paste the result of "ls -ld /data" in here, I suspect that is 
 isn't what you think it is
 
 Ian
 
 On Thu, 25 Apr 2019 at 17:05, Russ Hore >>> > wrote:
 I have just done a clean installation of Ubuntu 19.04, installed Tomcat 9, 
 installed OpenJDK 11 and installed GS 2.15
 
 I have a folder called /data to which I point GeoServer by editing web.xml
 

GEOSERVER_DATA_DIR
/data/
 
 
 Now when I start GeoServer I get an error in /var/log/syslog saying /data 
 is not writeable !
 
 Apr 25 15:14:05 hostname tomcat9[13480]: 25 Apr 15:14:05 ERROR 
 [storage.DefaultStorageFinder] - Found Servlet context parameter 
 GEOSERVER_DATA_DIR set to /data/ , which is not writeable
 
 Tomcat is running as user ‘tomcat’. The /data folder is owned by tomcat 
 with permissions 777 (I know that is not the best but I am trying to get 
 things working)
 
 I have tried setting the data folder in her setclasspath.sh
 
 CATALINA_OPTS="-DGEOSERVER_DATA_DIR=/data"
 
 But I get the same error.
 
 Has anybody else seen this?
 
 Russ
 ___
 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 
 
 
 If you want to request a feature or an improvement, also see this: 
 https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
  
 
 
 
 Geoserver-users@lists.sourceforge.net 
 
 https://lists.sourceforge.net/lists/listinfo/geoserver-users 
 
 
 
 -- 
 Ian Turton
>>> 
>>> ___
>>> 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 
>>> 
>>> 
>>> If you want to request a feature or an improvement, also see this: 
>>> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>>>  
>>> 
>>> 
>>> 
>>> Geose

Re: [Geoserver-users] /data directory not writeable

[Panagiotis Kountouris]

Hi Russ,

could you please list your users with a "sudo less /etc/shadow" ? I 
think you will see that your user is tomcat9 and not tomcat. If thats 
the case try to change ownership of your data folder by sudo chown -R 
tomcat9:tomcat9 /data


hope that helps.

Best regards,

Panagiotis



On 26.04.19 08:48, Russ Hore wrote:
I will try a clean install to Ubuntu 18.04 with the same Java etc and 
see what happens.


Russ

On 25 Apr 2019, at 17:51, Russ Hore > wrote:


# ls -ld /data
drwxrwxrwx 2 tomcat tomcat 4096 Apr 25 15:10 /data


For info.,

# ps -efl |grep tomcat
4 S tomcat    1232     1 49  80   0 - 1716271 futex_ 16:49 ?     
 00:00:46 /usr/lib/jvm/default-java/bin/java 
-Djava.util.logging.config.file=/var/lib/tomcat9/conf/logging.properties 
-Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 
-Djava.awt.headless=true -XX:+UseG1GC 
-Djdk.tls.ephemeralDHKeySize=2048 
-Djava.protocol.handler.pkgs=org.apache.catalina.webresources 
-Dorg.apache.catalina.security.SecurityListener.UMASK=0027 
-DGEOSERVER_DATA_DIR=/data -Dignore.endorsed.dirs= -classpath 
/usr/share/tomcat9/bin/bootstrap.jar:/usr/share/tomcat9/bin/tomcat-juli.jar 
-Dcatalina.base=/var/lib/tomcat9 -Dcatalina.home=/usr/share/tomcat9 
-Djava.io.tmpdir=/tmp org.apache.catalina.startup.Bootstrap start


Russ

On 25 Apr 2019, at 17:22, Ian Turton > wrote:


can you paste the result of "ls -ld /data" in here, I suspect that 
is isn't what you think it is


Ian

On Thu, 25 Apr 2019 at 17:05, Russ Hore > wrote:


I have just done a clean installation of Ubuntu 19.04, installed
Tomcat 9, installed OpenJDK 11 and installed GS 2.15

I have a folder called /data to which I point GeoServer by
editing web.xml

   
 GEOSERVER_DATA_DIR
 /data/
    

Now when I start GeoServer I get an error in /var/log/syslog
saying /data is not writeable !

Apr 25 15:14:05 hostname tomcat9[13480]: 25 Apr 15:14:05 ERROR
[storage.DefaultStorageFinder] - Found Servlet context parameter
GEOSERVER_DATA_DIR set to /data/ , which is not writeable

Tomcat is running as user ‘tomcat’. The /data folder is owned by
tomcat with permissions 777 (I know that is not the best but I
am trying to get things working)

I have tried setting the data folder in her setclasspath.sh

CATALINA_OPTS="-DGEOSERVER_DATA_DIR=/data"

But I get the same error.

Has anybody else seen this?

Russ
___
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

If you want to request a feature or an improvement, also see
this:

https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net

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



--
Ian Turton


___
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


If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer



Geoserver-users@lists.sourceforge.net 


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




___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


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


--
Dr. Panagiotis Kountouris

Chief Research Officer
Drift & Noise Polar Services GmbH
www.driftnoise.com
Stavendamm 17
28195 Bremen, Germany

Office: +49 421 223 70 660
Mobile: +49 176 79 07 11 36

___
Geoserver-users mailing list

Please make sure you read the 

Re: [Geoserver-users] /data directory not writeable

[DEGRÈVE Benoît]

Hi all,

Russ, I would like to help but I may be wrong : have you already tried an 
absolute path instead ?

I say that because I’ve recently change my web.xml to direct Geoserver to save 
cached tiles in a geoserver (+tomcat) subdirectory and I used an absolute path, 
and it works without changing anything else.

And if you want to use a relative path, maybe you should use « ./data/ » 
instead of « /data/ »

Hope it helps,

Benoît DEGRÈVE
Risques sous-sols et cartographie
Bachelier en gestion de données et cartographie


De : Russ Hore [mailto:r...@russ-hore.co.uk]
Envoyé : jeudi 25 avril 2019 18:52
À : Ian Turton
Cc : geoserver-users@lists.sourceforge.net
Objet : Re: [Geoserver-users] /data directory not writeable

# ls -ld /data
drwxrwxrwx 2 tomcat tomcat 4096 Apr 25 15:10 /data


For info.,

# ps -efl |grep tomcat
4 S tomcat1232 1 49  80   0 - 1716271 futex_ 16:49 ?  00:00:46 
/usr/lib/jvm/default-java/bin/java 
-Djava.util.logging.config.file=/var/lib/tomcat9/conf/logging.properties 
-Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 
-Djava.awt.headless=true -XX:+UseG1GC -Djdk.tls.ephemeralDHKeySize=2048 
-Djava.protocol.handler.pkgs=org.apache.catalina.webresources 
-Dorg.apache.catalina.security.SecurityListener.UMASK=0027 
-DGEOSERVER_DATA_DIR=/data -Dignore.endorsed.dirs= -classpath 
/usr/share/tomcat9/bin/bootstrap.jar:/usr/share/tomcat9/bin/tomcat-juli.jar 
-Dcatalina.base=/var/lib/tomcat9 -Dcatalina.home=/usr/share/tomcat9 
-Djava.io.tmpdir=/tmp org.apache.catalina.startup.Bootstrap start

Russ


On 25 Apr 2019, at 17:22, Ian Turton 
mailto:ijtur...@gmail.com>> wrote:

can you paste the result of "ls -ld /data" in here, I suspect that is isn't 
what you think it is

Ian

On Thu, 25 Apr 2019 at 17:05, Russ Hore 
mailto:r...@russ-hore.co.uk>> wrote:
I have just done a clean installation of Ubuntu 19.04, installed Tomcat 9, 
installed OpenJDK 11 and installed GS 2.15

I have a folder called /data to which I point GeoServer by editing web.xml

   
   GEOSERVER_DATA_DIR
   /data/


Now when I start GeoServer I get an error in /var/log/syslog saying /data is 
not writeable !

Apr 25 15:14:05 hostname tomcat9[13480]: 25 Apr 15:14:05 ERROR 
[storage.DefaultStorageFinder] - Found Servlet context parameter 
GEOSERVER_DATA_DIR set to /data/ , which is not writeable

Tomcat is running as user ‘tomcat’. The /data folder is owned by tomcat with 
permissions 777 (I know that is not the best but I am trying to get things 
working)

I have tried setting the data folder in her setclasspath.sh

CATALINA_OPTS="-DGEOSERVER_DATA_DIR=/data"

But I get the same error.

Has anybody else seen this?

Russ
___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


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


--
Ian Turton

___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


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