64 pointsSerious WPMU DEV-sterI'm new here
antman6214
Member
—
8th May 2009 (3 years ago)
Hello, I have gotten all the way through the plguin, all my tables have been moved to the other DBs. But when i try to visit my site i get this ...
"This webpage has a redirect loop.
The webpage at http://mygamescribe.com/wp-signup.php?new=mygamescribe.com has resulted in too many redirects. Clearing your cookies for this site may fix the problem. If not, it is possibly a server configuration issue and not a problem with your computer."
Hello, I have gotten all the way through the plguin, all my tables have been moved to the other DBs. But when i try to visit my site i get this ...
"This webpage has a redirect loop.
The webpage at http://mygamescribe.com/wp-signup.php?new=mygamescribe.com has resulted in too many redirects. Clearing your cookies for this site may fix the problem. If not, it is possibly a server configuration issue and not a problem with your computer."
Hi andrew, Here is the contents of my db-config file.
<?php
// Plugin Name: Multi-DB
// Plugin URI: http://premium.wpmudev.org/project/Multiple-Databases
// Author: Andrew Billits (Incsub)
// Version: 2.7.1
//------------------------------------------------------------------------//
//---DB Scaling-----------------------------------------------------------//
//------------------------------------------------------------------------//
// 16,256,4096
define ('DB_SCALING', '16');
//------------------------------------------------------------------------//
//---DC IPs---------------------------------------------------------------//
//------------------------------------------------------------------------//
// Usage: add_dc_ip(IP, DC)
// EX: add_dc_ip('123.123.123.', 'dc1');
add_dc_ip('localhost', 'dc1');
//------------------------------------------------------------------------//
//---Global Tables--------------------------------------------------------//
//------------------------------------------------------------------------//
// Do not include default global tables
// Leave off base prefix (eg: wp_)
//
// Usage: add_global_table(TABLE_NAME)
// EX: add_global_table('something');
add_global_table('game_scribe_blog');
//------------------------------------------------------------------------//
//---DB Servers-----------------------------------------------------------//
//------------------------------------------------------------------------//
// Database servers grouped by dataset.
// R can be 0 (no reads) or a positive integer indicating the order
// in which to attempt communication (all locals, then all remotes)
//
// Usage: add_db_server(DS, DC, READ, WRITE, HOST, LAN_HOST, NAME, USER, PASS)
// EX: add_db_server('global', 'dc1', 1, 1,'global.mysql.example.com:3509','global.mysql.example.lan:3509', 'global-db', 'globaluser', 'globalpassword');
//
// Note: you can also place this section in a file called db-list.php in wp-content
add_db_server('global', 'dc1', 1, 1,'69.36.175.26','localhost', 'gamescribe_db_global', 'dbadmin', '******');
You have to declare global tables in db-config.php. Every premium plugin that adds a table should come with a sql.txt file. Just add all of the plugin tables like so:
6593 pointsLike some sort of WPMU DEV GodExceptionally helpfulLifetime member
Keeper of the Dark Chocolate
—
9th May 2009 (3 years ago)
#
Every premium plugin that adds a table should come with a sql.txt file.
If I may suggest, putting a line in the install instructions about adding in the line to db-config.php for global installs. Rumor has it that someone forgot it recently. :whistle:
This may be a dumb question, but just confirming... All this is doing is telling Wordpress that all the blogs have access to the tables that i add. correct? Its not actually creating those tables again is it?
We are running into the same error please specify Andrew what you meant by ;
Next, replace IP in your connection lines with 'localhost'.
Hiya,
Just to confirm, you now have the add_dc_ip bit configured as?:
add_dc_ip('69.36.175.', 'dc1');
Next, replace IP in your connection lines with 'localhost'.
Thanks,
Andrew
Responses (15)
Erstwhile founder — 8th May 2009 (3 years ago) #
Hiya,
Can you please copy/paste the content of your db-config.php here with the passwords masked?
If you're using 256 or 4096 databases just post a selection of the connection lines.
Thanks,
Andrew
Member — 8th May 2009 (3 years ago) #
Hi andrew, Here is the contents of my db-config file.
<?php
// Plugin Name: Multi-DB
// Plugin URI: http://premium.wpmudev.org/project/Multiple-Databases
// Author: Andrew Billits (Incsub)
// Version: 2.7.1
//------------------------------------------------------------------------//
//---DB Scaling-----------------------------------------------------------//
//------------------------------------------------------------------------//
// 16,256,4096
define ('DB_SCALING', '16');
//------------------------------------------------------------------------//
//---DC IPs---------------------------------------------------------------//
//------------------------------------------------------------------------//
// Usage: add_dc_ip(IP, DC)
// EX: add_dc_ip('123.123.123.', 'dc1');
add_dc_ip('localhost', 'dc1');
//------------------------------------------------------------------------//
//---Global Tables--------------------------------------------------------//
//------------------------------------------------------------------------//
// Do not include default global tables
// Leave off base prefix (eg: wp_)
//
// Usage: add_global_table(TABLE_NAME)
// EX: add_global_table('something');
add_global_table('game_scribe_blog');
//------------------------------------------------------------------------//
//---DB Servers-----------------------------------------------------------//
//------------------------------------------------------------------------//
// Database servers grouped by dataset.
// R can be 0 (no reads) or a positive integer indicating the order
// in which to attempt communication (all locals, then all remotes)
//
// Usage: add_db_server(DS, DC, READ, WRITE, HOST, LAN_HOST, NAME, USER, PASS)
// EX: add_db_server('global', 'dc1', 1, 1,'global.mysql.example.com:3509','global.mysql.example.lan:3509', 'global-db', 'globaluser', 'globalpassword');
//
// Note: you can also place this section in a file called db-list.php in wp-content
add_db_server('global', 'dc1', 1, 1,'69.36.175.26','localhost', 'gamescribe_db_global', 'dbadmin', '******');
add_db_server('0', 'dc1', 1, 1,'69.36.175.26','localhost', 'gamescribe_db_0', 'dbadmin', '******');
add_db_server('1', 'dc1', 1, 1,'69.36.175.26','localhost', 'gamescribe_db_1', 'dbadmin', '******');
add_db_server('2', 'dc1', 1, 1,'69.36.175.26','localhost', 'gamescribe_db_2', 'dbadmin', '******');
add_db_server('3', 'dc1', 1, 1,'69.36.175.26','localhost', 'gamescribe_db_3', 'dbadmin', '******');
add_db_server('4', 'dc1', 1, 1,'69.36.175.26','localhost', 'gamescribe_db_4', 'dbadmin', '******');
add_db_server('5', 'dc1', 1, 1,'69.36.175.26','localhost', 'gamescribe_db_5', 'dbadmin', '******');
add_db_server('6', 'dc1', 1, 1,'69.36.175.26','localhost', 'gamescribe_db_6', 'dbadmin', '******');
add_db_server('7', 'dc1', 1, 1,'69.36.175.26','localhost', 'gamescribe_db_7', 'dbadmin', '******');
add_db_server('8', 'dc1', 1, 1,'69.36.175.26','localhost', 'gamescribe_db_8', 'dbadmin', '******');
add_db_server('9', 'dc1', 1, 1,'69.36.175.26','localhost', 'gamescribe_db_9', 'dbadmin', '******');
add_db_server('a', 'dc1', 1, 1,'69.36.175.26','localhost', 'gamescribe_db_a', 'dbadmin', '******');
add_db_server('b', 'dc1', 1, 1,'69.36.175.26','localhost', 'gamescribe_db_b', 'dbadmin', '******');
add_db_server('c', 'dc1', 1, 1,'69.36.175.26','localhost', 'gamescribe_db_c', 'dbadmin', '******');
add_db_server('d', 'dc1', 1, 1,'69.36.175.26','localhost', 'gamescribe_db_d', 'dbadmin', '******');
add_db_server('e', 'dc1', 1, 1,'69.36.175.26','localhost', 'gamescribe_db_e', 'dbadmin', '******');
add_db_server('f', 'dc1', 1, 1,'69.36.175.26','localhost', 'gamescribe_db_f', 'dbadmin', '******');
//------------------------------------------------------------------------//
//---VIP Blogs------------------------------------------------------------//
//------------------------------------------------------------------------//
// Usage: add_vip_blog(BLOG_ID, DS)
// EX: add_vip_blog(1, 'vip1');
?>
Erstwhile founder — 8th May 2009 (3 years ago) #
Hiya,
You need to use your actual IP instead of localhost here:
add_dc_ip('localhost', 'dc1');
If your IP is 127.127.127.127:
add_dc_ip('127.127.127.', 'dc1');
Thanks,
Andrew
Member — 8th May 2009 (3 years ago) #
I am still getting the same issue
Erstwhile founder — 8th May 2009 (3 years ago) #
Hiya,
Just to confirm, you now have the add_dc_ip bit configured as?:
add_dc_ip('69.36.175.', 'dc1');
Next, replace IP in your connection lines with 'localhost'.
Thanks,
Andrew
Member — 8th May 2009 (3 years ago) #
Oh.. lol I didn't catch the last part missing. Its working now. Thanks
Member — 8th May 2009 (3 years ago) #
Figures.. Now my Community Tags/Posts dont work..
Member — 8th May 2009 (3 years ago) #
Are the Premium Plugins compatible with the Multi DB Plugin?
Erstwhile founder — 9th May 2009 (3 years ago) #
Hiya,
You have to declare global tables in db-config.php. Every premium plugin that adds a table should come with a sql.txt file. Just add all of the plugin tables like so:
Table name: wp_site_posts
Ex:
add_global_table('site_posts');
Note that I left off the prefix on purpose.
Thanks,
Andrew
Keeper of the Dark Chocolate — 9th May 2009 (3 years ago) #
If I may suggest, putting a line in the install instructions about adding in the line to db-config.php for global installs. Rumor has it that someone forgot it recently. :whistle:
Member — 9th May 2009 (3 years ago) #
This may be a dumb question, but just confirming... All this is doing is telling Wordpress that all the blogs have access to the tables that i add. correct? Its not actually creating those tables again is it?
Erstwhile founder — 9th May 2009 (3 years ago) #
It's telling WPMU/Multi-DB that those tables are located in your global database.
Thanks,
Andrew
Erstwhile founder — 9th May 2009 (3 years ago) #
Yeh, I'm going to extend the description of each bit/section in db-config.php
Thanks,
Andrew
Member — 20th February 2011 (1 year ago) #
We are running into the same error please specify Andrew what you meant by ;
Next, replace IP in your connection lines with 'localhost'.
Hiya,
Just to confirm, you now have the add_dc_ip bit configured as?:
add_dc_ip('69.36.175.', 'dc1');
Next, replace IP in your connection lines with 'localhost'.
Thanks,
Andrew
Sales & Support Lead — 20th February 2011 (1 year ago) #
Hiya Visible.net,
Sometimes these older threads get over-looked by moderators. If you're having an issue, feel free to start up a new thread.
I believe Andrew's referring to the spots in db-config that need to be modified:
-DC IPs
and the values in add_db_server
Hope this helps. If you need anything further, please open a new thread.
Thanks!
Become a member