--===============1222641847==
Content-Type: multipart/alternative;
boundary="----=_Part_30090_1856751.1204520542018"

------=_Part_30090_1856751.1204520542018
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Thomas

Thanks for your response. Got it working in the end, figured the message was
not telling me the correct thing, not finding the user actually meant the
password was wrong....which was throwing me off the track.


SQLBackend postgres



AuthOrder mod_sql.c mod_auth_unix.c
SQLAuthenticate users
SQLAuthTypes Crypt
SQLConnectInfo mc2@host username password
SQLUserInfo accounts login passwd uid gid homedir shell
SQLGroupInfo groups group_name gid gid

For those that have this in the future.

I added all SQLAuthTypes to the line and it worked so I removed one at a
time until it didn't anymore.

Thanks

Darragh

On Fri, Feb 29, 2008 at 8:40 PM, Thomas L. Shinnick wrote:

> 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
>
>
> -------------------------------------------------------------------------
> 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
>


------=_Part_30090_1856751.1204520542018
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Thomas

Thanks for your response. Got it working in the end, figured the message was not telling me the correct thing, not finding the user actually meant the password was wrong....which was throwing me off the track.


<IfModule mod_sql.c>
SQLBackend                      postgres
</IfModule>


AuthOrder               mod_sql.c mod_auth_unix.c
SQLAuthenticate         users
SQLAuthTypes            Crypt

SQLConnectInfo          mc2@host username password
SQLUserInfo             accounts login passwd uid gid homedir shell
SQLGroupInfo            groups group_name gid gid

For those that have this in the future.


I added all SQLAuthTypes to the line and it worked so I removed one at a time until it didn't anymore.

Thanks

Darragh

On Fri, Feb 29, 2008 at 8:40 PM, Thomas L. Shinnick <tshinnic@io.com> wrote:



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   <roftpd-users@proftpd.org" target="_blank">proftpd-users@proftpd.org>

Unsubscribe problems?


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



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

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   <roftpd-users@proftpd.org">proftpd-users@proftpd.org>

Unsubscribe problems?

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



------=_Part_30090_1856751.1204520542018--


--===============1222641847==
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/
--===============1222641847==
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
--===============1222641847==--