Hi Mauro!<br><br>Thanks for you answer. Here is what my xfrd.properties looks like:<br><br>database_dialect=org.hibernate.dialect.MySQL5InnoDBDialect<br>database_driver_class=com.mysql.jdbc.Driver<br>database_host=localhost<br>
database_name='dns' (already tried with and without quotes)<br>database_password='******' (already tried with and without quotes)<br>database_port=3306<br>database_username='root' (already tried with and without quotes)<br>
database_vendor=mysql<br><br>I've kept the folder hierarchies found on compressed file. I mean these files/folders are at the same level:<br>ChangeLog dnsshim-signer.jar lib README.txt<br>
CreateZoneDirs.sh dnsshim-xfrd.jar log4j-signer.properties SlaveSync.sh<br>db-migration.jar doc log4j-xfrd.properties<br><br><br><br><br clear="all">Francisco Barretto<br>Doutorando PPG-Arte - Arte e Tecnologia<br>
<br>Laboratório de Pesquisa em Arte Computacional (Midialab)<br>Departamento de Artes Visuais<br>Instituto de Artes<br>Universidade de Brasília - UnB<br>Campus Universitário Darcy Ribeiro<br>Asa Norte<br>70910-900, Brasília - DF<br>
<br><a href="http://www.ciurbi.wordpress.com" target="_blank">www.ciurbi.wordpress.com</a><br><a href="http://www.wikinarua.com" target="_blank">www.wikinarua.com</a><br><a href="http://www.tectecbaratinha.wordpress.com" target="_blank">www.tectecbaratinha.wordpress.com</a><br>
<a href="http://www.flickr.com/photos/meiotijolo" target="_blank">www.flickr.com/photos/meiotijolo</a><br>
<br><br><div class="gmail_quote">2012/9/4 Mauro Romano Trajber <span dir="ltr"><<a href="mailto:mauro@registro.br" target="_blank">mauro@registro.br</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hi Francisco,<br>
<br>
Can I see your xfrd.properties entries that start with "database_"
?<br>
<br>
For MySQL as DBMS, the configuration must be something like that:<br>
<br>
database_dialect=org.hibernate.dialect.MySQL5InnoDBDialect<br>
database_driver_class=com.mysql.jdbc.Driver<br>
database_host=<your mysql host><br>
database_name=dnsshim<br>
database_password=<your password><br>
database_port=3306<br>
database_username=<database username><br>
database_vendor=mysql<br>
<br>
<br>
PS: db-migration utility, like xfrd and signer, must be executed
at the same level of directory lib/, that contains all library
dependencies.<div><div class="h5"><br>
<br>
On 09/03/2012 05:43 PM, Francisco Barretto wrote:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">Hi There!<br>
<br>
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:<br>
<br>
<a href="mailto:root@nsmasterdev:/etc/dnsshim-2.0#" target="_blank">root@nsmasterdev:/etc/dnsshim-2.0#</a> java -jar db-migration.jar <br>
log4j:WARN No appenders could be found for logger
(br.registro.dnsshim.xfrd.dao.filesystem.XfrdConfigDao).<br>
log4j:WARN Please initialize the log4j system properly.<br>
Sep 3, 2012 5:36:19 PM org.hibernate.annotations.common.Version
<clinit><br>
INFO: Hibernate Commons Annotations 3.2.0.Final<br>
Sep 3, 2012 5:36:19 PM org.hibernate.cfg.Environment
<clinit><br>
INFO: Hibernate 3.6.6.Final<br>
Sep 3, 2012 5:36:19 PM org.hibernate.cfg.Environment
<clinit><br>
<b>INFO: hibernate.properties not found</b><br>
Sep 3, 2012 5:36:19 PM org.hibernate.cfg.Environment
buildBytecodeProvider<br>
INFO: Bytecode provider name : javassist<br>
Sep 3, 2012 5:36:19 PM org.hibernate.cfg.Environment
<clinit><br>
INFO: using JDK 1.4 java.sql.Timestamp handling<br>
Sep 3, 2012 5:36:19 PM org.hibernate.ejb.Version <clinit><br>
INFO: Hibernate EntityManager 3.6.6.Final<br>
Sep 3, 2012 5:36:20 PM org.hibernate.cfg.AnnotationBinder
bindClass<br>
INFO: Binding entity from annotated class:
br.registro.dnsshim.xfrd.domain.TsigKeyInfo<br>
Sep 3, 2012 5:36:20 PM org.hibernate.cfg.annotations.EntityBinder
bindTable<br>
INFO: Bind entity br.registro.dnsshim.xfrd.domain.TsigKeyInfo on
table tsig<br>
Sep 3, 2012 5:36:20 PM org.hibernate.cfg.AnnotationBinder
bindClass<br>
INFO: Binding entity from annotated class:
br.registro.dnsshim.xfrd.domain.User<br>
Sep 3, 2012 5:36:20 PM org.hibernate.cfg.annotations.EntityBinder
bindTable<br>
INFO: Bind entity br.registro.dnsshim.xfrd.domain.User on table
user<br>
Sep 3, 2012 5:36:20 PM org.hibernate.cfg.AnnotationBinder
bindClass<br>
INFO: Binding entity from annotated class:
br.registro.dnsshim.xfrd.domain.DnskeyInfo<br>
Sep 3, 2012 5:36:20 PM org.hibernate.cfg.annotations.EntityBinder
bindTable<br>
INFO: Bind entity br.registro.dnsshim.xfrd.domain.DnskeyInfo on
table dnskey<br>
Sep 3, 2012 5:36:20 PM org.hibernate.cfg.AnnotationBinder
bindClass<br>
INFO: Binding entity from annotated class:
br.registro.dnsshim.xfrd.domain.ZoneInfo<br>
Sep 3, 2012 5:36:20 PM org.hibernate.cfg.annotations.EntityBinder
bindTable<br>
INFO: Bind entity br.registro.dnsshim.xfrd.domain.ZoneInfo on
table zone<br>
Sep 3, 2012 5:36:20 PM org.hibernate.cfg.AnnotationBinder
bindClass<br>
INFO: Binding entity from annotated class:
br.registro.dnsshim.xfrd.domain.SlaveGroup<br>
Sep 3, 2012 5:36:20 PM org.hibernate.cfg.annotations.EntityBinder
bindTable<br>
INFO: Bind entity br.registro.dnsshim.xfrd.domain.SlaveGroup on
table slavegroup<br>
Sep 3, 2012 5:36:20 PM org.hibernate.cfg.AnnotationBinder
bindClass<br>
INFO: Binding entity from annotated class:
br.registro.dnsshim.xfrd.domain.Slave<br>
Sep 3, 2012 5:36:20 PM org.hibernate.cfg.annotations.EntityBinder
bindTable<br>
INFO: Bind entity br.registro.dnsshim.xfrd.domain.Slave on table
slave<br>
Sep 3, 2012 5:36:20 PM org.hibernate.cfg.AnnotationBinder
bindClass<br>
INFO: Binding entity from annotated class:
br.registro.dnsshim.xfrd.domain.ZoneSync<br>
Sep 3, 2012 5:36:20 PM org.hibernate.cfg.annotations.EntityBinder
bindTable<br>
INFO: Bind entity br.registro.dnsshim.xfrd.domain.ZoneSync on
table zone_sync<br>
Sep 3, 2012 5:36:20 PM
org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass<br>
INFO: Mapping collection:
br.registro.dnsshim.xfrd.domain.Slave.tsigKeys -> tsig<br>
Sep 3, 2012 5:36:20 PM
org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass<br>
INFO: Mapping collection:
br.registro.dnsshim.xfrd.domain.ZoneInfo.keys -> dnskey<br>
Sep 3, 2012 5:36:20 PM
org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass<br>
INFO: Mapping collection:
br.registro.dnsshim.xfrd.domain.SlaveGroup.syncZones ->
zone_sync<br>
Sep 3, 2012 5:36:20 PM org.hibernate.cfg.Configuration
applyHibernateValidatorLegacyConstraintsOnDDL<br>
INFO: Hibernate Validator not found: ignoring<br>
Sep 3, 2012 5:36:20 PM
org.hibernate.cfg.search.HibernateSearchEventListenerRegister
enableHibernateSearch<br>
INFO: Unable to find
org.hibernate.search.event.FullTextIndexEventListener on the
classpath. Hibernate Search is not enabled.<br>
Sep 3, 2012 5:36:20 PM
org.hibernate.connection.ConnectionProviderFactory
initializeConnectionProviderFromConfig<br>
INFO: Initializing connection provider:
org.hibernate.connection.C3P0ConnectionProvider<br>
Sep 3, 2012 5:36:20 PM
org.hibernate.connection.C3P0ConnectionProvider configure<br>
<b>INFO: C3P0 using driver: at URL: jdbc:://:/</b><br>
Sep 3, 2012 5:36:20 PM
org.hibernate.connection.C3P0ConnectionProvider configure<br>
<b>INFO: Connection properties: {user=, password=****,
autocommit=true, release_mode=auto}</b><br>
Sep 3, 2012 5:36:20 PM
org.hibernate.connection.C3P0ConnectionProvider configure<br>
INFO: autocommit mode: true<br>
Sep 3, 2012 5:36:20 PM
org.hibernate.connection.C3P0ConnectionProvider configure<br>
<b>SEVERE: JDBC Driver class not found: <br>
java.lang.ClassNotFoundException: </b><br>
at java.lang.Class.forName0(Native Method)<br>
at java.lang.Class.forName(Class.java:186)<br>
at
org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:192)<br>
at
org.hibernate.connection.C3P0ConnectionProvider.configure(C3P0ConnectionProvider.java:118)<br>
at
org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:143)<br>
at
org.hibernate.ejb.InjectionSettingsFactory.createConnectionProvider(InjectionSettingsFactory.java:51)<br>
at
org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:90)<br>
at
org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)<br>
at
org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)<br>
at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)<br>
at
org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:906)<br>
at
org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:57)<br>
at
javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63)<br>
at
br.registro.dnsshim.util.DatabaseUtil.getInstance(DatabaseUtil.java:23)<br>
at
br.registro.dnsshim.xfrd.migration.DbMigration.main(DbMigration.java:15)<br>
Exception in thread "main" javax.persistence.PersistenceException:
[PersistenceUnit: dnsshim_db] Unable to build EntityManagerFactory<br>
at
org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:915)<br>
at
org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:57)<br>
at
javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63)<br>
at
br.registro.dnsshim.util.DatabaseUtil.getInstance(DatabaseUtil.java:23)<br>
at
br.registro.dnsshim.xfrd.migration.DbMigration.main(DbMigration.java:15)<br>
Caused by: org.hibernate.HibernateException: JDBC Driver class not
found: <br>
at
org.hibernate.connection.C3P0ConnectionProvider.configure(C3P0ConnectionProvider.java:123)<br>
at
org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:143)<br>
at
org.hibernate.ejb.InjectionSettingsFactory.createConnectionProvider(InjectionSettingsFactory.java:51)<br>
at
org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:90)<br>
at
org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)<br>
at
org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)<br>
at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)<br>
at
org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:906)<br>
... 4 more<br>
Caused by: java.lang.ClassNotFoundException: <br>
at java.lang.Class.forName0(Native Method)<br>
at java.lang.Class.forName(Class.java:186)<br>
at
org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:192)<br>
at
org.hibernate.connection.C3P0ConnectionProvider.configure(C3P0ConnectionProvider.java:118)<br>
... 11 more<br>
<br>
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?<br>
<br>
I'm using<br>
java version "1.6.0_20"<br>
OpenJDK Runtime Environment (IcedTea6 1.9.13)
(6b20-1.9.13-0ubuntu1~10.04.1)<br>
OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode)<br>
<br>
Ubuntu 10.04<br>
<br>
Thanks!<br>
<br clear="all">
Francisco Barretto<br>
Doutorando PPG-Arte - Arte e Tecnologia<br>
<br>
Laboratório de Pesquisa em Arte Computacional (Midialab)<br>
Departamento de Artes Visuais<br>
Instituto de Artes<br>
Universidade de Brasília - UnB<br>
Campus Universitário Darcy Ribeiro<br>
Asa Norte<br>
70910-900, Brasília - DF<br>
<br>
<a href="http://www.ciurbi.wordpress.com" target="_blank">www.ciurbi.wordpress.com</a><br>
<a href="http://www.wikinarua.com" target="_blank">www.wikinarua.com</a><br>
<a href="http://www.tectecbaratinha.wordpress.com" target="_blank">www.tectecbaratinha.wordpress.com</a><br>
<a href="http://www.flickr.com/photos/meiotijolo" target="_blank">www.flickr.com/photos/meiotijolo</a><br>
</blockquote>
<br>
</div></div></div>
</blockquote></div><br>