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-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
