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
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
6. Restart
alfresco server and login to alfresco to see the below screen
