]> git.mxchange.org Git - friendica.git/blobdiff - tests/src/Core/Console/AutomaticInstallationConsoleTest.php
Merge pull request #7068 from MrPetovan/task/7047-theme-error-page
[friendica.git] / tests / src / Core / Console / AutomaticInstallationConsoleTest.php
index f83edd88daf7a5555899b6e922cbfe764a0fd070..9ed3d404f21a57bed039c9bada2a6503ed5c5989 100644 (file)
@@ -2,7 +2,18 @@
 
 namespace Friendica\Test\src\Core\Console;
 
+use Friendica\Core\Config\Cache\ConfigCache;
+use Friendica\Core\Console\AutomaticInstallation;
+use Friendica\Core\Installer;
+use Friendica\Core\Logger;
+use Friendica\Test\Util\DBAMockTrait;
+use Friendica\Test\Util\DBStructureMockTrait;
+use Friendica\Test\Util\L10nMockTrait;
+use Friendica\Test\Util\RendererMockTrait;
+use Friendica\Util\BaseURL;
+use Friendica\Util\Logger\VoidLogger;
 use org\bovigo\vfs\vfsStream;
+use org\bovigo\vfs\vfsStreamFile;
 
 /**
  * @runTestsInSeparateProcesses
@@ -11,32 +22,144 @@ use org\bovigo\vfs\vfsStream;
  */
 class AutomaticInstallationConsoleTest extends ConsoleTest
 {
-       private $db_host;
-       private $db_port;
-       private $db_data;
-       private $db_user;
-       private $db_pass;
+       use L10nMockTrait;
+       use DBAMockTrait;
+       use DBStructureMockTrait;
+       use RendererMockTrait;
+
+       /**
+        * @var vfsStreamFile Assert file without DB credentials
+        */
+       private $assertFile;
+       /**
+        * @var vfsStreamFile Assert file with DB credentials
+        */
+       private $assertFileDb;
+
+       /**
+        * @var ConfigCache The configuration cache to check after each test
+        */
+       private $configCache;
 
        public function setUp()
        {
                parent::setUp();
 
-               if ($this->root->hasChild('config' . DIRECTORY_SEPARATOR . 'local.ini.php')) {
+               if ($this->root->hasChild('config' . DIRECTORY_SEPARATOR . 'local.config.php')) {
                        $this->root->getChild('config')
-                               ->removeChild('local.ini.php');
+                               ->removeChild('local.config.php');
                }
 
-               $this->db_host = getenv('MYSQL_HOST');
-               $this->db_port = (!empty(getenv('MYSQL_PORT'))) ? getenv('MYSQL_PORT') : null;
-               $this->db_data = getenv('MYSQL_DATABASE');
-               $this->db_user = getenv('MYSQL_USERNAME') . getenv('MYSQL_USER');
-               $this->db_pass = getenv('MYSQL_PASSWORD');
+               $this->mockL10nT();
+
+               $this->configCache = new ConfigCache();
+               $this->configCache->set('system', 'basepath', $this->root->url());
+               $this->configCache->set('config', 'php_path', trim(shell_exec('which php')));
+               $this->configCache->set('system', 'theme', 'smarty3');
+
+               $this->mockApp($this->root, true);
+
+               $this->configMock->shouldReceive('set')->andReturnUsing(function ($cat, $key, $value) {
+                       if ($key !== 'basepath') {
+                               return $this->configCache->set($cat, $key, $value);
+                       } else {
+                               return true;
+                       }
+               });
+
+               $this->configMock->shouldReceive('has')->andReturn(true);
+               $this->configMock->shouldReceive('get')->andReturnUsing(function ($cat, $key) {
+                       return $this->configCache->get($cat, $key);
+               });
+               $this->configMock->shouldReceive('load')->andReturnUsing(function ($config, $overwrite = false) {
+                       return $this->configCache->load($config, $overwrite);
+               });
+
+               $this->mode->shouldReceive('isInstall')->andReturn(true);
+               Logger::init(new VoidLogger());
        }
 
-       private function assertConfig($family, $key, $value)
+       /**
+        * Returns the dataset for each automatic installation test
+        *
+        * @return array the dataset
+        */
+       public function dataInstaller()
        {
-               $config = $this->execute(['config', $family, $key]);
-               $this->assertEquals($family . "." . $key . " => " . $value . "\n", $config);
+               return [
+                       'empty' => [
+                               'data' => [
+                                       'database' => [
+                                               'hostname'    => '',
+                                               'username'    => '',
+                                               'password'    => '',
+                                               'database'    => '',
+                                               'port'        => '',
+                                       ],
+                                       'config' => [
+                                               'php_path'    => '',
+                                               'hostname'    => 'friendica.local',
+                                               'admin_email' => '',
+                                       ],
+                                       'system' => [
+                                               'basepath'    => '',
+                                               'urlpath'     => '',
+                                               'url'         => 'http://friendica.local',
+                                               'ssl_policy'  => 0,
+                                               'default_timezone' => '',
+                                               'language'    => '',
+                                       ],
+                               ],
+                       ],
+                       'normal' => [
+                               'data' => [
+                                       'database' => [
+                                               'hostname'    => 'testhost',
+                                               'port'        => 3306,
+                                               'username'    => 'friendica',
+                                               'password'    => 'a password',
+                                               'database'    => 'database',
+                                       ],
+                                       'config' => [
+                                               'php_path'    => '',
+                                               'hostname'    => 'friendica.local',
+                                               'admin_email' => 'admin@philipp.info',
+                                       ],
+                                       'system' => [
+                                               'urlpath'     => 'test/it',
+                                               'url'         => 'http://friendica.local/test/it',
+                                               'basepath'    => '',
+                                               'ssl_policy'  => '2',
+                                               'default_timezone' => 'en',
+                                               'language'    => 'Europe/Berlin',
+                                       ],
+                               ],
+                       ],
+                       'special' => [
+                               'data' => [
+                                       'database' => [
+                                               'hostname'    => 'testhost.new.domain',
+                                               'port'        => 3341,
+                                               'username'    => 'fr"ยง%ica',
+                                               'password'    => '$%\"gse',
+                                               'database'    => 'db',
+                                       ],
+                                       'config' => [
+                                               'php_path'    => '',
+                                               'hostname'    => 'friendica.local',
+                                               'admin_email' => 'admin@philipp.info',
+                                       ],
+                                       'system' => [
+                                               'urlpath'     => 'test/it',
+                                               'url'         => 'https://friendica.local/test/it',
+                                               'basepath'    => '',
+                                               'ssl_policy'  => '1',
+                                               'default_timezone' => 'en',
+                                               'language'    => 'Europe/Berlin',
+                                       ],
+                               ],
+                       ],
+               ];
        }
 
        private function assertFinished($txt, $withconfig = false, $copyfile = false)
@@ -48,6 +171,8 @@ class AutomaticInstallationConsoleTest extends ConsoleTest
 
 
 Creating config file...
+
+ Complete!
 CFG;
                }
 
@@ -56,20 +181,23 @@ CFG;
 
 
 Copying config file...
+
+ Complete!
 CFG;
                }
 
                $finished = <<<FIN
