[plugin: phpbb_recent_topics] No connection, no data…

  • 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.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter skwamy

    (@skwamy)

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

    Plugin Author linickx

    (@linickx)

    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

    Plugin Author linickx

    (@linickx)

    Oh.. I forgot to answer this…

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

    Yes ??

    Thread Starter skwamy

    (@skwamy)

    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!

    Plugin Author linickx

    (@linickx)

    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 ( https://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!

    hi, my WP is installed in wwww.mysite.com and my PHPBB is in https://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: https://www.6stringchickmagnet.com/forum

    is there anything im missing? thanks!!

    Plugin Author linickx

    (@linickx)

    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

    ??

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘[plugin: phpbb_recent_topics] No connection, no data…’ is closed to new replies.