[DNSSHIM] Migration from version 1.x
Mauro Romano Trajber
mauro at registro.br
Tue Sep 4 13:40:14 BRT 2012
Francisco,
Quotes are not necessary on xfrd.properties.
It seems that db-migration is parsing another configuration file. Is
DNSSHIM_HOME environment variable exported ?
On 09/04/2012 11:35 AM, Francisco Barretto wrote:
> Hi Mauro!
>
> Thanks for you answer. Here is what my xfrd.properties looks like:
>
> database_dialect=org.hibernate.dialect.MySQL5InnoDBDialect
> database_driver_class=com.mysql.jdbc.Driver
> database_host=localhost
> database_name='dns' (already tried with and without quotes)
> database_password='******' (already tried with and without quotes)
> database_port=3306
> database_username='root' (already tried with and without quotes)
> database_vendor=mysql
>
> I've kept the folder hierarchies found on compressed file. I mean
> these files/folders are at the same level:
> ChangeLog dnsshim-signer.jar lib README.txt
> CreateZoneDirs.sh dnsshim-xfrd.jar log4j-signer.properties
> SlaveSync.sh
> db-migration.jar doc log4j-xfrd.properties
>
>
>
>
> Francisco Barretto
> Doutorando PPG-Arte - Arte e Tecnologia
>
> Laboratório de Pesquisa em Arte Computacional (Midialab)
> Departamento de Artes Visuais
> Instituto de Artes
> Universidade de Brasília - UnB
> Campus Universitário Darcy Ribeiro
> Asa Norte
> 70910-900, Brasília - DF
>
> www.ciurbi.wordpress.com <http://www.ciurbi.wordpress.com>
> www.wikinarua.com <http://www.wikinarua.com>
> www.tectecbaratinha.wordpress.com
> <http://www.tectecbaratinha.wordpress.com>
> www.flickr.com/photos/meiotijolo <http://www.flickr.com/photos/meiotijolo>
>
>
> 2012/9/4 Mauro Romano Trajber <mauro at registro.br
> <mailto:mauro at registro.br>>
>
> Hi Francisco,
>
> Can I see your xfrd.properties entries that start with "database_" ?
>
> For MySQL as DBMS, the configuration must be something like that:
>
> database_dialect=org.hibernate.dialect.MySQL5InnoDBDialect
> database_driver_class=com.mysql.jdbc.Driver
> database_host=<your mysql host>
> database_name=dnsshim
> database_password=<your password>
> database_port=3306
> database_username=<database username>
> database_vendor=mysql
>
>
> PS: db-migration utility, like xfrd and signer, must be executed
> at the same level of directory lib/, that contains all library
> dependencies.
>
>
> On 09/03/2012 05:43 PM, Francisco Barretto wrote:
>> Hi There!
>>
>> I'm currenlty trying to migrate a DNSSHIM server which is a 1.x
>> version to the latest 2.0. I've installed mysql-server 5.1,
>> edited xfrd.properties and created the database which will be
>> used by the newest dnsshim version but when I try to run
>> db-migration.jar it throws the class not found exception below:
>>
>> root at nsmasterdev:/etc/dnsshim-2.0#
>> <mailto:root at nsmasterdev:/etc/dnsshim-2.0#> java -jar
>> db-migration.jar
>> log4j:WARN No appenders could be found for logger
>> (br.registro.dnsshim.xfrd.dao.filesystem.XfrdConfigDao).
>> log4j:WARN Please initialize the log4j system properly.
>> Sep 3, 2012 5:36:19 PM org.hibernate.annotations.common.Version
>> <clinit>
>> INFO: Hibernate Commons Annotations 3.2.0.Final
>> Sep 3, 2012 5:36:19 PM org.hibernate.cfg.Environment <clinit>
>> INFO: Hibernate 3.6.6.Final
>> Sep 3, 2012 5:36:19 PM org.hibernate.cfg.Environment <clinit>
>> *INFO: hibernate.properties not found*
>> Sep 3, 2012 5:36:19 PM org.hibernate.cfg.Environment
>> buildBytecodeProvider
>> INFO: Bytecode provider name : javassist
>> Sep 3, 2012 5:36:19 PM org.hibernate.cfg.Environment <clinit>
>> INFO: using JDK 1.4 java.sql.Timestamp handling
>> Sep 3, 2012 5:36:19 PM org.hibernate.ejb.Version <clinit>
>> INFO: Hibernate EntityManager 3.6.6.Final
>> Sep 3, 2012 5:36:20 PM org.hibernate.cfg.AnnotationBinder bindClass
>> INFO: Binding entity from annotated class:
>> br.registro.dnsshim.xfrd.domain.TsigKeyInfo
>> Sep 3, 2012 5:36:20 PM org.hibernate.cfg.annotations.EntityBinder
>> bindTable
>> INFO: Bind entity br.registro.dnsshim.xfrd.domain.TsigKeyInfo on
>> table tsig
>> Sep 3, 2012 5:36:20 PM org.hibernate.cfg.AnnotationBinder bindClass
>> INFO: Binding entity from annotated class:
>> br.registro.dnsshim.xfrd.domain.User
>> Sep 3, 2012 5:36:20 PM org.hibernate.cfg.annotations.EntityBinder
>> bindTable
>> INFO: Bind entity br.registro.dnsshim.xfrd.domain.User on table user
>> Sep 3, 2012 5:36:20 PM org.hibernate.cfg.AnnotationBinder bindClass
>> INFO: Binding entity from annotated class:
>> br.registro.dnsshim.xfrd.domain.DnskeyInfo
>> Sep 3, 2012 5:36:20 PM org.hibernate.cfg.annotations.EntityBinder
>> bindTable
>> INFO: Bind entity br.registro.dnsshim.xfrd.domain.DnskeyInfo on
>> table dnskey
>> Sep 3, 2012 5:36:20 PM org.hibernate.cfg.AnnotationBinder bindClass
>> INFO: Binding entity from annotated class:
>> br.registro.dnsshim.xfrd.domain.ZoneInfo
>> Sep 3, 2012 5:36:20 PM org.hibernate.cfg.annotations.EntityBinder
>> bindTable
>> INFO: Bind entity br.registro.dnsshim.xfrd.domain.ZoneInfo on
>> table zone
>> Sep 3, 2012 5:36:20 PM org.hibernate.cfg.AnnotationBinder bindClass
>> INFO: Binding entity from annotated class:
>> br.registro.dnsshim.xfrd.domain.SlaveGroup
>> Sep 3, 2012 5:36:20 PM org.hibernate.cfg.annotations.EntityBinder
>> bindTable
>> INFO: Bind entity br.registro.dnsshim.xfrd.domain.SlaveGroup on
>> table slavegroup
>> Sep 3, 2012 5:36:20 PM org.hibernate.cfg.AnnotationBinder bindClass
>> INFO: Binding entity from annotated class:
>> br.registro.dnsshim.xfrd.domain.Slave
>> Sep 3, 2012 5:36:20 PM org.hibernate.cfg.annotations.EntityBinder
>> bindTable
>> INFO: Bind entity br.registro.dnsshim.xfrd.domain.Slave on table
>> slave
>> Sep 3, 2012 5:36:20 PM org.hibernate.cfg.AnnotationBinder bindClass
>> INFO: Binding entity from annotated class:
>> br.registro.dnsshim.xfrd.domain.ZoneSync
>> Sep 3, 2012 5:36:20 PM org.hibernate.cfg.annotations.EntityBinder
>> bindTable
>> INFO: Bind entity br.registro.dnsshim.xfrd.domain.ZoneSync on
>> table zone_sync
>> Sep 3, 2012 5:36:20 PM
>> org.hibernate.cfg.annotations.CollectionBinder
>> bindOneToManySecondPass
>> INFO: Mapping collection:
>> br.registro.dnsshim.xfrd.domain.Slave.tsigKeys -> tsig
>> Sep 3, 2012 5:36:20 PM
>> org.hibernate.cfg.annotations.CollectionBinder
>> bindOneToManySecondPass
>> INFO: Mapping collection:
>> br.registro.dnsshim.xfrd.domain.ZoneInfo.keys -> dnskey
>> Sep 3, 2012 5:36:20 PM
>> org.hibernate.cfg.annotations.CollectionBinder
>> bindOneToManySecondPass
>> INFO: Mapping collection:
>> br.registro.dnsshim.xfrd.domain.SlaveGroup.syncZones -> zone_sync
>> Sep 3, 2012 5:36:20 PM org.hibernate.cfg.Configuration
>> applyHibernateValidatorLegacyConstraintsOnDDL
>> INFO: Hibernate Validator not found: ignoring
>> Sep 3, 2012 5:36:20 PM
>> org.hibernate.cfg.search.HibernateSearchEventListenerRegister
>> enableHibernateSearch
>> INFO: Unable to find
>> org.hibernate.search.event.FullTextIndexEventListener on the
>> classpath. Hibernate Search is not enabled.
>> Sep 3, 2012 5:36:20 PM
>> org.hibernate.connection.ConnectionProviderFactory
>> initializeConnectionProviderFromConfig
>> INFO: Initializing connection provider:
>> org.hibernate.connection.C3P0ConnectionProvider
>> Sep 3, 2012 5:36:20 PM
>> org.hibernate.connection.C3P0ConnectionProvider configure
>> *INFO: C3P0 using driver: at URL: jdbc:://:/*
>> Sep 3, 2012 5:36:20 PM
>> org.hibernate.connection.C3P0ConnectionProvider configure
>> *INFO: Connection properties: {user=, password=****,
>> autocommit=true, release_mode=auto}*
>> Sep 3, 2012 5:36:20 PM
>> org.hibernate.connection.C3P0ConnectionProvider configure
>> INFO: autocommit mode: true
>> Sep 3, 2012 5:36:20 PM
>> org.hibernate.connection.C3P0ConnectionProvider configure
>> *SEVERE: JDBC Driver class not found:
>> java.lang.ClassNotFoundException: *
>> at java.lang.Class.forName0(Native Method)
>> at java.lang.Class.forName(Class.java:186)
>> at
>> org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:192)
>> at
>> org.hibernate.connection.C3P0ConnectionProvider.configure(C3P0ConnectionProvider.java:118)
>> at
>> org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:143)
>> at
>> org.hibernate.ejb.InjectionSettingsFactory.createConnectionProvider(InjectionSettingsFactory.java:51)
>> at
>> org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:90)
>> at
>> org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)
>> at
>> org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)
>> at
>> org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)
>> at
>> org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:906)
>> at
>> org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:57)
>> at
>> javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63)
>> at
>> br.registro.dnsshim.util.DatabaseUtil.getInstance(DatabaseUtil.java:23)
>> at
>> br.registro.dnsshim.xfrd.migration.DbMigration.main(DbMigration.java:15)
>> Exception in thread "main"
>> javax.persistence.PersistenceException: [PersistenceUnit:
>> dnsshim_db] Unable to build EntityManagerFactory
>> at
>> org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:915)
>> at
>> org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:57)
>> at
>> javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63)
>> at
>> br.registro.dnsshim.util.DatabaseUtil.getInstance(DatabaseUtil.java:23)
>> at
>> br.registro.dnsshim.xfrd.migration.DbMigration.main(DbMigration.java:15)
>> Caused by: org.hibernate.HibernateException: JDBC Driver class
>> not found:
>> at
>> org.hibernate.connection.C3P0ConnectionProvider.configure(C3P0ConnectionProvider.java:123)
>> at
>> org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:143)
>> at
>> org.hibernate.ejb.InjectionSettingsFactory.createConnectionProvider(InjectionSettingsFactory.java:51)
>> at
>> org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:90)
>> at
>> org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)
>> at
>> org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)
>> at
>> org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)
>> at
>> org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:906)
>> ... 4 more
>> Caused by: java.lang.ClassNotFoundException:
>> at java.lang.Class.forName0(Native Method)
>> at java.lang.Class.forName(Class.java:186)
>> at
>> org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:192)
>> at
>> org.hibernate.connection.C3P0ConnectionProvider.configure(C3P0ConnectionProvider.java:118)
>> ... 11 more
>>
>> I've followed exactly the steps mentioned in the 2.0 english
>> manual (rev 1498), including the xfrd.properties entries order.
>> Is there a more complete tutorial on migration? Is there any
>> relation with the hierarchical folders? Do db-migration.jar need
>> to be in any specific folder? What about the hibernate
>> configuration not found?
>>
>> I'm using
>> java version "1.6.0_20"
>> OpenJDK Runtime Environment (IcedTea6 1.9.13)
>> (6b20-1.9.13-0ubuntu1~10.04.1)
>> OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode)
>>
>> Ubuntu 10.04
>>
>> Thanks!
>>
>> Francisco Barretto
>> Doutorando PPG-Arte - Arte e Tecnologia
>>
>> Laboratório de Pesquisa em Arte Computacional (Midialab)
>> Departamento de Artes Visuais
>> Instituto de Artes
>> Universidade de Brasília - UnB
>> Campus Universitário Darcy Ribeiro
>> Asa Norte
>> 70910-900, Brasília - DF
>>
>> www.ciurbi.wordpress.com <http://www.ciurbi.wordpress.com>
>> www.wikinarua.com <http://www.wikinarua.com>
>> www.tectecbaratinha.wordpress.com
>> <http://www.tectecbaratinha.wordpress.com>
>> www.flickr.com/photos/meiotijolo
>> <http://www.flickr.com/photos/meiotijolo>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://eng.registro.br/pipermail/dnsshim/attachments/20120904/3815a55b/attachment-0001.html>
More information about the DNSSHIM
mailing list