Skip ke Konten
Odoo Menu
  • Login
  • Uji coba gratis
  • Aplikasi
    Keuangan
    • Akuntansi
    • Faktur
    • Pengeluaran
    • Spreadsheet (BI)
    • Dokumen
    • Tanda Tangan
    Sales
    • CRM
    • Sales
    • POS Toko
    • POS Restoran
    • Langganan
    • Rental
    Website
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Rantai Pasokan
    • Inventaris
    • Manufaktur
    • PLM
    • Purchase
    • Maintenance
    • Kualitas
    Sumber Daya Manusia
    • Karyawan
    • Rekrutmen
    • Cuti
    • Appraisal
    • Referensi
    • Armada
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Acara
    • Otomatisasi Marketing
    • Survei
    Layanan
    • Project
    • Timesheet
    • Layanan Lapangan
    • Meja Bantuan
    • Planning
    • Appointment
    Produktivitas
    • Diskusi
    • Approval
    • IoT
    • VoIP
    • Pengetahuan
    • WhatsApp
    Aplikasi pihak ketiga Odoo Studio Platform Odoo Cloud
  • Industri-Industri
    Retail
    • Toko Buku
    • Toko Baju
    • Toko Furnitur
    • Toko Kelontong
    • Toko Hardware
    • Toko Mainan
    Makanan & Hospitality
    • Bar dan Pub
    • Restoran
    • Fast Food
    • Rumah Tamu
    • Distributor Minuman
    • Hotel
    Real Estate
    • Agensi Real Estate
    • Firma Arsitektur
    • Konstruksi
    • Estate Management
    • Perkebunan
    • Asosiasi Pemilik Properti
    Konsultansi
    • Firma Akuntansi
    • Mitra Odoo
    • Agensi Marketing
    • Firma huku
    • Talent Acquisition
    • Audit & Sertifikasi
    Manufaktur
    • Tekstil
    • Logam
    • Perabotan
    • Makanan
    • Brewery
    • Corporate Gift
    Kesehatan & Fitness
    • Sports Club
    • Toko Kacamata
    • Fitness Center
    • Wellness Practitioners
    • Farmasi
    • Salon Rambut
    Perdagangan
    • Handyman
    • IT Hardware & Support
    • Sistem-Sistem Energi Surya
    • Pembuat Sepatu
    • Cleaning Service
    • Layanan HVAC
    Lainnya
    • Organisasi Nirlaba
    • Agen Lingkungan
    • Rental Billboard
    • Fotografi
    • Penyewaan Sepeda
    • Reseller Software
    Browse semua Industri
  • Komunitas
    Belajar
    • Tutorial-tutorial
    • Dokumentasi
    • Sertifikasi
    • Pelatihan
    • Blog
    • Podcast
    Empower Education
    • Program Edukasi
    • Game Bisnis 'Scale Up!'
    • Kunjungi Odoo
    Dapatkan Softwarenya
    • Download
    • Bandingkan Edisi
    • Daftar Rilis
    Kolaborasi
    • Github
    • Forum
    • Acara
    • Terjemahan
    • Menjadi Partner
    • Layanan untuk Partner
    • Daftarkan perusahaan Akuntansi Anda.
    Dapatkan Layanan
    • Temukan Mitra
    • Temukan Akuntan
    • Temui penasihat
    • Layanan Implementasi
    • Referensi Pelanggan
    • Bantuan
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Dapatkan demo
  • Harga
  • Bantuan

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Akuntansi
  • Inventaris
  • PoS
  • Project
  • MRP
All apps
Anda harus terdaftar untuk dapat berinteraksi di komunitas.
Semua Post Orang Lencana-Lencana
Label (Lihat semua)
odoo accounting v14 pos v15
Mengenai forum ini
Anda harus terdaftar untuk dapat berinteraksi di komunitas.
Semua Post Orang Lencana-Lencana
Label (Lihat semua)
odoo accounting v14 pos v15
Mengenai forum ini
Help

[V9]postgresql connection error

Langganan

Dapatkan notifikasi saat terdapat aktivitas pada post ini

Pertanyaan ini telah diberikan tanda
errorpostgresqlconnectionv9.0
4 Replies
12225 Tampilan
Avatar
betton

Hi everyone

My first and new installation of 9.0 community

When I start odoo using my user and odoo.py it's ok

When I try with "service odoo start" I have a issue

  File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 164, in connect
    conn = _connect(dsn, connection_factory=connection_factory, async=async)
