Hello,
I'm still struggling to connect mapscript to MySQL using OGR direct
connection here.
I've been logging mysql query to myslLOG.log.
The ogrinfo successfull connection from commandline:
[r...@server]# su -fm apache
bash: /root/.bashrc: Permission denied
[apa...@server]$ /usr/bin/ogrinfo base.ovf
ERROR 4: Update access not supported for VRT datasources.
Had to open data source read-only.
INFO: Open of `/home/infojawa/maps_data/jawa/base.ovf'
using driver `VRT' successful.
1: base
mysqlLOG.log says:
26 Connect r...@localhost on mapserver
26 Query SHOW KEYS FROM `base`
26 Field List base
now when I access the web,
*Warning*: [MapServer Error]: msOGRFileOpen(): Open failed for OGR
connection in layer `base'. Failed to open datasource
`MySQL:mapserver,user=xxxx,password=xxxx,tables=base'. in
*/home/infojawa/maps/jawa.inc.php* on line *552*
mysqlLOG.log doesn't say anytihing at all. Seems like mapscript/OGR
never did any connection to mysql server.
Does anyone ever find similar problem?Any idea will be highly appreciated
Thanks in advance
Junek
PS: I have rebuilt gdal/ogr again, --with-mysql=/usr/bin/mysql_config
--with-unixODBC-includes --with-unixODBC-libs
Frank Warmerdam wrote:
Juni Adi wrote:
Hi all,
I've just installed mapserver with php_mapscript enabled on my centos5 :
mapserver-5.2.1
Judi,
I don't know how mysql permissions work, but I'd suggest reviewing
whether
the apache account has permissions to access mysql. I don't see any
other
obvious reason things wouldn't work assuming the same libraries are being
used in both configurations.
Best regards,
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
