LinuxQuestions.org
Help answer threads with 0 replies.
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 02-14-2006, 12:14 PM   #1
g_srinivas
Member
 
Registered: Jul 2005
Location: USA
Distribution: SuSE 9
Posts: 49

Rep: Reputation: 15
Question does debian have any firewall installed?


Hello,
I am using Debian v3.1 (Sarge), with all stable packages. Recently I installed and configured MySQL5/Apache2/PHP5, and for now everything works fine but with one small problem with MySQL5.

I am having a windows xp professional also on the same network where my debian system also lies. Now, I am able to ping or ssh to linux from my windows xp pc, but I am not able to connect to MySQL using MySQL Administrator from windows. I doubt that maybe there is debian firewall which might be blocking the 3306 port which is used by MySQL.

So, can anyone please tell me how can I check if the problem is because of the port getting blocked or not? and if so then how can I unblock port 3306 in debian?

Thanks in advance.
 
Old 02-14-2006, 12:27 PM   #2
ethics
Senior Member
 
Registered: Apr 2005
Location: London
Distribution: Arch - Latest
Posts: 1,522

Rep: Reputation: 45
man iptables

iptables is a firewall built into the kernel, it may be that there are existing rules in effect preventing it.

that said is it not seeing MYSQL or is it not letting you login?
 
Old 02-14-2006, 12:29 PM   #3
tuxrules
Senior Member
 
Registered: Jun 2004
Location: Chicago
Distribution: Slackware64 -current
Posts: 1,144

Rep: Reputation: 56
I would not think that a out-of-the-box debian would be running a firewall. Check on the debian box for any iptables rules deployed. If you are not able to connect to port 3306, MySQL may be starting with a --skip-networking option. As far as I know, this would make the db server not accept any connections on port 3306.

Tux,
 
Old 02-14-2006, 12:38 PM   #4
g_srinivas
Member
 
Registered: Jul 2005
Location: USA
Distribution: SuSE 9
Posts: 49

Original Poster
Rep: Reputation: 15
Angry

Thanks for the quick reply. When i try to connect through MySql Administrator, i get the following error:

Code:
Could not connect to the specified instance.

MySQL Error Number 1130
Host 'xp-system' is not allowed to connect to this MySQL server

If you want to check the network connection, please click the Ping button.
And when i try to ping, i successfully get reply. The network connection between the two systems is fine (i'm sure about this).

Regarding, # man iptables i get the manual so i guess the firewall is integrated into my kernel. So could please tell me how to unblock port 3306?
 
Old 02-14-2006, 12:58 PM   #5
tuxrules
Senior Member
 
Registered: Jun 2004
Location: Chicago
Distribution: Slackware64 -current
Posts: 1,144

Rep: Reputation: 56
Quote:
And when i try to ping, i successfully get reply. The network connection between the two systems is fine (i'm sure about this).
Well then, try and see if what startup options your have for mysql. You can check /etc directory for my.cnf file (there may be several). Open up that file and look for --skip-networking option. I don't know much about debian but you can try.

Quote:
Regarding, # man iptables i get the manual so i guess the firewall is integrated into my kernel. So could please tell me how to unblock port 3306?
Having iptables installed doesn't mean you have it running. You have to actually construct rules and then start iptables service for a firewall to take effect.

Have you tried googling for your particular problem?

Tux,
 
Old 02-14-2006, 01:01 PM   #6
tuxrules
Senior Member
 
Registered: Jun 2004
Location: Chicago
Distribution: Slackware64 -current
Posts: 1,144

Rep: Reputation: 56
http://www.google.com/search?hl=en&l...30&btnG=Search

Something that may interest you...
 
Old 02-14-2006, 01:02 PM   #7
g_srinivas
Member
 
Registered: Jul 2005
Location: USA
Distribution: SuSE 9
Posts: 49

Original Poster
Rep: Reputation: 15
I checked MySql's my.cnf and skip_networking variable is disabled. Acutally i only disabled it as this would be first thing i need to disable if i need to access MySql through network.

I tried googling but.. didnt find any solution related to my problem, so i posted in this forum.
 
Old 02-14-2006, 01:11 PM   #8
g_srinivas
Member
 
Registered: Jul 2005
Location: USA
Distribution: SuSE 9
Posts: 49

Original Poster
Rep: Reputation: 15
Thanks tuxrules, the link worked and the solution was to grant privileges to the user account through which i am trying to access MySQL Administrator.

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

I have installed MySQL before on windows and never had to do this so never thought in this direction. Anyways, now that it worked thanks.
 
  


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
is there a firewall in debian linuxmandrake Debian 7 09-29-2005 03:19 PM
Firewall for debian PinRojas Debian 5 07-14-2005 10:42 PM
Debian installed now what? Oh Cisco Debian 12 07-28-2004 01:51 PM
Setting up an OpenBSD firewall... Got OBSD installed, can't see both nics! dboyer *BSD 5 01-18-2004 10:02 PM
debian firewall race Debian 8 12-31-2003 04:28 PM


All times are GMT -5. The time now is 03:05 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