Server Installation not working MAC Sierra

victor orrego7 years ago

Hi, I I have been trying all day to get this server running on a Mysql database but it is not working. each time I go to http://localhost:8082/ I get a message that says that the localhost refused to connect.

I created the database:

$ mysql -u root -p
> CREATE DATABASE TRACCAR;
> CREATE USER 'traccardb'@'localhost' IDENTIFIED BY 'mypassword';
> GRANT ALL PRIVILEGES ON TRACCAR.* TO 'traccerdb'@'localhost';
> FLUSH PRIVILEGES;

then installed the traccar and follow this directions. https://www.traccar.org/mac-os/
the updated the traccar.xml file to:

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

lastly, sudo /opt/traccar/bin/startDaemon.sh, then it shows that the service traccar started but still localhost refuses to connect. I check the log directory and it appears that the tracker-server.log is missing.

Anton Tananaev7 years ago

Have you checked wrapper log file?

victor orrego7 years ago
wrapper.java.command=java
wrapper.java.app.jar=tracker-server.jar
wrapper.app.parameter.1=./conf/traccar.xml
wrapper.java.additional.1=-Dfile.encoding=UTF-8
wrapper.logfile=logs/wrapper.log.YYYYMMDD
wrapper.logfile.rollmode=DATE
wrapper.ntservice.name=traccar
wrapper.ntservice.displayname=Traccar
wrapper.ntservice.description=Traccar
wrapper.daemon.run_level_dir=${if (new File('/etc/rc0.d').exists()) return '/et$

This is everything there is in that file.

Also, might be that the port is closed? how can I open it

nmap -p 8082 localhost
Starting Nmap 7.25BETA2 ( https://nmap.org ) at 2017-08-27 18:31 EDT
Nmap scan report for localhost (127.0.0.1)
Host is up (0.00033s latency).
Other addresses for localhost (not scanned): ::1 fe80::1
PORT     STATE  SERVICE
8082/tcp closed blackice-alerts
Anton Tananaev7 years ago

I asked for wrapper log file, not config file.

victor orrego7 years ago
WARNING|wrapper|Service traccar|17-08-27 17:15:05|YAJSW: yajsw-stable-12.09
WARNING|wrapper|Service traccar|17-08-27 17:15:05|OS   : Mac OS X/10.12.6/x86_64
WARNING|wrapper|Service traccar|17-08-27 17:15:05|JVM  : Oracle Corporation/1.8.0_144//Library/Java/JavaVirtualMachines/jdk1.8.0_144.jdk/Contents/Home/jre/64
INFO|wrapper|Service traccar|17-08-27 17:15:07|starting 
INFO|wrapper|Service traccar|17-08-27 17:15:08|started process 3474
INFO|wrapper|Service traccar|17-08-27 17:15:08|started process with pid 3474
WARNING|3474/0|Service traccar|17-08-27 17:15:37|startup of java application timed out. if this is due to server overload consider increasing wrapper.startup.timeout
WARNING|wrapper|Service traccar|17-08-27 17:22:33|YAJSW: yajsw-stable-12.09
WARNING|wrapper|Service traccar|17-08-27 17:22:33|OS   : Mac OS X/10.12.6/x86_64
WARNING|wrapper|Service traccar|17-08-27 17:22:33|JVM  : Oracle Corporation/1.8.0_144//Library/Java/JavaVirtualMachines/jdk1.8.0_144.jdk/Contents/Home/jre/64
INFO|wrapper|Service traccar|17-08-27 17:22:35|starting 
INFO|wrapper|Service traccar|17-08-27 17:22:36|started process 3615
INFO|wrapper|Service traccar|17-08-27 17:22:36|started process with pid 3615
INFO|3615/0|Service traccar|17-08-27 17:22:36|in_8575481431410079727$1503868953195: Channel not open for writing - cannot extend file to required size
INFO|3615/0|Service traccar|17-08-27 17:22:37|[INFO] StandardFileSystemManager - Using "/var/folders/zz/zyxvpxvq6csfxvn_n0000000000000/T/vfs_cache" as temporary files store.
INFO|3615/0|Service traccar|17-08-27 17:22:37|java.lang.reflect.InvocationTargetException
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at java.lang.reflect.Method.invoke(Method.java:498)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|3615/0|Service traccar|17-08-27 17:22:37|Caused by: java.util.InvalidPropertiesFormatException: org.xml.sax.SAXParseException; lineNumber: 28; columnNumber: 99; The reference to entity "autoReconnect" must end with the ';' delimiter.
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at sun.util.xml.PlatformXmlPropertiesProvider.load(PlatformXmlPropertiesProvider.java:80)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at java.util.Properties$XmlSupport.load(Properties.java:1201)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at java.util.Properties.loadFromXML(Properties.java:881)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at org.traccar.Config.load(Config.java:32)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at org.traccar.Context.init(Context.java:209)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at org.traccar.Main.main(Main.java:35)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	... 6 more
INFO|3615/0|Service traccar|17-08-27 17:22:37|Caused by: org.xml.sax.SAXParseException; lineNumber: 28; columnNumber: 99; The reference to entity "autoReconnect" must end with the ';' delimiter.
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:203)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:177)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:400)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:327)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1472)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEntityReference(XMLDocumentFragmentScannerImpl.java:1850)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:3061)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:602)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:505)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:841)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:770)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:243)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:339)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at sun.util.xml.PlatformXmlPropertiesProvider.getLoadingDoc(PlatformXmlPropertiesProvider.java:106)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	at sun.util.xml.PlatformXmlPropertiesProvider.load(PlatformXmlPropertiesProvider.java:78)
INFO|3615/0|Service traccar|17-08-27 17:22:37|	... 11 more
INFO|wrapper|Service traccar|17-08-27 17:22:38|exit code linux process 59136
WARNING|wrapper|Service traccar|17-08-27 18:12:49|YAJSW: yajsw-stable-12.09
WARNING|wrapper|Service traccar|17-08-27 18:12:49|OS   : Mac OS X/10.12.6/x86_64
WARNING|wrapper|Service traccar|17-08-27 18:12:49|JVM  : Oracle Corporation/1.8.0_144//Library/Java/JavaVirtualMachines/jdk1.8.0_144.jdk/Contents/Home/jre/64
INFO|wrapper|Service traccar|17-08-27 18:12:52|starting 
INFO|wrapper|Service traccar|17-08-27 18:12:53|started process 4366
INFO|wrapper|Service traccar|17-08-27 18:12:53|started process with pid 4366
WARNING|4366/0|Service traccar|17-08-27 18:13:22|startup of java application timed out. if this is due to server overload consider increasing wrapper.startup.timeout
WARNING|wrapper|Service traccar|17-08-27 18:29:48|YAJSW: yajsw-stable-12.09
WARNING|wrapper|Service traccar|17-08-27 18:29:48|OS   : Mac OS X/10.12.6/x86_64
WARNING|wrapper|Service traccar|17-08-27 18:29:48|JVM  : Oracle Corporation/1.8.0_144//Library/Java/JavaVirtualMachines/jdk1.8.0_144.jdk/Contents/Home/jre/64
INFO|wrapper|Service traccar|17-08-27 18:29:48|starting 
INFO|wrapper|Service traccar|17-08-27 18:29:49|started process 315
INFO|wrapper|Service traccar|17-08-27 18:29:49|started process with pid 315
WARNING|315/0|Service traccar|17-08-27 18:30:18|startup of java application timed out. if this is due to server overload consider increasing wrapper.startup.timeout
WARNING|wrapper|Service traccar|17-08-27 18:31:07|YAJSW: yajsw-stable-12.09
WARNING|wrapper|Service traccar|17-08-27 18:31:07|OS   : Mac OS X/10.12.6/x86_64
WARNING|wrapper|Service traccar|17-08-27 18:31:07|JVM  : Oracle Corporation/1.8.0_144//Library/Java/JavaVirtualMachines/jdk1.8.0_144.jdk/Contents/Home/jre/64
INFO|wrapper|Service traccar|17-08-27 18:31:07|starting 
INFO|wrapper|Service traccar|17-08-27 18:31:08|started process 706
INFO|wrapper|Service traccar|17-08-27 18:31:08|started process with pid 706
WARNING|706/0|Service traccar|17-08-27 18:31:37|startup of java application timed out. if this is due to server overload consider increasing wrapper.startup.timeout

My bad.

victor orrego7 years ago
MacBook-Victor:logs VictorHugo$ java -version
java version "1.8.0_144"
Java(TM) SE Runtime Environment (build 1.8.0_144-b01)
Java HotSpot(TM) 64-Bit Server VM (build 25.144-b01, mixed mode)
MacBook-Victor:logs VictorHugo$
Anton Tananaev7 years ago

Your configuration file is invalid. If you read error message carefully, it even tells which line and column has the problem.

victor orrego7 years ago

you mean from traccar.xml?

Anton Tananaev7 years ago

Yes. You use & in the database URL, when it should be &amp;.

victor orrego7 years ago

now I'm having access denied to the data base 

WARNING|wrapper|Service traccar|17-08-27 21:05:31|OS   : Mac OS X/10.12.6/x86_64
WARNING|wrapper|Service traccar|17-08-27 21:05:31|JVM  : Oracle Corporation/1.8.0_144//Library/Java/JavaVirtualMachines/jdk1.8.0_144.jdk/Contents/Home/jre/64
INFO|wrapper|Service traccar|17-08-27 21:05:32|starting 
INFO|wrapper|Service traccar|17-08-27 21:05:33|started process 2242
INFO|wrapper|Service traccar|17-08-27 21:05:33|started process with pid 2242
INFO|2242/0|Service traccar|17-08-27 21:05:33|in_9181550185245947819$1503882331258: Channel not open for writing - cannot extend file to required size
INFO|2242/0|Service traccar|17-08-27 21:05:34|[INFO] StandardFileSystemManager - Using "/var/folders/zz/zyxvpxvq6csfxvn_n0000000000000/T/vfs_cache" as temporary files store.
INFO|2242/0|Service traccar|17-08-27 21:05:34|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|2242/0|Service traccar|17-08-27 21:05:35|Sun Aug 27 21:05:35 EDT 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
INFO|2242/0|Service traccar|17-08-27 21:05:40|[main] ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
INFO|2242/0|Service traccar|17-08-27 21:05:40|com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.Util.getInstance(Util.java:408)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2104)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2029)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:112)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:118)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at org.traccar.database.DataManager.initDatabase(DataManager.java:120)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at org.traccar.database.DataManager.<init>(DataManager.java:75)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at org.traccar.Context.init(Context.java:221)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at org.traccar.Main.main(Main.java:35)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at java.lang.reflect.Method.invoke(Method.java:498)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|2242/0|Service traccar|17-08-27 21:05:40|Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'traccardb'@'localhost' to database 'traccar'
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.Util.getInstance(Util.java:408)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2194)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2045)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	... 28 more
INFO|2242/0|Service traccar|17-08-27 21:05:40|java.lang.reflect.InvocationTargetException
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at java.lang.reflect.Method.invoke(Method.java:498)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|2242/0|Service traccar|17-08-27 21:05:40|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.
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:528)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:520)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at org.traccar.database.DataManager.initDatabase(DataManager.java:120)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at org.traccar.database.DataManager.<init>(DataManager.java:75)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at org.traccar.Context.init(Context.java:221)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at org.traccar.Main.main(Main.java:35)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	... 6 more
INFO|2242/0|Service traccar|17-08-27 21:05:40|Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.Util.getInstance(Util.java:408)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2104)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2029)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:112)
INFO|2242/0|Service traccar|17-08-27 21:05:40|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:118)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	... 12 more
FINEST|2242/0|Service traccar|17-08-27 21:05:40|Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'traccardb'@'localhost' to database 'traccar'
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.Util.getInstance(Util.java:408)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2194)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2045)
FINEST|2242/0|Service traccar|17-08-27 21:05:40|	... 28 more
INFO|wrapper|Service traccar|17-08-27 21:05:40|exit code linux process 59136
victor orrego7 years ago

when I created the user, at the line GRANT ALL PRIVILEGES ON TRACCAR.* TO 'traccerdb'@'localhost'; Mysql gave me error 1133 can't find any matching row in the user table.

Anton Tananaev7 years ago

That's not a Traccar issue. If you are not able to configure MySQL database, I would recommend asking on MySQL-related resources.

victor orrego7 years ago
WARNING|wrapper|Service traccar|17-08-28 09:43:16|YAJSW: yajsw-stable-12.09
WARNING|wrapper|Service traccar|17-08-28 09:43:16|OS   : Mac OS X/10.12.6/x86_64
WARNING|wrapper|Service traccar|17-08-28 09:43:16|JVM  : Oracle Corporation/1.8.0_144//Library/Java/JavaVirtualMachines/jdk1.8.0_144.jdk/Contents/Home/jre/64
INFO|wrapper|Service traccar|17-08-28 09:43:17|starting 
INFO|wrapper|Service traccar|17-08-28 09:43:18|started process 306
INFO|wrapper|Service traccar|17-08-28 09:43:18|started process with pid 306
WARNING|306/0|Service traccar|17-08-28 09:43:48|startup of java application timed out. if this is due to server overload consider increasing wrapper.startup.timeout
WARNING|wrapper|Service traccar|17-08-28 09:45:48|YAJSW: yajsw-stable-12.09
WARNING|wrapper|Service traccar|17-08-28 09:45:48|OS   : Mac OS X/10.12.6/x86_64
WARNING|wrapper|Service traccar|17-08-28 09:45:48|JVM  : Oracle Corporation/1.8.0_144//Library/Java/JavaVirtualMachines/jdk1.8.0_144.jdk/Contents/Home/jre/64
INFO|wrapper|Service traccar|17-08-28 09:45:49|starting 
INFO|wrapper|Service traccar|17-08-28 09:45:50|started process 726
INFO|wrapper|Service traccar|17-08-28 09:45:50|started process with pid 726
WARNING|726/0|Service traccar|17-08-28 09:46:19|startup of java application timed out. if this is due to server overload consider increasing wrapper.startup.timeout
WARNING|wrapper|Service traccar|17-08-28 09:48:45|YAJSW: yajsw-stable-12.09
WARNING|wrapper|Service traccar|17-08-28 09:48:45|OS   : Mac OS X/10.12.6/x86_64
WARNING|wrapper|Service traccar|17-08-28 09:48:45|JVM  : Oracle Corporation/1.8.0_144//Library/Java/JavaVirtualMachines/jdk1.8.0_144.jdk/Contents/Home/jre/64
INFO|wrapper|Service traccar|17-08-28 09:48:46|starting 
INFO|wrapper|Service traccar|17-08-28 09:48:47|started process 852
INFO|wrapper|Service traccar|17-08-28 09:48:47|started process with pid 852
WARNING|852/0|Service traccar|17-08-28 09:49:16|startup of java application timed out. if this is due to server overload consider increasing wrapper.startup.timeout

looks like something is wrong with java now?

victor orrego7 years ago

I got it working. but I am having an issue "send fail" from the android client. Im going to post in another topic section. Thanks a lot for your help