Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

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

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Stuck at Odoo database manager

Subscribe

Get notified when there's activity on this post

This question has been flagged
installodoo
3 Replies
6693 Views
Avatar
Harold Anderson

Hi!  So I installed the Odoo community edition version 17.0 on my Windows desktop, and it dumps me at a screen that says it has generated a master password.  Then it asks for another master password, a database name, an email address, yet another password, a phone number, language, country, and a checkbox for demo data.  Then there is a big blue Create Database button.


Before I even got to this screen, I installed Postgres.  This created a database called Postgres.  I then created another user called odoo with create database permissions and login permissions.  I know Postgres is running because I can do stuff in pgAdmin.   I'm not sure what to fill in at the Odoo screen for Master password, database name, email, password, phone number, language, country, and demo data.  I've tried a lot of combinations of things, and I always get an error message saying 


Database creation error: connection to server at "localhost" (::1), port 5432 failed: FATAL: password authentication failed for user "openpg"

So I created another user called openpg with the same permissions, but I'm still getting the same error message.   What is the purpose of the screen I am at, and what should I fill in? 

0
Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

The below image will be shown in your screen to create a new database. A database is required to run odoo in your system


1) Master Password : Enter the admin password that you provided while installing odoo. you can find the admin_password from your odoo conf file

2)Database Name : Provide a name for your database. Use _ instead of space while creating database name

3)Email: Provide a login credential this will be taken as your login ID to your db

4)Password: Provide a password, and this will be taken as your login Password to your DB

5)Demo Data: If you need some demo data in your DB while creating , then you can enable it else leave it

Click on continue to create DB


Hope it helps

0
Avatar
Discard
Avatar
Harold Anderson
Author Best Answer

@cybrosys That is not the screen that was shown.  I said above, this is the screen that was shown when installing Odoo, whereas you have stated that your screen is shown after creating a master password.  The question again:

1.  What is the purpose of the master password?  Is this a password in Postgres, or something that Odoo keeps internally for some purpose?  If so, what purpose?

2. Why is Odoo giving me a master password on the installation screen, then immediately giving me a blank to enter that password and/or change it?  Am I supposed to enter the master password they have shown me, or am I supposed to enter a new master password?  In any event, an entry is mandatory.

3. What is the database you are referring to in #2?  Is this the postgres database that the postgres installer created when Postgres was installed?  In that case, wouldn't Odoo know that the name is postgres?   If Odoo needs another database, wouldn't the install docs say that I should have created that database in Postgres first?  If Odoo is going to create another Postgres database and is asking for the name of the new Postgres database, why wouldn't they make that clear?   In any event, it is very unclear what is going on.

4. Email will be login to my db?  Again, the install docs do say that I need to create a new Postgres db, and that odoo cannot use the postgres db.   I also think that I was supposed to create another Postgres user called odoo because odoo is not allowed to use the main postgres user, which is also called postgres, not openpg.  It is a real mystery where openpg came from.

5.  You can probably see that if I don't know the answers to the above four questions, I have no idea what password they are asking for in the blank between email and Phone number.

I don't know what or where the odoo conf file you refer to is.  The install instructions say merely to download the nightly exe file and run it. I don't have enough karma to post the link, but it is at www dot odoo dot com slash documentation slash 17.0 slash administration slash on_premise slash packages.html then scroll down to Windows.

I would unmark your answer as the correct answer, but I do not have enough karma to do that.  Not sure who marked the answer as correct, because it isn't.


0
Avatar
Discard
Avatar
RAGESH KUMAR G
Best Answer

Hi Harold Anderson  ,

  • You can Change the pg_hba.conf file below,
host    all             all             0.0.0.0/0            trust

It was worked for me.

Thanks

0
Avatar
Discard
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Odoo 10.0 manual install modules Solved
modules install odoo
Avatar
Avatar
Avatar
Avatar
5
Apr 17
20495
Where can I download odoo for Ubuntu? Solved
install packing odoo
Avatar
Avatar
2
Mar 15
5226
I need to install Odoo on Centos 5.10
install vps odoo
Avatar
Avatar
2
Mar 15
7308
How do I go about this error? I am trying to uninstall a module
odoo
Avatar
0
Nov 25
3340
How to import product variants with my own external id when using dynamic creation mode Solved
odoo
Avatar
Avatar
2
Aug 25
3911
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة 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 is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

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