How about Anton, could help with these errors, it seems that there is a problem in recognizing the URL of the controller and the database, I made some changes and I was reviewing several topics in the forum, but I could not get any positive results.
This is my configuration:
<entry key='database.driver'>com.mysql.jdbc.Driver</entry>
<entry key='database.url'> jdbc: mysql: // 192.168.0.100:3306/traccar? useSSL = false & allowMultiQu$
<entry key='database.user'>traccardb</entry>
<entry key='database.password'>mypassword</entry>
This is what the log file throws at me:
WARNING|wrapper|Service traccar|17-11-17 00:21:49|YAJSW: yajsw-stable-12.09
WARNING|wrapper|Service traccar|17-11-17 00:21:49|OS : Linux/4.4.0-98-generic/i386
WARNING|wrapper|Service traccar|17-11-17 00:21:49|JVM : Oracle Corporation/1.7.0_151//usr/lib/jvm/java-7-openjdk-i386/jre/32
INFO|wrapper|Service traccar|17-11-17 00:21:49|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.42.jar:/opt/traccar/lib/postgresql-42.1.1.jre7.jar:/opt/traccar/lib/mssql-jdbc-6.2.0.jre7.jar:/opt/traccar/lib/HikariCP-java7-2.4.12.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/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.0.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.12.jar:/opt/traccar/lib/poi-3.14.jar:/opt/traccar/lib/poi-ooxml-3.14.jar:/opt/traccar/lib/poi-ooxml-schemas-3.14.jar:/opt/traccar/lib/xmlbeans-2.6.0.jar:/opt/traccar/lib/stax-api-1.0.1.jar:/opt/traccar/lib/curvesapi-1.03.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/ical4j-2.0.0.jar:/opt/traccar/lib/commons-collections4-4.0.jar:/opt/traccar/lib/groovy-all-2.3.2.jar:/opt/traccar/lib/bndlib-2.3.0.jar:/opt/traccar/lib/org.osgi.core-4.3.1.jar:/opt/traccar/lib/commons-lang3-3.3.2.jar:/opt/traccar/lib/commons-codec-1.9.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=2122180814927671019" "-Dwrapper.teeName=2122180814927671019$1510899709498" "-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|17-11-17 00:21:49|posix_spawn pid 16757
INFO|wrapper|Service traccar|17-11-17 00:21:49|started process 16757
INFO|wrapper|Service traccar|17-11-17 00:21:49|started process with pid 16757
INFO|16757/0|Service traccar|17-11-17 00:21:50|[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store.
INFO|16757/0|Service traccar|17-11-17 00:21:51|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|16757/0|Service traccar|17-11-17 00:21:51|java.lang.reflect.InvocationTargetException
INFO|16757/0|Service traccar|17-11-17 00:21:51| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|16757/0|Service traccar|17-11-17 00:21:51| at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
INFO|16757/0|Service traccar|17-11-17 00:21:51| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|16757/0|Service traccar|17-11-17 00:21:51| at java.lang.reflect.Method.invoke(Method.java:606)
INFO|16757/0|Service traccar|17-11-17 00:21:51| at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|16757/0|Service traccar|17-11-17 00:21:51| at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|16757/0|Service traccar|17-11-17 00:21:51|Caused by: java.lang.RuntimeException: Driver com.mysql.jdbc.Driver claims to not accept jdbcUrl, jdbc: mysql: // 192.168.0.100:3306/traccar? useSSL = false & allowMultiQueries = true &autoReconnect = true & useUnicode = true & characterEncoding = UTF-8 & sessionVariables = sql_mode=''
INFO|16757/0|Service traccar|17-11-17 00:21:51| at com.zaxxer.hikari.util.DriverDataSource.<init>(DriverDataSource.java:101)
INFO|16757/0|Service traccar|17-11-17 00:21:51| at com.zaxxer.hikari.pool.PoolBase.initializeDataSource(PoolBase.java:318)
INFO|16757/0|Service traccar|17-11-17 00:21:51| at com.zaxxer.hikari.pool.PoolBase.<init>(PoolBase.java:108)
INFO|16757/0|Service traccar|17-11-17 00:21:51| at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:105)
INFO|16757/0|Service traccar|17-11-17 00:21:51| at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
INFO|16757/0|Service traccar|17-11-17 00:21:51| at org.traccar.database.DataManager.initDatabase(DataManager.java:120)
INFO|16757/0|Service traccar|17-11-17 00:21:51| at org.traccar.database.DataManager.<init>(DataManager.java:75)
INFO|16757/0|Service traccar|17-11-17 00:21:51| at org.traccar.Context.init(Context.java:221)
INFO|16757/0|Service traccar|17-11-17 00:21:51| at org.traccar.Main.main(Main.java:35)
INFO|16757/0|Service traccar|17-11-17 00:21:51| ... 6 more
INFO|wrapper|Service traccar|17-11-17 00:21:51|waitpid 16757 59136
INFO|wrapper|Service traccar|17-11-17 00:21:51|exit code posix process: 59136 application: 0
I don't know where you got that database URL, but it's obviously incorrect. Why do you have spaces everywhere? Please follow official documentation.
How about Anton, could help with these errors, it seems that there is a problem in recognizing the URL of the controller and the database, I made some changes and I was reviewing several topics in the forum, but I could not get any positive results.
This is my configuration:
<entry key='database.driver'>com.mysql.jdbc.Driver</entry> <entry key='database.url'> jdbc: mysql: // 192.168.0.100:3306/traccar? useSSL = false & allowMultiQu$ <entry key='database.user'>traccardb</entry> <entry key='database.password'>mypassword</entry>This is what the log file throws at me: