[prev in list] [next in list] [prev in thread] [next in thread]
List: proftpd-users
Subject: Re: [Proftpd-user] AuthOrder: warning: module 'mod_sql_postgres.c'
From: "Darragh Gammell" <dbgsystems2 () gmail ! com>
Date: 2008-03-03 5:02:21
Message-ID: bdffd0680803022102s3b5b76fape247a9ce6c715f0c () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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 <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 <proftpd-users@proftpd.org>
> Unsubscribe problems?
> http://www.proftpd.org/list-unsub.html
>
[Attachment #5 (text/html)]
Hi Thomas<br><br>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. <br> <br><IfModule \
mod_sql.c><br>SQLBackend \
postgres<br></IfModule><br><br><br>AuthOrder \
mod_sql.c mod_auth_unix.c<br>SQLAuthenticate \
users<br>SQLAuthTypes \
Crypt<br> SQLConnectInfo \
<font><font size="3">mc2@host username \
password</font></font><br>SQLUserInfo \
accounts login passwd uid gid homedir \
shell<br>SQLGroupInfo \
groups group_name gid gid<br><br>For those that have this in the future.<br> <br>I \
added all SQLAuthTypes to the line and it worked so I removed one at a time until it \
didn't anymore.<br><br>Thanks<br><br>Darragh<br><br><div class="gmail_quote">On \
Fri, Feb 29, 2008 at 8:40 PM, Thomas L. Shinnick <<a \
href="mailto:tshinnic@io.com">tshinnic@io.com</a>> wrote:<br> <blockquote \
class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt \
0pt 0.8ex; padding-left: 1ex;"> <div><div class="Ih2E3d">
<font size="3">At 11:08 PM 2/28/2008, you wrote:<br>
<blockquote type="cite">Hi<br><br>
I recently set up proftpd and had it working with /etc/passwd
fine.<br><br>
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<br><br>
AuthOrder
mod_sql_postgres.c<br><br>
SQLAuthenticate
users*<br>
SQLBackend
postgres<br>
SQLAuthTypes
Plaintext<br><br>
SQLConnectInfo
mc2@host username password<br><br>
SQLUserInfo
accounts login passwd_txt uid gid homedir shell</blockquote></font><br></div>
It's been so long, but can I ask if you did <br>
./configure
--with-modules=mod_sql:mod_sql_postgres<br><br>
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.<br><br>
So... what about in \doc\howto\Authentication.html where it says <br>
AuthOrder mod_sql.c <br>
not <br><div class="Ih2E3d">
AuthOrder mod_sql_postgres.c <br><br></div>
That makes more sense, doesn't it?<br><br>
<blockquote type="cite"><font size="3"><div class="Ih2E3d">but I see this in
the logs is:<br><br>
eb 29 16:01:46 hudson proftpd[4657] hudson: ProFTPD killed (signal
15)<br>
Feb 29 16:01:46 hudson proftpd[4657] hudson: ProFTPD 1.3.0 standalone
mode SHUTDOWN<br>
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<br>
Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:<a href="http://111.2.3.4" target="_blank">111.2.3.4</a>]):
AuthOrder: warning: module 'mod_sql_postgres.c' has no auth handlers<br>
Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:<a href="http://111.2.3.4" target="_blank">111.2.3.4</a>]): \
FTP session opened.<br>
Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:<a href="http://111.2.3.4" target="_blank">111.2.3.4</a>]):
mod_delay/0.5: delaying for 162 usecs<br>
Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:<a href="http://111.2.3.4" target="_blank">111.2.3.4</a>]): \
no such user 'darraghp'<br>
Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:<a href="http://111.2.3.4" target="_blank">111.2.3.4</a>]): \
USER
darraghp: no such user found from
> > ffff:<a href="http://203.10.72.85" target="_blank">203.10.72.85</a>
[::ffff:<a href="http://203.10.72.85" target="_blank">203.10.72.85</a>] to
> > ffff:<a href="http://203.10.72.69:21" target="_blank">203.10.72.69:21</a><br>
Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:<a href="http://111.2.3.4" target="_blank">111.2.3.4</a>]):
mod_delay/0.5: delaying for 229 usecs<br>
Feb 29 16:01:53 hudson proftpd[21659] hudson
(::ffff:111.2.3.4[::ffff:<a href="http://111.2.3.4" target="_blank">111.2.3.4</a>]): \
FTP session closed.<br><br>
<br>
Note:<br>
Running the query using psql works fine.<br><br>
mc2=# select login, passwd_txt, uid, gid, homedir, shell from accounts
where login='darraghp';<br>
login | passwd_txt | uid | gid
>
>
homedir
| shell<br>
----------+------------+-------+-------+-------------------------------------+---------------<br>
darraghp | blabla | 74783 | 74783 |
/home/mc2/public_html/home/darraghp | /bin/ftp_only<br>
(1 row)<br><br>
<br>
can anyone indicate where Im going wrong.<br><br>
Cheers<br><br>
Darragh<br><br>
<br><br>
<br></div>
-------------------------------------------------------------------------<br>
This SF.net email is sponsored by: Microsoft<br>
Defy all challenges. Microsoft(R) Visual Studio 2008.<br>
<a href="http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/" target="_blank">
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/</a><br>
_______________________________________________<br>
ProFTPD Users List <<a href="mailto:proftpd-users@proftpd.org" \
target="_blank">proftpd-users@proftpd.org</a>><br> Unsubscribe problems?<br>
<a href="http://www.proftpd.org/list-unsub.html" target="_blank">
http://www.proftpd.org/list-unsub.html</a></font></blockquote></div>
<br>-------------------------------------------------------------------------<br>
This SF.net email is sponsored by: Microsoft<br>
Defy all challenges. Microsoft(R) Visual Studio 2008.<br>
<a href="http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/" \
target="_blank">http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/</a><br>_______________________________________________<br>
ProFTPD Users List <<a \
href="mailto:proftpd-users@proftpd.org">proftpd-users@proftpd.org</a>><br> \
Unsubscribe problems?<br> <a href="http://www.proftpd.org/list-unsub.html" \
target="_blank">http://www.proftpd.org/list-unsub.html</a><br></blockquote></div><br>
-------------------------------------------------------------------------
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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic