Unable to start endtb distribution with provided database

mseaton · March 8, 2016, 4:23pm

Hi Bahmni team,

As of yesterday I started getting an error while trying to set up Bahmni for endtb with the database located here: https://bahmni-repo.twhosted.com/endtb/release-1.0/mysql_dump.sql

The error I am getting is as follows:

ERROR 1449 (HY000) at line 7501: The user specified as a definer ('openmrs-user'@'172.18.2.30') does not exist

Grepping the mysql_dump.sql file above for “172.18.2.30” returns the following:

[vagrant@192 deployment-artifacts]$ grep '172.18.2.30' mysql_dump.sql 
INSERT INTO `db` VALUES ('%','test','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','N','N','Y','Y'),('%','test\\_%','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','N','N','Y','Y'),('%','openmrs','openmrs-user','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'),('localhost','openmrs','openmrs-user','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'),('','openmrs','openmrs-user','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'),('172.18.2.30','openmrs','openmrs-user','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO `user` VALUES ('localhost','root','*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',NULL,'N'),('127.0.0.1','root','*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',NULL,'N'),('172.18.2.30','openmrs-user','*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'mysql_native_password','','N'),('localhost','openmrs-user','*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'mysql_native_password','','N'),('%','openmrs-user','*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'mysql_native_password','','N'),('','openmrs-user','*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'mysql_native_password','','N'),('172.18.2.30','root','*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'mysql_native_password','','N');
/*!50013 DEFINER=`openmrs-user`@`172.18.2.30` SQL SECURITY DEFINER */
/*!50013 DEFINER=`openmrs-user`@`172.18.2.30` SQL SECURITY DEFINER */
/*!50013 DEFINER=`openmrs-user`@`172.18.2.30` SQL SECURITY DEFINER */
[vagrant@192 deployment-artifacts]$

Can you please let me know if there is something I am doing wrong, or perhaps this database artifact was recently updated with this error (I wasn’t having this problem a few days ago)?

Perhaps instead of distributing this SQL separately it could be included within the endtb_config.zip (this would allow us to see it’s version history within the endtb_config repository).

@petmongrels / @shruthidipali / @maheshonopenmrs or others? (Not sure the right list to ping about endtb issues)

maheshonopenmrs · March 9, 2016, 10:51am

This sql is a full db dump (containing mysql system db and tables) and not just an OpenMRS database dump. If we restore this dump without any existing database, it works fine. In our earlier discussion, we spoke about removing unneccessary databases like jasperreports which we have done.

We are also working on providing just the openmrs database without any other database (like mysql). The ansible scripts will be updated to take care of creating a specified user mentioned here as part of the installation:

github.com

Bahmni/bahmni-playbooks/blob/master/group_vars/dev#L23


openmrs_modules_dir: /home/bahmni/.OpenMRS/modules
openmrs_run_dir: /var/run/openmrs
openmrs_context_path: openmrs
openmrs_server_options: "-Xms512m -Xmx1024m"


openmrs_auto_update_database: "true"
openmrs_db_username: openmrs-user
openmrs_db_password: password
openmrs_snapshots_tmp_dir: /tmp/openmrs-snapshots
openmrs_application_data_directory: /opt/openmrs/
openmrs_module_allow_web_admin: "true"


openelis_username: atomfeed
openelis_password: AdminadMIN*
openelis_db_username: clinlims
openelis_db_password: password


openerp_db_username: openerp
openerp_db_password: password
openerp_user: admin
openerp_password: password

We will update you when this is completed.

I hope this is not a blocker for you to test out Release 1.0. You can still get this deployed onto your machines and run Bahmni as usual.

We will be checking-in the updated version of endtb sql in endtb-config repo and update you. Please feel free to pull us in a call if required.

mseaton · March 9, 2016, 2:04pm

Thanks @maheshonopenmrs,

Hmm. I was actually experiencing this by simply running through the Ansible install on a fresh CentOS Vagrant box. I was aware of the issue of this dump containing all of the mysql tables.

If you are able to run through this without any errors, can you please share the setup.yml file that you are running the installation with?

Thanks, Mike

maheshonopenmrs · March 9, 2016, 3:29pm

I have tried several times (5-6) with the exact steps that we have mentioned in release notes and it was running perfectly fine. Please find my setup.yml file content here:

http://pastebin.com/UaVBEuxL

Can you please try again with this and let me know if you are able to run it without errors?

mseaton · March 18, 2016, 1:31pm

After a bunch more testing, I’m pretty sure this is a real issue. No matter what I do, I cannot get endtb to install using the database supplied under the 1.0 release.

Please confirm that you can get this to work using the database at: https://bahmni-repo.twhosted.com/endtb/release-1.0/mysql_dump.sql

Note: if I use the non-release-1.0 version, things work.

To be explicit…

This works: https://bahmni-repo.twhosted.com/endtb/mysql_dump.sql This does not work: https://bahmni-repo.twhosted.com/endtb/release-1.0/mysql_dump.sql

cioan · March 18, 2016, 1:43pm

Here is the error I see when using release-1.0/mysql_dump.sql:

> TASK: [bahmni-emr | Install openmrs database dump if provided and database does not exist] *** 
> <localhost> EXEC ['/bin/sh', '-c', 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1458306012.35-61858280348940 && echo $HOME/.ansible/tmp/ansible-tmp-1458306012.35-61858280348940']
> <localhost> PUT /opt/bahmni-installer/bahmni-playbooks/roles/bahmni-emr/files/restore_mysql_dump.sh TO /root/.ansible/tmp/ansible-tmp-1458306012.35-61858280348940/restore_mysql_dump.sh
> <localhost> EXEC /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=uemuhvoxzdttpnzzsarmtryryqbwjhdm] password: " -u root /bin/sh -c '"'"'echo BECOME-SUCCESS-uemuhvoxzdttpnzzsarmtryryqbwjhdm; chmod +rx /root/.ansible/tmp/ansible-tmp-1458306012.35-61858280348940/restore_mysql_dump.sh'"'"''
> <localhost> EXEC $SHELL -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=xffenebkcakxvpxcsdsisgijpwshkcxf] password: " -u root $SHELL -c '"'"'echo BECOME-SUCCESS-xffenebkcakxvpxcsdsisgijpwshkcxf; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /root/.ansible/tmp/ansible-tmp-1458306012.35-61858280348940/restore_mysql_dump.sh '"'"''
> <localhost> EXEC ['/bin/sh', '-c', 'rm -rf /root/.ansible/tmp/ansible-tmp-1458306012.35-61858280348940/ >/dev/null 2>&1']
> failed: [localhost] => {"changed": true, "rc": 1}
> stderr: + . /etc/bahmni-installer/bahmni.conf
> ++ IMPLEMENTATION_NAME=endtb
> ++ OPENMRS_DB_USERNAME=openmrs-user
> ++ OPENMRS_DB_PASSWORD=password
> ++ OPENMRS_DB_SERVER=localhost
> ++ MYSQL_ROOT_USER=root
> ++ MYSQL_ROOT_PASSWORD=password
> ++ mysql -h localhost -uroot -ppassword --skip-column-names -e 'SHOW DATABASES LIKE '\''openmrs'\'''
> Warning: Using a password on the command line interface can be insecure.
> + RESULT=
> + '[' '' '!=' openmrs ']'
> + echo 'openmrs database not found... Restoring a base dump'
> + mysql -h localhost -uroot -ppassword
> Warning: Using a password on the command line interface can be insecure.
> ERROR 1449 (HY000) at line 7501: The user specified as a definer ('openmrs-user'@'172.18.2.30') does not exist

> stdout: openmrs database not found... Restoring a base dump


> FATAL: all hosts have already failed -- aborting

maheshonopenmrs · March 18, 2016, 2:27pm

@mseaton, @cioan, @jmbabazi, can you please try using this database dump instead and let us know if you are still facing the same issue. This database dump is having UAT fixes.

darius · March 18, 2016, 5:15pm

I just tried this out based on the original instruction, and I got the same error that @mseaton is describing.

The exact commands I did are here (I tried this twice and it failed the same way both times):

gist.github.com

