localhost:8082 not working

I can't access my localhost:8082 page.

I get this error: ERR_CONNECTION_REFUSED

My log:

2018-01-26 17:23:11  INFO: Operating system name: Windows 10 version: 10.0 architecture: amd64
2018-01-26 17:23:11  INFO: Java runtime name: Java HotSpot(TM) 64-Bit Server VM vendor: Oracle Corporation version: 25.151-b12
2018-01-26 17:23:11  INFO: Memory limit heap: 2727mb non-heap: 0mb
2018-01-26 17:23:11  INFO: Character encoding: UTF-8 charset: UTF-8
2018-01-26 17:23:11  INFO: Version: 3.15-SNAPSHOT
2018-01-26 17:23:15  INFO: Starting server...

Anton Tananaev7 years ago

Is the process running? Is it listening for the port?

Daniel Bonifacio7 years ago

The service starts and stops a few seconds later.
None proccess with traccar or similar name running.

Anton Tananaev7 years ago

Then you should check wrapper.log.

Daniel Bonifacio7 years ago

There it is:

...
INFO|6768/0|Service traccar|18-01-26 17:23:15|[main] INFO org.eclipse.jetty.util.log - Logging initialized @6701ms
INFO|6768/0|Service traccar|18-01-26 17:23:16|java.lang.reflect.InvocationTargetException
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at java.lang.reflect.Method.invoke(Unknown Source)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|6768/0|Service traccar|18-01-26 17:23:16|Caused by: org.jboss.netty.channel.ChannelException: Failed to bind to: 0.0.0.0/0.0.0.0:5040
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at org.jboss.netty.bootstrap.ServerBootstrap.bind(ServerBootstrap.java:272)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at org.traccar.TrackerServer.start(TrackerServer.java:117)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at org.traccar.ServerManager.start(ServerManager.java:81)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at org.traccar.Main.main(Main.java:38)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	... 6 more
INFO|6768/0|Service traccar|18-01-26 17:23:16|Caused by: java.net.BindException: Address already in use: bind
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at sun.nio.ch.Net.bind0(Native Method)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at sun.nio.ch.Net.bind(Unknown Source)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at sun.nio.ch.Net.bind(Unknown Source)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at sun.nio.ch.ServerSocketChannelImpl.bind(Unknown Source)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at sun.nio.ch.ServerSocketAdaptor.bind(Unknown Source)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at org.jboss.netty.channel.socket.nio.NioServerBoss$RegisterTask.run(NioServerBoss.java:193)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at org.jboss.netty.channel.socket.nio.AbstractNioSelector.processTaskQueue(AbstractNioSelector.java:391)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:315)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at org.jboss.netty.channel.socket.nio.NioServerBoss.run(NioServerBoss.java:42)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
INFO|6768/0|Service traccar|18-01-26 17:23:16|	at java.lang.Thread.run(Unknown Source)
INFO|wrapper|Service traccar|18-01-26 17:23:16|calling onStop

Anton Tananaev7 years ago

As log pretty clearly says, you have a conflict on port 5040. It has been discussed many times before.

Daniel Bonifacio7 years ago

Thanks! Just commented the line 111 of default.xml file and restarted the service. Worked!

VZ7 years ago

Same problem for me.
I can't access the localhost:8082 page. When i had install the traccar and tested, all was fine, but today i couldn't access the page. I installed on Debian. I am running the service and i am getting the message "Service traccar started" but i can't access it (localhost:8082). Can you please tell me what to check so i will be able to solve the problem?

Thanks.
Best Regards.
(Sorry for my English)

Anton Tananaev7 years ago

First thing you should do before asking for help on forum is check server logs. We won't be able to help you without logs anyway.

VZ7 years ago

Sorry about that, but at the time that i got access to the forum i was away from the Server and the log files.
So today i am sending you the log files:
These are the last lines when i am starting the service with the command "sudo /opt/traccar/bin/startDaemon.sh" :
Service traccar started

