541982 - Set up Live Chat login migration on support-stage.mozilla.org

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Matthew Middleton (:zzxc)]

In order to complete the test plan for Live Chat login migration (https://wiki.mozilla.org/Support/Live_Chat/SUMO_login/Testing), we need this set up on staging.  Openfire and TikiWiki each need to connect to each others' databases during the migration, so the configuration must be updated on each.

Instructions for setting this up on support-stage.mozilla.org:
# Update db/local.php by filling in the Openfire database host, name, username, and password
# Run scripts/livechat/migration-script.php to complete automatic migration.  (Make sure sending mail from staging is turned off at this stage, to avoid spamming all live chat contributors)

Once these steps are completed, testing of auto-migrated accounts and tiki-livechat_migration.php can begin.

Comment 1

[Matthew Middleton (:zzxc)]

This is blocking the test of the migration script, so it should be done ASAP.

Comment 2

[Aravind Gottipati [:aravind]]

I have to go down to the colo today, so I will ping folks in server-ops and see if they can handle this.

Comment 3

[Jeremy Orem [:oremj]]

Which openfire instance/database should this point to?

Comment 4

[Matthew Middleton (:zzxc)]

On support-stage, it should point to chat-support-stage's database.

On production, it will point to chat-support, but this bug only concerns staging.

Comment 5

[Jeremy Orem [:oremj]]

cat local.php.dist 
<?php
$db_tiki='mysql';
$dbversion_tiki='1.10';
$host_tiki='localhost';
$user_tiki='mysqluser';
$pass_tiki='mysqluserpw';
$dbs_tiki='mysqldbname';

$memcached_options = array(
    'enabled'            => TRUE,
    'expiration'         => 3600,
    'key_prefix'         => 'sumo_',
    'flags'              => MEMCACHE_COMPRESSED,
    'cache_forum_output' => TRUE,
    'cache_wiki_output'  => TRUE,
    'cache_wiki_data'    => FALSE
);

$memcached_servers = array(
    array(
        'host'   => '127.0.0.1',
        'port'   => '11211',
        'weight' => '1'
    )
);
?>

Where do the openfire db settings go?

Comment 6

[Stephen Donner [:stephend] Not actively reading bugmail]

Matthew, please respond to comment 5; thanks!

Comment 7

[Matthew Middleton (:zzxc)]

It looks like a boilerplate for this was never checked in.  It should be:

$host_of=''; //hostname
$user_of=''; //username
$pass_of=''; //password
$dbs_of='openfire_chat'; //database name

(Just add the above lines under the tiki database lines)

Comment 8

[Stephen Donner [:stephend] Not actively reading bugmail]

(This is blocking my testing of an already-delayed release; expediency is appreciated :-)

Comment 9

[Jeremy Orem [:oremj]]

local.php has been updated and migration script was run.

Comment 10

[Matthew Middleton (:zzxc)]

This needs to be run again, after the change from bug 543115 is picked up.  The query in bug 542025 should be run just before executing this script.

Comment 11

[Jeremy Orem [:oremj]]

[root@mrapp-stage02 livechat]# php -f migration-script.php
1a. Updating Tiki database for same-email users... 1 distinct emails... Done.
1b. Emailing the above Openfire users... Done.
1c. Removing them from the Openfire database... Done.
2.  Emailing rest of OpenFire accounts (with email set)... 3 distinct emails... Done
3.  Creating livechat_id for non-conflicting TikiWiki accounts...


149734 rows..

Comment 12

[Jeremy Orem [:oremj]]

Note: need to run "UPDATE users_users SET livechat_id=NULL;" before the migration.

Comment 14

[Stephen Donner [:stephend] Not actively reading bugmail]

Now that the RPM is available in https://bugzilla.mozilla.org/show_bug.cgi?id=541983#c7, will this need to be re-run, Matthew?

Comment 15

[Matthew Middleton (:zzxc)]

We should go ahead and run this script again, with updated databases, now that bug 543115 has been patched.

The steps that need to happen this time:
1. Import a fresh copy of the Openfire database from production to staging
2. Restart Openfire
3. On tikiwiki's database, run the query in comment 12
4. Execute the automatic import script (./migration-script.php --no-email)

Comment 16

[Jeremy Orem [:oremj]]

1. Done in a different bug
2. Done.
3. mysql> UPDATE users_users SET livechat_id=NULL;
Query OK, 149198 rows affected (12.03 sec)
Rows matched: 149739  Changed: 149198  Warnings: 0
4. Running...

Comment 17

[Jeremy Orem [:oremj]]

1a. Updating Tiki database for same-email users... 298 distinct emails... Done.
1c. Removing them from the Openfire database... Done.
3.  Creating livechat_id for non-conflicting TikiWiki accounts... 148876 rows...

Comment 18

[Stephen Donner [:stephend] Not actively reading bugmail]

Linked in https://wiki.mozilla.org/Support/Live_Chat/SUMO_login/Testing, https://support-stage.mozilla.org/tiki-livechat-migration.php is a 404 :-(

Comment 19

[Matthew Middleton (:zzxc)]

Fixed the link, it should be https://support-stage.mozilla.org/tiki-livechat_migration.php