ProleWiki - User contributions [en]

ProleWiki:Maintenance/Backups

2022-08-09T16:40:55Z

KakumeiAshley: updated backup schedule

== The crontab ==
The script is called from the root user's crontab, configured to run at 05:40 UTC.

<pre>root@prolewiki:~# crontab -l
40 05 * * * /root/bin/backup.sh | tee -a /var/log/backup.sh.log
35 */1 * * * /root/bin/dfmon.sh | tee /var/log/dfmon.sh.log
root@prolewiki:~# date
Tue 09 Aug 2022 04:32:14 PM UTC</pre>
== The log ==
* Cron redirects the output of the script to <code>/var/log/backup.sh.log</code>
* Zip logs output to <code>/var/log/backup.sh.zip.log</code>

There is currently no log rotation/truncation set up!!
== The code ==

See <code>/root/bin/backup.sh</code>

ProleWiki:Maintenance/Backups

2022-08-09T03:34:57Z

KakumeiAshley:

== The crontab ==
The script is called from the root user's crontab, configured to run at 40 minutes past the hour every 10 hours.

<pre>root@prolewiki:/etc/cron.daily# crontab -l
40 */10 * * * /root/bin/backup.sh | tee -a /var/log/backup.sh.log</pre>
== The log ==
* Cron redirects the output of the script to <code>/var/log/backup.sh.log</code>
* Zip logs output to <code>/var/log/backup.sh.zip.log</code>

There is currently no log rotation/truncation set up!!
== The code ==

See <code>/root/bin/backup.sh</code>

ProleWiki:Maintenance/Backups

2022-08-09T02:25:10Z

KakumeiAshley:

placeholder / work in progress

* ''Comrade [[Comrade:KakumeiAshley|KakumeiAshley]]'' ([[Comradeship:KakumeiAshley|talk]]) 02:09, 9 August 2022 (UTC)

== The crontab ==
<pre>root@prolewiki:/etc/cron.daily# crontab -l
40 */10 * * * /root/bin/backup.sh | tee -a /var/log/backup.sh.log</pre>
== The log ==
<code>/var/log/backup.sh.log</code>
== The code ==
<pre>
# placeholder
</pre>

ProleWiki:Maintenance/Backups

2022-08-09T02:09:34Z

KakumeiAshley: Created page with "placeholder * ~~~~"

placeholder

* ''Comrade [[Comrade:KakumeiAshley|KakumeiAshley]]'' ([[Comradeship:KakumeiAshley|talk]]) 02:09, 9 August 2022 (UTC)

ProleWiki:Maintenance/Adding languages

2022-08-09T02:06:51Z

KakumeiAshley: added apache and ssl cert info

Here we will be following a step-by-step tutorial on how to add new languages to ProleWiki. We will use a non-existent "aa" language code as an example, but it should be changed to the language that is being included (e.g.: <code>en</code> for English, <code>fr</code> for French, <code>ru</code> for Russian, etc.). We can check the existing language on Wikipedia as a reference for its language code.

===Step 1: Create new A Record for the site===

*Go to our Namecheap account and add new A Record for the site, using the same configuration as the others, changing only the language code.

===Step 2: Create new database for the site===
<ul>
<li> Open command <syntaxhighlight inline lang="bash">mysql</syntaxhighlight>
<li> Type in <syntaxhighlight inline lang="mysql">CREATE DATABASE prole_aa;</syntaxhighlight>
<li> Give permission to database user by typing <syntaxhighlight inline lang="mysql">GRANT ALL PRIVILEGES ON prole_aa.* TO 'proledbuser'@'localhost';</syntaxhighlight>
<li> Exit mysql by typing <syntaxhighlight inline lang="mysql">exit</syntaxhighlight>
</ul>
===Step 3: Add basic schema to database===

*Go to maintenance folder (<syntaxhighlight inline lang="bash">cd /var/www/prole/maintenance</syntaxhighlight>)
*Input the command <code>mysql prole_aa < /var/www/prole/maintenance/tables-generated.sql</code>

===Step 4: Add new site to site configuration===

