Quoting Sarah Reichelt <[EMAIL PROTECTED]>: > I have never used PostgreSQL, so I don't know how you normally start > it. However from the error message, it appears that you don't start it > with sudo, just with a standard user's login. > > Can you start PostgreSQL as normal from the Terminal and post the > commands you use (blanking out any password). Then we can see how that > needs to be altered to work directly from Rev. > > One other point: the message box does not always act exactly the same > as a script in an object, so for testing, I suggest you make a button > and do this in a mouseUp handler. > > Cheers, > Sarah first of all thanks for your response and sorry for the delay, accidently I posted my password and had to change it immediatly and some how my computer got locked and took a while till i got back to business plus the holidays. Ok, I open terminal, quote Hershel-Fischs-Computer:~ hershelfisch$ su - postgres Password: Hershel-Fischs-Computer:~ postgres$ /usr/local/bin/postmaster -D /usr/local/ pgsql/data -i and quote Thanks a million, Hersel Fisch
LOG: database system was shut down at 2006-10-18 16:19:56 EDT LOG: checkpoint record is at 0/AD3C8C LOG: redo record is at 0/AD3C8C; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 1469; next OID: 17250 LOG: database system is ready > > > On 10/5/06, Hershel Fisch <[EMAIL PROTECTED]> wrote: > > On 10/4/06 6:51 AM, "Sarah Reichelt" <[EMAIL PROTECTED]> wrote: > > Thanks, > > this is what I put into the message box > > > > put "#!/bin/sh" & cr into tScript put "pw=" & quote & "vehachhkl" & quote > & > > cr after tScript > > put "echo $pw | sudo -S /usr/local/bin/postmaster -D /usr/local/pgsql/data > - > > i" & cr after tScript > > put shell(tScript) > > > > This is the result for the above script > > Password: > > "root" execution of the PostgreSQL server is not permitted. > > The server must be started under an unprivileged user ID to prevent > > possible system security compromise. See the documentation for > > more information on how to properly start the server. > > > > --put "#!/bin/sh" & cr into tScript > > put "pw=" & quote & "vehachhkl" & quote & cr after tScript > > put "echo $pw | sudo -S /usr/local/bin/postmaster -D /usr/local/pgsql/data > - > > i" & cr after tScript > > put shell(tScript) > > > > And this is the result for this script, I'm wondering. > > 1 > > But it doesn't open "postgres" > > Thanks again. > > Hershel > > > > > > > On 10/4/06, Hershel Fisch <[EMAIL PROTECTED]> wrote: > > >> Hi, I'd greatly appreciate if some one can help me out on this one. > > >> How do I write this command with the shell function, I would write it > in > > >> terminal as follows > > >> > > >> Su - myUsr > > >> Password: > > >> And another command. > > >> > > >> Now the question is that every line above is a different entry > > >> If I put > > >> Put shell("su - myUsr") in the message box this is the result > > >> "Password's: Sorry" > > >> > > >> And also if I understand correctly every command with the shell function > is > > >> a different terminal and does not correspond to the previous shell > reply, is > > >> that true? If so how do I write that every command should correspond to > the > > >> previously respond? > > > > > > > > > You have to construct the shell commands as a single string and do it > > > all at once. Here's an example of how to use sudo to set the system > > > clock, but just put whatever you want after the "-S". > > > > > > put "#!/bin/sh" & cr into tScript > > > put "pw=" & quote & tPass & quote & cr after tScript > > > put "echo $pw | sudo -S date " & tDate & tTime & cr after tScript > > > -- build the command lines, the command you need to run goes after the > -S > > > put shell(tScript) into tCheck -- do the command & get the result > > > > > > You have to quote your admin password, but you can ask for that when > > > running the script, or store it in a custom property. > > > > > > HTH, > > > Sarah > > > _______________________________________________ > > > use-revolution mailing list > > > use-revolution@lists.runrev.com > > > Please visit this url to subscribe, unsubscribe and manage your > subscription > > > preferences: > > > http://lists.runrev.com/mailman/listinfo/use-revolution > > > > _______________________________________________ > > use-revolution mailing list > > use-revolution@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-revolution > > > _______________________________________________ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/ _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution