It works fine now, thanks.
Regards.
George Lefter wrote:
Hi,
This was a problem with table name case mismatch, I fixed it now.
I also removed an automatic capitalization of table and column names,
now the names are as listed in the config files.
Because of this, you may notice duplicate tables in the database.
Florent Guillaume wrote:
George, you may have not seen this as it was sent to the wrong list.
Was this part of the fixes this WE ?
Florent
Begin forwarded message:
From: Vincent Dutat <[EMAIL PROTECTED]>
Date: 26 May 2007 21:56:25 GMT+02:00
To: [EMAIL PROTECTED]
Subject: nxsqldirectory tables 'USERS' and 'USERS2GROUP' dropped
every time JBoss is restarted (MySQL used)
nxsqldirectory tables 'USERS' and 'USERS2GROUP' dropped every time
JBoss is restarted. All my databases are in MYSQL. see backtrace
below, searching for column 'password' in lowercase, no found so the
table is dropped and re-created with column in uppercase.
2007-05-26 21:49:30,578 DEBUG
[org.nuxeo.ecm.platform.login.NuxeoLoginModule] NXLoginModule
initialized
2007-05-26 21:49:30,609 INFO [org.hibernate.dialect.Dialect] Using
dialect: org.hibernate.dialect.MySQLDialect
2007-05-26 21:49:30,609 DEBUG
[org.nuxeo.ecm.directory.sql.SQLDirectory] setting up directory
userDirectory
2007-05-26 21:49:30,625 DEBUG
[org.jboss.resource.connectionmanager.IdleRemover]
internalRegisterPool: registering pool with interval 900000 old
interval: 450000
2007-05-26 21:49:30,765 DEBUG
[org.nuxeo.ecm.directory.sql.SQLDirectory] required field: password,
available columns: [PASSWORD, USERNAME, LASTNAME, FIRSTNAME, COMPANY,
EMAIL]
2007-05-26 21:49:30,765 DEBUG
[org.nuxeo.ecm.directory.sql.SQLDirectory] checking if table USERS
exists: true
2007-05-26 21:49:30,765 DEBUG
[org.nuxeo.ecm.directory.sql.SQLDirectory] execute sql: drop table if
exists `USERS`
2007-05-26 21:49:30,765 DEBUG
[org.nuxeo.ecm.directory.sql.SQLDirectory] execute sql: create table
`USERS` (`USERNAME` varchar(255), `PASSWORD` varchar(255), `EMAIL`
varchar(255), `FIRSTNAME` varchar(255), `LASTNAME` varchar(255),
`COMPANY` varchar(255))
2007-05-26 21:49:30,812 DEBUG
[org.nuxeo.ecm.directory.sql.SQLDirectory] loading data file:
users.csv for directory userDirectory
2007-05-26 21:49:30,812 DEBUG
[org.jboss.mx.loading.RepositoryClassLoader] setRepository,
[EMAIL PROTECTED],
[EMAIL PROTECTED]
url=null ,addedOrder=0}
2007-05-26 21:49:30,812 DEBUG
[org.nuxeo.ecm.directory.sql.SQLDirectory] insert statement: insert
into `USERS` (`USERNAME`, `PASSWORD`, `FIRSTNAME`, `LASTNAME`,
`COMPANY`, `EMAIL`) values (?, ?, ?, ?, ?, ?)
2007-05-26 21:49:30,828 DEBUG
[org.nuxeo.ecm.directory.sql.SQLDirectory] creating the table pointed
to by the reference
2007-05-26 21:49:30,828 INFO [org.hibernate.dialect.Dialect] Using
dialect: org.hibernate.dialect.MySQLDialect
2007-05-26 21:49:30,828 DEBUG
[org.nuxeo.ecm.directory.sql.SQLDirectory] setting up directory
groupDirectory
2007-05-26 21:49:30,859 DEBUG
[org.nuxeo.ecm.directory.sql.SQLDirectory] skipping sql setup script,
policy=on_missing_columns and all columns matched
2007-05-26 21:49:30,890 DEBUG
[org.nuxeo.ecm.directory.sql.SQLDirectory] checking if ref table
USER2GROUP exists: true
2007-05-26 21:49:30,890 DEBUG
[org.nuxeo.ecm.directory.sql.SQLDirectory] dropping reference table:
user2group[drop table if exists `USER2GROUP`]
2007-05-26 21:49:30,890 DEBUG
[org.nuxeo.ecm.directory.sql.SQLDirectory] creating reference table:
user2group[create table `USER2GROUP` (`USERID` varchar(255),
`GROUPID` varchar(255))]
2007-05-26 21:49:31,031 DEBUG
[org.nuxeo.ecm.directory.sql.SQLDirectory] loading data file:
user2group.csv for directory userDirectory
2007-05-26 21:49:31,031 DEBUG
[org.nuxeo.ecm.directory.sql.SQLDirectory] insert statement: insert
into `USER2GROUP` (`USERID`, `GROUPID`) values (?, ?)
2007-05-26 21:49:31,062 DEBUG
[org.nuxeo.ecm.platform.login.NuxeoLoginModule] createIdentity:
Administrator
2007-05-26 21:49:31,140 DEBUG
[org.nuxeo.ecm.platform.login.NuxeoLoginModule] getRoleSets
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
