Config Database Mysql + Alfresco

######################  Config Mysql Database ####################
1. yum -y install mysql-server
2. service mysqld start
3. chkconfig mysqld on
4. /usr/bin/mysql_secure_installation
         hit “enter” to give no password
generate and save a new root password
5. service mysqld restart
6. mysql -u root -p
7. CREATE DATABASE alfresco DEFAULT CHARACTER SET utf8;
8. FLUSH PRIVILEGES;
9. exit
10. vi /etc/my.cnf
      [client]
      default-character-set=utf8
      [mysql]
      default-character-set=utf8
      [mysqld]
      collation-server = utf8_unicode_ci
      init-connect='SET NAMES utf8'
      character-set-server = utf8
11. กด esc ตามด้วย :wq
######################  Config Mysql Database ####################

######################  Config Alfresco ####################
12. wget http://eu.dl.alfresco.com/release/community/build-4848/alfresco-community-4.2.e-installer-linux-x64.bin
13. chmod +x alfresco-community-4.2.e-installer-linux-x64.bin
14. yum install -y libXrender libSM libICE libXext fontconfig cups-libs
15. ./alfresco-community-4.2.e-installer-linux-x64.bin
16.      กด 2 install แบบ Advanced
17. Java [Y/n] :Y
18. PostgreSQL [Y/n] :n
19. Alfresco : Y
20. SharePoint [Y/n] :Y
21. Web Quick Start [y/N] : Y
22. OpenOffice [Y/n] :Y
23. Is the selection above correct? [Y/n]: Y
24. Select a folder [/opt/alfresco-4.0.e]: /opt/alfresco
25. JDBC URL: [jdbc:postgresql://localhost/alfresco]: jdbc:mysql://localhost:3306/alfresco
26. JDBC Driver: [org.postgresql.Driver]: org.gjt.mm.mysql.Driver
27. Database name: [alfresco]:  กด Enter ได้เลย คือเลือกเอา Database name ชื่อ alfresco
28. Username: []: root
29. Password: :
30. Verify: :
31. Web Server domain: [127.0.0.1]:
32. Tomcat Server Port: [8080]: ** สามารถแก้ไข port ได้
33. Tomcat Shutdown Port: [8005]: ** สามารถแก้ไข port ได้
34. Tomcat SSL Port [8443]: ** สามารถแก้ไข port ได้
35. Tomcat AJP Port: [8009]: ** สามารถแก้ไข port ได้
36. Port: [21]: ** สามารถแก้ไข port ได้
37. Port: [50500]: ** สามารถแก้ไข port ได้
38. Admin Password: :
39. Repeat Password: :
40. Install Alfresco Community as a service? [Y/n]: Y
41. OpenOffice Server port [8100]:
42. Do you want to continue? [Y/n]: Y
43. View Readme File [Y/n]: Y
44. Launch Alfresco Community Share [Y/n]: Y
45. wget http://mirror.cogentco.com/pub/mysql/Connector-J/mysql-connector-java-5.1.27.tar.gz
46. tar zxvf mysql-connector-java-5.1.27.tar.gz
47. cp /root/mysql-connector-java-5.1.27/mysql-connector-java-5.1.27-bin.jar /opt/alfresco/tomcat/lib
######################  Config Alfresco ####################


######################  เปิดการกำหนด Quota ####################
48. find / -name 'repository.properties'
49. vi /opt/alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/repository.properties
50.      กด esc ตามด้วย :/system.usages.enabled
51. system.usages.enabled=true เปลี่ยนจาก false เป็น true
52. service alfresco restart
######################  เปิดการกำหนด Quota ####################

######################   Email inbound  ####################
53. cd /opt/alfresco/tomcat/shared/classes
54. vi alfresco-global.properties
55. # Enable/Disable the inbound email service.  The service could be used by processes other than
# the Email Server (e.g. direct RMI access) so this flag is independent of the Email Service.
#-------------
email.inbound.enabled=true
# Email Server properties
#-------------
email.server.enabled=true
email.server.port=25
email.server.domain=ec2-72-44-49-158.compute-1.amazonaws.com
email.inbound.unknownUser=emailAnon
email.server.connections.max=3
email.server.enableTLS=false
# A comma separated list of email REGEX patterns of allowed senders.
# If there are any values in the list then all sender email addresses
# must match. For example:
#   .*\@alfresco\.com, .*\@alfresco\.org
# Allow anyone:
#-------------
email.server.allowed.senders=.*
56.      กด esc ตามด้วย :/wq
57. service alfresco restart
######################   Email inbound  ####################


######################   Email outbound  ####################
58. cd /opt/alfresco/tomcat/shared/classes
59. vi alfresco-global.properties
60. mail.host=smtp.gmail.com
61. mail.port=465
62. mail.username=user@gmail.com
63. mail.password=password
64. mail.protocol=smtps
65. mail.smtps.starttls.enable=true
66. mail.smtps.auth=true
67. กด esc ตามด้วย :/wq
68. service alfresco restart
######################   Email outbound  ####################