what you need
apache (default installed)    but we need to run this as unjailed
php /  mysql  / gcc compile

im not going to tell you how to install openBSD

the downside is that you have to run apache unjailed to be able to run the mydns web front end
but persoanl : for some of the stuff i being doing the only was i got it to work was by running it unjailed


to setup openBSD google for an howto there are 100's of them out there

once installed

log in as root

http://www.openbsd.org/ftp.html :: find an LOCAL FTP / http mirror to download to speed up the downloads and check first to see if they got the ver of the OpenBSD are you running listed on there mirror

 

export PKG_PATH=ftp://192.168.1.101/pub/OpenBSD/4.2/packages/i386

pkg_add -v wget-1.10.2p0.tgz jed-0.99.16-no_x11.tgz phpMyAdmin-2.10.1.tgz mysql-server-5.0.45.tgz gcc-4.2.20070307p2.tgz


copy and paste this area into your putty window


cp /usr/local/share/examples/php5/php.ini-recommended /var/www/conf/php.ini
mkdir /var/www/tmp
chown -R www:www /var/www/tmp
chmod -R 0770 /var/www/tmp

/usr/local/sbin/phpxs -s
/usr/local/sbin/phpxs -a gd
/usr/local/sbin/phpxs -a mbstring
/usr/local/sbin/phpxs -a mcrypt
/usr/local/sbin/phpxs -a mysql


mysql_install_db
mysqld_safe&
sleep 2


/usr/local/bin/mysqladmin -u root password zcworld

time to clean out the default stuff thats comes in the htdocs

