[gdal-dev] Connect ogr2ogr without socket

Felipe Matas felipematas at yahoo.com
Wed Mar 23 12:36:09 PDT 2022


 Well, I was using bad the syntax, and if instead of localhost I use the numbers, works, at least half of it.., I'll check this more instead ask here first, to confirm here where to ask.
Thx :)
   El miércoles, 23 de marzo de 2022, 03:21:06 p. m. GMT-3, Felipe Matas via gdal-dev <gdal-dev at lists.osgeo.org> escribió:  
 
 Hi, I'm testing a new db that is dolt, is like git in db, literally, but that db does not support connection through socket, but the db is mysql, or like a simulation of it, I'm trying this to check the connection:
ogrinfo MySQL:"host=127.0.0.1 port=3306 user='root' password='' dbname='test'"

I try several syntax too, and the answer from the ogrinfo was similar to:

ERROR 1: MySQL connect failed for: host=127.0.0.1;port=3306;user='root';password=XXXXXXXXXXXXXXXXXXXXXXX connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)
ERROR 1: MySQL connect failed for: host=127.0.0.1;port=3306;user='root';password=XXXXXXXXXXXXXXXXXXXXXXX connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)
FAILURE:
Unable to open datasource `MySQL:host=127.0.0.1;port=3306;user='root';password='';dbname='water'' with the following drivers.
(here the very long list of drivers, MySQL is in the list.
ogr is trying to connect from a socket, and the db does not support it, the connection need to be TCP, how can I force the ogr to use TCP? (not just for local, for remote servers too, and ogr2ogr too)

Thx.
_______________________________________________
gdal-dev mailing list
gdal-dev at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20220323/b8be6a02/attachment.html>


More information about the gdal-dev mailing list