#753 - set up an order system to let eyeo employees file order requests

manifests/issuesserver.pp

 node 'issues1' {
 
   include base, private::trac
 
   class {'trac':
     domain => 'issues.adblockplus.org',
     certificate => 'issues.adblockplus.org_sslcert.pem',
     private_key => 'issues.adblockplus.org_sslcert.key',
     is_default => true,
   }
@@ skipping 15 matching lines @@
     database => 'trac_orders',
     permissions => "puppet:///modules/trac/order-permissions.csv",
   }
 
   # Transforming the auth_cookie table of the "new" Trac project into an
   # insertable view for the "old" project's table of the same name avoids
   # the need to convert the entire auth to htpasswd-file handling, which
   # would be the official way to go for achieving a shared authentication.
   exec { 'trac_auth_cookie_view':
     command => "mysql -utrac -p'${private::trac::database_password}' trac_orders --execute '
-      CREATE VIEW auth_cookie_view AS SELECT * FROM trac.auth_cookie;
-      RENAME TABLE auth_cookie TO auth_cookie_original, auth_cookie_view TO auth_cookie;'",

[Wladimir Palant, 2014/08/01 13:56:08]

Not addressed yet:

On 2014/07/31 09:46:53, Wladimir Palant wrote:

+      DROP TABLE IF EXISTS auth_cookie;
+      CREATE VIEW auth_cookie AS SELECT * FROM trac.auth_cookie;'",
     unless => "mysql -utrac -p'${private::trac::database_password}' trac_orders --execute '
       SHOW CREATE VIEW auth_cookie'",
     path => "/usr/bin:/usr/sbin:/bin:/usr/local/bin",
     require => [
       Exec["deploy_issues"],
       Exec["deploy_orders"],
     ],
   }
 
   # Synchronizing e-mail and password information between the project
@@ skipping 24 matching lines @@
 
   # Unfortunately, the spawn-fcgi module is not capable of stopping the
   # processes of pools that are changed to absent - simply because it removes
   # the configuration file and the subsequent reload or restart does not
   # recognize the pool any more. Thus, we have to ensure that the service is
   # stopped before:
   exec { 'tracd_kludge':
     command => 'service spawn-fcgi stop',
     onlyif => 'service spawn-fcgi status',
     path => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin',
+    notify => Service['spawn-fcgi'],
   }
 
   # Pretty similar to the "tracd" pool issue above: The trac-admin initenv
   # command would fail for environment-issues after creation of the directory
   # structure, when it comes to the database setup (which already exists),
   # if we do not handle the existing resources manually..
   exec { 'trac_env_issues_kludge':
     command => 'ln -s environment /home/trac/environment-issues',
     before => Exec['trac_env_issues'],
     path => "/usr/bin:/bin",
     user => trac,
-    onlyif => 'test -d /home/trac/environment',
+    onlyif => 'test -d /home/trac/environment && \
+      test ! -e /home/trac/environment-issues',
     require => User['trac'],
   }
 
   class {'nagios::client':
     server_address => 'monitoring.adblockplus.org'
   }
 }