Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
Isaac Boates
@iboates
there it is
ok, thank you
i will finish up the last things i want on this commit and then i will begin migrating it
Vicky Vergara
@cvvergara
ok, I will be here
are you subscribed to pgRouting-dev list?
Isaac Boates
@iboates
Hi Vicky
I am not
also, I need to have permission to create repositories in order to transfer the repository to the pgRouting organisation
Vicky Vergara
@cvvergara
@dkastl do you know how to do that?
Vicky Vergara
@cvvergara
Vicky Vergara
@cvvergara
@iboates trying to contact @dkastl again
Vicky Vergara
@cvvergara
@iboates dont forget to subscribe to pgrouting-dev & pgRouting-user list
Daniel Kastl
@dkastl
@iboates thanks for contributing to pgRouting! That's very much appreciated!
I just found a setting in Github to allow members of the organization to create repositories, so I enabled it.
You are already osm2pgrouting member, so could you try, if it works?
Isaac Boates
@iboates
all done
and you're welcome, thanks for the invitation
now i finally have a valid reason to put my pgrouting sticker on my laptop :)
Vicky Vergara
@cvvergara
Welcome :)
Debashish Nanda
@debashishnanda
hello mentors
Vicky Vergara
@cvvergara
Hello, if you are appliying please go to https://gitter.im/pgRouting/pgrouting
Debashish Nanda
@debashishnanda
ok
Tobias Werner
@Tobias-Werner
Hi! I have a question about processing multiple OSM files. I want to split up large areas in multiple smaller files which i want to import separately for building a topology. Does osm2pgrouting take into account already imported topology? My intention is to build a topology of germany by importing the states sequentially. I read the docs that if the --clean paramter is missing the new imported data will be appended to the existing data - but will the existing topology be considered?
Daniel Kastl
@dkastl
@Tobias-Werner , yes, this should work as expected. When you do not use the --clean flag, then missing data will be apppended.
Tobias Werner
@Tobias-Werner
@dkastl thank you!
Sergii
@curiousaboutgis
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

What could be the problem?
Vicky Vergara
@cvvergara

@atene468

# work on the home folder
cd

# login to postgres
psql -U postgres

-- Create youruser
CREATE ROLE youruser SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN PASSWORD 'your_pass';

-- exit psql
\q

# Add the user to .pgpass
echo :5432:*:youruser:yourpass >> .pgpass

Then try with

osm2pgrouting --f your-OSM-XML-File.osm --conf mapconfig.xml --dbname routing \
     --username youruser \
     --clean
Sergii
@curiousaboutgis
error2.png
Thanks a lot for your quick answer. Unfortunately it doesnt work. Got the message like this
Vicky Vergara
@cvvergara
chmod 0600 ~/.pgpass
try again
Sergii
@curiousaboutgis
echo :5432:*routing:routing >> chmod 0600 ~/.pgpass
I did same and got the same error message.
Vicky Vergara
@cvvergara
I dont know you are using the same name everywhere
can you do createdb foo ?
Sergii
@curiousaboutgis
ok now I tried it with sudo, error about permission group/world access disappeared. but the problem stays same: fe_sendauth: no password supplied
oh ok, I will try
Vicky Vergara
@cvvergara
why sudo?
if you cant do createdb foo just like that without sudo is because you dont have in pgpass your name and password
Sergii
@curiousaboutgis
Thanks a lot for your instant answers! I tried it as you said: it still shows: fe_sendauth: no password supplied
Vicky Vergara
@cvvergara
that is postgres issue
why dont you google it and see what you find
Sergii
@curiousaboutgis
I have definitely searched about it a lot before landing here, but yes, will try to dig a bit more :)
Sergii
@curiousaboutgis
It finally worked. I added -W password. I mean I tried before, but my password for postgres contained symbols like !,1234, and the response was always: !,1234, event not recognized. I had to change my postgres password by choosing just letter symbols and it worked!
osm2pgrouting --f your-OSM-XML-File.osm --conf mapconfig.xml --dbname routing --username postgres -W yourpassword --clean
Vicky Vergara
@cvvergara
good you could solve it
gregorhuh
@gregorhuh
Hi there, would you have some guidance on how to install osm2pgrouting? I'm an absolute greenhorn when it comes to compiling from source code (which is what I believe I have to do?). I have postgresql (via pgAdmin 4), postgis and pgrouting. I also installed boost and he CMAKE gui from pre-compiled binaries (I think that's the the term). I have the git cmd application as well, but no idea how to go about the rest ... :-/ Any guidance would be much appreciated
gregorhuh
@gregorhuh
Also, I should say I'm on Windows 10 (whereas the main page says that "Currently osm2pgrouting is only tested on Linux distributions."). Can I use osm2pgrouting on windows?
Daniel Kastl
@dkastl
@gregorhuh , the majority of pgRouting developers does not work on Windows.
But you could try to use the Docker images of pgRouting. They also contain osm2pgrouting: https://hub.docker.com/r/pgrouting/pgrouting/
I haven't tested this on Windows, but it might work and you don't need to compile anything then.
gregorhuh
@gregorhuh
Great, thanks a million Daniel!