Difference between revisions of "User:TerryE/phpBB3.0.7 Upgrade/Issues and Actions"

From Apache OpenOffice Wiki
Jump to: navigation, search
(→‎Logfile Retention Policy: Move to closed)
 
(57 intermediate revisions by the same user not shown)
Line 3: Line 3:
 
|}
 
|}
 
I have included the list of open issues and activities that I intend to carried out as part of the phpBB V3.0.7 upgrade below.   
 
I have included the list of open issues and activities that I intend to carried out as part of the phpBB V3.0.7 upgrade below.   
 +
== The Core Build ==
  
−
== Automated Backup ==
+
This work is now complete and all ten live NL databases migrated to 3.0.7.  See [[User:TerryE/phpBB3.0.7 Upgrade/Closed Issues and Actions#The Core Build|Closed Issues and Actions]] for details on the process.
  
−
I had a set of scripts that ran as a cron job for the old server with the PostgresSQL D/B, but I turned these off when I moved to MySQL and we decommissioned using the OUCV server as a second site.  I have a script which I use manually about once per week (on top of standard Solaris backups), but I would prefer to have a nightly incremental dump.
+
== Round-off and archive ==
  
−
== Automated Unactivated Users Prune ==
+
See [[User:TerryE/phpBB3.0.7 Upgrade/Closed Issues and Actions#The Core Build|Closed Issues and Actions]] for details on the following completed activities:
  
−
This is another batch script that I have still in development.  It automates a tedious twice weekly task. Low priority until the issues which are impacting the NL Administrators are sorted.
+
* Automated administrator email responder
 +
* Automated unactivated users prune
 +
* Automated backup
 +
* Forum watchdog
 +
* Oracle branding
 +
* Retiring custom fields
  
−
== Automated Administrator Email Responder ==
+
I need still need to clean out any temporary archive files, and archive the core set of sh and patch files so that I can pick this up as a basis of a future 3.0.7 -> 3.x upgrade.
  
−
V1 of this was developed about a year ago.  I upgraded V2 to Python for deployment with phpBB V305.  This fails to part about 5% of valid email queries and rejects these as errors. I need to fix this as part of the upgrade to V307.
+
== Enabling Atom Feeds ==
 +
A number of the power users on the '''FR''' forum used the previous RSS feed.  This functionality has been dropped and an equivalent needs reinstituted.  The previous mod implementation adopted the [http://www.phpbb.com/community/viewtopic.php?f=69&t=1189825 Simple RSS mod for phpBB3].  However, this mod has significant limitations that I can't ignore; most importantly it bypasses the phpBB access control system, allowing unregistered users to browse closed forums.  I didn't get this working properly but this functionality is now superseded by a standard php V306 feature to provide ATOM feeds.   
 +
* We need to investigate its implementation for those forums that want it, as it requires enabling / configuring through ACP.
 +
* I need to discuss this further with the FR proponents of this mod.
 +
* Note that for some reason, the ATOM feed link isn't being displayed if the Feed is enable.  I need to investigate this.
  
−
== Code Base ==
+
== Basic Management Reporting ==
  
−
* The core phpBB code base from [http://www.ohloh.net/p/phpbb/download?filename=phpBB-3.0.7.tar.bz2 phpBB 3.0.7 Download]
+
Some of the NL forums are clearly active and healthy. Some clearly less so.  However, we have no objective measures in place to identify any issues that are arising and any trends that need to trigger additional support for any individual forum that might be having problems.  One option here might be to introduce some basic health measures so that we can maintain a simple forum dashboard.
−
* The following language packs from [http://www.phpbb.com/languages/ phpBB 3.0.x Languages] repository. These are maintained in the site '''/files/language_packs_30x/''' sub-directory
+
−
 
+
−
{| class="prettytable"
+
−
| <center>'''Language '''</center>
+
−
| <center>'''Language files '''</center>
+
−
| <center>'''Prosilver GIFs '''</center>
+
−
 
+
−
|-
+
−
| English (U.K.) || (built-in) || (built-in)
+
−
|-
+
−
| English (U.S.) || lang_en_us.tar.gz || prosilver_en_us.tar.gz
+
−
|-
+
−
| French || lang_fr.tar.gz || prosilver_fr.tar.gz
+
−
|-
+
−
| Catalan || lang_ca.tar.gz || prosilver_ca.tar.gz
+
−
|-
+
−
| Catalan (Valencian) || lang_ca_pv.tar.gz || prosilver_ca_pv.tar.gz
+
−
|-
+
−
| Dutch || lang_nl.tar.gz || prosilver_nl.tar.gz
+
−
|-
+
−
| Hungarian || lang_hu.tar.gz || prosilver_hu.tar.gz
+
−
|-
+
−
| Italian || lang_it.tar.gz || prosilver_it.tar.gz
+
−
|-
+
−
| Japanese || lang_ja.tar.gz || prosilver_ja.tar.gz
+
−
|-
+
−
| Mandarin Chinese (Traditional script) || lang_zh_cmn_hant.tar.gz || prosilver_zh_cmn_hant.tar.gz
+
−
|-
+
−
| Mandarin Chinese (Simplified script) || lang_zh_cmn_hans.tar.gz || prosilver_zh_cmn_hans.tar.gz
+
−
|-
+
−
| Polish || lang_pl.tar.gz || prosilver_pl.tar.gz
+
−
|-
+
−
| Spanish || lang_es.tar.gz || prosilver_es.tar.gz
+
−
|-
+
−
| Spanish (Argentina) || lang_es_ar.tar.gz || prosilver_es_ar.tar.gz
+
−
|-
+
−
| Vietnamese || lang_vi.tar.gz || prosilver_vi.tar.gz
+
−
|}
+
−
 
+
−
  for co in ca ca_pv en_us es es_ar fr hu it ja nl pl vi zh_cmn_hant zh_cmn_hans; do
+
−
  wget <nowiki>http://www.phpbb.com/files/language_packs_30x/lang_$co.tar.gz</nowiki>
+
−
  wget <nowiki>http://www.phpbb.com/files/language_packs_30x/prosilver_$co.tar.gz</nowiki>
+
−
done
+
−
 
+
−
== Logfile Retention Policy ==
+
−
 
+
−
At the moment I've configured Logfile rotation on the Apache access and error logs on a weekly basis.  At the moment I periodically compress old logs and delete access logs older the 3 months.  Rotation on the MySQL logs is also done on an adhoc basis. I need to implement a simple weekly cron task which:
+
−
* Rotates the Mysql log
+
−
* Compresses logs older than one week
+
−
* Deletes the compress access and mysql error logs files older than 3 months.
+
−
 
+
−
== Oracle Branding ==
+
−
 
+
−
Now that Oracle has acquired Sun, some of the Sun Footer logos have been replaced with Oracle branding ones.  <s>I will sort this out as part of this upgrade.</s>  I've done this earlier by request of Clayton.
+
−
 
+
−
== Retiring Custom Fields ==
+
−
 
+
−
This functionality has been moved into the standard signature format.  I have already done this for the EN forums and swithed off the use of custom fields in the creation of new accounts on all forums,  but I've got about existing 800 accounts across three NL forums where I need to move this data into the signatures.
+
−
 
+
−
== RSS Feed ==
+
−
 
+
−
A number of the power users on the '''fr''' forum used the previous RSS feed.  This functionality has been temporarily dropped and needs reinstituted.  The current implementation adopts the [http://www.phpbb.com/community/viewtopic.php?f=69&t=1189825 Simple RSS mod for phpBB3].  However, this mod has significant limitations that I can't ignore.  Most importantly it bypasses the phpBB access control system, allowing unregistered users to browse closed forums.  I didn't get this working properly but this functionality is now superseded by a standard php V306 feature. I need to discuss this further with the fr proponents of this mod.
+
  
 
== Standardising Forum Configurations ==  
 
== Standardising Forum Configurations ==  
  
−
With 9 forums ''any'' degree of divergence can cause problems on upgrade and through-life maintenance, so we need to standardise where possible.  I am ''not'' talking about language packs or basic forum structure but things like the extra BBcodes, permissible file extensions for upload, etc..  If they make sense in one OOo forum then they should be in all.
+
With 10 forums ''any'' degree of divergence can cause problems on upgrade and through-life maintenance, so we need to standardise where possible.  I am ''not'' talking about language packs or basic forum structure but things like the extra BBcodes, permissible file extensions for upload, etc..  If they make sense in one OOo forum then they should be in all.
  
 
== Write up phpBB 3.0.7 configuration ==
 
== Write up phpBB 3.0.7 configuration ==
  
 
I have decided to do this in the phpBB wiki because this will be of more interest to phpBB admins rather than OOo Volunteers and NL Admins.  I will post the link here when I've done it.
 
I have decided to do this in the phpBB wiki because this will be of more interest to phpBB admins rather than OOo Volunteers and NL Admins.  I will post the link here when I've done it.

Latest revision as of 11:16, 30 August 2011

I have included the list of open issues and activities that I intend to carried out as part of the phpBB V3.0.7 upgrade below.

The Core Build

This work is now complete and all ten live NL databases migrated to 3.0.7. See Closed Issues and Actions for details on the process.

Round-off and archive

See Closed Issues and Actions for details on the following completed activities:

  • Automated administrator email responder
  • Automated unactivated users prune
  • Automated backup
  • Forum watchdog
  • Oracle branding
  • Retiring custom fields

I need still need to clean out any temporary archive files, and archive the core set of sh and patch files so that I can pick this up as a basis of a future 3.0.7 -> 3.x upgrade.

Enabling Atom Feeds

A number of the power users on the FR forum used the previous RSS feed. This functionality has been dropped and an equivalent needs reinstituted. The previous mod implementation adopted the Simple RSS mod for phpBB3. However, this mod has significant limitations that I can't ignore; most importantly it bypasses the phpBB access control system, allowing unregistered users to browse closed forums. I didn't get this working properly but this functionality is now superseded by a standard php V306 feature to provide ATOM feeds.

  • We need to investigate its implementation for those forums that want it, as it requires enabling / configuring through ACP.
  • I need to discuss this further with the FR proponents of this mod.
  • Note that for some reason, the ATOM feed link isn't being displayed if the Feed is enable. I need to investigate this.

Basic Management Reporting

Some of the NL forums are clearly active and healthy. Some clearly less so. However, we have no objective measures in place to identify any issues that are arising and any trends that need to trigger additional support for any individual forum that might be having problems. One option here might be to introduce some basic health measures so that we can maintain a simple forum dashboard.

Standardising Forum Configurations

With 10 forums any degree of divergence can cause problems on upgrade and through-life maintenance, so we need to standardise where possible. I am not talking about language packs or basic forum structure but things like the extra BBcodes, permissible file extensions for upload, etc.. If they make sense in one OOo forum then they should be in all.

Write up phpBB 3.0.7 configuration

I have decided to do this in the phpBB wiki because this will be of more interest to phpBB admins rather than OOo Volunteers and NL Admins. I will post the link here when I've done it.

Retrieved from "https://wiki.openoffice.org/w/index.php?title=User:TerryE/phpBB3.0.7_Upgrade/Issues_and_Actions&oldid=197408"
Personal tools