The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Postgresql: Can't add users/databases

Discussion in 'General Discussion' started by deltaarc, Jan 16, 2005.

  1. deltaarc

    deltaarc Registered

    Joined:
    Mar 28, 2004
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    I'm running latest cpanel RELEASE build.

    I never managed to get postgresql working from cpanel on any of my servers.

    When a user from cpanel tries to add a user or database from x2, it tells them it added the user or database sucessfully, but when you go back to the previous page, the user isn't created.

    Anyone has an idea why this isn't working?
     
  2. digx

    digx Registered

    Joined:
    Aug 9, 2004
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Same problem

    Have tried all the solutions I've been able to find on the forums for this type of problem.

    I've tried removing all RPMs, and reinstalling.
    Have tried updating cPanel but I'm at latest.
    I seem to be a dead end.

    :confused:

    Any help will be greatly appreciated. Thanks in advance. =)
     
  3. deltaarc

    deltaarc Registered

    Joined:
    Mar 28, 2004
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    I still haven't figured it out myself...
     
  4. digx

    digx Registered

    Joined:
    Aug 9, 2004
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    * bump *

    :)
     
  5. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    Can you run postgresql commands from shell? If it's just the cpanel connection you might want to put in a ticket.
     
  6. kacsa

    kacsa Member

    Joined:
    Apr 6, 2003
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    If Cpanel's username content '-', can't add user/database.

    Sorry my english:)
     
  7. arbuzas

    arbuzas Member

    Joined:
    Apr 10, 2004
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    same here.... :confused:
     
  8. kacsa

    kacsa Member

    Joined:
    Apr 6, 2003
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    Solution: modify cpanel users name, no contain '-'. Example: before xy-z, after xyz.
     
  9. kacsa

    kacsa Member

    Joined:
    Apr 6, 2003
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    Another possibility: in /var/lib/pgsql/data/postgresql.conf the following entry uncomment:
    #log_connections = false -> log_connections = true
    #log_statement = false -> log_statement = true
    #log_timestamp = false -> log_timestamp = true

    #log_min_error_statement = error -> log_min_error_statement = error

    and view /var/log/pgsql or /usr/local/cpanel/logs/error.log
     
  10. arbuzas

    arbuzas Member

    Joined:
    Apr 10, 2004
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    LooooL..... First tray to make user with dash :cool: oo what we get form cPanel:

    Error: Sorry usernames cannot contain a dash.

    Any way I even can login in phpPgAdmin. As 'deltaarc' say:

    So problem not in dashes
     
  11. arbuzas

    arbuzas Member

    Joined:
    Apr 10, 2004
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    I go this:

    Code:
    psql: FATAL:  No pg_hba.conf entry for host localhost, user postgres, database template1  
     
  12. kacsa

    kacsa Member

    Joined:
    Apr 6, 2003
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    Cpanel create postgresql username the following:
    Cpanel's loginname (ex. marhafeju) + give username (ex. test)
    If cpanel's loginname contain '-' (ex. marha-feju), the user can't add postgresql (cpanel write "added the user or database sucessfully", this is not TRUE)
     
  13. kacsa

    kacsa Member

    Joined:
    Apr 6, 2003
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    "psql: FATAL: No pg_hba.conf entry for host localhost, user postgres, database template1 "
    Look my postgresql conf files for solution: (if you modify something in conf file, RESTART YOUR postgresql, /etc/init.d/postgresql restart)
     

    Attached Files:

Loading...

Share This Page