Alfresco WorkDesk set up steps

Steps required for WorkDesk set up

1.       Set up the database, Scripts are available for setting different databases. We will consider setting it up with mysql

C:\Users\bpatil\Desktop\Workdesk\db\scripts\create_mysql_databases

Execute all the sql files so that it sets the user,database and tables which needs to be used later in workdesk configuration

2.       Copy the mysql connector jar to the location  C:\Alfresco\tomcat\lib and copy the workdesk folder to C:\Alfresco\tomcat\webapps from the downloaded zip file

3.       Now configure the workdesk to look into the application  cmis_prof by changing web.xml  in the location C:\Alfresco\tomcat\webapps\workdesk\WEB-INF

        OwResourceFilePath

         deploy#WEB-INF/conf/cmis_prof

4.       Configure the datasource in workdesk.xml in the location  C:\Alfresco\tomcat\conf\Catalina\localhost

        auth="Container"

        type="javax.sql.DataSource"

        factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"

        username="owdemo"

        password="owdemo"

        driverClassName="com.mysql.jdbc.Driver"

        url="jdbc:mysql://localhost:3306/owd?autoReconnect=true"

        maxWait="1000"

        removeAbandoned="true"

        maxActive="30"

        maxIdle="10"

        removeAbandonedTimeout="60"

        logAbandoned="true"

        validationQuery="select 1"/>     

5.       Change owbootstrap.xml in the location C:\Alfresco\tomcat\webapps\workdesk\WEB-INF\conf\cmis_prof to connect to the configured data source

                                java:/MySQLDS

               

    

6.       Restart alfresco server and login to alfresco to see the below screen