The drupal6 charm does not install on power.

[Matt Bruzek]

I am doing testing of the charms on power hardware (ppc64le) and the drupal6 charm does not deploy.

It looks like the PPA that is added in the install hook has some unresolved problems:
add-apt-repository ppa:nginx/stable

Here is the output in the unit-drupal6-0.log

2014-09-18 21:58:11 INFO install The following information may help to resolve the situation:
2014-09-18 21:58:11 INFO install
2014-09-18 21:58:11 INFO install The following packages have unmet dependencies:
2014-09-18 21:58:11 INFO install nginx : Depends: nginx-full (>= 1.6.2-1+trusty0) but it is not going to be installed or
2014-09-18 21:58:11 INFO install nginx-light (>= 1.6.2-1+trusty0) but it is not going to be installed or
2014-09-18 21:58:11 INFO install nginx-extras (>= 1.6.2-1+trusty0) but it is not going to be installed or
2014-09-18 21:58:11 INFO install nginx-naxsi (>= 1.6.2-1+trusty0) but it is not going to be installed
2014-09-18 21:58:11 INFO install Depends: nginx-full (< 1.6.2-1+trusty0.1~) but it is not going to be installed or
2014-09-18 21:58:11 INFO install nginx-light (< 1.6.2-1+trusty0.1~) but it is not going to be installed or
2014-09-18 21:58:11 INFO install nginx-extras (< 1.6.2-1+trusty0.1~) but it is not going to be installed or
2014-09-18 21:58:11 INFO install nginx-naxsi (< 1.6.2-1+trusty0.1~) but it is not going to be installed
2014-09-18 21:58:11 INFO install E: Unable to correct problems, you have held broken packages.
2014-09-18 21:58:11 ERROR juju.worker.uniter uniter.go:486 hook failed: exit status 100

When the ppa was removed, drupal was able to install on trusty (14.04).

[Matt Bruzek (mbruzek)]

No power port available on ppa?

[Johnny Shieh (jshieh)]

Brandon,

  Any chances of a port of this to trusty and ppc64le?

[Antonio Rosales (arosales)]

Collaborating with IBM this is a workload that should be enabled for ppc64el. We need to determine the following:
- install nginx from Trusty
- confirm nginx support for Trusty
- propose Trusty charm

[Mahesh Waidande (mahesh-waidande1248)]

I am working on porting drupla6 juju charm to ppc64le trusty version. I am able to deploy it and able to create relation with MySQL. While installing drupla6 charm I am facing below warning which is interrupting the installation process.

 • User warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#039;) ORDER BY fit DESC LIMIT 0, 1&#039; at line 1 query: SELECT * FROM pf_menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in _db_query() (line 170 of /var/www/drupal/includes/database.mysql.inc).
• User warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#039;) ORDER BY fit DESC LIMIT 0, 1&#039; at line 1 query: SELECT * FROM pf_menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in _db_query() (line 170 of /var/www/drupal/includes/database.mysql.inc).

Internally drupla6 juju charm clones the pressflow and deploys it. Pressflow is a clone of drupal with some enhancement http://www.pressflow.org/.

I am working resolving above warnings. I also raise a bug against pressflow on github ( https://github.com/pressflow/6/issues/100 ) regarding the warnings. For more information I have attached snapshot of warnings along with this post. I will update this bug as an when I find something to share.