One small comment on the dhis.conf file, which I know is a distraction from the original question.
It is not a good idea in production for the application to connect to the database using the postgres user. If the application is hacked (as has happened more than once - recently with the struts vulnerability) then an attacker could get access to the dhis.conf file. To minimize the damage you don’t want to be giving away the database superuser credentials.
A better practice is to create a database user which only has access to this database. And put that user’s name and password in the conf file.
···
On 25 April 2017 at 18:38, Muhammad Bilal Siddqui m.bilalsiddqui@micromerger.com wrote:
Yes you are right i miss this
connection.dialect = org.hibernate.dialect.PostgreSQLDialect
Now i am able to add OrgUnit .
Thanks alot for help me out.
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
On Tue, Apr 25, 2017 at 10:01 PM, Em Le Hong em.hispvietnam@gmail.com wrote:
Yes, you have to define it in dhis.conf file.
See example from the file that I have sent to you or copy the configuration below. DhisH2 database may cause an issue with the strange error.
Hibernate SQL dialect
connection.dialect = org.hibernate.dialect.PostgreSQLDialect
JDBC driver class
connection.driver_class = org.postgresql.Driver
Database connection URL
connection.url = jdbc:postgresql:databaseName
Database username
connection.username = postgres
Database password
connection.password = postgresPasswordHere
Database schema behavior, can be validate, update, create, create-drop
connection.schema = update
Encryption password (sensitive)
encryption.password = 1
–
Regards
Muhammad Bilal Siddiqui
MicroMerger (Pvt.) Ltd.
Office No-104 Cubator 1ne
CIIT, Park Road, Chak Shehzad
Islamabad.
Pakistan 44000
C : +923325694928 P : +92518444777
E : m.bilalsiddqui@micromerger.com W : www.micromerger.com
*This e-mail and any files transmitted with it are confidential to the intended recipient and may be privileged. If you are not the intended recipient, please immediately notify the sender. Whilst we have used Anti-Virus software to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from them.*N : Think before print do you really need this on paper. thanks
On Tue, Apr 25, 2017 at 11:55 PM, Muhammad Bilal Siddqui m.bilalsiddqui@micromerger.com wrote:
How do I set database type? Should it define in dhis.conf file?
–
Em Le Hong
DHIS2 Implementation| **HISP Vietnam **
em.hispvietnam@gmail.com | Skype: em.hispvietnam@gmail.com
On Tue, Apr 25, 2017 at 9:53 PM, Em Le Hong em.hispvietnam@gmail.com wrote:
The database should be pointed to Postgres, look at play demo server, the last row
–
Regards
Muhammad Bilal Siddiqui
MicroMerger (Pvt.) Ltd.
Office No-104 Cubator 1ne
CIIT, Park Road, Chak Shehzad
Islamabad.
Pakistan 44000
C : +923325694928 P : +92518444777
E : m.bilalsiddqui@micromerger.com W : www.micromerger.com
*This e-mail and any files transmitted with it are confidential to the intended recipient and may be privileged. If you are not the intended recipient, please immediately notify the sender. Whilst we have used Anti-Virus software to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from them.*N : Think before print do you really need this on paper. thanks
On Tue, Apr 25, 2017 at 11:50 PM, Em Le Hong em.hispvietnam@gmail.com wrote:
1 important thing, I just realize that you database type is DhisH2, it’s not postgres which should be, you can compare with play server
–
Em Le Hong
DHIS2 Implementation| **HISP Vietnam **
em.hispvietnam@gmail.com | Skype: em.hispvietnam@gmail.com
On Tue, Apr 25, 2017 at 11:44 PM, Em Le Hong em.hispvietnam@gmail.com wrote:
I just logged into your server, it’s really strange, since it works properly on my laptop and dhis2 play server. Can you delete all dhis folder in your tomcat/webapp folder, try to download latest war file and run it again.
–
Em Le Hong
DHIS2 Implementation| **HISP Vietnam **
em.hispvietnam@gmail.com | Skype: em.hispvietnam@gmail.com
On Tue, Apr 25, 2017 at 11:35 PM, Muhammad Bilal Siddqui m.bilalsiddqui@micromerger.com wrote:
Hi
Thanks for providing blank DB. After importing this my application started but again in organisation unit I am not able to add organisation it shows same error. ERROR: null value in column “organisationunitid” violates not-null constraint
–
Em Le Hong
DHIS2 Implementation| **HISP Vietnam **
em.hispvietnam@gmail.com | Skype: em.hispvietnam@gmail.com
On Tue, Apr 25, 2017 at 8:17 PM, Em Le Hong em.hispvietnam@gmail.com wrote:
Hi,
I just created 1 blank instance on my laptop, I give you the backup of its. You can try to restore it with any testing instance that running DHIS2 2.26. (Remember that when you restore this database, it will completely cover your old database, so make sure that you have a backup of your database, otherwise you can’t recover it).
I created 1 orgUnit in this database called Global, you can change it later. It’s working fine on my laptop, hope you can run it.
–
Regards
Muhammad Bilal Siddiqui
MicroMerger (Pvt.) Ltd.
Office No-104 Cubator 1ne
CIIT, Park Road, Chak Shehzad
Islamabad.
Pakistan 44000
C : +923325694928 P : +92518444777
E : m.bilalsiddqui@micromerger.com W : www.micromerger.com
*This e-mail and any files transmitted with it are confidential to the intended recipient and may be privileged. If you are not the intended recipient, please immediately notify the sender. Whilst we have used Anti-Virus software to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from them.*N : Think before print do you really need this on paper. thanks
On Tue, Apr 25, 2017 at 10:02 PM, Muhammad Bilal Siddqui m.bilalsiddqui@micromerger.com wrote:
Yes.
I am using dhis.conf file.
I have to change because i am using 2 instance of DHIS one with name dhis and other with lhs so i had to change 2nd one to LHS_HOME.
Although i have facing same error on both when creating orgUnit
–
Em Le Hong
DHIS2 Implementation| **HISP Vietnam **
em.hispvietnam@gmail.com | Skype: em.hispvietnam@gmail.com
On Tue, Apr 25, 2017 at 7:58 PM, Em Le Hong em.hispvietnam@gmail.com wrote:
you can change the war file name, but the variable name should be DHIS2_HOME and make sure that you use dhis.conf file (not the hibernate.properties file).
–
Regards
Muhammad Bilal Siddiqui
MicroMerger (Pvt.) Ltd.
Office No-104 Cubator 1ne
CIIT, Park Road, Chak Shehzad
Islamabad.
Pakistan 44000
C : +923325694928 P : +92518444777
E : m.bilalsiddqui@micromerger.com W : www.micromerger.com
*This e-mail and any files transmitted with it are confidential to the intended recipient and may be privileged. If you are not the intended recipient, please immediately notify the sender. Whilst we have used Anti-Virus software to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from them.*N : Think before print do you really need this on paper. thanks
On Tue, Apr 25, 2017 at 9:55 PM, Muhammad Bilal Siddqui m.bilalsiddqui@micromerger.com wrote:
I am using war file.
its name lhs.war
and using LHS_HOME varible instead of DHIS2_HOME
–
Em Le Hong
DHIS2 Implementation| **HISP Vietnam **
em.hispvietnam@gmail.com | Skype: em.hispvietnam@gmail.com
On Tue, Apr 25, 2017 at 7:45 PM, Em Le Hong em.hispvietnam@gmail.com wrote:
How did you run it? Did you download the war file from dhis2.org and run it with tomcat server or you just download the dhis2 live package?
–
Regards
Muhammad Bilal Siddiqui
MicroMerger (Pvt.) Ltd.
Office No-104 Cubator 1ne
CIIT, Park Road, Chak Shehzad
Islamabad.
Pakistan 44000
C : +923325694928 P : +92518444777
E : m.bilalsiddqui@micromerger.com W : www.micromerger.com
*This e-mail and any files transmitted with it are confidential to the intended recipient and may be privileged. If you are not the intended recipient, please immediately notify the sender. Whilst we have used Anti-Virus software to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from them.*N : Think before print do you really need this on paper. thanks
On Tue, Apr 25, 2017 at 9:37 PM, Muhammad Bilal Siddqui m.bilalsiddqui@micromerger.com wrote:
Hi.
I tried as you suggested I check some tables in DB created. But application failed to start.
I attached log files. It shows error about DB.
–
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispvietnam@gmail.com | Skype: em.hispvietnam@gmail.com
On Tue, Apr 25, 2017 at 3:01 PM, Muhammad Bilal Siddqui m.bilalsiddqui@micromerger.com wrote:
Ok. Thank you. I will try that.
Get Outlook for iOS
To: Muhammad Bilal Siddqui
Subject: Re: [Dhis2-users] Data Store Issue in DHIS2 [2.26]
From: Em Le Hong em.hispvietnam@gmail.com
Sent: Tuesday, April 25, 2017 2:59:44 PM
in postgresSQL, create a database, then run it with your instance, it will automatically generate all tables for you.
–
Regards
Muhammad Bilal Siddiqui
MicroMerger (Pvt.) Ltd.
Office No-104 Cubator 1ne
CIIT, Park Road, Chak Shehzad
Islamabad.
Pakistan 44000
C : +923325694928 P : +92518444777
E : m.bilalsiddqui@micromerger.com W : www.micromerger.com
*This e-mail and any files transmitted with it are confidential to the intended recipient and may be privileged. If you are not the intended recipient, please immediately notify the sender. Whilst we have used Anti-Virus software to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from them.*N : Think before print do you really need this on paper. thanks
On Tue, Apr 25, 2017 at 4:56 PM, Muhammad Bilal Siddqui
m.bilalsiddqui@micromerger.com wrote:
Can you tell me how to create db?
Just i stop server and make db. And start server again. All table in db should generate automatically? Or i need to create all tables?
Get
Outlook for iOS
Subject: Re: [Dhis2-users] Data Store Issue in DHIS2 [2.26]
From: Em Le Hong em.hispvietnam@gmail.com
Sent: Tuesday, April 25, 2017 2:47:42 PM
To: Muhammad Bilal Siddqui
Hi,
I guess you download a copy database from
dhis2.org site and modified something, there’s some wrong with database. The orgUnit from demo server has 2 attributes: HR identifier and NGO ID, I removed it from your server, but it still doesn’t work.
My suggestion is that you need to create a blank database on 2.26 and import all metadata (orgUnit…) into the new server.
Hope this work for you.
Sincerely,
–
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispvietnam@gmail.com | Skype:
em.hispvietnam@gmail.com
On Tue, Apr 25, 2017 at 4:12 PM, Muhammad Bilal Siddqui
m.bilalsiddqui@micromerger.com wrote:
Hi
http://45.33.45.176:8080/lhs/
user admin
pass district
you can check with this account
–
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispvietnam@gmail.com | Skype:
em.hispvietnam@gmail.com
On Tue, Apr 25, 2017 at 1:51 PM, Em Le Hong
em.hispvietnam@gmail.com wrote:
Hi,
If your server is online, is it possible to give me one account, I will login and check for you.
–
Regards
Muhammad Bilal Siddiqui
MicroMerger (Pvt.) Ltd.
Office No-104 Cubator 1ne
CIIT, Park Road, Chak Shehzad
Islamabad.
Pakistan 44000
C : +923325694928 P : +92518444777
E : m.bilalsiddqui@micromerger.com W : www.micromerger.com
- This e-mail and any files transmitted with it are confidential to the intended recipient and may be privileged. If you are not the intended recipient, please immediately notify the sender. Whilst we have used Anti-Virus software to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from them.
*N : Think before print do you really need this on paper. thanks
On Tue, Apr 25, 2017 at 3:38 PM, Muhammad Bilal Siddqui
m.bilalsiddqui@micromerger.com wrote:
Actually there are some OrgUnits. I select 1 as parent but it still showing that error.
Get Outlook for iOS
From: Em Le Hong em.hispvietnam@gmail.com
Sent: Tuesday, April 25, 2017 1:30:41 PM
To: Muhammad Bilal Siddqui
Cc: Knut Staring; DHIS 2 Users list
Subject: Re: [Dhis2-users] Data Store Issue in DHIS2 [2.26]
I guess you are missing parent orgUnit, you need to create it as root orgUnit if there’s no orgUnit exist in your database.
–
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispvietnam@gmail.com | Skype:
em.hispvietnam@gmail.com
On Tue, Apr 25, 2017 at 3:10 PM, Muhammad Bilal Siddqui
m.bilalsiddqui@micromerger.com wrote:
Thanks for response. I check console it show me following error
null value in column “organisationunitid” violates not-null constraint
console screenshot attached
Mailing list:
https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe :
https://launchpad.net/~dhis2-users
More help :
https://help.launchpad.net/ListHelp
–
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispvietnam@gmail.com | Skype:
em.hispvietnam@gmail.com
On Tue, Apr 25, 2017 at 11:26 AM, Knut Staring
knutst@gmail.com wrote:
Please look for error messages in your browser console and your Tomcat log.
Regards,
Knut
–
Regards
Muhammad Bilal Siddiqui
MicroMerger (Pvt.) Ltd.
Office No-104 Cubator 1ne
CIIT, Park Road, Chak Shehzad
Islamabad.
Pakistan 44000
C : +923325694928 P : +92518444777
E : m.bilalsiddqui@micromerger.com W : www.micromerger.com
- This e-mail and any files transmitted with it are confidential to the intended recipient and may be privileged. If you are not the intended recipient, please immediately notify the sender. Whilst we have used Anti-Virus software to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from them.
*N : Think before print do you really need this on paper. thanks
On Apr 25, 2017 6:13 AM, “Muhammad Bilal Siddqui” m.bilalsiddqui@micromerger.com wrote:
HI,
I have set up DHIS2 on my server successfully all is working fine with demo DB then I connect different empty db and also try in demo db but i am not able to add Organisation unit. it gives me following error.
failed_to_save_organisation_unit
Any thoughts what went wrong. Am using chrome browser
DHIS2 Version 2.26
PostgresSQL Version 9.4.10
–
Regards
Muhammad Bilal Siddiqui
MicroMerger (Pvt.) Ltd.
Office No-104 Cubator 1ne
CIIT, Park Road, Chak Shehzad
Islamabad.
Pakistan 44000
C : +923325694928 P : +92518444777
E : m.bilalsiddqui@micromerger.com W : www.micromerger.com
- This e-mail and any files transmitted with it are confidential to the intended recipient and may be privileged. If you are not the intended recipient, please immediately notify the sender. Whilst we have used Anti-Virus software to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from them.
*N : Think before print do you really need this on paper. thanks
Mailing list:
https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe :
https://launchpad.net/~dhis2-users
More help :
https://help.launchpad.net/ListHelp