WordPress.org

1. skwamy
   Member
   Posted 1 year ago #

   Hello and thanks already.

   I'm using WP 3.1.1 on my computer (localhost).
   I'm using PHPBB 3 on a '1and1' server.
   And... I'm trying to display the latest topics of this online PHPBB forum on my local WP website (in the sidebar, but it's not important).

   But it doesn't work:
   - When I do it simply (no "Insecure connection"), it tells me "Connection established" but nothings appears (the strange date as others described, and it seems to kill other data in the sidebar: 0 in the recent WP posts for example).
   - When I try the "insecure" thing, I fill my DB user, server and password but it tells me "connectivity to PHPBB failed". So I tried to fill the server blank with its IP address (as described in the README file) but it did not work either.

   So, I'm wondering if connection is possible from a local server.

   I don't know what to do. Please help me, I really need this cool functionality.
   And to finish, another question if it's only because of the local thing: is using the insecure connection required when servers are not the same?

   Maaaaaany thanks.

2. skwamy
   Member
   Posted 1 year ago #

   I forgot to mention that I tried the GRANT requests but 1and1 does not allow its users to make such requests.

3. linickx
   Member
   Posted 1 year ago #

   Hello,

   When I try the "insecure" thing, I fill my DB user, server and password but it tells me "connectivity to PHPBB failed".

   Are you filling in your PHPBB config.php credentials into the boxes?

   Cheers,
   Nick

4. linickx
   Member
   Posted 1 year ago #

   Oh.. I forgot to answer this...

   is using the insecure connection required when servers are not the same?

   Yes :)

5. skwamy
   Member
   Posted 1 year ago #

   Hello,

   Thanks for replying.
   Yes, I'm using the PHPBB credentials to fill the blanks... But it doesn't work :-(
   Now I'm not sure about the line "phpbb MySQL Server". Do I have to put:
   - the address of my PHPBB database: xxxxxxx.1and1.fr ?
   - the IP address of my PHPBB database: 192.xxxxxxxxxx ?
   - the IP address of the server where my PHPBB forum is: 82.xxxxxxx ?

   Thanks!

6. linickx
   Member
   Posted 1 year ago #

   Hello,

   If both wordpress and phpbb are hosted with 1 & 1 it'll probably be the 192.168.xxx address... if wordpress is at home on your laptop and you're connecting to 1&1 it'll be the IP of your mysql db... not necessarily phpbb.

   whatever is the correct IP of the database you'll need to ensure there is no firewall blocking you (TCP/3306) ... and... that the GRANT permissions on the phpbb database server are not restricted to @localhost

   For example, remember when you setup phpbb, you probably did something like this to create your DB and user...

   CREATE DATABASE phpbbdb;
   GRANT ALL PRIVILEGES ON phpbbdb.* TO "phpbbuser"@"localhost" IDENTIFIED BY "mypassword";
   FLUSH PRIVILEGES;

   The @localhost means that you can only log in from the same server that the mysql runs ... you need to replace @localhost with the ip address (or hostname) of the server which wordpress is logging in from.... this again is probably a 192.168 address if the server is in 1&1, if you're at home you'll need to use your public ip ( http://icanhazip.com )

   If you have CLI (Shell / SSH) access to your wordpress server you can test connectivity from the WP server to the PHPBB server with the mysql CLI tool..

   mysql -h mysql_server --user=user_name --password=your_password db_name

   Good luck!

7. spacepets4
   Member
   Posted 11 months ago #

   hi, my WP is installed in wwww.mysite.com and my PHPBB is in http://www.mysite.com/forum

   WP and phpBB are hosted in my ipage hosting service.

   i keep getting "Database Error. Connectivity to phpBB failed." both securely and insecurely... i have read the readme through and fro. lol

   i filled up insecurely as...

   phpbb MySQL Database Name: php_4ec1oli32g
   phpbb MySQL Database UserName: phpOOnlrtIb
   phpbb MySQL Database Password: 9Bhib45UpZ
   phpbb MySQL Server: howtogetfreeiphoneco.ipagemysql.com
   phpbb Topics Table Name: phpbb_topics
   phpbb Forums Table Name: phpbb_forums
   phpbb Posts Table Name: phpbb_posts
   phpbb forum URL: http://www.6stringchickmagnet.com/forum

   is there anything im missing? thanks!!

8. linickx
   Member
   Posted 11 months ago #

   only...

   ensure there is no firewall blocking you (TCP/3306) ... and... that the GRANT permissions on the phpbb database server are not restricted to @localhost

   ;-)

Topic Closed

This topic has been closed to new replies.