Iptables Log in mysql

5 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

iptables - allow MySql

Hi I want to allow mysql connections to my server and I have added the following iptables. Chain INPUT (policy ACCEPT) target prot opt source destination ACCEPT tcp -- anywhere anywhere tcp dpt:mysql Chain FORWARD (policy ACCEPT) target ...

2. UNIX and Linux Applications

MySQL Daemon failed to start - no mysql.sock file

After doing a yum install mysql mysql-server on Fedora 14 I wasn't able to fully install the packages correctly. It installed MySQL 5.1. I was getting the following error when running the: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)...

3. UNIX and Linux Applications

missing delimiters when mysql output is redirected to log file

Hi, Pls check that '|' and '+' present in Step-1 are not copied to log file in Step-3. Pls suggest how to get the exact output from Step-1 (i.e. with out losing '|' and '+') in to a log file ~Thanks Step-1: Execute command > mysql -utest -ptest -htesthost testdb -e "select * from...

4. Shell Programming and Scripting

Extract Mysql table output to a log file

I need to compare the 2 mysql database tables. there are around 50 tables in each DB. my idea is in DB1 extract result select * from table1; to alog file1 in DB2 extract result select * from table1; to alog file2 now compare log file 1 file 2 pls help me out ... thanks in advance

5. UNIX and Linux Applications

MySQL Slow Queries Log: Lock_time

In MySQL's slow queries log, it'll have an entry like this: # User@Host: scc_service @ # Query_time: 43 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET timestamp=1237769209; UPDATE loan SET funding_status="scheduled",datetime_approved=now() WHERE loan_id = '00000'; What does Lock_time...

LEARN ABOUT MOJAVE

tc-xt

iptables action in tc(8)                                               Linux                                              iptables action in tc(8)

NAME

       xt - tc iptables action

SYNOPSIS

       tc ... action xt -j TARGET [ TARGET_OPTS ]

DESCRIPTION

       The xt action allows to call arbitrary iptables targets for packets matching the filter this action is attached to.

OPTIONS

       -j TARGET [ TARGET_OPTS ]
              Perform a jump to the given iptables target, optionally passing any target specific options in TARGET_OPTS.

EXAMPLES

       The  following  will  attach a u32 filter to the ingress qdisc matching ICMP replies and using the xt action to make the kernel yell 'PONG'
       each time:

              tc qdisc add dev eth0 ingress
              tc filter add dev eth0 parent ffff: proto ip u32 
                   match ip protocol 1 0xff 
                   match ip icmp_type 0 0xff 
                   action xt -j LOG --log-prefix PONG

SEE ALSO

       tc(8), tc-u32(8), iptables-extensions(8)

iproute2                                                            3 Mar 2016                                            iptables action in tc(8)

IP Networking