Mysql database linux for traccar

Database for traccar MyISAM or InnoDB ?

Thanxs Kamil

By default Traccar uses embedded H2 database. If you switch to MySQL, I think Hibernate library will use MyISAM engine by default.

It is better MyISAM or InnoDB ?

I guess InnoDB is the better option in the case of GPS tracking systems.

Hi i have problem with mysql in traccar 3.0

my lines...

<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</entry>
<entry key='database.user'>gps</entry>
<entry key='database.password'>MyPass1234</entry>
<entry key='database.checkTable'>traccar</entry>

Run and log..

cat logs/tracker-server.log
2015-06-29 19:28:37 WARN: Table 'traccar.user' doesn't exist - MySQLSyntaxErrorException (... < QueryBuilder.java:287 < DataManager.java:225 < PermissionsManager.java:50 < ...)

all time only is working with default DB

is with clean mysql table...
thanks

Might be the same problem as https://github.com/tananaev/traccar/issues/1275.

Try to apply following changes to the config:
https://github.com/tananaev/traccar/commit/e9d300e00f244a56246809a3edace996286f1e19

Thanks for the answer , but still does not work ... now it does not fail but does not create the database .

my new config

<!--<entry key='database.driverFile'>hsqldb.jar</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</entry>
<entry key='database.user'>traccar</entry>
<entry key='database.password'>mypasswd</entry>
<entry key='database.checkTable'>traccar</entry>
<entry key='database.mock'>true</entry>

have this messeng

2015-07-07 20:56:08 WARN: Connections could not be acquired from the underlying database! - SQLException (... < QueryBuilder.java:46 < *:120 < DataManager.java:225 < PermissionsManager.java:50 < ...)

Looks like Traccar can't connection to your database. I guess some connection parameters are incorrect or database is not accessible.

Good morning,

Traccar I installed on my server, and it works perfectly. Now I'm trying to use it with MySQL, and make Tables me, but I sent the following notice:

"WARN: Database is already closed (to disable automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL) [90121-190] - JdbcSQLException (... < QueryBuilder:61 < *:131 < DataManager:231 < *:122 < *:133 < ConnectionManager:83"

I've looked at the forums, and I see that I have to set the url MySQL:

"DB_CLOSE_ON_EXIT=FALSE"

But not to the file that contains the configuration is, or as it is called.

Could you help me.

Thank you,

Miquel Toha Perera
www.speakapp-messenger.com

This error is related to H2 database. It has nothing to do with MySQL.