http://osdir.com/ml/network.pureftpd.user/2005-11/msg00066.html



Mysql-auth per user connection limit feature: msg#00066
network.pureftpd.user

Subject:  Mysql-auth per user connection limit feature

I needed this feature, but haven't found any solution, so i implemented it,
and i saw, that some other people needs it too, so made a patch.
Here it is:
http://dblaci.hu/pure-ftpd/pure-ftpd-1.0.20-mysqlperusermax.patch

I added a comment to the feature request 993994 too.

DBLaci

p.s. i don't know if this mail is going to the right place, if not, sorry.

---------------------------------------------------------------------
To post a new message, e-mail: list@xxxxxxxxxxxx
To unsubscribe, e-mail: list-unsubscribe@xxxxxxxxxxxx
For additional commands, e-mail: list-help@xxxxxxxxxxxx



 

diff -ur pure-ftpd-1.0.20.old/pureftpd-mysql.conf pure-ftpd-1.0.20/pureftpd-mysql.conf
--- pure-ftpd-1.0.20.old/pureftpd-mysql.conf 2003-01-21 21:09:44.000000000 +0100
+++ pure-ftpd-1.0.20/pureftpd-mysql.conf 2005-11-18 12:27:34.000000000 +0100
@@ -106,6 +106,12 @@
 # MySQLGetRatioUL SELECT ULRatio FROM users WHERE User="L"
 # MySQLGetRatioDL SELECT DLRatio FROM users WHERE User="L"
 
+# Optional : concurrent session limit per user.
+# The server has to be compiled with per-user-limits support.
+# Value 0 means unlimited. (default)
+
+#MySQLGetPerUserMax SELECT PerUserMax FROM users WHERE User="L"
+
 
 # Optional : bandwidth throttling.
 # The server has to be compiled with throttling support.
diff -ur pure-ftpd-1.0.20.old/src/log_mysql.c pure-ftpd-1.0.20/src/log_mysql.c
--- pure-ftpd-1.0.20.old/src/log_mysql.c 2004-05-15 23:14:06.000000000 +0200
+++ pure-ftpd-1.0.20/src/log_mysql.c 2005-11-18 11:48:58.000000000 +0100
@@ -300,6 +300,9 @@
     const char *bandwidth_ul = NULL;   /* stored bandwidth UL */
     const char *bandwidth_dl = NULL;   /* stored bandwidth DL */
 #endif
+#ifdef PER_USER_LIMITS
+    const char *perusermax = NULL;     /* stored per user concurrent sessions */
+#endif
     char *escaped_account = NULL;
     char *escaped_ip = NULL;
     char *escaped_port = NULL;
@@ -543,6 +546,18 @@
         }
     }
 #endif
+#ifdef PER_USER_LIMITS
+    if ((perusermax = pw_mysql_getquery(id_sql_server, sqlreq_getperusermax,
+                                          escaped_account, escaped_ip,
+                                          escaped_port, escaped_peer_ip,
+                                          escaped_decimal_ip)) != NULL) {
+        const unsigned long q = (unsigned long) strtoul(perusermax, NULL, 10);
+       
+        if (q > 0UL) {
+            result->per_user_max = q;
+        }
+    }
+#endif
     result->slow_tilde_expansion = !tildexp;
     result->auth_ok =- result->auth_ok;
     bye:
@@ -572,6 +587,9 @@
     free((void *) bandwidth_ul);
     free((void *) bandwidth_dl);
 #endif   
+#ifdef PER_USER_LIMITS
+    free((void *) perusermax);
+#endif   
     free((void *) escaped_account);
     free((void *) escaped_ip);
     free((void *) escaped_port);
diff -ur pure-ftpd-1.0.20.old/src/log_mysql_p.h pure-ftpd-1.0.20/src/log_mysql_p.h
--- pure-ftpd-1.0.20.old/src/log_mysql_p.h 2004-02-29 22:49:28.000000000 +0100
+++ pure-ftpd-1.0.20/src/log_mysql_p.h 2005-11-18 11:21:18.000000000 +0100
@@ -38,6 +38,9 @@
 static char *sqlreq_getbandwidth_ul;
 static char *sqlreq_getbandwidth_dl;
 #endif
+#ifdef PER_USER_LIMITS
+static char *sqlreq_getperusermax;
+#endif
 static signed char server_down;
 
 static ConfigKeywords mysql_config_keywords[] = {
@@ -68,6 +71,9 @@
     { "MYSQLGetBandwidthUL", &sqlreq_getbandwidth_ul },
     { "MYSQLGetBandwidthDL", &sqlreq_getbandwidth_dl },
 #endif
+#ifdef PER_USER_LIMITS
+    { "MYSQLGetPerUserMax", &sqlreq_getperusermax },
+#endif
     { NULL, NULL }
 };


 

번호 제목 글쓴이 날짜 조회 수
77 [펌] OS X에서 파일 시스템 관리를 위한 디스크 유틸리티와 fsck의 사용 Administrator 2008.03.30 30532
76 [펌] 맥미니에 소요된 부품 목록 Administrator 2008.03.30 45270
75 [펌] ★ 애플 Mac mini 리뷰 & 분해기! [1] Administrator 2008.03.30 27391
74 제로보드 버그 Administrator 2008.03.30 24621
73 리얼맥 시동음 제거 [1] Administrator 2008.03.30 30836
72 [펌] 맥미니 전력 소모 (애플 자료) [2] sukhyun 2008.03.30 26839
71 [펌] Linux on the Mac Mini Administrator 2008.03.30 26388
70 [펌] 집에서 Mac으로 메일서버 운영하기 (1) [1] Administrator 2008.03.30 30566
69 [펌] Tryout Mac Mini as Fileserver Administrator 2008.03.30 34232
68 [펌] 도구 없이 wire만으로 맥미니 분해하기!! [2] sukhyun 2008.03.30 35531
67 .DMG to .ISO sukhyun 2008.04.03 23341
66 DMG resize sukhyun 2008.04.04 22151
65 man hdiutil sukhyun 2008.04.04 136956
64 [펌] 10.5: Easily change the location of your home directory sukhyun 2008.04.06 21867
63 [펌] PC에서 맥FTP서버로 접근시 한글 깨짐문제. [1] sukhyun 2008.04.06 38593
62 Cyberduck - FTP and SFTP Browser for Mac OS X file sukhyun 2008.04.06 24327
61 transmit 3 - FTP client [1] sukhyun 2008.04.06 24322
60 [펌] Tutorial: Using what's new in Leopard's Accounts and File Sharing Preferences sukhyun 2008.04.07 32756
59 [펌] FTP Only Accounts Under Mac OS X Leopard sukhyun 2008.04.07 23598
58 [펌] ftpd encoding patch sukhyun 2008.04.07 24382

사용자 로그인