[Proftpd-user] MS IE bug workaround patch: 'badly formatted EPRT argument' (RFC2428)

[Paulo Matos <pjsm@fc...>]

	Hi folks!

	I discovered a bug on Microsoft Internet Explorer (only tested on=20
ipv6 not NAT), which results on a 'badly formatted EPRT argument'.

	This happens because IE does not send the final terminator on the=20
EPRT argument as stated on sec. 2 of RFC2428:
"(...)          =20
       EPRT<space><d><net-prt><d><net-addr><d><tcp-port><d>
"
	An example is of IE's conversation is:
USER anonymous
PASS (hidden)
OPTS utf8 on
SYST
SITE help
PWD
NOOP
CWD /
TYPE A
EPRT |2|2001:690:1ffe:6666::10|1038

at this time the following proftpd error:

badly formatted EPRT argument: '|2|2001:690:1ffe:6666::10|1038'

	This was tested on the same client use MS command-line ftp and it=20
behaved as expected sending the EPRT command as:

EPRT |2|2001:690:1ffe:6666::10|1044|


	Tested with the latest IE available at the moment:

	Version: 6.0.2800.1106.xpsp2.030422-1633
	Updates: SP1; Q822925; Q330994; Q820223; Q828750; Q824145; Q832894

	Hope this helps someone while waiting for IE's bugfix...

	Regards,

	Paulo Matos
 ----------------------------------- ----------------------------------
|Sys & Net Admin                    | Servi=E7o de Inform=E1tica         =
  |
|Faculdade de Ci=EAncias e Tecnologia | Tel: +351-21-2948596             =
|
|Universidade Nova de Lisboa        | Fax: +351-21-2948548             |
|P-2829-516 Caparica                | e-Mail: pjsm@...          |
 ----------------------------------- ----------------------------------

RE: [Proftpd-user] proftpd configuration and authentication probl em

[Bailey, Dwight <DBailey@ha...>]

TJ, Thanks for the quick response yesterday!

The apparent reason for the error [that were Killing Me ;-)] were:

1. The user's home directory had to correspond to the directory in
proftpd.conf file.
2. Setting the absolute path in proftpd.conf and removing the tilde (~)
allowed the user to authenticate to their directories.
3. Setting the appropriate permissions and ownership on the directory.

The suggestions you made were right on target and running proftpd in
debugging mode (proftpd -nd6) provided a lot of useful information.

The ftp server is up and running and the test users were able to
authenticate. The <Limit> directives were also enforced correctly.

Now I will move on to figuring out how to allow password user's to change
between multiple incongruent directories.

Thanks again! And I look forward to the day when I can give good suggestion
as you did here.

-Dwight

-----Original Message-----
From: proftp-user-admin@...
[mailto:proftp-user-admin@...]On Behalf Of TJ Saunders
Sent: Wednesday, February 04, 2004 9:08 AM
To: 'proftp-user@...'
Subject: Re: [Proftpd-user] proftpd configuration and authentication
problem



> ##### Default Directory #####
>
> DefaultRoot  ~/export/ftp

Does every user have an export/ftp directory in their home directory?  The
tilde character (~) expands to the full path to the home directory of the
user logging in...

> The errors that are killing me are:
>
> 1. 530 login incorrect,  Login failed when logging in as utestpwd.
> Notes: the user has a valid username, password and group.

What does server debugging output show when this happens?

 
http://www.castaglia.org/proftpd/doc/contrib/ProFTPD-mini-HOWTO-Debugging.ht
ml

A description of how proftpd authenticates users can be found here:

 
http://www.castaglia.org/proftpd/doc/contrib/ProFTPD-mini-HOWTO-Authenticati
on.html

> 2.Logging in as ftp lets me in to the public area but I still have
> permissions to upload and delete files?

It looks like your use of the tilde in your <Directory> sections may not
be resulting in the paths you expect.  It's best to use full paths in
<Directory> sections:

 
http://www.castaglia.org/proftpd/doc/contrib/ProFTPD-mini-HOWTO-Directory.ht
ml

> 3.Logging in as anonymous gives the 530 login incorrect. Login failed.
> Confusing since aliasing anonymous to ftp should still allow anonymous
> username.

