Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#4621 Failed in Step 5 - Create Compiere DB

R2.6.1
closed
Felipe Reyes
5
2007-12-05
2007-11-26
Mohan Das
No

Dear Friends,
i found a strange problem during the installation of Compiere. It was smooth upto Step4 (I was using the installation document compiere_installation_instructions_edb.pdf). When i execute the .bat file, i got the following error messaget

pg_restore -d compiere F:\Compiere2\data\edb.compiere.backup -U compiere
pg_restore: [archiver (db)] connection to database "compiere" failed: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "compiere", database "compiere", SSL off

I CHECKED THE pg_hba.conf file, it has the following entry

host all all 127.0.0.1/32 md5
host all all 0.0.0.0/0 md5

so, i assumed that the pg_hba.conf entry is correct.

but, i can connect to the databse compiere using the user name compiere like this

edb_psql -d compiere -U compiere

this will ask for the password and give the db prompt

So, friends pls help me to fix this.

Many thanks in advance

Best Regards
Das

Discussion

  • Felipe Reyes
    Felipe Reyes
    2007-11-26

    • milestone: --> R2.6.1
    • status: open --> pending
     
  • Felipe Reyes
    Felipe Reyes
    2007-11-26

    Logged In: YES
    user_id=1793135
    Originator: NO

    During the configuration with RUN_Setup, please use the DNS name of the server. Do not use localhost (127.0.0.1)

     
  • Mohan Das
    Mohan Das
    2007-11-27

    Logged In: YES
    user_id=1945976
    Originator: YES

    while executing the RUN_setup, i gave the server as 'core' this is the name of my computer. I have also tried to give IP addresses during that step as a trial, but the scrip prompted me NOT TO USE IP address or LOCALHOST.

    but reported error occurred in next step - RUN_Importcompiere

     
  • Mohan Das
    Mohan Das
    2007-11-27

    Logged In: YES
    user_id=1945976
    Originator: YES

    *** Status set to PENDING *** If the issue solved, please CLOSE
    this request - otherwise set the status back to OPEN (we only
    check OPEN items). If there is no reaction within a week, the
    system will automatically CLOSE it. To speed up response time,
    you may want to consider a support agreement.
    ***

     
  • Mohan Das
    Mohan Das
    2007-11-27

    • status: pending --> open
     
  • Felipe Reyes
    Felipe Reyes
    2007-11-27

    Logged In: YES
    user_id=1793135
    Originator: NO

    Please provide the following:
    - Output of "ping core"
    - Log file of RUN_Setup
    - Complete output of RUN_ImportCompiere
    - Is your compiere home in the same box as the database?

     
  • Felipe Reyes
    Felipe Reyes
    2007-11-27

    • status: open --> pending
     
    • status: pending --> closed
     
  • Logged In: YES
    user_id=1312539
    Originator: NO

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 7 days (the time period specified by
    the administrator of this Tracker).