Hi,
I'm new to Traccar. I just installed Traccar on my Windows 8.1 pc.
When I try to access the website I can access it on my pc. When I try to access the website on another device (in the same network using my internal ip address or in another website using my external ip address), I just can't access it. When I try to send my location using the iOS client and using the port 5055, I get a 'send failed' error.
My router is configured to send all traffic to that pc, it works for my other applications like sickrage etc.
Any idea what might be wrong?
I added entry key='web.address', but that doesn't work.
I changed the port on which Traccar must run and that doesn't work.
I also added entry key='osmand.enable' to enable the iOS client, but that also doesn't work...
This is my config file:
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE properties SYSTEM 'http://java.sun.com/dtd/properties.dtd'>
<properties>
<!-- SERVER CONFIG -->
<entry key='web.enable'>true</entry>
<entry key='web.address'>*Dummy, here is my external dns name for my pc*</entry>
<entry key='web.port'>9999</entry>
<entry key='web.path'>C:\Program Files (x86)\Traccar\web</entry>
<entry key='geocoder.enable'>true</entry>
<entry key='geocoder.type'>google</entry>
<entry key='logger.enable'>true</entry>
<entry key='logger.level'>all</entry>
<entry key='logger.file'>C:\Program Files (x86)\Traccar\logs\tracker-server.log</entry>
<!-- DATABASE CONFIG -->
<entry key='database.driver'>org.h2.Driver</entry>
<entry key='database.url'>jdbc:h2:C:\Program Files (x86)\Traccar\data\database</entry>
<entry key='database.user'>sa</entry>
<entry key='database.password'></entry>
<entry key='database.checkTable'>traccar</entry>
<entry key='database.selectSchemaVersion'>
SELECT * FROM traccar;
</entry>
<entry key='database.createSchema'>
CREATE TABLE "user" (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(128) NOT NULL,
email VARCHAR(128) NOT NULL UNIQUE,
hashedPassword VARCHAR(128) NOT NULL,
salt VARCHAR(128) DEFAULT '' NOT NULL,
readonly BIT DEFAULT 0 NOT NULL,
admin BIT DEFAULT 0 NOT NULL,
map VARCHAR(128),
language VARCHAR(128),
distanceUnit VARCHAR(128),
speedUnit VARCHAR(128),
latitude FLOAT DEFAULT 0 NOT NULL,
longitude FLOAT DEFAULT 0 NOT NULL,
zoom INT DEFAULT 0 NOT NULL);
CREATE TABLE device (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(128) NOT NULL,
uniqueId VARCHAR(128) NOT NULL UNIQUE,
status VARCHAR(128),
lastUpdate TIMESTAMP,
positionId INT,
dataId INT);
CREATE TABLE user_device (
userId INT NOT NULL,
deviceId INT NOT NULL,
"read" BIT DEFAULT 1 NOT NULL,
"write" BIT DEFAULT 1 NOT NULL,
FOREIGN KEY (userId) REFERENCES "user" (id) ON DELETE CASCADE,
FOREIGN KEY (deviceId) REFERENCES device (id) ON DELETE CASCADE);
CREATE INDEX user_device_userId ON user_device(userId);
CREATE TABLE position (
id INT PRIMARY KEY AUTO_INCREMENT,
protocol VARCHAR(128),
deviceId INT NOT NULL,
serverTime TIMESTAMP NOT NULL,
deviceTime TIMESTAMP NOT NULL,
fixTime TIMESTAMP NOT NULL,
valid BIT NOT NULL,
latitude FLOAT NOT NULL,
longitude FLOAT NOT NULL,
altitude FLOAT NOT NULL,
speed FLOAT NOT NULL,
course FLOAT NOT NULL,
address VARCHAR(512),
other VARCHAR(4096) NOT NULL,
FOREIGN KEY (deviceId) REFERENCES device (id) ON DELETE CASCADE);
CREATE INDEX position_deviceId_fixTime ON position (deviceId, fixTime);
CREATE TABLE data (
id INT PRIMARY KEY AUTO_INCREMENT,
protocol VARCHAR(128),
deviceId INT NOT NULL,
serverTime TIMESTAMP NOT NULL,
deviceTime TIMESTAMP NOT NULL,
other VARCHAR(4096) NOT NULL,
FOREIGN KEY (deviceId) REFERENCES device (id) ON DELETE CASCADE);
ALTER TABLE device ADD
FOREIGN KEY (positionId) REFERENCES position (id) ON DELETE CASCADE;
ALTER TABLE device ADD
FOREIGN KEY (dataId) REFERENCES data (id) ON DELETE CASCADE;
CREATE TABLE server (
id INT PRIMARY KEY AUTO_INCREMENT,
registration BIT NOT NULL,
map VARCHAR(128),
language VARCHAR(128),
distanceUnit VARCHAR(128),
speedUnit VARCHAR(128),
latitude FLOAT DEFAULT 0 NOT NULL,
longitude FLOAT DEFAULT 0 NOT NULL,
zoom INT DEFAULT 0 NOT NULL);
CREATE TABLE traccar (
version INT DEFAULT 0 NOT NULL);
INSERT INTO traccar (version) VALUES (301);
</entry>
<entry key='database.selectServers'>
SELECT * FROM server;
</entry>
<entry key='database.insertServer'>
INSERT INTO server (registration, latitude, longitude, zoom)
VALUES (:registration, :latitude, :longitude, :zoom);
</entry>
<entry key='database.updateServer'>
UPDATE server SET
registration = :registration,
map = :map,
language = :language,
distanceUnit = :distanceUnit,
speedUnit = :speedUnit,
latitude = :latitude,
longitude = :longitude,
zoom = :zoom
WHERE id = :id;
</entry>
<entry key='database.loginUser'>
SELECT * FROM "user"
WHERE email = :email;
</entry>
<entry key='database.selectUser'>
SELECT * FROM "user"
WHERE id = :id;
</entry>
<entry key='database.selectUsersAll'>
SELECT * FROM "user";
</entry>
<entry key='database.insertUser'>
INSERT INTO "user" (name, email, hashedPassword, salt, admin)
VALUES (:name, :email, :hashedPassword, :salt, :admin);
</entry>
<entry key='database.updateUser'>
UPDATE "user" SET
name = :name,
email = :email,
admin = :admin,
map = :map,
language = :language,
distanceUnit = :distanceUnit,
speedUnit = :speedUnit,
latitude = :latitude,
longitude = :longitude,
zoom = :zoom
WHERE id = :id;
</entry>
<entry key='database.updateUserPassword'>
UPDATE "user" SET hashedPassword = :hashedPassword, salt = :salt WHERE id = :id;
</entry>
<entry key='database.deleteUser'>
DELETE FROM "user" WHERE id = :id;
</entry>
<entry key='database.getPermissionsAll'>
SELECT userId, deviceId FROM user_device;
</entry>
<entry key='database.selectDevicesAll'>
SELECT * FROM device;
</entry>
<entry key='database.selectDevices'>
SELECT * FROM device d INNER JOIN user_device ud ON d.id = ud.deviceId WHERE ud.userId = :userId;
</entry>
<entry key='database.insertDevice'>
INSERT INTO device (name, uniqueId) VALUES (:name, :uniqueId);
</entry>
<entry key='database.updateDevice'>
UPDATE device SET name = :name, uniqueId = :uniqueId WHERE id = :id;
</entry>
<entry key='database.deleteDevice'>
DELETE FROM device WHERE id = :id;
</entry>
<entry key='database.linkDevice'>
INSERT INTO user_device (userId, deviceId) VALUES (:userId, :deviceId);
</entry>
<entry key='database.selectPositions'>
SELECT * FROM position WHERE deviceId = :deviceId AND fixTime BETWEEN :from AND :to;
</entry>
<entry key='database.insertPosition'>
INSERT INTO position (deviceId, protocol, serverTime, deviceTime, fixTime, valid, latitude, longitude, altitude, speed, course, address, other)
VALUES (:deviceId, :protocol, CURRENT_TIMESTAMP(), :time, :time, :valid, :latitude, :longitude, :altitude, :speed, :course, :address, :other);
</entry>
<entry key='database.selectLatestPositions'>
SELECT * FROM position WHERE id IN (SELECT positionId FROM device);
</entry>
<entry key='database.updateLatestPosition'>
UPDATE device SET positionId = :id WHERE id = :deviceId;
</entry>
<!-- PROTOCOL CONFIG -->
<entry key='gps103.port'>5001</entry>
...
<entry key='cityeasy.port'>5088</entry>
</properties>
Hi,
I'm new to Traccar. I just installed Traccar on my Windows 8.1 pc.
When I try to access the website I can access it on my pc. When I try to access the website on another device (in the same network using my internal ip address or in another website using my external ip address), I just can't access it. When I try to send my location using the iOS client and using the port 5055, I get a 'send failed' error.
My router is configured to send all traffic to that pc, it works for my other applications like sickrage etc.
Any idea what might be wrong?
I added entry key='web.address', but that doesn't work.
I changed the port on which Traccar must run and that doesn't work.
I also added entry key='osmand.enable' to enable the iOS client, but that also doesn't work...
This is my config file: