Differential D1573
Allow to create MySQL database Authored by dereckson on Apr 3 2018, 02:34. Tags None Referenced Files
Subscribers None
Details
How can we create a database for a new phpBB instance? The wrapper script runs on the Docker Engine host The wrapper script will so run a container with this The wrapper part is implemented at D1524. saas-phpbb sites:createdb foo
Diff Detail
Event TimelineComment Actions Ensure identifiant is valid. Use PDO in exception mode. Database aren't a named parameter to quote. Comment Actions 1. Prepare a directory with the code to test Dwellers $ cd /home/dereckson/dev/docker/phpbb $ git clone ssh://vcs@devcentral.docker.ulubis/source/saas-phpbb.git $ cd saas-phpbb $ arc shell $ arc patch D1573 2. Run a MySQL container Same procedure and container than acquisitariat, but called phpbb_db, and without a volume mount. 3. Run a php-cli container $ mkdir /tmp/data-saas-phpbb $ docker run -it --rm --link phpbb_db:db -e SAAS_SITES_DB=/data/sites.db -v /tmp/data-saas-phpbb:/data -v /home/dereckson/dev/docker/phpbb/saas-phpbb:/app nasqueron/php-cli bash $ make $ saas-phpbb sites:bootstrap 4. Add test data in sites.db $ sqlite /tmp/data-saas-phpbb/sites.db SQLite version 3.7.17 2013-05-20 00:56:22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .schema CREATE TABLE sites ( id text, host text, db_user text, db_password text, db_prefix text, active boolean ); sqlite> INSERT INTO sites VALUES ('acme', 'phpbb.acme.tld', 'acme', 'somepass', 'phpbb_', 1); sqlite> 5. Go back to our php-cli container to test this change $ php bin/saas-phpbb.php sites:createdb acme6. Fire a MySQL client to check we can connect to the created database with the created account $ docker run -it --link phpbb_db:mysql --rm nasqueron/mysql bash $ mysql -hmysql -uacme -p acme Enter password: somepass Welcome to the MySQL monitor. Commands end with ; or \g. mysql> |