Bug 1034552

Summary: Postgresql-9.2 can not be added to zend-6.1 applications
Product: OpenShift Online Reporter: Qiushui Zhang <qiuzhang>
Component: ImageAssignee: Vojtech Vitek <vvitek>
Status: CLOSED CURRENTRELEASE QA Contact: libra bugs <libra-bugs>
Severity: medium Docs Contact:
Priority: medium    
Version: 2.xCC: dmcphers, hripps, mfojtik, xtian
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-01-30 00:50:52 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
broker and node log none

Description Qiushui Zhang 2013-11-26 05:49:03 UTC
Created attachment 829068 [details]
broker and node log

Description of problem:
Trying to add postgresql-9.2 to a zend-6.1 application.
It will fail with errors: "pg_ctl: symbol lookup error: /lib64/libldap_r-2.4.so.2: undefined symbol: ber_sockbuf_io_udp"

Version-Release number of selected component (if applicable):
vvitek-Zend-QE-preserve

How reproducible:
always

Steps to Reproduce:
1. Create a zend-6.1 app
2. Try to add postgresql-9.2 to the app
rhc cartridge add zd1 zend-6.1 postgresql-9.2

Actual results:
It fails with errors, saying "pg_ctl: symbol lookup error: /lib64/libldap_r-2.4.so.2: undefined symbol: ber_sockbuf_io_udp"

Expected results:
Postgresql should be added successfully

Additional info:
1. Postgresql-8.4 works OK
2. Logs are added to the bug attachment

Comment 1 Qiushui Zhang 2013-11-26 05:59:16 UTC
The command used in step 2 to add cartridge is:
rhc cartridge add postgresql-9.2 -a zd1

Like the following:

[openshift@dhcp-10-143 tmp]$ rhc cartridge add postgresql-9.2 -a zd1
Adding postgresql-9.2 to application 'zd1' ... pg_ctl: symbol lookup error: /lib64/libldap_r-2.4.so.2: undefined symbol: ber_sockbuf_io_udp

Sorry for the wrong pasting.

Comment 5 openshift-github-bot 2013-12-06 18:00:56 UTC
Commit pushed to master at https://github.com/openshift/li

https://github.com/openshift/li/commit/42890fc9ab68af211d9f394f694d72d27b883612
fix secondary carts failures due to zend-6.1 LD_LIBRARY_PATH

This is rather workaround fix for:

  Bug 1034552 - Postgresql-9.2 can not be added to zend-6.1 applications
  https://bugzilla.redhat.com/show_bug.cgi?id=1034552

  Bug 1034583 - Fail to add Jenkins client to zend-6.1 apps
  https://bugzilla.redhat.com/show_bug.cgi?id=1034583

until we implement "Handle multiple catridges having their
own LD_LIBRARY_PATH" feature request. https://trello.com/c/BB2errnd

Comment 6 Qiushui Zhang 2013-12-09 05:42:45 UTC
Tested on devenv_4111.

rhc app create zd zend-6.1
rhc cartridge add postgresql-9.2 -a zd

Adding postgresql-9.2 to application 'zd' ... done

postgresql-9.2 (PostgreSQL 9.2)
-------------------------------
  Gears:          Located with zend-6.1
  Connection URL: postgresql://$OPENSHIFT_POSTGRESQL_DB_HOST:$OPENSHIFT_POSTGRESQL_DB_PORT
  Database Name:  zd
  Password:       cBl6m6tM4sav
  Username:       adminragb92z

PostgreSQL 9.2 database added.  Please make note of these credentials:

   Root User: adminragb92z
   Root Password: cBl6m6tM4sav
   Database Name: zd

Connection URL: postgresql://$OPENSHIFT_POSTGRESQL_DB_HOST:$OPENSHIFT_POSTGRESQL_DB_PORT

After adding, the database can be visit and control normally.

Mark the bug as verified.