Can't connect to MySQL database...

Hi Anton,

As you suggest on the previous post, i'm installing traccar 3.11 server

with the default values on traccar.xml all works fine using default database H2

    <entry key='database.driver'>org.h2.Driver</entry>
    <entry key='database.url'>jdbc:h2:./data/database</entry>
    <entry key='database.user'>sa</entry>
    <entry key='database.password'></entry>
</properties>

When i change the database for this setting:

    <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=ANSI_QUOTES</entry>
    <entry key='database.user'>root</entry> 
    <entry key='database.password'></entry>

Traccar services does not start.

Any ideas ?

Thanks in advance
David

Probably the problem is that you removed "properties" closing tag, but you should check logs for errors.

Thanks Anton;
I don't know if this is a tip for instalations (at least under WinXP SP3):

Each time i upgrade the server, i must backup the database, delete it, recreate a new empty database and then, restore the database.

Now, all works fine.

My 0.01
David

You don't need to recreate database every time. Traccar will upgrade schema automatically.

Thanks Anton, again...

Now, Server 3.11 is working fine.

I'm testing Traccar Manager on my Lenovo K5, and i think is virtually impossible get a group.

Is very difficult set the visible columns, add the group column and after this set the filter of the group column getting the group name.

My Lenovo K5 is HD definition, the touch is perfect and the phone is 3 months old.

Please, could you consider for a new update, add a button (or something like) or a simple combobox for selecting groups ?

Please! please! please!

King regards,
David

For any suggestions or feature requests please use GitHub. Also, provide as much information as possible to support your point. In this case maybe a screenshot of what it looks like and why it's so hard to filter by group.