Server debugging output should show why this happens, as well.

Hope this helps,
TJ

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~

   The act looks very differently on the inside, and on the outside; in its
   quality, and its consequences.

     -Ralph Waldo Emerson

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~


-------------------------------------------------------
The SF.Net email is sponsored by EclipseCon 2004
Premiere Conference on Open Tools Development and Integration
See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
http://www.eclipsecon.org/osdn
_______________________________________________
ProFTPD Users List   <proftpd-users@...>
Unsubscribe problems?
http://www.proftpd.org/list-unsub.html

[Proftpd-user] RE: mod_tls

[Jim Shewmaker <jim@tr...>]

> before.  If it isn't in my sql table, it isn't letting me in.  This was
> working last I checked.  I need this for FTP over SSH.  Just to be clear,
I
> added "AuthOrder mod_sql.c mod_auth_unix.c" to my proftpd.conf.  I happen
to
> be logged in with the account with SSH, and I've tested to be sure I
didn't
> do something stupid like cut and paste my password incorrectly.

What does your mod_sql configuration look like?

TJ
---------------------
mod_sql config looks like:

SQLAuthTypes	openssl Plaintext
SQLAuthenticate 	users* groups* usersetfast groupsetfast
SQLConnectInfo    client_accounts@... proftpd_master xxxxxxxxxx
SQLDefaultGID     100
SQLDefaultUID     1004
SQLMinUserGID     100
SQLMinUserUID     500
SQLUserInfo       users username passwd uid gid homedir shell
User                            ftp
Group                           clients

(ftp is uid 1004 and clients is gid 100)
I did make a couple of unrelated changes, but just in case, here is a new
log

debug shows:

- RELINQUISH PRIVS at mod_auth.c:150
- AuthOrder in effect, resetting auth module order
- connected - local  : xxxxxxxxx
- connected - remote : xxxxxxxxx
- FTP session opened.
- dispatching PRE_CMD command 'AUTH TLS' to mod_tls
- dispatching PRE_CMD command 'AUTH TLS' to mod_core
- dispatching PRE_CMD command 'AUTH TLS' to mod_core
- dispatching CMD command 'AUTH TLS' to mod_tls
- dispatching POST_CMD command 'AUTH TLS' to mod_sql
- dispatching LOG_CMD command 'AUTH TLS' to mod_sql
- dispatching LOG_CMD command 'AUTH TLS' to mod_log
- dispatching PRE_CMD command 'USER jim' to mod_tls
- dispatching PRE_CMD command 'USER jim' to mod_core
- dispatching PRE_CMD command 'USER jim' to mod_core
- dispatching PRE_CMD command 'USER jim' to mod_auth
- dispatching auth request "endpwent" to module mod_sql
- dispatching auth request "endgrent" to module mod_sql
- dispatching CMD command 'USER jim' to mod_ratio
- dispatching CMD command 'USER jim' to mod_auth
- dispatching auth request "getgroups" to module mod_sql
- no supplemental groups found for user 'jim'
- dispatching POST_CMD command 'USER jim' to mod_sql
- dispatching LOG_CMD command 'USER jim' to mod_sql
- dispatching LOG_CMD command 'USER jim' to mod_log
- dispatching PRE_CMD command 'PASS (hidden)' to mod_tls
- dispatching PRE_CMD command 'PASS (hidden)' to mod_core
- dispatching PRE_CMD command 'PASS (hidden)' to mod_core
- dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap
- dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
- dispatching auth request "endpwent" to module mod_sql
- dispatching auth request "endgrent" to module mod_sql
- dispatching CMD command 'PASS (hidden)' to mod_auth
- dispatching auth request "getgroups" to module mod_sql
- no supplemental groups found for user 'jim'
- dispatching auth request "getpwnam" to module mod_sql
- no such user 'jim'
- USER jim: no such user found from xxxxxxxxxx to xxxxxxxxxxxxxx
- dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_sql
- dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_sql
- dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log
- dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth
- dispatching auth request "endpwent" to module mod_sql
- dispatching auth request "endgrent" to module mod_sql
- FTP session closed

