DBPrism CMS 2.1.1 available through CVS includes several improvement collected from the To Do List.

If you need to perform a fresh install, simply uses the install instructions document.

You you will upgrade from a running 2.1.0 version you need to make some changes manually:

Here a list of changes:

• Add a new column to cms_users table, logged as cms_data run alter table cms_users add column liveSite VARCHAR2(256);
• Create a new index on archived_cms_docs table, logged as cms_data execute CREATE INDEX archived_cms_docs_oid_idx ON archived_cms_docs(oid);
• Run the Ant script, ant pre-install, to install the new DBPrism Toolkit.
• Run the Ant script, ant install-source, to re-install the CMS Code.
• Grant these permitions to CMS_CODE and CMS_DATA: create view, create synonym, create public synonym, drop public synonym, alter session.
• This new release include some notifications by email using UTL_MAIL package, check for the availabilty of this package or execute logged as SYS: @?/rdbms/admin/utlmail.sql, @?/rdbms/admin/prvtmail.plb and set the SMTP host using alter system set smtp_out_server='smtp.yourdomain.com' scope=spfile;
• Grant these permitions to all the users listed on CMS_USERS table: execute on UTL_MAIL, create view, create synonym.
• Re-create the DBPrism CMS Front End deployment files running ant dbprism-doc-ldoc-app, and unzip dbprism-ldoc.zip in your Web Server deployment directory of the previous Front End.
• Re-start the container.