http://localhost in php script?

I have a blog (WordPress) and a forum (phpBB). I am using a plug in to try to integrate user log in for both.

The script calls for -

*************
if ( $userdata['session_logged_in'] )
{
$u_login_logout = '../wordpress/wphpbb-login.php?action=logout&redirect_to=http://localhost'. $_SERVER['REQUEST_URI'] . '&sid=' . $userdata['session_id'];//'login.'.$phpEx.'?logout=true&sid=' . $userdata['session_id']
$l_login_logout = $lang['Logout'] . ' [ ' . $userdata['username'] . ' ]';
}
else
{
$u_login_logout = '../wordpress/wphpbb-login.php?&redirect_to=http://localhost'. $_SERVER['REQUEST_URI']; //'login.'.$phpEx;
$l_login_logout = $lang['Login'];
}

****************

I know that normally you have to change "localhost" to "mysql.yourdomain.com"

Would this apply here also?

Edited: Oops! I didn't look at the code closely enough, and gave you a "bum" answer - I'm sorry! No, it doesn't. In the case of defining your MySQL host, you need to replace "localhost" with the appropriate host for your database. In this instance, "localhost" should be replaced with an environment variable to help define paths/urls and, as such, should not have the the name of your MySQL database host substituted for it, rather the varible to represent the path of your server - what Atropos7 said
.

--rlparker

Edited by rlparker on 11/24/06 05:19 PM (server time).

In reply to:

---

I know that normally you have to change "localhost" to "mysql.yourdomain.com"

---

Yes. Obviously one cannot use localhost as the hostname in the URL. You have two options. You can explicitly specify the hostname using your own variable, or implicitly specify it using the superglobal $_SERVER.

For example, one might want to do this:

$redirect_hostname = $_SERVER['SERVER_NAME'] ;
$redirect_path = $_SERVER['REQUEST_URI'];
$redirect_url = 'http://' . $redirect_hostname . $redirect_path;

$u_login_logout = '../wordpress/wphpbb-login.php?action=logout&redirect_to=' . $redirect_url . '&sid=' . $userdata['session_id'];

Edit: It should be obvious but $redirect_hostname should be the hostname of your website.

Atropos | openvein.orgEdited by Atropos7 on 11/24/06 06:14 PM (server time).

How do you know it should be mysql.example.com instead of www.example.com? Just wondering.




tor.eff.org

Good catch on my "bad" advice there... I didn't look at the code closely enough, and have edited my post, *but* I believe in this instance if the OP chooses to define the path explicitly, he needs to use the path of his http server, not his mysql server...or am I completely missing this? (which is certainly possible!)

--rlparker

I should have stated I would need "dummied" down answers. :) The instructions for the plug in said to use the absolute path.

You said I would need to replace "localhost" with the host for my database.

When I created the database, the "hostname" was prepopulated with "mysql.ylice.net". I did not change this.

So, would the path be - http://www.ylice.net/mysql.ylice.net/ ?

I'm sorry for the confusion...I think what should go there is either an environment variable that contains your *domain*, or actual "hardcoding" in your domain, *not* your database host.

In reply to:

---

So, would the path be - http://www.ylice.net/mysql.ylice.net/ ?

---

I think what should go in there is:

http://www.ylice.net/

I believe the code is to handle to routing of pages to your *site*, not interaction with your database (note the other messages in this thread).

What pluy-in are you trying to install?(name - link, etc.)? I'll go take a look and get a better idea of what is involved if you would like for me to.

--rlparker

You're right, he does need to specify the hostname of a HTTP server, in particular the one hosting his web site. I've edited my post as well.

I assumed OP just needed clarification that he needs to modify the script to use a different hostname. I interprated his statement as an observation that one cannot use localhost based on the documentation or experience with using databases.


Atropos | openvein.org

I'm using wphpBB-Login v0.12. It can be found at - http://www.happypoet.com/hackery/wphpbb-login/

I'll try your suggestion. I know just enough to be dangerous.

I used the path to my database earlier and the forum page was OK, but my main site page was blank.

Thanks for your help.

No probelm - we kinda "borked" up giving you a clean-cut answer on your question, and I apologize. I'll go over an take a look at the plug-in, though I think , especially from you last post, that you will be "good to go" with your main site url in place of localhost.

Please post back and let us know how it goes, ok?

--rlparker

Thanks, I will.

I think there are other adjustments I'll need to make. I can't seem to find one set of instructions that gives all the same information.

I have done everything that came with the plug in zip, but I found some additional instructions on his website.

I'm headed to update my "localhost" mistake now.

