Hi Maruf,<div><br></div><div>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).</div><div>Also OSGeo Live has a an admin user named "user", so this might not work for you either.</div>
<div><br></div><div>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.</div><div><br></div>
<div>Daniel</div><div><br></div><div><br></div><div><br><br><div class="gmail_quote">On Fri, Feb 22, 2013 at 12:59 AM, maruf rahman <span dir="ltr"><<a href="mailto:maruf.csdu@gmail.com" target="_blank">maruf.csdu@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div>Hi Daniel,<br></div>I have run the script using <b>bash ./install_pgrouting.sh<br></b></div>
Please check a part of output <a href="http://paste.ubuntu.com/1699747/" target="_blank">here</a>. Its missing sample data and there are some database issue.<br>
<br></div><div>Thanks<span class="HOEnZb"><font color="#888888"><br></font></span></div><span class="HOEnZb"><font color="#888888">Maruf</font></span><div><div class="h5"><br><div><div class="gmail_extra"><br><br><div class="gmail_quote">
On Thu, Feb 21, 2013 at 9:46 PM, Daniel Kastl <span dir="ltr"><<a href="mailto:daniel@georepublic.de" target="_blank">daniel@georepublic.de</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Maruf,<div><br></div><div>Looking at the Gist, there is no need anymore to compile PostGIS 2.0, because it already has packages in the UbuntuGIS unstable repository.</div>
<div>It furthermore installs pgRouting as packages as well as osm2pgrouting, which is good.</div>
<div><br></div><div>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".</div>
<div>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:</div><div><a href="http://trac.osgeo.org/osgeo/browser/livedvd/gisvm/branches/osgeolive_6_5/bin/install_pgrouting.sh" target="_blank">http://trac.osgeo.org/osgeo/browser/livedvd/gisvm/branches/osgeolive_6_5/bin/install_pgrouting.sh</a></div>
<div><br></div><div>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).</div>
<div>And the hack for osm2pgrouting is from line #138. </div><span><font color="#888888"><div><br></div></font></span><div><span><font color="#888888">Daniel</font></span><div><div>
<br><br><div class="gmail_quote">On Fri, Feb 22, 2013 at 12:31 AM, maruf rahman <span dir="ltr"><<a href="mailto:maruf.csdu@gmail.com" target="_blank">maruf.csdu@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>OS: Ubuntu 12.04<br></div><div>I have installed pgrouting dependencies using this url <a href="https://gist.github.com/djq/2846196" target="_blank">https://gist.github.com/djq/2846196</a><br>
</div><div>
and pgrouting using this tutorial <a href="http://pgrouting.org/docs/1.x/install.html" target="_blank">http://pgrouting.org/docs/1.x/install.html</a><br>
</div><div>and didn't use LiveDVD.<br></div><div><br></div><div>Please let me know if any more info is needed.<span><font color="#888888"><br></font></span></div><span><font color="#888888"><div class="gmail_extra">
<br></div><div class="gmail_extra">Maruf<br></div></font></span><div><div><div class="gmail_extra">
<br><div class="gmail_quote">On Thu, Feb 21, 2013 at 8:59 PM, Daniel Kastl <span dir="ltr"><<a href="mailto:daniel@georepublic.de" target="_blank">daniel@georepublic.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi Maruf,<div><br></div><div>Can you provide more information?</div><div>Like which OS you use, how you installed pgRouting, etc..</div><div>Do you use the OSGeo LiveDVD?</div><div><br></div><div>Daniel</div><div><br><br>
<div class="gmail_quote"><div><div>
On Thu, Feb 21, 2013 at 11:38 PM, maruf rahman <span dir="ltr"><<a href="mailto:maruf.csdu@gmail.com" target="_blank">maruf.csdu@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div>
<div dir="ltr"><div><div>Hi<br></div>I am trying to use pgrouting following this <a href="http://workshop.pgrouting.org/index.html" target="_blank">tutorial</a>. Currently I am in section<a href="http://workshop.pgrouting.org/chapters/osm2pgrouting.html" target="_blank"> 4.2</a>. However when I try to execute the command of section 4.2, it only creates 3 tables name <i>classes, nodes</i> and <i>types</i>. But the document says, it should create 8 tables.<br>
<br></div>Where is the problem? How can I solve this?<br><div><br><br clear="all"><div><div>Thanks<span><font color="#888888"><br>Maruf</font></span></div></div></div></div>
<br></div></div>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br></blockquote></div><span><font color="#888888"><br><br clear="all"><div><br></div>-- <br><span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>
eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66,99,171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a href="http://georepublic.de/" style="color:rgb(66,99,171)" target="_blank">http://georepublic.de</a></span>
</font></span></div>
<br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a></blockquote></div></div></div></div></div>
<br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66,99,171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a href="http://georepublic.de/" style="color:rgb(66,99,171)" target="_blank">http://georepublic.de</a></span>
</div></div></div>
<br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br></blockquote></div><br></div></div></div></div></div>
<br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66,99,171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a href="http://georepublic.de/" style="color:rgb(66,99,171)" target="_blank">http://georepublic.de</a></span>
</div>