-Initializing setup...{$cfg}
+Initializing setup...
 
  Complete!
 
 
-Checking basic setup...
+Checking environment...
 
  NOTICE: Not checking .htaccess/URL-Rewrite during CLI installation.
 
  Complete!
+{$cfg}
 
 
 Checking database...
@@ -100,22 +228,25 @@ FIN;
                $finished = <<<FIN
 Initializing setup...
 
-Creating config file...
-
  Complete!
 
 
-Checking basic setup...
+Checking environment...
 
  NOTICE: Not checking .htaccess/URL-Rewrite during CLI installation.
 
  Complete!
 
 
+Creating config file...
+
+ Complete!
+
+
 Checking database...
 
 [Error] --------
-MySQL Connection: Failed, please check your MySQL settings and credentials.
+Could not connect to database.: 
 
 
 FIN;
@@ -123,160 +254,330 @@ FIN;
                $this->assertEquals($finished, $txt);
        }
 
-       /**
-        * @medium
-        */
-       public function testWithConfig()
+       private function assertStuckURL($txt)
        {
-               $config = <<<CONF
-<?php return <<<INI
+               $finished = <<<FIN
+Initializing setup...
 
-[database]
-hostname = 
-username = 
-password = 
-database = 
-charset = utf8mb4
+ Complete!
 
 
-; ****************************************************************
-; The configuration below will be overruled by the admin panel.
-; Changes made below will only have an effect if the database does
-; not contain any configuration for the friendica system.
-; ****************************************************************
+Checking environment...
 
-[config]
-admin_email =
+ NOTICE: Not checking .htaccess/URL-Rewrite during CLI installation.
 
-sitename = Friendica Social Network
+ Complete!
 
-register_policy = REGISTER_OPEN
-register_text =
 
-[system]
-default_timezone = UTC
+Creating config file...
 
-language = en
-INI;
-// Keep this line
+The Friendica URL has to be set during CLI installation.
 
-CONF;
+FIN;
 
-               vfsStream::newFile('prepared.ini.php')
-                       ->at($this->root)
-                       ->setContent($config);
+               $this->assertEquals($finished, $txt);
+       }
 
-               $txt = $this->execute(['autoinstall', '-f', 'prepared.ini.php']);
+       /**
+        * Asserts one config entry
+        *
+        * @param string     $cat           The category to test
+        * @param string     $key           The key to test
+        * @param null|array $assertion     The asserted value (null = empty, or array/string)
+        * @param string     $default_value The default value
+        */
+       public function assertConfigEntry($cat, $key, $assertion = null, $default_value = null)
+       {
+               if (!empty($assertion[$cat][$key])) {
+                       $this->assertEquals($assertion[$cat][$key], $this->configCache->get($cat, $key));
+               } elseif (!empty($assertion) && !is_array($assertion)) {
+                       $this->assertEquals($assertion, $this->configCache->get($cat, $key));
+               } elseif (!empty($default_value)) {
+                       $this->assertEquals($default_value, $this->configCache->get($cat, $key));
+               } else {
+                       $this->assertEmpty($this->configCache->get($cat, $key), $this->configCache->get($cat, $key));
+               }
+       }
 
-               $this->assertFinished($txt, false, true);
+       /**
+        * Asserts all config entries
+        *
+        * @param null|array $assertion    The optional assertion array
+        * @param boolean    $saveDb       True, if the db credentials should get saved to the file
+        * @param boolean    $default      True, if we use the default values
+        * @param boolean    $defaultDb    True, if we use the default value for the DB
+        * @param boolean    $realBasepath True, if we use the real basepath of the installation, not the mocked one
+        */
+       public function assertConfig($assertion = null, $saveDb = false, $default = true, $defaultDb = true, $realBasepath = false)
+       {
+               if (!empty($assertion['database']['hostname'])) {
+                       $assertion['database']['hostname'] .= (!empty($assertion['database']['port']) ? ':' . $assertion['database']['port'] : '');
+               }
 
-               $this->assertTrue($this->root->hasChild('config' . DIRECTORY_SEPARATOR . 'local.ini.php'));
+               $this->assertConfigEntry('database', 'hostname', ($saveDb) ? $assertion : null, (!$saveDb || $defaultDb) ? Installer::DEFAULT_HOST : null);
+               $this->assertConfigEntry('database', 'username', ($saveDb) ? $assertion : null);
+               $this->assertConfigEntry('database', 'password', ($saveDb) ? $assertion : null);
+               $this->assertConfigEntry('database', 'database', ($saveDb) ? $assertion : null);
+
+               $this->assertConfigEntry('config', 'admin_email', $assertion);
+               $this->assertConfigEntry('config', 'php_path', trim(shell_exec('which php')));
+               $this->assertConfigEntry('config', 'hostname', $assertion);
+
+               $this->assertConfigEntry('system', 'default_timezone', $assertion, ($default) ? Installer::DEFAULT_TZ : null);
+               $this->assertConfigEntry('system', 'language', $assertion, ($default) ? Installer::DEFAULT_LANG : null);
+               $this->assertConfigEntry('system', 'url', $assertion);
+               $this->assertConfigEntry('system', 'urlpath', $assertion);
+               $this->assertConfigEntry('system', 'ssl_policy', $assertion, ($default) ? BaseURL::DEFAULT_SSL_SCHEME : null);
+               $this->assertConfigEntry('system', 'basepath', ($realBasepath) ? $this->root->url() : $assertion);
        }
 
        /**
-        * @medium
+        * Test the automatic installation without any parameter/setting
+        * Should stuck because of missing hostname
         */
