Page 1 of 1

[SOLVED]Created postgresql database now can't login...

Posted: Tue Mar 23, 2004 11:08 pm
by dragonreborn
I created a pgsql db using the following commands (using Cygwin bash shell):

Code: Select all

ipc-daemon2 &

initdb -D /pgsql -W -E LATIN1
(this ran through the process and I set the superuser pass)

/bin/pg_clt -D /pgsql -l logfilestart
 -database successfully started
Now, I've got phppgadmin on the server but can't get it to connect. I've tried setting the host to localhost and '' but not working. Trying to login as [myself] with superuser pass I created with initdb.

Posted: Wed Mar 24, 2004 12:31 am
by Slippy
Make sure of the following:

- superuser should not be root user, just a "postgres" user should be used

- check the config.inc.php file for phppgadmin and make sure that you have specifed the host (localhost), port (5432), username (postgres), password (pass)

- Make sure you are using $cfgServers[1] and not [0]

- Start the postmaster with the -i option so that it is listening on ports and not socks

Posted: Wed Mar 24, 2004 10:08 am
by dragonreborn
Ok I'll make the changes but the config.ini.php file doesn't have variables for user and pass do they need to be set?

Also just to make sure I got this right the command to start the postmaster should be: /bin/pg_clt -D -i /pgsql -l logfile start

(that looks weird to me...hmmmm)

Should I change the following in the config.ini.php file:

Code: Select all

// If extra login security is true, then logins via phpPgAdmin with no
	// password or certain usernames (pgsql, postgres, root, administrator)
	// will be denied. Only turn this off once you have read the FAQ and
	// understand how to change PostgreSQL's pg_hba.conf to enable
	// passworded local connections.
	$confї'extra_login_security'] = true;
-thanks

Posted: Wed Mar 24, 2004 11:15 am
by dragonreborn
got it working with the following: postmaster -D /pgsql -i

Thanks for the help

Posted: Wed Mar 24, 2004 3:03 pm
by Slippy
Glad it worked.