/** * Creates database object based on form data. * * @return array The database connection info. Can be passed into Piwik::createDatabaseObject. */ public function createDatabaseObject() { $dbname = $this->getSubmitValue('dbname'); if (empty($dbname)) { throw new Exception("No database name"); } $adapter = $this->getSubmitValue('adapter'); $port = Piwik_Db_Adapter::getDefaultPortForAdapter($adapter); $dbInfos = array('host' => $this->getSubmitValue('host'), 'username' => $this->getSubmitValue('username'), 'password' => $this->getSubmitValue('password'), 'dbname' => $dbname, 'tables_prefix' => $this->getSubmitValue('tables_prefix'), 'adapter' => $adapter, 'port' => $port); if (($portIndex = strpos($dbInfos['host'], '/')) !== false) { // unix_socket=/path/sock.n $dbInfos['port'] = substr($dbInfos['host'], $portIndex); $dbInfos['host'] = ''; } else { if (($portIndex = strpos($dbInfos['host'], ':')) !== false) { // host:port $dbInfos['port'] = substr($dbInfos['host'], $portIndex + 1); $dbInfos['host'] = substr($dbInfos['host'], 0, $portIndex); } } try { @Piwik::createDatabaseObject($dbInfos); } catch (Zend_Db_Adapter_Exception $e) { $db = Piwik_Db_Adapter::factory($adapter, $dbInfos, $connect = false); // database not found, we try to create it if ($db->isErrNo($e, '1049')) { $dbInfosConnectOnly = $dbInfos; $dbInfosConnectOnly['dbname'] = null; @Piwik::createDatabaseObject($dbInfosConnectOnly); @Piwik::createDatabase($dbInfos['dbname']); // select the newly created database @Piwik::createDatabaseObject($dbInfos); } else { throw $e; } } return $dbInfos; }
/** * Installation Step 3: Database Set-up */ function databaseSetup() { $this->checkPreviousStepIsValid( __FUNCTION__ ); // case the user hits the back button $this->session->skipThisStep = array( 'firstWebsiteSetup' => false, 'displayJavascriptCode' => false, ); $view = new Piwik_Installation_View( $this->pathView . 'databaseSetup.tpl', $this->getInstallationSteps(), __FUNCTION__ ); $this->skipThisStep( __FUNCTION__ ); $view->showNextStep = false; $form = new Piwik_Installation_FormDatabaseSetup(); if($form->validate()) { $adapter = $form->getSubmitValue('adapter'); $port = Piwik_Db_Adapter::getDefaultPortForAdapter($adapter); $dbInfos = array( 'host' => $form->getSubmitValue('host'), 'username' => $form->getSubmitValue('username'), 'password' => $form->getSubmitValue('password'), 'dbname' => $form->getSubmitValue('dbname'), 'tables_prefix' => $form->getSubmitValue('tables_prefix'), 'adapter' => $adapter, 'port' => $port, ); if(($portIndex = strpos($dbInfos['host'], '/')) !== false) { // unix_socket=/path/sock.n $dbInfos['port'] = substr($dbInfos['host'], $portIndex); $dbInfos['host'] = ''; } else if(($portIndex = strpos($dbInfos['host'], ':')) !== false) { // host:port $dbInfos['port'] = substr($dbInfos['host'], $portIndex + 1 ); $dbInfos['host'] = substr($dbInfos['host'], 0, $portIndex); } try{ try { @Piwik::createDatabaseObject($dbInfos); $this->session->databaseCreated = true; } catch (Zend_Db_Adapter_Exception $e) { $db = Piwik_Db_Adapter::factory($adapter, $dbInfos, $connect = false); // database not found, we try to create it if($db->isErrNo($e, '1049')) { $dbInfosConnectOnly = $dbInfos; $dbInfosConnectOnly['dbname'] = null; @Piwik::createDatabaseObject($dbInfosConnectOnly); @Piwik::createDatabase($dbInfos['dbname']); $this->session->databaseCreated = true; } else { throw $e; } } Piwik::checkDatabaseVersion(); $this->session->databaseVersionOk = true; $this->session->db_infos = $dbInfos; $this->redirectToNextStep( __FUNCTION__ ); } catch(Exception $e) { $view->errorMessage = $e->getMessage(); } } $view->addForm($form); echo $view->render(); }
/** * Create database object and connect to database */ public static function createDatabaseObject($dbInfos = null) { $config = Zend_Registry::get('config'); if (is_null($dbInfos)) { $dbInfos = $config->database->toArray(); } Piwik_PostEvent('Reporting.getDatabaseConfig', $dbInfos); $dbInfos['profiler'] = $config->Debug->enable_sql_profiler; $db = null; Piwik_PostEvent('Reporting.createDatabase', $db); if (is_null($db)) { $adapter = $dbInfos['adapter']; $db = @Piwik_Db_Adapter::factory($adapter, $dbInfos); } Zend_Registry::set('db', $db); }