Port is closed

Magudash 7 years ago

Hello,
windows server 2016 with mssql data base
I installed traccar, configure MSSQL config traccar.xml I created the database name also . and start service I see that the tables have been created.
but site I have the following error message (This site can’t be reached)

Log file

2018-09-01 11:30:53  INFO: Operating system name: Windows Server 2016 version: 10.0 architecture: amd64
2018-09-01 11:30:53  INFO: Java runtime name: Java HotSpot(TM) 64-Bit Server VM vendor: Oracle Corporation version: 25.181-b13
2018-09-01 11:30:53  INFO: Memory limit heap: 2729mb non-heap: 0mb
2018-09-01 11:30:53  INFO: Character encoding: UTF-8 charset: UTF-8
2018-09-01 11:30:53  INFO: Version: 4.0-SNAPSHOT
2018-09-01 11:33:36  INFO: Operating system name: Windows Server 2016 version: 10.0 architecture: amd64
2018-09-01 11:33:36  INFO: Java runtime name: Java HotSpot(TM) 64-Bit Server VM vendor: Oracle Corporation version: 25.181-b13
2018-09-01 11:33:36  INFO: Memory limit heap: 2729mb non-heap: 0mb
2018-09-01 11:33:36  INFO: Character encoding: UTF-8 charset: UTF-8
2018-09-01 11:33:36  INFO: Version: 4.0-SNAPSHOT

Port check

port is closed i was configured firewall also disable

how can run server traccar application

Magudash 7 years ago

But default H2 data base running as use welly working fine but change MSSQL data base link haven't run

mdtaylorlrim 7 years ago

It sounds like you installed Traccar using admin privileges (so it created the tables, etc.) but Windows is running the service as a normal user without the correct privileges to run properly. But, I'm not a Windows person...

Magudash 7 years ago

WRAPPER.LOG

WARNING|wrapper|Service traccar|18-09-03 13:24:44|YAJSW: yajsw-stable-12.12
WARNING|wrapper|Service traccar|18-09-03 13:24:44|OS   : Windows Server 2016/10.0/amd64
WARNING|wrapper|Service traccar|18-09-03 13:24:44|JVM  : Oracle Corporation/1.8.0_181/C:\Program Files\Java\jre1.8.0_181/64
INFO|wrapper|Service traccar|18-09-03 13:24:44|start delay: 0
INFO|wrapper|Service traccar|18-09-03 13:24:44|started process with pid 2104
INFO|2104/0|Service traccar|18-09-03 13:24:45|[INFO] StandardFileSystemManager - Using "C:\Windows\TEMP\vfs_cache" as temporary files store.
INFO|2104/0|Service traccar|18-09-03 13:24:45|SLF4J: Class path contains multiple SLF4J bindings.
INFO|2104/0|Service traccar|18-09-03 13:24:45|SLF4J: Found binding in [jar:file:/D:/Traccar/Traccar/lib/slf4j-simple-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
INFO|2104/0|Service traccar|18-09-03 13:24:45|SLF4J: Found binding in [jar:file:/D:/Traccar/Traccar/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class]
INFO|2104/0|Service traccar|18-09-03 13:24:45|SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
INFO|2104/0|Service traccar|18-09-03 13:24:45|SLF4J: Actual binding is of type [org.slf4j.impl.SimpleLoggerFactory]
INFO|2104/0|Service traccar|18-09-03 13:24:45|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|2104/0|Service traccar|18-09-03 13:24:46|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
INFO|2104/0|Service traccar|18-09-03 13:24:46|[main] INFO liquibase.executor.jvm.JdbcExecutor - select schema_name()
INFO|2104/0|Service traccar|18-09-03 13:24:46|[main] INFO liquibase.executor.jvm.JdbcExecutor - SELECT CASE ServerProperty('EngineEdition')
INFO|2104/0|Service traccar|18-09-03 13:24:46|         WHEN 1 THEN 'Personal'
INFO|2104/0|Service traccar|18-09-03 13:24:46|         WHEN 2 THEN 'Standard'
INFO|2104/0|Service traccar|18-09-03 13:24:46|         WHEN 3 THEN 'Enterprise'
INFO|2104/0|Service traccar|18-09-03 13:24:46|         WHEN 4 THEN 'Express'
INFO|2104/0|Service traccar|18-09-03 13:24:46|         WHEN 5 THEN 'Azure'
INFO|2104/0|Service traccar|18-09-03 13:24:46|         ELSE 'Unknown'
INFO|2104/0|Service traccar|18-09-03 13:24:46|       END
INFO|2104/0|Service traccar|18-09-03 13:24:46|[main] INFO liquibase.Liquibase - Clearing database change log checksums
...
FINEST|2104/0|Service traccar|18-09-03 13:24:47|[main] ERROR liquibase.changelog.ChangeSet - Change Set changelog-4.0::changelog-4.0::author failed.  Error: The object 'DF_notifications_web' is dependent on column 'web'. [Failed SQL: ALTER TABLE tc_notifications DROP COLUMN web]
FINEST|2104/0|Service traccar|18-09-03 13:24:47|[main] INFO liquibase.executor.jvm.JdbcExecutor - select schema_name()
FINEST|2104/0|Service traccar|18-09-03 13:24:47|[main] INFO liquibase.lockservice.StandardLockService - Successfully released change log lock
FINEST|2104/0|Service traccar|18-09-03 13:24:47|java.lang.reflect.InvocationTargetException
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at java.lang.reflect.Method.invoke(Unknown Source)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set changelog-4.0::changelog-4.0::author:
FINEST|2104/0|Service traccar|18-09-03 13:24:47|     Reason: liquibase.exception.DatabaseException: The object 'DF_notifications_web' is dependent on column 'web'. [Failed SQL: ALTER TABLE tc_notifications DROP COLUMN web]
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:637)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:78)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at liquibase.Liquibase.update(Liquibase.java:202)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at liquibase.Liquibase.update(Liquibase.java:179)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at liquibase.Liquibase.update(Liquibase.java:175)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:307)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at org.traccar.database.DataManager.<init>(DataManager.java:88)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at org.traccar.Context.init(Context.java:361)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at org.traccar.Main.main(Main.java:35)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	... 6 more
FINEST|2104/0|Service traccar|18-09-03 13:24:47|Caused by: liquibase.exception.DatabaseException: The object 'DF_notifications_web' is dependent on column 'web'. [Failed SQL: ALTER TABLE tc_notifications DROP COLUMN web]
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1229)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1211)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:600)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	... 15 more
FINEST|2104/0|Service traccar|18-09-03 13:24:47|Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The object 'DF_notifications_web' is dependent on column 'web'.
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:857)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:757)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7347)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:734)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352)
FINEST|2104/0|Service traccar|18-09-03 13:24:47|	... 20 more
INFO|wrapper|Service traccar|18-09-03 13:24:48|calling onStop
INFO|wrapper|Service traccar|18-09-03 13:24:48|Win service stop - timeout: 30000
INFO|wrapper|Service traccar|18-09-03 13:24:48|Win service wrapper.control -> stopping application
INFO|wrapper|Service traccar|18-09-03 13:24:48|Win service stop - after shutdown
INFO|wrapper|Service traccar|18-09-03 13:24:48|Win service stop - before notify
INFO|wrapper|Service traccar|18-09-03 13:24:48|Win service terminated

Anton Tananaev 7 years ago

Have you tried searching before asking for help?

https://www.traccar.org/forums/topic/mssql-erorr-on-traccar-4/

Magudash 7 years ago

Thank you we have replaced on
https://github.com/traccar/traccar/blob/master/schema/changelog-4.0.xml

schema Changelog file as on working fine thank you sir