-       public function testWithEnvironmentAndSave()
+       public function testEmpty()
        {
-               $this->assertTrue(putenv('FRIENDICA_ADMIN_MAIL=admin@friendica.local'));
-               $this->assertTrue(putenv('FRIENDICA_TZ=Europe/Berlin'));
-               $this->assertTrue(putenv('FRIENDICA_LANG=de'));
+               $console = new AutomaticInstallation($this->consoleArgv);
 
-               $txt = $this->execute(['autoinstall', '--savedb']);
+               $txt = $this->dumpExecute($console);
 
-               $this->assertFinished($txt, true);
+               $this->assertStuckURL($txt);
+       }
+
+       /**
+        * Test the automatic installation without any parameter/setting
+        * except URL
+        */
+       public function testEmptyWithURL()
+       {
+               $this->mockConnect(true, 1);
+               $this->mockConnected(true, 1);
+               $this->mockExistsTable('user', false, 1);
+               $this->mockUpdate([$this->root->url(), false, true, true], null, 1);
 
-               $this->assertTrue($this->root->hasChild('config' . DIRECTORY_SEPARATOR . 'local.ini.php'));
+               $this->mockGetMarkupTemplate('local.config.tpl', 'testTemplate', 1);
+               $this->mockReplaceMacros('testTemplate', \Mockery::any(), false, '', 1);
 
-               $this->assertConfig('database', 'hostname', $this->db_host . (!empty($this->db_port) ? ':' . $this->db_port : ''));
-               $this->assertConfig('database', 'username', $this->db_user);
-               $this->assertConfig('database', 'database', $this->db_data);
-               $this->assertConfig('config', 'admin_email', 'admin@friendica.local');
-               $this->assertConfig('system', 'default_timezone', 'Europe/Berlin');
-               $this->assertConfig('system', 'language', 'de');
+               $console = new AutomaticInstallation($this->consoleArgv);
+               $console->setOption('url', 'http://friendica.local');
+
+               $txt = $this->dumpExecute($console);
+
+               $this->assertFinished($txt, true, false);
+               $this->assertTrue($this->root->hasChild('config' . DIRECTORY_SEPARATOR . 'local.config.php'));
+
+               $this->assertConfig(['config' => ['hostname' => 'friendica.local'], 'system' => ['url' => 'http://friendica.local', 'ssl_policy' => 0, 'urlPath' => '']], false, true, true, true);
        }
 
+       /**
+        * Test the automatic installation with a prepared config file
+        * @dataProvider dataInstaller
+        */
+       public function testWithConfig(array $data)
+       {
+               $this->mockConnect(true, 1);
+               $this->mockConnected(true, 1);
+               $this->mockExistsTable('user', false, 1);
+               $this->mockUpdate([$this->root->url(), false, true, true], null, 1);
+
+               $conf = function ($cat, $key) use ($data) {
+                       if ($cat == 'database' && $key == 'hostname' && !empty($data['database']['port'])) {
+                               return $data[$cat][$key] . ':' . $data['database']['port'];
+                       }
+                       return $data[$cat][$key];
+               };
+
+               $config = <<<CONF
+<?php
+
+// Local configuration
+
+// If you're unsure about what any of the config keys below do, please check the config/defaults.config.php for detailed
+// documentation of their data type and behavior.
+
+return [
+       'database' => [
+               'hostname' => '{$conf('database', 'hostname')}',
+               'username' => '{$conf('database', 'username')}',
+               'password' => '{$conf('database', 'password')}',
+               'database' => '{$conf('database', 'database')}',
+               'charset' => 'utf8mb4',
+       ],
+
+       // ****************************************************************
+       // The configuration below will be overruled by the admin panel.
+       // Changes made below will only have an effect if the database does
+       // not contain any configuration for the friendica system.
+       // ****************************************************************
+
+       'config' => [
+               'admin_email' => '{$conf('config', 'admin_email')}',
+               'hostname' => '{$conf('config', 'hostname')}',
+               'sitename' => 'Friendica Social Network',
+               'register_policy' => \Friendica\Module\Register::OPEN,
+               'register_text' => '',
+       ],
+       'system' => [
+               'basepath' => '{$conf('system', 'basepath')}',
+               'urlpath' => '{$conf('system', 'urlpath')}',
+               'url' => '{$conf('system', 'url')}',
+               'ssl_policy' => '{$conf('system', 'ssl_policy')}',
+               'default_timezone' => '{$conf('system', 'default_timezone')}',
+               'language' => '{$conf('system', 'language')}',
+       ],
+];
+CONF;
+
+               vfsStream::newFile('prepared.config.php')
+                       ->at($this->root)
+                       ->setContent($config);
+
+               $console = new AutomaticInstallation($this->consoleArgv);
+               $console->setOption('f', 'prepared.config.php');
+
+               $txt = $this->dumpExecute($console);
+
+               $this->assertFinished($txt, false, true);
+
+               $this->assertTrue($this->root->hasChild('config' . DIRECTORY_SEPARATOR . 'local.config.php'));
+               $this->assertEquals($config, file_get_contents($this->root->getChild('config' . DIRECTORY_SEPARATOR . 'local.config.php')->url()));
+
+               $this->assertConfig($data, true, false, false);
+       }
 
        /**
-        * @medium
+        * Test the automatic installation with environment variables
+        * Includes saving the DB credentials to the file
+        * @dataProvider dataInstaller
         */
-       public function testWithEnvironmentWithoutSave()
+       public function testWithEnvironmentAndSave(array $data)
        {
-               $this->assertTrue(putenv('FRIENDICA_ADMIN_MAIL=admin@friendica.local'));
-               $this->assertTrue(putenv('FRIENDICA_TZ=Europe/Berlin'));
-               $this->assertTrue(putenv('FRIENDICA_LANG=de'));
-               $this->assertTrue(putenv('FRIENDICA_URL_PATH=/friendica'));
+               $this->mockConnect(true, 1);
+               $this->mockConnected(true, 1);
+               $this->mockExistsTable('user', false, 1);
+               $this->mockUpdate([$this->root->url(), false, true, true], null, 1);
 
-               $txt = $this->execute(['autoinstall']);
+               $this->mockGetMarkupTemplate('local.config.tpl', 'testTemplate', 1);
+               $this->mockReplaceMacros('testTemplate', \Mockery::any(), false, '', 1);
 
-               $this->assertFinished($txt, true);
+               $this->assertTrue(putenv('MYSQL_HOST='     . $data['database']['hostname']));
+               $this->assertTrue(putenv('MYSQL_PORT='     . $data['database']['port']));
+               $this->assertTrue(putenv('MYSQL_DATABASE=' . $data['database']['database']));
+               $this->assertTrue(putenv('MYSQL_USERNAME=' . $data['database']['username']));
+               $this->assertTrue(putenv('MYSQL_PASSWORD=' . $data['database']['password']));
+
+               $this->assertTrue(putenv('FRIENDICA_HOSTNAME='   . $data['config']['hostname']));
+               $this->assertTrue(putenv('FRIENDICA_BASE_PATH='  . $data['system']['basepath']));
+               $this->assertTrue(putenv('FRIENDICA_URL='        . $data['system']['url']));
+               $this->assertTrue(putenv('FRIENDICA_PHP_PATH='   . $data['config']['php_path']));
+               $this->assertTrue(putenv('FRIENDICA_ADMIN_MAIL=' . $data['config']['admin_email']));
+               $this->assertTrue(putenv('FRIENDICA_TZ='         . $data['system']['default_timezone']));
+               $this->assertTrue(putenv('FRIENDICA_LANG='       . $data['system']['language']));
 
-               $this->assertTrue($this->root->hasChild('config' . DIRECTORY_SEPARATOR . 'local.ini.php'));
+               $console = new AutomaticInstallation($this->consoleArgv);
+               $console->setOption('savedb', true);
 
-               $this->assertConfig('database', 'hostname', '');
-               $this->assertConfig('database', 'username', '');
-               $this->assertConfig('database', 'database', '');
-               $this->assertConfig('config', 'admin_email', 'admin@friendica.local');
-               $this->assertConfig('system', 'default_timezone', 'Europe/Berlin');
-               $this->assertConfig('system', 'language', 'de');
-               $this->assertConfig('system', 'url_path', '/friendica');
+               $txt = $this->dumpExecute($console);
+
+               $this->assertFinished($txt, true);
+               $this->assertConfig($data, true, true, false, true);
        }
 
        /**
-        * @medium
+        * Test the automatic installation with environment variables
+        * Don't save the db credentials to the file
+        * @dataProvider dataInstaller
         */
