554888 - Update RSVP app

Status: RESOLVED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Description

[Michael Morgan [:morgamic]]

Need to update the rsvp app.

1. run http://svn.mozilla.org/projects/rsvp.mozilla.com/trunk/sql/rsvp.sql on the database in stage and prod

2. svn up on both (production tag has since been updated)

3. we should force SSL on both of these instances -- we're transmitting personal info.

Comment 1

[Reed Loden [:reed]]

Also, ensure that admin/ is protected to only users with the RSVPAdmin (I believe that's what it's called, but you should probably double-check) LDAP bit.

Comment 2

[Shyam Mani [:fox2mike]]

Updated DB and code on stage.

Comment 3

[Shyam Mani [:fox2mike]]

Update code on prod :

[root@mradm02 rsvp.mozilla.com]# svn up
U    sql/rsvp.sql
D    htdocs/css/dalvay
D    htdocs/css/rustico
D    htdocs/css/base
U    htdocs/css/screen.css
A    htdocs/css/fonts
A    htdocs/css/fonts/Chunkfive.svg
A    htdocs/css/fonts/Chunkfive.woff
A    htdocs/css/fonts/Chunkfive.eot
A    htdocs/css/fonts/Chunkfive.otf
A    htdocs/css/min.css
A    htdocs/css/ui-lightness
A    htdocs/css/ui-lightness/images
A    htdocs/css/ui-lightness/images/ui-bg_gloss-wave_35_f6a828_500x100.png
A    htdocs/css/ui-lightness/images/ui-icons_ef8c08_256x240.png
A    htdocs/css/ui-lightness/images/ui-bg_diagonals-thick_18_b81900_40x40.png
A    htdocs/css/ui-lightness/images/ui-bg_highlight-soft_75_ffe45c_1x100.png
A    htdocs/css/ui-lightness/images/ui-icons_ffffff_256x240.png
A    htdocs/css/ui-lightness/images/ui-bg_flat_10_000000_40x100.png
A    htdocs/css/ui-lightness/images/ui-bg_glass_100_fdf5ce_1x400.png
A    htdocs/css/ui-lightness/images/ui-bg_glass_65_ffffff_1x400.png
A    htdocs/css/ui-lightness/images/ui-bg_diagonals-thick_20_666666_40x40.png
A    htdocs/css/ui-lightness/images/ui-icons_228ef1_256x240.png
A    htdocs/css/ui-lightness/images/ui-bg_highlight-soft_100_eeeeee_1x100.png
A    htdocs/css/ui-lightness/images/ui-icons_ffd27a_256x240.png
A    htdocs/css/ui-lightness/images/ui-bg_glass_100_f6f6f6_1x400.png
A    htdocs/css/ui-lightness/images/ui-icons_222222_256x240.png
A    htdocs/css/ui-lightness/jquery-ui-1.8rc3.custom.css
A    htdocs/.htaccess
D    htdocs/img/template
A    htdocs/img/footer.png
A    htdocs/img/happy.png
A    htdocs/img/header-border.png
A    htdocs/img/body.jpg
A    htdocs/img/arrow.png
A    htdocs/img/tab-mozilla.png
D    htdocs/js/jquery-1.2.3.min.js
A    htdocs/js/jquery-1.4.2.min.js
A    htdocs/js/jquery-ui-1.8rc3.custom.min.js
U    htdocs/index.php
U    lib/rsvp.php
U    bin/email.php
U    inc/footer.php
U    inc/header.php
 U   .

Fetching external item into 'lib/yadbc'
Updated external to revision 64768.

Updated to revision 64768.

Ran SQL :

mysql> DROP TABLE IF EXISTS `reservations`;
Query OK, 0 rows affected (0.19 sec)

mysql> CREATE TABLE `reservations` (
    ->   `id` varchar(40) NOT NULL default '',
    ->   `email` varchar(255) NOT NULL default '',
    ->   `pref_email` varchar(255) NOT NULL default '',
    ->   `firstname` varchar(255) NOT NULL default '',
    ->   `middlename` varchar(255) NOT NULL default '',
    ->   `lastname` varchar(255) NOT NULL default '',
    ->   `dob` varchar(255) NOT NULL default '',
    ->   `invited` tinyint(1) unsigned NOT NULL default '0',
    ->   `coming` tinyint(1) unsigned NOT NULL default '0',
    ->   `phone` varchar(255) NOT NULL default '',
    ->   `ircnick` varchar(255) NOT NULL default '',
    ->   `diet` varchar(255) NOT NULL default '',
    ->   `street` varchar(255) NOT NULL default '',
    ->   `city` varchar(255) NOT NULL default '',
    ->   `state` varchar(255) NOT NULL default '',
    ->   `country` varchar(255) NOT NULL default '',
    ->   `citizenship` varchar(255) NOT NULL default '',
    ->   `zip` varchar(255) NOT NULL default '',
    ->   `tshirt` varchar(255) NOT NULL default '',
    ->   `passport` varchar(255) NOT NULL default '',
    ->   `passportnumber` varchar(255) NOT NULL default '',
    ->   `passportexpire` varchar(255) NOT NULL default '',
    ->   `departureairport` varchar(255) NOT NULL default '',
    ->   `departuredate` varchar(255) NOT NULL default '',
    ->   `departuretime` varchar(255) NOT NULL default '',
    ->   `returnairport` varchar(255) NOT NULL default '',
    ->   `returndate` varchar(255) NOT NULL default '',
    ->   `airlineprefs` varchar(255) NOT NULL default '',
    ->   `gender` varchar(255) NOT NULL default '',
    ->   `summitprefs` varchar(255) NOT NULL default '',
    ->   `created` datetime NOT NULL,
    ->   `modified` datetime NOT NULL,
    ->   KEY `id` (`id`,`email`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.06 sec)

Site only works with https already and /admin already has auth, members of the RSVPadmins group can access that.