Germanium Project Plan

Developement for Germanium will be done in sections. This way it will ensure multiple people can design the system and not step on toes. This wiki page will contain the plan for moving forward with the recode of Galimufred into Germanium.

There are two parts I envision for this system;

frontend (lamp)
backend (perl + MyDNS)

Here we will discuss the parts and plan in detail.

Frontend

DB Structure

DNS DB Structure

The DB structure is very important. The DNS record keeping needs to match the schema MyDNS uses. By doing this it allows;

MyDNS server to work natively with Germanium
MyDNS Export will be able to export the DB zones to real zone files

dns_soa

Deprecated: Function split() is deprecated in /home/sourpuss.net/http/www/mirror/wiki.opennicproject.org/actions/table/table.php on line 40

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/sourpuss.net/http/www/mirror/wiki.opennicproject.org/3rdparty/core/safehtml/classes/safehtml.php on line 162

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/sourpuss.net/http/www/mirror/wiki.opennicproject.org/3rdparty/core/safehtml/classes/safehtml.php on line 163

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/sourpuss.net/http/www/mirror/wiki.opennicproject.org/3rdparty/core/safehtml/classes/safehtml.php on line 162

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/sourpuss.net/http/www/mirror/wiki.opennicproject.org/3rdparty/core/safehtml/classes/safehtml.php on line 163

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/sourpuss.net/http/www/mirror/wiki.opennicproject.org/3rdparty/core/safehtml/classes/safehtml.php on line 162

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/sourpuss.net/http/www/mirror/wiki.opennicproject.org/3rdparty/core/safehtml/classes/safehtml.php on line 163

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/sourpuss.net/http/www/mirror/wiki.opennicproject.org/3rdparty/core/safehtml/classes/safehtml.php on line 162

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/sourpuss.net/http/www/mirror/wiki.opennicproject.org/3rdparty/core/safehtml/classes/safehtml.php on line 163

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/sourpuss.net/http/www/mirror/wiki.opennicproject.org/3rdparty/core/safehtml/classes/safehtml.php on line 162

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/sourpuss.net/http/www/mirror/wiki.opennicproject.org/3rdparty/core/safehtml/classes/safehtml.php on line 163

Field	Type	Null	Key	Default	Extra
id	int(10) unsigned	NO	PRI	NULL	auto_increment
userid	int(11) unsigned	NO		NULL
nsset	varchar(255)	NO		NULL
expiredate	int(11) unsigned	NO		NULL
period	int(11) unsigned	NO		NULL
origin	varchar(255)	NO	UNI	NULL
ns	varchar(255)	NO		NULL
mbox	varchar(255)	NO		1
serial	int(11) unsigned	NO		NULL
refresh	int(11) unsigned	NO		28800
retry	int(11) unsigned	NO		7200
expire	int(11) unsigned	NO		604800
minimum	int(11) unsigned	NO		86400
ttl	int(11) unsigned	NO		86400
active	enum('N','Y')	NO	MUL	NULL

dns_rr

Field	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI	NULL	auto_increment
zone	int(11) unsigned	NO	MUL	NULL
type	varchar(64)	YES		enum('A','AAAA','ALIAS','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT')
data	varchar(255)	NO		NULL
aux	int(11) unsigned	NO		0
ttl	int(11) unsigned	NO		86400
active	enum('N','Y')	NO		Y
stamp	timestamp	NO		CURRENT_TIMESTAMP
serial	int(10) unsigned	YES		NULL

dns_nsset

Field	Type	Null	Key	Default	Extra
id	int(10) unsigned	NO	PRI	NULL	auto_increment
userid	int(11) unsigned	NO		NULL
nsset	varchar(255)	NO	UNI	NULL
ns1ip	varchar(255)	NO		NULL
ns2ip	varchar(255)	NO		NULL
ns3ip	varchar(255)	NO		NULL
ns4ip	varchar(255)	NO		NULL
cid	varchar(255)	NO		NULL

UI

CategoryArchitecture

OpenNIC Wiki : germaniumplan

Revision [2365]

Germanium Project Plan

Frontend

DB Structure

DNS DB Structure

UI