[osmosis-dev] Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user

[Katie Urey]

Resolved--- reconfigured host based authentication in pg_hba.conf.

On Mon, Apr 9, 2012 at 5:24 PM, Katie Urey <ksurey at gmail.com> wrote:
> Friends,
>
> osmosis is failing with a password authentication error on a ubuntu
> system, lucid 10.04, postgres 9.1.
>
> postgres accepts logins and commands loaded with psql.
>
> the caused by error is;
> Caused by: org.postgresql.util.PSQLException: FATAL: password
> authentication failed for user "jack"
>
> we'd like some hints about how to debug or repair the osmosis/postgres install.
>
> + /home/jack/osmosis/bin/osmosis --read-xml
> file=/home/jack/gis/gps/strOSM/ladds.osm --wkv
> keyValueList=highway.path,highway.cycleway,highway.footway,highway.pedestrian,highway.motorway,highway.motorway_link,highway.trunk,highway.trunk_link,highway.primary,highway.primary_link,highway.secondary,highway.secondary_link,highway.tertiary,highway.tertiary_link,highway.residential,highway.residential_link,highway.service,highway.track,highway.living_street
> --write-pgsimp-0.6 user=jack database=osm46 password=****
>
> Apr 6, 2012 10:43:34 PM org.openstreetmap.osmosis.core.Osmosis run
> INFO: Osmosis Version 0.40
> Apr 6, 2012 10:43:36 PM org.openstreetmap.osmosis.core.Osmosis run
> INFO: Preparing pipeline.
> Apr 6, 2012 10:43:36 PM org.openstreetmap.osmosis.core.Osmosis run
> INFO: Launching pipeline execution.
> Apr 6, 2012 10:43:36 PM org.openstreetmap.osmosis.core.Osmosis run
> INFO: Pipeline executing, waiting for completion.
> Apr 6, 2012 10:43:36 PM
> org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
> waitForCompletion
> SEVERE: Thread for task 1-read-xml failed
> org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to
> establish a new database connection.
>        at org.openstreetmap.osmosis.pgsimple.common.DatabaseContext.getConnectionFromDriverManager(DatabaseContext.java:73)
>        at org.openstreetmap.osmosis.pgsimple.common.DatabaseContext.getConnection(DatabaseContext.java:125)
>        at org.openstreetmap.osmosis.pgsimple.common.DatabaseContext.createStatement(DatabaseContext.java:221)
>        at org.openstreetmap.osmosis.pgsimple.common.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:70)
>        at org.openstreetmap.osmosis.pgsimple.common.SchemaVersionValidator.validateVersion(SchemaVersionValidator.java:50)
>        at org.openstreetmap.osmosis.pgsimple.v0_6.PostgreSqlWriter.initialize(PostgreSqlWriter.java:185)
>        at org.openstreetmap.osmosis.pgsimple.v0_6.PostgreSqlWriter.process(PostgreSqlWriter.java:779)
>        at org.openstreetmap.osmosis.tagfilter.v0_6.WayKeyValueFilter.process(WayKeyValueFilter.java:70)
>        at org.openstreetmap.osmosis.core.container.v0_6.NodeContainer.process(NodeContainer.java:58)
>        at org.openstreetmap.osmosis.tagfilter.v0_6.WayKeyValueFilter.process(WayKeyValueFilter.java:53)
>        at org.openstreetmap.osmosis.xml.v0_6.impl.NodeElementProcessor.end(NodeElementProcessor.java:118)
>        at org.openstreetmap.osmosis.xml.v0_6.impl.OsmHandler.endElement(OsmHandler.java:107)
>        at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
>        at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown
> Source)
>        at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown
> Source)
>        at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown
> Source)
>        at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
> Source)
>        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
>        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
>        at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
>        at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
>        at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
>        at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)
>        at javax.xml.parsers.SAXParser.parse(SAXParser.java:195)
>        at org.openstreetmap.osmosis.xml.v0_6.XmlReader.run(XmlReader.java:108)
>        at java.lang.Thread.run(Thread.java:636)
> Caused by: org.postgresql.util.PSQLException: FATAL: password
> authentication failed for user "jack"
>        at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:291)
>        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108)
>        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
>        at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
>        at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
>        at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
>        at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)
>        at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
>        at org.postgresql.Driver.makeConnection(Driver.java:393)
>        at org.postgresql.Driver.connect(Driver.java:267)
>        at java.sql.DriverManager.getConnection(DriverManager.java:620)
>        at java.sql.DriverManager.getConnection(DriverManager.java:200)
>        at org.openstreetmap.osmosis.pgsimple.common.DatabaseContext.getConnectionFromDriverManager(DatabaseContext.java:64)
>        ... 25 more
> Apr 6, 2012 10:43:36 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:92)
>        at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37)
>        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>        at java.lang.reflect.Method.invoke(Method.java:616)
>
>
>
>
> --
> Katie Urey
> ksurey at gmail.com



-- 
Katie Urey
ksurey at gmail.com