608023 - stage socorro create session database and update Kohana configs

Status: RESOLVED FIXED

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

Description

[Austin King [:ozten]]

Please execute the following SQL in stage:
CREATE TABLE sessions (
    session_id varchar(127) NOT NULL,
    last_activity integer NOT NULL,
    data text NOT NULL,
    CONSTRAINT session_id_pkey PRIMARY KEY (session_id),
    CONSTRAINT last_activity_check CHECK (last_activity >= 0)
);

Create a config:
cp webapp-php/system/config/session.php webapp-php/application/config/session.php

Edit and update
 $config['driver'] = 'database';

These instructions have also been added to
http://code.google.com/p/socorro/wiki/SocorroUpgrade

Related info: http://docs.kohanaphp.com/libraries/session

Comment 1

[Justin Dow [:jabba]]

breakpad=> CREATE TABLE sessions (
breakpad(>     session_id varchar(127) NOT NULL,
breakpad(>     last_activity integer NOT NULL,
breakpad(>     data text NOT NULL,
breakpad(>     CONSTRAINT session_id_pkey PRIMARY KEY (session_id),
breakpad(>     CONSTRAINT last_activity_check CHECK (last_activity >= 0)
breakpad(> );
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "session_id_pkey" for table "sessions"
CREATE TABLE
breakpad=> 


Done.