Traccar Services fails
Someone has made a loop with groups. You need to manually remove that loop.
Also, it means that you are using old version of Traccar.
Thanks Anton, If I wanted to update Traccar will I have to uninstall the 3.5 version and install 3.6 version. or can I just install the 3.6 and it will update. Will this affect any other configs such as the ports the admin of the server opened for the Services to receive data from GPS devices.
If you just install new version, it will overwrite config file, but any database changes should persist. Don't forget to make backups before updating anything.
Hi Anton, is there documentation on how i can manually remove the group from the H2 database?
I am not familiar with the embedded H2 DB and so I attempted to change config to use a SQL Server Database engine instead. I followed the steps here https://www.traccar.org/ms-sql/ and now when I start the service it fails to start and I get following message:
"Windows could not start the Traccar on Local Computer. For more information, review the system event log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 1."
IGNORE ABOVE: Found that the user I created for Traccar can't login to the SQL Server DB Engine. working on this now, I will update this when all good and working
Ok so I tried using a username that can connect to the Database Engine in SQL Server Management Studio and works fine. I used that same user details in traccar config file and when i check the wrapper.log file i still get the login failed message. here is wrapper.log content, I must be reading the error incorrectly please help:
STATUS | wrapper | 2016/07/20 11:31:51 | --> Wrapper Started as Service STATUS | wrapper | 2016/07/20 11:31:51 | Java Service Wrapper Community Edition 32-bit 3.5.28 STATUS | wrapper | 2016/07/20 11:31:51 | Copyright (C) 1999-2016 Tanuki Software, Ltd. All Rights Reserved. STATUS | wrapper | 2016/07/20 11:31:51 | http://wrapper.tanukisoftware.com STATUS | wrapper | 2016/07/20 11:31:51 | STATUS | wrapper | 2016/07/20 11:31:51 | Launching a JVM... INFO | jvm 1 | 2016/07/20 11:31:52 | WrapperManager: Initializing... INFO | jvm 1 | 2016/07/20 11:31:52 | [WrapperSimpleAppMain] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Started. INFO | jvm 1 | 2016/07/20 11:31:53 | [WrapperSimpleAppMain] INFO com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Close initiated... INFO | jvm 1 | 2016/07/20 11:31:53 | [WrapperSimpleAppMain] INFO com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Closed. INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp: INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: Encountered an error running main: INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Login failed for user 'tamati'. ClientConnectionId:6dc870c3-d7da-42ec-95d3-9b1ef2478966 INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:516) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:118) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:71) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at org.traccar.database.DataManager.initDatabase(DataManager.java:134) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at org.traccar.database.DataManager.<init>(DataManager.java:87) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at org.traccar.Context.init(Context.java:136) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at org.traccar.Main.main(Main.java:30) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at java.lang.reflect.Method.invoke(Unknown Source) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:325) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at java.lang.Thread.run(Unknown Source) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'tamati'. ClientConnectionId:6dc870c3-d7da-42ec-95d3-9b1ef2478966 INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:316) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:506) INFO | jvm 1 | 2016/07/20 11:31:53 | WrapperSimpleApp Error: ... 12 more STATUS | wrapper | 2016/07/20 11:31:55 | <-- Wrapper Stopped
You are reading it correctly. Traccar is not able to connect to the server.
Maybe this would help:
Thanks so much Anton for your help I solved my issue.
My Fix to get services running again:
- Intalled latest version 3.6
- Change config file to use SQL Server Database Engine https://www.traccar.org/ms-sql/
(When I did above step my old data wasn't moved over to SQL Server Database Engine so have a fresh database and have to add my devices back in. This fixes the looping Groups that someone made.)
To solve my failed to login error on SQL Server DB when traccar starts I simply followed the steps provided here https://support.microsoft.com/en-us/kb/555332
Restarted SQL Server Service. Then started Traccar Service and all good now. (Note: make sure user has access to create tables and insert/update)
Thanks again Anton.
When I start the service it runs about a second or 2 later it stops.
It was working yesterday and managed to add some devices and track them. The last known actions done was one of the users added a device and added another user. I logged in to check out the new device and couldn't see any of the devices even the ones i added in. I couldn't make any adjustments to users as when i select save i got error "Request failed". So I thought a restart of the service would help. did that and the service wouldn't start. Had a look in the wrapper.log file but can't dig out exactly what the issue is. can someone help with the issue. Below is the content of wrapper.log file
STATUS | wrapper | 2016/07/19 08:30:35 | --> Wrapper Started as Service STATUS | wrapper | 2016/07/19 08:30:35 | Java Service Wrapper Community Edition 32-bit 3.5.28 STATUS | wrapper | 2016/07/19 08:30:35 | Copyright (C) 1999-2016 Tanuki Software, Ltd. All Rights Reserved. STATUS | wrapper | 2016/07/19 08:30:35 | http://wrapper.tanukisoftware.com STATUS | wrapper | 2016/07/19 08:30:35 | STATUS | wrapper | 2016/07/19 08:30:36 | Launching a JVM... INFO | jvm 1 | 2016/07/19 08:30:36 | WrapperManager: Initializing... INFO | jvm 1 | 2016/07/19 08:30:37 | [MLog-Init-Reporter] INFO com.mchange.v2.log.MLog - MLog clients using slf4j logging. INFO | jvm 1 | 2016/07/19 08:30:37 | [WrapperSimpleAppMain] INFO com.mchange.v2.c3p0.C3P0Registry - Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10] INFO | jvm 1 | 2016/07/19 08:30:39 | INFO 7/19/16 8:30 AM: liquibase: Clearing database change log checksums INFO | jvm 1 | 2016/07/19 08:30:39 | INFO 7/19/16 8:30 AM: liquibase: Successfully acquired change log lock INFO | jvm 1 | 2016/07/19 08:30:39 | INFO 7/19/16 8:30 AM: liquibase: Successfully released change log lock INFO | jvm 1 | 2016/07/19 08:30:39 | INFO 7/19/16 8:30 AM: liquibase: Successfully acquired change log lock INFO | jvm 1 | 2016/07/19 08:30:41 | INFO 7/19/16 8:30 AM: liquibase: Reading from PUBLIC.DATABASECHANGELOG INFO | jvm 1 | 2016/07/19 08:30:41 | INFO 7/19/16 8:30 AM: liquibase: Reading from PUBLIC.DATABASECHANGELOG INFO | jvm 1 | 2016/07/19 08:30:41 | INFO 7/19/16 8:30 AM: liquibase: Successfully released change log lock INFO | jvm 1 | 2016/07/19 08:30:42 | [WrapperSimpleAppMain] INFO com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 2sa1i99i186ufjyrrij3|1e74dff, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> org.h2.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 2sa1i99i186ufjyrrij3|1e74dff, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:h2:C:\Program Files\Traccar\data\database, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> true, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ] INFO | jvm 1 | 2016/07/19 08:30:42 | WrapperSimpleApp: INFO | jvm 1 | 2016/07/19 08:30:42 | WrapperSimpleApp Error: Encountered an error running main: INFO | jvm 1 | 2016/07/19 08:30:42 | WrapperSimpleApp Error: java.lang.StackOverflowError INFO | jvm 1 | 2016/07/19 08:30:42 | WrapperSimpleApp Error: at java.util.HashMap.putVal(Unknown Source) INFO | jvm 1 | 2016/07/19 08:30:42 | WrapperSimpleApp Error: at java.util.HashMap.put(Unknown Source) INFO | jvm 1 | 2016/07/19 08:30:42 | WrapperSimpleApp Error: at java.util.HashSet.add(Unknown Source) INFO | jvm 1 | 2016/07/19 08:30:42 | WrapperSimpleApp Error: at org.traccar.database.GroupTree.getNodes(GroupTree.java:144) INFO | jvm 1 | 2016/07/19 08:30:42 | WrapperSimpleApp Error: at org.traccar.database.GroupTree.getNodes(GroupTree.java:145) INFO | jvm 1 | 2016/07/19 08:30:42 | WrapperSimpleApp Error: at org.traccar.database.GroupTree.getNodes(GroupTree.java:145) INFO | jvm 1 | 2016/07/19 08:30:42 | WrapperSimpleApp Error: at org.traccar.database.GroupTree.getNodes(GroupTree.java:145) INFO | jvm 1 | 2016/07/19 08:30:42 | WrapperSimpleApp Error: at org.traccar.database.GroupTree.getNodes(GroupTree.java:145) INFO | jvm 1 | 2016/07/19 08:30:42 | WrapperSimpleApp Error: at org.traccar.database.GroupTree.getNodes(GroupTree.java:145) INFO | jvm 1 | 2016/07/19 08:30:42 | WrapperSimpleApp Error: at org.traccar.database.GroupTree.getNodes(GroupTree.java:145) INFO | jvm 1 | 2016/07/19 08:30:42 | WrapperSimpleApp Error: at org.traccar.database.GroupTree.getNodes(GroupTree.java:145) INFO | jvm 1 | 2016/07/19 08:30:42 | WrapperSimpleApp Error: at org.traccar.database.GroupTree.getNodes(GroupTree.java:145) INFO | jvm 1 | 2016/07/19 08:30:42 | WrapperSimpleApp Error: at org.traccar.database.GroupTree.getNodes(GroupTree.java:145) INFO | jvm 1 | 2016/07/19 08:30:42 | WrapperSimpleApp Error: at org.traccar.database.GroupTree.getNodes(GroupTree.java:145) INFO | jvm 1 | 2016/07/19 08:30:42 | WrapperSimpleApp Error: at org.traccar.database.GroupTree.getNodes(GroupTree.java:145) STATUS | wrapper | 2016/07/19 08:30:44 | <-- Wrapper Stopped