aboutsummaryrefslogtreecommitdiffstats
path: root/lib/setup/mysql.php
diff options
context:
space:
mode:
authorThomas Müller <thomas.mueller@tmit.eu>2013-09-25 13:36:30 +0200
committerThomas Müller <thomas.mueller@tmit.eu>2013-09-30 16:36:59 +0200
commit9c9dc276b7a1d2592c4fb0a887888632dc1f1e29 (patch)
treebbe3aed3e09c31c68806bdb8acffef70ba08f51c /lib/setup/mysql.php
parenta711399e62d5a9f14d4b748efe4354ee37e61f13 (diff)
downloadnextcloud-server-9c9dc276b7a1d2592c4fb0a887888632dc1f1e29.tar.gz
nextcloud-server-9c9dc276b7a1d2592c4fb0a887888632dc1f1e29.zip
move the private namespace OC into lib/private - OCP will stay in lib/public
Conflicts: lib/private/vcategories.php
Diffstat (limited to 'lib/setup/mysql.php')
-rw-r--r--lib/setup/mysql.php95
1 files changed, 0 insertions, 95 deletions
diff --git a/lib/setup/mysql.php b/lib/setup/mysql.php
deleted file mode 100644
index d97b6d2602f..00000000000
--- a/lib/setup/mysql.php
+++ /dev/null
@@ -1,95 +0,0 @@
-<?php
-
-namespace OC\Setup;
-
-class MySQL extends AbstractDatabase {
- public $dbprettyname = 'MySQL';
-
- public function setupDatabase($username) {
- //check if the database user has admin right
- $connection = @mysql_connect($this->dbhost, $this->dbuser, $this->dbpassword);
- if(!$connection) {
- throw new \DatabaseSetupException($this->trans->t('MySQL username and/or password not valid'),
- $this->trans->t('You need to enter either an existing account or the administrator.'));
- }
- $oldUser=\OC_Config::getValue('dbuser', false);
-
- //this should be enough to check for admin rights in mysql
- $query="SELECT user FROM mysql.user WHERE user='$this->dbuser'";
- if(mysql_query($query, $connection)) {
- //use the admin login data for the new database user
-
- //add prefix to the mysql user name to prevent collisions
- $this->dbuser=substr('oc_'.$username, 0, 16);
- if($this->dbuser!=$oldUser) {
- //hash the password so we don't need to store the admin config in the config file
- $this->dbpassword=\OC_Util::generateRandomBytes(30);
-
- $this->createDBUser($connection);
-
- \OC_Config::setValue('dbuser', $this->dbuser);
- \OC_Config::setValue('dbpassword', $this->dbpassword);
- }
-
- //create the database
- $this->createDatabase($connection);
- }
- else {
- if($this->dbuser!=$oldUser) {
- \OC_Config::setValue('dbuser', $this->dbuser);
- \OC_Config::setValue('dbpassword', $this->dbpassword);
- }
-
- //create the database
- $this->createDatabase($connection);
- }
-
- //fill the database if needed
- $query='select count(*) from information_schema.tables'
- ." where table_schema='".$this->dbname."' AND table_name = '".$this->tableprefix."users';";
- $result = mysql_query($query, $connection);
- if($result) {
- $row=mysql_fetch_row($result);
- }
- if(!$result or $row[0]==0) {
- \OC_DB::createDbFromStructure($this->dbDefinitionFile);
- }
- mysql_close($connection);
- }
-
- private function createDatabase($connection) {
- $name = $this->dbname;
- $user = $this->dbuser;
- //we cant use OC_BD functions here because we need to connect as the administrative user.
- $query = "CREATE DATABASE IF NOT EXISTS `$name`";
- $result = mysql_query($query, $connection);
- if(!$result) {
- $entry = $this->trans->t('DB Error: "%s"', array(mysql_error($connection))) . '<br />';
- $entry .= $this->trans->t('Offending command was: "%s"', array($query)) . '<br />';
- \OC_Log::write('setup.mssql', $entry, \OC_Log::WARN);
- }
- $query="GRANT ALL PRIVILEGES ON `$name` . * TO '$user'";
-
- //this query will fail if there aren't the right permissions, ignore the error
- mysql_query($query, $connection);
- }
-
- private function createDBUser($connection) {
- $name = $this->dbuser;
- $password = $this->dbpassword;
- // we need to create 2 accounts, one for global use and one for local user. if we don't specify the local one,
- // the anonymous user would take precedence when there is one.
- $query = "CREATE USER '$name'@'localhost' IDENTIFIED BY '$password'";
- $result = mysql_query($query, $connection);
- if (!$result) {
- throw new \DatabaseSetupException($this->trans->t("MySQL user '%s'@'localhost' exists already.", array($name)),
- $this->trans->t("Drop this user from MySQL", array($name)));
- }
- $query = "CREATE USER '$name'@'%' IDENTIFIED BY '$password'";
- $result = mysql_query($query, $connection);
- if (!$result) {
- throw new \DatabaseSetupException($this->trans->t("MySQL user '%s'@'%%' already exists", array($name)),
- $this->trans->t("Drop this user from MySQL."));
- }
- }
-}