502089 - Database schema and data for 'clean' SUMO install

Status: RESOLVED FIXED

(support.mozilla.org :: Knowledge Base Software, task)

Description

[E. Cooper [:ecooper]]

This 'dump' should consist of the basic tiki db tables, the added SUMO tables, and then a specific set of data including 'permissions, admin option setup, and admin modules' and anything else required to run a SUMO install out of the box.

Comment 1

[E. Cooper [:ecooper]]

Some very simple statistics I came across this morning while narrowing down what data we need to keep in the tables:

show table status;
230 rows in set (0.03 sec)

show table status where Rows=0;
142 rows in set (0.03 sec)

show table status where Rows>0;
88 rows in set (0.03sec)

On SUMO, over half (nearly 62%) of the tiki tables contain absolutely no rows.

Comment 2

[E. Cooper [:ecooper]]

This is too big for bugzilla. A rough cut can be found on dm-sumotools1 in my home folder under 'p10n/schema/sumo_selected_data_schema.sql'.

What it needs still:
*seeded with the pool options and questions, happening tonight
*figure out what's missing... :-/

Question is, how SUMO is this? Currently, the only content included outside the base tiki install is as follows: the languages (translated strings and enabled), modules, groups, permissions, and preferences. Things like categories aren't included.

Comment 3

[E. Cooper [:ecooper]]

(In reply to comment #2)
> This is too big for bugzilla. A rough cut can be found on dm-sumotools1 in my
> home folder under 'p10n/schema/sumo_selected_data_schema.sql'.
> 
> What it needs still:
> *seeded with the pool options and questions, happening tonight
> *figure out what's missing... :-/
> 
> Question is, how SUMO is this? Currently, the only content included outside the
> base tiki install is as follows: the languages (translated strings and
> enabled), modules, groups, permissions, and preferences. Things like categories
> aren't included.

This is updated some dir. Entries are dated now, so just use the newest one if you want to take a look at it.

Comment 4

[Paul Craciunoiu [:paulc]]

I'm up for taking this. Would like some input from laura on the current script though :)

Comment 5

[Laura Thomson :laura]

We do need categories IMHO
Looks like we got all the CSAT stuff.

It's looking fairly complete to me.  The way to test, I would suggest, is to get
a fresh checkout and point it at this database, and see what's broken.  (You
can start with QA's BFTs.)  Lots of attention to detail will be needed.

Let's get that test server up for this (file an IT bug).  We should enlist some QA help as well.

Comment 6

[Paul Craciunoiu [:paulc]]

* Added "Additional categories" that are not Firefox specific
* Added some permissions -- copied over tables users_grouppermissions and users_objectpermissions, and users_permissions from the SUMO db
* Showed the Admin option for the menu for System Admins (that didn't show up for some reason).
* Set the Admin user in the proper group (System Admins) and also assigned it the other registered groups (ensures full functionality of the site)
* Created notification content for: editing pages with bad characters, registering, watching a category

I did this while looking at the Litmus BFT tests here:
https://litmus.mozilla.org/show_test.cgi?searchType=by_category&product_id=12&branch_id=30&testgroup_id=127&subgroup_id=1204

All those that can be done seem to work fine. E.g. there is no "Ask a question" page and Forums home page, etc. so I only did the ones that are applicable.

I've placed this in my homedir at:
/home/pcraciunoiu/p10n/schema (there's a gzipped version too).

Take a look Laura and let me know if I missed anything.

Comment 7

[Laura Thomson :laura]

This looks good - r+.  Let's try it out on our test server next.

Comment 8

[Laura Thomson :laura]

Can you get this committed and point stephend at the test server?  I hear it's working on there ;)

Comment 9

[Paul Craciunoiu [:paulc]]

r50328 / r50329

Test server is at http://dm-sumotest01.mozilla.org/
I reopened the IT bug 510005 since the httpd.conf keeps getting replaced.

Comment 10

[Carsten Schmitz]

Hello!

How can a non-team-member user access the basic DB dump to start?