Search found 3 matches

by pjsamson
Wed Jun 22, 2022 3:04 am
Forum: Meteobridge Discussion
Topic: MySQL Can't connect to local MySQL server through socket '/tmp' **solved**
Replies: 1
Views: 729

MySQL Can't connect to local MySQL server through socket '/tmp' **solved**

I'm running a local MySQL 8 on my iMac and can access it via command line but not from within meteobridge. Anyone had this issue and found how to get it to work?
Screen Shot 2022-06-21 at 8.50.38 PM.png
Screen Shot 2022-06-21 at 8.50.38 PM.png (78.56 KiB) Viewed 729 times
by pjsamson
Sat Nov 16, 2013 6:30 pm
Forum: Meteobridge Discussion
Topic: Help with MySQL
Replies: 1
Views: 1908

Re: Help with MySQL

Never mind, I found a solution for inserting datetime (use now(), ...duh). For others setting up a MySQL push with MeteoBridge here's the working query I've created:

insert into data (datetime, temp, hum,dew,heat_index, in_temp,in_hum,in_dew,press,sea_press,wind,avgwind,winddir,windchill,rainrate ...
by pjsamson
Sat Nov 16, 2013 5:32 pm
Forum: Meteobridge Discussion
Topic: Help with MySQL
Replies: 1
Views: 1908

Help with MySQL

I am new to this system and am trying to set up MySQL. Doe anyone have an example MySQL query that illustrates how to store a timestamp as well as the data? I am trying

"insert into data (datetime,temp) values ([YYYY]-[MM]-[DD] [hh]:[mm]:[ss],[th0temp-act.1:-9999])"

but this doesn't work and ...