Thanks Humphries. In the $JETTY_BASE, I didn't have the lib folder. I created it and placed the jar inside but it didn't work. I will try again but creating the jdbc folder too.
Thanks again. El jue, 8 sept 2022 a las 1:41, Humphries, Graham (< graham.humphr...@stategrowth.tas.gov.au>) escribió: > According to some documentation I found ( > https://help.percussion.com/rhythmyx/implementation/jetty/jetty-file-structure.html) > you should place database drivers here: jetty/base/lib/jdbc > > > > *From:* Micho García <micho.gar...@geomatico.es> > *Sent:* Wednesday, 7 September 2022 11:38 PM > *To:* GeoServer Mailing List List <geoserver-users@lists.sourceforge.net> > *Subject:* [Geoserver-users] Connecting Jetty to Postgis using JNDI > > > > Hi everybody, > > > I'm Micho from geomatico.es > <https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgeomatico.es%2F&data=05%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C27986e1c2b874ae2da7008da90daa943%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637981567866547011%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=Fxl80ru%2Bvr041noKWm3nt%2FP6NwvU1Jm13IahHSV5zyA%3D&reserved=0> > and I'm having some problems connecting geoserver's Jetty with Postgis > using JNDI. > > > I've read the documentation and I've configured a settings.xml with my > JNDI configuration (attached). I need to understand why geoserver is trying > to delete my whole indexes' database, but when I tried to publish an > imagemosaic I receive this error: > > > 07 Sep 15:13:59 ERROR [gce.imagemosaic] - Unable to obtain connection: > Cannot create JDBC driver of class 'org.postgresql.Driver' for connect URL > 'jdbc:postgres://172.20.0.11:5432/satagro_indexes > <https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2F172.20.0.11%3A5432%2Fsatagro_indexes&data=05%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C27986e1c2b874ae2da7008da90daa943%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637981567866547011%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=IjQiYe33%2Fz%2FxQv8pGCGoAGYrdTn%2FbCsS%2BNao6lAHYws%3D&reserved=0> > ' > java.lang.RuntimeException: Unable to obtain connection: Cannot create > JDBC driver of class 'org.postgresql.Driver' for connect URL > 'jdbc:postgres://172.20.0.11:5432/satagro_indexes > <https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2F172.20.0.11%3A5432%2Fsatagro_indexes&data=05%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C27986e1c2b874ae2da7008da90daa943%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637981567866547011%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=IjQiYe33%2Fz%2FxQv8pGCGoAGYrdTn%2FbCsS%2BNao6lAHYws%3D&reserved=0> > ' > > I was investigating and I am almost sure that the Jetty is unable to get > the Driver but my problem is that I don't know where I should place > the postgresql-42.5.0.jar. I've placed into the $JETTY_HOME (in my case > /home/michogarcia/geomati.co/SATAGRO/dev/geoserver/src/release/jetty/)in > <https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgeomati.co%2FSATAGRO%2Fdev%2Fgeoserver%2Fsrc%2Frelease%2Fjetty%2F)in&data=05%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C27986e1c2b874ae2da7008da90daa943%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637981567866547011%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=9VuQb9ppID0hAc4C%2BpWbHe7TxVJnadkEl6PPH8upGS0%3D&reserved=0> > the $JETTY_HOME/resources and in several more places, but always with the > same result. > > > Where I should place the .jar to be used by Jetty?. > > > Thanks a lot. > > > Best. > > > > settings.xml: > > > > <?xml version="1.0"?> > <!DOCTYPE Configure PUBLIC "-//Mort Bay Consulting//DTD Configure//EN" " > http://jetty.mortbay.org/configure.dtd > <https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fjetty.mortbay.org%2Fconfigure.dtd&data=05%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C27986e1c2b874ae2da7008da90daa943%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637981567866547011%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=SiGnggSBvlC9hKbYMGKAROqs2efVh1OcUuGHKJT7eag%3D&reserved=0> > "> > <Configure class="org.eclipse.jetty.server.Server"> > <New class="org.eclipse.jetty.plus.jndi.Resource"> > <Arg>java:comp/env/jdbc/postgres</Arg> > <Arg> > <New class="org.apache.commons.dbcp.BasicDataSource"> > <Set name="driverClassName">org.postgresql.Driver</Set> > <Set name="url">jdbc:postgres://172.20.0.11:5432/satagro > <https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2F172.20.0.11%3A5432%2Fsatagro&data=05%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C27986e1c2b874ae2da7008da90daa943%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637981567866547011%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=dF0wSkBD0r9PbL19q89%2FUM2WMe%2FnvFupNSbwJc91JRo%3D&reserved=0> > </Set> > <Set name="username">satagro</Set> > <Set name="password"></Set> > <Set name="maxActive">200</Set> > <Set name="maxIdle">8</Set> > <Set name="minIdle">0</Set> > <Set name="maxWait">10000</Set> > <Set name="minEvictableIdleTimeMillis">60000</Set> > <Set name="timeBetweenEvictionRunsMillis">30000</Set> > <Set name="numTestsPerEvictionRun">20</Set> > <Set name="poolPreparedStatements">true</Set> > <Set name="maxOpenPreparedStatements">100</Set> > <Set name="testOnBorrow">true</Set> > <Set name="validationQuery">SELECT SYSDATE FROM DUAL</Set> > <Set name="accessToUnderlyingConnectionAllowed">true</Set> > </New> > </Arg> > </New> > <New class="org.eclipse.jetty.plus.jndi.Resource"> > <Arg>java:comp/env/jdbc/indexes</Arg> > <Arg> > <New class="org.apache.commons.dbcp.BasicDataSource"> > <Set name="driverClassName">org.postgresql.Driver</Set> > <Set name="url">jdbc:postgres:// > 172.20.0.11:5432/satagro_indexes > <https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2F172.20.0.11%3A5432%2Fsatagro_indexes&data=05%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C27986e1c2b874ae2da7008da90daa943%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637981567866547011%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=IjQiYe33%2Fz%2FxQv8pGCGoAGYrdTn%2FbCsS%2BNao6lAHYws%3D&reserved=0> > </Set> > <Set name="username">satagro</Set> > <Set name="password"></Set> > <Set name="maxActive">200</Set> > <Set name="maxIdle">8</Set> > <Set name="minIdle">0</Set> > <Set name="maxWait">10000</Set> > <Set name="minEvictableIdleTimeMillis">60000</Set> > <Set name="timeBetweenEvictionRunsMillis">30000</Set> > <Set name="numTestsPerEvictionRun">20</Set> > <Set name="poolPreparedStatements">true</Set> > <Set name="maxOpenPreparedStatements">100</Set> > <Set name="testOnBorrow">true</Set> > <Set name="validationQuery">SELECT SYSDATE FROM DUAL</Set> > <Set name="accessToUnderlyingConnectionAllowed">true</Set> > </New> > </Arg> > </New> > </Configure> > > > > -- > > Micho Garcia > > geomatico.es > <https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgeomatico.es%2F&data=05%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C27986e1c2b874ae2da7008da90daa943%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637981567866547011%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=Fxl80ru%2Bvr041noKWm3nt%2FP6NwvU1Jm13IahHSV5zyA%3D&reserved=0> > > > > *Política de Protección de Datos de Carácter Personal Responsable: > GEOMATICO, S. COOP. GALEGA CIF: F-27875327 Teléfono de contacto: 623 066 > 080 Correo electrónico: i...@geomatico.es <i...@geomatico.es> Dirección > postal: C/ Pi y Margall, 60, entlo. ofic-2, 6202, Vigo, Pontevedra. Los > datos de carácter personal contenidos en el presente y futuros correos > electrónicos quedarán incorporados en nuestro Registro interno de > actividades de tratamiento, con la finalidad de poder llevar a cabo una > adecuada gestión de las comunicaciones (envíos, respuestas y reenvíos), así > como para mantenerle informado de mis novedades comerciales y distintas > ofertas promocionales. Los datos proporcionados se conservarán mientras se > mantenga la relación comercial. Asimismo, los datos no serán cedidos a > terceros salvo en aquellos casos en que exista una obligación legal. Tiene > derecho a conocer en mayor detalle nuestra política de privacidad, acceder > a sus datos personales, rectificar los datos inexactos, solicitar su > supresión, limitar alguno de los tratamientos u oponerse a algún uso (por > ej. oponerse posteriormente al envío de publicidad, si fuera el caso), vía > e-mail, personalmente o mediante correo postal.* > > ------------------------------ > > CONFIDENTIALITY NOTICE AND DISCLAIMER > The information in this transmission may be confidential and/or protected > by legal professional privilege, and is intended only for the person or > persons to whom it is addressed. If you are not such a person, you are > warned that any disclosure, copying or dissemination of the information is > unauthorised. If you have received the transmission in error, please > immediately contact this office by telephone, fax or email, to inform us of > the error and to enable arrangements to be made for the destruction of the > transmission, or its return at our cost. No liability is accepted for any > unauthorised use of the information contained in this transmission. > -- Micho Garcia geomatico.es *Política de Protección de Datos de Carácter Personal **Responsable: GEOMATICO, S. COOP. GALEGA **CIF: F-27875327 **Teléfono de contacto: 623 066 080 **Correo electrónico: i...@geomatico.es <i...@geomatico.es> **Dirección postal: C/ Pi y Margall, 60, entlo. ofic-2, 6202, Vigo, Pontevedra. **Los datos de carácter personal contenidos en el presente y futuros correos electrónicos quedarán incorporados en nuestro Registro interno de actividades de tratamiento, con la finalidad de poder llevar a cabo una adecuada gestión de las comunicaciones (envíos, respuestas y reenvíos), así como para mantenerle informado de mis novedades comerciales y distintas ofertas promocionales. Los datos proporcionados se conservarán mientras se mantenga la relación comercial. **Asimismo, los datos no serán cedidos a terceros salvo en aquellos casos en que exista una obligación legal. **Tiene derecho a conocer en mayor detalle nuestra política de privacidad, acceder a sus datos personales, rectificar los datos inexactos, solicitar su supresión, limitar alguno de los tratamientos u oponerse a algún uso (por ej. oponerse posteriormente al envío de publicidad, si fuera el caso), vía e-mail, personalmente o mediante correo postal.*
_______________________________________________ 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
