Re: [Health] Upgrading to GNU Health 1.4.3

[Christoph H. Larsen]

Dear Luis,



On 31/01/12 00:43, Luis Falcon wrote:
> Hi Chris !
> 
> 
> On Mon, Jan 30, 2012 at 3:36 PM, Christoph H. Larsen
> <address@hidden> wrote:
>> Dear All,
>>
>> It was with a good deal of excitement that I upgraded today, and would
>> like to report a few issues:
>>
>> Background: FreeBSD 8.2 server with GNU Health running inside a jail.
>> Version 1.4.2 working (with Tryton 2.2.1), all installed using pip.
>>
>> Initially, I tried to upgrade the whole Tryton/GNU Health complex by using:
>>
>> pip install --upgrade --build-dir=/usr/local/src trytond[whatever, incl.
>> trytond itself]
>>
>> That did not float, as Tryton died upon restart looking for module name
>> <VERSION>.
>>
>> I therefore decided to run
>>
>> pip uninstall --yes trytond_[module_name]
>> This uninstalled all trytond modules.
>> Followed by:
>> pip install --build-dir=/usr/local/src trytond[whatever, incl. trytond
>> itself]
>> This did not make Tryton go belly up upon re-start
>> (/usr/local/etc/rc.d/ttrytond restart), but wait: We have to upgrade the
>> database first. Here we go:
>>
>> su tryton -c "/usr/local/bin/trytond \
>>        --config=/usr/local/etc/trytond.conf \
>>        --update=all --database=[database name]"
>>
>> And this is what I got:
>>
>> --------------------------------------------------------------------------------
>> [Mon Jan 30 23:02:32 2012] INFO:modules:health:loading data/WHO_products.xml
>> [Mon Jan 30 23:02:32 2012] WARNING:convert:Field name of
>> address@hidden not updated (id: prod_medicament), because it has
>> changed since the last update
>> [Mon Jan 30 23:02:32 2012] WARNING:convert:Field name of
>> address@hidden not updated (id: prod_medicament_WHO), because it has
>> changed since the last update
>> [Mon Jan 30 23:02:41 2012] INFO:modules:health:loading
>> data/WHO_list_of_essential_medicines.xml
>> [Mon Jan 30 23:02:42 2012] INFO:modules:health:loading
>> data/health_specialties.xml
>> [Mon Jan 30 23:02:42 2012] INFO:modules:health:loading
>> data/ethnic_groups.xml
>> [Mon Jan 30 23:02:42 2012] INFO:modules:health:loading data/occupations.xml
>> [Mon Jan 30 23:02:43 2012] INFO:modules:health:loading data/dose_units.xml
>> [Mon Jan 30 23:02:43 2012] INFO:modules:health:loading
>> data/drug_administration_routes.xml
>> [Mon Jan 30 23:02:43 2012] INFO:modules:health:loading
>> data/medicament_form.xml
>> [Mon Jan 30 23:02:43 2012] INFO:modules:health:loading
>> data/medication_frequencies.xml
>> [Mon Jan 30 23:02:43 2012] INFO:modules:health:loading
>> data/health_sequences.xml
>> [Mon Jan 30 23:02:43 2012] INFO:modules:health:loading
>> security/access_rights.xml
>> [Mon Jan 30 23:02:43 2012] ERROR:sql:Wrong SQL: INSERT INTO "res_group"
>> ("name", create_uid, create_date) VALUES ( 'Health Administration', 0,
>> '2012-01-30T23:02:43.116288'::timestamp) RETURNING id
>> /usr/local/lib/python2.7/site-packages/trytond/model/modelsql.py:360:
>> DeprecationWarning: With-statements now directly support multiple
>> context managers
>>  Transaction().set_user(0)):
>> [Mon Jan 30 23:02:43 2012] ERROR:convert:Error while parsing xml file:
>> In tag record: model res.group with id group_health_admin.
>> Traceback (most recent call last):
>>  File "/usr/local/bin/trytond", line 104, in <module>
>>    trytond.server.TrytonServer(options).run()
>>  File "/usr/local/lib/python2.7/site-packages/trytond/server.py", line
>> 115, in run
>>    Pool(db_name).init(update=update, lang=lang)
>>  File "/usr/local/lib/python2.7/site-packages/trytond/pool.py", line
>> 118, in init
>>    lang=lang)
>>  File
>> "/usr/local/lib/python2.7/site-packages/trytond/modules/__init__.py",
>> line 430, in load_modules
>>    load_module_graph(graph, pool, lang)
>>  File
>> "/usr/local/lib/python2.7/site-packages/trytond/modules/__init__.py",
>> line 253, in load_module_graph
>>    tryton_parser.parse_xmlstream(fp)
>>  File "/usr/local/lib/python2.7/site-packages/trytond/convert.py", line
>> 413, in parse_xmlstream
>>    self.sax_parser.parse(source)
>>  File "/usr/local/lib/python2.7/xml/sax/expatreader.py", line 107, in parse
>>    xmlreader.IncrementalParser.parse(self, source)
>>  File "/usr/local/lib/python2.7/xml/sax/xmlreader.py", line 123, in parse
>>    self.feed(buffer)
>>  File "/usr/local/lib/python2.7/xml/sax/expatreader.py", line 207, in feed
>>    self._parser.Parse(data, isFinal)
>>  File "/usr/local/lib/python2.7/xml/sax/expatreader.py", line 304, in
>> end_element
>>    self._cont_handler.endElement(name)
>>  File "/usr/local/lib/python2.7/site-packages/trytond/convert.py", line
>> 460, in endElement
>>    self.taghandler = self.taghandler.endElement(name)
>>  File "/usr/local/lib/python2.7/site-packages/trytond/convert.py", line
>> 260, in endElement
>>    self.mh.import_record(self.model._name, self.values, self.xml_id)
>>  File "/usr/local/lib/python2.7/site-packages/trytond/convert.py", line
>> 832, in import_record
>>    db_id = object_ref.create(values)
>>  File "/usr/local/lib/python2.7/site-packages/trytond/res/group.py",
>> line 75, in create
>>    res = super(Group, self).create(vals)
>>  File
>> "/usr/local/lib/python2.7/site-packages/trytond/model/modelsql.py", line
>> 390, in create
>>    self.raise_user_error(error)
>>  File "/usr/local/lib/python2.7/site-packages/trytond/error.py", line
>> 76, in raise_user_error
>>    raise UserError(error)
>> trytond.exceptions.UserError: ('UserError', ('The name of the group must
>> be unique!', ''))
>> --------------------------------------------------------------------------------
>>
> It looks like is related to a conflict with the current admin group
> and the new access control rules we have imposed in each module
> security directories.
> 
> Try to comment out the "security/access_rights.xml" on each
> __tryton__.py file and run the upgrade again.
> 
>> If I play dummy and restart the tryton server, and try to log in using
>> the client, I get a "NetworkError! BadFingerprint" error:
>> --------------------------------------------------------------------------------
>> Mon Jan 30 23:04:48 2012] INFO:server:starting JSON-RPC protocol on
>> erp.jail.vlan:8000
>> [Mon Jan 30 23:04:48 2012] INFO:server:starting XML-RPC SSL protocol on
>> erp.jail.vlan:8069
>> [Mon Jan 30 23:04:48 2012] INFO:server:starting WebDAV SSL protocol on
>> erp.jail.vlan:8080
>> [Mon Jan 30 23:04:48 2012] INFO:server:waiting for connections...
>> 192.168.0.71 - - [30/Jan/2012 23:05:02] code 400, message Bad request
>> syntax
>> ("\x16\x03\x01\x00\xcc\x01\x00\x00\xc8\x03\x01O&\xe2\xcd'+\x7fu^\x83\xcf\xd9\x8et97\x96Q/}\xda\xf0qX(:\x17\x00\xf2Ek\xee\x00\x00Z\xc0\x14\xc0")
>> -------------------------------------------------------------------------------
>> Any ideas? I can always go back to 1.4.2, and replay my PostgreSQL
>> backups from up to two weeks ago, but... ;-(
>>
> You shouldn't (but make sure you backup all the data before each upgrade :-) 
> ).
> 
> Let us know how it went
I think the best policy will be to try the upgrade on the new database,
examine the changes in admin right you implemented (as I may well have
duplicated your efforts in the old version), and see it from there...
Let me work on it, and thanks for your help!.
Chris
> 
>> Thanks a lot, for your help!
> 
> Thanks !
>>
>> Chris
>>
>>
>>
>>
>>
>> On 30/01/12 21:30, address@hidden wrote:
>>> Send Health-announce mailing list submissions to
>>>       address@hidden
>>>
>>> To subscribe or unsubscribe via the World Wide Web, visit
>>>       https://lists.gnu.org/mailman/listinfo/health-announce
>>> or, via email, send a message with subject or body 'help' to
>>>       address@hidden
>>>
>>> You can reach the person managing the list at
>>>       address@hidden
>>>
>>> When replying, please edit your Subject line so it is more specific
>>> than "Re: Contents of Health-announce digest..."
>>>
>>>
>>> Today's Topics:
>>>
>>>    1. GNU Health 1.4.3 released (Luis Falcon)
>>>
>>>
>>> ----------------------------------------------------------------------
>>>
>>> Message: 1
>>> Date: Mon, 30 Jan 2012 00:11:27 -0300
>>> From: Luis Falcon <address@hidden>
>>> To: address@hidden
>>> Subject: [Health-announce] GNU Health 1.4.3 released
>>> Message-ID:
>>>       <address@hidden>
>>> Content-Type: text/plain; charset=ISO-8859-1
>>>
>>> Dear all
>>>
>>> I'm happy to announce the release of Health 1.4.3. This version
>>> contains many enhancements and fixes.?Check at the end of this mail
>>> for some important links.
>>>
>>> As a summary :
>>>
>>> - Improved menus, icons and navigation
>>> - Integrate neonatology and PSC (Pediatric Symptoms Checklist ) in a
>>> new Pediatrics menu
>>> - Now we can refer to the patient using directly the social security
>>> number, in addition to the internal health center ID
>>> - Add product categories for Insurance plans
>>> - Create initial admin rights for the main modules
>>> - Create a .mo template for each module, so we can update the
>>> transifex source language (only in the tar.gz distribution)
>>> - Added patient lastname in the party tree view
>>> - Include in the translation project in transifex many data files (
>>> occupations, drugs, ICD-10, ... ) that before they were created as a
>>> separated file. Now these particular fields can be translated. Removed
>>> the old files containing language-specific terms.
>>> - Improved patient medication history
>>> -?Add patient lastname to summary of appointment event calendar
>>> - Updated Database demo environment (with Proteus). Fixed bugs and use
>>> the health profile module.
>>>
>>> For more detailed information, please check the Changelog at :
>>> http://health.gnu.org/Changelog
>>>
>>> Some other important links :
>>>
>>> * Main site : http://health.gnu.org
>>> * Mailing lists, Development, Downloads and Bugs at GNU Savannah :
>>> https://savannah.gnu.org/projects/health/
>>> * Health Documentation Project :?http://en.wikibooks.org/wiki/GNU_Health
>>> * Health Translation and localization project at Transifex :
>>> https://www.transifex.net/projects/p/GNU_Health/
>>>
>>> Make sure you grab the latest translation file of your country /
>>> region for the current version at Transifex.
>>>
>>> Please report bugs and suggestions at the GNU Health project in the 
>>> Savannah.
>>>
>>> --
>>> Luis Falcon
>>> GNU Health
>>> http://health.gnu.org
>>>
>>>
>>>
>>> ------------------------------
>>>
>>> _______________________________________________
>>> Health-announce mailing list
>>> address@hidden
>>> https://lists.gnu.org/mailman/listinfo/health-announce
>>>
>>>
>>> End of Health-announce Digest, Vol 6, Issue 1
>>> *********************************************
>>
>> --
>> Dr. Christoph H. Larsen
>> synaLinQ (Vietnam)                      synaLinQ (Kenya)
>> P.O. Box 55, Bưu điện NT, 01 Pasteur    P.O. Box 1607, Village Market
>> Nha Trang, Khánh Hòa                    Nairobi 00621
>> Vietnam                                 Kenya
>> Mobile: +84-98-9607357                  Mobile: +254-753-632481
>>        +49-176-96456254 (Germany)
>> Fax:    +49-231-292734790
>> Email:  address@hidden
>>
> 
> 
> 

-- 
Dr. Christoph H. Larsen
synaLinQ (Vietnam)                      synaLinQ (Kenya)
P.O. Box 55, Bưu điện NT, 01 Pasteur    P.O. Box 1607, Village Market
Nha Trang, Khánh Hòa                    Nairobi 00621
Vietnam                                 Kenya
Mobile: +84-98-9607357                  Mobile: +254-753-632481
        +49-176-96456254 (Germany)
Fax:    +49-231-292734790
Email:  address@hidden