[Health] Upgrading to GNU Health 1.4.3

[Christoph H. Larsen]

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!', ''))
--------------------------------------------------------------------------------

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... ;-(

Thanks a lot, for your help!

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