Re: [Geoserver-users] OpenLayers with App-Schemas

2013-09-05 Thread Christy Caudill 
See email below:

Ben -

We got things to work by adjusting the Host header on the proxy server (nginx 
in this case), but before doing that we were seeing 127.0.0.1 addresses in the 
GetCapabilities and OpenLayers previews even though we had set the Geoserver 
proxy base url. We're using 2.3, so I'm curious why we seemed to be having the 
same issue that was solved at 2.1.x in that bug report you mentioned?

Just for the record, here's the nginx config snippet that we're using now (that 
works). Previously we weren't setting the Host header:

# By default, traffic is sent to Tomcat
location / {
proxy_pass http://127.0.0.1:8080;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $remote_addr;
proxy_set_header Host $http_host;
}

Thanks!
Ryan


From: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] On Behalf Of Andrea 
Aime
Sent: Thursday, September 05, 2013 10:07 AM
To: Christy Caudill
Cc: GeoServer Mailing List List
Subject: Re: [Geoserver-users] OpenLayers with App-Schemas

On Thu, Sep 5, 2013 at 6:50 PM, christy@azgs 
christy.caud...@azgs.az.govmailto:christy.caud...@azgs.az.gov wrote:
Okay, so you can see that the OnlineResource in the GetCapabilities still
references 127.0.0.1

http://data.usgin.org/azgs_bedrock_geology/gsmlp/wms?service=WMSversion=1.3.0request=GetCapabilities

Do you have caching issues? The online resources point to the host you 
configured for me?
The OpenLayers preview works fine as well

Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it 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

---
--
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58041391iu=/4140/ostg.clktrk___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] App Schema Resolution

2013-03-26 Thread Christy Caudill 
Hello Ben,

Please see the attached DDL for the table. As you can see, the objected is 
never null, and isn't shouldn't be big - it is numbered 1 - 1949.

Thank you,
Christy 

-Original Message-
From: Ben Caradoc-Davies [mailto:ben.caradoc-dav...@csiro.au] 
Sent: Sunday, March 17, 2013 10:14 PM
To: christy@azgs
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] App Schema Resolution

Christy,

this is rather odd. Even if the argument is not a string (and by #1 it means 
the second argument), the first thing strConcat tries to do is to convert it to 
a string. The only thing that I can think of that might cause this to fail is 
that the type is some big integer that it cannot handle, or null. Ordinary 
integers should be converted.

Can we please see the DDL for the source table?

Is objectid ever null?

select count(1) from yourtablename where objectid is null;

Kind regards,
Ben.


On 15/03/13 04:09, christy@azgs wrote:
 We have achieved schema resolution!  That is, as long as we use the 
 getId() idExpression. However, because we'd like to use our integer 
 field 'objectid', we need to figure out how to concatenate an integer 
 with that field OR make that read as a string. We tried the following, 
 but we get that
 java.lang.IllegalArgumentException: Filter Function problem for 
 function strConcat argument #1 - expected type String error:

  
 idExpression

 OCQLstrConcat('BT', objectid)/OCQL
  
 /idExpression

 And we also tried:
   idExpression
   
 OCQLstrConcat('BT', strTrim(objectid))/OCQL
   /idExpression

 Resulting in the same error.  Thanks to anyone with ideas.



 --
 View this message in context: 
 http://osgeo-org.1560.n6.nabble.com/Re-App-Schema-Resolution-tp5040030
 p5040472.html Sent from the GeoServer - User mailing list archive at 
 Nabble.com.

 --
  Everyone hates slow websites. So do we.
 Make your web apps faster with AppDynamics Download AppDynamics Lite 
 for free today:
 http://p.sf.net/sfu/appdyn_d2d_mar
 ___
 Geoserver-users mailing list
 Geoserver-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/geoserver-users


--
Ben Caradoc-Davies ben.caradoc-dav...@csiro.au Software Engineer CSIRO Earth 
Science and Resource Engineering Australian Resources Research Centre
?xml version=1.0 encoding=UTF-8?

report

  header
generatedMon 18 Mar 2013 08:06:30 AM MST/generated
serverkyanite (kyanite:5432)/server
databaseazgs/database
schemasde/schema
titleTable DDL report - azboreholetemperatures/title
  /header

  section id=s1 number=1 name=Table DDL
table
  columns
  /columns
  rows
  /rows
/table
sql-- Table: azboreholetemperatures

-- DROP TABLE azboreholetemperatures;

CREATE TABLE azboreholetemperatures
(
  objectid integer NOT NULL,
  observationuri character varying(255),
  wellname character varying(255),
  apino character varying(255),
  headeruri character varying(255),
  otherid character varying(255),
  othername character varying(255),
  boreholename character varying(255),
  label character varying(255),
  operator character varying(255),
  leasename character varying(255),
  leaseowner character varying(255),
  leaseno character varying(255),
  spuddate timestamp without time zone,
  endeddrillingdate timestamp without time zone,
  welltype character varying(255),
  status character varying(255),
  commodityofinterest character varying(255),
  statusdate timestamp without time zone,
  function_ character varying(255),
  production character varying(255),
  producinginterval character varying(255),
  releasedate timestamp without time zone,
  field character varying(255),
  otherlocationname character varying(255),
  county character varying(255),
  state character varying(255),
  plss_meridians character varying(255),
  twp character varying(255),
  rge character varying(255),
  section_ numeric(38,8),
  sectionpart character varying(255),
  parcel character varying(255),
  utm_e numeric(38,8),
  utm_n numeric(38,8),
  utmdatumzone character varying(255),
  latdegree numeric(38,8),
  longdegree numeric(38,8),
  srs character varying(255),
  locationuncertaintystatement text,
  locationuncertaintycode character varying(255),
  locationuncertaintyradius numeric(38,8),
  drillertotaldepth numeric(38,8),
  depthreferencepoint character varying(255),
  lengthunits character varying(255),
  wellboreshape character varying(255),
  trueverticaldepth numeric(38,8),
  elevationkb numeric(38,8),
  elevationdf numeric(38,8),
  elevationgl numeric(38,8),
  formationtd character varying(255),
  bitdiametercollar