[Health-dev] Update database failed

[Bounmy Sihaphom]

Hi Luis and all!!

I am having problems with updating our existing database with gnuhealth 2.8 when running:
./trytond --database=cmr28 --u=all

Here is the error message:
 File "./trytond", line 80, in <module>
    trytond.server.TrytonServer(options).run()
  File "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.4.1/trytond/server.py", line 75, in run
    with Transaction().start(db_name, 0) as transaction:
  File "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.4.1/trytond/transaction.py", line 84, in start
    database = Database(database_name).connect()
  File "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.4.1/trytond/backend/postgresql/database.py", line 67, in connect
    self._connpool = ThreadedConnectionPool(minconn, maxconn, dsn)
  File "/home/gnuhealth/.local/lib/python2.7/site-packages/psycopg2/pool.py", line 156, in __init__
    self, minconn, maxconn, *args, **kwargs)
  File "/home/gnuhealth/.local/lib/python2.7/site-packages/psycopg2/pool.py", line 58, in __init__
    self._connect()
  File "/home/gnuhealth/.local/lib/python2.7/site-packages/psycopg2/pool.py", line 62, in _connect
    conn = psycopg2.connect(*self._args, **self._kwargs)
  File "/home/gnuhealth/.local/lib/python2.7/site-packages/psycopg2/__init__.py", line 164, in connect
    conn = _connect(dsn, connection_factory=connection_factory, async=async)
psycopg2.OperationalError: FATAL:  password authentication failed for user "gnuhealth"
FATAL:  password authentication failed for user "gnuhealth"

Here is my trytond.conf

[database]
jsonrpc = *:8000
uri = postgresql://gnuhealth:address@hidden:5432/
data_path = /home/gnuhealth/attach

[session]
super_pwd = tESfNNnB6gcaQ
timezone = Asia/vientiane

I am not sure which password we are using here, I have run the serverpass.py and got the password.

Best Regards;

Bounmy Sihaphom

mail. address@hidden

On Wed, Feb 4, 2015 at 5:21 AM, Luis Falcon <address@hidden> wrote:

Update of bug #44182 (project health):

                  Status:                    None => Ready For Test

    _______________________________________________________

Follow-up Comment #1:

Hi Carlos

Thanks for reporting !

The error is coming from the serverpass utility, _only_ when is the first
installation.

You need to source the GNU Health RC file

$ source $HOME/.gnuhealthrc

Then run the serverpass utility

cd gnuhealth/tryton/server/util
python ./serverpass.py

Then follow the next steps in the installation guide.

I will update the guide accordingly .

Let us know if it works for you.

Best,




    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/bugs/?44182>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/