[Maybe] Double DB mysql and can´t login
The default login is admin / admin. If it doesn't work, you must have changed it or removed the user.
Thank you very much @Anton, let me see my conf/traccar/traccar.xml to chek what datas are in <entry key>
after that i DROP my user and DATABASE not corresponding with the entry key
I can't delete it, how it works? I try this
mysql> SELECT User, Host FROM mysql.user;
+------------------+-----------+
| User | Host |
+------------------+-----------+
| david | localhost |
| debian-sys-maint | localhost |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+------------------+-----------+
6 rows in set (0.02 sec)
mysql> DROP USER 'david'@'localhost'
-> nothing happened after that
MySQL website has pretty extensive documentation if you want to understand how to manage the database user. There's also a million other resources. That's not really something specific to Traccar.
Fix it, the last ;
mysql> SELECT User, Host FROM mysql.user;
+------------------+-----------+
| User | Host |
+------------------+-----------+
| debian-sys-maint | localhost |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+------------------+-----------+
5 rows in set (0.82 sec)Thank you Anton
Let me show you something about traccar mysql and VPS
sudo vim /opt/traccar/conf/traccar.xml
<entry key='database.driver'>com.mysql.cj.jdbc.Driver</entry>
<entry key='database.url'>jdbc:mysql://10.0.0.11:3306/mottrack?serverTimezone=UTC&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
<entry key='database.user'>root</entry>
<entry key='database.password'>root</entry>in the entery key database you can see an ip port and DB; 10.0.0.11:3306/
That is an private IP and I have that in my VPS Oracle, so, assuming mi ip is 123.456.78.90 Can or need I change my traccar.xml and put my ip 123.456.78.90:3306/traccar to make it work and enter data into my database? Something like that... https://www.traccar.org/mysql/
Usually we recommend using localhost there if the database is local, but have you actually checked the logs to see if there's any problem with the database connection? I feel like you're jumping between some completely random things.
I certainly don't understand any of this, it's not my field, mine is art/musician.
If I'm on an Oracle VPS, is this localhost?
By localhost I understand a server mounted on my PC, like traccar installed on my PC, but I'm on an OCI (Oracle Cloud Infrastructure), what's local about that?
That's why reading theirs tutorials like this one https://www.traccar.org/mysql/, I try to understand what I should do for a better operation, without having hardly any knowledge of this, that's why I ask for your help until everything is well configured.
Sorry for the questions and issues that I understand may not be well posed.
I'll try to see logs or something, the OCI machine sometimes is stopped.
Thnks Anton
Have you tried following this guide on a clean Ubuntu server?
https://www.traccar.org/install-digitalocean/
I'm pretty sure you can do it with Oracle VPS.
Yes, and I do some question about that. https://www.traccar.org/forums/topic/i-dont-know-if-i-have-myql-database-on-vps/#post-76761
For now a little bit log
2022-10-13 19:24:00 WARN: Unable to release Session Session@6d5b15bb{id=node02dn3b998gbsjtrt2cuhe4p650,x=node02dn3b998gbsjtrt2cuhe4p650.node0,req=0,res=true} - InterruptedException (...)
2022-10-13 19:24:13 INFO: [T14216c20] id: 359339075269547, time: 2022-10-13 14:27:20, lat: 39.33661, lon: -5.90441, course: 209.0
2022-10-13 19:24:13 INFO: [T14216c20: topin < 84.78.247.6] 78781511160a0d0e1b1e9f0438672000a22d8a003ce90206000d0a
2022-10-13 19:24:13 INFO: [T14216c20: topin > 84.78.247.6] 78781511160a0d0e1b1e0d0a
2022-10-13 19:24:37 INFO: [T14216c20] id: 359339075269547, time: 2022-10-13 14:27:30, lat: 39.33627, lon: -5.90472, course: 233.0
2022-10-13 19:24:38 INFO: [T14216c20: topin < 84.78.247.6] 78781511160a0d0e1b379f043860e100a239b4003cef020f000d0a
2022-10-13 19:24:38 INFO: [T14216c20: topin > 84.78.247.6] 78781511160a0d0e1b370d0a
2022-10-13 19:25:44 INFO: [T14216c20] id: 359339075269547, time: 2022-10-13 14:27:55, lat: 39.33538, lon: -5.90645, course: 239.0
2022-10-13 19:25:44 INFO: [T14216c20: topin < 84.78.247.6] 78781511160a0d0e1c069f04385f3400a23d47003ce90209000d0a
2022-10-13 19:25:46 INFO: [T14216c20: topin > 84.78.247.6] 78781511160a0d0e1c060d0a
2022-10-13 19:26:52 WARN: Unable to release Session Session@6d5b15bb{id=node02dn3b998gbsjtrt2cuhe4p650,x=node02dn3b998gbsjtrt2cuhe4p650.node0,req=0,res=true} - InterruptedException (...)
2022-10-13 19:32:03 INFO: Operating system name: Linux version: 5.15.0-1016-oracle architecture: amd64
2022-10-13 19:32:03 INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: ojdkbuild version: 11.0.15+10-LTS
2022-10-13 19:32:03 INFO: Memory limit heap: 233mb non-heap: 0mb
2022-10-13 19:32:03 INFO: Character encoding: UTF-8 charset: UTF-8
2022-10-13 19:32:03 INFO: Version: 5.3
2022-10-13 19:32:03 INFO: Starting server...
2022-10-13 19:32:05 INFO: HikariPool-1 - Starting...
2022-10-13 19:32:08 WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2022-10-13 19:32:11 INFO: HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@1c65121
2022-10-13 19:32:11 INFO: HikariPool-1 - Start completed.
2022-10-13 19:32:16 INFO: Clearing database change log checksums
2022-10-13 19:32:21 INFO: Successfully acquired change log lock
2022-10-13 19:32:24 INFO: Successfully released change log lock
2022-10-13 19:32:25 INFO: Successfully acquired change log lock
2022-10-13 19:32:25 INFO: Cannot load service: liquibase.parser.ChangeLogParser: liquibase.parser.core.json.JsonChangeLogParser Unable to get public no-arg constructor
2022-10-13 19:32:25 INFO: Cannot load service: liquibase.parser.ChangeLogParser: liquibase.parser.core.yaml.YamlChangeLogParser Unable to get public no-arg constructorYour logs show that everything is working.
it is very simple taking into account your previous contribution regarding the traccar.xml configuration if the database is in the same vps where you have traccar, that is, it is local in the traccar configuration URL it should be as localhosto and not with another ip Since it's local, you should only put ip in your mysql traccar config if the mysql database is on another server. but in your case it is local so I recommend that you use the configuration that I will provide
<string key='database.driver'>com.mysql.cj.jdbc.Driver</string>
<string key='database.url'>jdbc:mysql://localhost:3306/mottrack?serverTimezone=UTC&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</string>
<string key='database.user'>root</string>
<string key='database.password'>root</string>Make sure that both the name, username and password of the database match the lines that you will put in traccar xml, and if you are going to connect to your local database create the username as for example david@localhost
with what I told you you should solve your connection problem, when I was learning I had a similar problem with this information you solve it.
Although no one told me, I had to search the internet and read the documentation, which I recommend you read and analyze and watch videos on YouTube where there is good information, which would be good for you in the long term so that you are not depending on others. that it is something complex but I encourage you to investigate the subject and learn, it can take some time but it is very beneficial
Spanish:
Gracias a ambos.
¿De dónde eres? @control taken, bien supongamos que de UK. Pues intenta comprender Linux, servidores en la nube, conexiones de túnel para escapar cg-nat, MySQL, y traccar siguiendo post y tutoriales en castellano o español, hazlo durante veinte minutos o media hora, y luego me dices cómo te sentiste.
Gracias por vuestra ayuda.
Ok, @Anton and @control taken, let me show you what is the manual that I follow because it is exactly to install Traccar and MySQL in an Oracle VPS (OCI), this manual is in Spanish and the OP says that he makes 2 instances (one for MySQL and another for traccar) because MySQL consumes a lot of resources.
After generate ssh key an Connect he make MySQL install, configure It and after install traccar.
Please read and translate if you need, and after we can discuss, because my same VPS still don't work good whell...go to
https://mundogps.org/instalacion-traccar-y-mysql-en-oracle-vps/
Please, need help with mysql
Please be empathetic with me, for me this is complex but I use my shortcuts to try to understand it.
I think I have 2 databases in my clumsy attempt to create one, when maybe there was already another one. This is what mysql SHOW DATABE throws at me.
and this is my user of mysql
The query or question is that now after deleting the cookies to access traccar ip xxx.xx.xx.xx:8082 it asks me for email / password and I can't find what it should be; admin / admin doesn't work, root@localhost / root doesn't either, root / root neither and I don't know where to look for my login solution and see if the tracker responds, goes online and sends data.
I hope you can help me.
Greetings and thanks.