RE: [ADMIN] passwords ?
RE: [ADMIN] passwords ?
От:
"Benjamin Tehan" <sysadmin@sakon.com.sg>
Дата:
i tried that also and it didnt work [admin@host3 admin]$ su postgres Password: su: incorrect password [admin@host3 admin]$ If i su postgres from root i dont need to enter a password Any other ideas ? -----Original Message----- From: aubrey [mailto:aubrey.quarcoo@esolutions.co.nz] Sent: Thursday, February 24, 2000 11:31 AM To: Benjamin Tehan Subject: Re: [ADMIN] passwords ? try su postgres password : postgres ----- Original Message ----- From: Benjamin Tehan To: postgreSQL Sent: Thursday, February 24, 2000 4:22 PM Subject: [ADMIN] passwords ? > Ok, I have a small query. > > When I goto create a database I cannot create one > > I've already created the a new postgres database via initdb and i have run > postmaster > > I never set a password to postgres, and I've tried using the admin/root > password and yet that doesnt work either. > > Any one got any ideas ? > > I'm using Linux > > > > [admin@host3 admin]$ su > Password: > [root@host3 admin]# su - postgres > [postgres@host3 pgsql]$ createdb cfsnippets > Connection to database 'template1' failed. > fe_sendauth: no password supplied > > createdb: database creation failed on cfsnippets. > [postgres@host3 pgsql]$ createdb -u cfsnippets > Username: postgres > Password: > > Connection to database 'template1' failed. > Password authentication failed for user 'postgres' > createdb: database creation failed on cfsnippets. > [postgres@host3 pgsql]$ > > > ************ >
RE: [ADMIN] passwords ?
От:
"Hossein S. Zadeh" <hossein@bf.rmit.edu.au>
Дата:
On Thu, 24 Feb 2000, Benjamin Tehan wrote: > i tried that also and it didnt work > > [admin@host3 admin]$ su postgres > Password: > su: incorrect password > [admin@host3 admin]$ > > If i su postgres from root i dont need to enter a password > Probably because password of postgres account is disabled! :-) Seriousely, postgres account gets "!!" as its password in /etc/shadow, and it only means one thing: no one can login to postgres account. This extends to "su" from another account as well. But of course most security checks are ignored if you are "root"; including "su" into a disabled account. cheers, Hossein