• Topic
  • Discussion
  • ODS.OdsIntegrationphpBB(Last) -- DAVWikiAdmin? , 2018-04-05 15:56:43 Edit WebDAV System Administrator 2018-04-05 15:56:43

    ODS Integration of phpBB

    What is phpBB?

    phpBB is the most famous Open Source product for online forums. Here you can find instructions how to use Virtuoso Database for hosting phpBB tables, and use it as Application Server with php hosting.

    Install VAD

    1. Start virtuoso db using the hosting_php.so ( .dll for win users). In oder to use this plugin, it needs to be included in your virtuoso ini file as follows:

      ... [Plugins] # for ex. here the location of the plugins is the plugin folder LoadPath = ./plugin ... Load6 = Hosting,hosting_php.so ...

      • Notes: Make sure you have the following line in your virtuoso.ini section [Parameters] (for instance that is used for phpBB database). If not set phpBB would not work correct with the Virtuoso DB:

        PrefixResultNames = 0

    2. Setup "Local Virtuoso" DSN (note the empty space in the name!) in order to access any of the application URLs.
      • For windows users, please perform the following steps:
        1. Go to Start >> Settings >> Control Panel >> Administrative Tools >> Data Sources (ODBC)
        2. Go to tab "User DSN" and click "Add"
        3. Select the "OpenLink? Virtuoso (version)" driver and click "Finish"
        4. Enter "Name": Local Virtuoso
        5. Enter "Description": My Local Virtuoso
        6. For "Server", enter your Virtuoso's hostname and ISQL port, e.g., localhost:1116
        7. Click "Next"
        8. Enter a username for "Login ID", e.g., dba
        9. Enter the user's "Password". For dba, the default password is dba
        10. Click "Next"
        11. Click "Finish".
    3. Installing packages:
      1. Using ISQL:
        1. Install the ODS ods_framework_dav.vad package:

          DB.DBA.VAD_INSTALL('tmp/ods_framework_dav.vad',0);

        2. Install the phpBB3 phpBB3_fs.vad package:

          SQL> DB.DBA.VAD_INSTALL('tmp/phpBB3_fs.vad',0);

      2. Using Conductor UI:
        • For more information see here.

    Linked Data View Scripts

    • You can find the phpBB3 Linked Data View scripts here. Note that they are included in the phpBB3 package.

    Configuration

    1. In case you want to change the dba password, you need to locate the file below in your FS and change the $dbpasswd value:

      vad\vsp\phpBB3\config.php

      • Important: In the config.php file leave the tables prefix to default "phpbb_" as well as $dbuser.

    phpBB3 Administration

    • For more information see here .

    phpBB3 and ODS Newsgroups

    1. Install the ODS Discussion ods_discussion_dav.vad package. For ex. from ISQL:

      SQL>DB.DBA.VAD_INSTALL('tmp/ods_discussion_dav.vad',0);

    2. phpBB-news-create_procedures.sql: create procedures which are needed later:

      isql localhost:1116 dba dba phpBB-news-create_procedures.sql

    3. phpBB-news-fill_tables.sql: modifies the phpBB tables and fills them with data from Virtuoso News tables and ODS tables:

      isql localhost:1116 phpBB-news-fill_tables.sql

    4. phpBB-news-create_triggers.sql : creates the triggers which will sync the data between phpBB and Virtuoso news tables:

      isql localhost:1116 phpBB-news-create_triggers.sql

    5. In order to make new news groups or to subscribe to other servers you should use the admin or Conductor UI:
      1. From ISQL install the Conductor conductor_dav.vad package:

        DB.DBA.VAD_INSTALL('tmp/conductor_dav.vad',0);

      2. Go to http://host:port/conductor
      3. Login as dba and go to NNTP:
      4. Enter Server Address, port and if needed user name and password and click the button "Add".
      5. Click the server address link
      6. Click the "Subscribe to newsgroups" link.
      7. Click the Subscribe link for Group name
      8. As result the group will be shown in the list of "Subscribed groups for ..." Click its Newsgroup name link.
      9. As result will be shown the page with information about the newsgroup and the messages that have been retrieved.
    6. Register in ODS. Then with the created account you will be able to log in at phpBB3 UI:
      1. Go to http://host:port/ods
      2. Click the "Sign Up" link
      3. Enter in the shown form Login Name, etc, and click the "Sign Up" button.
    7. Access the phpBB3 home page: http://host:port/phpBB3
    8. Click the Login link and enter the user name and pwd you have entered when registering in ODS:
    9. As result you will be successfully logged in to the phpBB3 UI.
    10. Click the link of the forum with name "Your first forum".
    11. Click the "new topic" button
    12. Enter in the form in the Subject and text-area fields some values and click the "Submit" button.
    13. As result your topic will be created.

    Newsgroup support available

    In case you have installed the ODS Discussion ods_discussion_dav.vad package, executed the 3 files as described above and added a newsgroup from Conductor, then:

    1. Access the phpBB3 home page: http://host:port/phpBB3:
    2. As result will be shown the phpBB3 UI with list of the subscribed for NewsGroups?. Click the Login link and enter the user name and pwd you have entered when registering in ODS:
    3. As result you will be successfully logged in to the phpBB3 UI.
    4. Click on the newsgroup name link.
    5. As result will be shown the posts for this newsgroup. Click the "Post a new topic" link.
    6. Enter in the form in the Subject and text-area fields some values and click the "Submit" button.
    7. As result your topic will be created.
    8. You can view your post also from the ODS UI:
      1. Go to http://host:port/ods and login as ODS user.
      2. Go to ODS->Discussions
      3. Click the link "Discussions"
      4. Click the link "List" for the newsgroup you have posted your message to.
      5. Click the Read link for your message shown at the top of the messages list.
      6. As result your message details will be shown.

    URI Schemes


    http://<your-instance-cname>/phpBB3/user/<ods-user-id>
    

    Download

    • You can download the phpBB3 VAD package from here.

    References

    See Also

    Related

    CategorySPARQL CategorySIOC CategoryODS CategoryWebSite