Nuxeo SQL Database Schema Creation

[SMAH_Haider]

We have to run Nuxeo with db.user and db.password having no table creation rights and we have successfully configured nuxeo but we have to do the following steps:

1. Start nuxeo with db.user and db.password having table creation rights. (This step creates all the necessary tables)
2. Set noDDL as "true" and added custom plugin having directories' table creation policies as "never"
3. Start nuxeo with db.user and db.password having no table creation rights.

Nuxeo starts perfectly fine.

We want to avoid step # 1 (first starting nuxeo with db.user and db.password having table creation rights) So we want to create tables via sql db scripts. Is this possible?

[Benjamin_Jalon1 · Accepted solution]

I'm not sure to understand your question. Do you ask our permission to do that ? 😄

If you really want, why not 🙂 but you will do exactly the same that what Nuxeo do automatically. Maybe my advices would be

• is to allow table creation just for the first start and remove the right after.
• or you do the initialization of a pre-production instance identical of your production one and dump the data to inject it into the production instance...

But becareful if you do maintenance action (hot fix deployment) or add more feature through studio project or any else action that need the table rights, you may have some instabilities. My real advice will be to let the right.

Hope this will help you 😄

[SMAH_Haider]

Bjalon, Thats the constraint from the client that we cannot run nuxeo with user having table creation rights.

[Benjamin_Jalon1]

I'm sad for you

[Florent_Guillau]

The simplest way is to start Nuxeo once on an empty database, then use a database script generation tool to dump its content and turn it into a SQL script.

For instance using PostgreSQL you can use pg_dump --schema-only.