Changing Amahi's DNS
Posted: Thu Jan 15, 2009 1:24 pm
Hey guys,
since I had troubles with using amahi's default external dns (opendns) I decided to change that.
Thanks to cpg who said that the option is only changeable in the database itself and GeraldW who told me the mysql pw
Okay let's start!
greets from austria
since I had troubles with using amahi's default external dns (opendns) I decided to change that.
Thanks to cpg who said that the option is only changeable in the database itself and GeraldW who told me the mysql pw
Okay let's start!
- of course ssh as root into your hda
Code: Select all
ssh root@hda
- Before we make any changes to the database it's better to shutdown the hda
Code: Select all
hdactl stop
- Let's enter the database
Note: -p is password (pw for amahi's mysql db is hda) and demo_development is amahi's database
Code: Select all
mysql -p hda demo_development
- If everything was successfull you should now see a mysql prompt
awaiting your commands..
Code: Select all
mysql>
- let us see our current settings
as a response you should receive something like this:
Code: Select all
select * from settings;
Code: Select all
+----+---------------+------------------------------------------+ | id | name | value | +----+---------------+------------------------------------------+ | 2 | domain | yourdomain.com | | 3 | nick | yournick | | 4 | net | 192.168.1 | | 5 | netmask | 255.255.255.0 | | 6 | gateway | 1 | | 7 | api-key | yourapikeyhere | | 8 | external-dns1 | opendnsip1 | | 9 | external-dns2 | opendnsip2 | | 10 | self-address | 2 | | 11 | theme | 2 | +----+---------------+------------------------------------------+
- Okay now comes the funpart
if everything worked well you should see something like that:
Code: Select all
update settings set value='your new dns1 ip here' where value='the opendnsip1 from the database';
obviously you need to do the same thing for external-dns2..Code: Select all
Query OK, 1 row affected (0.01 sec) Rows matched: 1 Changed: 1 Warnings: 0
- When done press CTRL+D
- let's start hda again
Code: Select all
hdactl start
greets from austria