Page 1 of 2

ไม่สามารถ start openerp-server ของ openerp 7 ได้

Posted: 18/06/2020 10:09 am
by bolue
ไม่สามารถ start openerp-server ของ openerp 7 ได้ เมื่อกดรัน มันจะหยุดเองโดยอัตโนมัติ ทำให้ไม่สามารถรันได้
และขึ้นแจ้งเตือนว่า

Code: Select all

The openerp-server-7.0 7.0 service on local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs
ปัญหาการใช้ phpBB3, SMF, Joomla, Wordpress, CMS, CRM-1.png
ปัญหาการใช้ phpBB3, SMF, Joomla, Wordpress, CMS, CRM-1.png (111.56 KiB) Viewed 429 times

Re: ไม่สามารถ start openerp-server ของ openerp 7 ได้

Posted: 18/06/2020 10:33 am
by thatsawan
ปรับแก้ไขอะไรมาก่อนหน้านี้หรือ ป่าว คะ

Re: ไม่สามารถ start openerp-server ของ openerp 7 ได้

Posted: 18/06/2020 10:43 am
by bolue
thatsawan wrote: 18/06/2020 10:33 am ปรับแก้ไขอะไรมาก่อนหน้านี้หรือ ป่าว คะ
un ตัว openerp7 แล้วลงใหม่ค่ะ ไม่ได้แก้อะไรเลยค่ะ

Re: ไม่สามารถ start openerp-server ของ openerp 7 ได้

Posted: 18/06/2020 7:57 pm
by mindphp
ลองเช็คใน log ดู error มาแปะดูหน่อยครับ
openerp-server.log

Re: ไม่สามารถ start openerp-server ของ openerp 7 ได้

Posted: 19/06/2020 10:14 am
by bolue
mindphp wrote: 18/06/2020 7:57 pm ลองเช็คใน log ดู error มาแปะดูหน่อยครับ
openerp-server.log
ตอนใช้ user password ที่ยังไม่ทำการเปลี่ยน สามารถ start server ได้ค่ะ พอเปลี่ยนแล้ว start ไม่ได้ค่ะ

Code: Select all

2020-06-19 03:05:18,858 13332 INFO ? openerp: OpenERP version 7.0-20170329
2020-06-19 03:05:18,858 13332 INFO ? openerp: addons paths: C:\Program Files (x86)\OpenERP 7.0-20170329\server\openerp\addons
2020-06-19 03:05:18,858 13332 INFO ? openerp: database hostname: localhost
2020-06-19 03:05:18,858 13332 INFO ? openerp: database port: 5432
2020-06-19 03:05:18,859 13332 INFO ? openerp: database user: openpg
2020-06-19 03:05:20,322 16528 INFO ? openerp: OpenERP version 7.0-20170329
2020-06-19 03:05:20,322 16528 INFO ? openerp: addons paths: C:\Program Files (x86)\OpenERP 7.0-20170329\server\openerp\addons
2020-06-19 03:05:20,322 16528 INFO ? openerp: database hostname: localhost
2020-06-19 03:05:20,322 16528 INFO ? openerp: database port: 5432
2020-06-19 03:05:20,323 16528 INFO ? openerp: database user: openpg
2020-06-19 03:05:20,868 16528 WARNING ? openerp.addons.google_docs.google_docs: Please install latest gdata-python-client from http://code.google.com/p/gdata-python-client/downloads/list
2020-06-19 03:05:21,700 16528 INFO ? openerp: OpenERP server is running, waiting for connections...
2020-06-19 03:05:26,627 16528 INFO ? openerp.service.wsgi_server: HTTP service (werkzeug) running on 0.0.0.0:8069
2020-06-19 03:06:13,622 16528 ERROR ? openerp.sql_db: Connection to the database failed
Traceback (most recent call last):
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 442, in borrow
  File "psycopg2\__init__.pyc", line 164, in connect
OperationalError: FATAL:  password authentication failed for user "openpg"

2020-06-19 03:06:13,622 16528 ERROR ? openerp.netsvc: FATAL:  password authentication failed for user "openpg"
Traceback (most recent call last):
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\netsvc.py", line 306, in dispatch_rpc
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\service\web_services.py", line 140, in dispatch
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\service\web_services.py", line 365, in exp_list
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 486, in cursor
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 182, in __init__
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 377, in _locked
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 442, in borrow
  File "psycopg2\__init__.pyc", line 164, in connect
OperationalError: FATAL:  password authentication failed for user "openpg"

2020-06-19 03:06:13,865 16528 INFO ? werkzeug: 127.0.0.1 - - [19/Jun/2020 03:06:13] "GET / HTTP/1.1" 500 -
2020-06-19 03:06:14,046 16528 INFO ? werkzeug: 127.0.0.1 - - [19/Jun/2020 03:06:14] "GET /favicon.ico HTTP/1.1" 404 -
2020-06-19 03:08:18,142 16528 ERROR ? openerp.sql_db: Connection to the database failed
Traceback (most recent call last):
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 442, in borrow
  File "psycopg2\__init__.pyc", line 164, in connect
OperationalError: FATAL:  password authentication failed for user "openpg"

2020-06-19 03:08:18,144 16528 ERROR ? openerp.netsvc: FATAL:  password authentication failed for user "openpg"
Traceback (most recent call last):
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\netsvc.py", line 306, in dispatch_rpc
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\service\web_services.py", line 140, in dispatch
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\service\web_services.py", line 365, in exp_list
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 486, in cursor
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 182, in __init__
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 377, in _locked
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 442, in borrow
  File "psycopg2\__init__.pyc", line 164, in connect
