Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Jesper Raben on September 21, 2002, 03:11:14 PM

Title: Mysql Connection Problems..
Post by: Jesper Raben on September 21, 2002, 03:11:14 PM

Hallo

I can't connect to my MySql server from the outside world, but i can connect on my local network !.

I have createt a user and a database and I wish to connect to this from the internet !.

I am sitting behind a router and i have opned port 3306 in the router, but i can't connect to the server ?

I am using SME Server 5.5

What am i doing wrong ???

/Jesper

Title: Re: Mysql Connection Problems..
Post by: chris meredith on September 21, 2002, 09:05:31 PM

Are you running in Secure Gateway mode?  I would bet the port is blocked by default from the outside world. You could manually add an ipchains/iptables rule depending on teh version you are running rule.  You could also use the port opening contrib and just do it that way.  

I don't know if you really want to just open up that port to the world like that though.  You could create a rule to only allow a connection to that port from the ip of the box(s) you plan on using as a sql client.  You might want to at least restrict the sql user account to connecting from a certain ip or ips.

Title: Re: Mysql Connection Problems..
Post by: bud on November 25, 2002, 07:34:25 PM

So all we have to do is open port 3306?  Nothing else?

Title: Re: Mysql Connection Problems..
Post by: Benson on November 25, 2002, 10:45:05 PM

Look at this !

http://forums.contribs.org/index.php?topic=15630.msg60186#msg60186

It helped me !

Hilsen Benson