ProleWiki:Maintenance/Adding languages - Revision history

Forte: Added Flow to list of extensions which require manual intervention.

2024-04-21T14:58:00Z

Added Flow to list of extensions which require manual intervention.

← Older revision		Revision as of 14:58, 21 April 2024
Line 31:		Line 31:
	Here is a list of extensions which we have to add those tables:		Here is a list of extensions which we have to add those tables:
	CreatedPagesList		CreatedPagesList
			Flow (extensions/Flow/sql/mysql/tables-generated.sql)

	=== Step 5: Add new site to server registry configuration ===		=== Step 5: Add new site to server registry configuration ===

Forte: Added further context

2024-04-08T12:36:52Z

Added further context

← Older revision		Revision as of 12:36, 8 April 2024
Line 9:		Line 9:
	** The 1st and 2nd <code>ServerAlias</code> lines in the <code>VirtualHost</code> blocks for port :80 and :443.		** 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.		** 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.		* Add entries for the new subdomain so that the placement, 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>apache2ctl -t</code> and look for anything worse than a <code>warn</code>, or anything likely to cause problems
	* Run <code>certbot</code>		* Run <code>certbot</code>

Line 28:		Line 28:

	so you can manually add those tables. (MediaWiki pls fix)		so you can manually add those tables. (MediaWiki pls fix)

			Here is a list of extensions which we have to add those tables:
			CreatedPagesList

	=== Step 5: Add new site to server registry configuration ===		=== Step 5: Add new site to server registry configuration ===
Line 60:		Line 63:
	==== With script ====		==== With script ====
	*Go to the root directory <code>/var/www/prolewiki</code>		*Go to the root directory <code>/var/www/prolewiki</code>
	*[[Comrade:Forte\|Forte]] created ~~a script~~ on <code>pw-conf/</code> folder. You can simply add the language code to the array declared ~~there~~:		*[[Comrade:Forte\|Forte]] created several scripts on <code>pw-conf/scripts/</code> folder. You can simply add the language code to the array declared in the file named <code>wikicodes.sh</code>:
	<code>wikis=("en" "pt" "es" "de" "fr" "ru" "zh" "el" "fa" "aa")</code>		<code>wikis=("en" "pt" "es" "de" "fr" "ru" "zh" "el" "fa" "aa")</code>

	The sites are listed on the order of addition, just add to the end of the array. Then, from the root directory, run the script with:		The sites are listed on the order of addition, just add to the end of the array. Then, from the root directory, run the script with:

	<code>pw-conf/./site_refresh.sh</code>		<code>pw-conf/scripts/./site_refresh.sh</code>

	==== Manually ====		==== Manually ====

Forte at 22:13, 28 March 2024

2024-03-28T22:13:30Z

← Older revision		Revision as of 22:13, 28 March 2024
Line 71:		Line 71:

	<code>php maintenance/run.php ./maintenance/addSite.php aa prolewiki --wiki shared --pagepath=<nowiki>https://aa.prolewiki.org/wiki/\$1</nowiki> --filepath=<nowiki>https://aa.prolewiki.org/\$1</nowiki> --language aa --interwiki-id aa</code>		<code>php maintenance/run.php ./maintenance/addSite.php aa prolewiki --wiki shared --pagepath=<nowiki>https://aa.prolewiki.org/wiki/\$1</nowiki> --filepath=<nowiki>https://aa.prolewiki.org/\$1</nowiki> --language aa --interwiki-id aa</code>

			=== Notes ===
			<references group="lower-alpha"/>

Forte: Updated procedure

2024-03-28T22:12:51Z

Updated procedure

Show changes

Forte: Changing order of steps

2024-03-28T18:14:51Z

Changing order of steps

← Older revision		Revision as of 18:14, 28 March 2024
Line 5:		Line 5:
	*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.		*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===		===Step 2: 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>

			===Step 3: Create new database for the site===
	<ul>		<ul>
	<li> Open command <syntaxhighlight inline lang="bash">mysql</syntaxhighlight>		<li> Open command <syntaxhighlight inline lang="bash">mysql</syntaxhighlight>
Line 12:		Line 21:
	<li> Exit mysql by typing <syntaxhighlight inline lang="mysql">exit</syntaxhighlight>		<li> Exit mysql by typing <syntaxhighlight inline lang="mysql">exit</syntaxhighlight>
	</ul>		</ul>
	===Step 3: Add basic schema to database===		===Step 4: Add basic schema to database===

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

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

	*Edit <code>/var/www/prole/LocalSettings.php</code>		*Edit <code>/var/www/prole/LocalSettings.php</code>
Line 56:		Line 65:
	</syntaxhighlight>		</syntaxhighlight>
	*Save the file		*Save the file
	===Step 5: Add site to sites table in database and update it===		===Step 6: Add site to sites table in database and update it===
	*Go to <code>/var/www/prole/maintenance/</code>		*Go to <code>/var/www/prole/maintenance/</code>
	*Input the following:		*Input the following:
Line 74:		Line 83:
	php update.php --wiki <wiki-id> --quick		php update.php --wiki <wiki-id> --quick
	</syntaxhighlight>		</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]]'' <sup>([[Comradeship:KakumeiAshley\|talk]])</sup> 02:06, 9 August 2022 (UTC)

KakumeiAshley: added apache and ssl cert info

2022-08-09T02:06:51Z

added apache and ssl cert info

← Older revision		Revision as of 02:06, 9 August 2022
Line 74:		Line 74:
	php update.php --wiki <wiki-id> --quick		php update.php --wiki <wiki-id> --quick
	</syntaxhighlight>		</syntaxhighlight>
	===Step 6: Add site domain to Apache vHost directive===		===Step 6: Add site domain to Apache vHost directive & reissue certificate===
	* to do ''Comrade [[Comrade:KakumeiAshley\|KakumeiAshley]]'' <sup>([[Comradeship:KakumeiAshley\|talk]])</sup> 01:53, 9 August 2022 (UTC)		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]]'' <sup>([[Comradeship:KakumeiAshley\|talk]])</sup> 02:06, 9 August 2022 (UTC)

KakumeiAshley: coming soon uwu

2022-08-09T01:53:23Z

coming soon uwu

← Older revision		Revision as of 01:53, 9 August 2022
Line 74:		Line 74:
	php update.php --wiki <wiki-id> --quick		php update.php --wiki <wiki-id> --quick
	</syntaxhighlight>		</syntaxhighlight>
			===Step 6: Add site domain to Apache vHost directive===
			* to do ''Comrade [[Comrade:KakumeiAshley\|KakumeiAshley]]'' <sup>([[Comradeship:KakumeiAshley\|talk]])</sup> 01:53, 9 August 2022 (UTC)

Forte: Fixed mysql command with wrong syntax

2022-08-09T00:53:56Z

Fixed mysql command with wrong syntax

← Older revision		Revision as of 00:53, 9 August 2022
Line 8:		Line 8:
	<ul>		<ul>
	<li> Open command <syntaxhighlight inline lang="bash">mysql</syntaxhighlight>		<li> Open command <syntaxhighlight inline lang="bash">mysql</syntaxhighlight>
	<li> Type in <syntaxhighlight inline lang="mysql">CREATE prole_aa;</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> 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>		<li> Exit mysql by typing <syntaxhighlight inline lang="mysql">exit</syntaxhighlight>

Forte: Created page

2022-08-07T03:00:52Z

Created page

New page

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