How to install Traccar on AWS with MySQL

ronaldofjr8 years ago

Hi guys,

I'm trying to install Traccar server on AWS running Ubuntu. I installed Traccar and everything is running very well but when I add the lines bellow on Traccar conf, the server stops to respond.

I already tried to do it following another post but no success.
https://www.traccar.org/forums/topic/how-to-install-traccar-server-on-aws-amazon-step-by-step-tutorial/

The server is running under H2 database perfectly but I can't do it on MySQL. I added the lines bellow on my conf but when I restart the server, stops to respond. I use the root account.

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

What I need to do to make it run on MySQL? I'm running Ubuntu 64bits and Traccar 3.13.

Thanks!

Anton Tananaev8 years ago

Please read official documentation:

https://www.traccar.org/mysql/

ronaldofjr8 years ago

Thanks Anton for your answer.

My problem was MySQL permission. I needed to create a new user with permissions on tables.
This is what I need to follow and than insert MySQL configuration on traccar.xml file.

I create a new user called traccarmysql, grant all permissions on traccar database and than flush privileges. Check it on this website:
https://easyengine.io/tutorials/mysql/remote-access/

I hope that this helps others traccar users.