After installing MSSQL 2008 not able to run the traccar services

kundan2546 years ago

I have installed MS SQL server for Database. 

    <entry key='database.driver'>com.microsoft.sqlserver.jdbc.SQLServerDriver</entry>
    <entry key='database.url'>jdbc:sqlserver://161.117.10.116\SQLEXPRESS];user=Administrator;password=******;databaseName=traccar;</entry>
    <entry key='database.user'>Administrator</entry>
    <entry key='database.password'>*******</entry>

When i restart the Traccar server from Services.msc in winsrv2008, http://161.117.10.116:8082/ stop working.

Any idea? Sorry if i asked silly ques. New to development.

kundan2546 years ago
2018-06-11 12:19:19 DEBUG: [56ECD6A1: 5055 > 127.0.0.1] HEX: 485454502f312e3120323030204f4b0d0a436f6e74656e742d4c656e6774683a20300d0a0d0a
2018-06-11 12:19:19 DEBUG: [56ECD6A1: 5055 < 127.0.0.1] HEX: 300d0a0d0a
2018-06-11 12:19:19  WARN: [56ECD6A1] error - org.jboss.netty.handler.codec.http.HttpChunk$1 cannot be cast to org.jboss.netty.handler.codec.http.HttpRequest - ClassCastException (OsmAndProtocolDecoder:48 < ExtendedObjectDecoder:58 < ...)
2018-06-11 12:19:19  INFO: [56ECD6A1] disconnected
2018-06-11 12:19:19  INFO: [56ECD6A1] id: 856944, time: 2018-06-11 12:19:19, lat: 18.55621, lon: 73.89179, course: 0.0, accuracy: 24.0
2018-06-11 12:19:30  INFO: Shutting down server...
2018-06-11 12:19:30  INFO: [A1D97943] disconnected

ERR_CONNECTION_REFUSED : in browser.
From Services, its stays starting > started > Stopped within 2 sec.

Anton Tananaev6 years ago

You are looking at the wrong log file.

kundan2546 years ago

Hi Anton,

Can you please guide me for that?
Below wrapper.log

Thanks in advance.

...
INFO|3244/0|Service traccar|18-06-11 10:52:24|[main] INFO org.eclipse.jetty.server.Server - Started @5874ms
INFO|wrapper|Service traccar|18-06-11 11:09:42|Win service stop - timeout: 30000
INFO|wrapper|Service traccar|18-06-11 11:09:42|Win service wrapper.control -> stopping application
INFO|wrapper|Service traccar|18-06-11 11:09:42|stopping process with pid/timeout 3244 45000
INFO|3244/0|Service traccar|18-06-11 11:09:42|[Thread-13] INFO org.eclipse.jetty.server.ServerConnector - Stopped ServerConnector@22da2fe6{HTTP/1.1}{0.0.0.0:8082}
INFO|3244/0|Service traccar|18-06-11 11:09:42|[Thread-13] INFO org.eclipse.jetty.server.handler.ContextHandler - Stopped o.t.w.@519c6fcc{/,null,UNAVAILABLE}
INFO|3244/0|Service traccar|18-06-11 11:09:42|[Thread-13] INFO org.eclipse.jetty.server.handler.ContextHandler - Stopped o.e.j.s.ServletContextHandler@37a0ec3c{/api,null,UNAVAILABLE}
INFO|3244/0|Service traccar|18-06-11 11:09:43|wrapper manager received stop command
INFO|wrapper|Service traccar|18-06-11 11:09:44|process exit code: 0
INFO|wrapper|Service traccar|18-06-11 11:09:44|Win service stop - after shutdown
INFO|wrapper|Service traccar|18-06-11 11:09:44|Win service stop - before notify
INFO|wrapper|Service traccar|18-06-11 11:09:44|Win service terminated
WARNING|wrapper|Service traccar|18-06-11 11:09:45|YAJSW: yajsw-stable-12.12
WARNING|wrapper|Service traccar|18-06-11 11:09:45|OS   : Windows Server 2008 R2/6.1/amd64
WARNING|wrapper|Service traccar|18-06-11 11:09:45|JVM  : Oracle Corporation/1.8.0_171/C:\Program Files\Java\jre1.8.0_171/64
INFO|wrapper|Service traccar|18-06-11 11:09:45|start delay: 0
Anton Tananaev6 years ago

Looks like you don't have enough resources:

Win service stop - timeout: 30000
kundan2546 years ago

I doubt regarding lack of resources. I'm using WIN SRV 2008, MS SQL 2008 and 4 GB RAM.

