Traccar 3.5 + MySQL

Latenight8 years ago

Добрый день. Не могу запустить сервер с БД MySQ. CentOS 6.4 Версия mysql-5.1.67-1.el6_3.x86_64 Насколько я понимаю проблема в:


INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: Encountered an error running main:
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: liquibase.exception.DatabaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

Подскажите пожалуйста как решить?

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


STATUS | wrapper  | 2016/06/01 12:18:15 | --> Wrapper Started as Daemon
STATUS | wrapper  | 2016/06/01 12:18:15 | Java Service Wrapper Community Edition 64-bit 3.5.28
STATUS | wrapper  | 2016/06/01 12:18:15 |   Copyright (C) 1999-2016 Tanuki Software, Ltd. All Rights Reserved.
STATUS | wrapper  | 2016/06/01 12:18:15 |     http://wrapper.tanukisoftware.com
STATUS | wrapper  | 2016/06/01 12:18:15 | 
STATUS | wrapper  | 2016/06/01 12:18:16 | Launching a JVM...
INFO   | jvm 1    | 2016/06/01 12:18:16 | WrapperManager: Initializing...
INFO   | jvm 1    | 2016/06/01 12:18:16 | [MLog-Init-Reporter] INFO com.mchange.v2.log.MLog - MLog clients using slf4j logging.
INFO   | jvm 1    | 2016/06/01 12:18:16 | [WrapperSimpleAppMain] INFO com.mchange.v2.c3p0.C3P0Registry - Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp: 
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: Encountered an error running main:
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: liquibase.exception.DatabaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:247)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at liquibase.database.DatabaseFactory.openDatabase(DatabaseFactory.java:151)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at liquibase.database.DatabaseFactory.openDatabase(DatabaseFactory.java:140)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:257)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at org.traccar.database.DataManager.<init>(DataManager.java:75)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at org.traccar.Context.init(Context.java:121)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at org.traccar.Main.main(Main.java:29)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at java.lang.reflect.Method.invoke(Method.java:601)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:325)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at java.lang.Thread.run(Thread.java:722)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.Util.getInstance(Util.java:387)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:917)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:896)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:885)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2165)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2090)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:239)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	... 12 more
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: Caused by: java.sql.SQLException: Access denied for user 'traccar'@'127.0.0.1' (using password: YES)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4323)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1267)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2255)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2106)
INFO   | jvm 1    | 2016/06/01 12:18:21 | WrapperSimpleApp Error: 	... 23 more
STATUS | wrapper  | 2016/06/01 12:18:23 | <-- Wrapper Stopped
Latenight8 years ago

Пожалуйста удалите топик. Я разобрался. Прошу прощения

Anton Tananaev8 years ago

Можно оставить топик на случай если у кого-то вдруг такая-же проблема будет. Правильно я понимаю что проблема была с правами доступа пользователя?

Latenight8 years ago

Да, именно это в этом и была проблема. А помимо этого еще и ошибка в учетных данных была в конфиге. Вобщем, если у вас аналогичная проблема - рекомендую убедиться в наличие доступа вашей учетной записи mysql к базе данных.