mv /var/www/htdocs/* /tmp


on next reboot the tmp folder is auto-cleaned
so if u doing something in there like making backups of files and leave them in the tmp folder : BAD MOVE

lets edit the httpd.conf and add in the php lines

jed /var/www/conf/httpd.conf

lets find the directoryindex and add index.php index.htm
and than find the AddType application/x-httpd-php .php


and uncommet
save file and exit

ok
now we got an empty htdocs folder
lets fire up apache first and than move the phpmyadmin over
so we can setup my account for mydns

httpd -u
mv /var/www/phpMyAdmin/ /var/www/htdocs/



and lets edit the config.inc.php file in the phpMyadmin so we can use it


jed /var/www/htdocs/phpMyAdmin/config.inc.php

find line 18
$cfg['blowfish_secret'] = ''

just add something in the middle of the two ''

than save and exit the file
open up your web browser and goto

 

http://<IP/phpMyAdmin



than login with your mysql password
root / zcworld



in the Create new database box type in "mydns" than click on create
copy and paste this into box and click go

CREATE TABLE `rr` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL,
  `sys_groupid` int(11) NOT NULL,
  `sys_perm_user` varchar(5) NOT NULL,
  `sys_perm_group` varchar(5) NOT NULL,
  `sys_perm_other` varchar(5) NOT NULL,
  `zone` int(10) unsigned NOT NULL,
  `name` char(64) NOT NULL,
  `type` enum('A','AAAA','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT') default NULL,
  `data` char(128) NOT NULL,
  `aux` int(10) unsigned NOT NULL,
  `ttl` int(10) unsigned NOT NULL default '86400',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `rr` (`zone`,`name`,`type`,`data`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE `soa` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL,
  `sys_groupid` int(11) NOT NULL,
  `sys_perm_user` varchar(5) NOT NULL,
  `sys_perm_group` varchar(5) NOT NULL,
  `sys_perm_other` varchar(5) NOT NULL,
  `origin` char(255) NOT NULL,
  `ns` char(255) NOT NULL,
  `mbox` char(255) NOT NULL,
  `serial` int(10) unsigned NOT NULL default '1',
  `refresh` int(10) unsigned NOT NULL default '28800',
  `retry` int(10) unsigned NOT NULL default '7200',
  `expire` int(10) unsigned NOT NULL default '604800',
  `minimum` int(10) unsigned NOT NULL default '86400',
  `ttl` int(10) unsigned NOT NULL default '86400',
  `active` enum('Y','N') NOT NULL,
  `xfer` char(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `origin` (`origin`),
  KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE `sys_datalog` (
  `datalog_id` bigint(20) NOT NULL auto_increment,
  `dbtable` varchar(255) NOT NULL default '',
  `dbidx` varchar(255) NOT NULL default '',
  `action` char(1) NOT NULL default '',
  `tstamp` bigint(20) NOT NULL default '0',
  `user` varchar(255) NOT NULL default '',
  `data` text NOT NULL,
  PRIMARY KEY  (`datalog_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE `sys_dbsync` (
  `id` bigint(20) NOT NULL auto_increment,
  `jobname` varchar(255) NOT NULL default '',
  `sync_interval_minutes` int(11) NOT NULL default '0',
  `db_type` varchar(255) NOT NULL default '',
  `db_host` varchar(255) NOT NULL default '',
  `db_name` varchar(255) NOT NULL default '',
  `db_username` varchar(255) NOT NULL default '',
  `db_password` varchar(255) NOT NULL default '',
  `db_tables` varchar(255) NOT NULL default 'admin,forms',
  `empty_datalog` int(11) NOT NULL default '0',
  `sync_datalog_external` int(11) NOT NULL default '0',
  `active` int(11) NOT NULL default '1',
  `last_datalog_id` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `last_datalog_id` (`last_datalog_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE `sys_filesync` (
  `id` bigint(20) NOT NULL auto_increment,
  `jobname` varchar(255) NOT NULL default '',
  `sync_interval_minutes` int(11) NOT NULL default '0',
  `ftp_host` varchar(255) NOT NULL default '',
  `ftp_path` varchar(255) NOT NULL default '',
  `ftp_username` varchar(255) NOT NULL default '',
  `ftp_password` varchar(255) NOT NULL default '',
  `local_path` varchar(255) NOT NULL default '',
  `wput_options` varchar(255) NOT NULL default '--timestamping --reupload --dont-continue',
  `active` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE `sys_group` (
  `groupid` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`groupid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Daten für Tabelle `sys_group`
--
INSERT INTO `sys_group` (`groupid`, `name`, `description`) VALUES
(1, 'admin', 'Administrators group'),
(2, 'user', 'Users Group');
-- --------------------------------------------------------

CREATE TABLE `sys_user` (
  `userid` int(11) NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL default '0',
  `sys_groupid` int(11) NOT NULL default '0',
  `sys_perm_user` varchar(5) NOT NULL default '',
  `sys_perm_group` varchar(5) NOT NULL default '',
  `sys_perm_other` varchar(5) NOT NULL default '',
  `username` varchar(100) NOT NULL default '',
  `passwort` varchar(100) NOT NULL default '',
  `modules` varchar(255) NOT NULL default '',
  `startmodule` varchar(255) NOT NULL default '',
  `app_theme` varchar(100) NOT NULL default 'default',
  `typ` varchar(20) NOT NULL default 'user',
  `active` tinyint(4) NOT NULL default '1',
  `name` varchar(100) NOT NULL default '',
  `vorname` varchar(100) NOT NULL default '',
  `unternehmen` varchar(100) NOT NULL default '',
  `strasse` varchar(100) NOT NULL default '',
  `ort` varchar(100) NOT NULL default '',
  `plz` varchar(10) NOT NULL default '',
  `land` varchar(50) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `telefon` varchar(100) NOT NULL default '',
  `fax` varchar(100) NOT NULL default '',
  `language` varchar(10) NOT NULL default 'de',
  `groups` varchar(255) NOT NULL default '',
  `default_group` int(11) NOT NULL default '0',
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

INSERT INTO `sys_user` (`userid`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `username`, `passwort`, `modules`, `startmodule`, `app_theme`, `typ`, `active`, `name`, `vorname`, `unternehmen`, `strasse`, `ort`, `plz`, `land`, `email`, `url`, `telefon`, `fax`, `language`, `groups`, `default_group`) VALUES
(1, 1, 0, 'riud', 'riud', '', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin,dns', 'dns', 'grey', 'admin', 1, '', 'Administrator', '', '', '', '', '', '', '', '', '', 'en', '1,2', 0);

than click on the Server: localhost
than Privileges -> add a new user

username "mydns"
password "Woot-igotmydns"
retype "Woot-igotmydns"


than click on ok

than find half way down "Database-specific privileges" and pick from the list "mydns"

than click on check all than ok
thats gives the mydns user access rights to mydns database




back to your putty window

cd /root
mkdir build
cd build

wget http://mydns.bboy.net/download/mydns-1.1.0.tar.gz
tar -zxf mydns-1.1.0.tar.gz
cd mydns-1.1.0
./configure
make
make
make install
make conf









please note that you have an error dueing the make / compiling of it
but its all good


while the system compiles the code for the MyDNS services lets get the web front end and setup that up

open up an second putty window
log in as root
than

cd /var/www/
wget http://prdownloads.sourceforge.net/mydnsconfig/MyDNSConfig-1.1.0.tar.gz?download
tar -zxf MyDNSConfig-1.1.0.tar.gz
mv MyDNSConfig-1.1.0/interface htdocs/mydns



time to edit the mydns front end

jed /var/www/htdocs/mydns/lib/config.inc.php
find line 36
$conf["rootpath"] put in /var/www/htdocs/mydns

line 51
the username / password for mysql




in your web browser http://<IP>/mydns/
you will know if you got it to work
because you got an login box

default username / password
admin/admin

last step to do before your myDNS is online and ready for your use
/ to make it work

you got the backend half setup

now you gotta to tell mydns to look at mydns database with username / password we setup for it to make it work


jed /etc/mydns.conf


on lines
11 username : mydns
12 password : Woot-igotmydns
34 log : /var/log/mydns

save the file
and than

mydns -b


to run mydns as an background service


to start it on boot
we add to the

jed /etc/rc.local file

echo -n 'mysql'
/usr/local/bin/mysqld_safe &
sleep 2

echo -n 'starting mydns'
/usr/local/sbin/mydns -b


PLEASE NOTE
DO NOT LEAVE THE SQL ADMIN OR THE MYDNS ADMIN PAGES IN THE ROOT DOCUMENT FOLDER
BEST TO MAKE AN VHOST AND PUT THEM IN THERE SO YOU LOCK DOWN THE ACCESS TO THEM VIA IP ADDDRESS
OF YOUR OWN PC SO YOU CAN HAVE CONTROL ONLY



to use your DNS server
in windows
Control Panel - Network Connections - Local Area Connection -> Properties  -> TCP/IP -> Propertis ->
use the following DNS servers Addresses :
Prefeerred DNS Server : IP of your MyDNS Box
Alternate DNS Server : IP DNS Server Address Here : so ur Internet Works  : when not looking for your privte DNS Servers


start -> run -> cmd
ipconfig /flushdns



in mydns frontend
login and add an domain
than try to ping it / dig @localhost  

Click the Home Tab to go back to the Homepage



THis Page is powered by Dolphin Tabs Menu- by JavaScript Kit

 

if you want to see any howto or want to email me an thanks
or ask to use work on any website or anything else
email me here>> Email Me <<

remove the -SPAM-FREE-Zone part out of the address