[OSM-dev] Osmosis error reading osm file and writing to mysql

Frederik Ramm frederik at remote.org
Sat Dec 6 21:10:52 GMT 2008


Hi,

Maarten Deen wrote:
> $ mysql -D osm -u osm
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
> 
> Welcome to the MySQL monitor.  Commands end with ; or \g.

[...]

> $ osmosis --read-xml file="bank.osm" --write-mysql
> java.net.ConnectException
> MESSAGE: Connection refused

Maybe your MySQL is configured to work only through a Unix domain 
socket, not opening a TCP port. They used to do that for a while 
(skip-networking option). Or maybe it is using a non-standard TCP port. Do

netstat -an|grep 3306

and check if you get a line similar to this:

tcp        0      0 127.0.0.1:3306          0.0.0.0:* 
LISTEN

If not then that's the reason for the problem you're seeing and you have 
to work on your my.cnf.

Bye
Frederik




More information about the dev mailing list