IP Tables Add Open Port 3306 Post: 302545395

Sponsored Content

Operating Systems Linux IP Tables Add Open Port 3306 Post 302545395 by fspalero on Monday 8th of August 2011 09:05:10 AM

08-08-2011

Registered User

Hi Pludi,

I'm using Mysql,the command ;

Code:

[root]# /etc/init.d/mysql start
Starting MySQL                                             [  OK  ]
Checking Database socket .................................Database is not running

[root]# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

########
#my.cnf
########
[manager]
default-mysqld-path = /firescope/mysql/bin/mysqld
socket=/tmp/manager.sock
log=/firescope_data/mysqlmanager.err
pid-file=/firescope_data/mysqlmanager.pid
angel-pid-file=/firescope_data/mysqlmanager.angel.pid
password-file=/etc/.mysqlmanager.passwd
monitoring-interval = 20
port = 3406
bind-address = 127.0.0.1
run-as-service

# The following options will be passed to all MySQL clients
[client]
#password       = your_password
port            = 3306
socket          =/tmp/mysql.sock

# The MySQL server
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking
pid-file        = /firescope_data/mysqld.pid
log-error       = /firescope_data/mysql.err
basedir         = /firescope/mysql
datadir         = /firescope_data
innodb_data_home_dir = /firescope_data/
innodb_data_file_path = ibdata1:256M:autoextend
innodb_log_group_home_dir = /firescope_data/
innodb_log_arch_dir = /firescope_data/
innodb_buffer_pool_size = 768M
innodb_additional_mem_pool_size = 32M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 192M
innodb_log_buffer_size = 64M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

[mysqld_safe]
ledir==/usr/bin

!includedir /etc/mysql.d

Regards,
FSPalero

Last edited by fpmurphy; 08-08-2011 at 10:12 AM..

fspalero

View Public Profile for fspalero

Find all posts by fspalero

10 More Discussions You Might Find Interesting

1. Cybersecurity

Open Port 3306 for MySQL connection

I am needing to "un-block" port 3306 so that I can access MySQL from another PC. When I installed Mandrake 8.1, I set the security level to high because it is going to be a web server. I believe I have to allow access to my ports now and I do not know the commands to do that. If anyone...

2. Linux

open port

How can I open a port on linux machine ???

3. IP Networking

Unknown open port: "6881/tcp open bittorrent-tracker" found with nmap

