You are here

Connecting to MySQL DB on the mesh from outside the mesh

5 posts / 0 new
Last post
k0jpr
k0jpr's picture
Connecting to MySQL DB on the mesh from outside the mesh
I have a Pi running MeshMap within the Mesh.
I also have MeshMap installed on my 192.168.1.x outside the Mesh. I am trying to connect from this copy of MeshMap to the MySQL database running on the Pi.
I have a Netgear GS105Ev2 between the 192.168.1.x network and the 10.64.x.x network. The switch is using VLAN. I have a tunnel server on one of my local nodes and it is functioning A-OK.
How do I get the port 3306 routed between 192.168.1.x and 10.64.x.x ????
Thanks,
Tom

Photos of the Netgear setup can be found at: https://groups.io/g/KCmesh/album?id=242110
You will have to join our group to see the photos
Subscribe: KCmesh+subscribe@groups.io
AE6XE
AE6XE's picture
Tom, 
Tom, 

if the MySQL db is on a LAN device on the mesh node with the 192.168.x.x WAN connection, then the UI settings will work.   

If the MySQL db is on a mesh node across the mesh network and not directly connected to the gateway node to your home network, then this is a custom firewall rule.   This will require some knowledge of ssh and vi command lines.  On the gateway node, see the comments in "/etc/local/mesh-firewall/59_custom-rules"

Joe AE6XE
k0jpr
k0jpr's picture
Where is "/etc/local/mesh
Where is "/etc/local/mesh-firewall/59_custom-rules"? Is it on the Mesh Gateway node.
If so, what IP would it be?
tom
nc8q
nc8q's picture
My home firewall rule to allow access to meshmap from the WWW
My port forward (NAT) is the same as my tunnel (5525 .vs. 8083) to the same static IP address on the node hosting the meshmap server.
 
Image Attachments: 
nc8q
nc8q's picture
More
Forwarding port 8083 to meshmap:80


  ~!DOCTYPE html` ~html` ~head` ~/head` ~body` ~iframe frameborder="0" height="1080" width="100%" scrolling="no" src="http://69.81.74.7:8083/meshmap"`~/iframe> ~/body` ~/html`
Image Attachments: 

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer