{"id":13,"date":"2016-01-26T19:56:14","date_gmt":"2016-01-26T19:56:14","guid":{"rendered":"http:\/\/eyga.net\/en\/?p=13"},"modified":"2022-07-01T12:53:20","modified_gmt":"2022-07-01T11:53:20","slug":"how-to-make-phpbb-forum-read-only","status":"publish","type":"post","link":"https:\/\/eyga.net\/en\/2016\/01\/26\/how-to-make-phpbb-forum-read-only\/","title":{"rendered":"How to make phpBB forum read-only"},"content":{"rendered":"

PhpBB forum has an option to disable the forum. In that case no forums and topics are shown.
\nBut what if we want to make the forum read-only. So that anyone can read it and nobody can change the date.<\/p>\n

The solution is to give to the account, which phpBB uses to connect to the database, only SELECT permissions.
\nBut that way you will get errors, because the application wants to write session data, etc. into the database.
\nSo these permission changes must be executed for forum to be fully read-only.<\/p>\n

Create new account ‘read_only’ and make phpBB use it for connecting to database in file ‘config.php’.
\nAnd then execute this code:<\/p>\n

\r\nGRANT SELECT ON `phpbb_db`.* TO 'read_only'@'localhost';\r\nGRANT INSERT, UPDATE, DELETE ON `phpbb_sessions` TO 'read_only'@'localhost';\r\nGRANT INSERT, UPDATE, DELETE ON `phpbb_sessions_keys` TO 'read_only'@'localhost';\r\nGRANT UPDATE (`config_value`) ON `phpbb_config` TO 'read_only'@'localhost';\r\nGRANT UPDATE (`topic_views`, `topic_last_view_time`) ON `phpbb_topics` TO 'read_only'@'localhost';\r\nGRANT UPDATE (`mark_time`) ON `phpbb_topics_track` TO 'read_only'@'localhost';\r\nGRANT UPDATE (`download_count`) ON `phpbb_attachments` TO 'read_only'@'localhost';\r\n-- Admin\r\nGRANT INSERT, DELETE ON `phpbb_login_attempts` TO 'read_only'@'localhost';\r\nGRANT UPDATE ON `phpbb_users` TO 'read_only'@'localhost';\r\nGRANT INSERT ON `phpbb_log` TO 'read_only'@'localhost';\r\n-- Plugin: Advertisement Management\r\nGRANT UPDATE (`ad_views`, `ad_clicks`) ON `phpbb_ads` TO 'read_only'@'localhost';\r\n-- Plugin: phpBB SEO\r\nGRANT UPDATE (`topic_url`) ON `phpbb_topics` TO 'read_only'@'localhost';\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
PhpBB forum has an option to disable the forum. In that case no forums and topics are shown. But what if we want to make the forum read-only. So that anyone can read it and nobody can change the date. The solution is to give to the account, which phpBB uses to connect to the […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-13","post","type-post","status-publish","format-standard","hentry","category-code-snippets"],"yoast_head":"\nHow to make phpBB forum read-only - Eyga.net (EN)<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/eyga.net\/en\/2016\/01\/26\/how-to-make-phpbb-forum-read-only\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to make phpBB forum read-only - Eyga.net (EN)\" \/>\n<meta property=\"og:description\" content=\"PhpBB forum has an option to disable the forum. In that case no forums and topics are shown. But what if we want to make the forum read-only. So that anyone can read it and nobody can change the date. The solution is to give to the account, which phpBB uses to connect to the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/eyga.net\/en\/2016\/01\/26\/how-to-make-phpbb-forum-read-only\/\" \/>\n<meta property=\"og:site_name\" content=\"Eyga.net (EN)\" \/>\n<meta property=\"article:published_time\" content=\"2016-01-26T19:56:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-01T11:53:20+00:00\" \/>\n<meta name=\"author\" content=\"Domen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Domen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/eyga.net\\\/en\\\/2016\\\/01\\\/26\\\/how-to-make-phpbb-forum-read-only\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/eyga.net\\\/en\\\/2016\\\/01\\\/26\\\/how-to-make-phpbb-forum-read-only\\\/\"},\"author\":{\"name\":\"Domen\",\"@id\":\"https:\\\/\\\/eyga.net\\\/en\\\/#\\\/schema\\\/person\\\/4d5bb8efc36970bf82f47ebe7498c366\"},\"headline\":\"How to make phpBB forum read-only\",\"datePublished\":\"2016-01-26T19:56:14+00:00\",\"dateModified\":\"2022-07-01T11:53:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/eyga.net\\\/en\\\/2016\\\/01\\\/26\\\/how-to-make-phpbb-forum-read-only\\\/\"},\"wordCount\":120,\"articleSection\":[\"Code snippets\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/eyga.net\\\/en\\\/2016\\\/01\\\/26\\\/how-to-make-phpbb-forum-read-only\\\/\",\"url\":\"https:\\\/\\\/eyga.net\\\/en\\\/2016\\\/01\\\/26\\\/how-to-make-phpbb-forum-read-only\\\/\",\"name\":\"How to make phpBB forum read-only - Eyga.net (EN)\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/eyga.net\\\/en\\\/#website\"},\"datePublished\":\"2016-01-26T19:56:14+00:00\",\"dateModified\":\"2022-07-01T11:53:20+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/eyga.net\\\/en\\\/#\\\/schema\\\/person\\\/4d5bb8efc36970bf82f47ebe7498c366\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/eyga.net\\\/en\\\/2016\\\/01\\\/26\\\/how-to-make-phpbb-forum-read-only\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/eyga.net\\\/en\\\/2016\\\/01\\\/26\\\/how-to-make-phpbb-forum-read-only\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/eyga.net\\\/en\\\/2016\\\/01\\\/26\\\/how-to-make-phpbb-forum-read-only\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/eyga.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to make phpBB forum read-only\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/eyga.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/eyga.net\\\/en\\\/\",\"name\":\"Eyga.net (EN)\",\"description\":\"\u0160e eno spleti\u0161\u010de Eyga.net Spleti\u0161\u010da\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/eyga.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/eyga.net\\\/en\\\/#\\\/schema\\\/person\\\/4d5bb8efc36970bf82f47ebe7498c366\",\"name\":\"Domen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fafbecbf67fcf0bd2b817f7706916f5fa2ff4d3d8d5f466e2d2c05bc1f3c6212?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fafbecbf67fcf0bd2b817f7706916f5fa2ff4d3d8d5f466e2d2c05bc1f3c6212?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fafbecbf67fcf0bd2b817f7706916f5fa2ff4d3d8d5f466e2d2c05bc1f3c6212?s=96&d=mm&r=g\",\"caption\":\"Domen\"},\"url\":\"https:\\\/\\\/eyga.net\\\/en\\\/author\\\/domen\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to make phpBB forum read-only - Eyga.net (EN)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/eyga.net\/en\/2016\/01\/26\/how-to-make-phpbb-forum-read-only\/","og_locale":"en_US","og_type":"article","og_title":"How to make phpBB forum read-only - Eyga.net (EN)","og_description":"PhpBB forum has an option to disable the forum. In that case no forums and topics are shown. But what if we want to make the forum read-only. So that anyone can read it and nobody can change the date. The solution is to give to the account, which phpBB uses to connect to the […]","og_url":"https:\/\/eyga.net\/en\/2016\/01\/26\/how-to-make-phpbb-forum-read-only\/","og_site_name":"Eyga.net (EN)","article_published_time":"2016-01-26T19:56:14+00:00","article_modified_time":"2022-07-01T11:53:20+00:00","author":"Domen","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Domen","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/eyga.net\/en\/2016\/01\/26\/how-to-make-phpbb-forum-read-only\/#article","isPartOf":{"@id":"https:\/\/eyga.net\/en\/2016\/01\/26\/how-to-make-phpbb-forum-read-only\/"},"author":{"name":"Domen","@id":"https:\/\/eyga.net\/en\/#\/schema\/person\/4d5bb8efc36970bf82f47ebe7498c366"},"headline":"How to make phpBB forum read-only","datePublished":"2016-01-26T19:56:14+00:00","dateModified":"2022-07-01T11:53:20+00:00","mainEntityOfPage":{"@id":"https:\/\/eyga.net\/en\/2016\/01\/26\/how-to-make-phpbb-forum-read-only\/"},"wordCount":120,"articleSection":["Code snippets"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/eyga.net\/en\/2016\/01\/26\/how-to-make-phpbb-forum-read-only\/","url":"https:\/\/eyga.net\/en\/2016\/01\/26\/how-to-make-phpbb-forum-read-only\/","name":"How to make phpBB forum read-only - Eyga.net (EN)","isPartOf":{"@id":"https:\/\/eyga.net\/en\/#website"},"datePublished":"2016-01-26T19:56:14+00:00","dateModified":"2022-07-01T11:53:20+00:00","author":{"@id":"https:\/\/eyga.net\/en\/#\/schema\/person\/4d5bb8efc36970bf82f47ebe7498c366"},"breadcrumb":{"@id":"https:\/\/eyga.net\/en\/2016\/01\/26\/how-to-make-phpbb-forum-read-only\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/eyga.net\/en\/2016\/01\/26\/how-to-make-phpbb-forum-read-only\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/eyga.net\/en\/2016\/01\/26\/how-to-make-phpbb-forum-read-only\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/eyga.net\/en\/"},{"@type":"ListItem","position":2,"name":"How to make phpBB forum read-only"}]},{"@type":"WebSite","@id":"https:\/\/eyga.net\/en\/#website","url":"https:\/\/eyga.net\/en\/","name":"Eyga.net (EN)","description":"\u0160e eno spleti\u0161\u010de Eyga.net Spleti\u0161\u010da","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/eyga.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/eyga.net\/en\/#\/schema\/person\/4d5bb8efc36970bf82f47ebe7498c366","name":"Domen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/fafbecbf67fcf0bd2b817f7706916f5fa2ff4d3d8d5f466e2d2c05bc1f3c6212?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/fafbecbf67fcf0bd2b817f7706916f5fa2ff4d3d8d5f466e2d2c05bc1f3c6212?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fafbecbf67fcf0bd2b817f7706916f5fa2ff4d3d8d5f466e2d2c05bc1f3c6212?s=96&d=mm&r=g","caption":"Domen"},"url":"https:\/\/eyga.net\/en\/author\/domen\/"}]}},"_links":{"self":[{"href":"https:\/\/eyga.net\/en\/wp-json\/wp\/v2\/posts\/13","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eyga.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eyga.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eyga.net\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/eyga.net\/en\/wp-json\/wp\/v2\/comments?post=13"}],"version-history":[{"count":4,"href":"https:\/\/eyga.net\/en\/wp-json\/wp\/v2\/posts\/13\/revisions"}],"predecessor-version":[{"id":26,"href":"https:\/\/eyga.net\/en\/wp-json\/wp\/v2\/posts\/13\/revisions\/26"}],"wp:attachment":[{"href":"https:\/\/eyga.net\/en\/wp-json\/wp\/v2\/media?parent=13"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eyga.net\/en\/wp-json\/wp\/v2\/categories?post=13"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eyga.net\/en\/wp-json\/wp\/v2\/tags?post=13"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}