09-14-2006
ip address and subnet comparing
Hmmm, tough question for me, so I put it here.
I am trying to use shell script or mysql to do the following thing.
tableA, in which all are single ips.
sip
-------
1.2.3.4
8.8.8.8
123.3.32.1
....
and tableB, a list of our group subnets.
subnet
---------
1.0.0.0/8
20.0.1.0/24
.....
What I want is only picking up those ips belong to our group from tableA according to the subnet tableB
I have no idea on this till now, so can anyone give me some instructions?
Thank a lot!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi, I'm new to unix and have absolutely no experience with it. I am trying to change the network setting on the only computer on our network with SCO Unix. We switched ISP's and now have a new set of IP's. I can't for the life of me figure out how to go in and change these settings, please help.... (12 Replies)
Discussion started by: PBNOSGT
12 Replies
2. SCO
I am trying to find out if you can create an ACL for telnet sessions and restrict it to a certain subnet/IP range..
any information or where to look would be greatly appreciated.
thanks (1 Reply)
Discussion started by: marvin51796
1 Replies
3. IP Networking
Hi,
My project needs to migrate the existing Subnet (255.255.255.0) to a new subnet and change the ipaddresses (currently C class). How can I do that. I need some information.
John (0 Replies)
Discussion started by: johnmarsh
0 Replies
4. IP Networking
Hi,
How do I get subnet from this:
10.252.0.138/25
Tnx (2 Replies)
Discussion started by: mehrdad68
2 Replies
5. UNIX for Dummies Questions & Answers
:) Firstly Hi all!!, im NEW!! and on here hoping that someone might be able to offer me some help... i have a server that keeps crashing every few days with the error message:
PANIC KERNAL-MODE ADDRESS FAULT ON USER ADDRESS 0X14
KERNAL PAGE FAULT FROM (CS:EIP)=(100:EF71B5BD)
EAX=EF822000... (10 Replies)
Discussion started by: Twix
10 Replies
6. AIX
AIX:Command to get netaddress/subnet address command in IPv4/IP6
Can anybody help us with a command to retrieve netaddress/subnet address command in IPv4/IP6 on aix machine.
net/subnet address is in the format 172.16.212.0(signifies all 255 machines in an IPv4 network) (2 Replies)
Discussion started by: rookie8278
2 Replies
7. IP Networking
Is there a command that can lookup ip address, subnet mask, gateway, and dns all at the same. I know ifconfig can lookup ip address and subnet mask. I know route -n can lookup gateway. Not sure about a dns command. So I hope there is a way to lookup ip address, subnet mask, gateway, and dns all at... (2 Replies)
Discussion started by: cokedude
2 Replies
8. Shell Programming and Scripting
I have an input file:
class 1 3 5 10.10.10..0/23 hicks jimmy
class 3 10.12.10.0/22 mike
class.019283 10.10.15.10/20 henry
gym.847585 45 192.168.10.0/22 nancy jim steve maya
The output should look like this:
10.10.10..0/23
10.12.10.0/22
10.10.15.10/20
192.168.10.0/22
I have the... (3 Replies)
Discussion started by: e_mikey_2000
3 Replies
9. Shell Programming and Scripting
I have this subnet file shown below. How can I calculate all ip addresses from that list
103.22.200.0/22
141.101.64.0/18
10.0.0.0/22I need to be able to read the subnet file and print all IPs in those subnet to an out put file (3 Replies)
Discussion started by: e_mikey_2000
3 Replies
10. UNIX for Advanced & Expert Users
Hi ,
Could someone let me know how to detect duplicate ip address after assigning ip address to ethernet interface using c program (3 Replies)
Discussion started by: Gopi Krishna P
3 Replies
LEARN ABOUT CENTOS
pmdamysql
PMDAMYSQL(1) Performance Co-Pilot PMDAMYSQL(1)
NAME
pmdamysql - MySQL database PMDA
DESCRIPTION
pmdamysql is a Performance Co-Pilot PMDA which extracts live performance data from a running MySQL database.
INSTALLATION
pmdamysql uses a configuration file from (in this order):
o /etc/pcpdbi.conf
o $PCP_PMDAS_DIR/mysql/mysql.conf
This file can contain overridden values (Perl code) for the settings listed at the start of pmdamysql.pl, namely:
o database name (see DBI(3) for details)
o database user name
o database pass word
Once this is setup, you can access the names and values for the mysql performance metrics by doing the following as root:
# cd $PCP_PMDAS_DIR/mysql
# ./Install
If you want to undo the installation, do the following as root:
# cd $PCP_PMDAS_DIR/mysql
# ./Remove
pmdamysql is launched by pmcd(1) and should never be executed directly. The Install and Remove scripts notify pmcd(1) when the agent is
installed or removed.
Binary Status values in text
Some of the status values are in the form of YES/NO or ON/OFF.
Since these cannot be intepreted by tools like PMIE, they have been duplicated with a _num extension and the values of 1 (YES/ON) or 0
(NO/OFF).
Eg:
o mysql.slave_status.slave_io_running
o mysql.slave_status.slave_io_running_num
FILES
/etc/pcpdbi.conf
configuration file for all PCP database monitors
$PCP_PMDAS_DIR/mysql/mysql.conf
configuration file for pmdamysql
$PCP_PMDAS_DIR/mysql/Install
installation script for the pmdamysql agent
$PCP_PMDAS_DIR/mysql/Remove
undo installation script for the pmdamysql agent
$PCP_LOG_DIR/pmcd/mysql.log
default log file for error messages from pmdamysql
SEE ALSO
pmcd(1), pmdadbping.pl(1) and DBI(3). # vi: sw=4 ts=4 et:
3.8.10 Performance Co-Pilot PMDAMYSQL(1)