New Install - No Web Server

sdntecha month ago

Hi Folks,

I conducted a fresh install of Ubuntu Server, and while the Traccar services are running fine, there is no web server operational after the successful installation. Below is a snippet of the configuration: I've hardcoded the web port to 80, but there is no output when I run netstat | grep 80.

I'm not sure what else I can do to start the web server. I would appreciate any help you can provide.

root@ip-172-31-24-185:/home/ubuntu# systemctl status traccar
● traccar.service - traccar
     Loaded: loaded (/etc/systemd/system/traccar.service; enabled; vendor preset: enabled)
     Active: active (running) since Mon 2024-11-25 04:43:13 UTC; 49s ago
   Main PID: 1756 (java)
      Tasks: 15 (limit: 1078)
     Memory: 88.3M
        CPU: 2.446s
     CGroup: /system.slice/traccar.service
             └─1756 /opt/traccar/jre/bin/java -jar tracker-server.jar conf/traccar.xml

Nov 25 04:43:13 ip-172-31-24-185 systemd[1]: Started traccar.
!
root@ip-172-31-24-185:/home/ubuntu# cat /opt/traccar/conf/traccar.xml
    entry key='web.port'>80</entry>
</properties>
root@ip-172-31-24-185:/home/ubuntu# netstat -tanlp | grep 80
Anton Tananaeva month ago

Have you checked logs?

sdntecha month ago

I investigated the logs; nothing related to the web server was found. However, I do find the Database repeatedly going back to a locked state. 

