Port is closed

Magudash6 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

Magudash6 years ago

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

mdtaylorlrim6 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...

Magudash6 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 Tananaev6 years ago

Have you tried searching before asking for help?

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

Magudash6 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