Hi,<br><br>I gave it a quick go and it imported many domains. <b>Good work</b>!<br>But failed on one:<br><br><div style="margin-left: 40px;">Importing <a href="http://ivymobile.org">ivymobile.org</a> ....<br>rake aborted!<br>
You have a nil object when you didn't expect it!<br>The error occurred while evaluating nil.update_serial!<br></div><br>It then aborted (would have been better if it kepts trying to do other domains?)<br><br>The domain entry to be imported for the above one is:<br>
<div style="margin-left: 40px;">mysql> select * from domains where name="<a href="http://ivymobile.org">ivymobile.org</a>";<br>+----+---------------+--------------+------------+-------+-----------------+----------+<br>
| id | name | master | last_check | type | notified_serial | account |<br>+----+---------------+--------------+------------+-------+-----------------+----------+<br>| 40 | <a href="http://ivymobile.org">ivymobile.org</a> | 193.5.238.14 | NULL | SLAVE | 1240464779 | internal |<br>
+----+---------------+--------------+------------+-------+-----------------+----------+<br><br></div>The imported entry is:<br><div style="margin-left: 40px;">mysql> select * from pdns3.domains where name="<a href="http://ivymobile.org">ivymobile.org</a>";<br>
+----+---------------+--------+------------+--------+-----------------+---------+-------+---------------------+---------------------+---------+-------+<br>| id | name | master | last_check | type | notified_serial | account | ttl | created_at | updated_at | user_id | notes |<br>
+----+---------------+--------+------------+--------+-----------------+---------+-------+---------------------+---------------------+---------+-------+<br>| 30 | <a href="http://ivymobile.org">ivymobile.org</a> | NULL | NULL | NATIVE | NULL | NULL | 86400 | 2009-04-23 07:26:18 | 2009-04-23 07:26:18 | NULL | NULL |<br>
+----+---------------+--------+------------+--------+-----------------+---------+-------+---------------------+---------------------+---------+-------+<br><br></div><div style="margin-left: 40px;"><br></div>Why has it an issue with the serial? It is the Last_check that is causing the problem?<br>
<br>Where does one see the last check and serial in the GUI? Under SOA I see primary, contact, refresh, retry, expire, minimum?<br><br>Regards,<br><br>Sean<br><br><br><br><div class="gmail_quote">2009/4/22 Kenneth Kalmer <span dir="ltr"><<a href="mailto:kenneth.kalmer@gmail.com">kenneth.kalmer@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im"><div class="gmail_quote">On Wed, Apr 22, 2009 at 5:12 PM, Julian Pawlowski <span dir="ltr"><<a href="mailto:lists@propenguin.net" target="_blank">lists@propenguin.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><br>
> Now I'd like to:<br>
> - Migrate a live pdns DB to adapt its structure so that it has the<br>
> fields/tables needed by powerdns-on-rails.<br>
><br>
</div>> ...<br>
<div>><br>
> I thought it might be just something like<br>
> rake db:migrate RAILS_ENV="production"<br>
> but that tries to create tables, not update them.<br>
<br>
</div>I'm currently also facing these thoughts and I just asked a ruby-guru<br>
friend to give me some input here :-)<br>
I will let you know as soon as there are any news to this.<br></blockquote></div><br></div>Great you guys!<br><br>My apologies for only replying now, my DSL at home is busted, so this is from the office.<br><br>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.<br>
<br>Requirements for migration:<br><br>1. Empty (new) database for powerdns-on-rails to use.<br>2. Correctly configured database.yml file for the "target database"<br>3. Fully migrate the target database using "rake db:migrate"<br>
4. Seed the fresh database, to get an admin user: "rake db:seed"<br><br clear="all">When this is done and ready, you'll run the following:<br><br>$ rake migrate:powerdns<br><br>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.<br>
<br>Please let the feedback stream in, and thanks for trying it!<br><br>Best<div><div></div><div class="h5"><br><br>-- <br>Kenneth Kalmer<br><a href="mailto:kenneth.kalmer@gmail.com" target="_blank">kenneth.kalmer@gmail.com</a><br>
<a href="http://opensourcery.co.za" target="_blank">http://opensourcery.co.za</a><br>
@kennethkalmer<br>
</div></div><br>_______________________________________________<br>
Pdns-users mailing list<br>
<a href="mailto:Pdns-users@mailman.powerdns.com">Pdns-users@mailman.powerdns.com</a><br>
<a href="http://mailman.powerdns.com/mailman/listinfo/pdns-users" target="_blank">http://mailman.powerdns.com/mailman/listinfo/pdns-users</a><br>
<br></blockquote></div><br>