LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 08-23-2009, 01:43 PM   #1
archey
LQ Newbie
 
Registered: Jun 2009
Posts: 27

Rep: Reputation: 15
Opening port 3306


Hello, It's me again .

So I'm got an error from HLStatsX:CE

Code:
DBI connect('archeyre_stats:3306','X',...) failed: Can't connect to MySQL server on '3306' (22) at /home/X/perl/HLstats.plib line 107

Can't connect to MySQL database 'X' on '3306'
Server error: Can't connect to MySQL server on '3306' (22)
Now I assume I need to open port 3306, how can I do so?

Last edited by archey; 08-23-2009 at 04:37 PM.
 
Old 08-23-2009, 02:38 PM   #2
MS3FGX
LQ Guru
 
Registered: Jan 2004
Location: NJ, USA
Distribution: Slackware, Debian
Posts: 5,852

Rep: Reputation: 356Reputation: 356Reputation: 356Reputation: 356
Well...are you running an MySQL server in the first place?
 
Old 08-23-2009, 02:45 PM   #3
archey
LQ Newbie
 
Registered: Jun 2009
Posts: 27

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by MS3FGX View Post
Well...are you running an MySQL server in the first place?
uhh, yeah.
 
Old 08-23-2009, 03:02 PM   #4
repo
LQ 5k Club
 
Registered: May 2001
Location: Belgium
Distribution: Arch
Posts: 8,527

Rep: Reputation: 898Reputation: 898Reputation: 898Reputation: 898Reputation: 898Reputation: 898Reputation: 898
And do you have a firewall?
 
Old 08-23-2009, 03:08 PM   #5
archey
LQ Newbie
 
Registered: Jun 2009
Posts: 27

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by repo View Post
And do you have a firewall?

No clue.
 
Old 08-23-2009, 03:09 PM   #6
repo
LQ 5k Club
 
Registered: May 2001
Location: Belgium
Distribution: Arch
Posts: 8,527

Rep: Reputation: 898Reputation: 898Reputation: 898Reputation: 898Reputation: 898Reputation: 898Reputation: 898
login as root and type
Code:
iptables -L
 
Old 08-23-2009, 03:38 PM   #7
archey
LQ Newbie
 
Registered: Jun 2009
Posts: 27

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by repo View Post
login as root and type
Code:
iptables -L
okay, did that, now what?
 
Old 08-23-2009, 03:39 PM   #8
MS3FGX
LQ Guru
 
Registered: Jan 2004
Location: NJ, USA
Distribution: Slackware, Debian
Posts: 5,852

Rep: Reputation: 356Reputation: 356Reputation: 356Reputation: 356
Post the output so we can see what it says...
 
Old 08-23-2009, 04:08 PM   #9
archey
LQ Newbie
 
Registered: Jun 2009
Posts: 27

Original Poster
Rep: Reputation: 15
okay, here it is:

Code:
Chain INPUT (policy ACCEPT)
target     prot opt source               destination
acctboth   all  --  anywhere             anywhere

Chain FORWARD (policy ACCEPT)
target     prot opt source               destination

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination
acctboth   all  --  anywhere             anywhere

Chain acctboth (2 references)
target     prot opt source               destination
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:http
           tcp  --  anywhere             server.archeyreece.com tcp spt:http
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:smtp
           tcp  --  anywhere             server.archeyreece.com tcp spt:smtp
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:pop3
           tcp  --  anywhere             server.archeyreece.com tcp spt:pop3
           icmp --  server.archeyreece.com  anywhere
           icmp --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere
           tcp  --  anywhere             server.archeyreece.com
           udp  --  server.archeyreece.com  anywhere
           udp  --  anywhere             server.archeyreece.com
           all  --  server.archeyreece.com  anywhere
           all  --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:http
           tcp  --  anywhere             server.archeyreece.com tcp spt:http
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:smtp
           tcp  --  anywhere             server.archeyreece.com tcp spt:smtp
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:pop3
           tcp  --  anywhere             server.archeyreece.com tcp spt:pop3
           icmp --  server.archeyreece.com  anywhere
           icmp --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere
           tcp  --  anywhere             server.archeyreece.com
           udp  --  server.archeyreece.com  anywhere
           udp  --  anywhere             server.archeyreece.com
           all  --  server.archeyreece.com  anywhere
           all  --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:http
           tcp  --  anywhere             server.archeyreece.com tcp spt:http
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:smtp
           tcp  --  anywhere             server.archeyreece.com tcp spt:smtp
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:pop3
           tcp  --  anywhere             server.archeyreece.com tcp spt:pop3
           icmp --  server.archeyreece.com  anywhere
           icmp --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere
           tcp  --  anywhere             server.archeyreece.com
           udp  --  server.archeyreece.com  anywhere
           udp  --  anywhere             server.archeyreece.com
           all  --  server.archeyreece.com  anywhere
           all  --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:http
           tcp  --  anywhere             server.archeyreece.com tcp spt:http
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:smtp
           tcp  --  anywhere             server.archeyreece.com tcp spt:smtp
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:pop3
           tcp  --  anywhere             server.archeyreece.com tcp spt:pop3
           icmp --  server.archeyreece.com  anywhere
           icmp --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere
           tcp  --  anywhere             server.archeyreece.com
           udp  --  server.archeyreece.com  anywhere
           udp  --  anywhere             server.archeyreece.com
           all  --  server.archeyreece.com  anywhere
           all  --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:http
           tcp  --  anywhere             server.archeyreece.com tcp spt:http
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:smtp
           tcp  --  anywhere             server.archeyreece.com tcp spt:smtp
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:pop3
           tcp  --  anywhere             server.archeyreece.com tcp spt:pop3
           icmp --  server.archeyreece.com  anywhere
           icmp --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere
           tcp  --  anywhere             server.archeyreece.com
           udp  --  server.archeyreece.com  anywhere
           udp  --  anywhere             server.archeyreece.com
           all  --  server.archeyreece.com  anywhere
           all  --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:http
           tcp  --  anywhere             server.archeyreece.com tcp spt:http
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:smtp
           tcp  --  anywhere             server.archeyreece.com tcp spt:smtp
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:pop3
           tcp  --  anywhere             server.archeyreece.com tcp spt:pop3
           icmp --  server.archeyreece.com  anywhere
           icmp --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere
           tcp  --  anywhere             server.archeyreece.com
           udp  --  server.archeyreece.com  anywhere
           udp  --  anywhere             server.archeyreece.com
           all  --  server.archeyreece.com  anywhere
           all  --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:http
           tcp  --  anywhere             server.archeyreece.com tcp spt:http
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:smtp
           tcp  --  anywhere             server.archeyreece.com tcp spt:smtp
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:pop3
           tcp  --  anywhere             server.archeyreece.com tcp spt:pop3
           icmp --  server.archeyreece.com  anywhere
           icmp --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere
           tcp  --  anywhere             server.archeyreece.com
           udp  --  server.archeyreece.com  anywhere
           udp  --  anywhere             server.archeyreece.com
           all  --  server.archeyreece.com  anywhere
           all  --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:http
           tcp  --  anywhere             server.archeyreece.com tcp spt:http
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:smtp
           tcp  --  anywhere             server.archeyreece.com tcp spt:smtp
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:pop3
           tcp  --  anywhere             server.archeyreece.com tcp spt:pop3
           icmp --  server.archeyreece.com  anywhere
           icmp --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere
           tcp  --  anywhere             server.archeyreece.com
           udp  --  server.archeyreece.com  anywhere
           udp  --  anywhere             server.archeyreece.com
           all  --  server.archeyreece.com  anywhere
           all  --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:http
           tcp  --  anywhere             server.archeyreece.com tcp spt:http
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:smtp
           tcp  --  anywhere             server.archeyreece.com tcp spt:smtp
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:pop3
           tcp  --  anywhere             server.archeyreece.com tcp spt:pop3
           icmp --  server.archeyreece.com  anywhere
           icmp --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere
           tcp  --  anywhere             server.archeyreece.com
           udp  --  server.archeyreece.com  anywhere
           udp  --  anywhere             server.archeyreece.com
           all  --  server.archeyreece.com  anywhere
           all  --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:http
           tcp  --  anywhere             server.archeyreece.com tcp spt:http
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:smtp
           tcp  --  anywhere             server.archeyreece.com tcp spt:smtp
           tcp  --  server.archeyreece.com  anywhere            tcp dpt:pop3
           tcp  --  anywhere             server.archeyreece.com tcp spt:pop3
           icmp --  server.archeyreece.com  anywhere
           icmp --  anywhere             server.archeyreece.com
           tcp  --  server.archeyreece.com  anywhere
           tcp  --  anywhere             server.archeyreece.com
           udp  --  server.archeyreece.com  anywhere
           udp  --  anywhere             server.archeyreece.com
           all  --  server.archeyreece.com  anywhere
           all  --  anywhere             server.archeyreece.com
           all  --  anywhere             anywhere
 
Old 08-24-2009, 01:26 AM   #10
archey
LQ Newbie
 
Registered: Jun 2009
Posts: 27

Original Poster
Rep: Reputation: 15
friendly bump
 
Old 08-24-2009, 01:38 AM   #11
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,520

Rep: Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502
Does
Code:
netstat -tanpl|grep 3306
produce any output?
If not, you have to comment out "skip-networking" from my.cnf, or remove that option from the mysqld startup script
 
Old 08-24-2009, 01:43 AM   #12
repo
LQ 5k Club
 
Registered: May 2001
Location: Belgium
Distribution: Arch
Posts: 8,527

Rep: Reputation: 898Reputation: 898Reputation: 898Reputation: 898Reputation: 898Reputation: 898Reputation: 898
Open the port on your firewall.
Since you use cpanel, take a look for the firewall settings, or contact support.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
mysqld running and reading for connections on port 3306, no port 3306 found from scan darkenigmaa Linux - Networking 10 07-13-2016 12:53 PM
MySQL not listening on port 3306 mr_sarge Linux - Newbie 14 12-03-2013 05:17 AM
Mysql - port 3306 - turn it off rjcrews Linux - Security 5 01-11-2007 01:18 PM
opening a port satish Linux - Security 2 11-23-2006 03:14 PM
mysql port 3306 bulliver Linux - Security 4 04-17-2003 09:00 PM


All times are GMT -5. The time now is 12:57 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration