Postgresql: Can't add users/databases

deltaarc

Registered
Mar 28, 2004
2
0
151
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?
 

digx

Registered
Aug 9, 2004
3
0
151
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. =)
 

casey

Well-Known Member
Jan 17, 2003
2,303
0
191
Can you run postgresql commands from shell? If it's just the cpanel connection you might want to put in a ticket.
 

kacsa

Member
Apr 6, 2003
18
0
151
Solution: modify cpanel users name, no contain '-'. Example: before xy-z, after xyz.
 

kacsa

Member
Apr 6, 2003
18
0
151
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
 

arbuzas

Member
Apr 10, 2004
23
0
151
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:

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.
So problem not in dashes
 

arbuzas

Member
Apr 10, 2004
23
0
151
I go this:

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

kacsa

Member
Apr 6, 2003
18
0
151
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)
 

kacsa

Member
Apr 6, 2003
18
0
151
"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)
 

Attachments