Solved

perl mysql inetaton

Posted on 2013-12-18
11
345 Views
Last Modified: 2013-12-22
i want to add to mysql my ip addresses like this

perl ipadd.pl --ipclass=185.9.156.0/24

and it will add to 2 columns for each ip address

converted ip address and ip address
0
Comment
Question by:3XLcom
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 28

Expert Comment

by:FishMonger
ID: 39729397
What have you tried thus far?

What part of the process is giving you trouble?

What is your level of Perl knowledge?

What do you mean by "converted ip address"
0
 

Author Comment

by:3XLcom
ID: 39729406
nearly nothing we are just sending values to mysql db via perl
we are good at .net after getting values into mysql we are going on our way ;)
0
 
LVL 28

Expert Comment

by:FishMonger
ID: 39729456
So, are you're saying that you already do have a perl script that is updating the db, but are having trouble getting it to accomplish this task?

You need to be more specific on what you need to accomplish and what problems you're having with your current script.

From what you've posted so far, I have no clue to what you need to accomplish.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:3XLcom
ID: 39729482
we do not have any thing for this we just need a script which is
when we call it like perl addipclass.pl --ipclass=185.9.156.0/24



INSERT INTO `ipAdresleri` VALUES (3,3104414721,'185.9.156.1'),(4,3104414722,'185.9.156.2'),(5,3104414723,'185.9.156.3'),(6,3104414724,'185.9.156.4'),(7,3104414725,'185.9.156.5'),(8,3104414726,'185.9.156.6'),(9,3104414727,'185.9.156.7'),(10,3104414728,'185.9.156.8'),(11,3104414729,'185.9.156.9'),(12,3104414730,'185.9.156.10'),(13,3104414731,'185.9.156.11'),(14,3104414732,'185.9.156.12'),(15,3104414733,'185.9.156.13'),(16,3104414734,'185.9.156.14'),(17,3104414735,'185.9.156.15'),(18,3104414736,'185.9.156.16'),(19,3104414737,'185.9.156.17'),(20,3104414738,'185.9.156.18'),(21,3104414739,'185.9.156.19'),(22,3104414740,'185.9.156.20'),(23,3104414741,'185.9.156.21'),(24,3104414742,'185.9.156.22'),(25,3104414743,'185.9.156.23'),(26,3104414744,'185.9.156.24'),(27,3104414745,'185.9.156.25'),(28,3104414746,'185.9.156.26'),(29,3104414747,'185.9.156.27'),(30,3104414748,'185.9.156.28'),(31,3104414749,'185.9.156.29'),(32,3104414750,'185.9.156.30'),(33,3104414751,'185.9.156.31'),(34,3104414752,'185.9.156.32'),(35,3104414753,'185.9.156.33'),(36,3104414754,'185.9.156.34'),(37,3104414755,'185.9.156.35'),(38,3104414756,'185.9.156.36'),(39,3104414757,'185.9.156.37'),(40,3104414758,'185.9.156.38'),(41,3104414759,'185.9.156.39'),(42,3104414760,'185.9.156.40'),(43,3104414761,'185.9.156.41'),(44,3104414762,'185.9.156.42'),(45,3104414763,'185.9.156.43'),(46,3104414764,'185.9.156.44'),(47,3104414765,'185.9.156.45'),(48,3104414766,'185.9.156.46'),(49,3104414767,'185.9.156.47'),(50,3104414768,'185.9.156.48'),(51,3104414769,'185.9.156.49'),(52,3104414770,'185.9.156.50'),(53,3104414771,'185.9.156.51'),(54,3104414772,'185.9.156.52'),(55,3104414773,'185.9.156.53'),(56,3104414774,'185.9.156.54'),(57,3104414775,'185.9.156.55'),(58,3104414776,'185.9.156.56'),(59,3104414777,'185.9.156.57'),(60,3104414778,'185.9.156.58'),(61,3104414779,'185.9.156.59'),(62,3104414780,'185.9.156.60'),(63,3104414781,'185.9.156.61'),(64,3104414782,'185.9.156.62'),(65,3104414783,'185.9.156.63'),(66,3104414784,'185.9.156.64'),(67,3104414785,'185.9.156.65'),(68,3104414786,'185.9.156.66'),(69,3104414787,'185.9.156.67'),(70,3104414788,'185.9.156.68'),(71,3104414789,'185.9.156.69'),(72,3104414790,'185.9.156.70'),(73,3104414791,'185.9.156.71'),(74,3104414792,'185.9.156.72'),(75,3104414793,'185.9.156.73'),(76,3104414794,'185.9.156.74'),(77,3104414795,'185.9.156.75'),(78,3104414796,'185.9.156.76'),(79,3104414797,'185.9.156.77'),(80,3104414798,'185.9.156.78'),(81,3104414799,'185.9.156.79'),(82,3104414800,'185.9.156.80'),(83,3104414801,'185.9.156.81'),(84,3104414802,'185.9.156.82'),(85,3104414803,'185.9.156.83'),(86,3104414804,'185.9.156.84'),(87,3104414805,'185.9.156.85'),(88,3104414806,'185.9.156.86'),(89,3104414807,'185.9.156.87'),(90,3104414808,'185.9.156.88'),(91,3104414809,'185.9.156.89'),(92,3104414810,'185.9.156.90'),(93,3104414811,'185.9.156.91'),(94,3104414812,'185.9.156.92'),(95,3104414813,'185.9.156.93'),(96,3104414814,'185.9.156.94'),(97,3104414815,'185.9.156.95'),(98,3104414816,'185.9.156.96'),(99,3104414817,'185.9.156.97'),(100,3104414818,'185.9.156.98'),(101,3104414819,'185.9.156.99'),(102,3104414820,'185.9.156.100'),(103,3104414821,'185.9.156.101'),(104,3104414822,'185.9.156.102'),(105,3104414823,'185.9.156.103'),(106,3104414824,'185.9.156.104'),(107,3104414825,'185.9.156.105'),(108,3104414826,'185.9.156.106'),(109,3104414827,'185.9.156.107'),(110,3104414828,'185.9.156.108'),(111,3104414829,'185.9.156.109'),(112,3104414830,'185.9.156.110'),(113,3104414831,'185.9.156.111'),(114,3104414832,'185.9.156.112'),(115,3104414833,'185.9.156.113'),(116,3104414834,'185.9.156.114'),(117,3104414835,'185.9.156.115'),(118,3104414836,'185.9.156.116'),(119,3104414837,'185.9.156.117'),(120,3104414838,'185.9.156.118'),(121,3104414839,'185.9.156.119'),(122,3104414840,'185.9.156.120'),(123,3104414841,'185.9.156.121'),(124,3104414842,'185.9.156.122'),(125,3104414843,'185.9.156.123'),(126,3104414844,'185.9.156.124'),(127,3104414845,'185.9.156.125'),(128,3104414846,'185.9.156.126'),(129,3104414847,'185.9.156.127'),(130,3104414848,'185.9.156.128'),(131,3104414849,'185.9.156.129'),(132,3104414850,'185.9.156.130'),(133,3104414851,'185.9.156.131'),(134,3104414852,'185.9.156.132'),(135,3104414853,'185.9.156.133'),(136,3104414854,'185.9.156.134'),(137,3104414855,'185.9.156.135'),(138,3104414856,'185.9.156.136'),(139,3104414857,'185.9.156.137'),(140,3104414858,'185.9.156.138'),(141,3104414859,'185.9.156.139'),(142,3104414860,'185.9.156.140'),(143,3104414861,'185.9.156.141'),(144,3104414862,'185.9.156.142'),(145,3104414863,'185.9.156.143'),(146,3104414864,'185.9.156.144'),(147,3104414865,'185.9.156.145'),(148,3104414866,'185.9.156.146'),(149,3104414867,'185.9.156.147'),(150,3104414868,'185.9.156.148'),(151,3104414869,'185.9.156.149'),(152,3104414870,'185.9.156.150'),(153,3104414871,'185.9.156.151'),(154,3104414872,'185.9.156.152'),(155,3104414873,'185.9.156.153'),(156,3104414874,'185.9.156.154'),(157,3104414875,'185.9.156.155'),(158,3104414876,'185.9.156.156'),(159,3104414877,'185.9.156.157'),(160,3104414878,'185.9.156.158'),(161,3104414879,'185.9.156.159'),(162,3104414880,'185.9.156.160'),(163,3104414881,'185.9.156.161'),(164,3104414882,'185.9.156.162'),(165,3104414883,'185.9.156.163'),(166,3104414884,'185.9.156.164'),(167,3104414885,'185.9.156.165'),(168,3104414886,'185.9.156.166'),(169,3104414887,'185.9.156.167'),(170,3104414888,'185.9.156.168'),(171,3104414889,'185.9.156.169'),(172,3104414890,'185.9.156.170'),(173,3104414891,'185.9.156.171'),(174,3104414892,'185.9.156.172'),(175,3104414893,'185.9.156.173'),(176,3104414894,'185.9.156.174'),(177,3104414895,'185.9.156.175'),(178,3104414896,'185.9.156.176'),(179,3104414897,'185.9.156.177'),(180,3104414898,'185.9.156.178'),(181,3104414899,'185.9.156.179'),(182,3104414900,'185.9.156.180'),(183,3104414901,'185.9.156.181'),(184,3104414902,'185.9.156.182'),(185,3104414903,'185.9.156.183'),(186,3104414904,'185.9.156.184'),(187,3104414905,'185.9.156.185'),(188,3104414906,'185.9.156.186'),(189,3104414907,'185.9.156.187'),(190,3104414908,'185.9.156.188'),(191,3104414909,'185.9.156.189'),(192,3104414910,'185.9.156.190'),(193,3104414911,'185.9.156.191'),(194,3104414912,'185.9.156.192'),(195,3104414913,'185.9.156.193'),(196,3104414914,'185.9.156.194'),(197,3104414915,'185.9.156.195'),(198,3104414916,'185.9.156.196'),(199,3104414917,'185.9.156.197'),(200,3104414918,'185.9.156.198'),(201,3104414919,'185.9.156.199'),(202,3104414920,'185.9.156.200'),(203,3104414921,'185.9.156.201'),(204,3104414922,'185.9.156.202'),(205,3104414923,'185.9.156.203'),(206,3104414924,'185.9.156.204'),(207,3104414925,'185.9.156.205'),(208,3104414926,'185.9.156.206'),(209,3104414927,'185.9.156.207'),(210,3104414928,'185.9.156.208'),(211,3104414929,'185.9.156.209'),(212,3104414930,'185.9.156.210'),(213,3104414931,'185.9.156.211'),(214,3104414932,'185.9.156.212'),(215,3104414933,'185.9.156.213'),(216,3104414934,'185.9.156.214'),(217,3104414935,'185.9.156.215'),(218,3104414936,'185.9.156.216'),(219,3104414937,'185.9.156.217'),(220,3104414938,'185.9.156.218'),(221,3104414939,'185.9.156.219'),(222,3104414940,'185.9.156.220'),(223,3104414941,'185.9.156.221'),(224,3104414942,'185.9.156.222'),(225,3104414943,'185.9.156.223'),(226,3104414944,'185.9.156.224'),(227,3104414945,'185.9.156.225'),(228,3104414946,'185.9.156.226'),(229,3104414947,'185.9.156.227'),(230,3104414948,'185.9.156.228'),(231,3104414949,'185.9.156.229'),(232,3104414950,'185.9.156.230'),(233,3104414951,'185.9.156.231'),(234,3104414952,'185.9.156.232'),(235,3104414953,'185.9.156.233'),(236,3104414954,'185.9.156.234'),(237,3104414955,'185.9.156.235'),(238,3104414956,'185.9.156.236'),(239,3104414957,'185.9.156.237'),(240,3104414958,'185.9.156.238'),(241,3104414959,'185.9.156.239'),(242,3104414960,'185.9.156.240'),(243,3104414961,'185.9.156.241'),(244,3104414962,'185.9.156.242'),(245,3104414963,'185.9.156.243'),(246,3104414964,'185.9.156.244'),(247,3104414965,'185.9.156.245'),(248,3104414966,'185.9.156.246'),(249,3104414967,'185.9.156.247'),(250,3104414968,'185.9.156.248'),(251,3104414969,'185.9.156.249'),(252,3104414970,'185.9.156.250'),(253,3104414971,'185.9.156.251'),(254,3104414972,'185.9.156.252'),(255,3104414973,'185.9.156.253'),(256,3104414974,'185.9.156.254'),(257,3104414975,'185.9.156.255'),

