Hey Guys
Just wondering if anyone has had issues with getting mysql working on consolewd
i get the following error:
Cronmysql vers 1.5
Access violation
Verify infos are entered correctly in config.txt
I believe i have all the details correct
Mysql username=myuser
Mysql password=mypass
Mysql server=localhost (have also tried with 127.0.0.1 and my ip
Mysql databasename=mydb
Mysql tablename=wx_data
Mysql metric=Y (set N for oF, inches of rain, inches for baro)
Mysql time=300 (time interval between mysql update in seconds from 60 to 10000 sec)
I can login as the user in the config file and show the db columns. Any ideas?
show columns from wx_data;
±----------------------------±--------------±-----±----±-----------±------+
| Field | Type | Null | Key | Default | Extra |
±----------------------------±--------------±-----±----±-----------±------+
| time | time | NO | PRI | 00:00:00 | |
| date | date | NO | PRI | 0000-00-00 | |
| mintemp | float | NO | | 0 | |
| maxtemp | float | NO | | 0 | |
| temperature | float | NO | | 0 | |
| average_windspeed | float | NO | | 0 | |
| wind_direction | float | NO | | 0 | |
| gust_windspeed | float | NO | | 0 | |
| UV | float | NO | | 0 | |
| barometer | float | NO | | 0 | |
| daily_rainfall | float | NO | | 0 | |
| monthly_rainfall | float | NO | | 0 | |
| yearly_rainfall | float | NO | | 0 | |
| hourly_rainfall | float | NO | | 0 | |
| rain_rate | float | NO | | 0 | |
| max_rain_rate_curent_day | float | NO | | 0 | |
| monthtodatemaxtemp | float | NO | | 0 | |
| monthtodatemintemp | float | NO | | 0 | |
| day_hours | varbinary(20) | NO | | 0 | |
| forecast_icon | float | NO | | 0 | |
| yesterday_rainfall | float | NO | | 0 | |
| extra_temperature_sensor_1 | float | NO | | 0 | |
| extra_temperature_sensor_2 | float | NO | | 0 | |
| extra_temperature_sensor_3 | float | NO | | 0 | |
| extra_temperature_sensor_4 | float | NO | | 0 | |
| extra_temperature_sensor_5 | float | NO | | 0 | |
| extra_temperature_sensor_6 | float | NO | | 0 | |
| extra_temperature_sensor_7 | float | NO | | 0 | |
| extra_temperature_sensor_8 | float | NO | | 0 | |
| extra_temperature_sensor_9 | float | NO | | 0 | |
| extra_temperature_sensor_10 | float | NO | | 0 | |
| extra_humidity_1 | float | NO | | 0 | |
| extra_humidity_2 | float | NO | | 0 | |
| extra_humidity_3 | float | NO | | 0 | |
| extra_humidity_4 | float | NO | | 0 | |
| actual_solar_reading | float | NO | | 0 | |
| current_windchill | float | NO | | 0 | |
| current_humidex | float | NO | | 0 | |
| current_weather_desc | float | NO | | 0 | |
| barometer_trend_last_hour | varchar(20) | NO | | 0 | |
| todaywindrun | float | NO | | 0 | |
| max_gust_current_day | float | NO | | 0 | |
| dew_point_temperature | varchar(20) | NO | | 0 | |
| cloud_height | float | NO | | 0 | |
| current_heatindex | float | NO | | 0 | |
| soil_moist | float | NO | | 0 | |
| leaf_moist | float | NO | | 0 | |
| lightning_last_hour | float | NO | | 0 | |
| temp_change_last_hour | varchar(20) | NO | | 0 | |
±----------------------------±--------------±-----±----±-----------±------+
49 rows in set (0.03 sec)