<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
Hi,<br><br>I'm doing something wrong when I try to configure Postgres SQL DB <br>with osmosis-SNAPSHOT-r25162.<br><br>I get ERROR: permission denied for relation schema_info<br><br><br>Database setup on Fedora 14 64-bit:<br>================<br><br>sudo -u postgres psql<br> <br>CREATE USER osm<br>create database osm;<br>GRANT ALL PRIVILEGES ON DATABASE osm TO osm; <br>q\<br> <br>sudo -u postgres createlang plpgsql osm<br>sudo -u postgres psql -d osm -f /usr/share/pgsql/contrib/postgis-64.sql<br>sudo -u postgres psql -d osm -f /usr/share/pgsql/contrib/hstore.sql<br>sudo -u postgres psql -d osm -f /tmp/pgsnapshot_schema_0.6.sql<br><br>Error:<br>====<br>JAVACMD_OPTIONS="-Djava.io.tmpdir=/home/pelle/temp" osmosis --read-xml file="switzerland.osm" --write-pgsql user="osm" database="osm"<br>Feb 3, 2011 5:23:04 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Osmosis Version SNAPSHOT-r25162<br>Feb 3, 2011 5:23:05 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Preparing pipeline.<br>Feb 3, 2011 5:23:05 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Launching pipeline execution.<br>Feb 3, 2011 5:23:05 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Pipeline executing, waiting for completion.<br>Feb 3, 2011 5:24:31 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions<br>INFO: Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]<br>Feb 3, 2011 5:24:31 PM org.springframework.jdbc.support.SQLErrorCodesFactory <init><br>INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]<br>Feb 3, 2011 5:24:31 PM org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion<br>SEVERE: Thread for task 1-read-xml failed<br>org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT version FROM schema_info]; nested exception is org.postgresql.util.PSQLException: ERROR: permission denied for relation schema_info<br> at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)<br> at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)<br> at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)<br> at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)<br> at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)<br> at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:455)<br> at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:463)<br> at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:471)<br> at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:476)<br> at org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:485)<br> at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForInt(SimpleJdbcTemplate.java:113)<br> at org.openstreetmap.osmosis.pgsnapshot.common.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:64)<br> at org.openstreetmap.osmosis.pgsnapshot.common.SchemaVersionValidator.validateVersion(SchemaVersionValidator.java:47)<br> at org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.CopyFilesetLoader.run(CopyFilesetLoader.java:78)<br> at org.openstreetmap.osmosis.pgsnapshot.v0_6.PostgreSqlCopyWriter.complete(PostgreSqlCopyWriter.java:108)<br> at org.openstreetmap.osmosis.xml.v0_6.XmlReader.run(XmlReader.java:110)<br> at java.lang.Thread.run(Thread.java:636)<br>Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for relation schema_info<br> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)<br> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)<br> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)<br> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)<br> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)<br> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)<br> at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)<br> at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)<br> at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:440)<br> at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)<br> ... 12 more<br>Feb 3, 2011 5:24:31 PM org.openstreetmap.osmosis.core.Osmosis main<br>SEVERE: Execution aborted.<br>org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more tasks failed.<br> at org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)<br> at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:92)<br> at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:329)<br> at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:239)<br> at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)<br> at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)<br> at org.codehaus.classworlds.Launcher.main(Launcher.java:31)<br><br> </body>
</html>