Traccar on AWS EC2 instance Status=1/Failure issue

root@ip-172-31-0-242:/opt/traccar/conf# sudo systemctl status traccar.service
● traccar.service - traccar
     Loaded: loaded (/etc/systemd/system/traccar.service; enabled; vendor preset: enabled)
     Active: active (running) since Fri 2021-01-29 09:27:29 UTC; 8min ago
   Main PID: 14455 (java)
      Tasks: 41 (limit: 2326)
     Memory: 226.5M
     CGroup: /system.slice/traccar.service
             └─14455 /opt/traccar/jre/bin/java -jar tracker-server.jar conf/traccar.xml

Jan 29 09:27:29 ip-172-31-0-242 systemd[1]: Started traccar.
Jan 29 09:27:34 ip-172-31-0-242 traccar[14455]: WARNING: An illegal reflective access operation has occurred
Jan 29 09:27:34 ip-172-31-0-242 traccar[14455]: WARNING: Illegal reflective access by com.google.inject.internal.cglib.core.$ReflectUtils$1 (file:/opt/traccar/lib/guice-4.2.3.jar) to method java.lang.ClassLoader.defineClass(java.lang.St>
Jan 29 09:27:34 ip-172-31-0-242 traccar[14455]: WARNING: Please consider reporting this to the maintainers of com.google.inject.internal.cglib.core.$ReflectUtils$1
Jan 29 09:27:34 ip-172-31-0-242 traccar[14455]: WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
Jan 29 09:27:34 ip-172-31-0-242 traccar[14455]: WARNING: All illegal access operations will be denied in a future release

Slawek4 years ago

system is running, can you login ?

Nightwolve4 years ago

I cannot log in on the website, I'm using a AWS server instance, when i'm trying to use public IP with port i can't get in. Should i configure the .xml with my public ip?

Slawek4 years ago

check

sudo ufw status

Nightwolve4 years ago

root@ip-172-31-0-242:/opt/traccar/conf# sudo ufw status
Status: inactive

Slawek4 years ago

do you try ?

server_ip:8082

Anton Tananaev4 years ago

Have you configured AWS firewall?

Nightwolve4 years ago

Anton, Slawek,

This is what i'm getting right now:

Jan 29 14:01:52 ip-172-31-0-242 systemd[1]: Started traccar.
Jan 29 14:03:11 ip-172-31-0-242 PackageKit: daemon quit
Jan 29 14:03:11 ip-172-31-0-242 systemd[1]: packagekit.service: Succeeded.
Jan 29 14:03:28 ip-172-31-0-242 traccar[36005]: Exception in thread "main" java.lang.RuntimeException: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Jan 29 14:03:28 ip-172-31-0-242 traccar[36005]: #011at org.traccar.Main.run(Main.java:165)
Jan 29 14:03:28 ip-172-31-0-242 traccar[36005]: #011at org.traccar.Main.main(Main.java:110)
Jan 29 14:03:28 ip-172-31-0-242 traccar[36005]: Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Jan 29 14:03:28 ip-172-31-0-242 traccar[36005]: #011at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:595)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:581)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at org.traccar.database.DataManager.initDatabase(DataManager.java:139)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at org.traccar.database.DataManager.<init>(DataManager.java:89)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at org.traccar.Context.init(Context.java:299)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at org.traccar.Main.run(Main.java:137)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011... 1 more
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:906)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:831)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011... 7 more
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.NativeSession.connect(NativeSession.java:144)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:850)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011... 16 more
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: Caused by: java.net.SocketTimeoutException: connect timed out
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at java.base/java.net.Socket.connect(Socket.java:609)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
Jan 29 14:03:29 ip-172-31-0-242 traccar[36005]: #011... 18 more
Jan 29 14:03:29 ip-172-31-0-242 systemd[1]: traccar.service: Main process exited, code=exited, status=1/FAILURE
Jan 29 14:03:29 ip-172-31-0-242 systemd[1]: traccar.service: Failed with result 'exit-code'.

AWS firewall should be no problem since I set the designated ports accessable from all external IP and also internally

Slawek4 years ago

Could not create connection to database server. Attempted reconnect 3 times. Giving up.

Nightwolve4 years ago

Database is on the same server so nothing external? I used your code in mine and I got that issue. Perhaps it's configured incorrectly? but hardly doubt that.

Slawek4 years ago

did you do any changes in traccar.xml ?

Nightwolve4 years ago

I changed my line with the one you provided me and the rest is like the previous post i did:

<?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.cj.jdbc.Driver</entry>
        <entry key='database.url'>jdbc:mysql://127.0.0.1:3306/traccar?serverTimezone=UTC&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
        <entry key='database.user'>root</entry>
        <entry key='database.password'>root</entry>

</properties>

passwords for db are still root

Slawek4 years ago

please download again my config, replace files and restart service, this config is wrong

Nightwolve4 years ago

Traccar is up and running, Thanks Slawed. I still cannot access it through web client tho

Feb  3 10:26:50 ip-172-31-0-242 systemd[1]: traccar.service: Scheduled restart job, restart counter is at 3925.
Feb  3 10:26:50 ip-172-31-0-242 systemd[1]: Stopped traccar.
Feb  3 10:26:50 ip-172-31-0-242 systemd[1]: Started traccar.
Feb  3 10:26:55 ip-172-31-0-242 systemd[1]: Stopping traccar...
Feb  3 10:26:55 ip-172-31-0-242 systemd[1]: traccar.service: Succeeded.
Feb  3 10:26:55 ip-172-31-0-242 systemd[1]: Stopped traccar.
Feb  3 10:26:55 ip-172-31-0-242 systemd[1]: Started traccar.

Nightwolve4 years ago

root@ip-172-31-0-242:/opt/traccar/conf# sudo systemctl status traccar.service
● traccar.service - traccar
     Loaded: loaded (/etc/systemd/system/traccar.service; enabled; vendor preset: enabled)
     Active: active (running) since Wed 2021-02-03 10:26:55 UTC; 19s ago
   Main PID: 253684 (java)
      Tasks: 20 (limit: 2326)
     Memory: 102.9M
     CGroup: /system.slice/traccar.service
             └─253684 /opt/traccar/jre/bin/java -jar tracker-server.jar conf/traccar.xml