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],
cl=org.jboss.mx.loading.HeirarchicalLoaderRepository3
[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
--
Florent Guillaume, Director of R&D, Nuxeo
Open Source Enterprise Content Management (ECM)
http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
