[UMN_MAPSERVER-USERS] OGR Connection to MySQL

[Christian Braun]

Hey List,

I want to establish a connection between mapserver (pmapper client) and a
MySQL-DB.
It works fine with smaller queries like "select id,x,y from table". Actually
i don't have a problem with such little things.
If the queries getting more complex I get the results only in the Terminal
window with ogrinfo.
Such a query is
"SELECT ALL
       MG.MC_Name_col AS MCName,
       M1.`AttribValueNum_col` AS x,
       M2.`AttribValueNum_col` AS y
  FROM MeasCampGlobal_tbl MG, MeasCampAttrib_tbl M1
         LEFT OUTER JOIN IdRefStr_tbl I1
           ON M1.AttribType_id=I1.id,
       MeasCampAttrib_tbl M2
         LEFT OUTER JOIN IdRefStr_tbl I2
           ON M2.AttribType_id=I2.id
  WHERE M1.MeasCampGlobal_tbl_id=MG.idMeasCampGlobal_tbl
    AND M2.MeasCampGlobal_tbl_id=MG.idMeasCampGlobal_tbl
    AND MC_WWTPRef_col = 'Bleesbrück'
    AND I1.RefStr_col = 'Att_WWTP_CoordX'
    AND I2.RefStr_col = 'Att_WWTP_CoordY'"
As I said only results are displayed in the Terminal with the ogrinfo tool.
Mapserver hangs up.

Any Ideas???

System is Ubuntu Edgy, Mapserver 4.10, GDAL 1.4

Thanks in advance,
Christian