Simon, Here's the insert statement:
INSERT INTO mystation (ID, DateTime, TempOutCur, HumOutCur, PressCur, DewCur, HeatIdxCur, WindChillCur, TempInCur, HumInCur, WindSpeedCur, WindAvgSpeedCur, WindDirCur, WindDirCurEng, WindGust10, WindDirAvg10, WindDirAvg10Eng, RainRateCur, RainDay, RainYest ...
Search found 13 matches
- Thu Feb 07, 2019 1:22 am
- Forum: Meteobridge Discussion
- Topic: Meteobridge MySQL service returns socket error **solved**
- Replies: 15
- Views: 6546
- Thu Feb 07, 2019 12:09 am
- Forum: Meteobridge Discussion
- Topic: Meteobridge MySQL service returns socket error **solved**
- Replies: 15
- Views: 6546
Re: Meteobridge MySQL service returns socket error
Finally got the connection solved but not getting any data.
https://www.dropbox.com/s/6aqp5a6ct1tqo ... 9.png?dl=0
https://www.dropbox.com/s/kt1ahoqvh0jm6 ... 4.png?dl=0
https://www.dropbox.com/s/6aqp5a6ct1tqo ... 9.png?dl=0
https://www.dropbox.com/s/kt1ahoqvh0jm6 ... 4.png?dl=0
- Wed Feb 06, 2019 10:35 pm
- Forum: Meteobridge Discussion
- Topic: Meteobridge MySQL service returns socket error **solved**
- Replies: 15
- Views: 6546
Re: Meteobridge MySQL service returns socket error
check for [mysqld] area: not the [client] area find and make sure
/socket = /tmp/mysql.sock
Simon, I've checked everything and the only difference I can see is:
[mysqld]
socket = /tmp/mysqld.sock
Also, when I create a user in the terminal, it is always created as @localhost even is I specify ...
/socket = /tmp/mysql.sock
Simon, I've checked everything and the only difference I can see is:
[mysqld]
socket = /tmp/mysqld.sock
Also, when I create a user in the terminal, it is always created as @localhost even is I specify ...
- Wed Feb 06, 2019 8:48 pm
- Forum: Meteobridge Discussion
- Topic: Meteobridge MySQL service returns socket error **solved**
- Replies: 15
- Views: 6546
Re: Meteobridge MySQL service returns socket error
Simon, I can connect and make changes to the MySQL database thru both the terminal and a GUI client and I've disabled the binding in my.sql. Here are the connection parameters from the GUI client:
Address: localhost:3306
Database: meteobridge
URL: jdbc:mysql://localhost:3306/meteobridge
Server ...
Address: localhost:3306
Database: meteobridge
URL: jdbc:mysql://localhost:3306/meteobridge
Server ...
- Wed Feb 06, 2019 5:58 pm
- Forum: Meteobridge Discussion
- Topic: Meteobridge MySQL service returns socket error **solved**
- Replies: 15
- Views: 6546
Re: Meteobridge MySQL service returns socket error
Same error after editing my.sql and and restarting mysql.
- Wed Feb 06, 2019 5:26 pm
- Forum: Meteobridge Discussion
- Topic: Meteobridge MySQL service returns socket error **solved**
- Replies: 15
- Views: 6546
Re: Meteobridge MySQL service returns socket error
So, I should stop the service, move the .sock file to the /tmp folder, and edit mysql.cnf and my.cnf?
- Wed Feb 06, 2019 5:19 pm
- Forum: Meteobridge Discussion
- Topic: Meteobridge MySQL service returns socket error **solved**
- Replies: 15
- Views: 6546
Re: Meteobridge MySQL service returns socket error
I'm running on a Linux machine and installed MySQL myself thru the terminal command 'sudo apt install mysql'. On Linux, MySQL installs the .sock in the /var/run/mysqld folder. It will not allow copying or moving the file.
- Tue Feb 05, 2019 3:03 am
- Forum: Meteobridge Discussion
- Topic: Meteobridge MySQL service returns socket error **solved**
- Replies: 15
- Views: 6546
Meteobridge MySQL service returns socket error **solved**
I've been trying to get a MySQL service running on my Linux machine. Both the database and connection to Meteobridge are on the same machine. I'm getting the following error: Failed to connect to MYSQL database: Can't connect to local MySQL server through socket '/tmp' (146) . I've double-checked ...
- Thu Jan 31, 2019 10:41 pm
- Forum: Meteobridge Discussion
- Topic: Meteobridge not showing data from Vantage Vue **solved**
- Replies: 5
- Views: 2297
Re: Meteobridge not showing data from Vantage Vue [Solved]
New ISS delivered and installed. Receiving ISS data.
- Thu Jan 31, 2019 3:07 pm
- Forum: Meteobridge Discussion
- Topic: Meteobridge not showing data from Vantage Vue **solved**
- Replies: 5
- Views: 2297
Re: Meteobridge not showing data from Vantage Vue
No data at all. The ISS is 6 years old so decided to install a new one rather than shipping it back for a repair. Got a new one for $171 from Hodges Marine with free shipping, rather than paying $112 for repair when something else might go wrong down the road. Ordered it yesterday and it will be ...
- Tue Jan 29, 2019 1:33 pm
- Forum: Meteobridge Discussion
- Topic: Meteobridge not showing data from Vantage Vue **solved**
- Replies: 5
- Views: 2297
Re: Meteobridge not showing data from Vantage Vue
RF Sensitivity is set to -90db.
Distance from Vantage Vue to Meteostick is 100 feet.
Distance from Vantage Vue to Meteostick is 100 feet.
- Mon Jan 28, 2019 11:12 pm
- Forum: Meteobridge Discussion
- Topic: Meteobridge not showing data from Vantage Vue **solved**
- Replies: 5
- Views: 2297
Meteobridge not showing data from Vantage Vue **solved**
I have the following equipment:
Platform: TL-MR3020 (no USB hub)
SW Version: Meteobridge 3.9 (Jan 26 2019, build 12701), FW 1.4
Meteostick
Vantage Vue weather station
Suddenly, I'm only getting internal data, nothing from the Vantage Vue. I've already replaced the battery in the Vantage Vue. Where ...
Platform: TL-MR3020 (no USB hub)
SW Version: Meteobridge 3.9 (Jan 26 2019, build 12701), FW 1.4
Meteostick
Vantage Vue weather station
Suddenly, I'm only getting internal data, nothing from the Vantage Vue. I've already replaced the battery in the Vantage Vue. Where ...
- Thu Jul 16, 2015 1:19 am
- Forum: Discussion
- Topic: How do I reset MeteoStick?
- Replies: 1
- Views: 15906
How do I reset MeteoStick?
I'm having a problem because I can't remember the password to access the setup software. The unit isn't sending data so I need to check the setup.