Author Topic: Can't connect to local MySQL server (SOLVED)  (Read 3536 times)

0 Members and 1 Guest are viewing this topic.

Offline galfert

  • Global Moderator
  • Forecaster
  • *****
  • Posts: 6822
Re: Can't connect to local MySQL server
« Reply #25 on: February 06, 2019, 08:48:21 AM »
I've reread th OP and see that you have also tested using 192.168.1.4 as the Host address. Another problem could be how you have connected the Linux system on the network. If you have the Meteobridge set to connect to the network via WiFi then you can't connect the Linux system via the Meteobridge's Ethernet port. Even though you may be able to reach the Linux system this way via another computer on the network the Meteobridge can't. The Meteobridge looks for other devices via its default gateway bound interface which is the WiFi. So be sure to not use the Ethernet port if the Meteobridge is connected via WiFi.
Ecowitt GW1000 | Meteobridge on Raspberry Pi
WU: KFLWINTE111  |  PWSweather: KFLWINTE111
CWOP: FW3708  |  AWEKAS: 14814
Windy: pws-f075acbe
Weather Underground Issue Tracking
Tele-Pole

Offline Larry29936

  • Member
  • *
  • Posts: 16
Re: Can't connect to local MySQL server
« Reply #26 on: February 06, 2019, 09:03:27 AM »
galfert, the meteobridge is hardwired into the router with a static address of 192.168.1.79. The machine that the database is on (192.168.1.4) is connected to the network via WiFi (in fact, all of my machines are). Could this be the problem?
« Last Edit: February 06, 2019, 09:14:58 AM by Larry29936 »

Offline ConligWX

  • Forecaster
  • *****
  • Posts: 836
  • #conligwx
    • conligwx.org
Re: Can't connect to local MySQL server
« Reply #27 on: February 06, 2019, 09:27:55 AM »
lol now I'm confused.  #-o

Quote
The database is on the same machine as meteobridge.

then

Quote
meteobridge is hardwired into the router with a static address of 192.168.1.79. The machine that the database is on (192.168.1.4)


anyway I replied here: https://forum.meteohub.de/viewtopic.php?f=56&t=13596#p27852
Regards Simon
Davis Vantage Pro2 Plus (6162UK) • Daytime FARS • WeatherLink Live • AirLink • PurpleAir PA-II-SD • CumulusMX •


Offline freddie

  • Member
  • *
  • Posts: 24
    • Alcaston Weather
Re: Can't connect to local MySQL server
« Reply #28 on: February 06, 2019, 10:12:09 AM »
the meteobridge is hardwired into the router with a static address of 192.168.1.79
So you need the following in your privileges table:

Code: [Select]
GRANT ALL PRIVILEGES ON *.* TO 'larry'@'192.168.1.79'
From what you have described, MySQL is remote from Meteobridge, so you need to allow connections from Meteobridge via MySQL privileges.
Freddie

Offline hymrog

  • Senior Member
  • **
  • Posts: 52
    • Gahanna Weather
Re: Can't connect to local MySQL server
« Reply #29 on: February 06, 2019, 11:54:35 AM »
Hello -

First, try using the ip address of the machine that is running the mySQL server as your Host on meteobridge. and if that does not work change the user from "Larry" to Meteobridge.  Also if I recall my setup (on Linux) you will need to create and grant permission to user Meteobridge on your mySQL db. 

Personally, I would use  phpmyadmin to make changes, etc to your databases instead of the terminal.

g

Offline Larry29936

  • Member
  • *
  • Posts: 16
Re: Can't connect to local MySQL server
« Reply #30 on: February 06, 2019, 01:20:21 PM »
I installed phpmyadmin but I get a 404 Not Found error in my browser

Offline ConligWX

  • Forecaster
  • *****
  • Posts: 836
  • #conligwx
    • conligwx.org
Re: Can't connect to local MySQL server
« Reply #31 on: February 06, 2019, 02:00:55 PM »
myphpadmin requires a web server to run afaik.

Sent from my ONEPLUS A6003 using Tapatalk

Regards Simon
Davis Vantage Pro2 Plus (6162UK) • Daytime FARS • WeatherLink Live • AirLink • PurpleAir PA-II-SD • CumulusMX •


Offline galfert

  • Global Moderator
  • Forecaster
  • *****
  • Posts: 6822
Re: Can't connect to local MySQL server
« Reply #32 on: February 06, 2019, 02:14:32 PM »
Another tip...you should test your SQL server from a different computer on the network. Don't just do it from within the Linux SQL server.

If it works from within the Linux SQL server that is great. That means services are running and SQL is up. But if the Meteobridge can't connect then you have either network problems, firewall or port problems, or credentials / permissions problems. That is why you should be testing from another computer client that can give you more information than what the Meteobridge error messages give you.
« Last Edit: February 06, 2019, 02:18:19 PM by galfert »
Ecowitt GW1000 | Meteobridge on Raspberry Pi
WU: KFLWINTE111  |  PWSweather: KFLWINTE111
CWOP: FW3708  |  AWEKAS: 14814
Windy: pws-f075acbe
Weather Underground Issue Tracking
Tele-Pole

 

anything