localhost:8082 not working

Daniel Bonifacio 8 years ago

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 Tananaev 8 years ago

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

Daniel Bonifacio 8 years ago

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

Anton Tananaev 8 years ago

Then you should check wrapper.log.

Daniel Bonifacio 8 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 Tananaev 8 years ago

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

Daniel Bonifacio 8 years ago

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

VZ 8 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 Tananaev 8 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.

VZ 8 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 Tananaev 8 years ago

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

VZ 8 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 Tananaev 8 years ago

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

VZ 8 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?

VZ 8 years ago

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

Thanks for your help.