I have it connecting and authenticating to the database, it creates the tables but then errors on this...
The Wrapper log:
INFO | jvm 1 | 2016/05/08 21:53:43 | INFO 5/8/16 9:53 PM: liquibase: C:/Program Files (x86)/Traccar/data/changelog-3.5.xml::changelog-3.5::author: Successfully released change log lock
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp:
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: Encountered an error running main:
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: liquibase.exception.MigrationFailedException: Migration failed for change set C:/Program Files (x86)/Traccar/data/changelog-3.5.xml::changelog-3.5::author:
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: Reason: liquibase.exception.DatabaseException: The object 'DF_users_language' is dependent on column 'language'. [Failed SQL: ALTER TABLE [dbo].[users] DROP COLUMN [language]]
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at liquibase.changelog.ChangeSet.execute(ChangeSet.java:590)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at liquibase.Liquibase.update(Liquibase.java:212)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at liquibase.Liquibase.update(Liquibase.java:192)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at liquibase.Liquibase.update(Liquibase.java:188)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:268)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at org.traccar.database.DataManager.<init>(DataManager.java:75)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at org.traccar.Context.init(Context.java:121)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at org.traccar.Main.main(Main.java:29)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at java.lang.reflect.Method.invoke(Unknown Source)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:325)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at java.lang.Thread.run(Unknown Source)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: Caused by: liquibase.exception.DatabaseException: The object 'DF_users_language' is dependent on column 'language'. [Failed SQL: ALTER TABLE [dbo].[users] DROP COLUMN [language]]
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:301)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1251)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1234)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at liquibase.changelog.ChangeSet.execute(ChangeSet.java:554)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: ... 15 more
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The object 'DF_users_language' is dependent on column 'language'.
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:865)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:762)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1793)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:735)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:299)
INFO | jvm 1 | 2016/05/08 21:53:43 | WrapperSimpleApp Error: ... 20 more
STATUS | wrapper | 2016/05/08 21:53:45 | <-- Wrapper Stopped
My Config File....
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE properties SYSTEM 'http://java.sun.com/dtd/properties.dtd'>
<properties>
<!-- SERVER CONFIG -->
<entry key='web.enable'>true</entry>
<entry key='web.port'>8082</entry>
<entry key='web.path'>C:\Program Files (x86)\Traccar\web</entry>
<entry key='geocoder.enable'>true</entry>
<entry key='geocoder.type'>google</entry>
<entry key='logger.enable'>true</entry>
<entry key='logger.level'>all</entry>
<entry key='logger.file'>C:\Program Files (x86)\Traccar\logs\tracker-server.log</entry>
<!-- DATABASE CONFIG -->
<entry key='database.driverFile'>C:\Program Files (x86)\Traccar\lib\sqljdbc42.jar</entry>
<entry key='database.driver'>com.microsoft.sqlserver.jdbc.SQLServerDriver</entry>
<entry key='database.url'>jdbc:sqlserver://Bunch-GPS01\BUNCHGPS;database=Traccar</entry>
<entry key='database.user'>sa</entry>
<entry key='database.password'>********</entry>
<entry key='database.checkTable'>traccar</entry>
<entry key='database.changelog'>C:\Program Files (x86)\Traccar\data\changelog-master.xml</entry>
Am I missing something obvious?
So far this looks like my solution. Thanks so much!
It seemed to be working now, but the program will take any settings with this error:
2016-05-09 05:11:34 WARN: Invalid column name 'login'. - SQLServerException (... < QueryBuilder:376 < DataManager:285 < PermissionsManager:75 < ...)
2016-05-09 05:11:34 WARN: Invalid column name 'latestPosition_id'. - SQLServerException (... < QueryBuilder:376 < DataManager:452 < ConnectionManager:55 < ...)
I suspect I have got something wrong in the traccar.xml config file? Only everything seems right?
There is definitely something wrong with your config. Please use original Traccar 3.5. You don't need to change any queries.
Once again thanks. It works now, I much have been staring at this too long.
PS - it is possible to retrieve speed limits of roads through Traccar?
Currently there is no way to get speed limits in Traccar. You need access to some map data for that.
I have it connecting and authenticating to the database, it creates the tables but then errors on this...
The Wrapper log:
My Config File....
<?xml version='1.0' encoding='UTF-8'?> <!DOCTYPE properties SYSTEM 'http://java.sun.com/dtd/properties.dtd'> <properties> <!-- SERVER CONFIG --> <entry key='web.enable'>true</entry> <entry key='web.port'>8082</entry> <entry key='web.path'>C:\Program Files (x86)\Traccar\web</entry> <entry key='geocoder.enable'>true</entry> <entry key='geocoder.type'>google</entry> <entry key='logger.enable'>true</entry> <entry key='logger.level'>all</entry> <entry key='logger.file'>C:\Program Files (x86)\Traccar\logs\tracker-server.log</entry> <!-- DATABASE CONFIG --> <entry key='database.driverFile'>C:\Program Files (x86)\Traccar\lib\sqljdbc42.jar</entry> <entry key='database.driver'>com.microsoft.sqlserver.jdbc.SQLServerDriver</entry> <entry key='database.url'>jdbc:sqlserver://Bunch-GPS01\BUNCHGPS;database=Traccar</entry> <entry key='database.user'>sa</entry> <entry key='database.password'>********</entry> <entry key='database.checkTable'>traccar</entry> <entry key='database.changelog'>C:\Program Files (x86)\Traccar\data\changelog-master.xml</entry>Am I missing something obvious?