Page MenuHomePhabricator

set up hiwikiversity on labsdb1010
Closed, ResolvedPublic

Description

I'm running a routine command for T170927 -- it works properly on lasbdb1009 and 1011 but errors out with

"pymysql.err.OperationalError: (1044, "Access denied for user 'maintainviews'@'localhost' to database 'hiwikiversity_p'")"

So, looks like a bit of setup is missing on that host.

Event Timeline

Marostegui claimed this task.
Marostegui added a subscriber: Marostegui.

Our beloved bug...
It is now fixed.

mysql:root@localhost [hiwikiversity_p]> show tables;
+---------------------------+
| Tables_in_hiwikiversity_p |
+---------------------------+
| abuse_filter              |
| abuse_filter_action       |
| abuse_filter_log          |
| archive                   |
| archive_userindex         |
| babel                     |
| category                  |
| categorylinks             |
| change_tag                |
| externallinks             |
| filearchive               |
| filearchive_userindex     |
| geo_tags                  |
| global_block_whitelist    |
| globalblocks              |
| image                     |
| imagelinks                |
| interwiki                 |
| ipblocks                  |
| ipblocks_ipindex          |
| iwlinks                   |
| l10n_cache                |
| langlinks                 |
| linter                    |
| logging                   |
| logging_logindex          |
| logging_userindex         |
| math                      |
| module_deps               |
| oldimage                  |
| oldimage_userindex        |
| page                      |
| page_props                |
| page_restrictions         |
| pagelinks                 |
| protected_titles          |
| recentchanges             |
| recentchanges_userindex   |
| redirect                  |
| revision                  |
| revision_userindex        |
| site_identifiers          |
| site_stats                |
| sites                     |
| tag_summary               |
| templatelinks             |
| transcode                 |
| updatelog                 |
| user                      |
| user_former_groups        |
| user_groups               |
| user_properties           |
| valid_tag                 |
| wbc_entity_usage          |
+---------------------------+
54 rows in set (0.01 sec)

mysql:root@localhost [hiwikiversity_p]> select * from page limit 1;
+---------+----------------+-----------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+
| page_id | page_namespace | page_title      | page_restrictions | page_is_redirect | page_is_new | page_random    | page_touched   | page_links_updated | page_latest | page_len | page_content_model | page_lang |
+---------+----------------+-----------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+
|       2 |              8 | Sitesupport-url |                   |                0 |           1 | 0.023435285621 | 20170803145313 | 20170803145313     |           2 |      109 | wikitext           | NULL      |
+---------+----------------+-----------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+
1 row in set (0.00 sec)