Hi Andrea and Luke,
thank you soo much for your answers.
While your responses did not help me to directly sole the problem they got me thinking more about the message JNDI source not found … then I poked around the GeoServer doc http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html how to configure that connection driver and finally stumbled about the configuration file with is located in the tomcat home directory TOMCAT_HOME/conf/context.xml …which is /etc/tomcat7/context.xml in our servers.
I then compared the files /etc/tomcat7/context.xml in our live and the dev server (that was messed up) and found that the file on dev did not have any resource (data base connection tag) configured.
So what must have happened it that tomcat7 had been upgraded by someone and at that time the config.xml file was overwritten with the default file.
So to fix I replaced that file on dev with the live file version (attached) and restarted tomcat and voila all layers all working again.
Lesson to be learned is that when updating tomcat7 one need to copy also that config.xml file and update after installation to make the Geoserver layers based on (postgres) JNDI connections work.
Cheers
Karsten
From: andrea.aime@anonymised.com [mailto:andrea.aime@anonymised.com] On Behalf Of Andrea Aime
Sent: Friday, August 21, 2015 4:10
To: karsten@anonymised.com
Cc: GeoServer Mailing List List
Subject: Re: [Geoserver-users] Layer edit : Cannot find JNDI data source: java:comp/env/jdbc/postgres
On Thu, Aug 20, 2015 at 9:57 PM, karsten <karsten@anonymised.com> wrote:
Hi All,
I am trying to help a friend to fix his Geoserver 2.6.0 installation on Ubuntu Server, after some changes (a but unclear to me what happened ). Symptom is in the web interface when clicking on ‘edit layer’ the top liste this error:
failed to load attribute list, internal error is: Cannot find JNDI data source: java:comp/env/jdbc/postgres
Any idea what this means (or indicates what might have gone wrong) or ho to fix?
It means what it says, that the JNDI source cannot be found. Did you configure it correctly in your web container?
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 Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
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.