Post by justin on Aug 19, 2018 7:10:14 GMT -8
When my GroveWeatherPi boots up initially I'm getting "Use mysql: not present". And I'm not sure how to make it show "present"?
To give some background I installed mysql (I actually installed mariadb- which from what I read is the newer version that is supposed to be a drop-in replacement for mysql) as well as phpmyadmin. When i tried to run the command from your github readme file ( sudo mysql -u root -p GroveWeatherPi< GroveWeatherPi.sql ) it returned "bash: GroveWeatherPi.sql: No such file or directory".
So I instead imported the .sql file using phpmyadmin. When i log onto phpmyadmin it shows GroveWeatherPi. When i click on it it shows Powersystem, systemlog, and weatherdata. When i click on weatherdata it shows the the data table header (ID, Timestamp, as3935LightingCount, etc....) but there is no data being populated under the headers while I have the GroveWeatherPi running in the background. So i know I have the .sql file successfully imported into phpmyadmin but it is not showing any of the sensors data. It also still shows Use mysql: not present at boot-up.
So my question is what am i missing? How do I get the GroveWeatherPi to show Use mysql: present?
To give some background I installed mysql (I actually installed mariadb- which from what I read is the newer version that is supposed to be a drop-in replacement for mysql) as well as phpmyadmin. When i tried to run the command from your github readme file ( sudo mysql -u root -p GroveWeatherPi< GroveWeatherPi.sql ) it returned "bash: GroveWeatherPi.sql: No such file or directory".
So I instead imported the .sql file using phpmyadmin. When i log onto phpmyadmin it shows GroveWeatherPi. When i click on it it shows Powersystem, systemlog, and weatherdata. When i click on weatherdata it shows the the data table header (ID, Timestamp, as3935LightingCount, etc....) but there is no data being populated under the headers while I have the GroveWeatherPi running in the background. So i know I have the .sql file successfully imported into phpmyadmin but it is not showing any of the sensors data. It also still shows Use mysql: not present at boot-up.
So my question is what am i missing? How do I get the GroveWeatherPi to show Use mysql: present?
