Difference between revisions of "User:Pierre"

From ArchWiki
Jump to: navigation, search
(FluxBB 1.4 Upgrade)
 
(18 intermediate revisions by 2 users not shown)
Line 1: Line 1:
https://users.archlinux.de/~pierre/
+
https://pierre-schmitz.com/
 
+
==L10n-de Todo==
+
* Rewrite
+
** [[ArchWiki Tutorial (Deutsch)]]
+
** [[Getting Involved (Deutsch)]]
+
 
+
==FluxBB 1.4 Upgrade==
+
* <s>merge bbs.archlinux.de into git repo</s>
+
* <s>create empty fluxbb db</s>
+
* <s>adjust permissions of fluxbb user</s>
+
* <s>Password-protect access to bbs</s>
+
* <s>Remove or Rename duplicate accounts: http://bbs.archlinux.org/viewtopic.php?id=101085</s>
+
** <s>Test<s/>:
+
<pre>CREATE TEMPORARY TABLE tusers (
+
id int(10) unsigned NOT NULL,
+
username varchar(200) NOT NULL,
+
PRIMARY KEY (id),
+
UNIQUE KEY users_username_idx (username(25))
+
) DEFAULT CHARSET=utf8;
+
INSERT INTO tusers SELECT id, username FROM fluxbb_users;</pre>
+
* <s>Backup database phpbb</s>
+
* Backup complete directory
+
* import backup db into fluxbb
+
* adjust config.php
+
<pre>$db_name = 'fluxbb';
+
$db_type = 'mysql_innodb';
+
$cookie_secure = 1;
+
$arch_home ='http://www.archlinux.org/';
+
$arch_navbar = array('Home' => 'http://www.archlinux.org/',
+
                      'Packages' => 'http://www.archlinux.org/packages/',
+
                      'Forums' => 'http://bbs.archlinux.org/',
+
                      'Wiki' => 'http://wiki.archlinux.org/',
+
                      'Bugs' => 'http://bugs.archlinux.org/',
+
                      'AUR' => 'http://aur.archlinux.org/',
+
                      'Download' => 'http://www.archlinux.org/download/');
+
$arch_navbar_selected = 'Forums';</pre>
+
* remove fluxbb_ prefix from tables (adjust config.php)
+
<pre>RENAME TABLE fluxbb_bans TO bans;
+
RENAME TABLE fluxbb_categories TO categories;
+
RENAME TABLE fluxbb_censoring TO censoring;
+
RENAME TABLE fluxbb_config TO config;
+
RENAME TABLE fluxbb_forum_perms TO forum_perms;
+
RENAME TABLE fluxbb_forums TO forums;
+
RENAME TABLE fluxbb_groups TO groups;
+
RENAME TABLE fluxbb_online TO online;
+
RENAME TABLE fluxbb_posts TO posts;
+
RENAME TABLE fluxbb_ranks TO ranks;
+
RENAME TABLE fluxbb_reports TO reports;
+
RENAME TABLE fluxbb_search_cache TO search_cache;
+
RENAME TABLE fluxbb_search_matches TO search_matches;
+
RENAME TABLE fluxbb_search_words TO search_words;
+
RENAME TABLE fluxbb_subscriptions TO subscriptions;
+
RENAME TABLE fluxbb_topics TO topics;
+
RENAME TABLE fluxbb_users TO users;</pre>
+
* <s>Deny access to cache, include, lang, plugins, config.php, header.php, footer.php</s>
+
* <s>Add password-protected access to db_update.php, install.php</s>
+
* <pre>rm -f cache/*.php</pre>
+
* temporary disable apc stat cache
+
* temporaray increase maximum php execution time and memory usage
+
* killall php-cgi
+
* run update script
+
* check for wrong or duplicate mysql indexes
+
<pre>
+
ALTER TABLE `bans` DROP INDEX `fluxbb_bans_username`;
+
ALTER TABLE `online` DROP INDEX `punbb_online_user_id_ident_idx`;
+
ALTER TABLE `online` DROP INDEX `punbb_online_user_id_idx`;
+
ALTER TABLE `fluxbb`.`online` DROP INDEX `online_user_id_ident_idx` ,
+
ADD UNIQUE `online_user_id_ident_idx` ( `user_id` , `ident` ( 25 ) );
+
ALTER TABLE `online`  ENGINE = MEMORY;
+
ALTER TABLE `fluxbb`.`posts` DROP INDEX `punbb_posts_topic_id_idx` ,
+
ADD INDEX `posts_topic_id_idx` ( `topic_id` ) ;
+
ALTER TABLE `fluxbb`.`posts` DROP INDEX `punbb_posts_multi_idx` ,
+
ADD INDEX `posts_multi_idx` ( `poster_id` , `topic_id` ) ;
+
ALTER TABLE `fluxbb`.`reports` DROP INDEX `punbb_reports_zapped_idx` ,
+
ADD INDEX `reports_zapped_idx` ( `zapped` ) ;
+
ALTER TABLE `fluxbb`.`search_cache` DROP INDEX `punbb_search_cache_ident_idx` ,
+
ADD INDEX `search_cache_ident_idx` ( `ident` ( 8 ) ) ;
+
ALTER TABLE `search_matches` CHANGE `word_id` `word_id` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';
+
ALTER TABLE `fluxbb`.`search_matches` DROP INDEX `punbb_search_matches_word_id_idx` ,
+
ADD INDEX `search_matches_word_id_idx` ( `word_id` ) ;
+
ALTER TABLE `fluxbb`.`search_matches` DROP INDEX `punbb_search_matches_post_id_idx` ,
+
ADD INDEX `search_matches_post_id_idx` ( `post_id` ) ;
+
ALTER TABLE `search_words` CHANGE `id` `id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ;
+
ALTER TABLE `fluxbb`.`search_words` DROP INDEX `punbb_search_words_id_idx` ,
+
ADD INDEX `search_words_id_idx` ( `id` ) ;
+
ALTER TABLE `topics` DROP INDEX `punbb_topics_last_post_idx` ;
+
ALTER TABLE `fluxbb`.`topics` DROP INDEX `punbb_topics_forum_id_idx` ,
+
ADD INDEX `topics_forum_id_idx` ( `forum_id` ) ;
+
ALTER TABLE `fluxbb`.`topics` DROP INDEX `punbb_topics_moved_to_idx` ,
+
ADD INDEX `topics_moved_to_idx` ( `moved_to` ) ;
+
ALTER TABLE `users` CHANGE `group_id` `group_id` INT( 10 ) UNSIGNED NOT NULL DEFAULT '3';
+
ALTER TABLE `users` CHANGE `style` `style` VARCHAR( 25 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'ArchLinux';
+
ALTER TABLE `users` DROP INDEX `fluxbb_users_username_idx` ;
+
ALTER TABLE `fluxbb`.`topics` DROP INDEX `punbb_users_registered_idx` ,
+
ADD INDEX `users_registered_idx` ( `registered` ) ;
+
</pre>
+
* set default style to ArchLinux
+
<pre>UPDATE users SET style='ArchLinux';
+
UPDATE config SET conf_value='ArchLinux' WHERE conf_name='o_default_style';</pre>
+
* <pre>rm -f cache/*.php</pre>
+
* revert changes in php.ini and apc.ini
+
* re-enable public access
+
===Post update tasks===
+
* if everything is fine remove phpbb db
+
* where was announce_rss.php used?
+
* review ban lists
+
* review censor list
+
* remove unverified users?
+
* enable gzip?
+

Latest revision as of 21:30, 13 December 2011

https://pierre-schmitz.com/