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
mysqlbug
MYSQLBUG(1) MySQL Database System MYSQLBUG(1)
NAME
mysqlbug - generate bug report
SYNOPSIS
mysqlbug
DESCRIPTION
This program enables you to generate a bug report and send it to Oracle Corporation. It is a shell script and runs on Unix.
The normal way to report bugs is to visit http://bugs.mysql.com/, which is the address for our bugs database. This database is public and
can be browsed and searched by anyone. If you log in to the system, you can enter new reports. If you have no Web access, you can generate
a bug report by using the mysqlbug script.
mysqlbug helps you generate a report by determining much of the following information automatically, but if something important is missing,
please include it with your message. mysqlbug can be found in the scripts directory (source distribution) and in the bin directory under
your MySQL installation directory (binary distribution).
Invoke mysqlbug without arguments:
shell> mysqlbug
The script will place you in an editor with a copy of the report to be sent. Edit the lines near the beginning that indicate the nature of
the problem. Then write the file to save your changes, quit the editor, and mysqlbug will send the report by email.
COPYRIGHT
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Sun Microsystems, Inc. (http://www.mysql.com/).
MySQL 5.1 04/06/2010 MYSQLBUG(1)