Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
Framadate
Framadate
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 218
    • Issues 218
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Merge Requests 37
    • Merge Requests 37
  • Operations
    • Operations
    • Incidents
    • Environments
  • Analytics
    • Analytics
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Members
    • Members
  • Collapse sidebar
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
  • Framasoft
  • Framadate
  • FramadateFramadate
  • Wiki
    • Install
  • Database

Last edited by Thomas Citharel Aug 07, 2018
Page history

Database

Creating database

Framadate's database must be created before it can be populated. We also recommand connecting to your database with a dedicated user to increase security. Therefore you must connect to your MySQL or PostgreSQL server to execute a few commands.

MySQL

Connect to the database server

sudo mysql

Create the database

CREATE DATABASE IF NOT EXISTS `framadate` DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

Create a dedicated user (replace useastrongpassword with a strong password and don't forget to write it down)

CREATE USER 'framadate'@'localhost' IDENTIFIED BY 'useastrongpassword';
GRANT ALL PRIVILEGES ON `framadate`.* TO 'framadate'@'localhost';

If the database is on a different server than the application, replace localhost with correct value.

PostgreSQL

Framadate will be compatible with PostgreSQL only from version 1.2.0, which is yet to be released.


Connect to the database server

su - postgres
psql

Create a dedicated user (replace useastrongpassword with a strong password and don't forget to write it down)

CREATE USER 'framadate'@'localhost' WITH PASSWORD 'useastrongpassword';

If the database is on a different server than the application, replace localhost with correct value.

Create the database

CREATE DATABASE framadate;

Grant all rights to the framadate user on the framadate database.

GRANT ALL PRIVILEGES ON DATABASE framadate to 'framadate'@'localhost';

You can now quit psql and the postgres user with double Ctrl + D.

You can begin to install Framadate.

Clone repository
  • Install
  • Maintenance
    • Backups
    • Mode
    • Updating
  • coding
  • environment
  • faq
  • Home
  • install
    • Configure
    • Database
    • Install
    • requirements
  • locales
  • technical
  • translating
View All Pages