I've got a fresh install of Traccar v3.14 on a Win7 machine running Java 7 Update 76, trying to connect to a SQL server on another machine as it's database. I've made the changes to the traccar.xml per the instructions found here: https://www.traccar.org/ms-sql/
When I go to start the Traccar service for the first time, I'm getting an error: "Error 2: The system cannot find the file specified."
The log folder is empty, I'm assuming because the service has never actually run.
If I try to run the Path to executable from command prompt, here is the output I'm getting:
C:\Program Files\Java\jre7\bin>java.exe -classpath "C:\Program Files\Traccar\wra
pper.jar" -Xrs -Dwrapper.service=true "-Dwrapper.config=C:\Program Files\Traccar
\conf\wrapper.conf" -Dwrapper.additional.1x=-Xrs -Djna_tmpdir=C:\Users\rcathers\
AppData\Local\Temp org.rzo.yajsw.boot.WrapperServiceBooter
INFO: lib not found: C:\Program Files\Traccar\lib\extended\glazedlists\glazedlis
ts-1.8.0_java15.jar
INFO: lib not found: C:\Program Files\Traccar\lib\extended\glazedlists\commons-b
eanutils-1.8.2.jar
INFO: lib not found: C:\Program Files\Traccar\lib\extended\glazedlists\commons-b
eanutils-1.8.2.jar
INFO: lib not found: C:\Program Files\Traccar\lib\extended\glazedlists\glazedlis
ts-1.8.0_java15.jar
Oct 13, 2017 12:29:28 PM org.apache.commons.vfs2.VfsLog info
INFO: Using "C:\Users\rcathers\AppData\Local\Temp\vfs_cache" as temporary files
store.
java.io.FileNotFoundException: C:\Program Files\Traccar\.\logs\wrapper.log.20171
013.lck (Access is denied)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(Unknown Source)
at java.io.FileOutputStream.<init>(Unknown Source)
at org.rzo.yajsw.log.MyFileHandler.initOutputFiles(MyFileHandler.java:26
1)
at org.rzo.yajsw.log.MyFileHandler.init(MyFileHandler.java:184)
at org.rzo.yajsw.log.MyFileHandler.<init>(MyFileHandler.java:759)
at org.rzo.yajsw.log.MyFileHandler.<init>(MyFileHandler.java:766)
at org.rzo.yajsw.log.DateFileHandler.rotateDate(DateFileHandler.java:212
)
at org.rzo.yajsw.log.DateFileHandler.<init>(DateFileHandler.java:116)
at org.rzo.yajsw.wrapper.AbstractWrappedProcess.getFileHandler(AbstractW
rappedProcess.java:1511)
at org.rzo.yajsw.wrapper.AbstractWrappedProcess.getWrapperLogger(Abstrac
tWrappedProcess.java:2668)
at org.rzo.yajsw.wrapper.AbstractWrappedProcess.getInternalWrapperLogger
(AbstractWrappedProcess.java:2678)
at org.rzo.yajsw.wrapper.AbstractWrappedProcess.init(AbstractWrappedProc
ess.java:272)
at org.rzo.yajsw.wrapper.WrappedJavaProcess.init(WrappedJavaProcess.java
:77)
at org.rzo.yajsw.app.WrapperMainServiceWin.main(WrapperMainServiceWin.ja
va:140)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.rzo.yajsw.boot.WrapperServiceBooter.main(WrapperServiceBooter.jav
a:46)
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.rzo.yajsw.boot.WrapperServiceBooter.main(WrapperServiceBooter.jav
a:46)
Caused by: java.lang.NullPointerException
at org.rzo.yajsw.log.DateFileHandler.publish(DateFileHandler.java:162)
at java.util.logging.Logger.log(Unknown Source)
at org.rzo.yajsw.log.MyLogger.log(MyLogger.java:74)
at java.util.logging.Logger.doLog(Unknown Source)
at java.util.logging.Logger.log(Unknown Source)
at java.util.logging.Logger.warning(Unknown Source)
at org.rzo.yajsw.wrapper.AbstractWrappedProcess.init(AbstractWrappedProc
ess.java:275)
at org.rzo.yajsw.wrapper.WrappedJavaProcess.init(WrappedJavaProcess.java
:77)
at org.rzo.yajsw.app.WrapperMainServiceWin.main(WrapperMainServiceWin.ja
va:140)
... 5 more
Here are the changes I've made to traccar.xml:
<entry key='database.driver'>com.microsoft.sqlserver.jdbc.SQLServerDriver</entry>
<entry key='database.url'>jdbc:sqlserver://172.16.2.112;user=traccar;password=traccar;databaseName=Traccar;</entry>
<entry key='database.user'>traccar</entry>
<entry key='database.password'>traccar</entry>
Any suggestions would be appreciated.
You have some problem with log file. Are you sure you haven't opened one of those files in some text editor?
I've got a fresh install of Traccar v3.14 on a Win7 machine running Java 7 Update 76, trying to connect to a SQL server on another machine as it's database. I've made the changes to the traccar.xml per the instructions found here: https://www.traccar.org/ms-sql/
When I go to start the Traccar service for the first time, I'm getting an error: "Error 2: The system cannot find the file specified."
The log folder is empty, I'm assuming because the service has never actually run.
If I try to run the Path to executable from command prompt, here is the output I'm getting:
Here are the changes I've made to traccar.xml:
<entry key='database.driver'>com.microsoft.sqlserver.jdbc.SQLServerDriver</entry> <entry key='database.url'>jdbc:sqlserver://172.16.2.112;user=traccar;password=traccar;databaseName=Traccar;</entry> <entry key='database.user'>traccar</entry> <entry key='database.password'>traccar</entry>
Any suggestions would be appreciated.