MS SQL Server configuration with Liferay

1. Should be a developer edition
2. Through SQL Server configuration manager, enable the TCP/IP port (default 1433)
- In case of error regarding firewall blocking issue, add 1433  to TCP daynamic under IPAll
3. Create database first and then start tomcat server

* In properties, defined user should have admin access. - good to set sa(system administrator for SQL server)



jdbc.default.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.default.username=sa
jdbc.default.password=
jdbc.default.url=jdbc:sqlserver://localhost:1433;databaseName=lportal

index.search.spell.checker.dictionary[en_US]=dictionary/en_US_1.txt,dictionary/en_US_2.txt
javascript.single.page.application.enabled=false

dl.store.impl=com.liferay.portal.store.db.DBStore

dl.file.entry.thumbnail.custom1.max.width=468
dl.file.entry.thumbnail.custom2.max.width=1024
dl.file.entry.thumbnail.custom3.max.width=1280

Comments

Post a Comment

Popular posts from this blog

Portlet Edit Mode (Portlet preference) to replace Portlet configuration

Within the  EDIT  portlet mode, a portlet should provide content and logic that lets a user customize the behavior of the portlet Typically, portlets in  EDIT  portlet mode will set or update portlet preferences. Add the following properties to the MVCPortlet component annotation. "javax.portlet.portlet-mode=text/html;edit" "javax.portlet.init-param.edit-template=/edit.jsp" And then If you go into the grid button on the portlet, 'Preference' option will appear which redirects you to edit.jsp
Read more

GoGo Shell & What can be deleted in Liferay Instance

In Liferay Instance, remove 'state' in osgi & 'work' in tomcat to remove all histories. GoGoShell is for checking the current state of each jar files in modules. pen cmd as admin and type 'telnet localhost 11311' lb : list all the jar files with state stop 70 (jar file numner) / start 70 (uninstall 70 but for deletion, it would be better to delete jar file from module folder physically) )
Read more