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 <[email protected]> > On Wed, Apr 22, 2009 at 5:12 PM, Julian Pawlowski <[email protected]>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 > [email protected] > http://opensourcery.co.za > @kennethkalmer > > _______________________________________________ > Pdns-users mailing list > [email protected] > http://mailman.powerdns.com/mailman/listinfo/pdns-users > >
_______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
