From: Alexander M. <key...@us...> - 2003-07-16 14:37:04
|
CVSROOT : /cvsroot/publicdnsadmin Module : publicdnsadmin Commit time: 2003-07-16 14:37:02 UTC Modified files: docs/CHANGELOG docs/TODO docs/mysql.sql docs/postgresql.sql docs/whois.update.mysql.sql docs/whois.update.postgres.sql Added files: docs/whoissrv.mysql.sql docs/whoissrv.postgres.sql Log message: Author: Alexander Maassen <out...@ke...> Log message: - Added all needed whois servers one might need ---------------------- diff included ---------------------- Index: publicdnsadmin/docs/CHANGELOG diff -u publicdnsadmin/docs/CHANGELOG:1.18 publicdnsadmin/docs/CHANGELOG:1.19 --- publicdnsadmin/docs/CHANGELOG:1.18 Wed Jul 16 06:53:57 2003 +++ publicdnsadmin/docs/CHANGELOG Wed Jul 16 07:36:51 2003 @@ -35,3 +35,6 @@ sourceforge project interface. OUTsider <out...@ke...> - 16/7/2003 - Updated TODO and docs again to reflect new changes - Moved whois to use SQL instead as source for whois servers + - Added a list of all required whois servers you might need. + Import docs/whoissrv.<dbtype>.sql into your database. + (NOTE: Upgraders first import docs/whois.update.<dbtype>.sql !!) Index: publicdnsadmin/docs/TODO diff -u publicdnsadmin/docs/TODO:1.7 publicdnsadmin/docs/TODO:1.8 --- publicdnsadmin/docs/TODO:1.7 Wed Jul 16 06:53:57 2003 +++ publicdnsadmin/docs/TODO Wed Jul 16 07:36:51 2003 @@ -1,6 +1,5 @@ - Some sort of maintenence news system (displayed on the main login page). - Improve nsstats.php. - Add URL/HWINFO/MBOXFW/RP record type support. -- Create an interface to manage domain registries whois servers. - Syntax check records for validity to make it more fool proof. Index: publicdnsadmin/docs/mysql.sql diff -u publicdnsadmin/docs/mysql.sql:1.3 publicdnsadmin/docs/mysql.sql:1.4 --- publicdnsadmin/docs/mysql.sql:1.3 Wed Jul 16 06:53:57 2003 +++ publicdnsadmin/docs/mysql.sql Wed Jul 16 07:36:51 2003 @@ -54,15 +54,3 @@ ); CREATE INDEX gfxcodes_idx ON gfxcodes(code,crc,expire); - -INSERT INTO users VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'DNS Administrator', 'hos...@ex...', '', '2'); -INSERT INTO whoisservers VALUES (1,'com','whois.crsnic.net'); -INSERT INTO whoisservers VALUES (2,'net','whois.crsnic.net'); -INSERT INTO whoisservers VALUES (3,'edu','whois.crsnic.net'); -INSERT INTO whoisservers VALUES (4,'info','whois.afilias.net'); -INSERT INTO whoisservers VALUES (5,'name','whois.nic.name'); -INSERT INTO whoisservers VALUES (6,'biz','whois.nic.biz'); -INSERT INTO whoisservers VALUES (7,'us','whois.nic.us'); -INSERT INTO whoisservers VALUES (8,'cc','whois.enicregistrar.com'); -INSERT INTO whoisservers VALUES (9,'org','whois.enom.com'); -INSERT INTO whoisservers VALUES (10,'ws','whois.nic.ws'); Index: publicdnsadmin/docs/postgresql.sql diff -u publicdnsadmin/docs/postgresql.sql:1.5 publicdnsadmin/docs/postgresql.sql:1.6 --- publicdnsadmin/docs/postgresql.sql:1.5 Wed Jul 16 06:53:57 2003 +++ publicdnsadmin/docs/postgresql.sql Wed Jul 16 07:36:51 2003 @@ -54,14 +54,3 @@ CREATE INDEX gfxcodes_idx ON gfxcodes(code,crc,expire); INSERT INTO "users" ("username", "password", "name", "email", "company", "permission") VALUES('outsider', '21232f297a57a5a743894a0e4a801fc3', 'DNS Administrator', 'out...@ke...', 'Key2Peace BotServices', 2); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('com','whois.crsnic.net'); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('net','whois.crsnic.net'); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('edu','whois.crsnic.net'); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('info','whois.afilias.net'); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('name','whois.nic.name'); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('biz','whois.nic.biz'); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('us','whois.nic.us'); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('cc','whois.enicregistrar.com'); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('org','whois.enom.com'); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('ws','whois.nic.ws'); - Index: publicdnsadmin/docs/whois.update.mysql.sql diff -u publicdnsadmin/docs/whois.update.mysql.sql:1.1 publicdnsadmin/docs/whois.update.mysql.sql:1.2 --- publicdnsadmin/docs/whois.update.mysql.sql:1.1 Wed Jul 16 06:53:57 2003 +++ publicdnsadmin/docs/whois.update.mysql.sql Wed Jul 16 07:36:51 2003 @@ -5,13 +5,3 @@ PRIMARY KEY (id) ); -INSERT INTO whoisservers VALUES (1,'com','whois.crsnic.net'); -INSERT INTO whoisservers VALUES (2,'net','whois.crsnic.net'); -INSERT INTO whoisservers VALUES (3,'edu','whois.crsnic.net'); -INSERT INTO whoisservers VALUES (4,'info','whois.afilias.net'); -INSERT INTO whoisservers VALUES (5,'name','whois.nic.name'); -INSERT INTO whoisservers VALUES (6,'biz','whois.nic.biz'); -INSERT INTO whoisservers VALUES (7,'us','whois.nic.us'); -INSERT INTO whoisservers VALUES (8,'cc','whois.enicregistrar.com'); -INSERT INTO whoisservers VALUES (9,'org','whois.enom.com'); -INSERT INTO whoisservers VALUES (10,'ws','whois.nic.ws'); Index: publicdnsadmin/docs/whois.update.postgres.sql diff -u publicdnsadmin/docs/whois.update.postgres.sql:1.1 publicdnsadmin/docs/whois.update.postgres.sql:1.2 --- publicdnsadmin/docs/whois.update.postgres.sql:1.1 Wed Jul 16 06:53:57 2003 +++ publicdnsadmin/docs/whois.update.postgres.sql Wed Jul 16 07:36:52 2003 @@ -4,16 +4,3 @@ server varchar(128) NOT NULL default '', PRIMARY KEY (id) ); -DELETE FROM whoisservers; - -INSERT INTO "whoisservers" ("tld", "server") VALUES ('com','whois.crsnic.net'); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('net','whois.crsnic.net'); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('edu','whois.crsnic.net'); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('info','whois.afilias.net'); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('name','whois.nic.name'); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('biz','whois.nic.biz'); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('us','whois.nic.us'); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('cc','whois.enicregistrar.com'); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('org','whois.enom.com'); -INSERT INTO "whoisservers" ("tld", "server") VALUES ('ws','whois.nic.ws'); - Index: publicdnsadmin/docs/whoissrv.mysql.sql diff -u /dev/null publicdnsadmin/docs/whoissrv.mysql.sql:1.1 --- /dev/null Wed Jul 16 07:37:02 2003 +++ publicdnsadmin/docs/whoissrv.mysql.sql Wed Jul 16 07:36:52 2003 @@ -0,0 +1,86 @@ +DELETE FROM whoisservers; +INSERT INTO whoisservers VALUES (1, 'ac','whois.nic.ac'); +INSERT INTO whoisservers VALUES (2, 'ad','whois.ripe.net'); +INSERT INTO whoisservers VALUES (3, 'aero','whois.information.aero'); +INSERT INTO whoisservers VALUES (4, 'af','whois.netnames.net'); +INSERT INTO whoisservers VALUES (5, 'ag','whois.nic.ag'); +INSERT INTO whoisservers VALUES (6, 'am','whois.nic.am'); +INSERT INTO whoisservers VALUES (7, 'as','whois.nic.as'); +INSERT INTO whoisservers VALUES (8, 'at','whois.nic.at'); +INSERT INTO whoisservers VALUES (9, 'au','whois.apnic.net'); +INSERT INTO whoisservers VALUES (10, 'biz','whois.nic.biz'); +INSERT INTO whoisservers VALUES (11, 'br','whois.nic.br'); +INSERT INTO whoisservers VALUES (12, 'by','whois.ripe.net'); +INSERT INTO whoisservers VALUES (13, 'bz','mhpwhois1.verisign-grs.net'); +INSERT INTO whoisservers VALUES (14, 'ca','whois.cira.ca'); +INSERT INTO whoisservers VALUES (15, 'cc','whois.nic.cc'); +INSERT INTO whoisservers VALUES (16, 'cd','whois.cd'); +INSERT INTO whoisservers VALUES (17, 'ch','whois.nic.ch'); +INSERT INTO whoisservers VALUES (18, 'cl','whois.nic.cl'); +INSERT INTO whoisservers VALUES (19, 'cn','whois.cnnic.net.cn'); +INSERT INTO whoisservers VALUES (20, 'com','whois.crsnic.net'); +INSERT INTO whoisservers VALUES (21, 'cx','whois.nic.cx'); +INSERT INTO whoisservers VALUES (22, 'cz','whois.nic.cz'); +INSERT INTO whoisservers VALUES (23, 'de','whois.nic.de'); +INSERT INTO whoisservers VALUES (24, 'dk','whois.dk-hostmaster.dk'); +INSERT INTO whoisservers VALUES (25, 'ec','whois.lac.net'); +INSERT INTO whoisservers VALUES (26, 'edu','whois.crsnic.net'); +INSERT INTO whoisservers VALUES (27, 'es','whois.ripe.net'); +INSERT INTO whoisservers VALUES (28, 'fo','whois.ripe.net'); +INSERT INTO whoisservers VALUES (29, 'fr','whois.nic.fr'); +INSERT INTO whoisservers VALUES (30, 'gf','whois.nplus.gf'); +INSERT INTO whoisservers VALUES (31, 'gov','whois.nic.gov'); +INSERT INTO whoisservers VALUES (32, 'gr','whois.ripe.net'); +INSERT INTO whoisservers VALUES (33, 'gs','whois.adamsnames.tc'); +INSERT INTO whoisservers VALUES (34, 'hk','whois.hkdnr.net.hk'); +INSERT INTO whoisservers VALUES (35, 'ie','whois.domainregistry.ie'); +INSERT INTO whoisservers VALUES (36, 'il','whois.isoc.org.il'); +INSERT INTO whoisservers VALUES (37, 'in','whois.iisc.ernet.in'); +INSERT INTO whoisservers VALUES (38, 'info','whois.afilias.net'); +INSERT INTO whoisservers VALUES (39, 'is','whois.isnic.is'); +INSERT INTO whoisservers VALUES (40, 'it','whois.nic.it'); +INSERT INTO whoisservers VALUES (41, 'jp','whois.nic.ad.jp'); +INSERT INTO whoisservers VALUES (42, 'kr','whois.nic.or.kr'); +INSERT INTO whoisservers VALUES (43, 'kz','whois.domain.kz'); +INSERT INTO whoisservers VALUES (44, 'li','whois.nic.il'); +INSERT INTO whoisservers VALUES (45, 'lt','whois.ripe.net'); +INSERT INTO whoisservers VALUES (46, 'lu','whois.dns.lu'); +INSERT INTO whoisservers VALUES (47, 'lv','whois.ripe.net'); +INSERT INTO whoisservers VALUES (48, 'mc','whois.ripe.net'); +INSERT INTO whoisservers VALUES (49, 'mil','whois.internic.net'); +INSERT INTO whoisservers VALUES (50, 'mm','whois.nic.mm'); +INSERT INTO whoisservers VALUES (51, 'ms','whois.adamsnames.tc'); +INSERT INTO whoisservers VALUES (52, 'mx','whois.nic.mx'); +INSERT INTO whoisservers VALUES (53, 'name','whois.nic.name'); +INSERT INTO whoisservers VALUES (54, 'net','whois.crsnic.net'); +INSERT INTO whoisservers VALUES (55, 'nl','whois.domain-registry.nl'); +INSERT INTO whoisservers VALUES (56, 'no','whois.norid.no'); +INSERT INTO whoisservers VALUES (57, 'nu','whois.nic.nu'); +INSERT INTO whoisservers VALUES (58, 'nz','whois.domainz.net.nz'); +INSERT INTO whoisservers VALUES (59, 'org','whois.enom.com'); +INSERT INTO whoisservers VALUES (60, 'pl','whois.dns.pl'); +INSERT INTO whoisservers VALUES (61, 'pro','whois.internic.net'); +INSERT INTO whoisservers VALUES (62, 'pt','whois.ripe.net'); +INSERT INTO whoisservers VALUES (63, 'ro','whois.rotld.ro'); +INSERT INTO whoisservers VALUES (64, 'ru','whois'); +INSERT INTO whoisservers VALUES (65, 'se','whois.nic-se.se'); +INSERT INTO whoisservers VALUES (66, 'sg','whois.nic.net.sg'); +INSERT INTO whoisservers VALUES (67, 'sh','whois.nic.sh'); +INSERT INTO whoisservers VALUES (68, 'si','whois.arnes.si'); +INSERT INTO whoisservers VALUES (69, 'sk','whois.ripe.net'); +INSERT INTO whoisservers VALUES (70, 'st','whois.nic.st'); +INSERT INTO whoisservers VALUES (71, 'tc','whois.adamsnames.tc'); +INSERT INTO whoisservers VALUES (72, 'tf','whois.adamsnames.tc'); +INSERT INTO whoisservers VALUES (73, 'th','whois.thnic.net'); +INSERT INTO whoisservers VALUES (74, 'tj','whois.nic.tj'); +INSERT INTO whoisservers VALUES (75, 'tk','whois.dot.tk'); +INSERT INTO whoisservers VALUES (76, 'tm','whois.nic.tm'); +INSERT INTO whoisservers VALUES (77, 'to','monarch.tonic.to'); +INSERT INTO whoisservers VALUES (78, 'tr','whois.metu.edu.tr'); +INSERT INTO whoisservers VALUES (79, 'tv','whois.internic.net'); +INSERT INTO whoisservers VALUES (80, 'tw','whois.twnic.net'); +INSERT INTO whoisservers VALUES (81, 'ua','whois.net.ua'); +INSERT INTO whoisservers VALUES (82, 'uk','whois.nic.uk'); +INSERT INTO whoisservers VALUES (83, 'us','whois.nic.us'); +INSERT INTO whoisservers VALUES (84, 'vg','whois.adamsnames.tc'); +INSERT INTO whoisservers VALUES (85, 'ws','whois.nic.ws'); Index: publicdnsadmin/docs/whoissrv.postgres.sql diff -u /dev/null publicdnsadmin/docs/whoissrv.postgres.sql:1.1 --- /dev/null Wed Jul 16 07:37:02 2003 +++ publicdnsadmin/docs/whoissrv.postgres.sql Wed Jul 16 07:36:52 2003 @@ -0,0 +1,86 @@ +DELETE FROM whoisservers; +INSERT INTO whoisservers (tld,server) VALUES ('ac','whois.nic.ac'); +INSERT INTO whoisservers (tld,server) VALUES ('ad','whois.ripe.net'); +INSERT INTO whoisservers (tld,server) VALUES ('aero','whois.information.aero'); +INSERT INTO whoisservers (tld,server) VALUES ('af','whois.netnames.net'); +INSERT INTO whoisservers (tld,server) VALUES ('ag','whois.nic.ag'); +INSERT INTO whoisservers (tld,server) VALUES ('am','whois.nic.am'); +INSERT INTO whoisservers (tld,server) VALUES ('as','whois.nic.as'); +INSERT INTO whoisservers (tld,server) VALUES ('at','whois.nic.at'); +INSERT INTO whoisservers (tld,server) VALUES ('au','whois.apnic.net'); +INSERT INTO whoisservers (tld,server) VALUES ('biz','whois.nic.biz'); +INSERT INTO whoisservers (tld,server) VALUES ('br','whois.nic.br'); +INSERT INTO whoisservers (tld,server) VALUES ('by','whois.ripe.net'); +INSERT INTO whoisservers (tld,server) VALUES ('bz','mhpwhois1.verisign-grs.net'); +INSERT INTO whoisservers (tld,server) VALUES ('ca','whois.cira.ca'); +INSERT INTO whoisservers (tld,server) VALUES ('cc','whois.nic.cc'); +INSERT INTO whoisservers (tld,server) VALUES ('cd','whois.cd'); +INSERT INTO whoisservers (tld,server) VALUES ('ch','whois.nic.ch'); +INSERT INTO whoisservers (tld,server) VALUES ('cl','whois.nic.cl'); +INSERT INTO whoisservers (tld,server) VALUES ('cn','whois.cnnic.net.cn'); +INSERT INTO whoisservers (tld,server) VALUES ('com','whois.crsnic.net'); +INSERT INTO whoisservers (tld,server) VALUES ('cx','whois.nic.cx'); +INSERT INTO whoisservers (tld,server) VALUES ('cz','whois.nic.cz'); +INSERT INTO whoisservers (tld,server) VALUES ('de','whois.nic.de'); +INSERT INTO whoisservers (tld,server) VALUES ('dk','whois.dk-hostmaster.dk'); +INSERT INTO whoisservers (tld,server) VALUES ('ec','whois.lac.net'); +INSERT INTO whoisservers (tld,server) VALUES ('edu','whois.crsnic.net'); +INSERT INTO whoisservers (tld,server) VALUES ('es','whois.ripe.net'); +INSERT INTO whoisservers (tld,server) VALUES ('fo','whois.ripe.net'); +INSERT INTO whoisservers (tld,server) VALUES ('fr','whois.nic.fr'); +INSERT INTO whoisservers (tld,server) VALUES ('gf','whois.nplus.gf'); +INSERT INTO whoisservers (tld,server) VALUES ('gov','whois.nic.gov'); +INSERT INTO whoisservers (tld,server) VALUES ('gr','whois.ripe.net'); +INSERT INTO whoisservers (tld,server) VALUES ('gs','whois.adamsnames.tc'); +INSERT INTO whoisservers (tld,server) VALUES ('hk','whois.hkdnr.net.hk'); +INSERT INTO whoisservers (tld,server) VALUES ('ie','whois.domainregistry.ie'); +INSERT INTO whoisservers (tld,server) VALUES ('il','whois.isoc.org.il'); +INSERT INTO whoisservers (tld,server) VALUES ('in','whois.iisc.ernet.in'); +INSERT INTO whoisservers (tld,server) VALUES ('info','whois.afilias.net'); +INSERT INTO whoisservers (tld,server) VALUES ('is','whois.isnic.is'); +INSERT INTO whoisservers (tld,server) VALUES ('it','whois.nic.it'); +INSERT INTO whoisservers (tld,server) VALUES ('jp','whois.nic.ad.jp'); +INSERT INTO whoisservers (tld,server) VALUES ('kr','whois.nic.or.kr'); +INSERT INTO whoisservers (tld,server) VALUES ('kz','whois.domain.kz'); +INSERT INTO whoisservers (tld,server) VALUES ('li','whois.nic.il'); +INSERT INTO whoisservers (tld,server) VALUES ('lt','whois.ripe.net'); +INSERT INTO whoisservers (tld,server) VALUES ('lu','whois.dns.lu'); +INSERT INTO whoisservers (tld,server) VALUES ('lv','whois.ripe.net'); +INSERT INTO whoisservers (tld,server) VALUES ('mc','whois.ripe.net'); +INSERT INTO whoisservers (tld,server) VALUES ('mil','whois.internic.net'); +INSERT INTO whoisservers (tld,server) VALUES ('mm','whois.nic.mm'); +INSERT INTO whoisservers (tld,server) VALUES ('ms','whois.adamsnames.tc'); +INSERT INTO whoisservers (tld,server) VALUES ('mx','whois.nic.mx'); +INSERT INTO whoisservers (tld,server) VALUES ('name','whois.nic.name'); +INSERT INTO whoisservers (tld,server) VALUES ('net','whois.crsnic.net'); +INSERT INTO whoisservers (tld,server) VALUES ('nl','whois.domain-registry.nl'); +INSERT INTO whoisservers (tld,server) VALUES ('no','whois.norid.no'); +INSERT INTO whoisservers (tld,server) VALUES ('nu','whois.nic.nu'); +INSERT INTO whoisservers (tld,server) VALUES ('nz','whois.domainz.net.nz'); +INSERT INTO whoisservers (tld,server) VALUES ('org','whois.enom.com'); +INSERT INTO whoisservers (tld,server) VALUES ('pl','whois.dns.pl'); +INSERT INTO whoisservers (tld,server) VALUES ('pro','whois.internic.net'); +INSERT INTO whoisservers (tld,server) VALUES ('pt','whois.ripe.net'); +INSERT INTO whoisservers (tld,server) VALUES ('ro','whois.rotld.ro'); +INSERT INTO whoisservers (tld,server) VALUES ('ru','whois'); +INSERT INTO whoisservers (tld,server) VALUES ('se','whois.nic-se.se'); +INSERT INTO whoisservers (tld,server) VALUES ('sg','whois.nic.net.sg'); +INSERT INTO whoisservers (tld,server) VALUES ('sh','whois.nic.sh'); +INSERT INTO whoisservers (tld,server) VALUES ('si','whois.arnes.si'); +INSERT INTO whoisservers (tld,server) VALUES ('sk','whois.ripe.net'); +INSERT INTO whoisservers (tld,server) VALUES ('st','whois.nic.st'); +INSERT INTO whoisservers (tld,server) VALUES ('tc','whois.adamsnames.tc'); +INSERT INTO whoisservers (tld,server) VALUES ('tf','whois.adamsnames.tc'); +INSERT INTO whoisservers (tld,server) VALUES ('th','whois.thnic.net'); +INSERT INTO whoisservers (tld,server) VALUES ('tj','whois.nic.tj'); +INSERT INTO whoisservers (tld,server) VALUES ('tk','whois.dot.tk'); +INSERT INTO whoisservers (tld,server) VALUES ('tm','whois.nic.tm'); +INSERT INTO whoisservers (tld,server) VALUES ('to','monarch.tonic.to'); +INSERT INTO whoisservers (tld,server) VALUES ('tr','whois.metu.edu.tr'); +INSERT INTO whoisservers (tld,server) VALUES ('tv','whois.internic.net'); +INSERT INTO whoisservers (tld,server) VALUES ('tw','whois.twnic.net'); +INSERT INTO whoisservers (tld,server) VALUES ('ua','whois.net.ua'); +INSERT INTO whoisservers (tld,server) VALUES ('uk','whois.nic.uk'); +INSERT INTO whoisservers (tld,server) VALUES ('us','whois.nic.us'); +INSERT INTO whoisservers (tld,server) VALUES ('vg','whois.adamsnames.tc'); +INSERT INTO whoisservers (tld,server) VALUES ('ws','whois.nic.ws'); ----------------------- End of diff ----------------------- |