search

pgRouting / osm2pgrouting

Import tool for OpenStreetMap data to pgRouting database
https://pgrouting.org
GNU General Public License v2.0
291 stars 111 forks source link

Issue with data import: fe_sendauth: no password supplied #283

Closed giswhiz closed 4 years ago

giswhiz commented 4 years ago

Hello! I am trying to start osm2pgrouting by loading osm data into it, but I get the following error message:

osm2pgrouting --f your-OSM-XML-File.osm --conf mapconfig.xml --dbname routing --username postgres --clean

Execution starts at: Tue Jul 14 15:40:48 2020 ` COMMAND LINE CONFIGURATION * Filename = your-OSM-XML-File.osm Configuration file = mapconfig.xml host = localhost port = 5432 dbname = routing username = postgres schema= prefix = suffix = Drop tables Don't create indexes Don't add OSM nodes

Testing database connection: routing fe_sendauth: no password supplied ` This is postgres issue apparently, how could I supply it with password?

cayetanobv commented 4 years ago

Hi @curiousaboutgis . You need to add -W argument with your password.

giswhiz commented 4 years ago

Hi @curiousaboutgis . You need to add -W argument with your password.

Omg thanks God, it worked. I mean I tried before, but my password for postgres contained symbols like !,1234, and it was written as !,1234, event not recognized. I had to change my password by choosing just letter symbols and it worked! But now it worked thanks god!

giswhiz commented 4 years ago

the whole command should look like: osm2pgrouting --f your-OSM-XML-File.osm --conf mapconfig.xml --dbname routing --username postgres -W yourpassword --clean