Re: [Health] Upgrading to GNU Health 1.4.3

[Luis Falcon]

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

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



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