[pgrouting-users] Problem when running osm2pgrouting

Thu Feb 21 09:06:05 PST 2013

Hi Maruf,

Does you database have PostGIS installed?
Does PostGIS work?

It looks like some PostGIS stuff is missing.
Do you still have your self-compiled PostGIS from the Gist notes?

Daniel

On Fri, Feb 22, 2013 at 1:59 AM, maruf rahman <maruf.csdu at gmail.com> wrote:

> Hi Daniel,
> Everything is fine until adding pgrouting core functions. When i try to
> execute these two command
>
> *sudo -u $USER_NAME psql --quiet -f
> $PGROUTING_FOLDER/routing_core_wrappers.sql $OSM_DB
> sudo -u $USER_NAME psql --quiet -f $PGROUTING_FOLDER/routing_topology.sql
> $OSM_DB*
>
> it generates some error. Please see the output<http://paste.ubuntu.com/1700119/>
> .
> What is the solution?
>
>
> Thanks
> Maruf
>
>
> On Thu, Feb 21, 2013 at 10:04 PM, Daniel Kastl <daniel at georepublic.de>wrote:
>
>> Hi Maruf,
>>
>> You can't run this script just as it is, because it uses the same sample
>> data, that has been downloaded by the OSM install script before (different
>> script).
>> Also OSGeo Live has a an admin user named "user", so this might not work
>> for you either.
>>
>> So I would recommend you to just pick the commands you need and change
>> them where necessary. You can use your own OSM data for example, but you
>> probably need to adjust the path then.
>>
>> Daniel
>>
>>
>>
>>
>> On Fri, Feb 22, 2013 at 12:59 AM, maruf rahman <maruf.csdu at gmail.com>wrote:
>>
>>> Hi Daniel,
>>> I have run the script using *bash ./install_pgrouting.sh
>>> *
>>> Please check a part of output here <http://paste.ubuntu.com/1699747/>.
>>> Its missing sample data and there are some database issue.
>>>
>>> Thanks
>>> Maruf
>>>
>>>
>>>
>>> On Thu, Feb 21, 2013 at 9:46 PM, Daniel Kastl <daniel at georepublic.de>wrote:
>>>
>>>> Hi Maruf,
>>>>
>>>> Looking at the Gist, there is no need anymore to compile PostGIS 2.0,
>>>> because it already has packages in the UbuntuGIS unstable repository.
>>>> It furthermore installs pgRouting as packages as well as osm2pgrouting,
>>>> which is good.
>>>>
>>>> I don't know, why it doesn't work in your case and why you're missing
>>>> tables. Well, there is a t least one issue with osm2pgrouting when using
>>>> PostGIS 2.0, which requires some hack. And you may have to load
>>>> "legacy.sql".
>>>> Just a few days ago I updated the pgRouting installer for the new OSGeo
>>>> Live DVD and that it is working has been confirmed by several people:
>>>>
>>>> http://trac.osgeo.org/osgeo/browser/livedvd/gisvm/branches/osgeolive_6_5/bin/install_pgrouting.sh
>>>>
>>>> So maybe this OSGeo Live install script is more up-to-date. Because
>>>> pgRouting/osm2pgrouting still may have issues with PostGIS 2.0, you either
>>>> need to fix some wrapper SQL functions or load legacy.sql to your database
>>>> (see line #97).
>>>> And the hack for osm2pgrouting is from line #138.
>>>>
>>>> Daniel
>>>>
>>>>
>>>> On Fri, Feb 22, 2013 at 12:31 AM, maruf rahman <maruf.csdu at gmail.com>wrote:
>>>>
>>>>> OS: Ubuntu 12.04
>>>>> I have installed pgrouting dependencies using this url
>>>>> https://gist.github.com/djq/2846196
>>>>>  and pgrouting using this tutorial
>>>>> http://pgrouting.org/docs/1.x/install.html
>>>>> and didn't use LiveDVD.
>>>>>
>>>>> Please let me know if any more info is needed.
>>>>>
>>>>> Maruf
>>>>>
>>>>> On Thu, Feb 21, 2013 at 8:59 PM, Daniel Kastl <daniel at georepublic.de>wrote:
>>>>>
>>>>>> Hi Maruf,
>>>>>>
>>>>>> Can you provide more information?
>>>>>> Like which OS you use, how you installed pgRouting, etc..
>>>>>> Do you use the OSGeo LiveDVD?
>>>>>>
>>>>>> Daniel
>>>>>>
>>>>>>
>>>>>>  On Thu, Feb 21, 2013 at 11:38 PM, maruf rahman <maruf.csdu at gmail.com
>>>>>> > wrote:
>>>>>>
>>>>>>>  Hi
>>>>>>> I am trying to use pgrouting following this tutorial<http://workshop.pgrouting.org/index.html>.
>>>>>>> Currently I am in section 4.2<http://workshop.pgrouting.org/chapters/osm2pgrouting.html>.
>>>>>>> However when I try to execute the command of section 4.2, it only creates 3
>>>>>>> tables name *classes, nodes* and *types*. But the document says, it
>>>>>>> should create 8 tables.
>>>>>>>
>>>>>>> Where is the problem? How can I solve this?
>>>>>>>
>>>>>>>
>>>>>>> Thanks
>>>>>>> Maruf
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> Pgrouting-users mailing list
>>>>>>> Pgrouting-users at lists.osgeo.org
>>>>>>> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Georepublic UG & Georepublic Japan
>>>>>> eMail: daniel.kastl at georepublic.de
>>>>>> Web: http://georepublic.de
>>>>>>
>>>>>> _______________________________________________
>>>>>> Pgrouting-users mailing list
>>>>>> Pgrouting-users at lists.osgeo.org
>>>>>> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Pgrouting-users mailing list
>>>>> Pgrouting-users at lists.osgeo.org
>>>>> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Georepublic UG & Georepublic Japan
>>>> eMail: daniel.kastl at georepublic.de
>>>> Web: http://georepublic.de
>>>>
>>>> _______________________________________________
>>>> Pgrouting-users mailing list
>>>> Pgrouting-users at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>>>>
>>>>
>>>
>>> _______________________________________________
>>> Pgrouting-users mailing list
>>> Pgrouting-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>>>
>>>
>>
>>
>> --
>> Georepublic UG & Georepublic Japan
>> eMail: daniel.kastl at georepublic.de
>> Web: http://georepublic.de
>>
>> _______________________________________________
>> Pgrouting-users mailing list
>> Pgrouting-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>>
>>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>

-- 
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de
Web: http://georepublic.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20130222/2d86b7da/attachment.html>