Ubuntu Networking :: Make 127.0.0.1:3306 Redirect To A Remote Mysql Server?
Mar 22, 2010
I'd love a hint or two on the following problem. I've set up iptables rules to forward all connections to port 3306 to a non-standard mysql port on a remote server. This works, except that I need to deal with the loopback interface in a special way and I'm stuck.
Code:
iptables -t nat -A PREROUTING -p tcp --dport 3306 -j DNAT --to 128.XXX.XXX.XXX:3197
iptables -A FORWARD -p tcp -d 128.XXX.XXX.XXX --dport 3197 -j ACCEPT
iptables -t nat -A POSTROUTING -j MASQUERADE
Since locally-generated packets will never hit the PREROUTING rule, you'll need to setup a near identical rule using OUTPUT to make it work. Here is what I've tried:
How do I get mysql 3306 port to be seen on my network?
Here is my setup: ---Desttop - WIndows Vista Ultimate (192.168.0.101) --------VBox ------------Guest - Ubuntu 9.10 (Joomla CMS Development) (192.168.56.106) ---Server - Ubuntu 9.10 (192.168.0.100) --------VBox ------------Guest - Ubuntu 9.10 (Joomla Production) (192.168.56.104) ------------Guest - Ubuntu 9.10 (MySql Database) (192.168.56.105)
I can ping all OS from any OS, I can connect to a shares, I can connect to the web server. I can do a netscan and display the open ports and the services for those ports except for MySql. How do get MySql to showup, so I can connect to it from my Joomla CMS? I came from openSuse and I like how they have modules to do this automatically. What do I use with Ubuntu to get the same results?
I've been working and researching this for about a week now and I still haven't had any luck. Basically, I have been trying to open port 3306 to allow connections to my MySql server.
i've added the rule into iptables, saved and restarted that i've added the rule into my router. and I have removed "skip-networking" from the my.cnf file and added the blind address in, I'm trying to get this all to work on my LAN, but it doesn't seem to work, I've also restarted the entire server and then port scanned it from outside and inside the networking and it still tells me that 3306 is closed.
I did however i had some luck when I entered the Ip of the machine that would be sending data to the server but then PROFTPD stopped working and the port was open :/ im not really sure what ip should be in there but another thread from another forum said to enter the ip of the machine that mysql is installed on. so currently its 192.168.0.2 which is the static internal address of the server.
every machine on the network has a static ip and all the rules have been added to each firewall, i.e. server and router firewalls.
ill pop my "my.cnf" under this to see if anyone can find a mistake,
Code: # This will be passed to all mysql clients # It has been reported that passwords should be enclosed with ticks/quotes # escpecially if they contain "#" chars... # Remember to edit /etc/mysql/debian.cnf when changing the socket location.
Im having a frustrating issue with my two machine cluster I setup using Conga. Everything was working great except now when lucci starts mysql the port (3306) is never opened to outside machines. I can do a "ps -ef | grep mysql" and see it running as well as login to mysql on the node it is running on - but an nmap of the machine does not show the 3306 port and I cannot login to mysql remotely and yes I turned off all iptables(iptables,ip6tables) and SElinux is disabled.What am I missing here? If I start mysql on my own (and it is using the same my.cnf as lucci is) it does show the port open and works perfect,t for some reason when lucci starts it, no dice
I'm trying to workaround a limitation in a server application. The limitation is that I can only connect to a LOCAL mysql database. I am trying to fool the server in to using a remote mysql database. I was hoping to do this by simply forwarding 3306 to another server on the same subnet.To that end I've set up iptables rules to forward all connections to port 3306 to a non-standard mysql port on a remote server. This works, except that I need to deal with the loopback interface in a special way and I'm stuck.
Everything default.Everything works nicely with one exception. I can't connect to MySQL from the network.nmapping localhost tells me 3306 is open but nmap from the outside shows only ports 22 and 111 open. To my knowledge I have no firewall, iptables -L gives an empty set.I have several similar installations on the same network without any problems of this nature.
I'm new to linux, and setting up the mysql database server.
Here are my situation:
OS: CentOS 6 mysql version: 5.5
I tried to use MySQL Administrator to connect to my database on the host 192.168.1.120 and my computer is under the same network with ip: 192.168.1.105
But it shows the error msg: Could not connect to MySQL instance at 192.168.1.120
Error: Can't connect to MySQL server on '192.168.1.120'(61)(code 2003)
On the server side I've tried:
Code:
skip_networking is off and I've set the port for it.
When I check the process in OS:
Code:
When I try netstat:
Code:
I thought it's the problem of firewall, so I have check it also:
The issue is that my CentOS workstation is in a vlan from where the Intranet's DNS servers are unreachable. For browsing the web there is an ISA proxy server, which I presume resolves DNS for my firefox. However, wget, host, ping and aria2c fail to get any sort of DNS resolution since they're being run from command line.I have exported HTTP_PROXY value, which provides me internet access on console, but,only when I connect using IP address. It fails on name resolution.
My question is:May I redirect the DNS queries to my home PC which would be running a DNS server on a non standard port?I was thinking of putting nameserver 127.0.0.1 in /etc/resolv.conf and then put iptables rule to redirect 127.0.0.1:53 UDP to a.public.ip.address:3535 UDP..I don't know if I am shooting blanks or what, I am not very much aware of this kind of setup.My main need is to provide DNS resolution to console apps.I want to utilize my company's idle bandwidth for bulk downloads, so, using proxy, SSH tunneling through my Home PC is out of question.
I am trying to show library content (asp files, IIS server, MySQL database on Windows Server 2003 - Inetpub/wwwroot/library - 192.168.0.3) publicly. But Apache webserver is on Linux machine. In one of previos topics I was adviced to mount this remote machine webfolder into Linux /var/www. Well this way it want work. I was adviced it can be done through redirecting.
I have had a look at the the information on the ubuntu forum about this but am having trouble getting the server to do what i want it to do.
I have a VPS running ubuntu 9.10 and i am trying to set it up to redirect port 25 to a remote machine via a VPN connection (remote machine connected via VPN)
i have tried setting this up in the firewall using webmin but it is not working.
I need to redirect all http/https/ftp traffic through the remote proxy, but when I changes connection settings in browser or in System->Preferences->Network Proxy it doesn't work well: instead of getting page content browser asks for saving some short (8 bytes) file with the same content for all requested pages. It happens in Chrome/Opera/Firefox. This proxy requires authorization and works on computer with Windos XP. It worked well when I was using Windows 7 and Proxifier, now I have Ubuntu 9.10 with all available updates.
I'm hosting my own dedicated server with Ubuntu Server 10.10. I have it set up with a static local IP, and I've configured DynDNS to link up with my router and allow my server to go live to the internet. I have all the appropriate ports unlocked, with the exception of port 80. This port is blocked by my ISP (Charter) and I can't use it. Due to this, I configured my router to listen on port 81, and direct it to my server.
So, In order to view it, you need to go to the IP XXX.xxx.XXX.xxx:81 Today, I registered (www.online-self.com) in hopes of getting around my current mask (provided by DynDNS.com (omegame.selfip.com). So here is my dilemma, When I go to the host of my domain name , I want to redirect my DNS to my server IP.
I can't seem to do it though? They want a strict IP address, no port extensions. How do I get around this so that my domain name and IP address link up? I'm thinking I may be missing a step, or maybe I needed to register a domain name that simply redirects? I'm starting to get confused on what I should do next. Can I even do this?
i have a problem........ How to redirect local http port to remote ip ddress(192.168.10.64) using iptables..my destro is Centos 5.3 my rule is this iptables -t nat -A PREROUTING -s 0/0 -d <my local ip> -p tcp --dport 80 -j DNAT --to-destination 192.168.10.64
Scenario:A - Local Unix machineB - socks proxy server port 1080C - remote mysql server port 3306I want to connect to the remote mysql server(C) from local unix machine(A) using sock proxy(B).
I would like to connect to a separate mysql server, yet I can't find any documentation on how to do this.How would one achieve this? I am running qmail on centos4.
I have just installed CentOS 5. I have set mysql database to access from remote machines. But now the problem is it is not connecting from the local machine now.
I'm using slackware 13.1 and I have a problem to accept remote access to mysql server.The steps I have followed to do that thing are:vi /etc/my.cnfline skip-networking is commented bind-address my_ipaddressI opened the port 3306 of my firewallAlthough I can connect locally, i.e. mysql -u a_user -h localhost -pI can't do it remotely i.e. mysql -u same_user -h my_ipaddress -pI have also turned off my firewall, but nothing.telent 3306 my_ipaddress results in: telnet: connect to address my_ipaddress: Connection refusedMy my.cnf file is:
I have a question in regards to enabling root remote access to the server.I am trying to use the mysql workbenchit kicks back an error saying "Access denied for user 'root'@'10.x.x.x' (using password: YES)" But I am able to login locally on the server.How do I enable root to long on remotely from any workstation?
I have yum installed mysql 5 on Centos5 and I can successfully run queries through shell.However, I want to now allow external access to mysql via some mysql tools (Mysql Administrator/Mysql Query Browser) which is on some windows machines on the same network.Mysql is running on port 3006.When i try connecting through mysql Admin i get the following:Could not connect to the specified instance.MySQL Error Number 2003Can't connect to MySQL server on 'ipaddress' (10065)If you want to check the network connection, please click the Ping button.Googling this I get the impression its something port related, but I have tried what I have found and still no go.When I ping the server I get:
Start Pinging: Reply from ipaddress: Time=0ms TTL=64 Reply from ipaddress: Time=0ms TTL=64
I am fresh out the box to linux I am using mysql for the 1st time also, my question is what is the correct command to run on a mysql command line to connect to remote server.
I wish to connect to MySQL using an ODBC connection and I'm using isql to test. On the server connection using isql to local host is sweet however the problem is the client.Okay my set up looks like thisOn the server /etc/odbc.ini is[MySQL-scopus2008]Description = MySQL citation databaseDriver = MySQLServer = localhostDatabase = scopus2008Por
Enable remote access to MySQL database server I used the link above to enable remote access to mysql for a specific user. But when I try to telnet 3306 or user mysqladmin to connect, both just hang there. Using mysql 5.0 on opensuse 11.1
I have a server machine that is running SUSE Linux Enterprise Server 11. I set up a mysql server there. Now I want to access this mysql server from my laptop. I used the following command,
> mysql -h 12.246.5.70 -u davidehs -p
I found if the firewall on the server machine is running, I can not connect the mysql server from my laptop. If I stop the firewall first, and the do the connection, I can access the mysql. how to keep the firewall running and allow the remote mysql incoming requests?
I have a server machine that is running SUSE Linux Enterprise Server 11. I set up a mysql server there. Now I want to access this mysql server from my laptop. I used the following command,
> mysql -h 12.246.5.70 -u davidehs -p
I found if the firewall on the server machine is running, I can not connect the mysql server from my laptop. If I stop the firewall first, and the do the connection, I can access the mysql. Do you guys have any idea how to keep the firewall running and allow the remote mysql incoming requests?
