COMODO firewall, Apache and Mysql server.

Comodo Internet Security - CIS News / Announcements / Feedback - CIS
1

Hello everyone! :slight_smile:

I’m new around here and am in need of help. So, I’d be glad if you’d be helpful and hospitable… O0

My problem is: I’ve just installed Apache v2.2 and Mysql v5.1.32. But because of COMODO firewall, I’m with problems with both. Apache isn’t working properly, but is still funtional. Now, Mysql isn’t working at all… :frowning:

During the configuration of Mysql server, I get the following message:

The security settings could not be applied to the database because the connection has failed with the following error.

Erro Nr. 1045
Access denied for user ‘root’@‘localhost’ (using password: YES)

If a personal firewall is running on your machine, please, make sure you have opened the TCP port 3306 for connection. otherwise no client application can connect to the server.

Well, I created a port set and added the said port. Went to ‘Network Security Policy’ and gave permission to the mysql executable. Then, I gave it ‘Trusted application’ status through ‘Computer Security Policy’.

Tried running but with no luck. Tried reinstalling. but still…

So, I don’t wanna have to uninstall COMODO because IMO it’s the best software firewall out there. But if you can’t help me, I’ll have to. :cry: Please, help me!

Thank you in advance,

Jacaré

2

Hi Jacare,

disclaimer - I’m not running either server.

From your post the question needs to be asked.
Did you also make a Global Rule to Allow TCP In Port 3306 From Any(or your desired clients) To your server IP

The application rules are considered second, after Global rules for incoming traffic.

Later

3

Hello Frogger dude,

hm… Now you got me… I MADE a global rule to “Allow TCP In/Out From IP Any to IP Any Where Source Port Is In [Mysql] And Destination Port Is In [Mysql]”. I guess I did something wrong… ? Should the destination port be something else?

4

I can’t give details as I don’t know your topology.

Does the machine making the request send the request from the same port as Mysql is set to listen on?

Does the firewall log show blocked connection attempts?

I think I would try it with source port changed to Any. destination port (mysql) listening port.

5

I 'm running the server on my own pc.

EDIT: only now I understood what you said. I’m goona give it a try.

6

If this is all to from the same machine, the global rules should have no effect.
If the firewall logs show no blocks, then the problem is probably to do with
account/user permissions in mysql itself.

7

Hum… BTW, where are the logs stored?

8

Firewall > Common Tasks > View Firewall Events

Also you are not alone, Search your error code at the mysql forums.

http://forums.mysql.com/

Looks like there are a boatload of possible places you could go wrong.

Later

9

Thanks, man! :-TU

Oh, there are no logs stored.

Now, I’m gonna bother them over there. :wink: