Getting Started Sulu CMS

Installation

Tahap-1 Instalasi

composer create-project sulu/sulu-minimal my-project -n

Logs instalasi ada disini.

Tahap-2 Set GIT

cd my-project
git init
git add .
git commit -m "Initial commit"

Logs ada disini.

Tahap-3 Basic Setup

Edit example.com.xml jadi my-project1.com.xml

Edit file my-project1.com.xml

Caution

Changing the <key> of a webspace later on causes complications. We recommend to decide what key to use before you build the database in the next step.

We’ll return to webspaces later in this book.

Tahap-4 Setup Database (MySQL)

vim app/config/parameters.yml

Tahap-5  Build Project with MySQL

sudo apt-get install php7.2-mysql

bin/adminconsole sulu:build dev

Tahap-6 Build with MySQL Failed

Errors

 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'system, created, changed, idSecurityTypes, idUsersCreator, idUsersChanger) VALUE' at line 1" ["exception" => Doctrine\DBAL\Exception\SyntaxErrorException { …},"command" => "sulu:build dev","message" => """  An exception occurred while executing 'INSERT INTO se_roles (name, system, created, changed, idSecurityTypes, idUsersCreator, idUsersChanger) VALUES (?, ?, ?, ?, ?, ?, ?)' with params ["User", "Sulu", "2019-07-23 18:13:42", "2019-07-23 18:13:42", null, null, null]:\n  \n  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'system, created, changed, idSecurityTypes, idUsersCreator, idUsersChanger) VALUE' at line 1  """]

Tahap-7 Setup Database (PostgreSQL)

Changed the database from MySQL to PostgreSQL.

Using PostgreSQL

Sulu does not support MySQL 8.0 but work properly on PostgreSQL 11

Tahap-8 Run Server

SYMFONY_ENV=dev bin/console server:start