[pgrouting-users] Problem when running osm2pgrouting

[Daniel Kastl]

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