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: da...@ikt.es web: www.ikt.es ·················································································· -----Mensaje original----- De: Alan Boudreault [mailto:aboudrea...@mapgears.com] Enviado el: miércoles, 14 de julio de 2010 15:57 Para: mapserver-users@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/newp...@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: da...@ikt.es web: www.ikt.es > > ······································································ > ···· ········ _______________________________________________ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > -- Alan Boudreault Mapgears http://www.mapgears.com _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users