727104 - [DTPT] Update Dev and Stage for De Todos Para Todos (to support database)

Status: RESOLVED FIXED

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

Description

[Christie Koehler [:ckoehler]]

The updated code for DTPT now requires a database. Connection details are in bug 725696.

Please update the dev and stage environments with the most recent changes from Github and setup database support as follows:

1.. Update db name and credentials in tab/db.config.php (copied from db.config.php.sample).
2. Run tab/mysql/feb012012.sql from command line.
3. Block web access to tab/mysql/feb012012.sql via apache conf (or less us know if it should be done via htaccess).

Thanks!

Comment 1

[Brandon Burton [:solarce]]

Can you please explain the reasoning behind wanting access to the .sql file done, when it's available on https://github.com/Nobox/Mozilla-DeTodosParaTodos-Site/blob/master/tab/mysql/feb012012.sql for anyone to get?

Comment 2

[Brandon Burton [:solarce]]

Not done, but blocked

Comment 3

[Christie Koehler [:ckoehler]]

(In reply to Brandon Burton [:solarce] from comment #1)
> Can you please explain the reasoning behind wanting access to the .sql file
> done, when it's available on
> https://github.com/Nobox/Mozilla-DeTodosParaTodos-Site/blob/master/tab/mysql/
> feb012012.sql for anyone to get?

That's a good point. Please disregard that step.

Comment 4

[Christie Koehler [:ckoehler]]

(In reply to Brandon Burton [:solarce] from comment #2)
> Not done, but blocked

What is blocking this?

Comment 5

[Brandon Burton [:solarce]]

Sorry, poor choice of words. I wrote "Can you please explain the reasoning behind wanting access to the .sql file *done*" and meant "Can you please explain the reasoning behind wanting access to the .sql file *blocked*.

:jd is working on this now :)

Comment 6

[Jason Crowe [:jd]]

Christie,

Sorry for the delay.  Due to some confusion the databases were created on the incorrect servers.  This has been corrected.  I created databases for dev/stage/prod and imported feb012012.sql for all three.

I created the tab/db.config.php file for all three instances as well.  I updated both dev and stage from github.  The change is already set up on prod so it will get this configuration on the next push/update.

As per the previous discussion I did not block access to the feb012012.sql file through Apache.

Please let me know if you need further assistance or if anything does not work as expected.

Regards

Comment 7

[Christie Koehler [:ckoehler]]

Thanks, JD. I'm getting an error at this page (the one that uses the db), will you take a look?
http://detodosparatodos-dev.allizom.org/tab/

Comment 8

[Jason Crowe [:jd]]

Fixed it, that was my fault.  Should be good to go now.

Cheers