Re: [Health] Upgrading to GNU Health 1.4.3

[Luis Falcon]

On Tue, Jan 31, 2012 at 12:59 AM, Christoph H. Larsen
<address@hidden> wrote:
> 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!.

Great Chris ! Keep me updated with your advances.

Best
> 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
>



-- 
Luis Falcon
GNU Health
http://health.gnu.org