Have you tried searching before asking for help here? This is one of the first search results:
https://www.traccar.org/forums/topic/how-to-resolve-error-public-key-retrieval-is-not-allowed/
Hello!
I did this and added the
allowPublicKeyRetrieval=true
useSSL=false
But trouble is the same
In this line
<entry key='database.url'>jdbc:mysql://[HOST]:3306/[DATABASE]?serverTimezone=UTC&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
Add these parameters on traccar.xml:
allowPublicKeyRetrieval=true
useSSL=false
It will look like this:
<entry key='database.url'>jdbc:mysql://[HOST]:3306/[
Hello!
2021-11-23 12:17:53 INFO: HikariPool-1 - Starting...
2021-11-23 12:17:53 WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2021-11-23 12:17:59 ERROR: HikariPool-1 - Exception during pool initialization. - Access denied for user 'traccar'@'localhost' (using password: YES) - CJException (... < DataManager:130 < *:89 < Context:290 < Main:120 < ...)
2021-11-23 12:17:59 ERROR: Main method error - Access denied for user 'traccar'@'localhost' (using password: YES) - CJException (... < DataManager:130 < *:89 < Context:290 < Main:120 < ...)
My config
<?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?useSSL=false&allowPublicKeyRetrieval=true&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
<entry key='database.user'>traccar</entry>
<entry key='database.password'>venera1841</entry>
</properties>
Hello!
At the moment deamon is starting, but error with loading of driver's class .
Nov 24 08:02:49 traccar traccar[631182]: Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and m>
my ip is http://213.139.210.163:8082/
The error is pretty self explanatory:
Access denied for user 'traccar'@'localhost'
When I service start traccar
I ve got log notes:
/opt/traccar/logs/tracker-server.log