how can I move data configuration from one server CMDBuild to another without data (only configuration)
if you have two CMDBuild instances, used for test and production, and you want to apply to the production instance the structural changes (creating classes, attributes, domains) carried out on the test instance, the best way is to run the SQL commands automatically saved in the log file “cmdbuild_dd_sql.log”.
Of course it is recommended that you first perform a full backup of the database.
CMDBuild Team
Thank you for this way. I'll try it.
will you thinking about tool in system to export-import configuration?
if you have two CMDBuild instances, used for test and production, and you want to apply to the production instance the structural changes (creating classes, attributes, domains) carried out on the test instance, the best way is to run the SQL commands automatically saved in the log file "cmdbuild_dd_sql.log".
Of course it is recommended that you first perform a full backup of the database.
CMDBuild Team
it would surely be a useful tool.
However, it is not expected in the short - medium term because we have many other activities already scheduled in the coming months.
CMDBuild Team
Where is “cmdbuild_dd_sql.log”
I have a cmdbuild install that i am trying to move and i cant seem to get the pgsql dump to load. Keep getting error about syntax and integrers in date fields.
Previously Maxim wrote:
Thank you for this way. I'll try it.will you thinking about tool in system to export-import configuration?Previously Tecnoteca wrote:if you have two CMDBuild instances, used for test and production, and you want to apply to the production instance the structural changes (creating classes, attributes, domains) carried out on the test instance, the best way is to run the SQL commands automatically saved in the log file "cmdbuild_dd_sql.log".
Of course it is recommended that you first perform a full backup of the database.
CMDBuild Team
In the Tomcat logs folder.
CMDBuild Team
Nope. Just host access logs and catalina.out.xx.gz files.
Previously Tecnoteca wrote:
In the Tomcat logs folder.
CMDBuild Team
You can check what’s written in the WEB-INF/conf/log4j.conf file.
CMDBuild Team
log4j.debug=TRUE
log4j.rootLogger=WARN, R
log4j.logger.auth=WARN
log4j.logger.bim=WARN
log4j.logger.cmdbuild=INFO
log4j.logger.ddsql=INFO, DD
log4j.logger.dms=WARN
log4j.logger.email=INFO
log4j.logger.jsonrpc=INFO
log4j.logger.persist=WARN
log4j.logger.rest=WARN
log4j.logger.scheduler=WARN
log4j.logger.soap=WARN
log4j.logger.sql=WARN
log4j.logger.workflow=INFO
log4j.logger.org.springframework.jdbc.core=WARN
log4j.appender.R=org.apache.log4j.RollingFileAppender
log4j.appender.R.File=${catalina.base}/logs/cmdbuild.log
log4j.appender.R.MaxFileSize=100MB
log4j.appender.R.MaxBackupIndex=10
log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R.layout.ConversionPattern=%-5.5p %d{yyyy-MM-dd HH:mm:ss} [%-8c] %m%n
log4j.appender.DD=org.apache.log4j.RollingFileAppender
log4j.appender.DD.File=${catalina.base}/logs/cmdbuild_dd_sql.log
log4j.appender.DD.MaxFileSize=100MB
log4j.appender.DD.MaxBackupIndex=10
log4j.appender.DD.layout=org.apache.log4j.PatternLayout
log4j.appender.DD.layout.ConversionPattern=%-5.5p %d{yyyy-MM-dd HH:mm:ss} [%-8c] %m%n
You can check what's written in the WEB-INF/conf/log4j.conf file.
CMDBuild Team
This topic is quite old.
Can you please tell me where in year 2021 I can find cmdbuild_dd_sql.log, and if I need to put log4j.conf in tomcat logs folder (please confirm is it still true), what contents log4j.conf should have in order to produce cmdbuild_dd_sql.log.
At the moment I don’t have cmdbuild_dd_sql.log in cmdbuild directory tree.
Can someone provide an answer for cmdbuild v3.3?