Обсуждение: installing without shell access

Is it at all possible to get pgsql installed on a system without access
to a shell?  A friend is wanting me to install a particular bulletin
board system on her website; however, her hosting plan only provides the
MySQL database - the bulletin board requires pgsql.  And her hosting
plan has no ssh access.

So, is it possible to install the database with only ftp access to the
account?

On Mon, Nov 10, 2008 at 09:50:09AM -0600, Dana Holland wrote:
> Is it at all possible to get pgsql installed on a system without access
> to a shell?  A friend is wanting me to install a particular bulletin
> board system on her website; however, her hosting plan only provides the
> MySQL database - the bulletin board requires pgsql.  And her hosting
> plan has no ssh access.
>
> So, is it possible to install the database with only ftp access to the
> account?

No. You need to be able to at least start the server process which you
cannot do via FTP.

HTH,

Tino.

--
"What we nourish flourishes." - "Was wir nähren erblüht."

www.lichtkreis-chemnitz.de
www.craniosacralzentrum.de

On Mon, Nov 10, 2008 at 8:50 AM, Dana Holland
<dana.holland@navarrocollege.edu> wrote:
> Is it at all possible to get pgsql installed on a system without access to a
> shell?  A friend is wanting me to install a particular bulletin board system
> on her website; however, her hosting plan only provides the MySQL database -
> the bulletin board requires pgsql.  And her hosting plan has no ssh access.
>
> So, is it possible to install the database with only ftp access to the
> account?

most web languanges ala php allow you to execute arbitrary commands
(using back ticks in php) so theoretically she could probably do it.

Scott Marlowe schrieb:
> On Mon, Nov 10, 2008 at 8:50 AM, Dana Holland
> <dana.holland@navarrocollege.edu> wrote:
>> Is it at all possible to get pgsql installed on a system without access to a
>> shell?  A friend is wanting me to install a particular bulletin board system
>> on her website; however, her hosting plan only provides the MySQL database -
>> the bulletin board requires pgsql.  And her hosting plan has no ssh access.
>>
>> So, is it possible to install the database with only ftp access to the
>> account?
>
> most web languanges ala php allow you to execute arbitrary commands
> (using back ticks in php) so theoretically she could probably do it.
>

That reminds me having seen something like a shell implemented in PHP:
google for php-shell. I've never used such a beast, though.

Ciao,
Thomas

You do NOT have to have root priviledges.  I've built postgresql more
than once without it and made it work.

What you do need is to install it to your local home directory where
the apache user has priviledges and set LD_LIBRARY_PATH (or whatever
it's called, it has been a while) and you're golden.

On Mon, Nov 10, 2008 at 11:49 AM, Aras Angelo <araskoktas@gmail.com> wrote:
> gmake install requires root privileges.
> It wont install with regular httpd user (apache, nobody etc.) on a php-shell
> script or php system command functions.
>
>
> On Mon, Nov 10, 2008 at 10:08 AM, Thomas Pundt <mlists@rp-online.de> wrote:
>>
>> Scott Marlowe schrieb:
>>>
>>> On Mon, Nov 10, 2008 at 8:50 AM, Dana Holland
>>> <dana.holland@navarrocollege.edu> wrote:
>>>>
>>>> Is it at all possible to get pgsql installed on a system without access
>>>> to a
>>>> shell?  A friend is wanting me to install a particular bulletin board
>>>> system
>>>> on her website; however, her hosting plan only provides the MySQL
>>>> database -
>>>> the bulletin board requires pgsql.  And her hosting plan has no ssh
>>>> access.
>>>>
>>>> So, is it possible to install the database with only ftp access to the
>>>> account?
>>>
>>> most web languanges ala php allow you to execute arbitrary commands
>>> (using back ticks in php) so theoretically she could probably do it.
>>>
>>
>> That reminds me having seen something like a shell implemented in PHP:
>> google for php-shell. I've never used such a beast, though.
>>
>> Ciao,
>> Thomas
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>
>



--
When fascism comes to America, it will be draped in a flag and
carrying a cross - Sinclair Lewis

On Mon, Nov 10, 2008 at 10:54:57AM -0700, Scott Marlowe wrote:

> > Is it at all possible to get pgsql installed on a system without access to a
> > shell?  A friend is wanting me to install a particular bulletin board system
> > on her website; however, her hosting plan only provides the MySQL database -
> > the bulletin board requires pgsql.  And her hosting plan has no ssh access.
> >
> > So, is it possible to install the database with only ftp access to the
> > account?
>
> most web languanges ala php allow you to execute arbitrary commands
> (using back ticks in php) so theoretically she could probably do it.

While that might somehow work it's most probably something the hosting
provider won't like to see. PHP scripts are not expected to launch
persistent server processes. Better get a dedicated server for that
purpose.

Tino.

--
"What we nourish flourishes." - "Was wir nähren erblüht."

www.lichtkreis-chemnitz.de
www.craniosacralzentrum.de