{"id":52,"date":"2008-02-16T15:33:04","date_gmt":"2008-02-16T19:33:04","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=52"},"modified":"2008-05-08T15:51:04","modified_gmt":"2008-05-08T19:51:04","slug":"install-alfresco","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=52","title":{"rendered":"Install Alfresco"},"content":{"rendered":"<p><strong>Prepare database (in this case a SQL Server 2000 database)<\/strong><\/p>\n<ul>\n<li>Create a database named alfresco <\/li>\n<li>Create a database user named alfresco and make it owner of the newly created alfresco database<\/li>\n<\/ul>\n<p><strong>Prepare Alfresco<\/strong><\/p>\n<ul>\n<li>Download Alfresco: alfresco-community-tomcat-2.9.0B.zip<\/li>\n<li>Unzip content to D:\\Alfresco<\/li>\n<li>Install JDBC driver\n<ul>\n<li>SQLServer 2005:<br \/>\nCopy sqljdbc.jar to <alfresco_home>\\tomcat\\common\\lib<br \/>\nCopy sqljdbc_auth.dll to <windows>\\system32 <\/li>\n<li>SQLServer 2000:<br \/>\nCopy jtds-1.2.1.jar to to <alfresco_home>\\tomcat\\common\\lib <\/li>\n<\/ul>\n<\/li>\n<li>In alfresco\\tomcat\\shared\\classes\\alfresco\\extension directory<\/li>\n<li>Edit custom-hibernate-dialect.properties to use SQLServer dialect:<br \/>\nhibernate.dialect= org.alfresco.repo.domain<br \/>\n.hibernate.dialect.AlfrescoSQLServerDialect<\/li>\n<li>Edit custom-repository.properties to use alfresco database<br \/>\nSQLServer 2005:<br \/>\ndb.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver<br \/>\ndb.url=jdbc:sqlserver:\/\/localhost; DatabaseName=alfresco; IntegratedSecurity=true<br \/>\n#db.url=jdbc:sqlserver:\/\/localhost; DatabaseName=alfresco; User Id=alfresco;Password=alfresco;<\/p>\n<p>SQLServer 2000:<br \/>\ndir.root=D:\/Alfresco\/Data<br \/>\ndb.username=alfresco<br \/>\ndb.password=alfresco<br \/>\ndb.pool.initial=10<br \/>\ndb.pool.max=100<br \/>\ndb.driver=net.sourceforge.jtds.jdbc.Driver<br \/>\ndb.url=jdbc:jtds:sqlserver:\/\/localhost\/alfresco\n<\/li>\n<li>Edit alfresco\/tomcat\/conf\/server.xml and change port from 8080 to 80<\/li>\n<li>Edit service.bat to increase jvm memory: &#8211;JvmMs 512 &#8211;JvmMx 1024<\/li>\n<li>Install alfresco as a windows service: tomcat\\bin\\service install Alfresco<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Prepare database (in this case a SQL Server 2000 database) Create a database named alfresco Create a database user named alfresco and make it owner of the newly created alfresco database Prepare Alfresco Download Alfresco: alfresco-community-tomcat-2.9.0B.zip Unzip content to D:\\Alfresco &hellip; <a href=\"https:\/\/jianmingli.com\/wp\/?p=52\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[15],"tags":[],"class_list":["post-52","post","type-post","status-publish","format-standard","hentry","category-alfresco"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-Q","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/52","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=52"}],"version-history":[{"count":0,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/52\/revisions"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=52"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=52"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=52"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}