-       public function testWithArguments()
+       public function testWithEnvironmentWithoutSave(array $data)
        {
-               $args = ['autoinstall'];
-               array_push($args, '--dbhost');
-               array_push($args, $this->db_host);
-               array_push($args, '--dbuser');
-               array_push($args, $this->db_user);
-               if (!empty($this->db_pass)) {
-                       array_push($args, '--dbpass');
-                       array_push($args, $this->db_pass);
-               }
-               if (!empty($this->db_port)) {
-                       array_push($args, '--dbport');
-                       array_push($args, $this->db_port);
-               }
-               array_push($args, '--dbdata');
-               array_push($args, $this->db_data);
+               $this->mockConnect(true, 1);
+               $this->mockConnected(true, 1);
+               $this->mockExistsTable('user', false, 1);
+               $this->mockUpdate([$this->root->url(), false, true, true], null, 1);
+
+               $this->mockGetMarkupTemplate('local.config.tpl', 'testTemplate', 1);
+               $this->mockReplaceMacros('testTemplate', \Mockery::any(), false, '', 1);
+
+               $this->assertTrue(putenv('MYSQL_HOST=' . $data['database']['hostname']));
+               $this->assertTrue(putenv('MYSQL_PORT=' . $data['database']['port']));
+               $this->assertTrue(putenv('MYSQL_DATABASE=' . $data['database']['database']));
+               $this->assertTrue(putenv('MYSQL_USERNAME=' . $data['database']['username']));
+               $this->assertTrue(putenv('MYSQL_PASSWORD=' . $data['database']['password']));
 
-               array_push($args, '--admin');
-               array_push($args, 'admin@friendica.local');
-               array_push($args, '--tz');
-               array_push($args, 'Europe/Berlin');
-               array_push($args, '--lang');
-               array_push($args, 'de');
+               $this->assertTrue(putenv('FRIENDICA_HOSTNAME='   . $data['config']['hostname']));
+               $this->assertTrue(putenv('FRIENDICA_BASE_PATH='  . $data['system']['basepath']));
+               $this->assertTrue(putenv('FRIENDICA_URL='        . $data['system']['url']));
+               $this->assertTrue(putenv('FRIENDICA_PHP_PATH='   . $data['config']['php_path']));
+               $this->assertTrue(putenv('FRIENDICA_ADMIN_MAIL=' . $data['config']['admin_email']));
+               $this->assertTrue(putenv('FRIENDICA_TZ='         . $data['system']['default_timezone']));
+               $this->assertTrue(putenv('FRIENDICA_LANG='       . $data['system']['language']));
 
-               array_push($args, '--urlpath');
-               array_push($args, '/friendica');
+               $console = new AutomaticInstallation($this->consoleArgv);
 
-               $txt = $this->execute($args);
+               $txt = $this->dumpExecute($console);
 
                $this->assertFinished($txt, true);
+               $this->assertConfig($data, false, true, false, true);
+       }
 