Below is the new logs. :( 

FINEST|1796/0|Service traccar|18-06-11 14:13:01|[main] INFO liquibase.database.core.UnsupportedDatabase - Error getting default schema
FINEST|1796/0|Service traccar|18-06-11 14:13:01|liquibase.exception.DatabaseException: Error executing SQL call current_schema: Could not find stored procedure 'call'.
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:100)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:135)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:146)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:154)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:169)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:164)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.database.AbstractJdbcDatabase.getConnectionSchemaName(AbstractJdbcDatabase.java:327)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.database.AbstractJdbcDatabase.getDefaultSchemaName(AbstractJdbcDatabase.java:292)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.database.AbstractJdbcDatabase.escapeObjectName(AbstractJdbcDatabase.java:870)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.database.AbstractJdbcDatabase.escapeTableName(AbstractJdbcDatabase.java:856)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.sqlgenerator.core.CreateTableGenerator.generateSql(CreateTableGenerator.java:39)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.sqlgenerator.core.CreateTableGenerator.generateSql(CreateTableGenerator.java:23)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.sqlgenerator.SqlGeneratorChain.generateSql(SqlGeneratorChain.java:30)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.sqlgenerator.SqlGeneratorFactory.generateSql(SqlGeneratorFactory.java:223)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.sqlgenerator.core.CreateDatabaseChangeLogLockTableGenerator.generateSql(CreateDatabaseChangeLogLockTableGenerator.java:32)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.sqlgenerator.core.CreateDatabaseChangeLogLockTableGenerator.generateSql(CreateDatabaseChangeLogLockTableGenerator.java:14)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.sqlgenerator.SqlGeneratorChain.generateSql(SqlGeneratorChain.java:30)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.sqlgenerator.SqlGeneratorFactory.generateSql(SqlGeneratorFactory.java:223)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.AbstractExecutor.applyVisitors(AbstractExecutor.java:25)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.jvm.JdbcExecutor.access$500(JdbcExecutor.java:38)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:338)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:109)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.lockservice.StandardLockService.init(StandardLockService.java:97)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:246)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:207)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.Liquibase.clearCheckSums(Liquibase.java:1442)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:304)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at org.traccar.database.DataManager.<init>(DataManager.java:88)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at org.traccar.Context.init(Context.java:353)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at org.traccar.Main.main(Main.java:35)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at java.lang.reflect.Method.invoke(Unknown Source)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure 'call'.
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:548)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:479)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7347)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:401)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.jvm.JdbcExecutor$QueryCallableStatementCallback.doInCallableStatement(JdbcExecutor.java:452)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:93)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	... 37 more
FINEST|1796/0|Service traccar|18-06-11 14:13:01|[main] INFO liquibase.executor.jvm.JdbcExecutor - CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED datetime, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))
FINEST|1796/0|Service traccar|18-06-11 14:13:01|java.lang.reflect.InvocationTargetException
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at java.lang.reflect.Method.invoke(Unknown Source)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|Caused by: liquibase.exception.LockException: liquibase.exception.DatabaseException: Column, parameter, or variable #2: Cannot find data type BOOLEAN. [Failed SQL: CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED datetime, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:289)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:207)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.Liquibase.clearCheckSums(Liquibase.java:1442)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:304)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at org.traccar.database.DataManager.<init>(DataManager.java:88)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at org.traccar.Context.init(Context.java:353)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at org.traccar.Main.main(Main.java:35)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	... 6 more
FINEST|1796/0|Service traccar|18-06-11 14:13:01|Caused by: liquibase.exception.DatabaseException: Column, parameter, or variable #2: Cannot find data type BOOLEAN. [Failed SQL: CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED datetime, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:109)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.lockservice.StandardLockService.init(StandardLockService.java:97)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:246)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	... 12 more
FINEST|1796/0|Service traccar|18-06-11 14:13:01|Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Column, parameter, or variable #2: Cannot find data type BOOLEAN.
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:857)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:757)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7347)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:734)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352)
FINEST|1796/0|Service traccar|18-06-11 14:13:01|	... 17 more
INFO|wrapper|Service traccar|18-06-11 14:13:01|calling onStop
INFO|wrapper|Service traccar|18-06-11 14:13:01|Win service stop - timeout: 30000
INFO|wrapper|Service traccar|18-06-11 14:13:01|Win service wrapper.control -> stopping application
INFO|wrapper|Service traccar|18-06-11 14:13:01|Win service stop - after shutdown
INFO|wrapper|Service traccar|18-06-11 14:13:01|Win service stop - before notify
INFO|wrapper|Service traccar|18-06-11 14:13:01|Win service terminated