[mapserver-users] Question about oracle spatial configuration change [SOLVED]

[David Alda Fernandez de Lezea]

Alan,

Thanks for you response. It seems that there was a problem with user created. Something was wrong. Now it's fixed. Thanks.

Regards.
 
 
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
··················································································

-----Mensaje original-----
De: Alan Boudreault [mailto:aboudreault at mapgears.com] 
Enviado el: miércoles, 14 de julio de 2010 15:57
Para: mapserver-users at lists.osgeo.org
CC: David Alda Fernandez de Lezea
Asunto: Re: [mapserver-users] Question about oracle spatial configuration change

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