How to install and configure Alfresco on Solaris
Install Solaris 11
First lets prepare the os, Install Solaris 11 global.
Now lets configure and install a Solaris zone (since Alfresco will be running in a zone).
Follow the below zone configuration to configure your Alfresco Solaris zone.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
zfs create -o mountpoint=/docs rpool/docs chmod 700 /docs zonecfg -z docs # Paste form below to file /tmp/docs.cfg/tmp/docs.cfg # run zonecfg -z docs -f create -b set zonepath=/docs set brand=ipkg set autoboot=true set scheduling-class=FSS set ip-type=exclusive add net set physical=vnic0 end add capped-memory set physical=6G end add dataset set name=rpool/opt/alfresco end add dataset set name=rpool/alfresco end add dataset set name=rpool/mysql-logs end add dataset set name=rpool/mysql-data end commit #Install zone zoneadm -z docs install |
Configure Local IP Address & route
1 2 |
ipadm create-addr -T static -a 10.10.0.171/22 igb0/v4static route -p add default 10.10.0.1 |
Create vnic0 for the new zone
1 |
dladm create-vnic -l igb0 vnic0 |
Add some needed packages to the zone
1 2 3 4 5 |
# Note for sun studio you might need to add the sun studio repository ## Install in the global zone pkg install SUNWrcap ## Install in the local zone pkg install SUNWuiu8 imagemagick xpdf sunstdioexpress gnu-coreutils x11-server-utilities FSWxorg-client-programs svr4 libcanberra |
Install MySql 5.5
Note: MySql 5.5 is not supported on alfresco 3.3g, instead use mysql-51 installed with pkg
Download MySql 5.5 pkg for solaris x86 install and configure it.
1 2 3 4 5 |
gunzip mysql-5.5.8-solaris10-x86_64.pkg.gz pkgadd -d mysql-5.5.8-solaris10-x86_64.pkg /etc/init.d/mysql start /opt/mysql/mysql/bin/mysqladmin -u root password 'new-password' /opt/mysql/mysql/bin/mysqladmin -u root -h docs password 'new-password' |
To start mysql
1 |
svcadm enable svc:/application/database/mysql:version_51 |
Install OpenOffcie 2.3.1 (or latter)
1 2 3 4 5 6 |
wget http://download.services.openoffice.org/files/stable/3.2.1/OOo_3.2.1_Solaris_x86_install-wJRE_en-US.tar.gz gtar -zvxf OOo_3.2.1_Solaris_x86_install-wJRE_en-US.tar.gz cd OOO320_m18_native_packed-1_en-US.9502 ./setup |
Create Open Office start up script
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
cat /etc/init.d/start_oo.sh #!/bin/bash case $1 in start) nohup /opt/openoffice.org3/program/soffice "-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager" -nologo -headless -nofirststartwizard & ;; stop) pkill soffice ;; *) echo "Usage: $0 [stop|start]" esac n -s /etc/init.d/start_oo.sh /etc/rc2.d/S50start_oo.sh |
Install swftools 2.3.1
Download swftools
1 2 3 4 5 6 7 8 9 |
wget http://www.swftools.org/swftools-0.9.0.tar.gz gtar -xvf swftools-0.9.0.tar.gz cd swftools-0.9.0 ./configure dmake dmake instal # Note dmake and cc are from sunstidio |
Install Alfresco Community Tomcat Bundle
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
cd /alfresco_src wget -O alfresco-community-tomcat-3.3g.tar.gz http://dl.alfresco.com/release/community/build-2860/alfresco-community-tomcat-3.3g.tar.gz?dl_file=release/community/build-2860/alfresco-community-tomcat-3.3g.tar.gz zfs create -p -o mountpoint=/opt/alfresco rpool/opt/alfresco cd /opt/alfresco/ tar xvfz alfresco-community-tomcat-3.3g.tar.gz vi *.sh # Replace #!/bin/sh # With #!/bin/bash vi /opt/alfresco/tomcat/shared/classes/alfresco-global.properties # Change mysql user/password |
Configure MySql for alfresco
Configure MySql & alfresco database
Create ZFS MySql data set, and set the record size to 16k (match the db record size)
1 2 |
zfs create -o mountpoint=/mysql-data -o recordsize=16K rpool/mysql-data zfs create -o mountpoint=/mysql-logs rpool/mysql-logs |
Assign the dateset to the zone
1 2 3 4 5 6 7 8 9 |
zonecfg -z docs zonecfg:docs> add dataset zonecfg:docs:dataset> set name=rpool/mysql-logs zonecfg:docs:dataset> end zonecfg:docs> add dataset zonecfg:docs:dataset> set name=rpool/mysql-data zonecfg:docs:dataset> end zonecfg:docs> commit zonecfg:docs> exit |
Create MySql databse & Configure MySql my.cnf
1 2 |
cd /opt/mysql/mysql (in 5.5) and or /usr/mysql/5.1/bin (in 5.1) scripts/mysql_install_db --user=mysql |
Make sure to turn off Double-write buffer on ZFS for the MySql db, change in my.cnf
Note: A full copy of my.cnf is available below appendix b
1 2 3 |
The InnoDB Double-write buffer innodb_flush_method = O_DIRECT # For direct/IO also turns off per-fetching innodb_data_file_path = ibdatafile:10G:autoextend # FileSystem configuration for ZFS |
Create alfresco db
1 2 3 4 5 6 |
cd /opt/alfresco/extras/databases/mysql Change user & password in db_setup.sql /opt/mysql/mysql/bin/mysql -u root -p <db_setup.sql (on 5.5) Or /usr/mysql/5.1/bin/mysql -u root -p <db_setup.sql (on 5.1) |
Set MySql log location
1 2 |
setprop mysql/log = astring: /mysql-logs svcadm refresh svc:/application/database/mysql:version_51 |
Append A – alfresco-global.properties
cat /opt/alfresco/tomcat/shared/classes/alfresco-global.properties
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 |
############################### ## Common Alfresco Properties # ############################### # # Sample custom content and index data location #------------- dir.root=./alf_data # # Sample database connection properties #------------- db.name=alfresco db.username=alfresco db.password=password db.host=localhost db.port=3306 # # External locations #------------- ooo.exe=soffice ooo.enabled=true img.root=/usr swf.exe=/usr/local/bin/pdf2swf # # MySQL connection #------------- db.driver=org.gjt.mm.mysql.Driver db.url=jdbc:mysql://${db.host}:${db.port}/${db.name} # # PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent) # #db.driver=org.postgresql.Driver #db.url=jdbc:postgresql://localhost:5432/alfresco # # Index Recovery Mode #------------- #index.recovery.mode=AUTO # # Outbound Email Configuration #------------- #mail.host= #mail.port=25 #mail.username=anonymous #mail.password= #mail.encoding=UTF-8 #mail.from.default=alfresco@alfresco.org #mail.smtp.auth=false # # Alfresco Email Service and Email Server #------------- # 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=alfresco.com #email.inbound.unknownUser=anonymous # 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=.* # # The default authentication chain # To configure external authentication subsystems see: # http://wiki.alfresco.com/wiki/Alfresco_Authentication_Subsystems #------------- #authentication.chain=alfrescoNtlm1:alfrescoNtlm # # URL Generation Parameters (The ${localname} token is replaced by the local server name) #------------- alfresco.context=alfresco alfresco.host=${localname} alfresco.port=8080 alfresco.protocol=http # share.context=share share.host=${localname} share.port=8080 share.protocol=http #imap.server.enabled=true #imap.server.port=143 #imap.server.host=localhost # # RMI Services # To make your RMI services available from other machines you will need to change # alfresco.rmi.services.host from "localhost". # alfresco.rmi.services.port=50500 |
Start & Login to alfresco
Start alfresco
1 |
/opt/alfresco/alfresco.sh start |
Login to Alfresco Explorer or Alfresco Share
Alfresco has two ways to access the application — Alfresco Explorer and Alfresco Share.
- Go to http://localhost:8080/alfresco – to launch the Alfresco explorer
- Go to http://localhost:8080/share – to launch the Alfresco share
LDAP * Alfresco login
Modify the ldap-authentication.properties to support ldap
- /opt/alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/subsystems/Authentication/ldap/ldap-authentication.properties
Or
Add at the end of /opt/alfresco/tomcat/shared/classes/alfresco-global.properties
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 |
authentication.chain=alfrescoNtlm1:alfrescoNtlm,ldap1:ldap ldap.authentication.active=true ldap.authentication.allowGuestLogin=true ldap.authentication.userNameFormat=uid\=%s,OU\=Computer_IT,ou\=People,o\=domain.com,dc\=subdomain,dc\=com ldap.authentication.java.naming.factory.initial=com.sun.jndi.ldap.LdapCtxFactory ldap.authentication.java.naming.provider.url=ldap://ldap.domain.com:389 ldap.authentication.java.naming.security.authentication=simple ldap.authentication.escapeCommasInBind=false ldap.authentication.escapeCommasInUid=false ldap.authentication.defaultAdministratorUserNames=admin ldap.synchronization.active=true ldap.synchronization.java.naming.security.principal=cn=proxyagent,ou=profile,dc=domain,dc=com ldap.synchronization.java.naming.security.credentials=password ldap.synchronization.queryBatchSize=0 #ldap.synchronization.queryBatchSize=5000 ldap.synchronization.groupQuery=(objectclass\=posixGroup) ldap.synchronization.groupDifferentialQuery=(&(objectclass\=posixGroup)(!(modifyTimestamp<\={0}))) ldap.synchronization.personQuery=(objectclass\=inetOrgPerson) ldap.synchronization.personDifferentialQuery=(&(objectclass\=inetOrgPerson)(!(modifyTimestamp<\={0}))) ldap.synchronization.modifyTimestampAttributeName=modifyTimestamp ldap.synchronization.timestampFormat=yyyyMMddHHmmss'Z' ldap.synchronization.userIdAttributeName=uid ldap.synchronization.userFirstNameAttributeName=givenName ldap.synchronization.userLastNameAttributeName=sn ldap.synchronization.userEmailAttributeName=mail ldap.synchronization.groupIdAttributeName=cn ldap.synchronization.groupType=posixGroup #ldap.synchronization.userOrganizationalIdAttributeName=msExchALObjectVersion ldap.synchronization.defaultHomeFolderProvider=homeDirectory ldap.synchronization.groupSearchBase=ou\=Group,o\=domain.com,dc\=subdomain,dc\=com ldap.synchronization.userSearchBase=OU\=Computer_IT,ou\=People,o\=domain.com,dc\=subdomain,dc\=com ldap.synchronization.groupMemberAttributeName=memberUid ldap.synchronization.synchronizeChangesOnly=true ldap.synchronization.import.cron ldap.synchronization.syncOnStartup=true ldap.synchronization.syncWhenMissingPeopleLogIn=true ldap.synchronization.autoCreatePeopleOnLogin=false ldap.synchronization.personType=inetOrgPerson |
Alfresco 3.4.d additional Install
- install additional packages
1 |
pkg install javamail jta.jar libnb-java sendmail openoffice imagemagick tomcat mysql51 |
- Note: PATH to tomcat is /var/tomcat
- Add to /usr/tomcat6/bin/catalina.sh
1 2 3 |
export ALF_HOME=/usr/tomcat6 export JAVA_OPTS='-Xms512m -Xmx2048m -Xss1024k -XX:MaxPermSize=256m -XX:NewSize=256m -server' export JAVA_OPTS="${JAVA_OPTS} -Dalfresco.home=${ALF_HOME} -Dcom.sun.management.jmxremote" |
- Copy alfresco files (Make backups first)
1 2 3 4 |
cp web-server/conf/* /var/tomcat6/conf/. cp web-server/webapps/* var/tomcat6/webapps/. cp -rp web-server/shared /var/tomcat6/. cp web-server/lib/mysql-connector-java-5.1.13-bin.jar /usr/tomcat6/lib/. |
- Modify logs4j to the proper directory
1 2 3 4 5 6 7 |
Replace in /var/tomcat6/webapps/alfresco/WEB-INF/classes/log4j.properties From log4j.appender.File.File=alfresco.log To log4j.appender.File.File=/var/tomcat6/logs/alfresco.log |
- Modify /var/tomcat6/shared/classes/alfresco-global.properties
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 |
############################### ## Common Alfresco Properties # ############################### # # Sample custom content and index data location #------------- dir.root=/var/tomcat6/alf_data # # Sample database connection properties #------------- db.name=alfresco2 db.username=alfresco db.password=password db.host=docs db.port=3306 # # External locations #------------- ooo.exe=soffice ooo.enabled=true img.root=/usr swf.exe=/usr/local/bin/pdf2swf # # MySQL connection #------------- db.driver=org.gjt.mm.mysql.Driver db.url=jdbc:mysql://${db.host}:${db.port}/${db.name} # # Cifs config #------------- cifs.enabled=true cifs.Server.Name=test cifs.domain=DOMAIN.LOCAL cifs.hostanounce=true cifs.broadcast=0.0.0.0 cifs.tcpipSMB.port=1445 cifs.ipv6.enabled=false cifs.netBIOSSMB.namePort=1137 cifs.netBIOSSMB.datagramPort=1138 cifs.netBIOSSMB.sessionPort=1139 # # PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent) # #db.driver=org.postgresql.Driver #db.url=jdbc:postgresql://localhost:5432/alfresco # # Index Recovery Mode #------------- index.recovery.mode=AUTO # # Outbound Email Configuration #------------- mail.host=localhost mail.port=25 #mail.username=anonymous #mail.password= mail.encoding=UTF-8 mail.from.default=do-not-reply-alfresco@domain.com mail.smtp.auth=false # # Alfresco Email Service and Email Server #------------- # 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=domain.com #email.inbound.unknownUser=anonymous # 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=.* # # The default authentication chain # To configure external authentication subsystems see: # http://wiki.alfresco.com/wiki/Alfresco_Authentication_Subsystems #------------- #authentication.chain=alfrescoNtlm1:alfrescoNtlm # # URL Generation Parameters (The ${localname} token is replaced by the local server name) #------------- alfresco.context=alfresco alfresco.host=${localname} alfresco.port=8080 alfresco.protocol=http # share.context=share share.host=${localname} share.port=8080 share.protocol=http imap.server.enabled=true imap.server.port=143 imap.server.host=localhost # # RMI Services # To make your RMI services available from other machines you will need to change # alfresco.rmi.services.host from "localhost". # alfresco.rmi.services.port=50500 authentication.chain=alfrescoNtlm1:alfrescoNtlm,ldap1:ldap #authentication.chain=alfrescoNtlm1:alfrescoNtlm,passthru1:passthru,ldap1:ldap #cifs.domain=DOMAIN.LOCAL # #ntlm.authentication.sso.enabled=true #passthru.authentication.authenticateCIFS=true #passthru.authentication.domain=DOMIAN.LOCAL\\server1.domain.local,DOMAIN.LOCAL\\server2.domain.local #alfresco.authentication.authenticateCIFS=true ldap.authentication.active=true ldap.authentication.allowGuestLogin=false #ldap.authentication.userNameFormat=uid\=%s,OU\=Computer_IT,ou\=People,o\=domain.com,dc\=subdomain,dc\=com ldap.authentication.userNameFormat= ldap.authentication.java.naming.factory.initial=com.sun.jndi.ldap.LdapCtxFactory ldap.authentication.java.naming.provider.url=ldap://ldap1.domain.com:389 ldap.authentication.java.naming.security.authentication=simple ldap.authentication.java.naming.security.principal=cn=proxyagent,ou=profile,dc=subdomain,dc=com ldap.authentication.java.naming.security.credentials=password ldap.authentication.escapeCommasInBind=false ldap.authentication.escapeCommasInUid=false ldap.authentication.defaultAdministratorUserNames=admin # ldap.synchronization.active=true ldap.synchronization.java.naming.security.principal=cn=proxyagent,ou=profile,dc=subdomain,dc=com ldap.synchronization.java.naming.security.credentials=password ldap.synchronization.queryBatchSize=0 #ldap.synchronization.queryBatchSize=5000 ldap.synchronization.groupQuery=(objectclass=groupofuniquenames) ldap.synchronization.groupDifferentialQuery=(&(objectclass=groupofuniquenames)(!(modifyTimestamp<\={0}))) ldap.synchronization.personQuery=(objectclass=inetOrgPerson) ldap.synchronization.personDifferentialQuery=(&(objectclass=inetOrgPerson)(!(modifyTimestamp<\={0}))) ldap.synchronization.modifyTimestampAttributeName=modifyTimestamp ldap.synchronization.timestampFormat=yyyyMMddHHmmss'Z' ldap.synchronization.userIdAttributeName=uid ldap.synchronization.userFirstNameAttributeName=givenName ldap.synchronization.userLastNameAttributeName=sn ldap.synchronization.userEmailAttributeName=mail ldap.synchronization.groupIdAttributeName=cn ldap.synchronization.groupType=groupofuniquenames #ldap.synchronization.userOrganizationalIdAttributeName=msExchALObjectVersion ldap.synchronization.defaultHomeFolderProvider=homeDirectory ldap.synchronization.groupSearchBase=dc=subdomain,dc=com ldap.synchronisation.personSearchBase=ou=People,o=domain.com,dc=subdoamin,dc=com ldap.synchronization.userSearchBase=ou=People,o=domain.com,dc=subdomain,dc=com #ldap.synchronization.groupSearchBase=ou\=Group,o\=domain.com,dc\=subdomain,dc\=com ldap.synchronization.groupMemberAttributeName=uniqueMember ldap.synchronization.synchronizeChangesOnly=true ldap.synchronization.import.cron ldap.synchronization.syncOnStartup=true ldap.synchronization.syncWhenMissingPeopleLogIn=true ldap.synchronization.autoCreatePeopleOnLogin=false ldap.synchronization.personType=inetOrgPerson ldap.synchronization.autoSyncMissingUse=true # org.alfresco.fileserver=debug |
Appendx B – /etc/my.cnf
my.cnf for MySql 5.5
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 |
# Copyright (C) 2009 Sun Microsystems, Inc # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; version 2 of the License. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA # Default values that applies to all MySQL Servers [mysqld] open-files-limit= 1024 local-infile character-set-server= latin1 # Increase default connect_timeout to avoid intermittent # disconnects when test servers are put under load see BUG#28359 connect-timeout= 60 log-bin-trust-function-creators=1 key_buffer_size= 64M sort_buffer= 256K max_heap_table_size= 128M datadir= /mysql-data #innodb_data_home_dir= /mysql-data loose-innodb_data_file_path= ibdatafile:4096M:autoextend loose-innodb_buffer_pool_size= 2G loose-innodb_write_io_threads= 2 loose-innodb_read_io_threads= 2 loose-innodb_log_buffer_size= 16M loose-innodb_log_file_size= 1G loose-innodb_additional_mem_pool_size= 1024M loose-innodb_log_files_in_group= 2 slave-net-timeout=120 log-bin=mysqld-bin # Run tests with the performance schema instrumentation loose-enable-performance-schema # Run tests with a small number of instrumented objects # to limit memory consumption with MTR loose-performance-schema-max-mutex-instances=10000 loose-performance-schema-max-rwlock-instances=10000 loose-performance-schema-max-table-instances=500 loose-performance-schema-max-table-handles=1000 binlog-direct-non-transactional-updates # Add by eli (needed for ZFS) skip-innodb_doublewrite innodb_file_io_threads = 4 innodb_thread_concurrency = 32 innodb_log_group_home_dir = /mysql-logs #innodb_flush_method = O_DIRECT # #set-variable=long_query_time=5 slow-query-log-file=/mysql-logs/log-slow-queries.log slow-query-log = 1 slow_query_log = 1 long_query_time = 1 [mysqldump] quick max_allowed_packet = 16M |
my.cnf for MySql 5.1 (slight changed)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 |
# Copyright (C) 2009 Sun Microsystems, Inc # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; version 2 of the License. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA # Default values that applies to all MySQL Servers [mysqld] open-files-limit= 1024 local-infile character-set-server= latin1 # Increase default connect_timeout to avoid intermittent # disconnects when test servers are put under load see BUG#28359 connect-timeout= 60 log-bin-trust-function-creators=1 key_buffer_size= 64M sort_buffer= 256K max_heap_table_size= 128M datadir= /mysql-data #innodb_data_home_dir= /mysql-data loose-innodb_data_file_path= ibdatafile:4096M:autoextend loose-innodb_buffer_pool_size= 2G #loose-innodb_write_io_threads= 2 #loose-innodb_read_io_threads= 2 loose-innodb_log_buffer_size= 16M loose-innodb_log_file_size= 1G loose-innodb_additional_mem_pool_size= 1024M loose-innodb_log_files_in_group= 2 slave-net-timeout=120 log-bin=mysqld-bin # Run tests with the performance schema instrumentation #loose-enable-performance-schema # Run tests with a small number of instrumented objects # to limit memory consumption with MTR #loose-performance-schema-max-mutex-instances=10000 #loose-performance-schema-max-rwlock-instances=10000 #loose-performance-schema-max-table-instances=500 #loose-performance-schema-max-table-handles=1000 #binlog-direct-non-transactional-updates # Add by eli (needed for ZFS) skip-innodb_doublewrite innodb_file_io_threads = 4 innodb_thread_concurrency = 32 innodb_log_group_home_dir = /mysql-logs #innodb_flush_method = O_DIRECT # #set-variable=long_query_time=5 slow-query-log-file=/mysql-logs/log-slow-queries.log slow-query-log = 1 slow_query_log = 1 long_query_time = 1 [mysqldump] quick max_allowed_packet = 16M |
Troubleshooting
- Alfresco logs: tail -f /opt/alfresco/alfresco.log
- Tomcat logs: tail -f /opt/alfresco/tomcat/logs/catalina.out
Leave a Reply