Mauro,<br><br>It was worthy trying adding the quotes ahahah. Anyway, the variable was not exported. I'm not sure if I missed that part of exporting this variable or it was missing from the migration instructions. So I did export the variable and the db-migration runned smooth, no errors. Now I'll try to use it and see if everything runs fine.<br>
<br>Tue Sep 04 13:45:28 BRT 2012: Building zone paths <br>Tue Sep 04 13:45:28 BRT 2012: Reading zone files<br>Tue Sep 04 16:45:29 UTC 2012:204 zones read<br>Tue Sep 04 16:45:29 UTC 2012: reading key files<br>Tue Sep 04 16:45:31 UTC 2012: Saving to database<br>
Tue Sep 04 16:45:31 UTC 2012: Done migrating 204 zones<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>
<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>Francisco,<br>
<br>
Quotes are not necessary on xfrd.properties.<br>
<br>
It seems that db-migration is parsing another configuration file.
Is DNSSHIM_HOME environment variable exported ?<div><div class="h5"><br>
<br>
<br>
<br>
On 09/04/2012 11:35 AM, Francisco Barretto wrote:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">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><br>
<br>
On 09/03/2012 05:43 PM, Francisco Barretto wrote:<br>
</div>
</div>
</div>
<div>
<div>
<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>
</blockquote>
<br>
</div></div></div>
</blockquote></div><br>