It seems some people here have problem migrating, they have the old table "USER" for instance but "user" is not detected as missing, so it's not recreated, and later on of course the select fails. Could you check table presence detection uses the case correctly?
Florent > 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 >>> >>> >> > > > -- 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
