[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