OperationalError: FATAL:  password authentication failed for user "odoo"
FATAL:  password authentication failed for user "odoo"


So I delete the odoo user and crate a new one whith all permissions


CREATE ROLE odoo WITH PASSWORD 'mypasswd' SUPERUSER;

But nothing change


what's the solution ?



0
Avatar
Buang
Avatar
Michelle Martinez
Jawaban Terbai

buenos dias me pueden ayudarme  es de mi base de dato no puedo tener los permisos 

metro sale este error



0
Avatar
Buang
Avatar
betton
Penulis Jawaban Terbai

thanks for your answeers

-> deep

I have no .openerp_serverrc file in my server

And I think postgre is in the good port because I can launch odoo from my user

is here my /etc/odoo/openerp-server.conf

[options]
; This is the password that allows database operations:
; admin_passwd = admin
db_host = 127.0.0.1
#db_host = "/tmp/.s.PGSQL.5432"
db_port = False
db_user = odoo
db_password = False
addons_path = /usr/lib/python2.7/dist-packages/openerp/addons

 

-> dilip

 odoo usr exist on postgresql

so I change /etc/postgresql/9.5/main/pg_hba.conf like this

# Database administrative login by Unix domain socket
local   all             postgres                                peer
local   all              odoo       		           trust


and nothing change

I try to bee clear

odoo is a user creat by odoo installation. It have no /home directory.


[edit]

I uninstal odoo,  delete and clean postgresql.

I reinstall postrsql first and then odoo

And it's working out of the box

With my debian when I install odoo for the first time postgresql wasn't on my computer and it seems necessary to install postgresql first


[/edit]

0
Avatar
Buang
Avatar
Deepa Venkatesh
Jawaban Terbai

Check in the .openerp_serverrc file,

In that whether you have specified db related setup correctly such as db_host, db_user, db_password, db_port.

Further check in which port does the postgreSQL is running, sometimes the postgre will be running in the port 5432 but Odoo server may be pointed to port 5433.

So in that case, if you wished to change the PostgreSQL port, then execute the below code in the terminal.

sudo -u postgres psql -p 5433 postgres




0
Avatar
Buang
Avatar
Dilip Dabhi
Jawaban Terbai

First open terminal in ubantu OS.


In that type following commands :

->  sudo su postgres


if user odoo is not created.

            ->   createuser -s user_name

-> psql template1

-> alter user postgres password 'newpassword';


==============================OR====================

go in following path :

/etc/postgresql/9.3/main/

 ->   sudo vi /etc/postgresql/9.3/main/pg_hba.conf

.

.

.

# Database administrative login by Unix domain socket

local        all              postgres            peer

local        all              odoo                  trust

# TYPE DATABASE USER ADDRESS METHOD

# "local" is for Unix domain socket connections only

.

.

.

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

in above code add BOLD line

" local        all              odoo                  trust "




    


0
Avatar
Buang
Menikmati diskusi? Jangan hanya membaca, ikuti!

Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!

Daftar
Post Terkait Replies Tampilan Aktivitas
OperationalError: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost"
error connection
Avatar
Avatar
Avatar
Avatar
3
Nov 23
52947
Connection Error OpenERP 7.0 on Ubuntu 12.04 LTS?
error connection
Avatar
Avatar
2
Mar 15
10028
Reinstalacion del Odoo
installation error postgresql
Avatar
Avatar
1
Nov 23
3360
Odoo 12 Connection Lost... Trying to reconnect on nginx Diselesaikan
error connection odoo12.0
Avatar
Avatar
Avatar
Avatar
Avatar
5
Mar 22
18049
Error 503 - After restoring Backup
error postgresql Odoo13.0
Avatar
1
Agu 20
6160
Komunitas
  • Tutorial-tutorial
  • Dokumentasi
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Terjemahan
Layanan
  • Odoo.sh Hosting
  • Bantuan
  • Peningkatan
  • Custom Development
  • Pendidikan
  • Temukan Akuntan
  • Temukan Mitra
  • Menjadi Partner
Tentang Kami
  • Perusahaan kami
  • Aset Merek
  • Hubungi kami
  • Tugas
  • Acara
  • Podcast
  • Blog
  • Pelanggan
  • Hukum • Privasi
  • Keamanan
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo adalah rangkaian aplikasi bisnis open source yang mencakup semua kebutuhan perusahaan Anda: CRM, eCommerce, akuntansi, inventaris, point of sale, manajemen project, dan seterusnya.

Mudah digunakan dan terintegrasi penuh pada saat yang sama adalah value proposition unik Odoo.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now