And the normal proftpd.log shows:
xxx.xxx.xxx.xxx UNKNOWN ftp [05/Feb/2004:11:07:39 -0800] "USER jim" 331 -
xxx.xxx.xxx.xxx UNKNOWN ftp [05/Feb/2004:11:07:39 -0800] "PASS (hidden)"
530 -
xxx.xxx.xxx.xxx UNKNOWN ftp [05/Feb/2004:11:08:59 -0800] "USER tester" 331 -
xxx.xxx.xxx.xxx UNKNOWN tester [05/Feb/2004:11:08:59 -0800] "PASS (hidden)"
230 -

Thanks,
Jim Shewmaker

Re: [Proftpd-user] problem - proftpd 1.2.9 with gzipfs 0.9rc3

[TJ Saunders <tj@ca...>]

> but whenever I have the GzipFS line defined, it gives me the error "421
> Service not available, remote server has closed connection" as soon as
> I enter my password.

This should be fixed by mod_gzipfs-0.9rc4, just released on
 http://www.castaglia.org.

Cheers,
TJ

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   What can be said at all can be said clearly, and what we cannot talk about
   we must pass over in silence.

     -Ludwig Wittgenstein

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Re: [Proftpd-user] bug? When del a file form ftp, the file_in_used %{3} got 4294967295

[TJ Saunders <tj@ca...>]

> I fixed it. the diff as below:

This has been already corrected in CVS, where the mod_quotatab modules
have been added to the proftpd source tree.

Cheers,
TJ

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   Mankind will not be reasoned out of the feelings of humanity.

   	-Sir William Blackstone

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Re: [Proftpd-user] slow login

[TJ Saunders <tj@ca...>]

> /etc/inetd.conf contains the following line:
>
> ftp     stream  tcp     nowait  root    /usr/sbin/tcpd proftpd

OK.  In this case, it will depend on the options used when building tcpd.
It is very possible that the tcpd program is attempting a reverse DNS
resolution of the connecting client, which would add a delay.

Cheers,
TJ

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   Once more upon the waters! yet once more!
   And the waves bound beneath me as as a steed
   That knows his rider.

   	-Lord Byron

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Re: [Proftpd-user] any options to avoid count the directory when using mod_quote_tab ?

[TJ Saunders <tj@ca...>]

>    any options to avoid count the directory when using mod_quote_tab ?
>
> the files_in_used includes the directory now.

This is by design, for a directory is just another file.

TJ

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   The worst solitude is to be destitute of sincere friendship.

   	-Francis Bacon

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Re: [Proftpd-user] . files

[Michael Thompson <mike@th...>]

Hello Michael,


On Thu, 5 Feb 2004, at 14:44:07 [GMT +0000] (which was 14:44 in my
TimeZone) you wrote:




MT> Hi Proftp-user,



MT>   I know this has proboly beeen asked before, but I cant find anything
MT>   in the archives, how do I stop . (period) files from being shown in
MT>   the FTP listings?


Perhaps I should say, How do I use List directive to limit . files
using IgnoreHidden On, what commands do i need to limit, and where do
I put the Limit Block?

-- 
Best regards,
 Michael

http://www.thompsonmike.co.uk/
PGP KeyID := 0xA9547E32
  

Mohammed Saeed al-Sahaf: 
"They are not in Baghdad.
They are not in control of any airport.
I tell you this.
It is all a lie.
They lie.
It is a hollywood movie.
You do not believe them."

[Proftpd-user] . files

[Michael Thompson <mike@th...>]

Hi Proftp-user,



  I know this has proboly beeen asked before, but I cant find anything
  in the archives, how do I stop . (period) files from being shown in
  the FTP listings?


-- 

Best regards,
 Michael (mike@...)
   
Does anyone have any questions? Any answers? Anyone care for a mint? --Rita Rudner 

http://www.thompsonmike.co.uk/
PGP KeyID := 0xA9547E32

'To see a world in a grain of sand
And heaven in a wild flower
To hold infinity in the palm of your hand
And eternity in an hour'

Using TheBat! Version 2.02.3 CE
Running On Windows XP (2600, Service Pack 1)
Sent From OneAndOne

RE: [Proftpd-user] Problems compiling proftpd with mod_quota

[<maca02@at...>]

