odoo后台突然无法登陆的情况

2016年4月11日19:45:51 发表评论 1,562 views

Hi, I just found the solution, my admin password was okay; The problem was that once you add the administrator email, (settings-> users -> administrator) the administrator username also changes from the default 'admin' to the email you have put and 'admin' does not work for login anymore. I used the followin postgresql query to confirm my new username and password. Unfortunately I can't post the link as I don't have enough karma.

1. Take on postgres user privileges

you:-$ sudo -su postgres 

2. Start up the PostgreSQL command line with the list command to list all databases;

postgres:-$ psql -l (not a 1 but a small L)

 Name       |  Owner      | Encoding |   Collate         |    Ctype         |   Access privileges   
----------------+----------------+--------------+---------------------+--------------------+-----------------------
 odoo1       | openerp     |    UTF8   | en_US.UTF-8 | en_US.UTF-8 | 
 postgres   | postgres    | UTF8      | en_US.UTF-8  | en_US.UTF-8 | 
 template0 | postgres     | UTF8      | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
                |                   |               |                      |                      | postgres=CTc/postgres
 template1 | postgres     | UTF8      | en_US.UTF-8  | en_US.UTF-8 | =c/postgres          +
                 |                  |               |                      |                       | postgres=CTc/postgres

 

3. identify the database that is for your openerp. For me it was easy as the owner was "openerp", and the name "odoo1"

4. Fire up the PostgreSQL command line and select your database as below; use database identifed from step 3.

postgres:-$ psql -d odoo1

psql (9.3.4)

Type "help" for help.

5. Query your database by asking it to display all logins, passwords from the table "res_users". This is the odoo store for logins and passwords

yourDataBaseName=#Query login, password from table, 

odoo1=# select login, password from res_users;

      login        | password

  --------------------+----------

   rick                | rick123

admin@bit.co.ke | WheyHaarD4u2Guess

(2 rows) 

odoo1=#

大体意思就是说由于在后台设置了邮箱,系统会自动调用邮箱登陆,实际上你的密码啥的没人帮你改的,只是登陆用户名需要更改成邮箱而已,上边的命令可以查出来相关可以登陆的用户邮箱。

  • 我的微信
  • 这是我的微信扫一扫
  • weinxin
  • 我的微信公众号
  • 我的微信公众号扫一扫
  • weinxin

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: