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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
dragonreborn
Forum Newbie
Posts: 8
Joined: Mon Mar 22, 2004 11:49 am
Location: Utah
Contact:

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

Post 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.
Last edited by dragonreborn on Wed Mar 24, 2004 11:14 am, edited 1 time in total.
User avatar
Slippy
Forum Contributor
Posts: 113
Joined: Sat Jul 12, 2003 11:31 pm
Location: Vancouver eh!

Post 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
dragonreborn
Forum Newbie
Posts: 8
Joined: Mon Mar 22, 2004 11:49 am
Location: Utah
Contact:

Post 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
dragonreborn
Forum Newbie
Posts: 8
Joined: Mon Mar 22, 2004 11:49 am
Location: Utah
Contact:

Post by dragonreborn »

got it working with the following: postmaster -D /pgsql -i

Thanks for the help
User avatar
Slippy
Forum Contributor
Posts: 113
Joined: Sat Jul 12, 2003 11:31 pm
Location: Vancouver eh!

Post by Slippy »

Glad it worked.
Post Reply