it's a part of the "libz" string. You must, know, that libz.a is the Z lib compression library. The string "-lz" is:

"-" + "l"ib + "z"

where the "z" are the remaining characters after "lib".


On Thu, 5 Feb 2004 nicolas.rueegg@... wrote:

> > > "make" produces the following error:
> > >
> > > "[...] gcc [...] -lcap -lm -lz -lmysqlclient
> > > ld: cannot find -lz"
> >
> > This is saying that the build process cannot find the zlib compression
> > library (libz.a) on your system.
>
> How do you know that "-lz" stands for the zlib compression library?
> Anyway... After I installed the zlib-devel package
> (SuSE Professional 8.2) which provides "libz.a",
> anything works fine. Thanks.
>
> > > Can I delete the parameter "-lz" in Make.rules or will I get
> > > some problems?
> > > What is "-lz" for?
> >
> > The compression library is used by the MySQL client library,
> > I believe.
> > Remove that parameter is not recommended; it is there for a reason.
>
> That's what I thought ;-)
>
> Thank you for your support and greets,
>
> Nicolas
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> ProFTPD Users List   <proftpd-users@...>
> Unsubscribe problems?
> http://www.proftpd.org/list-unsub.html
>
>
>
>
>

RE: [Proftpd-user] Problems compiling proftpd with mod_quota

[<nicolas.rueegg@ks...>]

> > "make" produces the following error:
> >
> > "[...] gcc [...] -lcap -lm -lz -lmysqlclient
> > ld: cannot find -lz"
> 
> This is saying that the build process cannot find the zlib compression
> library (libz.a) on your system.

How do you know that "-lz" stands for the zlib compression library?
Anyway... After I installed the zlib-devel package
(SuSE Professional 8.2) which provides "libz.a",
anything works fine. Thanks.

> > Can I delete the parameter "-lz" in Make.rules or will I get
> > some problems?
> > What is "-lz" for?
> 
> The compression library is used by the MySQL client library, 
> I believe.
> Remove that parameter is not recommended; it is there for a reason.

That's what I thought ;-)

Thank you for your support and greets,

Nicolas

[Proftpd-user] need help with configuration

[Dhawan, Kiran (MED, TCS) <Kiran.Dhawan@me...>]

Hello,

I have configured max clients allowed to be 5 with Proftpd for testing
purpose. I found that when I initiated the sixth active connection Proftpd
very rightly did not allow that connection. But out here I need to display a
message to the user that due to maximum limit is reached the connection
initiated is dropped. 

The message displayed is "Connection closed by remote host."

Please can you all help me with this. I am sure Proftpd will have something
for this too but cannot get in documents I have.

Thanks and Regards
Kiran L. Dhawan

Re: [Proftpd-user] slow login

[Federico Nati <federico.nati@ti...>]

/etc/inetd.conf contains the following line:

ftp     stream  tcp     nowait  root    /usr/sbin/tcpd proftpd

thanks, ciao, Federico.

On Tue, 3 Feb 2004 20:23:56 +0800 (GMT-8)
TJ Saunders <tj@...> wrote:

> 
> > It runs from inetd, not as a standalone daemon. (it is the default
> > Slackware Linux 9.1 installation)
> 
> What does your inetd/xinetd configuration for ftp look like?  It could
> be inetd/xinetd that is the cause of the delay...
> 
> TJ
> 
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~~~~~~~~~~
> 
>    The split in you is clear.  There is a part of you that knows what
>    it should do, and a part that does what it feels like doing.
> 
>    	-John Cantwell Kiley
> 
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~~~~~~~~~~
> 
> 
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> ProFTPD Users List   <proftpd-users@...>
> Unsubscribe problems?
> http://www.proftpd.org/list-unsub.html

Re: [Proftpd-user] any options to avoid count the directory when using mod_quote_tab ?

[forehead<forehead@pe...>]

hi, forehead

sorry i got it, it's silly

== forehead wrote on 2004-02-05 16:40:00

