? db.* files to hosts file converstion

[Steven Wang]

Hi,

Questions:
1) Is there a program or script to convert db.DOMAIN and db.NET files
to hosts file?
2) Is there a database system adds/deletes records in a relational
database system? Are there programs or scripts to generate db.DOMAIN,
db.NET and hosts files from this database system?

Background:
I have written a Perl-based frond end user interface called ip to
a) retrieves and locks a revision of RFC 952 based file from RCS.
b) updates this file based on addition or deletion request.
c) stores new revision and unlocks this file into RCS.
d) data flow:
user -> ip -> RCS file -> htable -> hosts file -> h2n -> db.* files
But now our companys asks me to investigate what it takes to directly
updates db.* files and generates hosts file from it. (reversing the
data flow: user -> <a program> -> db.* files -> <a program> -> hosts file)

Thank you,
Steven Wang
Advanced Micro Devices

Attached is the screen capture of the main menu and 2 examples of the
sub-menus from running the script:

Hello! Steven Wang!

#########################################
## IP Address Administration Main Menu ##
## ##
## If you need assistance, please ##
## contact Steven Wang at x44608 ##
#########################################

(1) IP address addition request
(2) IP address deletion request
(3) Edit files using vi
(4) View files using more
(5) Run make
(6) Run decupdate.sh
(9) Exit

Please enter your choice? [default=9] 1

++++++++++++++++++++++++++++++++++++++++
+ IP Address Addition Request Sub-Menu +
++++++++++++++++++++++++++++++++++++++++

(1) Interactive mode
(2) Batch mode
(9) Return to main menu

Please enter your choice? [default=9]

#########################################
## IP Address Administration Main Menu ##
## ##
## If you need assistance, please ##
## contact Steven Wang at x44608 ##
#########################################

(1) IP address addition request
(2) IP address deletion request
(3) Edit files using vi
(4) View files using more
(5) Run make
(6) Run decupdate.sh
(9) Exit

Please enter your choice? [default=9] 2

========================================
= IP Address Deletion Request Sub-Menu =
========================================

(1) Interactive
(2) Batch with confirmation
(3) Batch without confirmation
(9) Return to main menu

Please enter your choice? [default=9]

[Marion Hakanson]

> From: wa...@mx5.amd.com (Steven Wang)
> . . .

> d) data flow:
> user -> ip -> RCS file -> htable -> hosts file -> h2n -> db.* files
> But now our companys asks me to investigate what it takes to directly
> updates db.* files and generates hosts file from it. (reversing the
> data flow: user -> <a program> -> db.* files -> <a program> -> hosts file)

> . . .

My "dnsparse" package has a "dns2hosts" script which does that. Why
anyone would want to go the other direction is beyond me (:-). But
producing both DNS zone files and hosts files from a real database is
likely a better way to go -- haven't done that yet here.

For dnsparse, see the user-contributed stuff in the BIND distribution,
or get it from "ftp://ftp.cse.ogi.edu/pub/dnsparse-2.1.tar.gz".

Regards,

--
Marion Hakanson <haka...@cse.ogi.edu>
Information Highway Maintenance -- OGI CS&E Division