[mapserver-users] MapServer logs

[P Kishor]

On 4/18/08, Daniel Morissette <dmorissette at mapgears.com> wrote:
> P Kishor wrote:
>
> >
> > I want MapServer to write every call that it makes to the database via
> > OGR. So, I added the following line to my map file
> >  WEB
> > ..
> >    LOG "/Users/punkish/Sites/sqlitegis/tmp/ms.log"
> >  END
> >
> >
>
>  IIRC, LOG only logs some info on the mapserv request status at the end of
> its execution. I don't use it much and don't know much about it.
>
>  To get debugging output, with MapServer 5.0+, set:
>
>   CONFIG "MS_ERRORFILE"
> "/Users/punkish/Sites/sqlitegis/tmp/ms.log"
>
>  ... and then set DEBUG level (ON, or number between 1 and 5) at the
> top-level in the mapfile and in each layer for which you want debugging
> output.
>

Very nice.

tail tmp/ms.log shows me

[Fri Apr 18 08:46:54 2008].505608
msOGRLayerClose(/Users/punkish/Data/sqlitegis/wi.db).
[Fri Apr 18 08:46:54 2008].505626
msOGRFileClose(/Users/punkish/Data/sqlitegis/wi.db,-1).
[Fri Apr 18 08:46:54 2008].505647
msConnPoolRelease(sg_zip,/Users/punkish/Data/sqlitegis/wi.db,0x1126de0)
[Fri Apr 18 08:46:54 2008].505654
msConnPoolClose(/Users/punkish/Data/sqlitegis/wi.db,0x1126de0)
[Fri Apr 18 08:46:54 2008].506741 msDrawMap(): Layer 0 (sg_zip), 0.257s
[Fri Apr 18 08:46:54 2008].216458
msOGRFileOpen(/Users/punkish/Data/sqlitegis/wi.db)...
[Fri Apr 18 08:46:54 2008].228475 OGROPen(/Users/punkish/Data/sqlitegis/wi.db)
[Fri Apr 18 08:46:54 2008].231712
msConnPoolRegister(sg_zip,/Users/punkish/Data/sqlitegis/wi.db,0x1126de0)

Unfortunately, it doesn't log the actual SQL calls being made to the
db. Perhaps that is an OGR logging issue. So, the next step is to find
a way to log that.

>  More details are available in RFC-28:
>
>   http://mapserver.gis.umn.edu/development/rfc/ms-rfc-28
>
>  Daniel
>  --
>  Daniel Morissette
>  http://www.mapgears.com/