Implementing audit reporting in reportnet 1.1

[willie]

Hi,

Can anyone explain in detail how to implement the auditing feature in reportnet 1.1.
Does the reportnet 1.1 come with the audit model?

Thanks,
Willie

[cogman]

Steps:

These steps were created from Cognos ReportNet 1.1 MR2.

The steps presume that you have the Audit reports imported from the deployment, if you do not have the Audit reports imported as of yet, then find the file named cognos_audit.zip included with your installation (located in the installation_location/webcontent/samples/content directory).  Copy the file to installation_location/deployment, and then follow the procedure to import the samples (see the 1.1MR2 Administration and Security Guide), when following these steps understand that you are importing the cognos_audit reports and not the cognos_samples.

These steps also presumes that Cognos ReportNet is started.

1. Increase the Logging Level in Cognos ReportNet (see the Cognos ReportNet 1.1 MR2 Administration and Security Guide).

2. Enable Audit Native Query (see the Cognos ReportNet 1.1 MR2 Administration and Security Guide). 

3. Add the audit database to Cognos Configuration.

            -in Cognos Configuration, right click on Logging, select New Resource.

            -select Destination.

            -name the destination (ie: Audit).

            -Ensure that the database is selected in the 'Type' drop-down menu, click OK.

            -right click the new destination that you just created.

            -select New Resource, select Database.

            -Name it 'Audit', and select the vendor that the Audit database has been created in (it is expected that you have already created the database in your database environment).

            -enter the proper credentials for your Audit database (Host, port, User ID, Password, DB Name).

            -Save from within Cognos Configuration.

4. In Cognos Connection, create a datasource to this new Audit Database.

5. Also follow the steps below to create a second datasource:

            -New Datasource, enter url_xml as the name, click Next.

            -choose XML as the Type, click Next.

            -enter the following as a connection string: http://servername:9300/p2pd/cognos/DSServlet.jsp click Finish.

NOTE: the host name and the port number in the connection string above needs to refer to your Dispatcher.

NOTE: this datasource will not test successfully until you are finished.

6. In the WEB.XML file (located in webapps/p2pd/web-inf), there will be a number of instances of <servlet></servlet> tags and <servlet-mapping></servlet-mapping> tags.

Place this XML amongst the other <servlet></servlet> tags taking care not to place the XML in the middle of another set of <servlet></servlet> tags:

            <servlet>
                       <servlet-name>DSServlet</servlet-name>
                       <servlet-class>com.cognos.demo.DSServlet</servlet-class>
            </servlet>

Place this XML amongst the other <servlet-mapping></servlet-mapping> tags again taking care not to place the XML in the middle of another set of <servlet-mapping></servlet-mapping> tags:

            <servlet-mapping>
                        <servlet-name>DSServlet</servlet-name>
                        <url-pattern>/cognos/DSServlet.jsp</url-pattern>
            </servlet-mapping>

Make sure both of these modfications are before the </webapp> tag at the very end of the file.

7. Copy the build.bat file from crn/webapps/Audit to crn/webapps/p2pd/web-inf/classes/com/cognos/demo.

NOTE: create the /com/cognos/demo folder structure location if it does not currently exist and make sure its all in lower case.

8. Edit the build file to ensure the JAVA_HOME points to your JDK (i.e. - C:\Sun\AppServer\jdk) and ensure your CRN_HOME points to your crn directory. If JDK is not installed on the server, then download and install it.

9. Copy the DSServlet.java file from the crn/webapps/Audit directory to crn/webapps/p2pd/web-inf/classes/com/cognos/demo.

10. Do one of the following in the DSServlet.java file:

            -If you are allowing anonymous logon, comment out the following line:

            binding.logon(...)

            -If you are not allowing anonymous logon, make sure that the username, password an namespace variables are correct (use the namespace id instead of the namespace name) and uncomment the following line:

            binding.logon(...)

11. Open a command prompt and run build.bat from crn/webapps/p2pd/web-inf/classes/com/cognos/demo.

Note:

If you are using another Application Server than the shipped Apache Tomcat, you have to rebuild your p2pd.war file and redeploy it in your Application server. Otherwise the changes wouldn't take affect.