FireStats error : Database error: INSERT command denied to user 'dbo244183939'@'74.208.16.197' for table 'wp_firestats_pending_data'

MySQL Version: 5.0.81-log
SQL Query:
INSERT DELAYED INTO `wp_firestats_pending_data` ( `timestamp`, `site_id` , `url` , `referrer` , `useragent` , `ip`, `type` ) VALUES ( NOW(), '1', 'http://www.pinoytux.com/linux/tip-using-dig-to-show-nameservers', '', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', '38.107.191.89', NULL )
Jun
26

Tip: Using dig to Show Nameservers

If the need to scan a list of domains arises, be it one or one hundred, I have one handy Perl script that will list all nameservers of a domain. This script uses the command dig, and filters and lists the result. Do note that Perl must be installed to do this script.

# vi mx_checker.pl

#!/usr/bin/perl

$file=$ARGV[0];
chomp($file);

@list = `cat $file`;

foreach $domain(@list) {
chomp($domain);
$ns = `dig ns $domain +short`;
chomp($ns);
$ns =~s/\n/\t/g;
print “$domain\t$ns\n”;
}

To make the script executable, change the permissions:

# chmod 700 mx_checker.pl

Then build the list of domains by listing it on a text file, one domain per file.

# vi domains.txt

google.com
yahoo.com
usautoparts.com

Now that the script and domain list is ready, it is time to execute the script:

# ./mx_checker.pl domains.txt

The nameservers will then be listed and can be piped to a text file, which can be exported to a spreadsheet as tab-separated values.

# ./mx_checker.pl domains.txt >> nameservers.xls

Related Posts

Post comment

CommentLuv Enabled