Error MySQL

Fabian6 years ago

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 &amp; 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

Anton Tananaev6 years ago

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.