Hi Alex,<div><br><div class="gmail_quote">2010/7/28 Alex Mandel <span dir="ltr"><<a href="mailto:tech_dev@wildintellect.com">tech_dev@wildintellect.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
This is the revision the disc was built with<br>
<a href="http://trac.osgeo.org/osgeo/browser/livedvd/gisvm/trunk/bin/install_pgrouting.sh?rev=4269" target="_blank">http://trac.osgeo.org/osgeo/browser/livedvd/gisvm/trunk/bin/install_pgrouting.sh?rev=4269</a></blockquote>
<div><br></div><div>This is the latest revision, so it should be OK.</div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><br>
What user are you running it as?<br></blockquote><div><br></div><div>Currently without setting a specific user.</div><div>Accoring to the script user "user" creates the database: </div><div><span class="Apple-style-span" style="font-family: monospace; font-size: 11px; border-collapse: collapse; "><br>
</span></div><div><span class="Apple-style-span" style="font-family: monospace; font-size: 11px; border-collapse: collapse; ">sudo -u $USER_NAME createdb $OSM_DB</span></div><div><br></div><div>So also "user" should be also the owner of the database, right?</div>
<div><br></div><div>Then I run osm2pgrouting program without "sudo -u user", so without changing the user to "user". It should run then as root, I think.</div><div><br></div><div>To be able to connect to the database you can specify the database user with <span class="Apple-style-span" style="font-family: monospace; font-size: 11px; border-collapse: collapse; ">osm2pgrouting [...] </span><span class="Apple-style-span" style="font-family: monospace; font-size: 11px; border-collapse: collapse; ">-user user [...]</span></div>
<div>But here it somehow fails. If I run it afterwards on the VM it's OK. </div><div><br></div><div>Wondering why it fails. Do you have any idea? The users are a bit confusing but I can't see the error.</div><div>
<br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
The reason that the sudo -u is there is because the scripts run as root<br>
but root does not have access to postgres only user does.<br>
<br>
So you could try:<br>
sudo su user<br>
run commands<br>
exit (can you do exit in a script like that?)<br></blockquote><div><br></div><div>Do you think this makes a difference to start a command with sudo -u user?</div><div><br></div><div>Daniel </div><div><br></div><div><br></div>
<div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br>
Thanks,<br>
<font color="#888888">Alex<br>
</font><div><div></div><div class="h5"><br>
On 07/27/2010 10:00 PM, Daniel Kastl wrote:<br>
> Hi Alex,<br>
><br>
> Somehow I still have a problem with one part of the pgRouting install script<br>
> (building the sample data).<br>
> The log says (from line 4036):<br>
><br>
> create pgrouting database<br>
> add PostGIS functions<br>
> add pgRouting core functions<br>
> add pgRouting TSP functions<br>
> unpack sample data<br>
> Run osm2pgrouting converter (this may take a while)<br>
> host=127.0.0.1 user=user dbname=pgrouting port=5432<br>
> connection failed<br>
><br>
> The database is there, all required PostGIS/pgRouting funtions as well.<br>
> Last week I actually thought I found the reason and removed the initial<br>
> "sudo -u $USER_NAME" (line 120 in install_pgrouting.sh).<br>
> I tested it on the VM and when I run "osm2pgrouting" with "sudo" I get the<br>
> "connection failed" error, when I run it without it works.<br>
><br>
> I updated SVN already a few days ago, but could you make sure that<br>
> your install_pgrouting.sh was the latest one and has no "sudo -u $USER_NAME"<br>
> in line 120?<br>
><br>
> Daniel<br>
><br>
><br>
><br>
> 2010/7/28 Alex Mandel <<a href="mailto:tech_dev@wildintellect.com">tech_dev@wildintellect.com</a>><br>
><br>
>> Much better, but still a few quirks:<br>
>> <a href="http://download.osgeo.org/livedvd/4.0-rc5/4.0rc5logs.tar.gz" target="_blank">http://download.osgeo.org/livedvd/4.0-rc5/4.0rc5logs.tar.gz</a><br>
>><br>
>> The Help Launcher is nowhere to be seen, the files are there the logs<br>
>> seem ok, maybe the icon shuffle at the end did it in(I looked but didn't<br>
>> see it in any of the folders)? Also Mapbender is still floating on the<br>
>> desktop.<br>
>> FYI looks like something is still making a /usr/local/livedvd-docs<br>
>> folder but all our stuff is in osgeolive-docs, someone want to find and<br>
>> kill that uneeded folder?<br>
>><br>
>> Firefox homepage reset doesn't work, but that's nothing new, I did it by<br>
>> hand this time. I also added the Geospatial menu from it's file, the cpu<br>
>> monitor and the keyboard switcher so I don't forget to do it on the<br>
>> final builds.<br>
>><br>
>> I'm still compressing the image to 7z, should be ready in a hour or<br>
>> less, just keep an eye on<br>
>> <a href="http://download.osgeo.org/livedvd/4.0-rc5/" target="_blank">http://download.osgeo.org/livedvd/4.0-rc5/</a><br>
>><br>
>> Thanks,<br>
>> Alex<br>
_______________________________________________<br>
Live-demo mailing list<br>
<a href="mailto:Live-demo@lists.osgeo.org">Live-demo@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/live-demo" target="_blank">http://lists.osgeo.org/mailman/listinfo/live-demo</a><br>
<a href="http://wiki.osgeo.org/wiki/Live_GIS_Disc" target="_blank">http://wiki.osgeo.org/wiki/Live_GIS_Disc</a><br>
</div></div></blockquote></div><br></div>