Possible to move auditing and businessobjects (CMS) databases?

[Former Member]

We have a newish business objects installation that was configured incorrectly when the 'install.sh' script was run - the installer requires a 'local' MySQL installation, and therefore we ended up pointing the CMS and the auding databases at the local server.

We want to use a remote server - a dedicated MySQL host to run CMS and auditing.

Is there a simple way to stop businessobjects, move the databases, change the configuration on the BO server, and bring it up usign the remote server?

I am very familiar with MySQL operation, so dumping and moving the databases is easy. But I don't knwo where the JDBC / Connection information is stored in BO.

Help!

[roland_hoeller2]

Hi Carl

Try the cmsdbsetup.sh script.

Regards

Roland

[Former Member]

Hi Roland - that seems to have worke,d thank you very much. I'm curious about the 'auditing' database though - has that been moved as well? We want both db instances moved.

[former_member136842]

Hi,

you can not move the Audit DB, only the CMS DB. You have to set your audit connection to you new DB and then only new events will be written.

If you move your DBs between one vendor DB (lets say from oracle DB1 to oracle DB2) you could try with oracle tools to move the audit db content from 1 to 2. That should work.

If you move between vendors (lets say from oracle DB1 to MSSQL DB1) then you would need some ETL tool to move the audit DB.

Regards

-Seb.

[roland_hoeller2]

Hi

If I am not mistaken there should be a different option in the script to move the Auditing db. There is also some db information in the ccm.config. My linux VM built is hanging at the mo so I can't check and verify...

Roland

[Former Member]

Hi, that's great, okay - we can change the connection (this is a very new install, it's not like we have history).

Remember though I'm a poor sysadmin that has been asked to maintain / install a BO server for another team. Where do I set the auditing connection?

Thanks again!

[roland_hoeller2]

Hi

From the BusinessObjects Enterprise Administrator's Guide

To configure the auditing database on UNIX

1. Use ccm.sh to stop the CMS.

2. Run cmsdbsetup.sh.

3. Choose the selectaudit option, and then supply the requested

information about your database server.

4. Run serverconfig.sh.

5. Choose the Modify a server option.

6. Select the CMS, and enable auditing. Enter the port number of the CMS

when prompted (the default value is 6400)

Regards

Roland

[former_member136842]

Hi,

just run the cmsdbsetup.sh script again. There you can choose to set the audit connection.

Regards

-Seb.

[former_member136842]

Hi,

just run the cmsdbsetup.sh script again. There you can choose to set the audit connection.

Regards

-Seb.