dhis2-devs team mailing list archive

[Alex Tumwesigye <atumwesigye@xxxxxxxxx>]

Hi,

The SQL statement required is:

delete from systemsetting where name='SMS_CONFIG' or name='keySmsConfig';

Alex

On Mon, Jan 25, 2016 at 9:53 AM, Ola Hodne Titlestad <olati@xxxxxxxxxx>
wrote:

> Hi,
>
> I just heard from Alex and Prosper in Uganda that this problem is caused
> by a change in the sms gateway configuration in 2.22, so most likely
> affects all instances that make use of this feature.
>
> Manually deleting the existing sms gateway configuration in the database
> before upgrading to 2.22 seems to do the trick.
>
> Alex, maybe you could add the sql statement here?
>
> Ola
> On 25 Jan 2016 07:38, "Elmarie Claasen" <elmarie@xxxxxxxx> wrote:
>
>> Hi Morten,
>>
>>
>>
>> Here is the log file from the error we got from starting up the instance
>> on 2.22 and going into Settings App.
>>
>> Hope this can assist to identify the error. We have no problem opening
>> settings in 2.19, 2.20 and 2.21 for the same instance.
>>
>>
>>
>> Regards,
>>
>>
>>
>> *Elmarie Claasen*
>>
>> [image: Hisp logo]
>>
>> Project Manager
>>
>> Health Information Systems Program
>>
>> Tel:      041-367 1027
>>
>> Cell:     082 374 2209
>>
>> E-mail: elmarie@xxxxxxxx
>>
>> Skype:  elmarie.claasen52
>>
>>
>>
>>
>>
>> This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer
>> .   Please read the disclaimer before opening any attachment or taking
>> any other action in terms of this electronic transmission.
>> If you cannot access the disclaimer, kindly send an email to disclaimer@xxxxxxxx
>> and a copy will be provided to you. By replying to this e-mail or opening
>> any attachment you agree to be bound by the provisions of the disclaimer.
>>
>>
>>
>> *From:* Morten Olav Hansen [mailto:mortenoh@xxxxxxxxx]
>> *Sent:* 22 January 2016 06:11 AM
>> *To:* Alex Tumwesigye
>> *Cc:* Elmarie Claasen; brendon@xxxxxxxx; DHIS 2 developers
>> *Subject:* Re: [Dhis2-devs] Problem opening settings app after updating
>> to 2.22
>>
>>
>>
>> Hi
>>
>>
>>
>> This seems to be linked to a wrong configuration in your database..
>>
>> http://pec.dhis.dhmis.org/staging/api/configuration [HTTP/1.1 500
>> Internal Server Error 503ms]
>>
>>
>>
>> There should have been a stack trace on the server side as part of this
>> 500 error, could you provide that? did you by any chance have SMS gateway
>> configured before you upgraded? (there have been some config errors linked
>> to this)
>>
>>
>> --
>> Morten
>>
>>
>>
>> On Thu, Jan 21, 2016 at 7:17 PM, Alex Tumwesigye <atumwesigye@xxxxxxxxx>
>> wrote:
>>
>> Dear Elmarie/Knut,
>>
>>
>>
>> We experienced the same. We (Prosper and I) have shared with Markus the
>> error.
>>
>>
>>
>> Alex
>>
>>
>>
>> On Thu, Jan 21, 2016 at 2:51 PM, Elmarie Claasen <elmarie@xxxxxxxx>
>> wrote:
>>
>> Hi Knut,
>>
>>
>>
>> Thanks, this seems to be the main error on the browser console – can you
>> assist with what the problem could be?
>>
>>
>>
>> Failed to load system settings: Object { readyState: 4,
>> getResponseHeader: .ajax/v.getResponseHeader(), getAllResponseHeaders:
>> .ajax/v.getAllResponseHeaders(), setRequestHeader:
>> .ajax/v.setRequestHeader(), overrideMimeType: .ajax/v.overrideMimeType(),
>> statusCode: .ajax/v.statusCode(), abort: .ajax/v.abort(), state:
>> .Deferred/d.state(), always: .Deferred/d.always(), promise:
>> .Deferred/d.promise(), 10 more… }
>>
>>
>>
>> The full browser console message is attached.
>>
>>
>>
>>
>>
>> Regards,
>>
>>
>>
>> *Elmarie Claasen*
>>
>> [image: Hisp logo]
>>
>> Project Manager
>>
>> Health Information Systems Program
>>
>> Tel:      041-367 1027
>>
>> Cell:     082 374 2209
>>
>> E-mail: elmarie@xxxxxxxx
>>
>> Skype:  elmarie.claasen52
>>
>>
>>
>>
>>
>> This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer
>> .   Please read the disclaimer before opening any attachment or taking
>> any other action in terms of this electronic transmission.
>> If you cannot access the disclaimer, kindly send an email to disclaimer@xxxxxxxx
>> and a copy will be provided to you. By replying to this e-mail or opening
>> any attachment you agree to be bound by the provisions of the disclaimer.
>>
>>
>>
>> *From:* Knut Staring [mailto:knutst@xxxxxxxxx]
>> *Sent:* 21 January 2016 01:34 PM
>> *To:* Elmarie Claasen
>> *Cc:* DHIS 2 developers; brendon@xxxxxxxx
>> *Subject:* Re: [Dhis2-devs] Problem opening settings app after updating
>> to 2.22
>>
>>
>>
>> Whenever the GUI seems to be hanging/spinning, it is helpful if you open
>> the browser console and look for errors there.
>>
>>
>>
>> Knut
>>
>>
>>
>> On Thu, Jan 21, 2016 at 12:14 PM, Elmarie Claasen <elmarie@xxxxxxxx>
>> wrote:
>>
>> Hi all,
>>
>>
>>
>> Please see the email below from our ICT specialist J
>>
>> Can you please assist with possible cause of this problem or is it a bug
>> although I do see that the Settings page open on the SL Demo.
>>
>>
>>
>> Thanks
>>
>>
>>
>> Elmarie Claasen
>>
>> HISP-SA
>>
>>
>>
>> *From:* Brendon Lines [mailto:brendon@xxxxxxxx]
>> *Sent:* 21 January 2016 01:09 PM
>> *To:* Elmarie Claasen
>> *Subject:* Possible 2.22 bug
>>
>>
>>
>> Hi there,
>>
>>
>>
>> I am having an issue with bringing up the settings page using war 2.22.
>> The circle just carries on spinning.
>>
>>
>>
>> I have created the dhis.conf file with the following details and deleted
>> hibernate.properties:
>>
>> *# Hibernate SQL dialect*
>>
>> *connection.dialect = org.hibernate.dialect.PostgreSQLDialect*
>>
>> *# JDBC driver class*
>>
>> *connection.driver_class = org.postgresql.Driver*
>>
>> *# JDBC driver connection URL*
>>
>> *connection.url = jdbc:postgresql://IP:PORT/DB name*
>>
>> *# Database username*
>>
>> *connection.username = dhis*
>>
>> *# Database password*
>>
>> *connection.password = xxxxxxxxxxxxxxxxxxxxxxxxxxxx*
>>
>> *# Database schema behavior, can be validate, update, create, create-drop*
>>
>> *connection.schema = update*
>>
>> *# Encryption password (sensitive)*
>>
>> *encryption.password = xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx*
>>
>>
>>
>> I have added the 2 java policy files under  (that being Local_policy and
>> US_export_policy.jar
>>
>> */usr/lib/jvm/java-8-oracle/jre/lib/security*
>>
>>
>>
>> I upgraded from war / DB 2.19, the process I followed was, ran upgrade
>> script from 2.19 - 2.20 on DB, downloaded war 2.20 and started tomcat, then
>> shutdown tomcat, deleted WAR 2.20 and downloaded WAR 2.21 started tomcat
>> and allowed everything to run, shutdown tomcat, deleted war 2.21, deleted
>> hibernate.properties and created dhis.conf, downloaded 2.22 and started
>> tomcat.
>>
>>
>>
>> All other aspects of the application open and run, the only issue is
>> opening settings, is there something im missing. There are no errors in the
>> catalina.out log file.
>>
>>
>>
>> Java Java-8-oracle/jre - 1.8.0.66
>>
>> Tomcat 8.0.26
>>
>> O/S: Linux 14.04 amd64
>>
>> Java opts:
>>
>> -Xmx1962m -Xms981m -XX:MaxPermSize=500m -XX:PermSize=200m
>>
>> Build Version: 21773
>>
>> Build date: 2016/01/21 09:45
>>
>>
>>
>>
>>
>>
>>
>> Brendon lines
>>
>> HISP
>>
>> Cell: 078 4444 568
>>
>> [image: hisp_banner]
>>
>>
>>
>>
>>
>> *This message and any attachments are subject to a disclaimer published
>> at http://www.hisp.org/policies.html#comms_disclaimer
>> <http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the
>> disclaimer before opening any attachment or taking any other action in
>> terms of this electronic transmission.  If you cannot access the
>> disclaimer, kindly send an email to disclaimer@xxxxxxxx
>> <disclaimer@xxxxxxxx> and a copy will be provided to you. By replying to
>> this e-mail or opening any attachment you agree to be bound by the
>> provisions of the disclaimer.*
>>
>>
>>
>> *This message and any attachments are subject to a disclaimer published
>> at http://www.hisp.org/policies.html#comms_disclaimer
>> <http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the
>> disclaimer before opening any attachment or taking any other action in
>> terms of this electronic transmission.  If you cannot access the
>> disclaimer, kindly send an email to disclaimer@xxxxxxxx
>> <disclaimer@xxxxxxxx> and a copy will be provided to you. By replying to
>> this e-mail or opening any attachment you agree to be bound by the
>> provisions of the disclaimer.*
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>>
>>
>> --
>>
>> Knut Staring
>>
>> Dept. of Informatics, University of Oslo
>>
>> Norway: +4791880522
>>
>> Skype: knutstar
>>
>> http://dhis2.org
>>
>>
>>
>> *This message and any attachments are subject to a disclaimer published
>> at http://www.hisp.org/policies.html#comms_disclaimer
>> <http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the
>> disclaimer before opening any attachment or taking any other action in
>> terms of this electronic transmission.  If you cannot access the
>> disclaimer, kindly send an email to disclaimer@xxxxxxxx
>> <disclaimer@xxxxxxxx> and a copy will be provided to you. By replying to
>> this e-mail or opening any attachment you agree to be bound by the
>> provisions of the disclaimer.*
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>>
>>
>> --
>>
>> Alex Tumwesigye
>>
>>
>>
>> Technical Advisor - DHIS2 (Consultant),
>> Ministry of Health/AFENET
>>
>> Kampala
>>
>> Uganda
>>
>> IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
>>
>> IT Specialist (Servers, Networks and Security, Health Information Systems
>> - DHIS2 ) & Solar Consultant
>>
>> +256 774149 775, + 256 759 800161
>>
>>
>> "I don't want to be anything other than what I have been - one tree hill "
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>> *This message and any attachments are subject to a disclaimer published
>> at http://www.hisp.org/policies.html#comms_disclaimer
>> <http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the
>> disclaimer before opening any attachment or taking any other action in
>> terms of this electronic transmission.  If you cannot access the
>> disclaimer, kindly send an email to disclaimer@xxxxxxxx
>> <disclaimer@xxxxxxxx> and a copy will be provided to you. By replying to
>> this e-mail or opening any attachment you agree to be bound by the
>> provisions of the disclaimer.*
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>


-- 
Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET
Kampala
Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems -
DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don't want to be anything other than what I have been - one tree hill "