new11120
( new)
August 23, 2017, 8:22am
1
I saw the two guides
speedtest-cli
This is great, thanks!
I might extend it to restart my router if there is no external/internet connection
openhab-mysql
The following tutorial is an example how I got MySQL persistence working in my environment.
Install “MySQL Persistence” via PaperUI
Install and configure MySQL:
sudo apt-get install mysql-server
Here, it will ask for a root password, saying that “While it is not necessary, it is suggested.” Of which it is always a good idea to include a root password. Make sure, of course, to remember this password as well.
Start the MySQL commandline as root
sudo mysql -u root -p
Create a database …
And I wanted to combine the two
i’m able to check the speed with speedtest-cli , but I also want to add below previous tests
I realized that in order to save information I needed to use a database
And thought to use mysql
I read the second directory of mysql openhab-mysql
And I could not figure out how to do it in the SpeedTest software
Can anyone explain to me?
Or to use another database
Thank you
rlkoshak
(Rich Koshak)
August 24, 2017, 12:54am
2
Please explain in more detail what you hope to accomplish and exactly where in the second link you provided you ran into trouble.
that second link is pretty thorough.
new11120
( new)
August 24, 2017, 7:00am
3
I want to create a speed test, which will check every hour
And the received data will be saved in mysql
the Speed test that runs every hour is working
The question is how to save the data in mysql
Thank you
rlkoshak
(Rich Koshak)
August 24, 2017, 12:25pm
4
Follow the tutorial on the second link you provided to set up persistence on the speed test items.
new11120
( new)
August 24, 2017, 7:17pm
5
I tried
I did everything look like the guide
And it’s not working
The DB still empty
rlkoshak
(Rich Koshak)
August 24, 2017, 7:44pm
6
I can’t really help with so little information. I don’t use MySQL so can’t guess and you are giving me no details except “it doesn’t work”.
Logs?
.persist file?
Errors that occurred during following that tutorial?
Item definitions?
How did you confirm that you performed each of the steps in the tutorial correctly?
There are a million things that could be wrong.