*Edit <code>/var/www/prole/LocalSettings.php</code>
*Add the following lines where there are similar ones, and before the "language selector":
<syntaxhighlight lang="php">
elseif (isset($_SERVER['SERVER_NAME']) && $_SERVER['SERVER_NAME'] == 'aa.prolewiki.org') {
$wikiId = 'aa';
}
</syntaxhighlight>
*Add this code block where there are similar ones like it, changing the options to the target language:
<syntaxhighlight lang="php">
elseif ($wikiId == 'aa') {
$wgServer = "https://aa.prolewiki.org";
$wgDBname = "prole_aa";
$wgLanguageCode = 'aa';
$wgLogo = "/resources/assets/prolewiki_logo_aa.png";
$wgExtraNamespaces = [
NS_LBRY => 'Library',
NS_LBRY_TALK => 'Library_talk',
NS_ESY => 'Essay',
NS_ESY_TALK => 'Essay_talk',
NS_USER => 'Comrade',
NS_USER_TALK => 'Comradeship',
NS_QUOTE => 'Quotes',
NS_QUOTE_TALK => 'Quotes_talk'
];
$wgMatomoIDSite = "X"; // Change to Matomo site
$wgMetaNamespace = "ProleWiki"; // Only necessary for wikis which use a different alphabet
$wgSitename = "ProleWiki"; // Same as above
$wgNamespaceAliases['ProleWiki'] = NS_PROJECT; // Same as above, leaving this as it is as a Latin alphabet fallback for the ProleWiki: namespace
$wgWikiSeoDefaultImage = '/resources/assets/seo/seo_aa.png';
$wgPageImagesOpenGraphFallbackImage = "/resources/assets/seo/seo_aa.png";
// Wikibase
wfLoadExtension( 'WikibaseClient', "$IP/extensions/Wikibase/extension-client.json" );
require_once "$IP/extensions/Wikibase/client/ExampleSettings.php";
$wgWBClientSettings['siteGlobalID'] = 'aa';
}
</syntaxhighlight>
*Save the file
===Step 5: Add site to sites table in database and update it===
*Go to <code>/var/www/prole/maintenance/</code>
*Input the following:
<syntaxhighlight lang="bash">
php addSite.php aa prolewiki --wiki shared --pagepath=https://aa.prolewiki.org/wiki/\$1 --filepath=https://aa.prolewiki.org/\$1 --language aa --interwiki-id aa
</syntaxhighlight>
*This should be done for all wikis. To do that, you should use:
<syntaxhighlight lang="bash">
php exportSites.php --wiki shared sites.xml
</syntaxhighlight>
*Then you import it for every wiki using (where wiki-id is <code>de</code>, <code>en</code>, <code>es</code>, <code>fr</code>, <code>pt</code>, <code>ru</code>, <code>aa</code>, etc.):
<syntaxhighlight lang="bash">
php importSites.php --wiki <wiki-id> sites.xml
</syntaxhighlight>
*Update all databases (where wiki-id includes <code>shared</code> as well:
<syntaxhighlight lang="bash">
php update.php --wiki <wiki-id> --quick
</syntaxhighlight>
===Step 6: Add site domain to Apache vHost directive & reissue certificate===
The new language subdomain must be explicitly added to Apache for Let's Encrypt to detect it and issue the certificate with the correct SANs.
* Open <code>/etc/apache2/sites-enabled/prolewiki.conf</code> for editing. There are 3 places to add the new subdomain:
** The 1st and 2nd <code>ServerAlias</code> lines in the <code>VirtualHost</code> blocks for port :80 and :443.
** The <code>RewriteCond</code> lines in approximately the middle of the file.
* Add entries for the new subdomain so that the placemet, formatting, etc, match the existing entries.
* Run <code>apache -t</code> and look for anything worse than a <code>warn</code>, or anything likely to cause problems
* Run <code>certbot</code>
** To do: add more detailed certbot notes ''Comrade [[Comrade:KakumeiAshley|KakumeiAshley]]'' ([[Comradeship:KakumeiAshley|talk]]) 02:06, 9 August 2022 (UTC)

ProleWiki:Maintenance/Adding languages

2022-08-09T01:53:23Z

KakumeiAshley: coming soon uwu

Here we will be following a step-by-step tutorial on how to add new languages to ProleWiki. We will use a non-existent "aa" language code as an example, but it should be changed to the language that is being included (e.g.: <code>en</code> for English, <code>fr</code> for French, <code>ru</code> for Russian, etc.). We can check the existing language on Wikipedia as a reference for its language code.

===Step 1: Create new A Record for the site===

*Go to our Namecheap account and add new A Record for the site, using the same configuration as the others, changing only the language code.

===Step 2: Create new database for the site===
<ul>
<li> Open command <syntaxhighlight inline lang="bash">mysql</syntaxhighlight>
<li> Type in <syntaxhighlight inline lang="mysql">CREATE DATABASE prole_aa;</syntaxhighlight>
<li> Give permission to database user by typing <syntaxhighlight inline lang="mysql">GRANT ALL PRIVILEGES ON prole_aa.* TO 'proledbuser'@'localhost';</syntaxhighlight>
<li> Exit mysql by typing <syntaxhighlight inline lang="mysql">exit</syntaxhighlight>
</ul>
===Step 3: Add basic schema to database===

*Go to maintenance folder (<syntaxhighlight inline lang="bash">cd /var/www/prole/maintenance</syntaxhighlight>)
*Input the command <code>mysql prole_aa < /var/www/prole/maintenance/tables-generated.sql</code>

===Step 4: Add new site to site configuration===

*Edit <code>/var/www/prole/LocalSettings.php</code>
*Add the following lines where there are similar ones, and before the "language selector":
<syntaxhighlight lang="php">
elseif (isset($_SERVER['SERVER_NAME']) && $_SERVER['SERVER_NAME'] == 'aa.prolewiki.org') {
$wikiId = 'aa';
}
</syntaxhighlight>
*Add this code block where there are similar ones like it, changing the options to the target language:
<syntaxhighlight lang="php">
elseif ($wikiId == 'aa') {
$wgServer = "https://aa.prolewiki.org";
$wgDBname = "prole_aa";
$wgLanguageCode = 'aa';
$wgLogo = "/resources/assets/prolewiki_logo_aa.png";
$wgExtraNamespaces = [
NS_LBRY => 'Library',
NS_LBRY_TALK => 'Library_talk',
NS_ESY => 'Essay',
NS_ESY_TALK => 'Essay_talk',
NS_USER => 'Comrade',
NS_USER_TALK => 'Comradeship',
NS_QUOTE => 'Quotes',
NS_QUOTE_TALK => 'Quotes_talk'
];
$wgMatomoIDSite = "X"; // Change to Matomo site
$wgMetaNamespace = "ProleWiki"; // Only necessary for wikis which use a different alphabet
$wgSitename = "ProleWiki"; // Same as above
$wgNamespaceAliases['ProleWiki'] = NS_PROJECT; // Same as above, leaving this as it is as a Latin alphabet fallback for the ProleWiki: namespace
$wgWikiSeoDefaultImage = '/resources/assets/seo/seo_aa.png';
$wgPageImagesOpenGraphFallbackImage = "/resources/assets/seo/seo_aa.png";
// Wikibase
wfLoadExtension( 'WikibaseClient', "$IP/extensions/Wikibase/extension-client.json" );
require_once "$IP/extensions/Wikibase/client/ExampleSettings.php";
$wgWBClientSettings['siteGlobalID'] = 'aa';
}
</syntaxhighlight>
*Save the file
===Step 5: Add site to sites table in database and update it===
*Go to <code>/var/www/prole/maintenance/</code>
*Input the following:
<syntaxhighlight lang="bash">
php addSite.php aa prolewiki --wiki shared --pagepath=https://aa.prolewiki.org/wiki/\$1 --filepath=https://aa.prolewiki.org/\$1 --language aa --interwiki-id aa
</syntaxhighlight>
*This should be done for all wikis. To do that, you should use:
<syntaxhighlight lang="bash">
php exportSites.php --wiki shared sites.xml
</syntaxhighlight>
*Then you import it for every wiki using (where wiki-id is <code>de</code>, <code>en</code>, <code>es</code>, <code>fr</code>, <code>pt</code>, <code>ru</code>, <code>aa</code>, etc.):
<syntaxhighlight lang="bash">
php importSites.php --wiki <wiki-id> sites.xml
</syntaxhighlight>
*Update all databases (where wiki-id includes <code>shared</code> as well:
<syntaxhighlight lang="bash">
php update.php --wiki <wiki-id> --quick
</syntaxhighlight>
===Step 6: Add site domain to Apache vHost directive===
* to do ''Comrade [[Comrade:KakumeiAshley|KakumeiAshley]]'' ([[Comradeship:KakumeiAshley|talk]]) 01:53, 9 August 2022 (UTC)