Mysql Server

[ut12345]

Hi,

Scenario-: I'm using pfsense version 2.1 and Mysql server 5.5. Let us assume two pfsense box as pfsense A & pfsense B.

Problem-: I have successfully installed pfsense & also installed Mysql server version 5.5 at two different pfsense box. For some purpose, I want to access the Mysql database of pfsense A by using pfsense B.

Thanks

[Gertjan]

Hi,

Please,
The begin with : do NOT install something like MySQL on a firewall.
I have to say this because you made it very clear that you do not know how to setup a 'MySQL' installation.

According to the MySQL manual ("the 2 page version") every installation of mySQL only listens to 'localhost' or 12700.0.1 or :11 by default.
You should 'RTFM' and change /etc/mysql/my.cnf (typically) so you can access MySQL from the outside of the server (which is a firewall).

Btw : This has nothing to do with pfSense.
Btw : This is against MySQL recommendations.

[ut12345]

@Gertjan:

Hi,

Please,
The begin with : do NOT install something like MySQL on a firewall.
I have to say this because you made it very clear that you do not know how to setup a 'MySQL' installation.

According to the MySQL manual ("the 2 page version") every installation of mySQL only listens to 'localhost' or 12700.0.1 or :11 by default.
You should 'RTFM' and change /etc/mysql/my.cnf (typically) so you can access MySQL from the outside of the server (which is a firewall).

Btw : This has nothing to do with pfSense.
Btw : This is against MySQL recommendations.

sorry I did not get your explanation according to my question.I have not found any my.cnf file at that location (/etc/mysql/my.cnf). Can you please explain it in more detail. I'm new to using pfsense.

Thanks

[Gertjan]

@ut12345:

….. I'm new to using pfsense.

pfSense is NOT the issue neither related to the question.

"pfSense" uses an OS : FreeBSD. Evey OS has it's own places where it stores executables and config files.
So, the "my.cnf", if it isn't here  /etc/mysql/my.cnf (like a Debian OS system, there where a MySQL belongs) it's elsewhere.
The fact that you can't find the file my.cnf is the problem (tip : you saw this thread :
[HOWTO] Captive portal + FreeRADIUS + local MySQL user friendly single step ? You should read it. It talks about MySQL and FreeBSD ….. so .... ;)).

[ut12345]

@Gertjan:

@ut12345:

….. I'm new to using pfsense.

pfSense is NOT the issue neither related to the question.

"pfSense" uses an OS : FreeBSD. Evey OS has it's own places where it stores executables and config files.
So, the "my.cnf", if it isn't here  /etc/mysql/my.cnf (like a Debian OS system, there where a MySQL belongs) it's elsewhere.
The fact that you can't find the file my.cnf is the problem (tip : you saw this thread :
[HOWTO] Captive portal + FreeRADIUS + local MySQL user friendly single step ? You should read it. It talks about MySQL and FreeBSD ….. so .... ;)).

I know this process  and I have sucessfully installed this process but my question is  that below:

Scenario-: I'm using pfsense version 2.1 and Mysql server 5.5. Let us assume two pfsense box as pfsense A & pfsense B.

Problem-: I have successfully installed pfsense & also installed Mysql server version 5.5 at two different pfsense box. For some purpose, I want to access the Mysql database of pfsense A by using pfsense B.

[Gertjan]

Modify the 'my.cnf' (de main MySQL config file) so it accepts not only connection from localhost (127.0.0.1) but also the 'external' IP  that the other pfSense would use to connect to the server.
This is well described in the MySQL doc.

You need to locate the file, and change it.
Restart MySQL.
[ check if the firewall on the IP/NIC isn't blocking incoming connections on the MySQL port ]
Done.