error while install bahmni 0.93 on centos 7.6

hello everyone

this is first time try install bahmni on my machine , I encountered this problem in the installation, any idea to slove this error.


PLAY [atomfeed-console] ************************************************************************************
META: ran handlers

TASK [atomfeed-console : install atomfeed-console rpm] *****************************************************
task path: /opt/bahmni-installer/bahmni-playbooks/roles/atomfeed-console/tasks/main.yml:2
fatal: [localhost]: FAILED! => {"changed": true, "failed": true, "msg": "http://repo.mybahmni.org/rpm/bahmni/atomfeed-console-1.1-1.noarch.rpm: [Errno -1] Package does not match intended download. Suggestion: run yum --enablerepo=bahmni clean metadata\nTrying other mirror.\n\n\nError downloading packages:\n  atomfeed-console-1.1-1.noarch: [Errno 256] No more mirrors to try.\n\n", "rc": 1, "results": ["Loaded plugins: fastestmirror, langpacks\nLoading mirror speeds from cached hostfile\n * base: mirrors.isu.net.sa\n * epel: mirror.earthlink.iq\n * extras: mirrors.isu.net.sa\n * updates: mirrors.isu.net.sa\nResolving Dependencies\n--> Running transaction check\n---> Package atomfeed-console.noarch 0:1.1-1 will be installed\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n================================================================================\n Package                   Arch            Version        Repository       Size\n================================================================================\nInstalling:\n atomfeed-console          noarch          1.1-1          bahmni           33 M\n\nTransaction Summary\n================================================================================\nInstall  1 Package\n\nTotal download size: 33 M\nInstalled size: 37 M\nDownloading packages:\n"]}
	to retry, use: --limit @/opt/bahmni-installer/bahmni-playbooks/all.retry

PLAY RECAP *************************************************************************************************
localhost                  : ok=260  changed=100  unreachable=0    failed=1   

Traceback (most recent call last):
  File "/bin/bahmni", line 9, in <module>
    load_entry_point('bahmni==0.1', 'console_scripts', 'bahmni')()
  File "/usr/lib64/python2.7/site-packages/click/core.py", line 764, in __call__
    return self.main(*args, **kwargs)
  File "/usr/lib64/python2.7/site-packages/click/core.py", line 717, in main
    rv = self.invoke(ctx)
  File "/usr/lib64/python2.7/site-packages/click/core.py", line 1137, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/usr/lib64/python2.7/site-packages/click/core.py", line 956, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/usr/lib64/python2.7/site-packages/click/core.py", line 555, in invoke
    return callback(*args, **kwargs)
  File "/usr/lib64/python2.7/site-packages/click/decorators.py", line 17, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/usr/lib/python2.7/site-packages/bahmni-0.1-py2.7.egg/bahmni.py", line 91, in install
  File "/usr/lib64/python2.7/subprocess.py", line 542, in check_call
    raise CalledProcessError(retcode, cmd)
subprocess.CalledProcessError: Command 'ansible-playbook -i /etc/bahmni-installer/local all.yml -vv  --extra-vars '@/etc/bahmni-installer/rpm_versions.yml' --extra-vars '@/etc/bahmni-backrest.conf' --extra-vars '@/etc/bahmni-installer/setup.yml'' returned non-zero exit status 2
[root@localhost yousef]# yum list installed | grep bahmni
bahmni-appointments-frontend.noarch     0.93-31                        @bahmni  
bahmni-emr.noarch                       0.93-131                       @bahmni  
bahmni-erp.noarch                       0.93-76                        @bahmni  
bahmni-erp-connect.noarch               0.93-76                        @bahmni  
bahmni-implementer-interface.noarch     0.93-97                        @bahmni  
bahmni-installer.noarch                 0.93-197                       @/bahmni-installer-0.93-197.noarch
bahmni-lab.noarch                       0.93-58                        @bahmni  
bahmni-lab-connect.noarch               0.93-131                       @bahmni  
bahmni-reports.noarch                   0.93-45                        @bahmni  
bahmni-web.noarch                       0.93-131                       @bahmni  

full installation details here https://pastebin.com/ikHG09AR

any help here

Did you change the repo URL? Check install steps on WIKI please

Edit the /etc/bahmni-installer/setup.yml file and add the Bahmni Repo URL

bahmni_repo_url: https: //repo .mybahmni.org /releases/

yes i already add the URL to setup.yml

if you look at the log, its trying to download from the above URL, which should not be the case. @n0man @mohant @gsluthra

We are looking into it.

Hi All,

I am facing the following error while trying to install bahmni 0.93 on centOS with blank database with JSS_config

TASK [implementation-config : Run openmrs liquibase migrations] ************************************************************* task path: /opt/bahmni-installer/bahmni-playbooks/roles/implementation-config/tasks/implementation-config.yml:73 fatal: [localhost]: FAILED! => {“changed”: true, “failed”: true, “msg”: “non-zero return code”, “rc”: 255, “stderr”: “+ . /etc/bahmni-installer/bahmni.conf\n++ IMPLEMENTATION_NAME=jss\n++ OPENMRS_DB_USERNAME=openmrs-user\n++ OPENMRS_DB_PASSWORD=P@ssw0rd\n++ OPENMRS_DB_SERVER=localhost\n++ OPENELIS_DB_USERNAME=clinlims\n++ OPENELIS_DB_PASSWORD=password\n++ OPENELIS_DB_SERVER=localhost\n++ OPENERP_DB_USERNAME=odoo\n++ OPENERP_DB_PASSWORD=password\n++ OPENERP_DB_SERVER=localhost\n++ MYSQL_ROOT_USER=root\n++ MYSQL_ROOT_PASSWORD=P@ssw0rd\n++ REPORTS_DB_SERVER=localhost\n++ REPORTS_DB_PASSWORD=P@ssw0rd\n++ REPORTS_DB_USERNAME=reports-user\n+ CHANGE_LOG_TABLE=’-Dliquibase.databaseChangeLogTableName=liquibasechangelog -Dliquibase.databaseChangeLogLockTableName=liquibasechangeloglock -DschemaName=openmrs’\n+ LIQUIBASE_JAR=/opt/openmrs/openmrs/WEB-INF/lib/liquibase-core-2.0.5.jar\n+ DRIVER=com.mysql.jdbc.Driver\n++ ls /opt/openmrs/openmrs/WEB-INF/lib/mysql-connector-java-5.1.28.jar\n+ CLASSPATH=/opt/openmrs/openmrs/WEB-INF/lib/mysql-connector-java-5.1.28.jar\n+ CHANGE_LOG_FILE=liquibase.xml\n+ ‘[’ -f /var/www/bahmni_config/openmrs/migrations/liquibase.xml ‘]’\n+ cd /var/www/bahmni_config/openmrs/migrations\n+ java -Dliquibase.databaseChangeLogTableName=liquibasechangelog -Dliquibase.databaseChangeLogLockTableName=liquibasechangeloglock -DschemaName=openmrs -jar /opt/openmrs/openmrs/WEB-INF/lib/liquibase-core-2.0.5.jar --driver=com.mysql.jdbc.Driver --classpath=/opt/openmrs/openmrs/WEB-INF/lib/mysql-connector-java-5.1.28.jar --changeLogFile=liquibase.xml --url=jdbc:mysql://localhost:3306/openmrs --username=openmrs-user --password=P@ssw0rd update\nINFO 3/11/22 1:57 PM:liquibase: Successfully acquired change log lock\nINFO 3/11/22 1:57 PM:liquibase: Reading from liquibasechangelog\nINFO 3/11/22 1:57 PM:liquibase: Reading from liquibasechangelog\nSEVERE 3/11/22 1:57 PM:liquibase: Change Set liquibase.xml::JSS-1::tw failed. Error: Error executing SQL INSERT INTO idgen_identifier_source (uuid, name, description, identifier_type, creator, date_created)\n VALUES (uuid(), ‘GAN’, ‘ID sequence source for patients whose primary health center is Ganiyari’, @patient_identifier, 1, curdate()): Column ‘identifier_type’ cannot be null\nliquibase.exception.DatabaseException: Error executing SQL INSERT INTO idgen_identifier_source (uuid, name, description, identifier_type, creator, date_created)\n VALUES (uuid(), ‘GAN’, ‘ID sequence source for patients whose primary health center is Ganiyari’, @patient_identifier, 1, curdate()): Column ‘identifier_type’ cannot be null\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)\n\tat liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)\n\tat liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)\n\tat liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)\n\tat liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)\n\tat liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)\n\tat liquibase.Liquibase.update(Liquibase.java:114)\n\tat liquibase.integration.commandline.Main.doMigration(Main.java:825)\n\tat liquibase.integration.commandline.Main.main(Main.java:134)\nCaused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column ‘identifier_type’ cannot be null\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)\n\tat sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)\n\tat java.lang.reflect.Constructor.newInstance(Constructor.java:423)\n\tat com.mysql.jdbc.Util.handleNewInstance(Util.java:411)\n\tat com.mysql.jdbc.Util.getInstance(Util.java:386)\n\tat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)\n\tat com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)\n\tat com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)\n\tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)\n\tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)\n\tat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)\n\tat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)\n\tat liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)\n\t… 9 more\nINFO 3/11/22 1:57 PM:liquibase: Successfully released change log lock\nLiquibase Update Failed: Error executing SQL INSERT INTO idgen_identifier_source (uuid, name, description, identifier_type, creator, date_created)\n VALUES (uuid(), ‘GAN’, ‘ID sequence source for patients whose primary health center is Ganiyari’, @patient_identifier, 1, curdate()): Column ‘identifier_type’ cannot be null\nSEVERE 3/11/22 1:57 PM:liquibase: Error executing SQL INSERT INTO idgen_identifier_source (uuid, name, description, identifier_type, creator, date_created)\n VALUES (uuid(), ‘GAN’, ‘ID sequence source for patients whose primary health center is Ganiyari’, @patient_identifier, 1, curdate()): Column ‘identifier_type’ cannot be null\nliquibase.exception.MigrationFailedException: Migration failed for change set liquibase.xml::JSS-1::tw:\n Reason: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO idgen_identifier_source (uuid, name, description, identifier_type, creator, date_created)\n VALUES (uuid(), ‘GAN’, ‘ID sequence source for patients whose primary health center is Ganiyari’, @patient_identifier, 1, curdate()): Column ‘identifier_type’ cannot be null:\n Caused By: Error executing SQL INSERT INTO idgen_identifier_source (uuid, name, description, identifier_type, creator, date_created)\n VALUES (uuid(), ‘GAN’, ‘ID sequence source for patients whose primary health center is Ganiyari’, @patient_identifier, 1, curdate()): Column ‘identifier_type’ cannot be null:\n Caused By: Column ‘identifier_type’ cannot be null\n\tat liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)\n\tat liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)\n\tat liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)\n\tat liquibase.Liquibase.update(Liquibase.java:114)\n\tat liquibase.integration.commandline.Main.doMigration(Main.java:825)\n\tat liquibase.integration.commandline.Main.main(Main.java:134)\nCaused by: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO idgen_identifier_source (uuid, name, description, identifier_type, creator, date_created)\n VALUES (uuid(), ‘GAN’, ‘ID sequence source for patients whose primary health center is Ganiyari’, @patient_identifier, 1, curdate()): Column ‘identifier_type’ cannot be null\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)\n\tat liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)\n\tat liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)\n\tat liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)\n\t… 5 more\nCaused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column ‘identifier_type’ cannot be null\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)\n\tat sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)\n\tat java.lang.reflect.Constructor.newInstance(Constructor.java:423)\n\tat com.mysql.jdbc.Util.handleNewInstance(Util.java:411)\n\tat com.mysql.jdbc.Util.getInstance(Util.java:386)\n\tat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)\n\tat com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)\n\tat com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)\n\tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)\n\tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)\n\tat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)\n\tat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)\n\tat liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)\n\t… 9 more\n\n\nFor more information, use the --logLevel flag)\n”, “stdout”: “”, “stdout_lines”: []} to retry, use: --limit @/opt/bahmni-installer/bahmni-playbooks/all.retry

PLAY RECAP ****************************************************************************************************************** localhost : ok=151 changed=53 unreachable=0 failed=1

Traceback (most recent call last): File “/usr/bin/bahmni”, line 9, in load_entry_point(‘bahmni==0.1’, ‘console_scripts’, ‘bahmni’)() File “/usr/lib64/python2.7/site-packages/click/core.py”, line 764, in call return self.main(*args, **kwargs) File “/usr/lib64/python2.7/site-packages/click/core.py”, line 717, in main rv = self.invoke(ctx) File “/usr/lib64/python2.7/site-packages/click/core.py”, line 1137, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File “/usr/lib64/python2.7/site-packages/click/core.py”, line 956, in invoke return ctx.invoke(self.callback, **ctx.params) File “/usr/lib64/python2.7/site-packages/click/core.py”, line 555, in invoke return callback(*args, **kwargs) File “/usr/lib64/python2.7/site-packages/click/decorators.py”, line 17, in new_func return f(get_current_context(), *args, **kwargs) File “/usr/lib/python2.7/site-packages/bahmni-0.1-py2.7.egg/bahmni.py”, line 91, in install File “/usr/lib64/python2.7/subprocess.py”, line 542, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command ‘ansible-playbook -i /etc/bahmni-installer/local all.yml -vv --extra-vars ‘@/etc/bahmni-installer/rpm_versions.yml’ --extra-vars ‘@/etc/bahmni-backrest.conf’ --extra-vars ‘@/etc/bahmni-installer/setup.yml’’ returned non-zero exit status 2

Maybe @arjun can give some guidance. You are trying to install Fresh Bahmni, with fresh DB along with JSS_Config. Where did you take jss_config from?

Thanks @gsluthra, for marking as Arjun. I have taken jss_config file from live local server of JSS.

Maybe this issue is occuring because JSS server is running older version of Bahmni, and you are trying on latest v0.93. Are you trying to see how to upgrade JSS to latest version of Bahmni? The error seems to indicate some issue in liquibase while running sql scripts on DB.