OperationalError: FATAL:  password authentication failed for user "openpg"

2020-06-19 03:08:18,229 16528 INFO ? werkzeug: 127.0.0.1 - - [19/Jun/2020 03:08:18] "GET / HTTP/1.1" 500 -
2020-06-19 03:08:19,273 16528 ERROR ? openerp.sql_db: Connection to the database failed
Traceback (most recent call last):
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 442, in borrow
  File "psycopg2\__init__.pyc", line 164, in connect
OperationalError: FATAL:  password authentication failed for user "openpg"

2020-06-19 03:08:19,275 16528 ERROR ? openerp.netsvc: FATAL:  password authentication failed for user "openpg"
Traceback (most recent call last):
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\netsvc.py", line 306, in dispatch_rpc
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\service\web_services.py", line 140, in dispatch
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\service\web_services.py", line 365, in exp_list
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 486, in cursor
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 182, in __init__
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 377, in _locked
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 442, in borrow
  File "psycopg2\__init__.pyc", line 164, in connect
OperationalError: FATAL:  password authentication failed for user "openpg"

2020-06-19 03:08:19,371 16528 INFO ? werkzeug: 127.0.0.1 - - [19/Jun/2020 03:08:19] "GET / HTTP/1.1" 500 -
2020-06-19 03:08:21,332 16528 ERROR ? openerp.sql_db: Connection to the database failed
Traceback (most recent call last):
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 442, in borrow
  File "psycopg2\__init__.pyc", line 164, in connect
OperationalError: FATAL:  password authentication failed for user "openpg"

2020-06-19 03:08:21,332 16528 ERROR ? openerp.netsvc: FATAL:  password authentication failed for user "openpg"
Traceback (most recent call last):
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\netsvc.py", line 306, in dispatch_rpc
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\service\web_services.py", line 140, in dispatch
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\service\web_services.py", line 365, in exp_list
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 486, in cursor
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 182, in __init__
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 377, in _locked
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 442, in borrow
  File "psycopg2\__init__.pyc", line 164, in connect
OperationalError: FATAL:  password authentication failed for user "openpg"

2020-06-19 03:08:21,490 16528 INFO ? werkzeug: 127.0.0.1 - - [19/Jun/2020 03:08:21] "GET / HTTP/1.1" 500 -
2020-06-19 03:11:46,187 17124 INFO ? openerp: OpenERP version 7.0-20170329
2020-06-19 03:11:46,187 17124 INFO ? openerp: addons paths: C:\Program Files (x86)\OpenERP 7.0-20170329\server\openerp\addons
2020-06-19 03:11:46,187 17124 INFO ? openerp: database hostname: localhost
2020-06-19 03:11:46,187 17124 INFO ? openerp: database port: 5432
2020-06-19 03:11:46,187 17124 INFO ? openerp: database user: openpg
2020-06-19 03:11:46,549 17124 WARNING ? openerp.addons.google_docs.google_docs: Please install latest gdata-python-client from http://code.google.com/p/gdata-python-client/downloads/list
2020-06-19 03:11:46,930 17124 INFO ? openerp: OpenERP server is running, waiting for connections...
2020-06-19 03:11:47,809 17124 INFO ? openerp.service.wsgi_server: HTTP service (werkzeug) running on 0.0.0.0:8069
2020-06-19 03:11:49,956 17124 ERROR ? openerp.sql_db: Connection to the database failed
Traceback (most recent call last):
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 442, in borrow
  File "psycopg2\__init__.pyc", line 164, in connect
OperationalError: FATAL:  password authentication failed for user "openpg"

2020-06-19 03:11:49,956 17124 ERROR ? openerp.netsvc: FATAL:  password authentication failed for user "openpg"
Traceback (most recent call last):
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\netsvc.py", line 306, in dispatch_rpc
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\service\web_services.py", line 140, in dispatch
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\service\web_services.py", line 365, in exp_list
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 486, in cursor
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 182, in __init__
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 377, in _locked
  File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 442, in borrow
  File "psycopg2\__init__.pyc", line 164, in connect
OperationalError: FATAL:  password authentication failed for user "openpg"

2020-06-19 03:11:50,026 17124 INFO ? werkzeug: 127.0.0.1 - - [19/Jun/2020 03:11:50] "GET / HTTP/1.1" 500 -

Re: ไม่สามารถ start openerp-server ของ openerp 7 ได้

Posted: 19/06/2020 10:24 am
by thatsawan
File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 442, in borrow
File "psycopg2\__init__.pyc", line 164, in connect
OperationalError: FATAL: password authentication failed for user "openpg"
password ไม่ถูกป่าว

Re: ไม่สามารถ start openerp-server ของ openerp 7 ได้

Posted: 19/06/2020 11:02 am
by bolue
thatsawan wrote: 19/06/2020 10:24 am
File "C:\Program Files (x86)\OpenERP 7.0-20170329\server\.\openerp\sql_db.py", line 442, in borrow
File "psycopg2\__init__.pyc", line 164, in connect
OperationalError: FATAL: password authentication failed for user "openpg"
password ไม่ถูกป่าว
เปลี่ยน user และ password จาก openpg และ openpgpwd เป็น postgres ตัวที่มีแล้วมันรันไม่ได้แล้วค่ะ

Re: ไม่สามารถ start openerp-server ของ openerp 7 ได้

Posted: 19/06/2020 11:53 am
by mindphp
สร้าง user ขึ้นมาใหม่ใน pgadmin เพื่อเอามาใช้งานใน openerp