The document provides instructions for downloading and configuring software and databases needed to set up a Sakai project. It includes links to download Apache Tomcat, Maven, the Sakai project files, and MySQL connector. It also provides details on setting environment variables, creating a MySQL database called sakaidatabase, configuring Tomcat by adding the MySQL connector library and a sakai.properties file, and modifying Tomcat context and server files. It concludes by creating a setenv.bat file and starting Tomcat.
The document provides instructions for downloading and configuring software and databases needed to set up a Sakai project. It includes links to download Apache Tomcat, Maven, the Sakai project files, and MySQL connector. It also provides details on setting environment variables, creating a MySQL database called sakaidatabase, configuring Tomcat by adding the MySQL connector library and a sakai.properties file, and modifying Tomcat context and server files. It concludes by creating a setenv.bat file and starting Tomcat.
The document provides instructions for downloading and configuring software and databases needed to set up a Sakai project. It includes links to download Apache Tomcat, Maven, the Sakai project files, and MySQL connector. It also provides details on setting environment variables, creating a MySQL database called sakaidatabase, configuring Tomcat by adding the MySQL connector library and a sakai.properties file, and modifying Tomcat context and server files. It concludes by creating a setenv.bat file and starting Tomcat.
The document provides instructions for downloading and configuring software and databases needed to set up a Sakai project. It includes links to download Apache Tomcat, Maven, the Sakai project files, and MySQL connector. It also provides details on setting environment variables, creating a MySQL database called sakaidatabase, configuring Tomcat by adding the MySQL connector library and a sakai.properties file, and modifying Tomcat context and server files. It concludes by creating a setenv.bat file and starting Tomcat.
create database sakaidatabase default character set utf8;
grant all on sakaidatabase.* to sakaiuser@'localhost' identified by 'sakaipassword'; grant all on sakaidatabase.* to sakaiuser@'127.0.0.1' identified by 'sakaipassword'; flush privileges;
CONFIGURACIÓN TOMCAT:
1. COPIAR MYSQL CONNECTOR A DIRECTORIO CATALINA_HOME/lib
2. CREAR CARPETA CATALINA_HOME/sakai Y CREAR UN ARCHIVO LLAMADO sakai.properties Y
AGREGAR EL SIGUIENTE CONTENIDO
## MySQL settings # Replace by whatever username you assigned in the database setup username@javax.sql.BaseDataSource=sakaiuser # Replace by whatever password you assigned to the sakaiuser in the database setup password@javax.sql.BaseDataSource=sakaipassword
# use your sakaidatabase name in the URI that starts
url@javax.sql.BaseDataSource= , below. vendor@org.sakaiproject.db.api.SqlService=mysql driverClassName@javax.sql.BaseDataSource=com.mysql.jdbc.Driver hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect url@javax.sql.BaseDataSource=jdbc:mysql://127.0.0.1:3306/sakaidatabase? useUnicode=true&characterEncoding=UTF-8 validationQuery@javax.sql.BaseDataSource=select 1 from DUAL defaultTransactionIsolationString@javax.sql.BaseDataSource=TRANSACTION_READ_COMMITT ED
3. MODIFICAR CATALINA_HOME/conf/context.xml Y AGREGAR DENTRO DE CONTEXT
<JarScanner> <!-- This is to speedup startup so that tomcat doesn't scan as much --> <JarScanFilter defaultPluggabilityScan="false" /> </JarScanner>
4. MODIFICAR CATALINA_HOME/conf/server.xml Y AGREGAR DESPUES DE <Connector
port="8080"
URIEncoding="UTF-8"
6. CREAR ARCHIVO setenv.bat DENTRO DE CATALINA_HOME/bin Y AGREGAR EL SIGUIENTE
CONTENIDO:
set JAVA_OPTS=-server -Xmx1028m -XX:MaxMetaspaceSize=512m
