"Set your $db_url in settings.php like this:
$db_url['default'] = mysql://user:pass@host/dbname
$db_url['wowroster'] = mysql://user:pass@host/dbname"

But it's in the readme file. I searched settings.php for "$db_url", looking for the variable, but it's not there. I have just upgraded to 1.7.3 or WoWRoster, as the readme states that the plugin requires. Do I need to create it? If so, the readme doesn't say this. It implies that it's already there and that it needs to be set up (e.g. - values need to be entered). Also, with this settings file sitting out there with my database's username and password...is this a security risk at all?

Maybe I just don't understand it at all...am I to simply copy the above text, as it is, into Settings.php? If so, where? I know this is just the dev version, but I'm not a developer of Drupal modules, and I just want to get the module set up so my guild can use it. Any help you can provide would be appreciated.

Thanks!

Comments

mosh’s picture

 

With the 'settings.php' i mean your /path/to/drupal/sites/default/settings.php file.

When you first look at /path/to/drupal/sites/default/settings.php you will see something like this in the Database settings section:

$db_url = 'mysql://username:password@localhost/databasename';

You have to change this variable into an array:

$db_url['default'] = 'mysql://username:password@localhost/databasename';
$db_url['wowroster'] = 'mysql://username:password@localhost/databasename';

To get a closer idea how to set it up with multiple databases please have a look at 'How to connect to multiple databases within Drupal'

Hope that this helps you a bit...

regards,
Mosh

mosh’s picture

 

Found it. Line 90. Thanks for the info.
Testing it now...

mosh’s picture

 

I uninstalled the module, edited the settings.php file, then I reinstalled the module and configured it.
I have two or three issues...

I tested an upload of data...
I get the following error:
===============
warning: fsockopen(): php_network_getaddresses: getaddrinfo failed: Non-recoverable failure in name resolution in /hsphere/local/home/wowguild/hordearmy.com/modules/wowroster/wowroster.inc on line 53.
warning: fsockopen(): unable to connect to /roster:80 in /hsphere/local/home/wowguild/hordearmy.com/modules/wowroster/wowroster.inc on line 53.
error...
===============

I also get "Server Not Found" error when I try to visit /wowroster_iframe via the link in my menu.

With regard to the errors above, before I edited the settings.php file, I was getting the same error on data upload, but I was able to view the roster in the iframe via the link that now gives me "Server Not Found".

Here are my settings from the WoWRoster Ingegration Config Page (/admin/settings/wowroster):
WoWRosters Domain: /roster (also tried http://www.hordearmy.com/roster)
WoWRosters Table Prefix: roster_

My WoWRoster database is different than the Drupal database, if that means anything. I stored the data in a separate DB to keep things clean, and just in case I needed to remove all the WoWRoster data at some point in the future.

--------------------------------------------------------------------------------------------------------------------------------------------------
Problem with Menu Items...
The problem now that I noticed is that I cannot change the location of the two menu items:
"WoWRoster"
"WoWRoster Upload"

I have a "Guild Information" menu at the root of the navigation menu system and I want to put these menus under there. The problem is that they do not appear on the /admin/build/menu page. In fact, when I browse to that page, they even disappear from the navigation menu. Is this normal? If I am at the /admin page, I see the menus in the navigation menu. It seems to only be when I go to the /admin/build/menu page that they both disappear.

Thanks for the help with this. If anything, we'll be one of your beta testers and help you find bugs, provided that I am not doing something wrong and causing the bugs myself. :-)

mosh’s picture

 

The issue with not being able to see the member list has been corrected:
"I also get "Server Not Found" error when I try to visit /wowroster_iframe via the link in my menu."
Not sure what the deal was here. Maybe it took a minute for some reason? I could have screwed something up too, I guess. In any case, ignore that one. :-)

mosh’s picture

 

Please ignore my previous post. I am still having the problem. I was confused when I looked at the complete list of players in the guild, which is different from the iframe page.

This is the post: #4 submitted by dmetzcher on March 11, 2007 - 22:12
Ignore. Problem still there with the iframe display.

mosh’s picture

 

Assigned:Unassigned» mosh

I've added subfolder-support to /admin/settings/wowroster.

For the settings you tried in post #3 it should look like this:

  • WoWRosters Domain: www.hordearmy.com
  • WoWRosters subfolder: /roster
  • WoWRosters table prefix: roster_

The menu items are visible on the /admin/build/menu page now and you can put them into your "Guild Information" menu.

Please download the current Development snapshot
-------------------------

If anything, we'll be one of your beta testers and help you find bugs...

Great! :-)

mosh’s picture

 

All issues resolved except the one I have with uploading the data from Character Profiler.
Whether the password is entered or not, here is the new error I get now...

=============================================
HTTP/1.1 500 Internal Server Error Date: Wed, 14 Mar 2007 17:08:31 GMT Server: NOYB Connection: close Transfer-Encoding: chunked Content-Type: text/html; charset=iso-8859-1 259
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@hordearmy.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Apache/1.3.37 Server at hordearmy.com Port 80
0
=============================================

Also, please confirm that I did the right thing with regard to the settings.php file...starting at line 90, I believe.

Old:
=============================================
$db_url = 'mysql://[user]:[pass]@[IP]:[port]/[mainDB]';
$db_prefix = '';
=============================================

New:
=============================================
/**
* $db_url = 'mysql://[user]:[pass]@[IP]:[port]/[mainDB]';
*/
$db_url['default'] = 'mysql://[user]:[pass]@[IP]:[port]/[mainDB]';
$db_url['wowroster'] = 'mysql://[user]:[pass]@[IP]:[port]/[wowrosterDB]';
$db_prefix = '';

=============================================

(I've removed the actual values for the user, password, IP, port, and DBs above, but they are in the file on the server.)

As you can see, I just commented out the original line and replaced it with the two lines that you gave me. Please be gentle... I only have slight knowledge of PHP (though my background is/used to be programming, so very minor code edits in other languages aren't difficult for me if I don't need to know specifics about the language).

Also, I assume that the new fields in the admin page that tie the character names to the users will be used later in future updates. Nothing changed on the http://hordearmy.com/wowroster page. Is that correct? I did run update.php, just to be sure.

Thanks,
Dennis

Simon Georges’s picture

 

Status:Active» Closed (won't fix)

This version of WowRoster Integration is not supported anymore. The issue is closed for this reason.

Please upgrade to a supported version and feel free to reopen the issue on the new version if applicable.

来自 https://www.drupal.org/node/126558