[mapserver-users] Question about oracle spatial configuration change

[Alan Boudreault]

Normally, you shouldn't have to change anything else. Have you tried to 
connect to the DB with your new user from the oracle sqlplus and did a "select 
* from <your_table_name>" ? 

Thanks,
Alan

On July 14, 2010 08:07:05 am David Alda Fernandez de Lezea wrote:
> Hi list,
> 
> We were working with mapserver 5.6.1 and oracle spatial, and we have change
>  the user (the new one has less privileges - it cannot modify anything
>  stored in the DB) that connects to oracle spatial, and now we cannot
>  connect to the layers stored in oracle. We get the following message:
> 
> [Wed Jul 14 14:01:29 2010].755000 CGI Request 1 on process 2648
> [Wed Jul 14 14:01:30 2010].380000 msOracleSpatialLayerGetItems(): Query
>  error. Cannot retrieve column list [Wed Jul 14 14:01:30 2010].380000
>  msDrawMap(): Image handling error. Failed to draw layer named
>  'provincias'. [Wed Jul 14 14:01:30 2010].380000 mapserv request processing
>  time (msLoadMap not incl.): 0.625s [Wed Jul 14 14:01:30 2010].380000
>  msFreeMap(): freeing map at 019AB590. [Wed Jul 14 14:01:32 2010].520000
>  CGI Request 1 on process 1924
> [Wed Jul 14 14:01:32 2010].661000 msOracleSpatialLayerGetItems(): Query
>  error. Cannot retrieve column list [Wed Jul 14 14:01:32 2010].661000
>  msDrawMap(): Image handling error. Failed to draw layer named
>  'provincias'. [Wed Jul 14 14:01:32 2010].661000 mapserv request processing
>  time (msLoadMap not incl.): 0.141s [Wed Jul 14 14:01:32 2010].661000
>  msFreeMap(): freeing map at 019AB590. [Wed Jul 14 14:01:33 2010].36000 CGI
>  Request 1 on process 2408
> [Wed Jul 14 14:01:33 2010].161000 msOracleSpatialLayerGetItems(): Query
>  error. Cannot retrieve column list [Wed Jul 14 14:01:33 2010].161000
>  msDrawMap(): Image handling error. Failed to draw layer named
>  'provincias'. [Wed Jul 14 14:01:33 2010].161000 mapserv request processing
>  time (msLoadMap not incl.): 0.125s [Wed Jul 14 14:01:33 2010].161000
>  msFreeMap(): freeing map at 019AB590. [Wed Jul 14 14:01:33 2010].505000
>  CGI Request 1 on process 2064
> [Wed Jul 14 14:01:33 2010].677000 msOracleSpatialLayerGetItems(): Query
>  error. Cannot retrieve column list [Wed Jul 14 14:01:33 2010].677000
>  msDrawMap(): Image handling error. Failed to draw layer named
>  'provincias'. [Wed Jul 14 14:01:33 2010].677000 mapserv request processing
>  time (msLoadMap not incl.): 0.172s [Wed Jul 14 14:01:33 2010].677000
>  msFreeMap(): freeing map at 019AB590. [Wed Jul 14 14:01:33 2010].989000
>  CGI Request 1 on process 3216
> [Wed Jul 14 14:01:34 2010].130000 msOracleSpatialLayerGetItems(): Query
>  error. Cannot retrieve column list [Wed Jul 14 14:01:34 2010].130000
>  msDrawMap(): Image handling error. Failed to draw layer named
>  'provincias'. [Wed Jul 14 14:01:34 2010].130000 mapserv request processing
>  time (msLoadMap not incl.): 0.141s [Wed Jul 14 14:01:34 2010].130000
>  msFreeMap(): freeing map at 019AB590.
> 
> Do we have to refresh something or do somethign else?
> 
> Layer config:
> 
> CONNECTIONTYPE oraclespatial
> CONNECTION "newuser/newpass at ORA10GEX"
> 
> If configure the layer with the old user, it works.
> 
> Thanks.
> 
> Un saludo,
> 
> ···········································································
> ·······
> 
> David Alda Fernández de Lezea
> Lurralde eta Biodibertsitate Saila / Dpto. de Territorio y Biodiversidad
> 
> IKT
> Granja Modelo s/n · 01192 · Arkaute (Araba)
> 
> ···········································································
> ······· Tlfnos.: 945-00-32-95                         Fax: 945-00.32.90
> ···········································································
> ······· email: dalda at ikt.es                                web: www.ikt.es
>  ··········································································
> ········ _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 

-- 
Alan Boudreault
Mapgears
http://www.mapgears.com