Open in new window

0
 
LVL 28

Expert Comment

by:FishMonger
ID: 39729684
I need to work on some other project, but will work up something for you when I have more time.

I'm assuming the first field you're inserting is an auto incrementing "id" field.  Is that correct?
0
 

Author Comment

by:3XLcom
ID: 39729693
yes it is and it does not be needed in the insert into statement
0
 
LVL 28

Expert Comment

by:FishMonger
ID: 39729734
Ok, so all that is needed in the insert is the IP address in int and dotted quad format.

Rather than putting the entire range in a single statement, I'd probably do it in a loop like I did in your other question.

The script will need 2 additional modules.  Getopt::Long which is used to handle the parsing of the script args and Net::IP or one of its cousins such as Net::CIDR to handle the address range calculation.

You might like to look over those modules.
0
 

Author Comment

by:3XLcom
ID: 39729769
i will but i am sure i can not do it because i am a .net developer . unfortunately we are following sflow and it is not easy on windows & asp.net this is our last part to organize system on cent os side
0
 
LVL 28

Accepted Solution

by:
FishMonger earned 500 total points
ID: 39730852
I didn't build a test database which also means I didn't test this script, so it may need a slight tweak.
#!/usr/bin/perl

use strict;
use warnings;
use DBI;
use Net::IP;
use Getopt::Long;

