--===============1281699017==
Content-Type: multipart/alternative;
boundary="----=_Part_25341_1696715.1204261734213"

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

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



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

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

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



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






------=_Part_25341_1696715.1204261734213--


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