cant connect traccar with my database

we have updated traccar version-3.8 and updated traccar.xml using this link https://www.traccar.org/mysql/ and some new table add in database but database is not connected by server:-
tables in database:-

| DATABASECHANGELOG     |
| DATABASECHANGELOGLOCK |
| Driver_detail         |
| data                  |
| device                |
| events                |
| groups                |
| position              |
| server                |
| student_detail        |
| tab_preferences       |
| tab_user              |
| traccar               |
| user                  |
| user_device           |
| user_group            |

Please help us.
Thanks,

How did you update to 3.8? It seems like your database is very out of date.

We have update our traccar using this link https://www.traccar.org/download/ to 3.8 19 nov 2016.
How do we can update our database to the newer version of traccar. can u please share some links.
Thanks,

For info about upgrading please read following page:

https://www.traccar.org/upgrading-traccar/

We have installed new traccar version 3.8 and create a new databse . We updated configure file traccar.xml like this:-

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

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

<properties>
    <entry key="config.default">./conf/default.xml</entry>
    <entry key='database.driver'>com.mysql.jdbc.Driver</entry>
    <entry key='database.url'>jdbc:mysql://127.0.0.1:3306/Traccar? allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=ANSI_QUOTES</entry>
    <entry key='database.user'>root</entry>
    <entry key='database.password'>Welcome123</entry>
    </properties>

database name is Traccar but in datbase is blank after configure xml file.please help me..
Thanks,

Check logs.

I have followed your installation instruction http://traccar.litvak.su/installation.html for traccar version 3.8 and have the following issue so far could you please help.

first of all service runs and gives "503 - Service Unavailable" on web.

Thanks,

The version you have installed is not the official one. If you need help with it, I would recommend contacting author.

it would be nice to get some links official version of traccar kindly share some link with more information so we update our system as soon as possible.
Thanks,

You are on the official Traccar website. Just click on the "Download" button at the top.

We have already stated that we updated our traccar system to 3.8 using https://www.traccar.org/download/ link in my previous reply so how claim the "The version you have installed is not the official one." Kindly clear the confusion.

Please tell how do we configure database completely for version traccar 3.8, share some links.

Thanks for you time Anton.

You said you followed instructions from "traccar.litvak.su". Those instructions are for installing unofficial mod for Traccar.

okay thanks for the kind support, now the system is working fine by doing some changes.

We stopped the traccar services using traccar.xml file and added those four lines inside it

<entry key='database.driver'>org.h2.Driver</entry>
<entry key='database.url'>jdbc:h2:/home/user/Documents/yourDataBaseName/target/database</entry>
<entry key='database.user'>sa</entry>
<entry key='database.password'></entry>

Note: database name changed

and started the traccar services after that.

Now we got another problem is that we cant see the list of configured added devices on web panel instead of we are getting animating loading image there at whereas when we check our database devices table is updated with configured device along with other data inside positions table.

Thanks for your valued time.

Check browser console for errors and warnings. Also check network calls, specifically /api/devices.

Hi Neha Sharma

I´m stuck with the same situation as you. I´m using HeidiSQL for creating the database but I can´t see any table created on my table after doing this changes in the traccar.xml I set up my file as follows :

entry key="config.default">./conf/default.xml</entry> 
    <entry key='database.driver'>com.mysql.jdbc.Driver</entry> 
    <entry key='database.url'>jdbc:mysql://127.0.0.1:3306/traccar2?allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
   <entry key='database.user'>root</entry> 
   <entry key='database.password'>myroot84</entry>

Could you please share which changes did you do in order to get system working fine, I mean, being able to see the tables created on your database.

Thanks!