[osmosis-dev] Problem using Osmosis34, Please Help
Hi i get following when exporting osm from db, please help $ ./osmosis --read-apidb host=127.0.0.1 database=openstreetmap user=root password=rose dbType=mysql --write-xml file=output.osm Apr 20, 2010 3:10:51 PM org.openstreetmap.osmosis.core.Osmosis run INFO: Osmosis Version 0.34 Apr 20, 2010 3:10:53 PM org.openstreetmap.osmosis.core.Osmosis run INFO: Preparing pipeline. Apr 20, 2010 3:10:53 PM org.openstreetmap.osmosis.core.Osmosis run INFO: Launching pipeline execution. Apr 20, 2010 3:10:53 PM org.openstreetmap.osmosis.core.Osmosis run INFO: Pipeline executing, waiting for completion. Apr 20, 2010 3:10:53 PM org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion SEVERE: Thread for task 1-read-apidb failed org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (FATAL: database openstreetmap does not exist) at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:238) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:125) at org.openstreetmap.osmosis.core.apidb.common.DatabaseContext2.executeWithinTransaction(DatabaseContext2.java:100) at org.openstreetmap.osmosis.core.apidb.v0_6.ApidbReader.run(ApidbReader.java:102) at java.lang.Thread.run(Thread.java:619) Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (FATAL: database openstreetmap does not exist) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:200) ... 5 more Caused by: org.postgresql.util.PSQLException: FATAL: database openstreetmap does not exist at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:444) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:99) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) at org.postgresql.jdbc2.AbstractJdbc2Connection.init(AbstractJdbc2Connection.java:124) at org.postgresql.jdbc3.AbstractJdbc3Connection.init(AbstractJdbc3Connection.java:30) at org.postgresql.jdbc4.AbstractJdbc4Connection.init(AbstractJdbc4Connection.java:29) at org.postgresql.jdbc4.Jdbc4Connection.init(Jdbc4Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:386) at org.postgresql.Driver.connect(Driver.java:260) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221) ... 7 more Apr 20, 2010 3:10:53 PM org.openstreetmap.osmosis.core.Osmosis main SEVERE: Execution aborted. org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more tasks failed. at org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146) at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:85) at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:30) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:329) at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:239) at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409) at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352) at org.codehaus.classworlds.Launcher.main(Launcher.java:31) ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev
Re: [osmosis-dev] Problem using Osmosis34, Please Help
M Naveed Akram schrieb: Hi i get following when exporting osm from db, please help $ ./osmosis --read-apidb host=127.0.0.1 database=openstreetmap user=root password=rose dbType=mysql --write-xml file=output.osm ... (FATAL: database openstreetmap does not exist) ... Q: Does the database openstreetmap exist and does the user root have access to it? Peter ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev
Re: [osmosis-dev] Problem using Osmosis34, Please Help
Yes database is present, also accessible.. i can check it via mysql -h 127.0.0.1 -u root -p rose On Tue, Apr 20, 2010 at 4:17 PM, Peter Körner osm-li...@mazdermind.dewrote: M Naveed Akram schrieb: Hi i get following when exporting osm from db, please help $ ./osmosis --read-apidb host=127.0.0.1 database=openstreetmap user=root password=rose dbType=mysql --write-xml file=output.osm ... (FATAL: database openstreetmap does not exist) ... Q: Does the database openstreetmap exist and does the user root have access to it? Peter http://www.google.com/profiles/cmnajs ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev
Re: [OSM-dev] Planet OSM 'bad result during COPY'
Seth Voltz schrieb: does anyone have an idea how long I can expect to wait before osm2pgsql completes its execution? What is it doing? It's normal that this stage can take up to an day. As far as I understand it creates the indexes now. Also, is it safe at this point to start up tile generation? I don't think so. Peter ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Open Social Routing Idea: Request for preliminary comments
El 19/04/2010 16:56, Jonas Gabriel escribió: Every person creates personal routes based on his knowledge of his living area.[...] Then a service could produce routes by using members of this alternative routing graph forest connected by a traditional routing service [...] I would like to hear some of your comments.Does it make any sense? Yeah, it makes sense and would be doable by lowering the weights of the graph arcs in the routing algorithm for every uploaded route, or add a new arc for every uploaded route, with a lowered weight. However, besides from being a cool research project... what problem does it *solve*? Why would *I* be interested in uploading routes to such a service? Cheers, -- Iván Sánchez Ortega i...@sanchezortega.es ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Open Social Routing Idea: Request for preliminary comments
Jonas, Jonas Gabriel wrote: I am in search of a Master Thesis' project idea in the field of Location Based Applications/Services. Last night I came across OpenRouteService.org http://www.openrouteservice.org/ and had an epiphany about a routing service based on social contribution.Let me clear out my idea: Peter Miller has done a talk at the 2008 State of the Map conference (in Limerick) about something in that direction; he explained that different people may favour different routes for very different reasons and that it could be a good idea to ask: What route would people like me use? Personally I would probably not make it as difficult as you; I would simply allow individual weights for bits of the routing graph. I.e. you would not upload a route; instead you would have the system compute the route it thinks is best, and then you'd say: Nah, I don't like that because it takes me along a busy road. I'll add a 50% penalty to that road and see where it takes me now. Oh well it doesn't use that bit of footway there but it really should, so I'll give that a bonus, etc. Anyone could then use the routing engine either with the normal weights, or with a combination of weights of different users. But still this might be too big for a Master's thesis. Bye Frederik ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Open Social Routing Idea: Request for preliminary comments
Frederik Ramm schrieb: Personally I would probably not make it as difficult as you; I would simply allow individual weights for bits of the routing graph. I.e. you would not upload a route; instead you would have the system compute the route it thinks is best, and then you'd say: Nah, I don't like that because it takes me along a busy road. I'll add a 50% penalty to that road and see where it takes me now. Oh well it doesn't use that bit of footway there but it really should, so I'll give that a bonus, etc. This is done using vias in google maps right now. Just drag'n'drop from the calculated route.. Peter ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Open Social Routing Idea: Request for preliminary comments
El 20/04/2010 13:02, Peter Körner escribió: Nah, I don't like that because it takes me along a busy road. I'll add a 50% penalty to that road and see where it takes me now. This is done using vias in google maps right now. Just drag'n'drop from the calculated route.. No, you cannot avoid stuff by dragging in GMaps. You can, however, use OpenRouteService for that :-) -- Iván Sánchez Ortega i...@sanchezortega.es ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Open Social Routing Idea: Request for preliminary comments
@Ivan: I agree. The more people using my favourite route, the slower I will get forward, so why should I share? Answer: not at all if I know which informations my actions do supply to the service. But: tell the user to make a perfect route for her purpose if she supplies the service with detail information such as car type, personal driving style, comfort preference, urgency, and, of course, starting time and personally expected arrival time. And don't forget about the feedback next time she logs in again. (think carefully about the validity of the result) last.fm names this 'skobbling' and gives you recommendations, groups user types and creates correlations to form groups by similarity of preferences. The idea is not bad, but I don't expect it to grow successful, especially because the project's scope is short-term. You need a deep breath to get it all sexy and charming enough for average people to use. Without a wide userbase such a service won't get any value. Creating the toolset services like this could be based upon looks promising, though. Thomas Original-Nachricht Datum: Tue, 20 Apr 2010 11:37:02 +0200 Von: Iván Sánchez Ortega i...@sanchezortega.es An: dev@openstreetmap.org Betreff: Re: [OSM-dev] Open Social Routing Idea: Request for preliminary comments El 19/04/2010 16:56, Jonas Gabriel escribió: Every person creates personal routes based on his knowledge of his living area.[...] Then a service could produce routes by using members of this alternative routing graph forest connected by a traditional routing service [...] I would like to hear some of your comments.Does it make any sense? Yeah, it makes sense and would be doable by lowering the weights of the graph arcs in the routing algorithm for every uploaded route, or add a new arc for every uploaded route, with a lowered weight. However, besides from being a cool research project... what problem does it *solve*? Why would *I* be interested in uploading routes to such a service? Cheers, -- Iván Sánchez Ortega i...@sanchezortega.es ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev -- http://www.openstreetmap.org/?lat=47.172lon=7.4395zoom=15layers=B000FTFTTmlat=47.16696mlon=7.43509 GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Planet OSM 'bad result during COPY'
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Peter, Good estimate of time, it took about 16 hours to finalize everything and DB access is significantly faster, which I'm betting is a combination of the indices and the decreased load from the import process. My tiles are generating about as fast as I expected and now it's time to play with themes. Thanks again for everyone who helped! — Seth On Apr 20, 2010, at 12:48 AM, Peter Körner wrote: Seth Voltz schrieb: does anyone have an idea how long I can expect to wait before osm2pgsql completes its execution? What is it doing? It's normal that this stage can take up to an day. As far as I understand it creates the indexes now. Also, is it safe at this point to start up tile generation? I don't think so. Peter -BEGIN PGP SIGNATURE- Version: PGP Desktop 9.12.0 (Build 1035) Charset: windows-1252 wsBVAwUBS83/FMgJWVul8LvVAQiFfwf+LcB9VlrPhvWyyAfjrb6aUQ02L4HeRHJx 69AKNbbAJ6DYhu5KPNHQlxR3A7xj7lqX48oylIyo3e3upNq6xFP3QPjFojz+80so U5s35ATdWjhgmFpmNh4ICw8Y8h7NK7+EH4dNhL7vJ7wH7LE0SISyWi94RcAVac3C RhXiCzLTVyYNWANwq1sYnhwt74KPc0CHHUV0RJYHyE/TFWaqNJVGVdiZVxoQCUcd zPTAGoKQJZr9pJY54mbOMxWKIHgfGdwImoY3htbivmbhmj/G+D3GGHYcSjkwTQft 1gSnvD6cY07uJCxraENHWO3Uno5GrHVPo1RosQ7Aa7SuxktUa7zD8g== =laJ1 -END PGP SIGNATURE- ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Open Social Routing Idea: Request for preliminary comments
It sounds good. Anyone who knows about routing knows that it takes a crazy long time to be sure of the perfect route. This could be a way for the program to say I know the best way to get most of the way, because Jane told me she goes this way.. Adding a load of sample routes in one area, and with a good weighting on provided routes, it would be interesting to see how the program faired to other routing algorithms that. Are you going to look at motoring routing? Walking routing might be just as interesting (and more easy to get people's routes added). I walk around university a lot, sometimes two routes look exactly the same length but I take the route through a park because it's nicer and makes the journey feel shorter. Sometimes I go one way because it just has a few steps, returning I go another way because it's downhill. On 20 April 2010 10:00, Thomas Meller thomas.mel...@gmx.net wrote: @Ivan: I agree. The more people using my favourite route, the slower I will get forward, so why should I share? Answer: not at all if I know which informations my actions do supply to the service. But: tell the user to make a perfect route for her purpose if she supplies the service with detail information such as car type, personal driving style, comfort preference, urgency, and, of course, starting time and personally expected arrival time. And don't forget about the feedback next time she logs in again. (think carefully about the validity of the result) last.fm names this 'skobbling' and gives you recommendations, groups user types and creates correlations to form groups by similarity of preferences. The idea is not bad, but I don't expect it to grow successful, especially because the project's scope is short-term. You need a deep breath to get it all sexy and charming enough for average people to use. Without a wide userbase such a service won't get any value. Creating the toolset services like this could be based upon looks promising, though. Thomas Original-Nachricht Datum: Tue, 20 Apr 2010 11:37:02 +0200 Von: Iván Sánchez Ortega i...@sanchezortega.es An: dev@openstreetmap.org Betreff: Re: [OSM-dev] Open Social Routing Idea: Request for preliminary comments El 19/04/2010 16:56, Jonas Gabriel escribió: Every person creates personal routes based on his knowledge of his living area.[...] Then a service could produce routes by using members of this alternative routing graph forest connected by a traditional routing service [...] I would like to hear some of your comments.Does it make any sense? Yeah, it makes sense and would be doable by lowering the weights of the graph arcs in the routing algorithm for every uploaded route, or add a new arc for every uploaded route, with a lowered weight. However, besides from being a cool research project... what problem does it *solve*? Why would *I* be interested in uploading routes to such a service? Cheers, -- Iván Sánchez Ortega i...@sanchezortega.es ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev -- http://www.openstreetmap.org/?lat=47.172lon=7.4395zoom=15layers=B000FTFTTmlat=47.16696mlon=7.43509 GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev -- Gregory o...@livingwithdragons.com http://www.livingwithdragons.com ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev