Description of problem: When you create an application from the website using the application templates, the created application doesn't work. I tried to create applications from the following templates: * drupal * wordpress * ruby on rails All the created apps were broken. Version-Release number of selected component (if applicable): rhc-node-0.93.13-1.el6_2.x86_64 How reproducible: very Steps to Reproduce: 1. Go to the integration environment website 2. Create an application based on a template 3. Notice that the resulting app is broken Actual results: drupal: Notice: Undefined index: OPENSHIFT_DB_USERNAME in include_once() (line 186 of /var/lib/stickshift/5599331bd62a4b8ab72ba444763cc586/app-root/runtime/repo/php/sites/default/settings.php). Notice: Undefined index: OPENSHIFT_DB_PASSWORD in include_once() (line 187 of /var/lib/stickshift/5599331bd62a4b8ab72ba444763cc586/app-root/runtime/repo/php/sites/default/settings.php). Notice: Undefined index: OPENSHIFT_DB_HOST in include_once() (line 188 of /var/lib/stickshift/5599331bd62a4b8ab72ba444763cc586/app-root/runtime/repo/php/sites/default/settings.php). Notice: Undefined index: OPENSHIFT_DB_PORT in include_once() (line 189 of /var/lib/stickshift/5599331bd62a4b8ab72ba444763cc586/app-root/runtime/repo/php/sites/default/settings.php). PDOException: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in lock_may_be_available() (line 164 of /var/lib/stickshift/5599331bd62a4b8ab72ba444763cc586/app-root/runtime/repo/php/includes/lock.inc). WordPress: Error establishing a database connection Ruby On Rails: Service Temporarily Unavailable Expected results: All apps should work the same way that they do when you manually go through the quickstart creation from the github quickstarts.
The Ruby On Rails app finally deployed successfully (it took a long time). So disregard that one in the description above.
To be clear, I can manually connect to the drupal app's mysql instance, but when I look in the DB, I don't see any drupal tables: mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | druptst2 | | mysql | +--------------------+ 3 rows in set (0.00 sec) mysql> use druptst2 Database changed mysql> show tables; Empty set (0.00 sec) mysql>
Kraman had me stop and start the drupal app which got past the initial error, but now we get this error: Uncaught exception thrown in shutdown function. PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'druptst2.semaphore' doesn't exist: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 17226333334fc84f0aec45a2.32926404 ) in lock_release_all() (line 266 of /var/lib/stickshift/5599331bd62a4b8ab72ba444763cc586/app-root/runtime/repo/php/includes/lock.inc). This error is almost certainly because the drupal tables haven't been deployed to the DB (see comment 2).
*** Bug 827322 has been marked as a duplicate of this bug. ***
*** Bug 827329 has been marked as a duplicate of this bug. ***
Based on kraman's fixes to the quickstarts, applications should deploy successfully. Waiting for his pull requests to be accepted. This is no longer a blocker, since we know the fixes are on the quickstart side. If there are more problems, no changes would need to be made to the broker/packages.
Verified all 4 templates work now that kraman's changed have been pulled into the quickstart master repositories. Please note that when testing Rails, it will return a "503: Service Temporarily Unavailable" until the gems are installed and the server comes back up (usually take about 8 minutes). This is expected, although we are looking into the cause and a solution.
Tested 4 kind if template app on stage, they are all working now, so verify this bug.