GetOptions("ipclass=s" => \my $ipclass)
    or die "Invalid command line arguments\n";

$ipclass or die "Missing required -ipclass arg\n";

my $network = Net::IP->new($ipclass) or die Net::IP::Error();

my $dbh = DBI->connect("DBI:mysql:db:db_server", 'user', 'password',
                       {RaiseError => 1})
        or die "Failed to connect to database $DBI::errstr";

my $sth = $dbh->prepare("INSERT INTO ipAdresleri(IP_int, IP_quad)
                         VALUES(?,inet_ntoa(?)");

for (my $ip = $network->intip; $ip <= $network->last_int; $ip++) {
    $sth->execute($ip, $ip);
}

$dbh->disconnect;

Open in new window

0
 
LVL 28

Expert Comment

by:FishMonger
ID: 39735251
Have you had a chance to test the script?

Do you have any questions about the script?
0
 

Author Closing Comment

by:3XLcom
ID: 39735401
I am sorry thank you
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

On Microsoft Windows, if  when you click or type the name of a .pl file, you get an error "is not recognized as an internal or external command, operable program or batch file", then this means you do not have the .pl file extension associated with …
A year or so back I was asked to have a play with MongoDB; within half an hour I had downloaded (http://www.mongodb.org/downloads),  installed and started the daemon, and had a console window open. After an hour or two of playing at the command …
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question