https://gist.github.com/djazayeri/6bd4426a4501cb096e92

installing-endtb.txt

-- these three lines are in my osx shell
vagrant init bento/centos-6.7
vagrant up
vagrant ssh

-- from here it's in the centos vm
sudo su
yum install https://bahmni-repo.twhosted.com/rpm/bahmni/bahmni-installer-0.80-139.noarch.rpm
yum install unzip
wget https://bahmni-repo.twhosted.com/endtb/release-1.0/mysql_dump.sql

This file has been truncated. show original

(Now I will try this with the new database dump.)

darius · March 18, 2016, 5:40pm

I tried with the new database (exactly my recipe from before but getting the db dump via

wget https://raw.githubusercontent.com/Bahmni/endtb-config/release-0.80/dbdump/mysql_dump.sql

The final error:

gist.github.com

https://gist.github.com/djazayeri/ed43212061b2cfe0d033#file-gistfile1-txt

a few lines up this also printed out in red

TASK: [bahmni-web | Check if bahmni-web rpm needs an update] ****************** 
<localhost> REMOTE_MODULE command yum list installed bahmni-web
<localhost> EXEC ['/bin/sh', '-c', 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1458322206.16-84569702859029 && echo $HOME/.ansible/tmp/ansible-tmp-1458322206.16-84569702859029']
<localhost> PUT /tmp/tmpv5eMMc TO /root/.ansible/tmp/ansible-tmp-1458322206.16-84569702859029/command
<localhost> EXEC /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=ctcjhexfztakavtkimdxfycvgssgyovq] password: " -u root /bin/sh -c '"'"'echo BECOME-SUCCESS-ctcjhexfztakavtkimdxfycvgssgyovq; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /root/.ansible/tmp/ansible-tmp-1458322206.16-84569702859029/command; rm -rf /root/.ansible/tmp/ansible-tmp-1458322206.16-84569702859029/ >/dev/null 2>&1'"'"''
failed: [localhost] => {"changed": true, "cmd": ["yum", "list", "installed", "bahmni-web"], "delta": "0:00:02.111244", "end": "2016-03-18 23:00:08.458928", "rc": 1, "start": "2016-03-18 23:00:06.347684", "warnings": ["Consider using yum module rather than running yum"]}
stderr: Error: No matching Packages to list
stdout: Loaded plugins: fastestmirror
...ignoring

gistfile1.txt

TASK: [bahmni-web | Install bahmni-web from bahmni repo] ********************** 
<localhost> REMOTE_MODULE yum name="bahmni-web-0.80-325" state=present
<localhost> EXEC ['/bin/sh', '-c', 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1458322213.49-150058880080286 && echo $HOME/.ansible/tmp/ansible-tmp-1458322213.49-150058880080286']
<localhost> PUT /tmp/tmp9dhOuN TO /root/.ansible/tmp/ansible-tmp-1458322213.49-150058880080286/yum
<localhost> EXEC /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=yhjrliogvivgmqvssmicpchhrjalqmou] password: " -u root /bin/sh -c '"'"'echo BECOME-SUCCESS-yhjrliogvivgmqvssmicpchhrjalqmou; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python -tt /root/.ansible/tmp/ansible-tmp-1458322213.49-150058880080286/yum; rm -rf /root/.ansible/tmp/ansible-tmp-1458322213.49-150058880080286/ >/dev/null 2>&1'"'"''
failed: [localhost] => {"changed": true, "rc": 1, "results": ["Loaded plugins: fastestmirror\nSetting up Install Process\nLoading mirror speeds from cached hostfile\n * base: mirrors.usc.edu\n * epel: linux.mirrors.es.net\n * extras: mirror.web-ster.com\n * updates: repos.forethought.net\nResolving Dependencies\n--> Running transaction check\n---> Package bahmni-web.noarch 0:0.80-325 will be installed\n--> Processing Dependency: python-flask for package: bahmni-web-0.80-325.noarch\n--> Processing Dependency: mod_wsgi for package: bahmni-web-0.80-325.noarch\n--> Processing Dependency: mod_ssl for package: bahmni-web-0.80-325.noarch\n--> Processing Dependency: httpd for package: bahmni-web-0.80-325.noarch\n--> Running transaction check\n---> Package httpd.x86_64 0:2.2.15-47.el6.centos.3 will be installed\n--> Processing Dependency: httpd-tools = 2.2.15-47.el6.centos.3 for package: httpd-2.2.15-47.el6.centos.3.x86_64\n--> Processing Dependency: apr-util-ldap for package: httpd-2.2.15-47.el6.centos.3.x86_64\n--> Processing Dependency: /etc/mime.types for package: httpd-2.2.15-47.el6.centos.3.x86_64\n--> Processing Dependency: libaprutil-1.so.0()(64bit) for package: httpd-2.2.15-47.el6.centos.3.x86_64\n--> Processing Dependency: libapr-1.so.0()(64bit) for package: httpd-2.2.15-47.el6.centos.3.x86_64\n---> Package mod_ssl.x86_64 1:2.2.15-47.el6.centos.3 will be installed\n---> Package mod_wsgi.x86_64 0:3.2-7.el6 will be installed\n---> Package python-flask.noarch 1:0.9-7.el6 will be installed\n--> Processing Dependency: python-werkzeug for package: 1:python-flask-0.9-7.el6.noarch\n--> Processing Dependency: python-jinja2-26 for package: 1:python-flask-0.9-7.el6.noarch\n--> Running transaction check\n---> Package apr.x86_64 0:1.3.9-5.el6_2 will be installed\n---> Package apr-util.x86_64 0:1.3.9-3.el6_0.1 will be installed\n---> Package apr-util-ldap.x86_64 0:1.3.9-3.el6_0.1 will be installed\n---> Package httpd-tools.x86_64 0:2.2.15-47.el6.centos.3 will be installed\n---> Package mailcap.noarch 0:2.1.31-2.el6 will be installed\n---> Package python-jinja2-26.noarch 0:2.6-3.el6 will be installed\n--> Processing Dependency: python-markupsafe for package: python-jinja2-26-2.6-3.el6.noarch\n---> Package python-werkzeug.noarch 0:0.8.3-2.el6 will be installed\n--> Running transaction check\n---> Package python-markupsafe.x86_64 0:0.9.2-4.el6 will be installed\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n================================================================================\n Package              Arch      Version                        Repository  Size\n================================================================================\nInstalling:\n bahmni-web           noarch    0.80-325                       bahmni      13 M\nInstalling for dependencies:\n apr                  x86_64    1.3.9-5.el6_2                  base       123 k\n apr-util             x86_64    1.3.9-3.el6_0.1                base        87 k\n apr-util-ldap        x86_64    1.3.9-3.el6_0.1                base        15 k\n httpd                x86_64    2.2.15-47.el6.centos.3         updates    831 k\n httpd-tools          x86_64    2.2.15-47.el6.centos.3         updates     77 k\n mailcap              noarch    2.1.31-2.el6                   base        27 k\n mod_ssl              x86_64    1:2.2.15-47.el6.centos.3       updates     95 k\n mod_wsgi             x86_64    3.2-7.el6                      base        66 k\n python-flask         noarch    1:0.9-7.el6                    epel       190 k\n python-jinja2-26     noarch    2.6-3.el6                      epel       527 k\n python-markupsafe    x86_64    0.9.2-4.el6                    base        22 k\n python-werkzeug      noarch    0.8.3-2.el6                    epel       552 k\n\nTransaction Summary\n================================================================================\nInstall      13 Package(s)\n\nTotal download size: 15 M\nInstalled size: 68 M\nDownloading Packages:\n--------------------------------------------------------------------------------\nTotal                                           795 kB/s |  15 MB     00:19     \nRunning rpm_check_debug\nRunning Transaction Test\nTransaction Test Succeeded\nRunning Transaction\n\r  Installing : apr-1.3.9-5.el6_2.x86_64                                    1/13 \n\r  Installing : apr-util-1.3.9-3.el6_0.1.x86_64                             2/13 \n\r  Installing : apr-util-ldap-1.3.9-3.el6_0.1.x86_64                        3/13 \n\r  Installing : httpd-tools-2.2.15-47.el6.centos.3.x86_64                   4/13 \n\r  Installing : python-werkzeug-0.8.3-2.el6.noarch                          5/13 \n\r  Installing : mailcap-2.1.31-2.el6.noarch                                 6/13 \n\r  Installing : httpd-2.2.15-47.el6.centos.3.x86_64                         7/13 \n\r  Installing : 1:mod_ssl-2.2.15-47.el6.centos.3.x86_64                     8/13 \n\r  Installing : mod_wsgi-3.2-7.el6.x86_64                                   9/13 \n\r  Installing : python-markupsafe-0.9.2-4.el6.x86_64                       10/13 \n\r  Installing : python-jinja2-26-2.6-3.el6.noarch                          11/13 \n\r  Installing : 1:python-flask-0.9-7.el6.noarch                            12/13 \n\r  Installing : bahmni-web-0.80-325.noarch                                 13/13 \nerror: Couldn't fork %post(bahmni-web-0:0.80-325.noarch): Cannot allocate memory\nerror: Couldn't fork %posttrans(httpd-2.2.15-47.el6.centos.3.x86_64): Cannot allocate memory\n\r  Verifying  : 1:python-flask-0.9-7.el6.noarch                             1/13 \n\r  Verifying  : python-markupsafe-0.9.2-4.el6.x86_64                        2/13 \n\r  Verifying  : apr-util-ldap-1.3.9-3.el6_0.1.x86_64                        3/13 \n\r  Verifying  : apr-1.3.9-5.el6_2.x86_64                                    4/13 \n\r  Verifying  : httpd-tools-2.2.15-47.el6.centos.3.x86_64                   5/13 \n\r  Verifying  : apr-util-1.3.9-3.el6_0.1.x86_64                             6/13 \n\r  Verifying  : 1:mod_ssl-2.2.15-47.el6.centos.3.x86_64                     7/13 \n\r  Verifying  : python-jinja2-26-2.6-3.el6.noarch                           8/13 \n\r  Verifying  : mailcap-2.1.31-2.el6.noarch                                 9/13 \n\r  Verifying  : mod_wsgi-3.2-7.el6.x86_64                                  10/13 \n\r  Verifying  : python-werkzeug-0.8.3-2.el6.noarch                         11/13 \n\r  Verifying  : bahmni-web-0.80-325.noarch                                 12/13 \n\r  Verifying  : httpd-2.2.15-47.el6.centos.3.x86_64                        13/13 \n\nDependency Installed:\n  apr.x86_64 0:1.3.9-5.el6_2                                                    \n  apr-util.x86_64 0:1.3.9-3.el6_0.1                                             \n  apr-util-ldap.x86_64 0:1.3.9-3.el6_0.1                                        \n  httpd-tools.x86_64 0:2.2.15-47.el6.centos.3                                   \n  mailcap.noarch 0:2.1.31-2.el6                                                 \n  mod_ssl.x86_64 1:2.2.15-47.el6.centos.3                                       \n  mod_wsgi.x86_64 0:3.2-7.el6                                                   \n  python-flask.noarch 1:0.9-7.el6                                               \n  python-jinja2-26.noarch 0:2.6-3.el6                                           \n  python-markupsafe.x86_64 0:0.9.2-4.el6                                        \n  python-werkzeug.noarch 0:0.8.3-2.el6                                          \n\nFailed:\n  bahmni-web.noarch 0:0.80-325       httpd.x86_64 0:2.2.15-47.el6.centos.3      \n\nComplete!\n"]}
msg: Error in POSTIN scriptlet in rpm package bahmni-web-0.80-325.noarch
Error in POSTTRANS scriptlet in rpm package httpd-2.2.15-47.el6.centos.3.x86_64

This file has been truncated. show original

A few lines before this was also red:

gist.github.com

https://gist.github.com/djazayeri/ed43212061b2cfe0d033#file-a-few-lines-up-this-also-printed-out-in-red

a few lines up this also printed out in red

TASK: [bahmni-web | Check if bahmni-web rpm needs an update] ****************** 
<localhost> REMOTE_MODULE command yum list installed bahmni-web
<localhost> EXEC ['/bin/sh', '-c', 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1458322206.16-84569702859029 && echo $HOME/.ansible/tmp/ansible-tmp-1458322206.16-84569702859029']
<localhost> PUT /tmp/tmpv5eMMc TO /root/.ansible/tmp/ansible-tmp-1458322206.16-84569702859029/command
<localhost> EXEC /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=ctcjhexfztakavtkimdxfycvgssgyovq] password: " -u root /bin/sh -c '"'"'echo BECOME-SUCCESS-ctcjhexfztakavtkimdxfycvgssgyovq; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /root/.ansible/tmp/ansible-tmp-1458322206.16-84569702859029/command; rm -rf /root/.ansible/tmp/ansible-tmp-1458322206.16-84569702859029/ >/dev/null 2>&1'"'"''
failed: [localhost] => {"changed": true, "cmd": ["yum", "list", "installed", "bahmni-web"], "delta": "0:00:02.111244", "end": "2016-03-18 23:00:08.458928", "rc": 1, "start": "2016-03-18 23:00:06.347684", "warnings": ["Consider using yum module rather than running yum"]}
stderr: Error: No matching Packages to list
stdout: Loaded plugins: fastestmirror
...ignoring

gistfile1.txt

TASK: [bahmni-web | Install bahmni-web from bahmni repo] ********************** 
<localhost> REMOTE_MODULE yum name="bahmni-web-0.80-325" state=present
<localhost> EXEC ['/bin/sh', '-c', 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1458322213.49-150058880080286 && echo $HOME/.ansible/tmp/ansible-tmp-1458322213.49-150058880080286']
<localhost> PUT /tmp/tmp9dhOuN TO /root/.ansible/tmp/ansible-tmp-1458322213.49-150058880080286/yum
<localhost> EXEC /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=yhjrliogvivgmqvssmicpchhrjalqmou] password: " -u root /bin/sh -c '"'"'echo BECOME-SUCCESS-yhjrliogvivgmqvssmicpchhrjalqmou; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python -tt /root/.ansible/tmp/ansible-tmp-1458322213.49-150058880080286/yum; rm -rf /root/.ansible/tmp/ansible-tmp-1458322213.49-150058880080286/ >/dev/null 2>&1'"'"''
failed: [localhost] => {"changed": true, "rc": 1, "results": ["Loaded plugins: fastestmirror\nSetting up Install Process\nLoading mirror speeds from cached hostfile\n * base: mirrors.usc.edu\n * epel: linux.mirrors.es.net\n * extras: mirror.web-ster.com\n * updates: repos.forethought.net\nResolving Dependencies\n--> Running transaction check\n---> Package bahmni-web.noarch 0:0.80-325 will be installed\n--> Processing Dependency: python-flask for package: bahmni-web-0.80-325.noarch\n--> Processing Dependency: mod_wsgi for package: bahmni-web-0.80-325.noarch\n--> Processing Dependency: mod_ssl for package: bahmni-web-0.80-325.noarch\n--> Processing Dependency: httpd for package: bahmni-web-0.80-325.noarch\n--> Running transaction check\n---> Package httpd.x86_64 0:2.2.15-47.el6.centos.3 will be installed\n--> Processing Dependency: httpd-tools = 2.2.15-47.el6.centos.3 for package: httpd-2.2.15-47.el6.centos.3.x86_64\n--> Processing Dependency: apr-util-ldap for package: httpd-2.2.15-47.el6.centos.3.x86_64\n--> Processing Dependency: /etc/mime.types for package: httpd-2.2.15-47.el6.centos.3.x86_64\n--> Processing Dependency: libaprutil-1.so.0()(64bit) for package: httpd-2.2.15-47.el6.centos.3.x86_64\n--> Processing Dependency: libapr-1.so.0()(64bit) for package: httpd-2.2.15-47.el6.centos.3.x86_64\n---> Package mod_ssl.x86_64 1:2.2.15-47.el6.centos.3 will be installed\n---> Package mod_wsgi.x86_64 0:3.2-7.el6 will be installed\n---> Package python-flask.noarch 1:0.9-7.el6 will be installed\n--> Processing Dependency: python-werkzeug for package: 1:python-flask-0.9-7.el6.noarch\n--> Processing Dependency: python-jinja2-26 for package: 1:python-flask-0.9-7.el6.noarch\n--> Running transaction check\n---> Package apr.x86_64 0:1.3.9-5.el6_2 will be installed\n---> Package apr-util.x86_64 0:1.3.9-3.el6_0.1 will be installed\n---> Package apr-util-ldap.x86_64 0:1.3.9-3.el6_0.1 will be installed\n---> Package httpd-tools.x86_64 0:2.2.15-47.el6.centos.3 will be installed\n---> Package mailcap.noarch 0:2.1.31-2.el6 will be installed\n---> Package python-jinja2-26.noarch 0:2.6-3.el6 will be installed\n--> Processing Dependency: python-markupsafe for package: python-jinja2-26-2.6-3.el6.noarch\n---> Package python-werkzeug.noarch 0:0.8.3-2.el6 will be installed\n--> Running transaction check\n---> Package python-markupsafe.x86_64 0:0.9.2-4.el6 will be installed\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n================================================================================\n Package              Arch      Version                        Repository  Size\n================================================================================\nInstalling:\n bahmni-web           noarch    0.80-325                       bahmni      13 M\nInstalling for dependencies:\n apr                  x86_64    1.3.9-5.el6_2                  base       123 k\n apr-util             x86_64    1.3.9-3.el6_0.1                base        87 k\n apr-util-ldap        x86_64    1.3.9-3.el6_0.1                base        15 k\n httpd                x86_64    2.2.15-47.el6.centos.3         updates    831 k\n httpd-tools          x86_64    2.2.15-47.el6.centos.3         updates     77 k\n mailcap              noarch    2.1.31-2.el6                   base        27 k\n mod_ssl              x86_64    1:2.2.15-47.el6.centos.3       updates     95 k\n mod_wsgi             x86_64    3.2-7.el6                      base        66 k\n python-flask         noarch    1:0.9-7.el6                    epel       190 k\n python-jinja2-26     noarch    2.6-3.el6                      epel       527 k\n python-markupsafe    x86_64    0.9.2-4.el6                    base        22 k\n python-werkzeug      noarch    0.8.3-2.el6                    epel       552 k\n\nTransaction Summary\n================================================================================\nInstall      13 Package(s)\n\nTotal download size: 15 M\nInstalled size: 68 M\nDownloading Packages:\n--------------------------------------------------------------------------------\nTotal                                           795 kB/s |  15 MB     00:19     \nRunning rpm_check_debug\nRunning Transaction Test\nTransaction Test Succeeded\nRunning Transaction\n\r  Installing : apr-1.3.9-5.el6_2.x86_64                                    1/13 \n\r  Installing : apr-util-1.3.9-3.el6_0.1.x86_64                             2/13 \n\r  Installing : apr-util-ldap-1.3.9-3.el6_0.1.x86_64                        3/13 \n\r  Installing : httpd-tools-2.2.15-47.el6.centos.3.x86_64                   4/13 \n\r  Installing : python-werkzeug-0.8.3-2.el6.noarch                          5/13 \n\r  Installing : mailcap-2.1.31-2.el6.noarch                                 6/13 \n\r  Installing : httpd-2.2.15-47.el6.centos.3.x86_64                         7/13 \n\r  Installing : 1:mod_ssl-2.2.15-47.el6.centos.3.x86_64                     8/13 \n\r  Installing : mod_wsgi-3.2-7.el6.x86_64                                   9/13 \n\r  Installing : python-markupsafe-0.9.2-4.el6.x86_64                       10/13 \n\r  Installing : python-jinja2-26-2.6-3.el6.noarch                          11/13 \n\r  Installing : 1:python-flask-0.9-7.el6.noarch                            12/13 \n\r  Installing : bahmni-web-0.80-325.noarch                                 13/13 \nerror: Couldn't fork %post(bahmni-web-0:0.80-325.noarch): Cannot allocate memory\nerror: Couldn't fork %posttrans(httpd-2.2.15-47.el6.centos.3.x86_64): Cannot allocate memory\n\r  Verifying  : 1:python-flask-0.9-7.el6.noarch                             1/13 \n\r  Verifying  : python-markupsafe-0.9.2-4.el6.x86_64                        2/13 \n\r  Verifying  : apr-util-ldap-1.3.9-3.el6_0.1.x86_64                        3/13 \n\r  Verifying  : apr-1.3.9-5.el6_2.x86_64                                    4/13 \n\r  Verifying  : httpd-tools-2.2.15-47.el6.centos.3.x86_64                   5/13 \n\r  Verifying  : apr-util-1.3.9-3.el6_0.1.x86_64                             6/13 \n\r  Verifying  : 1:mod_ssl-2.2.15-47.el6.centos.3.x86_64                     7/13 \n\r  Verifying  : python-jinja2-26-2.6-3.el6.noarch                           8/13 \n\r  Verifying  : mailcap-2.1.31-2.el6.noarch                                 9/13 \n\r  Verifying  : mod_wsgi-3.2-7.el6.x86_64                                  10/13 \n\r  Verifying  : python-werkzeug-0.8.3-2.el6.noarch                         11/13 \n\r  Verifying  : bahmni-web-0.80-325.noarch                                 12/13 \n\r  Verifying  : httpd-2.2.15-47.el6.centos.3.x86_64                        13/13 \n\nDependency Installed:\n  apr.x86_64 0:1.3.9-5.el6_2                                                    \n  apr-util.x86_64 0:1.3.9-3.el6_0.1                                             \n  apr-util-ldap.x86_64 0:1.3.9-3.el6_0.1                                        \n  httpd-tools.x86_64 0:2.2.15-47.el6.centos.3                                   \n  mailcap.noarch 0:2.1.31-2.el6                                                 \n  mod_ssl.x86_64 1:2.2.15-47.el6.centos.3                                       \n  mod_wsgi.x86_64 0:3.2-7.el6                                                   \n  python-flask.noarch 1:0.9-7.el6                                               \n  python-jinja2-26.noarch 0:2.6-3.el6                                           \n  python-markupsafe.x86_64 0:0.9.2-4.el6                                        \n  python-werkzeug.noarch 0:0.8.3-2.el6                                          \n\nFailed:\n  bahmni-web.noarch 0:0.80-325       httpd.x86_64 0:2.2.15-47.el6.centos.3      \n\nComplete!\n"]}
msg: Error in POSTIN scriptlet in rpm package bahmni-web-0.80-325.noarch
Error in POSTTRANS scriptlet in rpm package httpd-2.2.15-47.el6.centos.3.x86_64

This file has been truncated. show original

bharatak · March 19, 2016, 2:34am

@darius Looks like the second issue during installation is something related to permissions on the filesystem. Did a quick google on “Error in POSTTRANS scriptlet in rpm package”. I think you can try to do a “yum remove -y bahmni-web” and retry the installation. Its definitely not related to database restore.

@mseaton I have picked up the latest db dump that mahesh has pointed out and did a clean install on a digital ocean droplet. It is successfully installed. Mahesh removed all the instances to specific ip address. Can you please try with the latest db and tell us if it is fine? Thank you.

mseaton · March 19, 2016, 8:20am

Thanks @bharatak will try to test it out today.

PS - I’m in Rwanda currently, which has reinforced with me the need for an alternative strategy that can utilize cached or pre-downloaded artifacts. I know this is possible in theory by setting up a local yum repository. I may try to do this using one of my existing vagrant boxes. Otherwise it is really difficult to test vanilla provisioning using the bahmni installer from a poor bandwidth setting. Will try to document this for others if I’m able to make any progress this weekend.

bharatak · March 19, 2016, 12:02pm

@mseaton Sure. Is it just the EMR piece of bahmni you are looking for? or any other component, like erp, lab? Let me know if I can help you.

mseaton · March 19, 2016, 2:59pm

That new database worked! I’m very happy we’re over that hurdle Thanks for getting that fixed.

I’ll post on a different topic about my success in getting all of this to work without internet. It took a little doing, but all in all not too hard of a process.