Jan 31, 2018 8:20:33 AM org.rzo.yajsw.os.posix.PosixService getPid
INFO: wrapper pid file: /run/wrapper.traccar.pid
Jan 31, 2018 8:20:34 AM org.rzo.yajsw.os.posix.PosixService getPid
INFO: wrapper pid file: /run/wrapper.traccar.pid
Jan 31, 2018 8:20:34 AM org.rzo.yajsw.os.posix.PosixService getPid
INFO: wrapper pid file: /run/wrapper.traccar.pid
Service traccar started

And this is the wrapper log file after i started the traccar service:

WARNING|wrapper|Service traccar|18-01-31 07:55:40|YAJSW: yajsw-stable-12.11
WARNING|wrapper|Service traccar|18-01-31 07:55:40|OS   : Linux/4.9.0-4-amd64/amd64
WARNING|wrapper|Service traccar|18-01-31 07:55:40|JVM  : Oracle Corporation/1.8.0_151//usr/lib/jvm/java-8-openjdk-amd64/jre/64
INFO|wrapper|Service traccar|18-01-31 07:55:41|exec:java -classpath /opt/traccar/wrapperApp.jar:/opt/traccar/tracker-server.jar:/opt/traccar/lib/log4j-1.2.17.jar:/opt/traccar/lib/joda-time-2.9.9.jar:/opt/traccar/lib/h2-1.4.196.jar:/opt/traccar/lib/mysql-connector-java-5.1.45.jar:/opt/traccar/lib/postgresql-42.1.4.jre7.jar:/opt/traccar/lib/mssql-jdbc-6.2.2.jre7.jar:/opt/traccar/lib/HikariCP-java7-2.4.13.jar:/opt/traccar/lib/slf4j-api-1.7.21.jar:/opt/traccar/lib/netty-3.10.6.Final.jar:/opt/traccar/lib/async-http-client-1.9.40.jar:/opt/traccar/lib/slf4j-simple-1.7.25.jar:/opt/traccar/lib/javax.json-1.0.4.jar:/opt/traccar/lib/jetty-server-9.2.22.v20170606.jar:/opt/traccar/lib/javax.servlet-api-3.1.0.jar:/opt/traccar/lib/jetty-http-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-io-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-servlet-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-security-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-webapp-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-xml-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-jndi-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-util-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-proxy-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-client-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-server-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-common-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-api-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-client-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-servlet-9.2.22.v20170606.jar:/opt/traccar/lib/jersey-container-servlet-2.25.1.jar:/opt/traccar/lib/jersey-container-servlet-core-2.25.1.jar:/opt/traccar/lib/javax.inject-2.5.0-b32.jar:/opt/traccar/lib/jersey-common-2.25.1.jar:/opt/traccar/lib/javax.annotation-api-1.2.jar:/opt/traccar/lib/jersey-guava-2.25.1.jar:/opt/traccar/lib/hk2-api-2.5.0-b32.jar:/opt/traccar/lib/hk2-utils-2.5.0-b32.jar:/opt/traccar/lib/aopalliance-repackaged-2.5.0-b32.jar:/opt/traccar/lib/hk2-locator-2.5.0-b32.jar:/opt/traccar/lib/javassist-3.20.0-GA.jar:/opt/traccar/lib/osgi-resource-locator-1.0.1.jar:/opt/traccar/lib/jersey-server-2.25.1.jar:/opt/traccar/lib/jersey-client-2.25.1.jar:/opt/traccar/lib/jersey-media-jaxb-2.25.1.jar:/opt/traccar/lib/validation-api-1.1.0.Final.jar:/opt/traccar/lib/javax.ws.rs-api-2.0.1.jar:/opt/traccar/lib/jersey-media-json-jackson-2.25.1.jar:/opt/traccar/lib/jersey-entity-filtering-2.25.1.jar:/opt/traccar/lib/jackson-jaxrs-base-2.8.4.jar:/opt/traccar/lib/jackson-core-2.8.4.jar:/opt/traccar/lib/jackson-databind-2.8.4.jar:/opt/traccar/lib/jackson-jaxrs-json-provider-2.8.4.jar:/opt/traccar/lib/jackson-module-jaxb-annotations-2.8.4.jar:/opt/traccar/lib/jackson-annotations-2.8.4.jar:/opt/traccar/lib/liquibase-core-3.5.3.jar:/opt/traccar/lib/snakeyaml-1.17.jar:/opt/traccar/lib/mail-1.4.7.jar:/opt/traccar/lib/activation-1.1.jar:/opt/traccar/lib/jxls-2.4.2.jar:/opt/traccar/lib/commons-jexl-2.1.1.jar:/opt/traccar/lib/commons-beanutils-1.9.2.jar:/opt/traccar/lib/jcl-over-slf4j-1.7.12.jar:/opt/traccar/lib/logback-core-1.1.3.jar:/opt/traccar/lib/jxls-poi-1.0.13.jar:/opt/traccar/lib/poi-3.16.jar:/opt/traccar/lib/poi-ooxml-3.16.jar:/opt/traccar/lib/poi-ooxml-schemas-3.16.jar:/opt/traccar/lib/xmlbeans-2.6.0.jar:/opt/traccar/lib/stax-api-1.0.1.jar:/opt/traccar/lib/curvesapi-1.04.jar:/opt/traccar/lib/velocity-1.7.jar:/opt/traccar/lib/commons-collections-3.2.1.jar:/opt/traccar/lib/commons-lang-2.4.jar:/opt/traccar/lib/velocity-tools-2.0.jar:/opt/traccar/lib/commons-digester-1.8.jar:/opt/traccar/lib/commons-chain-1.1.jar:/opt/traccar/lib/commons-logging-1.1.jar:/opt/traccar/lib/servlet-api-2.3.jar:/opt/traccar/lib/commons-validator-1.3.1.jar:/opt/traccar/lib/dom4j-1.1.jar:/opt/traccar/lib/oro-2.0.8.jar:/opt/traccar/lib/sslext-1.2-0.jar:/opt/traccar/lib/struts-core-1.3.8.jar:/opt/traccar/lib/antlr-2.7.2.jar:/opt/traccar/lib/struts-taglib-1.3.8.jar:/opt/traccar/lib/struts-tiles-1.3.8.jar:/opt/traccar/lib/commons-collections4-4.1.jar:/opt/traccar/lib/ical4j-2.0.4.jar:/opt/traccar/lib/commons-codec-1.9.jar:/opt/traccar/lib/commons-lang3-3.3.2.jar:/opt/traccar/lib/threetenbp-1.3.3.jar:/opt/traccar/lib/ch-smpp-5.0.9.jar:/opt/traccar/lib/ch-commons-util-6.0.2.jar:/opt/traccar/lib/ch-commons-charset-3.0.2.jar -Dfile.encoding=UTF-8 -Xrs -Dwrapper.service=true -Dwrapper.console.visible=false -Dwrapper.port=15003 -Dwrapper.key=8126957839508913636 -Dwrapper.teeName=8126957839508913636$1517378140069 -Dwrapper.tmp.path=/opt/traccar/tmp -Djna_tmpdir=/opt/traccar/tmp -Dwrapper.config=/opt/traccar/conf/wrapper.conf -Dwrapper.visible=false -Dwrapper.pidfile=/run/wrapper.traccar.pid org.rzo.yajsw.app.WrapperJVMMain 
INFO|wrapper|Service traccar|18-01-31 07:55:41|posix_spawn pid 1477
INFO|wrapper|Service traccar|18-01-31 07:55:41|started process 1477
INFO|wrapper|Service traccar|18-01-31 07:55:41|started process with pid 1477
INFO|1477/0|Service traccar|18-01-31 07:55:46|[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store.
INFO|1477/0|Service traccar|18-01-31 07:55:48|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|1477/0|Service traccar|18-01-31 07:55:49|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
INFO|1477/0|Service traccar|18-01-31 07:55:49|INFO 1/31/18 7:55 AM: liquibase: Clearing database change log checksums
INFO|1477/0|Service traccar|18-01-31 07:55:49|INFO 1/31/18 7:55 AM: liquibase: Successfully acquired change log lock
INFO|1477/0|Service traccar|18-01-31 07:55:50|INFO 1/31/18 7:55 AM: liquibase: Successfully released change log lock
INFO|1477/0|Service traccar|18-01-31 07:55:50|INFO 1/31/18 7:55 AM: liquibase: Successfully acquired change log lock
INFO|1477/0|Service traccar|18-01-31 07:55:52|INFO 1/31/18 7:55 AM: liquibase: Reading from PUBLIC.DATABASECHANGELOG
INFO|1477/0|Service traccar|18-01-31 07:55:52|INFO 1/31/18 7:55 AM: liquibase: Reading from PUBLIC.DATABASECHANGELOG
INFO|1477/0|Service traccar|18-01-31 07:55:52|SEVERE 1/31/18 7:55 AM: liquibase: ./schema/changelog-master.xml: changelog-3.7::changelog-3.7::author: Change Set changelog-3.7::changelog-3.7::author failed.  Error: Table "DEVICES" not found; SQL statement:
INFO|1477/0|Service traccar|18-01-31 07:55:52|UPDATE PUBLIC.devices SET groupid = NULL WHERE groupid NOT IN (SELECT id FROM groups) [42102-196] [Failed SQL: UPDATE PUBLIC.devices SET groupid = NULL WHERE groupid NOT IN (SELECT id FROM groups)]
INFO|1477/0|Service traccar|18-01-31 07:55:52|INFO 1/31/18 7:55 AM: liquibase: changelog-3.7::changelog-3.7::author: Successfully released change log lock
INFO|1477/0|Service traccar|18-01-31 07:55:52|java.lang.reflect.InvocationTargetException
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at java.lang.reflect.Method.invoke(Method.java:498)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|1477/0|Service traccar|18-01-31 07:55:52|Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set changelog-3.7::changelog-3.7::author:
INFO|1477/0|Service traccar|18-01-31 07:55:52|     Reason: liquibase.exception.DatabaseException: Table "DEVICES" not found; SQL statement:
INFO|1477/0|Service traccar|18-01-31 07:55:52|UPDATE PUBLIC.devices SET groupid = NULL WHERE groupid NOT IN (SELECT id FROM groups) [42102-196] [Failed SQL: UPDATE PUBLIC.devices SET groupid = NULL WHERE groupid NOT IN (SELECT id FROM groups)]
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:619)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at liquibase.Liquibase.update(Liquibase.java:214)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at liquibase.Liquibase.update(Liquibase.java:192)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at liquibase.Liquibase.update(Liquibase.java:188)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:300)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.traccar.database.DataManager.<init>(DataManager.java:87)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.traccar.Context.init(Context.java:333)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.traccar.Main.main(Main.java:35)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	... 6 more
INFO|1477/0|Service traccar|18-01-31 07:55:52|Caused by: liquibase.exception.DatabaseException: Table "DEVICES" not found; SQL statement:
INFO|1477/0|Service traccar|18-01-31 07:55:52|UPDATE PUBLIC.devices SET groupid = NULL WHERE groupid NOT IN (SELECT id FROM groups) [42102-196] [Failed SQL: UPDATE PUBLIC.devices SET groupid = NULL WHERE groupid NOT IN (SELECT id FROM groups)]
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:309)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:113)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1277)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1259)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:582)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	... 15 more
INFO|1477/0|Service traccar|18-01-31 07:55:52|Caused by: org.h2.jdbc.JdbcSQLException: Table "DEVICES" not found; SQL statement:
INFO|1477/0|Service traccar|18-01-31 07:55:52|UPDATE PUBLIC.devices SET groupid = NULL WHERE groupid NOT IN (SELECT id FROM groups) [42102-196]
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.h2.message.DbException.get(DbException.java:179)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.h2.message.DbException.get(DbException.java:155)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.h2.schema.Schema.getTableOrView(Schema.java:456)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.h2.command.Parser.readTableOrView(Parser.java:5535)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.h2.command.Parser.readTableOrView(Parser.java:5529)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.h2.command.Parser.readSimpleTableFilter(Parser.java:796)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.h2.command.Parser.parseUpdate(Parser.java:739)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.h2.command.Parser.parsePrepared(Parser.java:471)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.h2.command.Parser.parse(Parser.java:321)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.h2.command.Parser.parse(Parser.java:293)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.h2.command.Parser.prepareCommand(Parser.java:258)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.h2.engine.Session.prepareLocal(Session.java:578)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.h2.engine.Session.prepareCommand(Session.java:519)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:176)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:164)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:307)
INFO|1477/0|Service traccar|18-01-31 07:55:52|	... 20 more
INFO|wrapper|Service traccar|18-01-31 07:55:53|waitpid 1477 59136
INFO|wrapper|Service traccar|18-01-31 07:55:53|exit code posix process: 59136 application: 231
WARNING|wrapper|Service traccar|18-01-31 08:20:31|YAJSW: yajsw-stable-12.11
WARNING|wrapper|Service traccar|18-01-31 08:20:31|OS   : Linux/4.9.0-4-amd64/amd64
WARNING|wrapper|Service traccar|18-01-31 08:20:31|JVM  : Oracle Corporation/1.8.0_151//usr/lib/jvm/java-8-openjdk-amd64/jre/64
INFO|wrapper|Service traccar|18-01-31 08:20:31|exec:java -classpath /opt/traccar/wrapperApp.jar:/opt/traccar/tracker-server.jar:/opt/traccar/lib/log4j-1.2.17.jar:/opt/traccar/lib/joda-time-2.9.9.jar:/opt/traccar/lib/h2-1.4.196.jar:/opt/traccar/lib/mysql-connector-java-5.1.45.jar:/opt/traccar/lib/postgresql-42.1.4.jre7.jar:/opt/traccar/lib/mssql-jdbc-6.2.2.jre7.jar:/opt/traccar/lib/HikariCP-java7-2.4.13.jar:/opt/traccar/lib/slf4j-api-1.7.21.jar:/opt/traccar/lib/netty-3.10.6.Final.jar:/opt/traccar/lib/async-http-client-1.9.40.jar:/opt/traccar/lib/slf4j-simple-1.7.25.jar:/opt/traccar/lib/javax.json-1.0.4.jar:/opt/traccar/lib/jetty-server-9.2.22.v20170606.jar:/opt/traccar/lib/javax.servlet-api-3.1.0.jar:/opt/traccar/lib/jetty-http-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-io-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-servlet-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-security-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-webapp-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-xml-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-jndi-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-util-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-proxy-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-client-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-server-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-common-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-api-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-client-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-servlet-9.2.22.v20170606.jar:/opt/traccar/lib/jersey-container-servlet-2.25.1.jar:/opt/traccar/lib/jersey-container-servlet-core-2.25.1.jar:/opt/traccar/lib/javax.inject-2.5.0-b32.jar:/opt/traccar/lib/jersey-common-2.25.1.jar:/opt/traccar/lib/javax.annotation-api-1.2.jar:/opt/traccar/lib/jersey-guava-2.25.1.jar:/opt/traccar/lib/hk2-api-2.5.0-b32.jar:/opt/traccar/lib/hk2-utils-2.5.0-b32.jar:/opt/traccar/lib/aopalliance-repackaged-2.5.0-b32.jar:/opt/traccar/lib/hk2-locator-2.5.0-b32.jar:/opt/traccar/lib/javassist-3.20.0-GA.jar:/opt/traccar/lib/osgi-resource-locator-1.0.1.jar:/opt/traccar/lib/jersey-server-2.25.1.jar:/opt/traccar/lib/jersey-client-2.25.1.jar:/opt/traccar/lib/jersey-media-jaxb-2.25.1.jar:/opt/traccar/lib/validation-api-1.1.0.Final.jar:/opt/traccar/lib/javax.ws.rs-api-2.0.1.jar:/opt/traccar/lib/jersey-media-json-jackson-2.25.1.jar:/opt/traccar/lib/jersey-entity-filtering-2.25.1.jar:/opt/traccar/lib/jackson-jaxrs-base-2.8.4.jar:/opt/traccar/lib/jackson-core-2.8.4.jar:/opt/traccar/lib/jackson-databind-2.8.4.jar:/opt/traccar/lib/jackson-jaxrs-json-provider-2.8.4.jar:/opt/traccar/lib/jackson-module-jaxb-annotations-2.8.4.jar:/opt/traccar/lib/jackson-annotations-2.8.4.jar:/opt/traccar/lib/liquibase-core-3.5.3.jar:/opt/traccar/lib/snakeyaml-1.17.jar:/opt/traccar/lib/mail-1.4.7.jar:/opt/traccar/lib/activation-1.1.jar:/opt/traccar/lib/jxls-2.4.2.jar:/opt/traccar/lib/commons-jexl-2.1.1.jar:/opt/traccar/lib/commons-beanutils-1.9.2.jar:/opt/traccar/lib/jcl-over-slf4j-1.7.12.jar:/opt/traccar/lib/logback-core-1.1.3.jar:/opt/traccar/lib/jxls-poi-1.0.13.jar:/opt/traccar/lib/poi-3.16.jar:/opt/traccar/lib/poi-ooxml-3.16.jar:/opt/traccar/lib/poi-ooxml-schemas-3.16.jar:/opt/traccar/lib/xmlbeans-2.6.0.jar:/opt/traccar/lib/stax-api-1.0.1.jar:/opt/traccar/lib/curvesapi-1.04.jar:/opt/traccar/lib/velocity-1.7.jar:/opt/traccar/lib/commons-collections-3.2.1.jar:/opt/traccar/lib/commons-lang-2.4.jar:/opt/traccar/lib/velocity-tools-2.0.jar:/opt/traccar/lib/commons-digester-1.8.jar:/opt/traccar/lib/commons-chain-1.1.jar:/opt/traccar/lib/commons-logging-1.1.jar:/opt/traccar/lib/servlet-api-2.3.jar:/opt/traccar/lib/commons-validator-1.3.1.jar:/opt/traccar/lib/dom4j-1.1.jar:/opt/traccar/lib/oro-2.0.8.jar:/opt/traccar/lib/sslext-1.2-0.jar:/opt/traccar/lib/struts-core-1.3.8.jar:/opt/traccar/lib/antlr-2.7.2.jar:/opt/traccar/lib/struts-taglib-1.3.8.jar:/opt/traccar/lib/struts-tiles-1.3.8.jar:/opt/traccar/lib/commons-collections4-4.1.jar:/opt/traccar/lib/ical4j-2.0.4.jar:/opt/traccar/lib/commons-codec-1.9.jar:/opt/traccar/lib/commons-lang3-3.3.2.jar:/opt/traccar/lib/threetenbp-1.3.3.jar:/opt/traccar/lib/ch-smpp-5.0.9.jar:/opt/traccar/lib/ch-commons-util-6.0.2.jar:/opt/traccar/lib/ch-commons-charset-3.0.2.jar -Dfile.encoding=UTF-8 -Xrs -Dwrapper.service=true -Dwrapper.console.visible=false -Dwrapper.port=15003 -Dwrapper.key=-4336484413157688631 -Dwrapper.teeName=-4336484413157688631$1517379630305 -Dwrapper.tmp.path=/opt/traccar/tmp -Djna_tmpdir=/opt/traccar/tmp -Dwrapper.config=/opt/traccar/conf/wrapper.conf -Dwrapper.visible=false -Dwrapper.pidfile=/run/wrapper.traccar.pid org.rzo.yajsw.app.WrapperJVMMain 
INFO|wrapper|Service traccar|18-01-31 08:20:31|posix_spawn pid 2743
INFO|wrapper|Service traccar|18-01-31 08:20:31|started process 2743
INFO|wrapper|Service traccar|18-01-31 08:20:31|started process with pid 2743
INFO|2743/0|Service traccar|18-01-31 08:20:36|[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store.
INFO|2743/0|Service traccar|18-01-31 08:20:37|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|2743/0|Service traccar|18-01-31 08:20:38|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
INFO|2743/0|Service traccar|18-01-31 08:20:39|INFO 1/31/18 8:20 AM: liquibase: Clearing database change log checksums
INFO|2743/0|Service traccar|18-01-31 08:20:39|INFO 1/31/18 8:20 AM: liquibase: Successfully acquired change log lock
INFO|2743/0|Service traccar|18-01-31 08:20:39|INFO 1/31/18 8:20 AM: liquibase: Successfully released change log lock
INFO|2743/0|Service traccar|18-01-31 08:20:39|INFO 1/31/18 8:20 AM: liquibase: Successfully acquired change log lock
INFO|2743/0|Service traccar|18-01-31 08:20:41|INFO 1/31/18 8:20 AM: liquibase: Reading from PUBLIC.DATABASECHANGELOG
INFO|2743/0|Service traccar|18-01-31 08:20:41|INFO 1/31/18 8:20 AM: liquibase: Reading from PUBLIC.DATABASECHANGELOG
INFO|2743/0|Service traccar|18-01-31 08:20:41|SEVERE 1/31/18 8:20 AM: liquibase: ./schema/changelog-master.xml: changelog-3.7::changelog-3.7::author: Change Set changelog-3.7::changelog-3.7::author failed.  Error: Table "DEVICES" not found; SQL statement:
INFO|2743/0|Service traccar|18-01-31 08:20:41|UPDATE PUBLIC.devices SET groupid = NULL WHERE groupid NOT IN (SELECT id FROM groups) [42102-196] [Failed SQL: UPDATE PUBLIC.devices SET groupid = NULL WHERE groupid NOT IN (SELECT id FROM groups)]
INFO|2743/0|Service traccar|18-01-31 08:20:41|INFO 1/31/18 8:20 AM: liquibase: changelog-3.7::changelog-3.7::author: Successfully released change log lock
INFO|2743/0|Service traccar|18-01-31 08:20:41|java.lang.reflect.InvocationTargetException
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at java.lang.reflect.Method.invoke(Method.java:498)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|2743/0|Service traccar|18-01-31 08:20:41|Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set changelog-3.7::changelog-3.7::author:
INFO|2743/0|Service traccar|18-01-31 08:20:41|     Reason: liquibase.exception.DatabaseException: Table "DEVICES" not found; SQL statement:
INFO|2743/0|Service traccar|18-01-31 08:20:41|UPDATE PUBLIC.devices SET groupid = NULL WHERE groupid NOT IN (SELECT id FROM groups) [42102-196] [Failed SQL: UPDATE PUBLIC.devices SET groupid = NULL WHERE groupid NOT IN (SELECT id FROM groups)]
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:619)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at liquibase.Liquibase.update(Liquibase.java:214)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at liquibase.Liquibase.update(Liquibase.java:192)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at liquibase.Liquibase.update(Liquibase.java:188)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:300)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.traccar.database.DataManager.<init>(DataManager.java:87)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.traccar.Context.init(Context.java:333)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.traccar.Main.main(Main.java:35)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	... 6 more
INFO|2743/0|Service traccar|18-01-31 08:20:41|Caused by: liquibase.exception.DatabaseException: Table "DEVICES" not found; SQL statement:
INFO|2743/0|Service traccar|18-01-31 08:20:41|UPDATE PUBLIC.devices SET groupid = NULL WHERE groupid NOT IN (SELECT id FROM groups) [42102-196] [Failed SQL: UPDATE PUBLIC.devices SET groupid = NULL WHERE groupid NOT IN (SELECT id FROM groups)]
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:309)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:113)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1277)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1259)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:582)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	... 15 more
INFO|2743/0|Service traccar|18-01-31 08:20:41|Caused by: org.h2.jdbc.JdbcSQLException: Table "DEVICES" not found; SQL statement:
INFO|2743/0|Service traccar|18-01-31 08:20:41|UPDATE PUBLIC.devices SET groupid = NULL WHERE groupid NOT IN (SELECT id FROM groups) [42102-196]
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.h2.message.DbException.get(DbException.java:179)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.h2.message.DbException.get(DbException.java:155)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.h2.schema.Schema.getTableOrView(Schema.java:456)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.h2.command.Parser.readTableOrView(Parser.java:5535)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.h2.command.Parser.readTableOrView(Parser.java:5529)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.h2.command.Parser.readSimpleTableFilter(Parser.java:796)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.h2.command.Parser.parseUpdate(Parser.java:739)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.h2.command.Parser.parsePrepared(Parser.java:471)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.h2.command.Parser.parse(Parser.java:321)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.h2.command.Parser.parse(Parser.java:293)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.h2.command.Parser.prepareCommand(Parser.java:258)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.h2.engine.Session.prepareLocal(Session.java:578)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.h2.engine.Session.prepareCommand(Session.java:519)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:176)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:164)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:307)
INFO|2743/0|Service traccar|18-01-31 08:20:41|	... 20 more
INFO|wrapper|Service traccar|18-01-31 08:20:42|waitpid 2743 59136
INFO|wrapper|Service traccar|18-01-31 08:20:42|exit code posix process: 59136 application: 231

