MySQL
> Hi, > > What database do they use? > > > Florent Guillaume wrote: >> 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
