Traccar on AWS EC2 instance Status=1/Failure issue

Nightwolve 5 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 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

Slawek 5 years ago

system is running, can you login ?

Nightwolve 5 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?

Slawek 5 years ago

check

sudo ufw status

Nightwolve 5 years ago

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

Slawek 5 years ago

do you try ?

server_ip:8082

Anton Tananaev 5 years ago

Have you configured AWS firewall?

Nightwolve 5 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

Slawek 5 years ago

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

Nightwolve 5 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.

Slawek 5 years ago

did you do any changes in traccar.xml ?

Nightwolve 5 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&amp;useSSL=false&amp;allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode=''</entry>
        <entry key='database.user'>root</entry>
        <entry key='database.password'>root</entry>

</properties>

passwords for db are still root

Slawek 5 years ago

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

Nightwolve 5 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.

Nightwolve 5 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