2024-11-26 00:55:13  INFO: Waiting for changelog lock....
2024-11-26 00:55:23 ERROR: Main method error - Database is in a locked state. It could be due to early service termination on a previous launch. To unlock you can run this query: 'UPDATE DATABASECHANGELOGLOCK SET locked = 0'. Make sure the schema is up to date before unlocking the database. - DatabaseLockException (DatabaseModule:102 < <gener:-1 < *:-1 < ... < MainModule:138 < <gener:-1 < ...)
2024-11-26 00:55:34  INFO: Operating system name: Linux version: 6.8.0-1015-aws architecture: amd64
2024-11-26 00:55:34  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Eclipse Adoptium version: 21.0.4+7-LTS
2024-11-26 00:55:34  INFO: Memory limit heap: 222mb non-heap: 0mb
2024-11-26 00:55:34  INFO: Character encoding: UTF-8
2024-11-26 00:55:34  INFO: Version: 6.5
2024-11-26 00:55:34  INFO: Starting server...
2024-11-26 00:55:34  INFO: HikariPool-1 - Starting...
2024-11-26 00:55:35  INFO: HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@5395ea39
2024-11-26 00:55:35  INFO: HikariPool-1 - Start completed.
2024-11-26 00:55:35  INFO: Clearing database change log checksums
2024-11-26 00:55:36  INFO: Successfully acquired change log lock
2024-11-26 00:55:36  INFO: Successfully released change log lock
2024-11-26 00:55:39  INFO: Reading from traccarDB.DATABASECHANGELOG
2024-11-26 00:55:40  WARN: Due to mysql SQL limitations, setNullable will lose primary key/autoincrement/not null/comment settings explicitly redefined in the change. Use <sql> or <modifySql> to re-specify all configuration if this is the case
2024-11-26 00:55:40  WARN: Due to mysql SQL limitations, modifyDataType will lose primary key/autoincrement/not null/comment settings explicitly redefined in the change. Use <sql> or <modifySql> to re-specify all configuration if this is the case
2024-11-26 00:55:40  WARN: Due to mysql SQL limitations, addDefaultValue will lose primary key/autoincrement/not null/comment settings explicitly redefined in the change. Use <sql> or <modifySql> to re-specify all configuration if this is the case
2024-11-26 00:55:40  WARN: Due to mysql SQL limitations, setNullable will lose primary key/autoincrement/not null/comment settings explicitly redefined in the change. Use <sql> or <modifySql> to re-specify all configuration if this is the case
2024-11-26 00:55:40  WARN: Due to mysql SQL limitations, modifyDataType will lose primary key/autoincrement/not null/comment settings explicitly redefined in the change. Use <sql> or <modifySql> to re-specify all configuration if this is the case
2024-11-26 00:55:40  WARN: Due to mysql SQL limitations, addDefaultValue will lose primary key/autoincrement/not null/comment settings explicitly redefined in the change. Use <sql> or <modifySql> to re-specify all configuration if this is the case
2024-11-26 00:55:40  INFO: Successfully acquired change log lock
2024-11-26 00:55:40  INFO: Using deploymentId: 2582540420
2024-11-26 00:55:40  INFO: Reading from traccarDB.DATABASECHANGELOG
2024-11-26 00:55:41  INFO: Table tc_attributes created
2024-11-26 00:55:41  INFO: Table tc_calendars created
2024-11-26 00:55:41  INFO: Table tc_commands created
2024-11-26 00:55:41  INFO: Table tc_device_attribute created
2024-11-26 00:55:41  INFO: Table tc_device_command created
2024-11-26 00:55:41  INFO: Table tc_device_driver created
2024-11-26 00:55:41  INFO: Table tc_device_geofence created
2024-11-26 00:55:41  INFO: Table tc_device_maintenance created
2024-11-26 00:55:41  INFO: Table tc_device_notification created
2024-11-26 00:55:41  INFO: Table tc_devices created
2024-11-26 00:55:41  INFO: Table tc_drivers created
2024-11-26 00:55:41  INFO: Table tc_events created
2024-11-26 00:55:41  INFO: Table tc_geofences created
2024-11-26 00:55:41  INFO: Table tc_group_attribute created
2024-11-26 00:55:41  INFO: Table tc_group_command created
2024-11-26 00:55:41  INFO: Table tc_group_driver created
2024-11-26 00:55:42  INFO: Table tc_group_geofence created
2024-11-26 00:55:42  INFO: Table tc_group_maintenance created
2024-11-26 00:55:42  INFO: Table tc_group_notification created
2024-11-26 00:55:42  INFO: Table tc_groups created
2024-11-26 00:55:42  INFO: Table tc_maintenances created
2024-11-26 00:55:42  INFO: Table tc_notifications created
2024-11-26 00:55:42  INFO: Table tc_positions created
2024-11-26 00:55:42  INFO: Table tc_servers created
2024-11-26 00:55:42  INFO: Table tc_statistics created
2024-11-26 00:55:42  INFO: Table tc_user_attribute created
2024-11-26 00:55:42  INFO: Table tc_user_calendar created
2024-11-26 00:55:42  INFO: Table tc_user_command created
2024-11-26 00:55:42  INFO: Table tc_user_device created
2024-11-26 00:55:42  INFO: Table tc_user_driver created
2024-11-26 00:55:42  INFO: Table tc_user_geofence created
2024-11-26 00:55:42  INFO: Table tc_user_group created
2024-11-26 00:55:42  INFO: Table tc_user_maintenance created
2024-11-26 00:55:42  INFO: Table tc_user_notification created
2024-11-26 00:55:42  INFO: Table tc_user_user created
2024-11-26 00:55:42  INFO: Table tc_users created
2024-11-26 00:55:43  INFO: Foreign key constraint added to tc_device_command (commandid)
2024-11-26 00:55:43  INFO: Foreign key constraint added to tc_device_command (deviceid)
2024-11-26 00:55:43  INFO: Foreign key constraint added to tc_device_driver (deviceid)
2024-11-26 00:55:43  INFO: Foreign key constraint added to tc_device_driver (driverid)
2024-11-26 00:55:43  INFO: Foreign key constraint added to tc_device_geofence (deviceid)
2024-11-26 00:55:43  INFO: Foreign key constraint added to tc_device_geofence (geofenceid)
2024-11-26 00:55:43  INFO: Foreign key constraint added to tc_device_maintenance (deviceid)
2024-11-26 00:55:43  INFO: Foreign key constraint added to tc_device_maintenance (maintenanceid)
2024-11-26 00:55:44  INFO: Foreign key constraint added to tc_device_notification (deviceid)
2024-11-26 00:55:44  INFO: Foreign key constraint added to tc_device_notification (notificationid)
2024-11-26 00:55:44  INFO: Foreign key constraint added to tc_devices (groupid)
2024-11-26 00:55:44  INFO: Foreign key constraint added to tc_events (deviceid)
2024-11-26 00:55:44  INFO: Foreign key constraint added to tc_geofences (calendarid)
2024-11-26 00:55:44  INFO: Foreign key constraint added to tc_group_attribute (attributeid)
2024-11-26 00:55:44  INFO: Foreign key constraint added to tc_group_attribute (groupid)
2024-11-26 00:55:45  INFO: Foreign key constraint added to tc_group_command (commandid)
2024-11-26 00:55:45  INFO: Foreign key constraint added to tc_group_command (groupid)
2024-11-26 00:55:45  INFO: Foreign key constraint added to tc_group_driver (driverid)
2024-11-26 00:55:45  INFO: Foreign key constraint added to tc_group_driver (groupid)
2024-11-26 00:55:45  INFO: Foreign key constraint added to tc_group_geofence (geofenceid)
2024-11-26 00:55:45  INFO: Foreign key constraint added to tc_group_geofence (groupid)
2024-11-26 00:55:45  INFO: Foreign key constraint added to tc_group_maintenance (groupid)
2024-11-26 00:55:45  INFO: Foreign key constraint added to tc_group_maintenance (maintenanceid)
2024-11-26 00:55:46  INFO: Foreign key constraint added to tc_group_notification (groupid)
2024-11-26 00:55:46  INFO: Foreign key constraint added to tc_group_notification (notificationid)
2024-11-26 00:55:46  INFO: Foreign key constraint added to tc_notifications (calendarid)
2024-11-26 00:55:46  INFO: Foreign key constraint added to tc_positions (deviceid)
2024-11-26 00:55:46  INFO: Foreign key constraint added to tc_user_attribute (attributeid)
2024-11-26 00:55:46  INFO: Foreign key constraint added to tc_user_attribute (userid)
2024-11-26 00:55:46  INFO: Foreign key constraint added to tc_user_calendar (calendarid)
2024-11-26 00:55:46  INFO: Foreign key constraint added to tc_user_calendar (userid)
2024-11-26 00:55:47  INFO: Foreign key constraint added to tc_user_command (commandid)
2024-11-26 00:55:47  INFO: Foreign key constraint added to tc_user_command (userid)
2024-11-26 00:55:47  INFO: Foreign key constraint added to tc_device_attribute (attributeid)
2024-11-26 00:55:47  INFO: Foreign key constraint added to tc_device_attribute (deviceid)
2024-11-26 00:55:47  INFO: Foreign key constraint added to tc_user_device (deviceid)
2024-11-26 00:55:47  INFO: Foreign key constraint added to tc_user_device (userid)
2024-11-26 00:55:47  INFO: Foreign key constraint added to tc_user_driver (driverid)
2024-11-26 00:55:47  INFO: Foreign key constraint added to tc_user_driver (userid)
2024-11-26 00:55:50  INFO: Operating system name: Linux version: 6.8.0-1015-aws architecture: amd64
2024-11-26 00:55:50  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Eclipse Adoptium version: 21.0.4+7-LTS
2024-11-26 00:55:50  INFO: Memory limit heap: 222mb non-heap: 0mb
2024-11-26 00:55:50  INFO: Character encoding: UTF-8
2024-11-26 00:55:50  INFO: Version: 6.5
2024-11-26 00:55:50  INFO: Starting server...
2024-11-26 00:55:50  INFO: HikariPool-1 - Starting...
2024-11-26 00:55:51  INFO: HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@5395ea39
2024-11-26 00:55:51  INFO: HikariPool-1 - Start completed.
2024-11-26 00:55:51  INFO: Clearing database change log checksums
2024-11-26 00:55:52  INFO: Waiting for changelog lock....
2024-11-26 00:56:02  INFO: Waiting for changelog lock....
2024-11-26 00:56:12  INFO: Waiting for changelog lock....
2024-11-26 00:56:22  INFO: Waiting for changelog lock....
2024-11-26 00:56:32  INFO: Waiting for changelog lock....
2024-11-26 00:56:42  INFO: Waiting for changelog lock....
2024-11-26 00:56:52 ERROR: Main method error - Database is in a locked state. It could be due to early service termination on a previous launch. To unlock you can run this query: 'UPDATE DATABASECHANGELOGLOCK SET locked = 0'. Make sure the schema is up to date before unlocking the database. - DatabaseLockException (DatabaseModule:102 < <gener:-1 < *:-1 < ... < MainModule:138 < <gener:-1 < ...)
2024-11-26 00:57:04  INFO: Operating system name: Linux version: 6.8.0-1015-aws architecture: amd64
2024-11-26 00:57:04  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Eclipse Adoptium version: 21.0.4+7-LTS
2024-11-26 00:57:04  INFO: Memory limit heap: 222mb non-heap: 0mb
2024-11-26 00:57:04  INFO: Character encoding: UTF-8
2024-11-26 00:57:04  INFO: Version: 6.5
2024-11-26 00:57:04  INFO: Starting server...
2024-11-26 00:57:04  INFO: HikariPool-1 - Starting...
2024-11-26 00:57:05  INFO: HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@5395ea39
2024-11-26 00:57:05  INFO: HikariPool-1 - Start completed.
2024-11-26 00:57:05  INFO: Clearing database change log checksums
2024-11-26 00:57:05  INFO: Waiting for changelog lock....
2024-11-26 00:57:15  INFO: Waiting for changelog lock....
2024-11-26 00:57:25  INFO: Waiting for changelog lock....
2024-11-26 00:57:35  INFO: Waiting for changelog lock....
2024-11-26 00:57:45  INFO: Waiting for changelog lock....
2024-11-26 00:57:55  INFO: Waiting for changelog lock....
2024-11-26 00:58:06 ERROR: Main method error - Database is in a locked state. It could be due to early service termination on a previous launch. To unlock you can run this query: 'UPDATE DATABASECHANGELOGLOCK SET locked = 0'. Make sure the schema is up to date before unlocking the database. - DatabaseLockException (DatabaseModule:102 < <gener:-1 < *:-1 < ... < MainModule:138 < <gener:-1 < ...)
2024-11-26 00:58:17  INFO: Operating system name: Linux version: 6.8.0-1015-aws architecture: amd64
2024-11-26 00:58:17  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Eclipse Adoptium version: 21.0.4+7-LTS
2024-11-26 00:58:17  INFO: Memory limit heap: 222mb non-heap: 0mb
2024-11-26 00:58:17  INFO: Character encoding: UTF-8
2024-11-26 00:58:17  INFO: Version: 6.5
2024-11-26 00:58:17  INFO: Starting server...
2024-11-26 00:58:17  INFO: HikariPool-1 - Starting...
2024-11-26 00:58:18  INFO: HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@5395ea39
2024-11-26 00:58:18  INFO: HikariPool-1 - Start completed.
2024-11-26 00:58:18  INFO: Clearing database change log checksums
2024-11-26 00:58:18  INFO: Waiting for changelog lock....
ubuntu@ip-172-31-24-185:/opt/traccar/logs$
Anton Tananaeva month ago

Have you unlocked it?

sdntecha month ago

Yes I did.

Anton Tananaeva month ago

It means the migration hasn't finished properly.