--===============1218218558==
Content-Type: multipart/alternative;
boundary="=====================_478538937==.ALT"

--=====================_478538937==.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed

At 11:08 PM 2/28/2008, you wrote:
>Hi
>
>I recently set up proftpd and had it working with /etc/passwd fine.
>
>I then tried to set up an mod_sql module and use that. so did
>apt-get install proftpd-pgsql(running ubuntu gutsy) and added the
>following to my /etc/proftpd/proftpd.conf
>
>AuthOrder mod_sql_postgres.c
>
>SQLAuthenticate users*
>SQLBackend postgres
>SQLAuthTypes Plaintext
>
>SQLConnectInfo mc2@host username password
>
>SQLUserInfo accounts login passwd_txt uid gid homedir shell


It's been so long, but can I ask if you did
./configure --with-modules=mod_sql:mod_sql_postgres

I looked in both these modules and one clearly says "I have
authentication hooks" and the other says "" so I bet you have
to use both. If you've done that, apologies... And since that's
covered in \doc\howto\SQL.html you've probably done that.

So... what about in \doc\howto\Authentication.html where it says
AuthOrder mod_sql.c
not
AuthOrder mod_sql_postgres.c

That makes more sense, doesn't it?

>but I see this in the logs is:
>
>eb 29 16:01:46 hudson proftpd[4657] hudson: ProFTPD killed (signal 15)
>Feb 29 16:01:46 hudson proftpd[4657] hudson: ProFTPD 1.3.0
>standalone mode SHUTDOWN
>Feb 29 16:01:48 hudson proftpd[21543] hudson: ProFTPD 1.3.0 (stable)
>(built Fri Jun 15 12:59:13 GMT 2007) standalone mode STARTUP
>Feb 29 16:01:53 hudson proftpd[21659] hudson
>(::ffff:111.2.3.4[::ffff:111.2.3.4]): AuthOrder:
>warning: module 'mod_sql_postgres.c' has no auth handlers
>Feb 29 16:01:53 hudson proftpd[21659] hudson
>(::ffff:111.2.3.4[::ffff:111.2.3.4]): FTP session opened.
>Feb 29 16:01:53 hudson proftpd[21659] hudson
>(::ffff:111.2.3.4[::ffff:111.2.3.4]):
>mod_delay/0.5: delaying for 162 usecs
>Feb 29 16:01:53 hudson proftpd[21659] hudson
>(::ffff:111.2.3.4[::ffff:111.2.3.4]): no such user 'darraghp'
>Feb 29 16:01:53 hudson proftpd[21659] hudson
>(::ffff:111.2.3.4[::ffff:111.2.3.4]): USER
>darraghp: no such user found from
>::ffff:203.10.72.85
>[::ffff:203.10.72.85] to
>::ffff:203.10.72.69:21
>Feb 29 16:01:53 hudson proftpd[21659] hudson
>(::ffff:111.2.3.4[::ffff:111.2.3.4]):
>mod_delay/0.5: delaying for 229 usecs
>Feb 29 16:01:53 hudson proftpd[21659] hudson
>(::ffff:111.2.3.4[::ffff:111.2.3.4]): FTP session closed.
>
>
>Note:
>Running the query using psql works fine.
>
>mc2=# select login, passwd_txt, uid, gid, homedir, shell from
>accounts where login='darraghp';
> login | passwd_txt
> | uid | gid | homedir | shell
>----------+------------+-------+-------+-------------------------------------+---------------
> darraghp | blabla | 74783 | 74783 |
> /home/mc2/public_html/home/darraghp | /bin/ftp_only
>(1 row)
>
>
>can anyone indicate where Im going wrong.
>
>Cheers
>
>Darragh
>
>
>
>
>-------------------------------------------------------------------------
>This SF.net email is sponsored by: Microsoft
>Defy all challenges. Microsoft(R) Visual Studio 2008.
>http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>_______________________________________________
>ProFTPD Users List
>Unsubscribe problems?
>http://www.proftpd.org/list-unsub.html


--=====================_478538937==.ALT
Content-Type: text/html; charset="us-ascii"



At 11:08 PM 2/28/2008, you wrote:

Hi


I recently set up proftpd and had it working with /etc/passwd
fine.


I then tried to set up an mod_sql module and use that. so did apt-get
install proftpd-pgsql(running ubuntu gutsy) and added the following to my
/etc/proftpd/proftpd.conf


AuthOrder              
mod_sql_postgres.c


SQLAuthenticate        
users*

SQLBackend             
postgres

SQLAuthTypes           
Plaintext


SQLConnectInfo         
mc2@host username password


SQLUserInfo            
accounts login passwd_txt uid gid homedir shell


It's been so long, but can I ask if you did

    ./configure
--with-modules=mod_sql:mod_sql_postgres


I looked in both these modules and one clearly says "I have
authentication hooks" and the other says "<null>" so
I bet you have to use both.  If you've done that, apologies... 
And since that's covered in \doc\howto\SQL.html you've probably done
that.


So... what about in \doc\howto\Authentication.html where it says

      AuthOrder mod_sql.c

not

      AuthOrder mod_sql_postgres.c


That makes more sense, doesn't it?


but I see this in
the logs is:


eb 29 16:01:46 hudson proftpd[4657] hudson: ProFTPD killed (signal
15)

Feb 29 16:01:46 hudson proftpd[4657] hudson: ProFTPD 1.3.0 standalone
mode SHUTDOWN

Feb 29 16:01:48 hudson proftpd[21543] hudson: ProFTPD 1.3.0 (stable)
(built Fri Jun 15 12:59:13 GMT 2007) standalone mode STARTUP

Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:111.2.3.4]):
AuthOrder: warning: module 'mod_sql_postgres.c' has no auth handlers

Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:111.2.3.4]): FTP
session opened.

Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:111.2.3.4]):
mod_delay/0.5: delaying for 162 usecs

Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:111.2.3.4]): no
such user 'darraghp'

Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:111.2.3.4]): USER
darraghp: no such user found from
::ffff:203.10.72.85
[::ffff:203.10.72.85] to
::ffff:203.10.72.69:21

Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:111.2.3.4]):
mod_delay/0.5: delaying for 229 usecs

Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:111.2.3.4]): FTP
session closed.




Note:

Running the query using psql works fine.


mc2=# select login, passwd_txt, uid, gid, homedir, shell from accounts
where login='darraghp';

  login   | passwd_txt |  uid  |  gid 
|              
homedir              
|     shell

----------+------------+-------+-------+-------------------------------------+---------------

 darraghp | blabla  | 74783 | 74783 |
/home/mc2/public_html/home/darraghp | /bin/ftp_only

(1 row)




can anyone indicate where Im going wrong.


Cheers


Darragh







-------------------------------------------------------------------------

This SF.net email is sponsored by: Microsoft

Defy all challenges. Microsoft(R) Visual Studio 2008.


http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/


_______________________________________________

ProFTPD Users List   <proftpd-users@proftpd.org>

Unsubscribe problems?


http://www.proftpd.org/list-unsub.html



--=====================_478538937==.ALT--



--===============1218218558==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
--===============1218218558==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
ProFTPD Users List
Unsubscribe problems?
http://www.proftpd.org/list-unsub.html
--===============1218218558==--