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
This table is used to store DNS SOA information. The userid field links the domain to a user. The nsset field links the domain to its nsset in the dns_nsset table. The fields in this table that need to be preserved for MyDNS are; origin, ns, mbox, serial, refresh, retry, expire, minimum, ttl, active
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
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(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
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 | 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
