Go Location Logger

A simple Go program that handles location data sent via HTTP POST requests and inserts it into a MySQL database.

Features

Handles JSON payloads containing location data.
Inserts location data into a MySQL database.
Utilizes headers X-Limit-U and X-Limit-D for specifying user and device information in HTTP requests.

Prerequisites

Before running the program, ensure you have the following:

Go installed: https://golang.org/doc/install
Docker and Docker Compose installed: https://docs.docker.com/get-docker/

Installation

Clone the repository:

git clone https://code.brothertec.eu/simono41/go-location-logger.git

Navigate to the project directory:
```
cd go-location-logger
```
Install dependencies:
```
go get -u github.com/sirupsen/logrus
```

Create an .env file in the project root with your environment variables:

# .env

DB_USER=your_db_user
DB_PASSWORD=your_db_password
DB_HOST=your_db_host
DB_PORT=your_db_port
DB_NAME=your_db_name

Create Database Table

CREATE TABLE `locations` (
  `dt` timestamp NULL DEFAULT NULL,
  `tid` char(2) DEFAULT NULL,
  `lat` decimal(9,6) DEFAULT NULL,
  `lon` decimal(9,6) DEFAULT NULL,
  `batt` int(11) DEFAULT NULL,
  `vac` int(11) DEFAULT NULL,
  `device` varchar(255) DEFAULT NULL,
  `user` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

Usage

Running with Docker Compose

Use Docker Compose to start the services:
```
docker-compose up -d
```
Access your Go application at http://localhost:8080. Make HTTP POST requests as described in the README.md.
Import the Grafana Dashboard from dashboard.json. Use the Grafana UI to import the dashboard and visualize your data.
To stop the services, run:
```
docker-compose down
```

Running without Docker

If you prefer not to use Docker, you can run the Go application directly using:

go run main.go

The server will start on http://localhost:8080.

Make a POST request with a JSON payload to http://localhost:8080/?device=your_device&user=your_user. The JSON payload should include location data.

Example:

curl -X POST -H "Content-Type: application/json" \
  -H "X-Limit-U: your_user" \
  -H "X-Limit-D: your_device" \
  -H "Authorization: Basic your_token" \
  -d '{
    "_type": "location",
    "tst": 1700820453,
    "lat": 37.7749,
    "lon": -122.4194,
    "alt": 90,
    "batt": 94,
    "acc": 35,
    "bs": 2,
    "p": 99.314,
    "created_at": 1700820457,
    "BSSID": "e8:48:b8:7f:b4:d4",
    "SSID": "Mr.Puhu",
    "vac": 20,
    "tag": "Arbeit",
    "topic": "owntracks/simono41/6193B679-AD67-4B93-9DF2-158501A055AF",
    "conn": "w",
    "m": 1,
    "tid": "AF"
  }' \
  http://localhost:8080/

Contributing

Feel free to open issues or submit pull requests.

License

This project is licensed under the MIT License - see the LICENSE file for details.

3.2 KiB Raw Permalink Blame History