Installation instructions

[jharej]

Hi, are there any more detailed instructions for building things with docker? As I see the database gets not build the right way. I've tried to build it manualy and got

mysql> source /var/create-data.sql
Query OK, 3 rows affected (0.01 sec)
Records: 3  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.01 sec)

Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0

Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

ERROR 1136 (21S01): Column count doesn't match value count at row 1
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`librebooking`.`time_blocks`, CONSTRAINT `time_blocks_ibfk_1` FOREIGN KEY (`layout_id`) REFERENCES `layouts` (`layout_id`) ON DELETE CASCADE ON UPDATE CASCADE)
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`librebooking`.`schedules`, CONSTRAINT `schedules_ibfk_1` FOREIGN KEY (`layout_id`) REFERENCES `layouts` (`layout_id`) ON DELETE CASCADE ON UPDATE CASCADE)
mysql> source /var/sample-data-utf8.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.03 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.04 sec)

Query OK, 4 rows affected (0.01 sec)
Records: 4  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.01 sec)

Query OK, 2 rows affected (0.01 sec)
Records: 2  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)

ERROR 1054 (42S22): Unknown column 'min_notice_time_add' in 'field list'
Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.04 sec)

ERROR 1136 (21S01): Column count doesn't match value count at row 1
ERROR 1146 (42S02): Table 'librebooking.custom_attributes' doesn't exist
ERROR 1146 (42S02): Table 'librebooking.custom_attributes' doesn't exist
Query OK, 0 rows affected (0.00 sec)

[JohnVillalovos]

@colisee may have more details as he knows a lot about Docker.

Here is the code that does the database install:

app/Presenters/Install/Installer.php

Lines 27 to 77 in d1f69c4

	public function InstallFresh($should_create_db, $should_create_user, $should_create_sample_data)
	{
	$results = [];
	$config = Configuration::Instance();
	$hostname = $config->GetSectionKey(ConfigSection::DATABASE, ConfigKeys::DATABASE_HOSTSPEC);
	$database_name = $config->GetSectionKey(ConfigSection::DATABASE, ConfigKeys::DATABASE_NAME);
	$database_user = $config->GetSectionKey(ConfigSection::DATABASE, ConfigKeys::DATABASE_USER);
	$database_password = $config->GetSectionKey(ConfigSection::DATABASE, ConfigKeys::DATABASE_PASSWORD);
	$timezone = $config->GetKey(ConfigKeys::DEFAULT_TIMEZONE);
	$create_database = new MySqlScript(ROOT_DIR . 'database_schema/create-db.sql');
	$create_database->Replace('librebooking', $database_name);
	$create_user = new MySqlScript(ROOT_DIR . 'database_schema/create-user.sql');
	$create_user->Replace('librebooking', $database_name);
	$create_user->Replace('lb_user', $database_user);
	$create_user->Replace('localhost', $hostname);
	$create_user->Replace('password', $database_password);
	$populate_sample_data = new MySqlScript(ROOT_DIR . 'database_schema/sample-data-utf8.sql');
	$populate_sample_data->Replace('librebooking', $database_name);
	$create_schema = new MySqlScript(ROOT_DIR . 'database_schema/create-schema.sql');
	$populate_data = new MySqlScript(ROOT_DIR . 'database_schema/create-data.sql');
	$populate_data->Replace('America/New_York', $timezone);
	if ($should_create_db) {
	$results[] = $this->ExecuteScript($hostname, 'mysql', $this->user, $this->password, $create_database);
	}
	$results[] = $this->ExecuteScript($hostname, $database_name, $this->user, $this->password, $create_schema);
	if ($should_create_user) {
	$results[] = $this->ExecuteScript($hostname, $database_name, $this->user, $this->password, $create_user);
	}
	$upgradeResults = $this->Upgrade();
	$results[] = $this->ExecuteScript($hostname, $database_name, $this->user, $this->password, $populate_data);
	/**
	* Populate sample data given in /LibreBooking/database_schema/sample-data-utf8.sql
	*/
	if ($should_create_sample_data) {
	$results[] = $this->ExecuteScript($hostname, $database_name, $this->user, $this->password, $populate_sample_data);
	}
	$results = array_merge($results, $upgradeResults);
	return $results;
	}

And https://github.com/LibreBooking/app/blob/develop/doc/INSTALLATION.md has information on how to setup the database.