> >hi, proftp-user
>
>   any options to avoid count the directory when using mod_quote_tab ?
>
>the files_in_used includes the directory now.
>
>
> 				
>----------------------
>forehead (Chun Sheng)
>forehead@...
>2004-02-05
>
>
>
>-------------------------------------------------------
>The SF.Net email is sponsored by EclipseCon 2004
>Premiere Conference on Open Tools Development and Integration
>See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
>http://www.eclipsecon.org/osdn
>_______________________________________________
>ProFTPD Users List   <proftpd-users@...>
>Unsubscribe problems?
>http://www.proftpd.org/list-unsub.html
>



			


				 
----------------------
forehead (Chun Sheng)
forehead@...
2004-02-05

[Proftpd-user] any options to avoid count the directory when using mod_quote_tab ?

[forehead<forehead@pe...>]

hi, proftp-user

   any options to avoid count the directory when using mod_quote_tab ?

the files_in_used includes the directory now.


 				
----------------------
forehead (Chun Sheng)
forehead@...
2004-02-05

Re: [Proftpd-user] bug? When del a file form ftp, the file_in_used %{3} got 4294967295

[forehead<forehead@pe...>]

hi, forehead

I fixed it. the diff as below:

# diff mod_quotatab_sql.c.fixed mod_quotatab_sql.c
398,400c398,400
<   snprintf(tally_files_in, 20, "%d", quotatab_deltas.files_in_delta);
<   snprintf(tally_files_out, 20, "%d", quotatab_deltas.files_out_delta);
<   snprintf(tally_files_xfer, 20, "%d", quotatab_deltas.files_xfer_delta);
---
>   snprintf(tally_files_in, 20, "%u", quotatab_deltas.files_in_delta);
>   snprintf(tally_files_out, 20, "%u", quotatab_deltas.files_out_delta);
>   snprintf(tally_files_xfer, 20, "%u", quotatab_deltas.files_xfer_delta);

the quotatab_deltas.files_in_delta may have '-' , so just use %d but not %u
and now in mysql log , there is " files_in_used = files_in_used + -1 ", works well.


== forehead wrote on 2004-02-05 15:40:00

> >hi, proftp-user
>
>as subject, when I del a file from ftp interface, the %{3} return 4294967295
>which should be -1
>
>I am Under FreeBSD and enable proftpd 1.29 and proftpd-mod-quotatab-1.2.11
>
>the proftpd.conf contains:
>
>SQLNamedQuery get-quota-limit SELECT "name, quota_type, per_session, limit_type, bytes_in_avail, \
>    bytes_out_avail, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail FROM quotalimits \
>        WHERE name = '%{0}' AND quota_type = '%{1}'"
>SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used, bytes_out_used, \
>    bytes_xfer_used, files_in_used, files_out_used, files_xfer_used FROM quotatallies \
>        WHERE name = '%{0}' AND quota_type = '%{1}'"
>SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, \
>    bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, \
>        files_in_used = files_in_used + %{3}, files_out_used = files_out_used + %{4}, \
>            files_xfer_used = files_xfer_used + %{5} \
>                WHERE name = '%{6}' AND quota_type = '%{7}'" quotatallies
>SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" quotatallies
>
>
>and in the mysql log file ,i got:
>
>040205 15:40:51      22 Query       UPDATE quotatallies SET bytes_in_used = bytes_in_used + -6366.000000,     bytes_out_used = bytes_out_used + 0.000000, bytes_xfer_used = bytes_xfer_used + 0.000000,         files_in_used = files_in_used + 4294967295, files_out_used = files_out_used + 0,             files_xfer_used = files_xfer_used + 0                 WHERE name = 'bingo' AND quota_type = 'user'
>
>it showed that the file quota is wrong. any idea?
>
>
>
>
>
>
> 				
>----------------------
>forehead (Chun Sheng)
>forehead@...
>2004-02-05
>
>
>
>-------------------------------------------------------
>The SF.Net email is sponsored by EclipseCon 2004
>Premiere Conference on Open Tools Development and Integration
>See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
>http://www.eclipsecon.org/osdn
>_______________________________________________
>ProFTPD Users List   <proftpd-users@...>
>Unsubscribe problems?
>http://www.proftpd.org/list-unsub.html
>



			


				 
----------------------
forehead (Chun Sheng)
forehead@...
2004-02-05

[Proftpd-user] bug? When del a file form ftp, the file_in_used %{3} got 4294967295

[forehead<forehead@pe...>]

hi, proftp-user

as subject, when I del a file from ftp interface, the %{3} return 4294967295
which should be -1

I am Under FreeBSD and enable proftpd 1.29 and proftpd-mod-quotatab-1.2.11

the proftpd.conf contains:

SQLNamedQuery get-quota-limit SELECT "name, quota_type, per_session, limit_type, bytes_in_avail, \
    bytes_out_avail, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail FROM quotalimits \
        WHERE name = '%{0}' AND quota_type = '%{1}'"
SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used, bytes_out_used, \
    bytes_xfer_used, files_in_used, files_out_used, files_xfer_used FROM quotatallies \
        WHERE name = '%{0}' AND quota_type = '%{1}'"
SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, \
    bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, \
        files_in_used = files_in_used + %{3}, files_out_used = files_out_used + %{4}, \
            files_xfer_used = files_xfer_used + %{5} \
                WHERE name = '%{6}' AND quota_type = '%{7}'" quotatallies
SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" quotatallies


and in the mysql log file ,i got:

040205 15:40:51      22 Query       UPDATE quotatallies SET bytes_in_used = bytes_in_used + -6366.000000,     bytes_out_used = bytes_out_used + 0.000000, bytes_xfer_used = bytes_xfer_used + 0.000000,         files_in_used = files_in_used + 4294967295, files_out_used = files_out_used + 0,             files_xfer_used = files_xfer_used + 0                 WHERE name = 'bingo' AND quota_type = 'user'

it showed that the file quota is wrong. any idea?






 				
----------------------
forehead (Chun Sheng)
forehead@...
2004-02-05

Re: [Proftpd-user] ProFTPd & LDAP

[Xavier Mertens <xavier@ro...>]

Here we go:

[...]
- dispatching CMD command 'PASS (hidden)' to mod_auth
- dispatching auth request "getgroups" to module mod_auth_file
- dispatching auth request "getgroups" to module mod_auth_unix
- no supplemental groups found for user 'xldap'
- dispatching auth request "getpwnam" to module mod_auth_file
- dispatching auth request "getpwnam" to module mod_auth_unix
- no such user 'xldap'
- USER xldap: no such user found from xxx [a.b.c.d] to w.x.y.z:21
[...]

Xavier
--

On Mon, 2 Feb 2004, TJ Saunders wrote:

>
> > I'm running a ProFTPd server on a Linux box where users are
> > authentication via LDAP (using nss_ldap). Users can log on the server
> > (ex via ssh) but are not recognized by the ProFTPd!? Do I need to use
> > LDAP authentication with ProFTPd too??
>
> What does server debugging output show when users attempt to login to
> proftpd?
>
>   http://www.castaglia.org/proftpd/doc/contrib/ProFTPD-mini-HOWTO-Debugging.html
>
> Cheers,
> TJ
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>    The true science and study of man is man.
>
>    	-Pierre Charron
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> ProFTPD Users List   <proftpd-users@...>
> Unsubscribe problems?
> http://www.proftpd.org/list-unsub.html
>

Re: [Proftpd-user] need help with configuration

[TJ Saunders <tj@ca...>]

> I am new to ProFTP but I have an FTP server running...I Have created 2
> users (upload, download). I want setup these accounts in such a way that
> when they logon they default to a certain directory

You can do with the DefaultChdir directive or DefaultRoot directives:

  http://www.proftpd.org/docs/directives/linked/config_ref_DefaultChdir.html
  http://www.proftpd.org/docs/directives/linked/config_ref_DefaultRoot.html

If you use DefaultRoot, you should also read:

  http://www.castaglia.org/proftpd/doc/contrib/ProFTPD-mini-HOWTO-Chroot.html

> secondly I want to limit number of users that can logon with the same
> name

  http://www.proftpd.org/docs/directives/linked/config_ref_MaxClientsPerUser.html

> and thirdly and most important I want to limit the bandwidth they
> utilise when they upload or download.

  http://www.proftpd.org/docs/directives/linked/config_ref_TransferRate.html

Cheers,
TJ

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   To measure you by your smallest deed is to reckon the power of the ocean
   by the frailty of its foam.

     -Kahlil Gibran

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~