<p>I solved the issue with the database.<br>
It was mainly due to the role & username.</p>
<p>Now i am facing the issue of key id already exists; when i am trying to populate the database.<br>
`aseggemu data $ osmosis --read-xml fokus_e00.osm \</p>
<blockquote>
<p>--write-apidb host="localhost" database="openstreetmap" <br>
user="openstreetmap" password="openstreetmap" validateSchemaVersion="no"<br>
Jul 01, 2017 2:38:23 PM org.openstreetmap.osmosis.core.Osmosis run<br>
INFO: Osmosis Version 0.45<br>
Jul 01, 2017 2:38:23 PM org.openstreetmap.osmosis.core.Osmosis run<br>
INFO: Preparing pipeline.<br>
Jul 01, 2017 2:38:23 PM org.openstreetmap.osmosis.core.Osmosis run<br>
INFO: Launching pipeline execution.<br>
Jul 01, 2017 2:38:23 PM org.openstreetmap.osmosis.core.Osmosis run<br>
INFO: Pipeline executing, waiting for completion.<br>
Jul 01, 2017 2:38:25 PM org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion<br>
SEVERE: Thread for task 1-read-xml failed<br>
org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to load current nodes.<br>
at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.populateCurrentNodes(ApidbWriter.java:935)<br>
at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.populateCurrentTables(ApidbWriter.java:1036)<br>
at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.complete(ApidbWriter.java:1070)<br>
at org.openstreetmap.osmosis.xml.v0_6.XmlReader.run(XmlReader.java:92)<br>
at java.lang.Thread.run(Thread.java:745)<br>
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "current_nodes_pkey1"<br>
Detail: Key (id)=(-39113) already exists.<br>
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)<br>
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)<br>
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)<br>
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)<br>
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)<br>
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)<br>
at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.populateCurrentNodes(ApidbWriter.java:932)<br>
... 4 more</p>
</blockquote>
<p>Jul 01, 2017 2:38:25 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:62)<br>
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br>
at java.lang.reflect.Method.invoke(Method.java:497)<br>
at org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:330)<br>
at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:238)<br>
at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415)<br>
at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)<br>
at org.codehaus.classworlds.Launcher.main(Launcher.java:47)`</p>
<p>I read through some of the issues. But, the solution was not applicable to mine. As, in the osm file there is one node i.e. id="-39113"<br>
Here is the <a href="https://gist.github.com/18dcca3af737cbee5223e5c51be84dba.git">fokus_e00.osm</a> file</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/openstreetmap/openstreetmap-website/issues/1545#issuecomment-312430417">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/ABWnLbWhqnflkL3hgheUccWZ8yoNcdKmks5sJj_jgaJpZM4NhOy6">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/ABWnLehQqxn_D57ul9Xnzo9O5wYQKjwfks5sJj_jgaJpZM4NhOy6.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
  <link itemprop="url" href="https://github.com/openstreetmap/openstreetmap-website/issues/1545#issuecomment-312430417"></link>
  <meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>

<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/openstreetmap/openstreetmap-website","title":"openstreetmap/openstreetmap-website","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/openstreetmap/openstreetmap-website"}},"updates":{"snippets":[{"icon":"PERSON","message":"@akarsh in #1545: I solved the issue with the database.\r\nIt was mainly due to the role \u0026 username.\r\n\r\nNow i am facing the issue of key id already exists; when i am trying to populate the database.\r\n`aseggemu data $ osmosis --read-xml fokus_e00.osm \\\r\n\u003e   --write-apidb host=\"localhost\" database=\"openstreetmap\" \\\r\n\u003e   user=\"openstreetmap\" password=\"openstreetmap\" validateSchemaVersion=\"no\"\r\nJul 01, 2017 2:38:23 PM org.openstreetmap.osmosis.core.Osmosis run\r\nINFO: Osmosis Version 0.45\r\nJul 01, 2017 2:38:23 PM org.openstreetmap.osmosis.core.Osmosis run\r\nINFO: Preparing pipeline.\r\nJul 01, 2017 2:38:23 PM org.openstreetmap.osmosis.core.Osmosis run\r\nINFO: Launching pipeline execution.\r\nJul 01, 2017 2:38:23 PM org.openstreetmap.osmosis.core.Osmosis run\r\nINFO: Pipeline executing, waiting for completion.\r\nJul 01, 2017 2:38:25 PM org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion\r\nSEVERE: Thread for task 1-read-xml failed\r\norg.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to load current nodes.\r\n\tat org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.populateCurrentNodes(ApidbWriter.java:935)\r\n\tat org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.populateCurrentTables(ApidbWriter.java:1036)\r\n\tat org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.complete(ApidbWriter.java:1070)\r\n\tat org.openstreetmap.osmosis.xml.v0_6.XmlReader.run(XmlReader.java:92)\r\n\tat java.lang.Thread.run(Thread.java:745)\r\nCaused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint \"current_nodes_pkey1\"\r\n  Detail: Key (id)=(-39113) already exists.\r\n\tat org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)\r\n\tat org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)\r\n\tat org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)\r\n\tat org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)\r\n\tat org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)\r\n\tat org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)\r\n\tat org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.populateCurrentNodes(ApidbWriter.java:932)\r\n\t... 4 more\r\n\r\nJul 01, 2017 2:38:25 PM org.openstreetmap.osmosis.core.Osmosis main\r\nSEVERE: Execution aborted.\r\norg.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more tasks failed.\r\n\tat org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)\r\n\tat org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:92)\r\n\tat org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat java.lang.reflect.Method.invoke(Method.java:497)\r\n\tat org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:330)\r\n\tat org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:238)\r\n\tat org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415)\r\n\tat org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)\r\n\tat org.codehaus.classworlds.Launcher.main(Launcher.java:47)`\r\n\r\nI read through some of the issues. But, the solution was not applicable to mine. As, in the osm file there is one node i.e. id=\"-39113\"\r\nHere is the [fokus_e00.osm](https://gist.github.com/18dcca3af737cbee5223e5c51be84dba.git) file"}],"action":{"name":"View Issue","url":"https://github.com/openstreetmap/openstreetmap-website/issues/1545#issuecomment-312430417"}}}</script>