I've tried all combinations in the config "traccar.xml" i keep getting invalid ipv6 address error in the log files:
2019-11-21 12:25:44 WARN: JNA: Callback org.traccar.WindowsService$ServiceMain@503f91c3 threw the following exception - The connection to the host [84.22.*.*][, named instance ecmssql] failed. Error: "java.net.UnknownHostException: [84.22.*.*][: invalid IPv6 address". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host. - SQLServerException (... < DataManager:139 < *:89 < Context:292 < Main:110 < ...)
with the configuration:
<entry key='database.driver'>com.microsoft.sqlserver.jdbc.SQLServerDriver</entry>
<entry key='database.driverFile'>./lib/mssql-jdbc-7.4.1.jre12.jar</entry>
<entry key='database.url'>jdbc:sqlserver://[84.22.*.*][\MSSQL];user=[User];password=[password];databaseName=[EverTracker];</entry>
<entry key='database.user'>[User]</entry>
<entry key='database.password'>[password]</entry>
I am sorry if there are any amateur mistakes because I am new to this, but also I've tried googling and doing my research by setting java arguments to favor ipv4 and disable ipv6 but i just can't get it working, it works just fine using h2 driver but I need it connected to MSSQL database so that I can synchronize databases between websites.
Thanks in advance for taking your time to read my problem.
Cheers
I've also opened all ports, but no good. Also ive hidden the ip for security reasons I don't want to risk it as it is for testing porpuses
traccar and mssql is installed on same machine ?
No they are on different machines,I can access the database from home using Microsoft SQL server managment studio.
I've self diagnosed my self with retardation, I didn't remove brackets [] and that fixed everything.
I've tried all combinations in the config "traccar.xml" i keep getting invalid ipv6 address error in the log files:
with the configuration:
<entry key='database.driver'>com.microsoft.sqlserver.jdbc.SQLServerDriver</entry> <entry key='database.driverFile'>./lib/mssql-jdbc-7.4.1.jre12.jar</entry> <entry key='database.url'>jdbc:sqlserver://[84.22.*.*][\MSSQL];user=[User];password=[password];databaseName=[EverTracker];</entry> <entry key='database.user'>[User]</entry> <entry key='database.password'>[password]</entry>
I am sorry if there are any amateur mistakes because I am new to this, but also I've tried googling and doing my research by setting java arguments to favor ipv4 and disable ipv6 but i just can't get it working, it works just fine using h2 driver but I need it connected to MSSQL database so that I can synchronize databases between websites.
Thanks in advance for taking your time to read my problem.
Cheers