Problem using phpPgAdmin 1

[newbiepg]

I am getting a message using pGAdmin when I log in using
postgres and postgres as username and password

I get the message saying "wrong username/password access denied."
I am using redhat 8.0 and postgresql 7.2.2(t6he default database that comes with it).
The database can be accessed from the shell prompt

I have uncommented 2 lines in pg_hba.conf

local all localhost trust
host all 127.0.0.1 255.255.255.255 trust

and commented this line

#local all ident sameuser

In the postgresql.conf file I have uncommented many lines

this is the complete file

#
# PostgreSQL configuration file
# -----------------------------
#
# This file consists of lines of the form
#
# name = value
#
# (The `=' is optional.) White space is collapsed, comments are
# introduced by `#' anywhere on a line. The complete list of option
# names and allowed values can be found in the PostgreSQL
# documentation. The commented-out settings shown in this file
# represent the default values.

# Any option can also be given as a command line switch to the
# postmaster, e.g., 'postmaster -c log_connections=on'. Some options
# can be changed at run-time with the 'SET' SQL command.


#========================================================================


#
# Connection Parameters
#
#tcpip_socket = false
tcpip_socket = true
ssl = false

max_connections = 32

port = 5432
#hostname_lookup = false
#show_source_port = false

#unix_socket_directory = ''
#unix_socket_group = ''
unix_socket_permissions = 0777

#virtual_host = ''

#krb_server_keyfile = ''


#
# Shared Memory Size
#
shared_buffers = 64 # 2*max_connections, min 16
max_fsm_relations = 100 # min 10, fsm is free space map
max_fsm_pages = 10000 # min 1000, fsm is free space map
max_locks_per_transaction = 64 # min 10
wal_buffers = 8 # min 4

#
# Non-shared Memory Sizes
#
sort_mem = 512 # min 32
vacuum_mem = 8192 # min 1024


#
# Write-ahead log (WAL)
#
wal_files = 0 # range 0-64
wal_sync_method = fsync # the default varies across platforms:
# # fsync, fdatasync, open_sync, or open_datasync
wal_debug = 0 # range 0-16
commit_delay = 0 # range 0-100000
commit_siblings = 5 # range 1-1000
checkpoint_segments = 3 # in logfile segments (16MB each), min 1
checkpoint_timeout = 300 # in seconds, range 30-3600
fsync = true


#
# Optimizer Parameters
#
enable_seqscan = true
enable_indexscan = true
enable_tidscan = true
enable_sort = true
enable_nestloop = true
enable_mergejoin = true
enable_hashjoin = true

#ksqo = false

effective_cache_size = 1000 # default in 8k pages
random_page_cost = 4
cpu_tuple_cost = 0.01
cpu_index_tuple_cost = 0.001
cpu_operator_cost = 0.0025


#
# GEQO Optimizer Parameters
#
geqo = true
geqo_selection_bias = 2.0 # range 1.5-2.0
geqo_threshold = 11
geqo_pool_size = 0 # default based on #tables in query, range 128-1024
geqo_effort = 1
geqo_generations = 0
geqo_random_seed = -1 # auto-compute seed


#
# Debug display
#
silent_mode = false

log_connections = false
log_timestamp = false
log_pid = false

debug_level = 0 # range 0-16

debug_print_query = false
debug_print_parse = false
debug_print_rewritten = false
debug_print_plan = false
debug_pretty_print = false

# requires USE_ASSERT_CHECKING
#debug_assertions = true


#
# Syslog
#
# requires ENABLE_SYSLOG
#syslog = 0 # range 0-2
#syslog_facility = 'LOCAL0'
#syslog_ident = 'postgres'


#
# Statistics
#
show_parser_stats = false
show_planner_stats = false
show_executor_stats = false
show_query_stats = false

# requires BTREE_BUILD_STATS
#show_btree_build_stats = false


#
# Access statistics collection
#
stats_start_collector = true
stats_reset_on_server_start = true
stats_command_string = false
stats_row_level = false
stats_block_level = false


#
# Lock Tracing
#
trace_notify = false

# requires LOCK_DEBUG
#trace_locks = false
#trace_userlocks = false
#trace_lwlocks = false
#debug_deadlocks = false
#trace_lock_oidmin = 16384
#trace_lock_table = 0


#
# Misc
#
dynamic_library_path = '$libdir'
australian_timezones = false
authentication_timeout = 60 # min 1, max 600
deadlock_timeout = 1000
default_transaction_isolation = 'read committed'
max_expr_depth = 10000 # min 10
max_files_per_process = 1000 # min 25
password_encryption = false
sql_inheritance = true
transform_null_equals = false


I have changed the config.inc.php file to add the postgres password this is the relevant part


// The $cfgServers array starts with $cfgServers[1]. Do not use $cfgServers[0].
// You can disable a server config entry by setting host to ''.
$cfgServers[1]['local'] = false;
$cfgServers[1]['host'] = 'localhost';
$cfgServers[1]['port'] = '5432';
$cfgServers[1]['adv_auth'] = true;

$cfgServers[1]['user'] = 'postgres'; // if you are not using adv_auth, enter the username to connect all the time
$cfgServers[1]['password'] = 'postgres'; // if you are not using adv_auth and a password is required enter a password
$cfgServers[1]['only_db'] = ''; // if set to a db-name, only this db is accessible

$cfgServers[2]['local'] = false;
$cfgServers[2]['host'] = '';
$cfgServers[2]['port'] = '5432';
$cfgServers[2]['adv_auth'] = true;

$cfgServers[2]['user'] = ''; // if you are not using adv_auth, enter the username to connect all the time
$cfgServers[2]['password'] = ''; // if you are not using adv_auth and a password is required enter a password
$cfgServers[2]['only_db'] = ''; // if set to a db-name, only this db is accessible

$cfgServers[3]['local'] = false;
$cfgServers[3]['host'] = '';
$cfgServers[3]['port'] = '5432';
$cfgServers[3]['adv_auth'] = true;

$cfgServers[3]['user'] = ''; // if you are not using adv_auth, enter the username to connect all the time


Can someone tell me what has gone wrong?
Is there something more I need to change?That was all I needed to do in 7.3 redhat

 

[Leland123]

Hi newbiepg,

You might make sure you have assigned postgres the correct password. As root do a:

# passwd postgres

Then enter the password for postgres.

Next change your pg_hba.conf "trust" setting to "password"

Restart postgres like:

# service postgresql restart

The as root try to login to postgres like:

# psql template1 -U postgres

You will be asked your password. If postgres accepts it, you will get the SQL command prompt.

Next, make sure the password you used to connect to postgres in the command window is entered exactly into your phpPgAdmin config.inc.php file. Then you should be able to log into phpPgAdmin.

LelandJ



Leland F. Jackson, CPA
Software - Master (TM)

http://www.smvfp.com

Nothing Runs Like the Fox

 

[newbiepg]

Leland123
Thanks . I was able to get the system working.
The error was that I had kept this line commented

#hostname_lookup = false

I changed it to
hostname_lookup = true

I was trying to change the password using PgAccess, but it seems that it is not there in Redhat 8.0.
When I tried psql template1 -U postgres after changing password, it said error in pg_hba.conf

I did locate PgAcess
and also run PgAcess(alt + f2) but it was not there.

I will write the entire process when I get time
Thanks for trying

 

[Leland123]

Hi newbiepg,

I had some time so I booted up Red Hat 8.0 on my dule boot computer. I opened up a command window and type pgaccess. When the pgaccess dialog came up, I was able to log into it. I clicked on the database I wanted to open in the left hand pane of the dialog. This opened a tree view with the database as it root. Off the database root I selected the user object. All users associated with the database appeared in the right hand pane. I select a user by clicking on him. Then I clicked on the top menu labeled [Object]. From the menu list that dropped down, I selected [Design]. This opened a dialog window for the user that would allow me to change his password.

Maybe this will help.

LelandJ

Leland F. Jackson, CPA
Software - Master (TM)

http://www.smvfp.com

Nothing Runs Like the Fox