Try this:
put "#!/bin/sh" & cr into tScript
put "pw=" & quote & tPass & quote & cr after tScript
put "echo $pw | sudo -S - postgres" & cr after tScript
put "/usr/local/bin/postmaster -D /usr/local/pgsql/data -i" & cr after tScript
put shell(tScript) into tCheck -- do the command & get the result
The tPass variable must contain your admin password.
Cheers,
Sarah
On 10/19/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
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
_______________________________________________
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
