Re: [Ecm] Tables 'USERS' and 'USERS2GROUP' dropped every time

George Lefter Tue, 29 May 2007 09:17:33 -0700

Because metadata may be case-insensitive, I cannot do the table check using 
metadata.
So I have changed now the table detection to use a query instead (select count(*) from 
"table").
As talked with Thierry, I also changed the column match to be case-insensitive.



George Lefter wrote:

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


_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm


_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm

Re: [Ecm] Tables 'USERS' and 'USERS2GROUP' dropped every time

Reply via email to