Release & enable the Sharing Engine on DEV

[jim]

(Documentation pending...)

The sharing engine needs releasing to DEV, and so far I've done the following:

• Added the files to SVN at /sharing-engine/trunk (see ​https://tech.transitionnetwork.org/trac/browser/sharing-engine/trunk)
• Created a new /web/news.dev.transitionnetwork.org.webarch.net/www folder, checked out the files.
• Created a new file (news.dev.transitionnetwork.org.webarch.net) under /etc/apache2/sites-available which started as a copy of the main dev.transitionnetwork.org.webarch.net but with the addresses updated.
• Symlinked it into sites-enabled
• Set up Drupal's settings.php with DEV DB settings
• Put a dump of the database onto DEV at /home/jim/sharing-engine.sql in preparation to put into the db with a database name of 'dev_sharing-engine'.

What needs to be done/help please == Server-side

• the Apache settings file doesn't appear to be being used - Chris, can you help? Is it because the main dev site has priority? When I go to ​http://news.dev.transitionnetwork.org.webarch.net/ I get the current dev site, not the news one.
• importing the mysql db dump into the database (am doing this now)

Website-side

• export of panels from my machine
• testing, testing
• feedback!!!

[jim]

Correction, that's dev_sharingengine for DB name... Now imported.

[chris]

The apache problem has been sorted out, the order of the files in /etc/apache2/sites-enabled is key when using wildcards, having the news site before the dev site has fixed it.

There now appears to be a MySQL issue;

The mysql error was: Access denied for user 'dev'@'localhost' to database 'dev_sharing-engine'.

I'll take a look at fixing this.

[chris]

I haven't sorted things out so that news.dev.transitionnetwork.org.webarch.net works with HTTPS, I'll also look at fixing that.

[chris]

The database name was wrong in /web/news.dev.transitionnetwork.org.webarch.net/www/sites/default/settings.php -- I have fixed this.

Also I have given the dev user all permissions on the database:

mysql> GRANT ALL ON dev_sharingengine.* TO 'dev'@'localhost';

I have also sorted out the HTTPS apache virtualhost, I think that's the lot so I'm closing the ticket, please reopen if I have missed anything.