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
![Laughing :lol:](./images/smilies/icon_lol.gif)
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