Hi, I recently upgraded the ports on my FreeBSD VPS for GeoServer, PostgreSQL and PostGIS. Well, I upgraded the ports for *everything*, actually.
Anyway, upon everything upgrading, I now have a problem with GeoServer being able to connect to the PSQL datastores. I've appended the output of tail -f to the GS log when I try to preview the following layer from a PSQL datastore: http://gulfcoaststrategicservices.com:8080/geoserver/SocialContxt/wms?service=WMS&version=1.1.0&request=GetMap&layers=SocialContxt:afghanistan_centroids&styles=&bbox=62.066,30.818,73.342,36.966&width=605&height=330&srs=EPSG:4326&format=application/openlayers I know that the database exists, obviously: [dheerajchand@dirty /usr/local/geoserver/data_dir/logs]$ psql psql (8.4.9, server 8.4.6) Type "help" for help. dheerajchand=# \l List of databases Name | Owner | Encoding | Collation | Ctype | Access privileges -----------------+--------------+-----------+-----------+-------+------------------- afghanistan | dheerajchand | SQL_ASCII | C | C | congress | dheerajchand | SQL_ASCII | C | C | dheerajchand | dheerajchand | SQL_ASCII | C | C | jamaa | dheerajchand | SQL_ASCII | C | C | lackey | dheerajchand | SQL_ASCII | C | C | pgsql | pgsql | SQL_ASCII | C | C | polling_places | dheerajchand | SQL_ASCII | C | C | popeyes | gis | SQL_ASCII | C | C | postgistemplate | pgsql | SQL_ASCII | C | C | postgres | pgsql | SQL_ASCII | C | C | spamandeggs | dheerajchand | SQL_ASCII | C | C | template0 | pgsql | SQL_ASCII | C | C | =c/pgsql : pgsql=CTc/pgsql template1 | pgsql | SQL_ASCII | C | C | =c/pgsql : pgsql=CTc/pgsql (13 rows) dheerajchand=# \c afghanistan psql (8.4.9, server 8.4.6) You are now connected to database "afghanistan". afghanistan=# ls afghanistan-# ; ERROR: syntax error at or near "ls" LINE 1: ls ^ afghanistan=# \d afghanistan Did not find any relation named "afghanistan". afghanistan=# \d afghanistan_ afghanistan_34_provinces afghanistan_34_provinces_pkey afghanistan_34_provinces_gid_seq afghanistan_centroids afghanistan=# \d afghanistan_ afghanistan_34_provinces afghanistan_34_provinces_pkey afghanistan_34_provinces_gid_seq afghanistan_centroids afghanistan=# \d afghanistan_centroids; View "public.afghanistan_centroids" Column | Type | Modifiers ------------+-----------------------+----------- gid | integer | e | double precision | shape_area | double precision | prov_34_na | character varying(80) | hectares | double precision | pc_plann_0 | double precision | pc_final_0 | double precision | pl_10_op_0 | double precision | candi_05_1 | double precision | n2010_male | double precision | n2010_fema | double precision | tot_votes_ | double precision | votes_inva | double precision | est_litera | double precision | est_popula | double precision | the_geom | geometry | longitude | double precision | latitude | double precision | View definition: SELECT afghanistan_34_provinces.gid, afghanistan_34_provinces.e, afghanistan_34_provinces.shape_area, afghanistan_34_provinces.prov_34_na, afghanistan_34_provinces.hectares, afghanistan_34_provinces.pc_plann_0, afghanistan_34_provinces.pc_final_0, afghanistan_34_provinces.pl_10_op_0, afghanistan_34_provinces.candi_05_1, afghanistan_34_provinces.n2010_male, afghanistan_34_provinces.n2010_fema, afghanistan_34_provinces.tot_votes_, afghanistan_34_provinces.votes_inva, afghanistan_34_provinces.est_litera, afghanistan_34_provinces.est_popula, afghanistan_34_provinces.centroid AS the_geom, st_x(afghanistan_34_provinces.centroid) AS longitude, st_y(afghanistan_34_provinces.centroid) AS latitude FROM afghanistan_34_provinces; afghanistan=# Any suggestions? -dx 2011-11-24 07:58:50,046 INFO [geoserver.wms] - Request: getServiceInfo 2011-11-24 07:58:50,047 ERROR [geoserver.ows] - java.lang.NullPointerException at org.geoserver.wms.map.GetMapKvpRequestReader.getDefaultStyle(GetMapKvpRequestReader.java:433) at org.geoserver.wms.map.GetMapKvpRequestReader.read(GetMapKvpRequestReader.java:342) at org.geoserver.wms.map.GetMapKvpRequestReader.read(GetMapKvpRequestReader.java:74) at org.geoserver.ows.Dispatcher.parseRequestKVP(Dispatcher.java:1157) at org.geoserver.ows.Dispatcher.dispatch(Dispatcher.java:488) at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:231) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093) at org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:23) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:74) at org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:45) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:49) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:394) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:185) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:71) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at org.geoserver.filters.SessionDebugFilter.doFilter(SessionDebugFilter.java:46) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:324) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:828) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:514) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450) ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