http://www.ylice.net didn't work.

My main site is still blank.

I"m going to restore everything back to the way it was and see if I can figure it out from a "clean" start.

I'm sorry to hear that...(you *did* clear all your caches, right?) I just went to your site, and it looks good; you must have already "undone it all".

I' looking at the plug-in now, and will post back if I find anything helpful..

--rlparker

I'm giving up. At least for tonight. I put everything back like it was.

This is what the instructions with the plug in said to do -

In reply to:

---

Plugin Name: WphpBB-Login
Plugin URI: http://www.happypoet.com/hackery/wphpbb-login/
Description: Replaces the login system of phpBB and WP to combine the two.
Author: Wilbur Bennett
Version: .09
Author URI: http://www.happypoet.com


WARNING:::: I take no responsibility for destroying everything you have worked hard to set up in your life.

For complete and updated directions go to http://www.happypoet.com/hackery/wphpbb-login/directions/

1) Upload zip in WP Main Folderr.
2) Uncompress zip
3) Move wphpbb-plugin.php to the plugin folder.
4) Modify phpBB and WordPress by putting making get_userdata and make_clickable pluggable.
5) Login to Wordpress Admin.
6) Activate WphpBB-Login.
7) Go to WphpBB-Login Options Page (Under Main Options).
8) Edit Options to Suit being sure to fill in required (Content Blocks if left undefined will be .
9) Save
10) Test WP login to make sure it works.
11) Modify phpBB to use wphpbb-login.php as the login page. (directions in changes to phpBB).
12) Enjoy!

---

I kept getting a blank index page.
1. Done
2. Done
3. Done
4. No clue!
5. Done
6. Done
7. Done
8. Done
9. Done
10. Didn't work.
11. Done - this was my "localhost" question.
12. Not yet!

But, on his website, I also found -

In reply to:

---

WphpBB-Login Directions
Filed under: main — WDuluoz @ 1:42 pm
Before you begin:
BACK UP EVERYTHING THING
Have phpBB and Wordpress running smoothly. (believe me it helps)
DID YOU BACK UP EVERYTHING?
Required:
Download WPHPBB-Login
(upload and unzip files in the main directory of wp).

Edit phpBB and WordPress:
Find function get_userdata in PHPBB (in includes/functions.php line 116 of phpBB 2.0.17):
add before the function
if (!function_exists(get_userdata)) :
and after the funtion
endif;
Find make_clickable both in WP (in wp-includes/functions-formatting.php line 544 of WP 1.5.1.3) and phpBB (in includes/bbcode.php line 617 in phpBB 2.0.17):
add before function
if (!function_exists(make_clickable)) :
and after the function
endif;
The idea is to tell these two functions not to be defined if they are already defined.
The reason is because PHPBB uses get_userdata only to get the user information for admin functions and for profile information. Since we are not doing either of those while in WP, then there should never be a time it is called. While you are in WP, you are using WordPress’s get_userdata and while you are in PHPBB you are using PHPBB’s get_userdata. This should ease some of the burden of installing this script.
PHPBB Login:
Change the path to the login page in phpBB to the file wphpbb-login.php in the WordPress login.
Directions are supplied with both WphpBB and WphpBB-Login. Easier to follow in text form.
Disable Allow Username changes
Unfortunately, WordPress will not allow the user_login to be changed with their wp_update_user function, even though it should. I could force it into the system, but I would rather not. If you dont set it to not allow username changes, then a new user will be created in WP each time the person changes their name.

---

The find function instructions weren't with the plug in I downloaded.

So, I'll try again when my head quits hurting.

I understand...I just spent about 30 minutes digging through the site for the plug-in, and now *my* head is starting to hurt too . The documentation is a "mess", and I'm not real thrilled that installing this plug-in requires editing the "core" files of *both* phpbb and wp. - that should make upgrades (especially important with PhpBB, given its security history!) a real "joy" (not!).

I'm not 100% sure I yet understand a lot of what I've read over there...and I know I'm not sure where the code you supplied was from (wp or phpbb, or the plug-in) - I am 100% sure that the installation seems to be pretty convoluted.

If you feel like giving it a try another time, whay don't you start a new thread, or maybe you can find someone over on the wordpress.org support forum who has installed this puppy on Dreamhost.

It appears from some of the discussion on the author's site that mod_security could be impacting the install also, and that is the "Extra Web Security" check-box setting option for domains (see Edit Domain in the Control Panel).

All in all, not encouraging indeed - and I don't have a spare PHPBB and WP installation laying around to test it with conveniently.

Who knows, maybe it will all look better in the morning..

--rlparker