AWS Ubuntu checking data in Mysql DB

Log_232 years ago

I have followed the Ubuntu installation steps in AWS EC2 Ubuntu machine and I am able to run the traccar server through the console. The device can able to send the data to aws ec2 instance and i can find it in the log file as like data from anonymous device. I checked traccar database, cant find the data in any of the mysql tables. Even I have cross checked using small python socket script and I confirmed that data is coming to the server.

I would like to know, is there any steps need to follow to add the device in my db or anything else I need to do once after I ran the traccar server?

Anton Tananaev2 years ago

What exactly do you see in the logs? Have you checked the troubleshooting guide?

Track-trace2 years ago

You need to add the device through the web login. From log you can see what the device ID is. You need to translate the Hex. If you dont understand then Just paste the log content here..

Log_232 years ago

Hi Anton and Track-trace,
Its working now, Once after I have added the device through the web login I can see the device. Thanks for your quick reply.

I like to configure to my firebase database, Like to design own mobile and web app based on my requirement.
So I prefered firebase. Is there any suggestion shall I go with that?
If it so, May I know what are the changes I need to do in these traccar code?
is there any discussion in these forum related to that? Could you please help me on this.
Thanks in Advance.

Anton Tananaev2 years ago

Traccar supports firebase out of the box. No code changes needed.

Log_232 years ago

Thanks for your reply Anton.
-- If I am changing my DB in conf.xml to firebase realtime DB, I need to make any changes in code?

My plan is to setup an angular customized app as frontend and that connected to Firebase to get the data [ past history, alerts, realtime tracking].
If user set any speed limit in front end that I need to pass to backend via firebase.
If device sends any alarm that will pass to DB and due to realtime DB it appears in frontend app as notification.

Is this correct way, can I alter the code to this requirement any where the code will breaks or any suggestion it will help me much.

Thanks n Advance

Anton Tananaev2 years ago

Sorry, I misread. You want to use the Firebase for database, not push notifications. That's not supported.

Log_232 years ago

Yes yes. Thanks Antov. So I can use either Mysql or Postgress to store the data for history. and use firebase for push notification. Is am correct?

In that case, In what way we can send the user inputs (ex. speed limit value, geofence value.) to backend traccar code. any suggested flow?

Anton Tananaev2 years ago

Correct.

Not sure I understand the question about user inputs.

Log_232 years ago

So to get alarm and notification from backend we can use firebase push notification. In another hand, If user want to do fuel cutoff he select the option in front end and it need to send it to the device through server.
I like to know what are the possible ways to connect front end and back end to send the fuel cut off signal or setting sleep mode, set tracking interval, set ip etc.

Anton Tananaev2 years ago

Send a command via the API?

Log_232 years ago

Emm okay... So I can send it to server via API from front end.

To which function in the traccar server code I need to point that API?

Anton Tananaev2 years ago

The question makes no sense. The API is what the server exposes. You don't point the API to anything.

We have the API documentation, so make sure to read it first before asking questions.

Log_232 years ago

Thanks Anton.

I like to understand the database in detail, Is there any link which has details about the tables?

Anton Tananaev2 years ago

There's no schema documentation, but the table/column names are pretty self explanatory.