[prev in list] [next in list] [prev in thread] [next in thread] 

List:       proftpd-users
Subject:    Re: [Proftpd-user] Proftpd crashes on user login (mod_quotatab_sql)
From:       "Stan Connors" <stanconn () gmail ! com>
Date:       2008-03-27 14:29:55
Message-ID: b4733beb0803270729o8b24d0eg8b8d262780e2606d () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


> What does your QuotaLog show?
QuotaLog is not renewing when proftpd falls.


>What does this query return, when you run it by hand (i.e. using the mysql
>command-line client)?
mysql> SELECT user,'user','false','hard',quota,0,0,NULL,NULL,NULL FROM ftp
WHERE user = 'stas5';
+-------+------+-------+------+----------+---+---+------+------+------+
| user  | user | false | hard | quota    | 0 | 0 | NULL | NULL | NULL |
+-------+------+-------+------+----------+---+---+------+------+------+
| stas5 | user | false | hard | 10485760 | 0 | 0 | NULL | NULL | NULL |
+-------+------+-------+------+----------+---+---+------+------+------+




Thank you for your patch - with it all works stable. And if i change query
to have zeros instead of NULL's it works too.

[Attachment #5 (text/html)]

<div>&gt; What does your QuotaLog show?</div><div>QuotaLog is not renewing when \
proftpd falls.</div><div><br>&nbsp;</div><div>&gt;What does this query return, when \
you run it by hand (i.e. using the mysql</div><div>&gt;command-line client)?</div> \
<div>mysql&gt; SELECT \
user,&#39;user&#39;,&#39;false&#39;,&#39;hard&#39;,quota,0,0,NULL,NULL,NULL FROM ftp \
WHERE user = &#39;stas5&#39;;</div><div>+-------+------+-------+------+----------+---+---+------+------+------+</div>
 <div>| user &nbsp;| user | false | hard | quota &nbsp; &nbsp;| 0 | 0 | NULL | NULL | \
NULL |</div><div>+-------+------+-------+------+----------+---+---+------+------+------+</div><div>| \
stas5 | user | false | hard | 10485760 | 0 | 0 | NULL | NULL | NULL |&nbsp;</div> \
<div>+-------+------+-------+------+----------+---+---+------+------+------+</div><div><br>&nbsp;</div><div><br>&nbsp;</div><div>Thank \
you for your patch - with it all works stable. And if i change query to have zeros \
instead of NULL&#39;s it works too.</div>



-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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