[OSM-dev] Problem in running checktouch.pl (QA script by Gray68)
Hi, I am having problems in running checktouch.pl, a touch check QA script by Gray68 I have added required modules. I get following errors use of uninitialized value $OSM::osm::line in pattern match (m//) at OSM/ osm.pm line 232, $file line 396942. use of uninitialized value $OSM::osm::line in pattern match (m//) at OSM/ osm.pm line 494, $file line 396942. use of uninitialized value $OSM::osm::line in pattern match (m//) at OSM/ osm.pm line 477, $file line 396942. use of uninitialized value $OSM::osm::line in pattern match (m//) at OSM/ osm.pm line 279, $file line 396942. . . . Please help me -- Regards M Naveed Akram ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Problem in rake db:migrate
Anyone can help why am i getting this while rake db:migrate DEPRECATION WARNING: Rake tasks in vendor/plugins/oauth-plugin/tasks are deprecated. Use lib/tasks instead. (called from /usr/local/lib/ruby/gems/1.8/gems/rails-2.3.8/lib/tasks/rails.rb:10) == CreateCountries: migrating -- innodb_table() - 0.0001s -- create_table(:countries, {:options=, :id=false, :force=true}) NOTICE: CREATE TABLE will create implicit sequence countries_id_seq for serial column countries.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index countries_pkey for table countries - 0.0141s -- add_index(:countries, [:code], {:unique=true, :name=countries_code_idx}) - 0.0034s rake aborted! An error has occurred, this and all later migrations canceled: #REXML::ParseException: missing attribute quote Line: Position: Last 80 unconsumed characters: STYLE id=L_defaDTITLEThe page cannot be displayed/TITLE /usr/local/lib/ruby/1.8/rexml/parsers/baseparser.rb:355:in `pull' /usr/local/lib/ruby/1.8/rexml/parsers/treeparser.rb:22:in `parse' /usr/local/lib/ruby/1.8/rexml/document.rb:227:in `build' /usr/local/lib/ruby/1.8/rexml/document.rb:43:in `initialize' ./db/migrate//031_create_countries.rb:18:in `new' ./db/migrate//031_create_countries.rb:18:in `up_without_benchmarks' /usr/local/lib/ruby/1.8/net/http.rb:543:in `start' /usr/local/lib/ruby/1.8/net/http.rb:440:in `start' ./db/migrate//031_create_countries.rb:17:in `up_without_benchmarks' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:282:in `send' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:282:in `migrate' /usr/local/lib/ruby/1.8/benchmark.rb:293:in `measure' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:282:in `migrate' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:365:in `__send__' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:365:in `migrate' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:491 /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:565:in `call' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:565:in `ddl_transaction' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/transactions.rb:182:in `transaction_without_deadlock_handling' /home/www/rails/vendor/plugins/deadlock_retry/lib/deadlock_retry.rb:46:in `transaction' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:565:in `ddl_transaction' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:490:in `migrate' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:477:in `each' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:477:in `migrate' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:401:in `up' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:383:in `migrate' /usr/local/lib/ruby/gems/1.8/gems/rails-2.3.8/lib/tasks/databases.rake:112 /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in `invoke_with_call_chain' /usr/local/lib/ruby/1.8/monitor.rb:242:in `synchronize' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `each' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in `run' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run' /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31 /usr/local/bin/rake:19:in `load' /usr/local/bin/rake:19 ... missing attribute quote Line: Position: Last 80 unconsumed characters: STYLE id=L_defaADTITLEThe page cannot be displayed/TITLE Line: Position: Last 80 unconsumed characters:
[OSM-dev] Do the old version of Rails Port works with Postgres
Hi, Do the old version of Rails Port that has 25 database schema migrations: works fine with Postgres ?? If so with which version of Postgres. Thanks -- Regards M Naveed Akram http://www.google.com/profiles/cmnajs ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Problem in rake db:migrate with postgre
== AddRelations: migrating === -- create_enumeration(:nwr_enum, [Node, way, Relation]) rake aborted! An error has occurred, this and all later migrations canceled: PGError: ERROR: syntax error at or near enum LINE 1: create type nwr_enum as enum ('Node', 'Way', 'Relation') ^ : create type nwr_enum as enum ('Node', 'Way', 'Relation') -- Regards M Naveed Akram http://www.google.com/profiles/cmnajs ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Problem in rake db:migrate with postgre
i upgraded to 8.4 very thanks. but there seems to be an issue with 8.4 for UTF8, it does not allow to create database with UTF8 Encoding. On Thu, Jun 3, 2010 at 9:48 PM, Andy Allan gravityst...@gmail.com wrote: According to http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL: PostgreSQL doesn't have the ENUM types prior to 8.3 I think it would be easiest to upgrade your version of postgres. Cheers, Andy On Thu, Jun 3, 2010 at 12:54 PM, M Naveed Akram cmn...@gmail.com wrote: 8.2 On Thu, Jun 3, 2010 at 4:48 PM, Shaun McDonald sh...@shaunmcdonald.me.uk wrote: Which version of Postgres are you using? Shaun On Thu, June 3, 2010 11:24 am, M Naveed Akram wrote: == AddRelations: migrating === -- create_enumeration(:nwr_enum, [Node, way, Relation]) rake aborted! An error has occurred, this and all later migrations canceled: PGError: ERROR: syntax error at or near enum LINE 1: create type nwr_enum as enum ('Node', 'Way', 'Relation') ^ : create type nwr_enum as enum ('Node', 'Way', 'Relation') -- Regards M Naveed Akram http://www.google.com/profiles/cmnajs ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev -- Regards M Naveed Akram http://www.google.com/profiles/cmnajs ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev -- Regards M Naveed Akram http://www.google.com/profiles/cmnajs ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [osmosis-dev] Problem using Osmosis34, Please Help
I can connect to my database explicitly, i think there is some problem with jdbc connection 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 On Wed, Apr 21, 2010 at 6:28 AM, Brett Henderson br...@bretth.com wrote: It seems odd that it's not finding the database. Can you try this please to verify that you can connect to the openstreetmap database explicitly? mysql -h 127.0.0.1 -u root -p rose *openstreetmap* On Tue, Apr 20, 2010 at 9:29 PM, M Naveed Akram cmn...@gmail.com wrote: 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 -- Regards M Naveed Akram http://www.google.com/profiles/cmnajs ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev
Re: [osmosis-dev] Problem using Osmosis34, Please Help
i checked this mysql -h 127.0.0.1 -u root -p rose *openstreetmap* also *SELECT * from nodes;* both works fine.. and the schema version is 0.6 On Wed, Apr 21, 2010 at 1:25 PM, Brett Henderson br...@bretth.com wrote: On Wed, Apr 21, 2010 at 5:03 PM, M Naveed Akram cmn...@gmail.com wrote: I can connect to my database explicitly, i think there is some problem with jdbc connection Sorry to ask, but did you run: mysql -h 127.0.0.1 -u root -p rose* * Or did you run: * *mysql -h 127.0.0.1 -u root -p rose *openstreetmap* The error seems to indicate that a successful connection is being made to the database server, but that that database schema doesn't exist. Can you verify that you can run a query against this schema? For example: *SELECT * from nodes;* I'm confused because I've never before seen a case where a successful connection is made to the server, but the schema can't be found. Brett ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev
Re: [osmosis-dev] Problem using Osmosis34, Please Help
It also gives the same error stack if i give wrong database information.. I tried to rebuild the package using ant resolve ant all but the build failed.. saying one or more junit tests failed.. couple of failed tests are - org.openstreetmap.osmosis.core.pgsql.v0_6.PostgreSqlTest - org.openstreetmap.osmosis.extract.apidb.v0_6.DatabaseTimeLoader There might be some db driver issue java version is 1.6.0_07-b02 On Wed, Apr 21, 2010 at 1:25 PM, Brett Henderson br...@bretth.com wrote: On Wed, Apr 21, 2010 at 5:03 PM, M Naveed Akram cmn...@gmail.com wrote: I can connect to my database explicitly, i think there is some problem with jdbc connection Sorry to ask, but did you run: mysql -h 127.0.0.1 -u root -p rose* * Or did you run: * *mysql -h 127.0.0.1 -u root -p rose *openstreetmap* The error seems to indicate that a successful connection is being made to the database server, but that that database schema doesn't exist. Can you verify that you can run a query against this schema? For example: *SELECT * from nodes;* I'm confused because I've never before seen a case where a successful connection is made to the server, but the schema can't be found. Brett -- Regards M Naveed Akram http://www.google.com/profiles/cmnajs ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev
Re: [osmosis-dev] Problem using Osmosis34, Please Help
i am using FreeBSD 7.1 Release i changed the db but same stuff..i have almost 4 dbs in place one with 0.5 schema and other with 0.6 schema i also tried with empty db.. On Wed, Apr 21, 2010 at 2:25 PM, Peter Körner osm-li...@mazdermind.dewrote: M Naveed Akram schrieb: It also gives the same error stack if i give wrong database information.. What OS are you running on? Are you using VMs or Jails or sth. like that? I thought about some strange SELinux error but that would prevent you from connecting. I also thought about a permission issue on the database-files but that would prevent mysql from working, too. Could you create another database and try with this? Or try to rename the openstreetmap database to any other name and try this? I'm not sure whether this is an osmosis problem or it's somewhere in the sql server. but the build failed.. saying one or more junit tests failed.. couple of failed tests are - org.openstreetmap.osmosis.core.pgsql.v0_6.PostgreSqlTest - org.openstreetmap.osmosis.extract.apidb.v0_6.DatabaseTimeLoader These tests always fail if you don't have the right postgres-db in place. Peter -- Regards M Naveed Akram http://www.google.com/profiles/cmnajs ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev
[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
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
[osmosis-dev] Osmosis34 JDBC Connection Error
When i use --read-apidb i get following error Could not open JDBC connection for transaction. How can i fix this. ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev