Обсуждение: how to use pam-pgsql

Does anyone know how to set vsftpd to work with pam-pgsql for user
authentification or how to use pam-pgsql at all.

I declare a cursor as below:
    DECLARE
            links_cur SCROLL CURSOR IS SELECT * FROM road;

and get this error:
    CONTEXT:  invalid type name "SCROLL CURSOR IS SELECT * FROM road"

If I take away 'SCROLL', it has no problem.

Any hint?

Thanks,
cyw

<cyw@dls.net> writes:
> I declare a cursor as below:
>     DECLARE
>             links_cur SCROLL CURSOR IS SELECT * FROM road;
> and get this error:
>     CONTEXT:  invalid type name "SCROLL CURSOR IS SELECT * FROM road"

What PG version?  IIRC plpgsql didn't allow the SCROLL modifier there
before 8.3.

            regards, tom lane

Am 2008-10-06 12:28:28, schrieb Dejan Dimic:
> Does anyone know how to set vsftpd to work with pam-pgsql for user
> authentification or how to use pam-pgsql at all.

Does "vsftpd" support PAM?

If yes you have to configure PAM to use pgSQL.  ;-)

What about reading the documentation?

The SQL SCHEME is included in the tarball  so  create  a  database  like
"system" and load the *.sql file into it.  Now you can add  normal  unix
users to it.

Thanks, Greetings and nice Day/Evening
    Michelle Konzack
    Systemadministrator
    24V Electronic Engineer
    Tamay Dogan Network
    Debian GNU/Linux Consultant


--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
+49/177/9351947    50, rue de Soultz         MSN LinuxMichi
+33/6/61925193     67100 Strasbourg/France   IRC #Debian (irc.icq.com)

On Oct 8, 2:52 am, linux4miche...@tamay-dogan.net (Michelle Konzack)
wrote:
> Am 2008-10-06 12:28:28, schrieb Dejan Dimic:
>
> > Does anyone know how to set vsftpd to work with pam-pgsql for user
> > authentification or how to use pam-pgsql at all.
>
> Does "vsftpd" support PAM?
>
> If yes you have to configure PAM to use pgSQL.  ;-)
>
> What about reading the documentation?
>
> The SQL SCHEME is included in the tarball  so  create  a  database  like
> "system" and load the *.sql file into it.  Now you can add  normal  unix
> users to it.
>
> Thanks, Greetings and nice Day/Evening
>     Michelle Konzack
>     Systemadministrator
>     24V Electronic Engineer
>     Tamay Dogan Network
>     Debian GNU/Linux Consultant
>
> --
> Linux-User #280138 with the Linux Counter,http://counter.li.org/
> ##################### Debian GNU/Linux Consultant #####################
> Michelle Konzack   Apt. 917                  ICQ #328449886
> +49/177/9351947    50, rue de Soultz         MSN LinuxMichi
> +33/6/61925193     67100 Strasbourg/France   IRC #Debian (irc.icq.com)
>
>  signature.pgp
> < 1KViewDownload

Thanks, for your reply.
I have managed to make it work in the meantime :-)
Reading the documentation can be very informative.
There is a ton of mysql documentation but for postgresql not so many.