ERR_CONNECTION_REFUSED and Server does not create MySQL database

ensilife7 years ago

Hi,

Thanks for this great software,

I'am unable to run traccar using mysql server, and I got ERR_CONNECTION_REFUSED while connecting to http://localhost:8082/

With H2 database it's working fine.

I'm under windows 8.1.

Here are the logs :

WARNING|wrapper|Service traccar|17-03-04 12:27:53|YAJSW: yajsw-stable-12.08
WARNING|wrapper|Service traccar|17-03-04 12:27:53|OS   : Windows 8.1/6.3/amd64
WARNING|wrapper|Service traccar|17-03-04 12:27:53|JVM  : Oracle Corporation/1.8.0_121/C:\Program Files\Java\jre1.8.0_121/64
INFO|wrapper|Service traccar|17-03-04 12:27:53|start delay: 0
INFO|wrapper|Service traccar|17-03-04 12:27:53|started process with pid 7088
INFO|7088/0|Service traccar|17-03-04 12:27:54|[INFO] StandardFileSystemManager - Using "C:\Windows\TEMP\vfs_cache" as temporary files store.
INFO|7088/0|Service traccar|17-03-04 12:27:54|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|7088/0|Service traccar|17-03-04 12:27:54|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.

for server log : this is all i have in the file :

2017-03-03 14:35:47  INFO: Operating system name: Windows 8.1 version: 6.3 architecture: amd64
2017-03-03 14:35:47  INFO: Java runtime name: Java HotSpot(TM) 64-Bit Server VM vendor: Oracle Corporation version: 25.121-b13
2017-03-03 14:35:47  INFO: Memory limit heap: 1799mb non-heap: 0mb
2017-03-03 14:35:47  INFO: Character encoding: UTF-8 charset: UTF-8
2017-03-03 14:35:47  INFO: Version: 3.10-SNAPSHOT
2017-03-03 14:35:57  INFO: Starting server...
2017-03-03 16:06:36  INFO: Shutting down server...

traccar Config file :

<?xml version='1.0' encoding='UTF-8'?>

<!DOCTYPE properties SYSTEM 'http://java.sun.com/dtd/properties.dtd'>

<properties>

<entry key='database.driver'>com.mysql.jdbc.Driver</entry> 
<entry key='database.url'>jdbc:mysql://localhost:3306/traccar?allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
<entry key='database.user'>traccar</entry> 
<entry key='database.password'>traccar</entry>

</properties>

Thanks in advance.

Anton Tananaev7 years ago

What happened to the "config.default" parameter in the configuration file?

ensilife7 years ago

Hi Anton,

Thanks a lot, Indeed I stupidly removed that line while puting Mysql connection Infos.

Regards