Re: [Proftpd-user] block user access based on mysql db column value
Cosmin Neagu via Proftp-user <[email protected]> Wed, 20 Nov 2024 13:50:19 +0000
| Newsgroups | gmane.network.proftpd.user |
|---|---|
| Message-ID | <CWLP265MB6385670EE3278CC66E2327158F212@CWLP265MB6385.GBRP265.PROD.OUTLOOK.COM> |
--===============1154817920763775254== Content-Language: en-US Content-Type: multipart/alternative; boundary="_000_CWLP265MB6385670EE3278CC66E2327158F212CWLP265MB6385GBRP_" --_000_CWLP265MB6385670EE3278CC66E2327158F212CWLP265MB6385GBRP_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable You can use something like this: SQLUserWhereClause "ACTIVE=3D1" WIll only auth users which have the ACTIVE column value set to 1. Best regards, Cosmin Neagu Network Architect ________________________________ From: Martin Opara via Proftp-user <[email protected]> Sent: Wednesday, November 20, 2024 3:26 PM To: [email protected] <[email protected]> Cc: Martin Opara <[email protected]> Subject: [Proftpd-user] block user access based on mysql db column value Hi Community, I am using proftpd in a mid volume commercial application and= was not able to find anywhere information, on how to block/lock ftp accoun= ts for users, which have a specific value in the mysql database. For exampl= e, a column called ZjQcmQRYFpfptBannerStart This Message Is From an External Sender This email originated from outside our organisation. Please do not click li= nks or open attachments unless you recognise the sender and know the conten= t is safe. ZjQcmQRYFpfptBannerEnd Hi Community, I am using proftpd in a mid volume commercial application and was not able to find anywhere information, on how to block/lock ftp accounts f= or users, which have a specific value in the mysql database. For example,= a column called "active", and a user with value "false" should not be ab= le to connect, or upload. You support would be highly appreciated. Kind regards, Martin Blaubit _______________________________________________ ProFTPD Users List <[email protected]> Unsubscribe problems? https://urldefense.com/v3/__http://www.proftpd.org/list-unsub.html__;!!KFYU= Deg!j012b_JenzxxMvW5HvIKQriewg3dU70l1uoGGe3iw4coWXKu_gY8-bEUVVQgV0YiMb1oYGO= W0yQrXEMRbRFDpodM_9pUtRU$[proftpd[.]org] --_000_CWLP265MB6385670EE3278CC66E2327158F212CWLP265MB6385GBRP_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <html> <head> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"= > <style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo= ttom:0;} </style> </head> <body dir=3D"ltr"> <div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo= nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c= olor: rgb(0, 0, 0);"> You can use something like this:</div> <div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo= nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c= olor: rgb(0, 0, 0);"> SQLUserWhereClause "ACTIVE=3D1"</div> <div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo= nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c= olor: rgb(0, 0, 0);"> <br> </div> <div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo= nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c= olor: rgb(0, 0, 0);"> WIll only auth users which have the ACTIVE column value set to 1.</div> <div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo= nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c= olor: rgb(0, 0, 0);"> <br> </div> <div id=3D"Signature" class=3D"elementToProof"> <div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, = Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"> <br> </div> <div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, = Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"> <br> </div> <p style=3D"margin-top: 0px; margin-bottom: 0px;"><span style=3D"font-famil= y: Arial, sans-serif; font-size: 9.75pt; color: black;">Best regards,</span= ></p> <p style=3D"text-align: left; margin: 0in 0in 0.0001pt;"><span style=3D"fon= t-family: Arial, sans-serif; font-size: 9.75pt; color: black;"><b>Cosmin Ne= agu</b></span></p> <p style=3D"text-align: left; margin: 0in 0in 0.0001pt;"><span style=3D"fon= t-family: Arial, sans-serif; font-size: 10pt; color: black;">Network Archit= ect</span></p> <p style=3D"text-align: left; margin: 0in 0in 0.0001pt;"><span style=3D"fon= t-family: Arial, sans-serif; font-size: 10pt; color: black;"><br> </span></p> </div> <div id=3D"appendonsend"></div> <hr style=3D"display:inline-block;width:98%" tabindex=3D"-1"> <div id=3D"divRplyFwdMsg" dir=3D"ltr"><font face=3D"Calibri, sans-serif" st= yle=3D"font-size:11pt" color=3D"#000000"><b>From:</b> Martin Opara via Prof= tp-user <[email protected]><br> <b>Sent:</b> Wednesday, November 20, 2024 3:26 PM<br> <b>To:</b> [email protected] <[email protected]= rge.net><br> <b>Cc:</b> Martin Opara <[email protected]><br> <b>Subject:</b> [Proftpd-user] block user access based on mysql db column v= alue</font> <div> </div> </div> <div> <div style=3D"display:none!important; display:none; visibility:hidden; font= -size:1px; color:#ffffff; line-height:1px; height:0px; max-height:0px; opac= ity:0; overflow:hidden"> Hi Community, I am using proftpd in a mid volume commercial application and= was not able to find anywhere information, on how to block/lock ftp accoun= ts for users, which have a specific value in the mysql database. For exampl= e, a column called</div> <div style=3D"display:none!important; display:none; visibility:hidden; font= -size:1px; color:#ffffff; line-height:1px; max-height:0px; opacity:0; overf= low:hidden"> ZjQcmQRYFpfptBannerStart</div> <div dir=3D"ltr" lang=3D"en" id=3D"x_pfptBannerygie31a" style=3D"display:bl= ock!important; text-align:left!important; margin:16px 0px 16px 0px!importan= t; padding:8px 16px 8px 16px!important; border-radius:4px!important; min-wi= dth:200px!important; background-color:#FADF9B!important; background-color:#= FADF9B; border-top:4px solid #e5bb00!important; border-top:4px solid #e5bb0= 0"> <div id=3D"x_pfptBannerygie31a" style=3D"float:left!important; display:bloc= k!important; margin:0px 0px 1px 0px!important; max-width:600px!important"> <div id=3D"x_pfptBannerygie31a" style=3D"display:block!important; visibilit= y:visible!important; background-color:#FADF9B!important; color:#000000!impo= rtant; color:#000000; font-family:'Arial',sans-serif!important; font-family= :'Arial',sans-serif; font-weight:bold!important; font-weight:bold; font-siz= e:14px!important; line-height:18px!important; line-height:18px"> This Message Is From an External Sender </div> <div id=3D"x_pfptBannerygie31a" style=3D"display:block!important; visibilit= y:visible!important; background-color:#FADF9B!important; color:#000000!impo= rtant; color:#000000; font-weight:normal; font-family:'Arial',sans-serif!im= portant; font-family:'Arial',sans-serif; font-size:12px!important; line-hei= ght:18px!important; line-height:18px; margin-top:2px!important"> This email originated from outside our organisation. Please do not click li= nks or open attachments unless you recognise the sender and know the conten= t is safe. </div> </div> <div style=3D"clear:both!important; display:block!important; visibility:hid= den!important; line-height:0!important; font-size:0.01px!important; height:= 0px"> </div> </div> <div style=3D"display:none!important; display:none; visibility:hidden; font= -size:1px; color:#ffffff; line-height:1px; max-height:0px; opacity:0; overf= low:hidden"> ZjQcmQRYFpfptBannerEnd</div> <style> <!-- #x_pfptBannerygie31a {display:block!important; visibility:visible!important; opacity:1!important; background-color:#FADF9B!important; max-width:none!important; max-height:none!important} --> </style> <pre style=3D"font-family:sans-serif; font-size:100%; white-space:pre-wrap;= word-wrap:break-word">Hi Community, I am using proftpd in a mid volume commercial application and was not able to find anywhere information, on how to block/lock ftp accounts f= or users, which have a specific value in the mysql database. For example,= a column called "active", and a user with value "false&qu= ot; should not be able to connect, or upload. You support would be highly appreciated. Kind regards, Martin Blaubit _______________________________________________ ProFTPD Users List <[email protected]> Unsubscribe problems? <a href=3D"https://urldefense.com/v3/__http://www.proftpd.org/list-unsub.ht= ml__;!!KFYUDeg!j012b_JenzxxMvW5HvIKQriewg3dU70l1uoGGe3iw4coWXKu_gY8-bEUVVQg= V0YiMb1oYGOW0yQrXEMRbRFDpodM_9pUtRU$">https://urldefense.com/v3/__http://ww= w.proftpd.org/list-unsub.html__;!!KFYUDeg!j012b_JenzxxMvW5HvIKQriewg3dU70l1= uoGGe3iw4coWXKu_gY8-bEUVVQgV0YiMb1oYGOW0yQrXEMRbRFDpodM_9pUtRU$</a>[proftpd= [.]org] </pre> </div> </body> </html> --_000_CWLP265MB6385670EE3278CC66E2327158F212CWLP265MB6385GBRP_-- --===============1154817920763775254== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline --===============1154817920763775254== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ ProFTPD Users List <[email protected]> Unsubscribe problems? http://www.proftpd.org/list-unsub.html --===============1154817920763775254==--