Sorry for the long post.
Thank You.

Anton Tananaev7 years ago

Looks like your database is corrupted for whatever reason. I would recommend to remove everything and start from scratch.

VZ7 years ago

Thanks for your quick response.
Is it right to erase just the folder "traccar" from "/opt" and re-installed, or i must follow another procedure?

Anton Tananaev7 years ago

There is documentation for removing/uninstalling Traccar. Follow it!

VZ7 years ago

I had follow the procedure and with the new installation seems that the problem with the Database solved but still i haven't access to "localhost:8082". I am giving you the new wrapper log. I looked it and one think that i found is a line with a failed to bind 0.0.0.0:5006. (When i am typing "locahost:5006" i am getting the default page of Apache2 - is this ok?).

Sorry for all this these lines, if there is a way to give you the hole file and not the lines of it please inform me about the procedure.

The New Wrapper log file is:

WARNING|wrapper|Service traccar|18-01-31 09:42:25|YAJSW: yajsw-stable-12.11
...
FINEST|3815/0|Service traccar|18-01-31 09:42:34|INFO 1/31/18 9:42 AM: liquibase: Successfully released change log lock
FINEST|3815/0|Service traccar|18-01-31 09:42:35|[main] INFO org.eclipse.jetty.util.log - Logging initialized @7934ms
FINEST|3815/0|Service traccar|18-01-31 09:42:36|java.lang.reflect.InvocationTargetException
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at java.lang.reflect.Method.invoke(Method.java:498)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|Caused by: org.jboss.netty.channel.ChannelException: Failed to bind to: 0.0.0.0/0.0.0.0:5006
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at org.jboss.netty.bootstrap.ServerBootstrap.bind(ServerBootstrap.java:272)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at org.traccar.TrackerServer.start(TrackerServer.java:117)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at org.traccar.ServerManager.start(ServerManager.java:81)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at org.traccar.Main.main(Main.java:38)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	... 6 more
FINEST|3815/0|Service traccar|18-01-31 09:42:36|Caused by: java.net.BindException: Address already in use
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at sun.nio.ch.Net.listen(Native Method)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:224)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at org.jboss.netty.channel.socket.nio.NioServerBoss$RegisterTask.run(NioServerBoss.java:193)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at org.jboss.netty.channel.socket.nio.AbstractNioSelector.processTaskQueue(AbstractNioSelector.java:391)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:315)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at org.jboss.netty.channel.socket.nio.NioServerBoss.run(NioServerBoss.java:42)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
FINEST|3815/0|Service traccar|18-01-31 09:42:36|	at java.lang.Thread.run(Thread.java:748)
INFO|wrapper|Service traccar|18-01-31 09:42:36|waitpid 3815 59136
INFO|wrapper|Service traccar|18-01-31 09:42:36|exit code posix process: 59136 application: 231

Can you see something that i missed it?

VZ7 years ago

Finally i change the port that Apache is listening and worked.

Thanks for your help.