-               $this->assertTrue($this->root->hasChild('config' . DIRECTORY_SEPARATOR . 'local.ini.php'));
+       /**
+        * Test the automatic installation with arguments
+        * @dataProvider dataInstaller
+        */
+       public function testWithArguments(array $data)
+       {
+               $this->mockConnect(true, 1);
+               $this->mockConnected(true, 1);
+               $this->mockExistsTable('user', false, 1);
+               $this->mockUpdate([$this->root->url(), false, true, true], null, 1);
+
+               $this->mockGetMarkupTemplate('local.config.tpl', 'testTemplate', 1);
+               $this->mockReplaceMacros('testTemplate', \Mockery::any(), false, '', 1);
+
+               $console = new AutomaticInstallation($this->consoleArgv);
+
+               $option = function($var, $cat, $key) use ($data, $console) {
+                       if (!empty($data[$cat][$key])) {
+                               $console->setOption($var, $data[$cat][$key]);
+                       }
+               };
+               $option('dbhost'    , 'database', 'hostname');
+               $option('dbport'    , 'database', 'port');
+               $option('dbuser'    , 'database', 'username');
+               $option('dbpass'    , 'database', 'password');
+               $option('dbdata'    , 'database', 'database');
+               $option('url'       , 'system'  , 'url');
+               $option('phppath'   , 'config'  , 'php_path');
+               $option('admin'     , 'config'  , 'admin_email');
+               $option('tz'        , 'system'  , 'default_timezone');
+               $option('lang'      , 'system'  , 'language');
+               $option('basepath'  , 'system'  , 'basepath');
+
+               $txt = $this->dumpExecute($console);
 
-               $this->assertConfig('database', 'hostname', $this->db_host . (!empty($this->db_port) ? ':' . $this->db_port : ''));
-               $this->assertConfig('database', 'username', $this->db_user);
-               $this->assertConfig('database', 'database', $this->db_data);
-               $this->assertConfig('config', 'admin_email', 'admin@friendica.local');
-               $this->assertConfig('system', 'default_timezone', 'Europe/Berlin');
-               $this->assertConfig('system', 'language', 'de');
-               $this->assertConfig('system', 'url_path', '/friendica');
+               $this->assertFinished($txt, true);
+               $this->assertConfig($data, true, true, true, true);
        }
 
+       /**
+        * Test the automatic installation with a wrong database connection
+        */
        public function testNoDatabaseConnection()
        {
-               $this->assertTrue(putenv('MYSQL_USERNAME='));
-               $this->assertTrue(putenv('MYSQL_PASSWORD='));
-               $this->assertTrue(putenv('MYSQL_DATABASE='));
+               $this->mockConnect(false, 1);
+
+               $this->mockGetMarkupTemplate('local.config.tpl', 'testTemplate', 1);
+               $this->mockReplaceMacros('testTemplate', \Mockery::any(), false, '', 1);
+
+               $console = new AutomaticInstallation($this->consoleArgv);
+               $console->setOption('url', 'http://friendica.local');
 
-               $txt = $this->execute(['autoinstall']);
+               $txt = $this->dumpExecute($console);
 
                $this->assertStuckDB($txt);
+               $this->assertTrue($this->root->hasChild('config' . DIRECTORY_SEPARATOR . 'local.config.php'));
+
+               $this->assertConfig(['config' => ['hostname' => 'friendica.local'], 'system' => ['url' => 'http://friendica.local', 'ssl_policy' => 0, 'urlpath' => '']], false, true, false, true);
        }
 
        public function testGetHelp()
@@ -288,7 +589,7 @@ Synopsis
        bin/console autoinstall [-h|--help|-?] [-v] [-a] [-f]
 
 Description
-    Installs Friendica with data based on the local.ini.php file or environment variables
+    Installs Friendica with data based on the local.config.php file or environment variables
 
 Notes
     Not checking .htaccess/URL-Rewrite during CLI installation.
@@ -297,18 +598,18 @@ Options
     -h|--help|-?            Show help information
     -v                      Show more debug information.
     -a                      All setup checks are required (except .htaccess)
-    -f|--file <config>      prepared config file (e.g. "config/local.ini.php" itself) which will override every other config option - except the environment variables)
-    -s|--savedb             Save the DB credentials to the file (if environment variables is used)
-    -H|--dbhost <host>      The host of the mysql/mariadb database (env MYSQL_HOST)
-    -p|--dbport <port>      The port of the mysql/mariadb database (env MYSQL_PORT)
-    -d|--dbdata <database>  The name of the mysql/mariadb database (env MYSQL_DATABASE)
-    -U|--dbuser <username>  The username of the mysql/mariadb database login (env MYSQL_USER or MYSQL_USERNAME)
-    -P|--dbpass <password>  The password of the mysql/mariadb database login (env MYSQL_PASSWORD)
-    -b|--urlpath <url_path> The URL path of Friendica - f.e. '/friendica' (env FRIENDICA_URL_PATH
-    -b|--phppath <php_path> The path of the PHP binary (env FRIENDICA_PHP_PATH) 
-    -A|--admin <mail>       The admin email address of Friendica (env FRIENDICA_ADMIN_MAIL)
-    -T|--tz <timezone>      The timezone of Friendica (env FRIENDICA_TZ)
-    -L|--lang <language>    The language of Friendica (env FRIENDICA_LANG)
+    -f|--file <config>      prepared config file (e.g. "config/local.config.php" itself) which will override every other config option - except the environment variables)
+    -s|--savedb               Save the DB credentials to the file (if environment variables is used)
+    -H|--dbhost <host>        The host of the mysql/mariadb database (env MYSQL_HOST)
+    -p|--dbport <port>        The port of the mysql/mariadb database (env MYSQL_PORT)
+    -d|--dbdata <database>    The name of the mysql/mariadb database (env MYSQL_DATABASE)
+    -U|--dbuser <username>    The username of the mysql/mariadb database login (env MYSQL_USER or MYSQL_USERNAME)
+    -P|--dbpass <password>    The password of the mysql/mariadb database login (env MYSQL_PASSWORD)
+    -U|--url <url>            The full base URL of Friendica - f.e. 'https://friendica.local/sub' (env FRIENDICA_URL
+    -B|--phppath <php_path>   The path of the PHP binary (env FRIENDICA_PHP_PATH)
+    -b|--basepath <base_path> The basepath of Friendica (env FRIENDICA_BASE_PATH)
+    -t|--tz <timezone>        The timezone of Friendica (env FRIENDICA_TZ)
+    -L|--lang <language>      The language of Friendica (env FRIENDICA_LANG)
  
 Environment variables
    MYSQL_HOST                  The host of the mysql/mariadb database (mandatory if mysql and environment is used)
@@ -316,26 +617,30 @@ Environment variables
    MYSQL_USERNAME|MYSQL_USER   The username of the mysql/mariadb database login (MYSQL_USERNAME is for mysql, MYSQL_USER for mariadb)
    MYSQL_PASSWORD              The password of the mysql/mariadb database login
    MYSQL_DATABASE              The name of the mysql/mariadb database
-   FRIENDICA_URL_PATH          The URL path of Friendica (f.e. '/friendica')
-   FRIENDICA_PHP_PATH          The path of the PHP binary
+   FRIENDICA_URL               The full base URL of Friendica - f.e. 'https://friendica.local/sub'
+   FRIENDICA_PHP_PATH          The path of the PHP binary - leave empty for auto detection
+   FRIENDICA_BASE_PATH         The basepath of Friendica - leave empty for auto detection
    FRIENDICA_ADMIN_MAIL        The admin email address of Friendica (this email will be used for admin access)
    FRIENDICA_TZ                The timezone of Friendica
    FRIENDICA_LANG              The langauge of Friendica
    
 Examples
-       bin/console autoinstall -f 'input.ini.php
-               Installs Friendica with the prepared 'input.ini.php' file
+       bin/console autoinstall -f 'input.config.php
+               Installs Friendica with the prepared 'input.config.php' file
 
        bin/console autoinstall --savedb
-               Installs Friendica with environment variables and saves them to the 'config/local.ini.php' file
+               Installs Friendica with environment variables and saves them to the 'config/local.config.php' file
 
        bin/console autoinstall -h localhost -p 3365 -U user -P passwort1234 -d friendica
                Installs Friendica with a local mysql database with credentials
 
 HELP;
 
-               $txt = $this->execute(['autoinstall', '-h']);
+               $console = new AutomaticInstallation($this->consoleArgv);
+               $console->setOption('help', true);
+
+               $txt = $this->dumpExecute($console);
 
-               $this->assertEquals($txt, $theHelp);
+               $this->assertEquals($theHelp, $txt);
        }
 }