On Friday, September 22, 2017 at 1:35:07 PM UTC, Cédric Krier wrote:
> On 2017-09-22 03:55, Maah Moussa wrote:
> > Hello Tryton Community,
> > The *.dump from the Tryton 3.8 client platform copied to the new server
> > converted to *.sql through command: pg_restore -f *.dump *.sql
> >
> > psql -c "CREATE USER gnuhealth WITH CREATEDB;"
> > createdb gnuhealth0 –owner=gnuhealth
> > psql gnuhealth0 < /directory/*.sql
> >
> > psql -c "ALTER DATABASE gnuhealth0 OWNER to tryton;"
> > psql -c "GRANT gnuhealth to tryton;"
> >
> > psql -c "CREATE USER tryton WITH CREATEDB;"
> >
> > The DB gnuhealth0 shows in the tryton 4.2 client but trying to connect the
> > message comes up:
> > Traceback (most recent call last):
> > File "/trytond/wsgi.py", line 47, in dispatch_request
> > return endpoint(request, **request.view_args)
> > File "/trytond/protocols/dispatcher.py", line 41, in rpc
> > request, database_name, *request.rpc_params)
> > File "/trytond/protocols/dispatcher.py", line 53, in login
> > database_name, user, parameters, language=language)
> > File "/trytond/security.py", line 24, in login
> > User = pool.get('res.user')
> > File "/trytond/pool.py", line 170, in get
> > return self._pool[self.database_name][type][name]
> > KeyError: 'res.user'
> > Sometimes Missing dependencies: ['purchase_request']
>
> You have to follow the migration path from 3.8 to 4.2:
> https://discuss.tryton.org/c/migration
> And perform an update of the database:
> http://doc.tryton.org/4.4/trytond/doc/topics/setup_database.html#topics-setup-database
>
> --
> Cédric Krier - B2CK SPRL
> Email/Jabber: [email protected]
> Tel: +32 472 54 46 59
> Website: http://www.b2ck.com/
On Friday, September 22, 2017 at 1:35:07 PM UTC, Cédric Krier wrote:
> On 2017-09-22 03:55, Maah Moussa wrote:
> > Hello Tryton Community,
> > The *.dump from the Tryton 3.8 client platform copied to the new server
> > converted to *.sql through command: pg_restore -f *.dump *.sql
> >
> > psql -c "CREATE USER gnuhealth WITH CREATEDB;"
> > createdb gnuhealth0 –owner=gnuhealth
> > psql gnuhealth0 < /directory/*.sql
> >
> > psql -c "ALTER DATABASE gnuhealth0 OWNER to tryton;"
> > psql -c "GRANT gnuhealth to tryton;"
> >
> > psql -c "CREATE USER tryton WITH CREATEDB;"
> >
> > The DB gnuhealth0 shows in the tryton 4.2 client but trying to connect the
> > message comes up:
> > Traceback (most recent call last):
> > File "/trytond/wsgi.py", line 47, in dispatch_request
> > return endpoint(request, **request.view_args)
> > File "/trytond/protocols/dispatcher.py", line 41, in rpc
> > request, database_name, *request.rpc_params)
> > File "/trytond/protocols/dispatcher.py", line 53, in login
> > database_name, user, parameters, language=language)
> > File "/trytond/security.py", line 24, in login
> > User = pool.get('res.user')
> > File "/trytond/pool.py", line 170, in get
> > return self._pool[self.database_name][type][name]
> > KeyError: 'res.user'
> > Sometimes Missing dependencies: ['purchase_request']
>
> You have to follow the migration path from 3.8 to 4.2:
> https://discuss.tryton.org/c/migration
> And perform an update of the database:
> http://doc.tryton.org/4.4/trytond/doc/topics/setup_database.html#topics-setup-database
>
> --
> Cédric Krier - B2CK SPRL
> Email/Jabber: [email protected]
> Tel: +32 472 54 46 59
> Website: http://www.b2ck.com/
Is the migration path a must to be used in any way the dump is taken,
gnuhealth-control or client dump when moving between series?
Do I need to follow from 3.8 to 4.0 then 4.0 to 4.2?
Does it matter before or after restoring the database?
How to apply this SQL queries into SQL plain text on OpenSUSE? A hint on how to
apply [SQL] or [PY] changes would be much appreciated. the command is not
available.
Thanks
Maah Moussa
[email protected]
--
You received this message because you are subscribed to the Google Groups
"tryton" group.
To view this discussion on the web visit
https://groups.google.com/d/msgid/tryton/9dbbc20d-a74a-486f-93ab-8401ec888b9c%40googlegroups.com.
