Page MenuHomePhabricator
Paste P12915

(An Untitled Masterwork)
ActivePublic

Authored by Urbanecm on Sun, Oct 4, 8:35 PM.
urbanecm@LAPTOP-A3BHKQ07 /var/www/html/mw-sqlite
$ # Downloading, extracting and installing MW 1.33
urbanecm@LAPTOP-A3BHKQ07 /var/www/html/mw-sqlite
$ sudo -u www-data sqlite3 ../../data/sqlitewiki.sqlite
SQLite version 3.27.2 2019-02-25 16:06:06
Enter ".help" for usage hints.
sqlite> .schema oathauth_users
CREATE TABLE oathauth_users (
id INTEGER not null primary key,
secret BLOB null,
scratch_tokens BLOB null
);
sqlite> select * from oathauth_users;
1|KF75LNK73O7MNOMI|TNZT4DFW4U77BGOZ,ZR5H5IRYQQ7WPLSE,H55Q3BNDIGWBHRS2,2IACYIPSXGNNU4VH,I4DS2VUYZDOQY5JA,NB3RCZXAQSPZBBFP,CJ5DLBL6HI3N5MSS,WJXHBN5WHPBBQ5Y3,DOZQ6J7EGPJYH3NE,DYT5THUGRJYE7PZH
sqlite>
urbanecm@LAPTOP-A3BHKQ07 /var/www/html/mw-sqlite
$ cd ..
urbanecm@LAPTOP-A3BHKQ07 /var/www/html
$ wget https://releases.wikimedia.org/mediawiki/1.35/mediawiki-1.35.0.tar.gz
urbanecm@LAPTOP-A3BHKQ07 /var/www/html
$ tar xzf mediawiki-1.35.0.tar.gz
urbanecm@LAPTOP-A3BHKQ07 /var/www/html
$ mv mw-sqlite mw-sqlite-old
urbanecm@LAPTOP-A3BHKQ07 /var/www/html
$ mv mediawiki-1.35.0 mw-sqlite
urbanecm@LAPTOP-A3BHKQ07 /var/www/html
$ cd mw-sqlite
urbanecm@LAPTOP-A3BHKQ07 /var/www/html
$ # ~/unsynced/gerrit/mediawiki/extensions/OATHAuth is my git clone, with this patch fetched
urbanecm@LAPTOP-A3BHKQ07 /var/www/html/mw-sqlite
$ cp -r /home/urbanecm/unsynced/gerrit/mediawiki/extensions/OATHAuth/sql/sqlite/ extensions/OATHAuth/sql/
urbanecm@LAPTOP-A3BHKQ07 /var/www/html/mw-sqlite
$ cp -r /home/urbanecm/unsynced/gerrit/mediawiki/extensions/OATHAuth/src/Hook/LoadExtensionSchemaUpdates/UpdateTables.php extensions/OATHAuth/src/Hook/LoadExtensionSchemaUpdates/UpdateTables.php
urbanecm@LAPTOP-A3BHKQ07 /var/www/html/mw-sqlite
$ sudo -u www-data php maintenance/update.php --quick
MediaWiki 1.35.0 Updater
Your composer.lock file is up to date with current dependencies!
Going to run database updates for sqlitewiki
Using SQLite file: '/var/www/data/sqlitewiki.sqlite'
Depending on the size of your database this may take a while!
...have ss_active_users field in site_stats table.
...ss_active_users user count set...
...have ipb_allow_usertalk field in ipblocks table.
...have initial indexes
...change_tag table already exists.
...user_properties table already exists.
...log_search table already exists.
...l10n_cache table already exists.
...ct_rc_id key doesn't exist.
...have rd_interwiki field in redirect table.
...fulltext search table appears to be in order.
...iwlinks table already exists.
...index iwl_prefix_title_from already set on iwlinks table.
...have ul_value field in updatelog table.
...have iw_api field in interwiki table.
...iwl_prefix key doesn't exist.
...have cl_collation field in categorylinks table.
...module_deps table already exists.
...ar_page_revid key doesn't exist.
...skipping index ar_revid because index ar_revid_uniq already set on archive table.
...index user_email already set on user table.
...uploadstash table already exists.
...user_former_groups table already exists.
...batch conversion of user_options: nothing to migrate. done.
...user table does not contain user_options field.
...have rev_sha1 field in revision table.
...have ar_sha1 field in archive table.
...index page_redirect_namespace_len already set on page table.
...have us_chunk_inx field in uploadstash table.
...have job_timestamp field in job table.
...have ipb_parent_block_id field in ipblocks table.
...index ipb_parent_block_id already set on ipblocks table.
...category table does not contain cat_hidden field.
...have page_content_model field in page table.
...site_stats table does not contain ss_admins field.
...recentchanges table does not contain rc_moved_to_title field.
...sites table already exists.
...have fa_sha1 field in filearchive table.
...have job_token field in job table.
...have job_attempts field in job table.
...have us_props field in uploadstash table.
...ug_group in table user_groups already modified by patch patch-ug_group-length-increase-255.sql.
...ufg_group in table user_former_groups already modified by patch patch-ufg_group-length-increase-255.sql.
...index pp_propname_page already set on page_props table.
...index img_media_mime already set on image table.
...index iwl_prefix_from_title already set on iwlinks table.
...have ar_id field in archive table.
...have el_id field in externallinks table.
...have rc_source field in recentchanges table.
...have page_links_updated field in page table.
...have user_password_expires field in user table.
...have pp_sortkey field in page_props table.
...recentchanges table does not contain rc_cur_time field.
...index wl_user_notificationtimestamp already set on watchlist table.
...have page_lang field in page table.
...have pl_from_namespace field in pagelinks table.
...have tl_from_namespace field in templatelinks table.
...have il_from_namespace field in imagelinks table.
...hitcounter doesn't exist.
...site_stats table does not contain ss_total_views field.
...page table does not contain page_counter field.
...fa_deleted_reason field does not exist in filearchive table, skipping modify field patch.
...msg_resource_links doesn't exist.
...msg_resource doesn't exist.
...bot_passwords table already exists.
...have wl_id field in watchlist table.
...cl_collation key doesn't exist.
...index cl_collation_ext already set on categorylinks table.
...collations up-to-date.
...index rc_name_type_patrolled_timestamp already set on recentchanges table.
...have ct_id field in change_tag table.
...have el_index_60 field in externallinks table.
...have ug_expiry field in user_groups table.
...img_media_type in table image already modified by patch patch-add-3d.sql.
...ip_changes table already exists.
...skipping: index cl_from doesn't exist.
...skipping: index tl_from doesn't exist.
...skipping: index pl_from doesn't exist.
...skipping: index old_id doesn't exist.
...skipping: index il_from doesn't exist.
...skipping: index iwl_from doesn't exist.
...skipping: index ll_from doesn't exist.
...skipping: index ls_field_val doesn't exist.
...skipping: index md_module_skin doesn't exist.
...skipping: index keyname doesn't exist.
...skipping: index qci_type doesn't exist.
...skipping: index ss_row_id doesn't exist.
...skipping: index ufg_user_group doesn't exist.
...skipping: index user_properties_user_property doesn't exist.
...comment table already exists.
...revision_comment_temp table already exists.
...have ar_comment_id field in archive table.
...img_description field does not exist in image table, skipping modify field patch.
...have ipb_reason_id field in ipblocks table.
...have log_comment_id field in logging table.
...have oi_description_id field in oldimage table.
...have pt_reason_id field in protected_titles table.
...have rc_comment_id field in recentchanges table.
...rev_comment field does not exist in revision table, skipping modify field patch.
...have img_description_id field in image table.
...have fa_description_id field in filearchive table.
...skipping: index lc_lang_key doesn't exist.
...content table already exists.
...content_models table already exists.
...slots table already exists.
...have slot_origin field in slots table.
...slot_roles table already exists.
...actor table already exists.
...have ar_actor field in archive table.
...revision_actor_temp table already exists.
...have ipb_by_actor field in ipblocks table.
...have img_actor field in image table.
...have oi_actor field in oldimage table.
...have fa_actor field in filearchive table.
...have rc_actor field in recentchanges table.
...have log_actor field in logging table.
...rev_text_id field does not exist in revision table, skipping modify field patch.
...table site_stats already modified by patch patch-site_stats-modify.sql.
...index rc_namespace_title_timestamp already set on recentchanges table.
...change_tag_def table already exists.
...el_index_60 in table externallinks already modified by patch patch-externallinks-el_index_60-drop-default.sql.
Running maintenance/deduplicateArchiveRevId.php...
...Update 'DeduplicateArchiveRevId' already logged as completed. Use --force to run it again.
done.
...have ct_tag_id field in change_tag table.
...index ar_revid_uniq already set on archive table.
...index log_type_action already set on logging table.
...type_action key doesn't exist.
...skipping: index iw_prefix doesn't exist.
...skipping: index pp_page_propname doesn't exist.
...skipping: index pt_namespace_title doesn't exist.
...skipping: index site_ids_type doesn't exist.
...index rc_this_oldid already set on recentchanges table.
...transcache doesn't exist.
Running maintenance/populateChangeTagDef.php...
...Update 'PopulateChangeTagDef' already logged as completed. Use --force to run it again.
done.
...index change_tag_rc_tag_id already set on change_tag table.
...have ipb_sitewide field in ipblocks table.
...ipblocks_restrictions table already exists.
...change_tag table does not contain ct_tag field.
...valid_tag doesn't exist.
...tag_summary doesn't exist.
...archive table does not contain ar_comment field.
...ipblocks table does not contain ipb_reason field.
...image table does not contain img_description field.
...oldimage table does not contain oi_description field.
...filearchive table does not contain fa_description field.
...recentchanges table does not contain rc_comment field.
...logging table does not contain log_comment field.
...protected_titles table does not contain pt_reason field.
...archive table does not contain ar_user field.
...ipblocks table does not contain ipb_by field.
...image table does not contain img_user field.
...oldimage table does not contain oi_user field.
...filearchive table does not contain fa_user field.
...recentchanges table does not contain rc_user field.
...logging table does not contain log_user field.
...watchlist_expiry table already exists.
...fa_actor in table filearchive already modified by patch patch-filearchive-drop-fa_actor-DEFAULT.sql.
...rc_actor in table recentchanges already modified by patch patch-recentchanges-drop-rc_actor-DEFAULT.sql.
...log_actor in table logging already modified by patch patch-logging-drop-log_actor-DEFAULT.sql.
...page_restrictions in table page already modified by patch patch-page_restrictions-null.sql.
...index ipb_address_unique already set on ipblocks table.
...have rev_actor field in revision table.
...archive table does not contain ar_text_id field.
...index ipb_address_unique on table ipblocks has no field ipb_anon_only; added.
...ipb_address_unique index up-to-date.
...actor_name in table actor already modified by patch patch-actor-actor_name-varbinary.sql.
...oathauth_users table already exists.
...oathauth_users table does not contain secret_reset field.
Adding module field to table oathauth_users ...done.
Table oathauth_users contains secret field. Dropping ...done.
...site_stats is populated...done.
Checking existence of old default messages...done.
Populating rev_len column
...doing rev_id from 1 to 200
Populating ar_len column
...archive table seems to be empty.
rev_len and ar_len population complete [0 revision rows, 0 archive rows].
Populating rev_sha1 column
...doing rev_id from 1 to 200
Populating ar_sha1 column
...archive table seems to be empty.
Populating ar_sha1 column legacy rows
rev_sha1 and ar_sha1 population complete [0 revision rows, 0 archive rows].
Populating img_sha1 field
Done 0 files in 0.0 seconds
Fixing protocol-relative entries in the externallinks table...
Done, 0 rows updated.
Populating fa_sha1 field from fa_storage_key
Done 0 files in 0.0 seconds
Updating *_from_namespace fields in links tables.
...doing page_id from 1 to 200
Adding empty categories with description pages...
Removing empty categories without description pages...
Category cleanup complete.
Populating page_props.pp_sortkey...
Populating page_props.pp_sortkey complete.
Updated a total of 0 rows
Copying IP revisions to ip_changes, from rev_id 0 to rev_id 1
...checking 1 revisions for IP edits that need copying, between rev_ids 0 and 1
Attempted to insert 0 IP revisions, 0 actually done.
Updating externallinks table index fields
Done, 0 rows updated, 0 deleted.
Purging caches...done.
Done in 3.1 s.
urbanecm@LAPTOP-A3BHKQ07 /var/www/html/mw-sqlite
$ sudo -u www-data sqlite3 ../../data/sqlitewiki.sqlite
SQLite version 3.27.2 2019-02-25 16:06:06
Enter ".help" for usage hints.
sqlite> .schema oathauth_users
CREATE TABLE IF NOT EXISTS "oathauth_users" (
id INTEGER not null primary key,
module text not null,
data BLOB null
);
sqlite> select * from oathauth_users;
1||
sqlite>

Event Timeline

Urbanecm created this paste.Sun, Oct 4, 8:35 PM