Title: Problem installing
Last modified: August 21, 2016

---

# Problem installing

 *  Resolved [Ruriko](https://wordpress.org/support/users/ruriko/)
 * (@ruriko)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/problem-installing-15/)
 * I followed the installation intructions but activated the plugin and then went
   to ShareBD Mirgration section it gave error: Error: You must configure your database
   settings by adding require(‘./db-settings.php’); to your /var/www/hentaipictures.
   xxx/htdocs/wp-config.php for the migration process to work
 * but I already have `require_once('db-settings.php');` in my wp-config.php file
   so I tried adding `require('./db-settings.php');` but it ended up giving my site
   a blank page. Here’s my db-settings:
 *     ```
       <?php
   
       // If you have multiple datacenters you can come up with your own datacenter
       // detection logic (php_uname?). This helps ensure the web servers try to
       // connect to the nearest database servers first, then distant ones.
       define( 'DATACENTER', '' );
   
       function add_slave($read, $host, $lhost = '', $user = DB_USER, $password = DB_PASSWORD) {
       	global $slaves;
       	$slaves[] = compact('read', 'host', 'lhost', 'user', 'password');
       }
   
       /* Add your configuration here */
   
       /* Use this configuration for a hexidecimal based hash 
   
       Ex. you have 256 databases that follow the naming convention acct_wpmuXX
       where XX is the hexidecimal hash for the blog DB
   
       // how many characters of hexidecimal hash
       $shardb_hash_length = 1;
       // what is the prefix of your blog database shards (everything before the hexidecimal hash)
       $shardb_prefix = 'he_';
       // set a string to be used as an internal identifier for the dataset
       $shardb_dataset = 'hentai_multi';
       // do you want to put your primary blog (blog_id 1) in its own 'home' database?
       $enable_home_db = true;
       // how many, if any, VIP databases do you have?
       $num_vipdbs = 1;
       // add this to set the write master read priority (default 1)
       $shardb_master_read = 99;
       // add this if all of your databases are on a local server
       $shardb_local_db = true;
       // use this function to add a read slave host
       add_slave($read_priority, $hostname, $local_hostname, $user, $password); 
   
       // instructions for adding vip blogs at the bottom of this confg filei
       */
   
       /* That's all, stop editing! Happy blogging. */
   
       if ( !defined('SAVEQUERIES') )
       	define('SAVEQUERIES', false);
   
       /**
        * A trick used by WordPress.com is .lan hostnames mapped to local IPs. Not required.
        *
        * @param unknown_type $hostname
        * @return unknown
        */
       function localize_hostname($hostname) {
       	return str_replace('.com', '.lan', $hostname);
       }
   
       function localize_hostnames($array) {
       	return array_map('localize_hostname', $array);
       }
   
       /**
        * This generates the array of servers.
        *
        * @param string $ds Dataset: the name of the dataset. Just use "global" if you don't need horizontal partitioning.
        * @param int $part Partition: the vertical partition number (1, 2, 3, etc.). Use "0" if you don't need vertical partitioning.
        * @param string $dc Datacenter: where the database server is located. Airport codes are convenient. Use whatever.
        * @param int $read Read order: lower number means use this for more reads. Zero means no reads (e.g. for masters).
        * @param bool $write Write flag: is this server writable?
        * @param string $host Internet address: host:port of server on internet.
        * @param string $lhost Local address: host:port of server for use when in same datacenter. Leave empty if no local address exists.
        * @param string $name Database name.
        * @param string $user Database user.
        * @param string $password Database password.
        */
       function add_db_server($ds, $part, $dc, $read, $write, $host, $lhost, $name, $user, $password) {
       	global $db_servers, $db_ds_parts;
   
       	if ( empty( $lhost ) )
       		$lhost = $host;
   
       	$server = compact('ds', 'part', 'dc', 'read', 'write', 'host', 'lhost', 'name', 'user', 'password');
   
       	$db_servers[$ds][$part][] = $server;
       	$db_ds_parts[$name] = "{$ds}_{$part}";
       }
   
       // Database servers grouped by dataset. (Totally tabular, dude!)
       // R can be 0 (no reads) or a positive integer indicating the order
       // in which to attempt communication (all locals, then all remotes)
   
       //dataset, partition, datacenter, R, W,             internet host:port,     internal network host:port,   database,        user,        password
   
       add_db_server( 'global', 0,    '', 1, 1,    DB_HOST, DB_HOST, $shardb_prefix . 'global', DB_USER, DB_PASSWORD );
       // Next line populates 'global' dataset from wp-config.php for instant compatibility. Remove it when you put your settings here.
       // add_db_server('global', 0,    '', 1, 1,    DB_HOST, DB_HOST, DB_NAME, DB_USER, DB_PASSWORD);
   
       // build the shard dataset
       $have_slaves = is_array($slaves) && (count($slaves) > 0);
       if(isset($shardb_hash_length) && $shardb_hash_length > 0 && $shardb_hash_length < 4 ) {
       	$fmt = "{$shardb_prefix}%0{$shardb_hash_length}x";
       	$shardb_num_db = 1 << ($shardb_hash_length*4);
       	if(!$have_slaves || !isset( $shardb_master_read )) {
       		$shardb_master_read = 1;
       	}
       	for($d=0;$d<$shardb_num_db;$d++) {
       		$db_name = sprintf($fmt, $d);
       		add_db_server($shardb_dataset, $d,  '', 1, $shardb_master_read,  DB_HOST,  DB_HOST, $db_name,  DB_USER,     DB_PASSWORD);
       		if($have_slaves) {
       			foreach($slaves as $s) {
       				add_db_server($shardb_dataset, $d,  '', $s['read'], 0,  $s['host'],  $s['lhost'], $db_name,  $s['user'], $s['password']);
       			}
       		}
       	}
       	$numdbs_added = $shardb_num_db;
   
       	// Enable home db?
           if ($enable_home_db === true) {
               add_db_server($shardb_dataset, $numdbs_added, '', 1, $shardb_master_read, DB_HOST, DB_HOST, $shardb_prefix .'home', DB_USER, DB_PASSWORD);
       		if($have_slaves) {
       			foreach($slaves as $s) {
       				add_db_server($shardb_dataset, $numdbs_added,  '', $s['read'], 0,  $s['host'],  $s['lhost'], $shardb_prefix .'home',  $s['user'], $s['password']);
       			}
       		}
           }
           $numdbs_added++;
       	// VIP databases
           if ( is_numeric($num_vipdbs) and $num_vipdbs > 0 ) {
               for($d=1;$d<=$num_vipdbs;$d++) {
                   add_db_server($shardb_dataset, $numdbs_added, '', 1, $shardb_master_read, DB_HOST, DB_HOST, $shardb_prefix .'vip'. $d, DB_USER, DB_PASSWORD);
       			if($have_slaves) {
       				foreach($slaves as $s) {
       					add_db_server($shardb_dataset, $numdbs_added,  '', $s['read'], 0,  $s['host'],  $s['lhost'], $db_name,  $s['user'], $s['password']);
       				}
       			}
       		   $numdbs_added++;
               }
           }
       }
       /*
       add_db_server(  'misc', 0, 'lax', 1, 1,     'misc.db.example.com:3722',     'misc.db.example.lan:3722',  'wp-misc',  'miscuser',  'miscpassword');
       add_db_server('global', 0, 'nyc', 1, 1,'global.mysql.example.com:3509','global.mysql.example.lan:3509','global-db','globaluser','globalpassword');
       */
   
       /**
        * Map a table to a partition.
        *
        * @param string $table
        * @param string $part
        */
       function add_db_table( $table, $db ) {
       	global $db_tables, $shardb_prefix;
   
       	$db_tables[$table] = $shardb_prefix . $db;
       }
   
       // ** NO DUPLICATE TABLE NAMES ALLOWED **
       // If running with the home DB enabled & a WP 3.0 single install converted to a network add any main site plugin tables here
       // If you want tables to live in a specific database, you can add those here
       // add_db_table( 'wp_misc', 'home' );
       // add_db_table( 'wp_etc', 'vip1' );
       // add_db_table( 'wp_extra', 'vip1' );
   
       /**
        * Map a blog to a custom database. AKA: VIP
        *
        * @param string $blog_id
        * @param string $db
        */
       function add_vip_blog( $blog_id, $db ) {
           global $vip_db, $shardb_prefix;
           $vip_db[$blog_id] = $shardb_prefix . $db;
       }
   
       // Adding a blog to a VIP database is simple.
       // You can put it in whatever VIP DB you want, or even in
       // another user db (like for a penalty box for low traffic blogs.
   
       // Simply use this format:
       // add_vip_blog($blog_id, 'db_name');
   
       // For example, lets say your buddy John needs some extra db love,
       // his blog_id is 24 and you want to put him in the vip3 database.
       // You would add a line below like this:
       //add_vip_blog(24,'vip3'); // John's blog
   
       // That's all there is to it. Plus a comment at the end reminds you of who is who!
   
       // VIP DB's
       if ( $enable_home_db === true )
       	add_vip_blog( 1, 'home' );    // home blog
       ?>
       ```
   
 * [https://wordpress.org/plugins/shardb/](https://wordpress.org/plugins/shardb/)

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [Ron Rennick](https://wordpress.org/support/users/wpmuguru/)
 * (@wpmuguru)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/problem-installing-15/#post-4805321)
 * > but I already have require_once(‘db-settings.php’);
 * Did you add that below the “That’s all, stop editing” line?
 *  Thread Starter [Ruriko](https://wordpress.org/support/users/ruriko/)
 * (@ruriko)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/problem-installing-15/#post-4805338)
 * I have tried both ways either putting above & below the line but I still get 
   Error: You must configure your database settings by adding require(‘./db-settings.
   php’); to your /var/www/hentaipictures.xxx/htdocs/wp-config.php for the migration
   process to work
 * I run Nginx as my webserver
 *  Thread Starter [Ruriko](https://wordpress.org/support/users/ruriko/)
 * (@ruriko)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/problem-installing-15/#post-4805341)
 * Here’s my wp-config.php & also censored my login details
 *     ```
       <?php
       /**
        * The base configurations of the WordPress.
        *
        * This file has the following configurations: MySQL settings, Table Prefix,
        * Secret Keys, WordPress Language, and ABSPATH. You can find more information
        * by visiting {@link http://codex.wordpress.org/Editing_wp-config.php Editing
        * wp-config.php} Codex page. You can get the MySQL settings from your web host.
        *
        * This file is used by the wp-config.php creation script during the
        * installation. You don't have to use the web site, you can just copy this file
        * to "wp-config.php" and fill in the values.
        *
        * @package WordPress
        */
   
       // ** MySQL settings - You can get this info from your web host ** //
       /** The name of the database for WordPress */
       define('DB_NAME', 'he_home');
   
       /** MySQL database username */
       define('DB_USER', '****');
   
       /** MySQL database password */
       define('DB_PASSWORD', '****');
   
       /** MySQL hostname */
       define('DB_HOST', 'localhost');
   
       /** Database Charset to use in creating database tables. */
       define('DB_CHARSET', 'utf8');
   
       /** The Database Collate type. Don't change this if in doubt. */
       define('DB_COLLATE', '');
   
       /**#@+
        * Authentication Unique Keys and Salts.
        *
        * Change these to different unique phrases!
        * You can generate these using the {@link https://api.wordpress.org/secret-key/1.1/salt/ WordPress.org secret-key service}
        * You can change these at any point in time to invalidate all existing cookies. This will force all users to have to log in again.
        *
        * @since 2.6.0
        */
       define('AUTH_KEY',         'put your unique phrase here');
       define('SECURE_AUTH_KEY',  'put your unique phrase here');
       define('LOGGED_IN_KEY',    'put your unique phrase here');
       define('NONCE_KEY',        'put your unique phrase here');
       define('AUTH_SALT',        'put your unique phrase here');
       define('SECURE_AUTH_SALT', 'put your unique phrase here');
       define('LOGGED_IN_SALT',   'put your unique phrase here');
       define('NONCE_SALT',       'put your unique phrase here');
   
       /**#@-*/
   
       /**
        * WordPress Database Table prefix.
        *
        * You can have multiple installations in one database if you give each a unique
        * prefix. Only numbers, letters, and underscores please!
        */
       $table_prefix  = 'hentai_multi_';
   
       /**
        * WordPress Localized Language, defaults to English.
        *
        * Change this to localize WordPress. A corresponding MO file for the chosen
        * language must be installed to wp-content/languages. For example, install
        * de_DE.mo to wp-content/languages and set WPLANG to 'de_DE' to enable German
        * language support.
        */
       define('WPLANG', '');
   
       /**
        * For developers: WordPress debugging mode.
        *
        * Change this to true to enable the display of notices during development.
        * It is strongly recommended that plugin and theme developers use WP_DEBUG
        * in their development environments.
        */
       define('WP_DEBUG', false);
   
       /* Multisite */
       define( 'WP_ALLOW_MULTISITE', true );
   
       define('MULTISITE', true);
       define('SUBDOMAIN_INSTALL', true);
       define('DOMAIN_CURRENT_SITE', 'www.hentaipictures.xxx');
       define('PATH_CURRENT_SITE', '/');
       define('SITE_ID_CURRENT_SITE', 1);
       define('BLOG_ID_CURRENT_SITE', 1);
   
       require('db-settings.php');
       /* That's all, stop editing! Happy blogging. */
   
       /** Absolute path to the WordPress directory. */
       if ( !defined('ABSPATH') )
       	define('ABSPATH', dirname(__FILE__) . '/');
   
       /** Sets up WordPress vars and included files. */
       require_once(ABSPATH . 'wp-settings.php');
       ```
   
 *  Plugin Author [Ron Rennick](https://wordpress.org/support/users/wpmuguru/)
 * (@wpmuguru)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/problem-installing-15/#post-4805388)
 * The sample configuration in the db-settings.php is commented out. Put your settings
   lines below the `*/` after the sample configuration.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Problem installing’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/shardb.svg)
 * [SharDB](https://wordpress.org/plugins/shardb/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/shardb/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/shardb/)
 * [Active Topics](https://wordpress.org/support/plugin/shardb/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/shardb/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/shardb/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [Ron Rennick](https://wordpress.org/support/users/wpmuguru/)
 * Last activity: [12 years, 1 month ago](https://wordpress.org/support/topic/problem-installing-15/#post-4805388)
 * Status: resolved