2022-08-22 09:02:17 +00:00
|
|
|
# sshmon
|
|
|
|
### Utility to monitor uptime of servers/services
|
|
|
|
|
|
|
|
## First configuration
|
|
|
|
1. Create docker image
|
|
|
|
- `$ docker build -t sshmon .`
|
|
|
|
|
|
|
|
2. Setup containers
|
|
|
|
- `$ docker-compose up -d`
|
|
|
|
|
|
|
|
- This will open ports 3306 for database, 8080 for main app and 8081 for phpMyAdmin
|
|
|
|
|
|
|
|
3. Create database and tables
|
|
|
|
- Script does not create database and tables by default
|
2022-08-24 08:39:08 +00:00
|
|
|
- Create database `sshmon` with 3 tables:
|
2022-08-22 09:02:17 +00:00
|
|
|
<table>
|
|
|
|
<thead>
|
|
|
|
<tr>
|
|
|
|
<th colspan=3>ips</th>
|
|
|
|
</tr>
|
|
|
|
</thead>
|
|
|
|
<tbody>
|
|
|
|
<tr>
|
|
|
|
<td>Name</td>
|
|
|
|
<td>Type</td>
|
|
|
|
<td>Extra</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>id</td>
|
|
|
|
<td>int</td>
|
|
|
|
<td>AUTO_INCREMENT PRIMARY KEY</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>ip</td>
|
|
|
|
<td>varchar(255)</td>
|
|
|
|
<td></td>
|
|
|
|
</tr>
|
|
|
|
</tbody>
|
|
|
|
</table>
|
|
|
|
<table>
|
|
|
|
<thead>
|
|
|
|
<tr>
|
|
|
|
<th colspan=3>users</th>
|
|
|
|
</tr>
|
|
|
|
</thead>
|
|
|
|
<tbody>
|
|
|
|
<tr>
|
|
|
|
<td>Name</td>
|
|
|
|
<td>Type</td>
|
|
|
|
<td>Extra</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>id</td>
|
|
|
|
<td>int</td>
|
|
|
|
<td>AUTO_INCREMENT PRIMARY KEY</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>username</td>
|
|
|
|
<td>varchar(255)</td>
|
|
|
|
<td></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>password</td>
|
|
|
|
<td>varchar(255)</td>
|
|
|
|
<td></td>
|
|
|
|
</tr>
|
|
|
|
</tbody>
|
|
|
|
</table>
|
2022-08-24 08:39:08 +00:00
|
|
|
<table>
|
|
|
|
<thead>
|
|
|
|
<tr>
|
|
|
|
<th colspan=3>downtime</th>
|
|
|
|
</tr>
|
|
|
|
</thead>
|
|
|
|
<tbody>
|
|
|
|
<tr>
|
|
|
|
<td>Name</td>
|
|
|
|
<td>Type</td>
|
|
|
|
<td>Extra</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>id</td>
|
|
|
|
<td>int</td>
|
|
|
|
<td>AUTO_INCREMENT PRIMARY KEY</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>ip</td>
|
|
|
|
<td>varchar(255)</td>
|
|
|
|
<td></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>time</td>
|
|
|
|
<td>datetime</td>
|
|
|
|
<td></td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>status</td>
|
|
|
|
<td>varchar(255)</td>
|
|
|
|
<td></td>
|
|
|
|
</tr>
|
|
|
|
</tbody>
|
|
|
|
</table>
|
2022-08-22 09:02:17 +00:00
|
|
|
|
|
|
|
4. Register new account in app
|
|
|
|
5. Login
|
|
|
|
6. Enjoy!
|
|
|
|
|