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:

[Code]...

View 4 Replies


ADVERTISEMENT

Ubuntu Networking :: Cannot Connect To MySQL (3306 Port)?

Jan 14, 2010

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?

View 9 Replies View Related

CentOS 5 Server :: Changing Default Mysql Port As 80 From 3306

Feb 2, 2009

I want to change my MySQL default port(3306) as 80 how can i do this on centOS 5.2? I tired to add

[client]
port=80

to /etc/my.cnf and different command in this file. But mysql didn't start. How can do this? I'll use server only as mysql and ftp server.

View 13 Replies View Related

Ubuntu Networking :: Unable To Open Port 3306 For MySql

Jul 18, 2010

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.

[Code].....

View 2 Replies View Related

Red Hat / Fedora :: Enabling Mysql In Server (port 3306) It Doesn't Work?

Apr 12, 2011

when i am enabling mysql in server (port 3306) it does'nt work. but when i execute iptables -F it works what may be the reson?

View 6 Replies View Related

Server :: Mysql In Redhat Two Machine Cluster Not Opening 3306 Port?

Jul 18, 2011

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

View 1 Replies View Related

Networking :: How To Redirect Locally-generated Packets To Remote Server?

Mar 22, 2010

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.

View 14 Replies View Related

Debian Configuration :: Mysql Port 3306 Not Visible?

Sep 3, 2010

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.

View 2 Replies View Related

General :: Connecting To Mysql Database Remotely Via Port 3306 ?

Jul 23, 2011

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:

Code:

View 3 Replies View Related

Server :: Redirect Local DNS Query To Remote DNS Server On Non Standard Port?

Feb 19, 2010

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.

View 8 Replies View Related

Programming :: Redirect Output To Remote Server Via Ssh?

May 18, 2009

I need to output of the script to the remote server via redirect. I created a simple script for your reference.Quote:

#!/bin/bash
W=`/usr/bin/w`
FREE=`/usr/bin/free`

[code]...

View 4 Replies View Related

Debian :: Redirect Apache To Remote Machine Www Content On IIS Server?

Mar 25, 2011

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.

View 14 Replies View Related

Ubuntu Networking :: Redirect Port 25 To A Remote Machine Via A VPN Connection

Feb 19, 2011

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.

View 3 Replies View Related

Ubuntu Networking :: Redirect All Http/https/ftp Traffic Through The Remote Proxy?

Apr 6, 2011

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.

View 3 Replies View Related

Ubuntu Servers :: Make It A .com - Redirect DNS To Server IP?

Oct 26, 2010

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?

View 6 Replies View Related

Networking :: Redirect Local Http Port To Remote Machine?

May 26, 2010

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

View 1 Replies View Related

Server :: Remote MySQL Server Connection Dies After Wget Large File

Feb 3, 2011

We have 2 servers, 1 is the webserver and the other is the Mysql server.

When transfering a 2GB file from the webserver to the Mysql server.

The webserver's connection to the mysql DB server dies completely.

Need to restart the MYSQL process in order for it to come back online.

During this connection downtime, when using phpmyadmin on the mysql server shows no problem running queries etc.

View 2 Replies View Related

General :: Access Remote Mysql Server Through Socks Proxy Server?

Aug 25, 2010

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).

View 1 Replies View Related

Server :: How To Connect Qmail / Vpopmail To Remote Mysql Server?

May 14, 2010

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.

View 3 Replies View Related

CentOS 5 Server :: MySQL Server Setup For Remote Access

May 4, 2009

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.

View 5 Replies View Related

Server :: Mysql Command To Allow A Remote Connection?

Jun 8, 2010

what is the correct command on a mysql command line to alllow mysql to alllow remote connection on a server

View 1 Replies View Related

Server :: Mysql Remote Access Failed?

Dec 28, 2010

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:

Code:
[client]
port= 3306

[code]....

View 14 Replies View Related

Server :: MySQL - Remote Access For Root?

Aug 9, 2010

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?

View 3 Replies View Related

General :: Allow Remote Access To MySQL Server On Centos5?

Jan 7, 2009

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

[code]....

View 5 Replies View Related

General :: Connecting To Remote Server Using Mysql Command

Jun 7, 2010

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.

View 5 Replies View Related

Server :: MySQL Odbc Connection Remote Client?

Jul 27, 2010

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

View 4 Replies View Related

OpenSUSE :: Enable Remote Access To MySQL Database Server?

Jan 29, 2011

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

View 1 Replies View Related

Ubuntu Servers :: Mysql ERROR 1045 \ Trying To Allow Remote Access To Mysql?

Jan 14, 2011

i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :

Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing

[code]....

View 4 Replies View Related

OpenSUSE Network :: Configure Firewall To Allow Remote Access To The Mysql Server?

May 31, 2011

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?

View 4 Replies View Related

OpenSUSE Network :: Configure Firewall To Allow Remote Access To The Mysql Server

Jan 28, 2011

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?

View 11 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved