64 points
Community rank #871
antman6214
El PresidenteJust Getting Started
MemberLikes (0)
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."
64 pointsCommunity rank #871El PresidenteJust Getting Started
Member
(joined April 2009)
Likes (0)
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', '******');
7430 pointsCommunity rank #7Supreme DeityMember of the MonthLifetime member
Erstwhile founder
(joined May 2007)
Likes (0)
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:
6593 pointsCommunity rank #9Supreme DeityMember of the MonthLifetime member
Keeper of the Dark Chocolate
(joined July 2007)
Likes (0)
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:
64 pointsCommunity rank #871El PresidenteJust Getting Started
Member
(joined April 2009)
Likes (0)
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?
12 pointsCommunity rank #4568SophomoreJust Getting Started
Member
(joined October 2008)
Likes (0)
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 (joined May 2007) Likes (0)
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 (joined April 2009) Likes (0)
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 (joined May 2007) Likes (0)
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 (joined April 2009) Likes (0)
I am still getting the same issue
Erstwhile founder (joined May 2007) Likes (0)
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 (joined April 2009) Likes (0)
Oh.. lol I didn't catch the last part missing. Its working now. Thanks
Member (joined April 2009) Likes (0)
Figures.. Now my Community Tags/Posts dont work..
Member (joined April 2009) Likes (0)
Are the Premium Plugins compatible with the Multi DB Plugin?
Erstwhile founder (joined May 2007) Likes (0)
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 (joined July 2007) Likes (0)
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 (joined April 2009) Likes (0)
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 (joined May 2007) Likes (0)
It's telling WPMU/Multi-DB that those tables are located in your global database.
Thanks,
Andrew
Erstwhile founder (joined May 2007) Likes (0)
Yeh, I'm going to extend the description of each bit/section in db-config.php
Thanks,
Andrew
Member (joined October 2008) Likes (0)
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
Member (joined April 2009) Likes (0)
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