Hi. I ran nmap on my server, and I get the following: Starting Nmap 4.76 ( http://nmap.org ) at 2009-03-19 16:33 EDT Interesting ports on -------- (-----): Not shown: 997 closed ports PORT STATE SERVICE 22/tcp open ssh 80/tcp open http 6881/tcp open bittorrent-tracker The...

4. Solaris

how to open specific port

Dear members, My release is open Solaris b103 1- How to know the opening port in my system 2- How to open a specific port like port number 53 3- How to closed the specific port like port number 53 Your feedback highly appreciated

5. Solaris

Open port on Solaris 10

Hi All, I am installing Infosphere (ETL tool) on solaris 10. One of the requirement is to open multiple ports for different apps that will be installed. I ran netstat -n | grep 9080 (,etc) but that did not return anything. I have attached the requirement. Can anyone guide me about how to...

6. UNIX for Dummies Questions & Answers

Linux - How to Open a Port

Hi, I would like to open a specific port for use with a bespoke application. Before everyone points me to other threads - I read a few but couldn't find any specific to my problem. Iptables / firewall is disabled SELinux is also disabled I would just like to assign this port to this...

7. IP Networking

Tcp ip port open but no such process (merged: Release A Port)

i want to kill a tcp connection by killing its pid with netstat -an i got the tcp ip connection on port 5914 but when i type ps -a or ps-e there is not such process running on port 5914 is it possible that because i do not log on with proper user account i can not see that process running?

8. HP-UX

How to open 443 port in HP-UX?

Hello Experts, I want to open the port 443 on my HP-UX system. can you please help ? Thanks in advance.

9. UNIX for Beginners Questions & Answers

Script for port is open or not

I need a script on which if i will pass the port number and the host name as external parameter then it should respond me if the port is open or not thread moved

10. Cybersecurity

Blocking 3306 with iptables -A INPUT -p tcp --dport 3306

Just added these lines to our server firewall: iptables -A INPUT -p tcp --dport 3306 -s 127.0.0.1 -d 127.0.0.1 -j ACCEPT iptables -A INPUT -p tcp --dport 3306 -j DROP Even though mysql is configured to correctly only listen on port 127.0.0.1 we still see these mysql log file notes on a daily...

LEARN ABOUT DEBIAN

ocf_heartbeat_mysql-proxy

OCF_HEARTBEAT_MYSQL()													     OCF_HEARTBEAT_MYSQL()

NAME

       ocf_heartbeat_mysql-proxy - Manages a MySQL Proxy daemon

SYNOPSIS

       mysql-proxy [start | stop | monitor | meta-data | validate-all]

DESCRIPTION

       This script manages MySQL Proxy as an OCF resource in a high-availability setup. Tested with MySQL Proxy 0.7.0 on Debian 5.0.

SUPPORTED PARAMETERS

       binary
	   Full path to the MySQL Proxy binary. For example, "/usr/sbin/mysql-proxy".  (optional, string, default /usr/sbin/mysql-proxy)

       defaults_file
	   Full path to a MySQL Proxy configuration file. For example, "/etc/mysql-proxy.conf".  (unique, optional, string, no default)

       proxy_backend_addresses
	   Address:port of the remote backend-servers (default: 127.0.0.1:3306).  (optional, string, default 127.0.0.1:3306)

       proxy_read_only_backend_addresses
	   Address:port of the remote (read only) slave-server (default: ).  (optional, string, default 127.0.0.1:3306)

       proxy_address
	   Listening address:port of the proxy-server (default: :4040). You can also specify a socket like "/tmp/mysql-proxy.sock".  (optional,
	   string, default :4040)

       log_level
	   Log all messages of level (error|warning|info|message|debug|) or higher. An empty value disables logging.  (optional, string, no
	   default)

       keepalive
	   Try to restart the proxy if it crashed (default: ). Valid values: true or false. An empty value equals "false".  (optional, string, no
	   default)

       admin_address
	   Listening address:port of the admin-server (default: 127.0.0.1:4041).  (optional, string, default 127.0.0.1:4041)

       admin_username
	   Username to allow to log in (default: ).  (optional, string, no default)

       admin_password
	   Password to allow to log in (default: ).  (optional, string, no default)

       admin_lua_script
	   Script to execute by the admin plugin.  (optional, string, no default)

       parameters
	   The MySQL Proxy daemon may be called with additional parameters. Specify any of them here.  (optional, string, no default)

       pidfile
	   PID file (unique, optional, string, default /var/run/resource-agents/mysql-proxy-default.pid)

SUPPORTED ACTIONS

       This resource agent supports the following actions (operations):

       start
	   Starts the resource. Suggested minimum timeout: 30s.

       stop
	   Stops the resource. Suggested minimum timeout: 30s.

       reload
	   Suggested minimum timeout: 30s.

       monitor
	   Performs a detailed status check. Suggested minimum timeout: 20s. Suggested interval: 60s.

       validate-all
	   Performs a validation of the resource configuration. Suggested minimum timeout: 30s.

       meta-data
	   Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5s.

EXAMPLE

       The following is an example configuration for a mysql-proxy resource using the crm(8) shell:

	   primitive p_mysql-proxy ocf:heartbeat:mysql-proxy 
	     op monitor depth="0" timeout="20s" interval="60s"

SEE ALSO

       http://www.linux-ha.org/wiki/mysql-proxy_(resource_agent)

AUTHOR

       Linux-HA contributors (see the resource agent source for information about individual authors)

															     OCF_HEARTBEAT_MYSQL()

10 More Discussions You Might Find Interesting

1. Cybersecurity

Open Port 3306 for MySQL connection

Discussion started by: gdboling

2. Linux

open port

Discussion started by: mm00123

3. IP Networking

Unknown open port: "6881/tcp open bittorrent-tracker" found with nmap

Discussion started by: Rledley

4. Solaris

how to open specific port

Discussion started by: dellroxy