Thread: Autologin problem
Hi-- I'm trying to run the following command on the "/etc/rc.local" so it will run everytime (RedHat 7/PHP4/PostgreSQL): nohup su -c 'postmaster -i -D /usr/local/pgsql/data \ </dev/null >>server.log 2>>1 &' <username> The problem is that <username> has a password set, and since Linux doesn't ask for it when it's on the rc.local file, my command fails. Is there a way to include the password with the "su" command? Is there a way to CLEAR a user's password and set it to NULL? Julio Cuz, Jr. Riverside Community College jcuz@rccd.cc.ca.us
You shouldn't post to multiple lists at one time. It is rude for very many reasons. This is the line I use to start postgres from rc.local (watch the word wrap). Password is irrelevant. If I understand correctly, root is what runs the rc.local and root never needs a password to su to another user. Log in as root and su to a user. You'll see. Very possible your comand is failing for other reasons. # Start Postgresql su -l <username for which postgres runs under> -c "<location of postmaster> -i -D <postgres data directory> >> <path to postgres log file> 2>>1 &" Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com ----- Original Message ----- From: "Julio Cuz, Jr." <jcuz@rccd.cc.ca.us> To: <pgsql-php@postgresql.org>; <php-db@lists.php.net> Sent: Thursday, January 04, 2001 9:55 PM Subject: [PHP] Autologin problem > Hi-- > > I'm trying to run the following command on the "/etc/rc.local" so it will > run everytime (RedHat 7/PHP4/PostgreSQL): > > nohup su -c 'postmaster -i -D /usr/local/pgsql/data \ > </dev/null >>server.log 2>>1 &' <username> > > The problem is that <username> has a password set, and since Linux doesn't > ask for it when it's on the rc.local file, my command fails. > > Is there a way to include the password with the "su" command? > > Is there a way to CLEAR a user's password and set it to NULL? > > Julio Cuz, Jr. > Riverside Community College > jcuz@rccd.cc.ca.us
I assume you're trying to get PostGresql to load automatically. In RH, get rid of the stuff you wrote below and put in the following line (in rc.local): /etc/rc.d/init.d/postgresql start This is the proper way to start the DB.-- Read the file to see what it does. You can also stop and restart it in similar fasion. On Thu, 4 Jan 2001, Julio Cuz, Jr. wrote: > Hi-- > > I'm trying to run the following command on the "/etc/rc.local" so it will > run everytime (RedHat 7/PHP4/PostgreSQL): > > nohup su -c 'postmaster -i -D /usr/local/pgsql/data \ > </dev/null >>server.log 2>>1 &' <username> > > The problem is that <username> has a password set, and since Linux doesn't > ask for it when it's on the rc.local file, my command fails. > > Is there a way to include the password with the "su" command? > > Is there a way to CLEAR a user's password and set it to NULL? > > Julio Cuz, Jr. > Riverside Community College > jcuz@rccd.cc.ca.us >
Actually, that is a valid point. Do you compile postgres or install it with the OS? Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com ----- Original Message ----- From: "Steve Bern" <sabern@eshell.net> To: "Julio Cuz, Jr." <jcuz@rccd.cc.ca.us> Cc: <pgsql-php@postgresql.org>; <php-db@lists.php.net> Sent: Friday, January 05, 2001 10:45 AM Subject: Re: [PHP] Autologin problem > I assume you're trying to get PostGresql to load automatically. In RH, > get rid of the stuff you wrote below and put in the following line (in > rc.local): > > /etc/rc.d/init.d/postgresql start > > This is the proper way to start the DB.-- Read the file to see what it > does. You can also stop and restart it in similar fasion. > > > On Thu, 4 Jan 2001, Julio Cuz, Jr. wrote: > > > Hi-- > > > > I'm trying to run the following command on the "/etc/rc.local" so it will > > run everytime (RedHat 7/PHP4/PostgreSQL): > > > > nohup su -c 'postmaster -i -D /usr/local/pgsql/data \ > > </dev/null >>server.log 2>>1 &' <username> > > > > The problem is that <username> has a password set, and since Linux doesn't > > ask for it when it's on the rc.local file, my command fails. > > > > Is there a way to include the password with the "su" command? > > > > Is there a way to CLEAR a user's password and set it to NULL? > > > > Julio Cuz, Jr. > > Riverside Community College > > jcuz@rccd.cc.ca.us > >
On Fri, 5 Jan 2001, Steve Bern wrote: > I assume you're trying to get PostGresql to load automatically. In RH, > get rid of the stuff you wrote below and put in the following line (in > rc.local): > > /etc/rc.d/init.d/postgresql start Actually, do a "man chkconfig" and follow the directions there. Much neater. In a nutshell: chkconfig --level 2345 postgresql on chkconfig --list -- Chuck Milam chuck@milams.net
In fact the RH style (rc.d) way is to add symlink "S95postgresql" (or "S<what_ever_you_need_number>postgresql" the number after "S" is for set the position after what postgres must start (eg. after or before apache) - for more detail see rc file in rc.d (and other rc.* files too)) on rc3.d (or directory for other runlevel) directory to the /etc/init.d/postgresql In fact in this rc.local start string was some syntax bugs (misuses?) first of all You don't need to use nohup. It is nohup'ed by default (If I good remember) Second: Always use "su" with "-" option! It meens that proper syntax is su - -c "command to run" <username> the "-" swith is for map env variables to variables proper for user <username> hope it helpful. regards Robert > I assume you're trying to get PostGresql to load automatically. In RH, > get rid of the stuff you wrote below and put in the following line (in > rc.local): > > /etc/rc.d/init.d/postgresql start > > This is the proper way to start the DB.-- Read the file to see what it > does. You can also stop and restart it in similar fasion. > > > On Thu, 4 Jan 2001, Julio Cuz, Jr. wrote: > > > Hi-- > > > > I'm trying to run the following command on the "/etc/rc.local" so it will > > run everytime (RedHat 7/PHP4/PostgreSQL): > > > > nohup su -c 'postmaster -i -D /usr/local/pgsql/data \ > > </dev/null >>server.log 2>>1 &' <username> > > > > The problem is that <username> has a password set, and since Linux doesn't > > ask for it when it's on the rc.local file, my command fails. > > > > Is there a way to include the password with the "su" command? > > > > Is there a way to CLEAR a user's password and set it to NULL? > > > > Julio Cuz, Jr. > > Riverside Community College > > jcuz@rccd.cc.ca.us > > >