Re: [Proftpd-user] AuthOrder: warning: module 'mod_sql

--===============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:[color=blue]
>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[/color]

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?
[color=blue]
>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:<http://111.2.3.4>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:<http://111.2.3.4>111.2.3.4]): FTP session opened.
>Feb 29 16:01:53 hudson proftpd[21659] hudson
>(::ffff:111.2.3.4[::ffff:<http://111.2.3.4>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:<http://111.2.3.4>111.2.3.4]): no such user 'darraghp'
>Feb 29 16:01:53 hudson proftpd[21659] hudson
>(::ffff:111.2.3.4[::ffff:<http://111.2.3.4>111.2.3.4]): USER
>darraghp: no such user found from
>::ffff:<http://203.10.72.85>203.10.72.85
>[::ffff:<http://203.10.72.85>203.10.72.85] to
>::ffff:<http://203.10.72.69:21>203.10.72.69:21
>Feb 29 16:01:53 hudson proftpd[21659] hudson
>(::ffff:111.2.3.4[::ffff:<http://111.2.3.4>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:<http://111.2.3.4>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.
>[url]http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/[/url]
>_______________________________________________
>ProFTPD Users List <proftpd-users@proftpd.org>
>Unsubscribe problems?
>[url]http://www.proftpd.org/list-unsub.html[/url][/color]

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

<html>
<body>
At 11:08 PM 2/28/2008, you wrote: 
<blockquote type=cite class=cite cite="">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</blockquote> 
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? 
<blockquote type=cite class=cite cite="">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:<a href="http://111.2.3.4">111.2.3.4</a>]):
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:<a href="http://111.2.3.4">111.2.3.4</a>]): FTP
session opened. 
Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:<a href="http://111.2.3.4">111.2.3.4</a>]):
mod_delay/0.5: delaying for 162 usecs 
Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:<a href="http://111.2.3.4">111.2.3.4</a>]): no
such user 'darraghp' 
Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:<a href="http://111.2.3.4">111.2.3.4</a>]): USER
darraghp: no such user found from
::ffff:<a href="http://203.10.72.85">203.10.72.85</a>
[::ffff:<a href="http://203.10.72.85">203.10.72.85</a>] to
::ffff:<a href="http://203.10.72.69:21">203.10.72.69:21</a> 
Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:<a href="http://111.2.3.4">111.2.3.4</a>]):
mod_delay/0.5: delaying for 229 usecs 
Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:<a href="http://111.2.3.4">111.2.3.4</a>]): 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. 
<a href="http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/" eudora="autourl">
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/</a> 
_______________________________________________ 
ProFTPD Users List   <proftpd-users@proftpd.org> 
Unsubscribe problems? 
<a href="http://www.proftpd.org/list-unsub.html" eudora="autourl">
http://www.proftpd.org/list-unsub.html</a></blockquote></body>
</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.
[url]http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/[/url]
--===============1218218558==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
ProFTPD Users List <proftpd-users@proftpd.org>
Unsubscribe problems?
[url]http://www.proftpd.org/list-unsub.html[/url]
--===============1218218558==--

Re: [Proftpd-user] AuthOrder: warning: module 'mod_sql_postgres.c'