[pgrouting-users] Problem when running osm2pgrouting

[maruf rahman]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20130221/2b0b82cf/attachment-0001.html>