[Pdns-users] Project back-end admin for powerdns

[Sean Boran]

Hi,

I gave it a quick go and it imported many domains. *Good work*!
But failed on one:

Importing ivymobile.org ....
rake aborted!
You have a nil object when you didn't expect it!
The error occurred while evaluating nil.update_serial!

It then aborted (would have been better if it kepts trying to do other
domains?)

The domain entry to be imported for the above one is:
mysql> select * from domains where name="ivymobile.org";
+----+---------------+--------------+------------+-------+-----------------+----------+
| id | name          | master       | last_check | type  | notified_serial |
account  |
+----+---------------+--------------+------------+-------+-----------------+----------+
| 40 | ivymobile.org | 193.5.238.14 |       NULL | SLAVE |      1240464779 |
internal |
+----+---------------+--------------+------------+-------+-----------------+----------+

The imported entry is:
mysql> select * from pdns3.domains where name="ivymobile.org";
+----+---------------+--------+------------+--------+-----------------+---------+-------+---------------------+---------------------+---------+-------+
| id | name          | master | last_check | type   | notified_serial |
account | ttl   | created_at          | updated_at          | user_id |
notes |
+----+---------------+--------+------------+--------+-----------------+---------+-------+---------------------+---------------------+---------+-------+
| 30 | ivymobile.org | NULL   |       NULL | NATIVE |            NULL |
NULL    | 86400 | 2009-04-23 07:26:18 | 2009-04-23 07:26:18 |    NULL |
NULL  |
+----+---------------+--------+------------+--------+-----------------+---------+-------+---------------------+---------------------+---------+-------+


Why has it an issue with the serial? It is the Last_check that is causing
the problem?

Where does one see the last check and serial in the GUI? Under SOA I see
primary, contact, refresh, retry, expire, minimum?

Regards,

Sean



2009/4/22 Kenneth Kalmer <kenneth.kalmer at gmail.com>

> On Wed, Apr 22, 2009 at 5:12 PM, Julian Pawlowski <lists at propenguin.net>wrote:
>
>>
>> > Now I'd like to:
>> > - Migrate a live pdns DB to adapt its structure so that it has the
>> > fields/tables needed by powerdns-on-rails.
>> >
>> > ...
>> >
>> > I thought it might be just something like
>> >     rake db:migrate RAILS_ENV="production"
>> > but that tries to create tables, not update them.
>>
>> I'm currently also facing these thoughts and I just asked a ruby-guru
>> friend to give me some input here :-)
>> I will let you know as soon as there are any news to this.
>>
>
> Great you guys!
>
> My apologies for only replying now, my DSL at home is busted, so this is
> from the office.
>
> There is a migration tool built into PowerDNS on Rails. It is very rough,
> but I've used it on our production servers initially to import about 15,000
> zones. Below is the steps to get it going, I'd appreciate any feedback you
> guys have on this.
>
> Requirements for migration:
>
> 1. Empty (new) database for powerdns-on-rails to use.
> 2. Correctly configured database.yml file for the "target database"
> 3. Fully migrate the target database using "rake db:migrate"
> 4. Seed the fresh database, to get an admin user: "rake db:seed"
>
> When this is done and ready, you'll run the following:
>
> $ rake migrate:powerdns
>
> It will prompt you for the details of the source database, which you can
> enter and then let the script run. I've had some feedback before on possible
> PostgreSQL issues (in Lighthouse). I've done my best to resolve them.
>
> Please let the feedback stream in, and thanks for trying it!
>
> Best
>
>
> --
> Kenneth Kalmer
> kenneth.kalmer at gmail.com
> http://opensourcery.co.za
> @kennethkalmer
>
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> http://mailman.powerdns.com/mailman/listinfo/pdns-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20090423/b904cb45/attachment-0001.html>