Cannot login after mysql installation
If it's a new database, registration should be enabled.
Register button at login page is disabled. How do I enable it again? Is there a corresponding control field/table in the traccar database that I can change using mysql console?
I reinstalled traccar, logged in ok and now Register button is enabled, created a new user;
Then I changed traccar.xml to enable H2 to mysql database I restarted traccar
Now the login page shows an error:
<html> <head><title>502 Bad Gateway</title></head> <body> <center><h1>502 Bad Gateway</h1></center> <hr><center>nginx/1.18.0 (Ubuntu)</center> </body> </html> Have you checked logs?
I see following error (recurring):
2023-08-05 22:46:09 INFO: Waiting for changelog lock....
2023-08-05 22:46:19 ERROR: Main method error - Could not acquire change log lock. Currently locked by server2.smartline.com.py
(104.251.212.47) since 8/5/23, 6:42 AM - LockException (... < DatabaseModule:95 < <gener:-1 < *:-1 < ... < MainModule:123 < ...)
2023-08-05 22:46:31 INFO: Operating system name: Linux version: 5.2.0 architecture: amd64
2023-08-05 22:46:31 INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Eclipse Adoptium version: 17.0.6+10
2023-08-05 22:46:31 INFO: Memory limit heap: 1536mb non-heap: 0mbserver2.smartline.com.py is the vps servers'name
I did a reboot on the server but the traccar's login page now says:
"NetworkError when attempting to fetch resource."Log error now is:
2023-08-05 23:08:17 WARN: Failed to restore the auto commit to true
2023-08-05 23:08:17 ERROR: Main method error - Communications link failure during rollback(). Transaction resolution unknown.
- SQLNonTransientConnectionException (... < DatabaseModule:95 < <gener:-1 < *:-1 < ... < MainModule:123 < ...)Looks like there's a lock in the database somewhere. You should go into your database and check what the problem is.
I installed a testing traccar server with default database and one admin user. I disabled new user registration ising settings > server > permissions > registration (unchecked).
Then I installed Mysql database and I did the corresponding changes in traccar.xml
Result: I loose my login credentials and cannot log to the server anymore. (sorry, I'm new to traccar).
Is there a way to recover access? How can I enable the registration button again?