콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
4 답글
6146 화면

Hello, I love to be here. I installed a similar version of Odoo 8.0.20160729 (which i try to run now on my machine) on another machine. It worked without problems and i really love it.

Specs. recent machine:

Odoo 8.0.20160729 with "PostgreSQL 9.3.5, compiled by Visual C++ build 1600, 32-bit"

pgAdmin 1.18.1

Firefox 47.0

User "Hörner-PC/Hörner" in Win 10 home on a x64 machine

Problem:

I cant login into Odoo: "500 Internal Server Error". I reinstalled Odoo in different folders (last: "C:\Odoo8"). Before the reinstallation i cleansed my pc of the old installation. Running openerp_server.exe in cmd showed an encoding error ([1] - UnicodeEncodeError). [2] led to a solution (unset client_encoding in postgresql.conf , restart service PostgreSQL_for_Odoo) . This led to the next Error ([3] - "no password supplied"). Solved by [4] (pg_hba.conf - for all IPv6 local connections: replaced "md5" with "trust"). Which led to ([5] - role doesn't exist, showing encryption errors). I am not sure if this is a problem with encoding or with a nonexisting user.

[1] - "UnicodeEncodeError: 'ascii' codec can't encode character u'\xf6' in position 10: ordinal not in range(128)"

[2] - https://github.com/odoo/odoo/issues/835

[3] - OperationalError: "fe_sendauth: no password supplied"

[4] - http://stackoverflow.com/questions/33928585/python-and-postgresql-operationalerror-fe-sendauth-no-password-supplied

[5] - OperationalError: FATAL: role �H�rner� doesn't exist

Questions:

I could search on for solutions but i fear that this will lead to a series of other errors. Is there a general mistake i made, that leads to these errors?

Not beeing experienced in SQL, I didn't really understand the structure behind Odoo. What i understood: Odoo uses (in a way) PostgreSQL by using the user "openpg". This works: openpg is logged in localhost:5432 according to pgAdmin. But what does "INFO ? openerp: database user: Hörner" mean in this context?

Thanks very much

every help is appreciated!

아바타
취소

INFO and ERROR messages are from the Odoo log and tell you a little bit about what's happening on the backend of things.

베스트 답변

Do you mean that "Hörner-PC/Hörner" is supposed to be your internal Odoo database user? If yes, you have to provide me a taster of your dope :-)

In a standard Odoo installation, the internal Odoo database user is "odoo". You might well change that, even if I see no reason for it, but in that case please try to avoid any non-standard ASCII characters.

아바타
취소
베스트 답변

Hi,

You can use pgadmin to create a new role with the supplied name [Hörner as in your case] by odoo log ...

Update:

or try to use the server parameters to enforce the db user:

--db_user <user here e.g openpg >, --db_password <password>

when you're running the server ...


hope this could helps

아바타
취소
작성자 베스트 답변

Thanks to all who helped or wanted to help!


The Error on the machine wasn't solved. I now use Odoo 8 on a virtual machine, which worked from the beginning.

=========================================

Htm-Mbs, Travis Waelbroeck, Ermin Trevisan, Ahmed M.Elmubarak. Hello, grüetzi and As-salam alaykom! Thank you very much for your answers!

To make this clear: i did not use "Hörner-PC/Hörner" as username for Odoo. I do use "Hörner" to login to Windows. The name of my machine, my pc is "Hörner-PC". I never specified any username for using Odoo (i can't access it in any way, as mentioned above - 500 internal server error). The only username i was able to choose was the postgreSQL "openpg"-username during the Odoo all-in-one-installer installation. But I kept this standard username.

I didn't set any Odoo-specific username. If I understand correctly, odoo logs into postgreSQL by using usr "openpg" (see https://pl.vc/1i1zpy ). How come that i get

C:\Odoo8\server>openerp-server.exe
2016-07-31 08:19:07,546 8988 INFO ? openerp: OpenERP version 8.0-20160729
2016-07-31 08:19:07,546 8988 INFO ? openerp: addons paths: [u'C:\\Users\\H\xf6rner\\AppData\\Local\\OpenERP S.A.\\Odoo\\addons\\8.0', u'C:\\Odoo8\\server\\openerp\\addons']
2016-07-31 08:19:07,562 8988 INFO ? openerp: database hostname: localhost
2016-07-31 08:19:07,562 8988 INFO ? openerp: database port: 5432
2016-07-31 08:19:07,562 8988 INFO ? openerp: database user: Hörner
2016-07-31 08:19:08,891 8988 INFO ? openerp.service.server: HTTP service (werkzeug) running on 0.0.0.0:8069

The database user differs from the one shown by pgAdmin. AND it is my windows username.

I tried to add the role "Hörner". It didn't work. I still get "OperationalError: FATAL: role �H�rner� doesn't exist".


This PC once was infedted by a virus. Is it possible that this scrambled the encoding?



Answer to Ermins comment from 31.07. 12:04:

this is the content of my openerp-server.conf:

[options]

addons_path = C:\Odoo8\server\openerp\addons

admin_passwd = admin

auto_reload = None

bin_path = C:\Odoo8\thirdparty

csv_internal_sep = ,

Adding

database user = openpg

or

user = openpg

won't change a thing


===============================

Thanks to all who helped or wanted to help!

The Error on the machine wasn't solved. I now use Odoo 8 on a virtual machine, which worked from the beginning.

================================


Hello Ermin, hello Ahmed,

thank you very much again for your answers. As soon as it's possible i'll give your ideas a try. As i'm not a my machine at the next days, it'll take a while.

Julian

아바타
취소

Check your openerp-server.conf file, there you will find the database user and in your case it should be "openpg" and not "Hörner".

It must be:

db_user = openpg

db_password = False

updated my answer ...

작성자

updated my answer

관련 게시물 답글 화면 활동
0
3월 25
1517
1
1월 25
1946
2
12월 22
15315
1
11월 21
5401
0
1월 21
2654