Wednesday, May 12, 2010

Migrating IPPlan from 4.92a to 6.00BETA2

I performed this for two IP network repositories that I manage and it worked out ok. The paths and such are relative to the FreeBSD platform from which this runs, therefore you may have to tweak if you've made the mistake of using something other than FreeBSD. Some steps, such as step 1, may not be necessary for you, so check your extensions.ini beforehand as you may already have support for gmp.

  1. rebuild php extensions with GNU MP support and enable it in /usr/local/etc/php/extensions.ini
  2. unpack source
  3. cp config.php config.php.orig
  4. patch config.php from patch file in /usr/ports/net-mgmt/ipplan/files/
  5. fix user name, password, db type, and db name in config.php
  6. fix user name, password, db type, and db name in contrib/db-migrate.php
  7. create new ipplanv6 db via phpMyAdmin with same permissions as ipplan db
  8. visit http://site/ipplanv6/admin/install.php, choosing "new installation" and "run the sql now"

    #zlib support compiled into php
    #output to webrowser will be compressed for quicker loading of pages if web browser supports compression
    The database schema was created - you can now create users and groups after loggin in with the admin user specified in the config.php file
    Click here to access the administration page
  9. visit http://site/ipplanv6/contrib/db-migrate.php which will import all data from the ipplan db into the new ipplanv6 db

    Migrating table grp Migrating table users [snip] Migrating table fwdzonerec
  10. via phpMyAdmin, check the ipplanv6.version table and you should see version (or schema) '23'

That's about it. Other than the fiasco with building the GNU MP extension for PHP, which I won't go into here, it was pretty painless and doing it twice helped me clean up these notes which will hopefully help you.

This is a big step forward for IPPlan and I am stoked to see IPv6 support. It's been on my wish list for a *very* long time and while I have contributed patches to the project in the past, I simply didn't have the spare time to do the IPv6 integration. I had been planning to resurrect the old Perl code for FreeIPdb that I worked on with a couple guys from Global Crossing, but now that IPPlan supports IPv6, I think that FreeIPdb will really die (at least for me).

Finally, if you are using IPPlan and it's useful to you and/or your business then *PLEASE* contribute to the project. Thank you!