[Dcmms-devel] Re: IIS + Permission Problem with dcmms

[<Ste...@do...>]

Piero,

I hope it's ok that I copy this mail to the dcmms-devel-list.
It's great news that DCMMS is also working with IIS and I would
like to share it with the other developers.

The error messages you're getting seem to be a PostgreSQL problem
only. Could you try a

grant all on administrativearea to group dcmmuser;

and/or 

grant all on administrativearea to dcmms;

in psql or pgAdmin or whatever tool you use to feed SQL
to your dcmms database? You should also check that the PostgreSQL user
dcmms is part of the PostgreSQL dcmmsuser group.

Steffen





Piero Cavalieri <pie...@he...>
02.11.2004 19:38
 
        To:     Steffen Macke <Ste...@do...>
        cc: 
        Subject:        IIS + Permission Problem with dcmms


Hi Steffen, I tested the application on Windows  + Apache. It was ok (at 
least for what I tested),
but my boss want to use IIS.
With IIS, when I log to the app. as admin user it seems to be ok, but if 
I log as dcmms user then:

- with the "Map" link I have the following error:
    PHP Warning: pg_query(): Query failed: ERROR: permission denied for 
relation administrativearea     in C:\Programmi\DCMMS\map.php on line 521
  (but I can see the map and query It)

- with the "Zoom" link I have:
    Warning: pg_exec(): Query failed: ERROR: permission denied for 
relation administrativearea in *    *C:\Programmi\DCMMS\zoom.php on line 
55*

*At the moment I don't have idea on how to solve this. Do you know 
something for this ?

Thanks,
       Piero

--
Il contenuto di questo messaggio e' confidenziale e la lettura non
autorizzata dello stesso viola i diritti di privacy del mittente e del
destinatario.

Se avete ricevuto questo messaggio per errore siete pregati di
rimuoverlo dal Vostro sistema.