vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Administrative and Maintenance Tools - Password Security Tools (https://vborg.vbsupport.ru/showthread.php?t=187980)

John 08-12-2008 10:00 PM

Password Security Tools
 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Password Security Tools
For vBulletin 3.7.0 and above
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Description
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A product designed to combat the recent increase in weak password attacks by spammers.

For background information, read the following threads:
http://www.vbulletin.com/forum/showthread.php?t=278975
http://www.vbulletin.com/forum/showthread.php?t=281371

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
The Problem
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
The problem stems from the fact that vBulletin doesn't check the quality of a user's password when registering or changing the password in the User CP. As a result, users are able to choose easily guessable passwords to protect their account. The most common passwords are things like "password", "12345", "qwerty", "letmein", as well as the user's own username. On a large forum, these poorly protected accounts can number hundreds or even thousands, and this has shown itself to be a prime opportunity for spammers to exploit. With a relatively simple script, spammers are able to scrape the member list from your forum and automatically validate which of the accounts have such passwords. A spammer with access to tens, hundreds or thousands of legitimate user accounts is a situation you don't want to be in.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
What This Does
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
This product has two main functions.
1. It prevents users from using their own username as a password, or any other commonly used word. (An editable list of banned passwords is available in the Admin CP.) The same rules apply if a user tries to change their password after registration.
2. It provides you with a tool to identify existing user accounts that have bad passwords, and lets you reset those passwords. Emails will be automatically dispatched to affected users notifying them of the change, and providing instructions on how to gain access to their account.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Installation
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
To install:
1. Upload cpnav_passrepair.xml to includes/xml/
2. Upload passsec.php to admincp/
3. Upload product-passrepair.xml to your Admin CP as a product
4. Enable the product in vBulletin Options

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Password Scanner - Usage Notes
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
The password scanning portion of this product is a utility designed for use by administrators. There are a few things to be aware of.
1. BACK UP YOUR DATA BEFORE USING THIS SCRIPT.
2. It's not a tool designed for frequent usage, it's a quick and dirty way of getting the job done. If Jelsoft don't address this issue, I might return to it and optimize the password scanner to make it a little less server intensive. Use it sparingly, and close your forums before commencing a scan.
3. The password scanner has the potential to send out a lot of email. Use the "Users Per Page" setting to process accounts at whatever rate you deem your server capable of handling.
4. After you've installed this product it'll be impossible for users to register using a blacklisted or invalid password (or to change it to one afterwards). As a result, you should only need to use the password scanner once. Feel free to remove the passsec.php and cpnav_passrepair.xml files from your server once you're done with the scanner, the rest of the product will still function.
5. For unattended bulk processing of accounts, there's some javascript in passsec.php that's currently commented out. Use it at your own risk.

glorify 08-13-2008 03:06 AM

Weeeeee. Installing now John :)

GaiLoan 08-13-2008 03:24 AM

wow sound kool, thanks let me try

sinucello 08-13-2008 04:18 AM

Hi,

thanks a lot for sharing this. Should have already been released by Jelsoft IMHO, but this has been discussed in the threads you mentioned. Great job anyway.

all the best,
Sacha

RedTrinity 08-13-2008 06:25 AM

I just got the following error after running the script to update bad passwords, it happened as soon as it tried to attend to the first member in the list:

Quote:

Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE user SET password='19c024c9537eca5a91fca3606caa7796' WHERE userid=81;

MySQL Error : Table 'xxxx_forums.user' doesn't exist
Error Number : 1146
Request Date : Wednesday, August 13th 2008 @ 05:21:56 PM
Error Date : Wednesday, August 13th 2008 @ 05:21:56 PM
Script : http://www.theparentingsanctuary.com...?do=dopassscan
Referrer : http://www.theparentingsanctuary.com...reparepassscan
IP Address : xxxx
Username : xxxx
Classname : vB_Database
MySQL Version : 5.0.48
:confused::confused::confused:

digicom 08-13-2008 06:56 AM

Installed Thankyou :up:

wacnstac 08-13-2008 10:26 AM

Thank you, thank you, thank you! Too bad you had to do Jelsoft's job for them. They'll probably be using this hack too, or they should be.

John 08-13-2008 12:02 PM

Quote:

Originally Posted by GamerGirl27 (Post 1597539)
I just got the following error after running the script to update bad passwords, it happened as soon as it tried to attend to the first member in the list:
:confused::confused::confused:

Ah, missed a table prefix. Download the zip again, and overwrite passsec.php.

MGSteve 08-13-2008 01:08 PM

Is there any reason this won't work on 3.6.0? I haven't upgraded my forum in a while (haven't got the time to redo all the plugins I've done again)!

John 08-13-2008 01:17 PM

Quote:

Originally Posted by MGSteve (Post 1597750)
Is there any reason this won't work on 3.6.0? I haven't upgraded my forum in a while (haven't got the time to redo all the plugins I've done again)!

Try it on a test installation first. (You might have to edit the product XML file to remove the 3.7.0 vBulletin version dependency.) There's a good chance it'll work, although I haven't tested.

MGSteve 08-13-2008 01:20 PM

Thanks for the quick reply, I'll give it a try!

You've got my vote for Mod Of The Month too....

John 08-13-2008 02:56 PM

Let me know how it goes, if it doesn't work I'll upload a 3.6.x version for you.

Elenna 08-13-2008 03:16 PM

Thanks very much for this! Thankfully I only had one user with an insecure password, but I'm sure there are more where that came from.

Hostboard 08-13-2008 03:35 PM

Is there anyway this can be integrated with the Ajax registration modification???
https://vborg.vbsupport.ru/showthread.php?t=182005

Would be a great merger of 2 modifications that complement each other :)

RvG2 08-13-2008 04:02 PM

Quote:

Originally Posted by Hostboard (Post 1597854)
Is there anyway this can be integrated with the Ajax registration modification???
https://vborg.vbsupport.ru/showthread.php?t=182005

Would be a great merger of 2 modifications that complement each other :)

i agree with you :)

hcmagix 08-13-2008 04:47 PM

Quote:

Originally Posted by RvG2 (Post 1597871)
i agree with you :)


dito

John 08-13-2008 04:48 PM

Quote:

Originally Posted by Hostboard (Post 1597854)
Is there anyway this can be integrated with the Ajax registration modification???
https://vborg.vbsupport.ru/showthread.php?t=182005

Would be a great merger of 2 modifications that complement each other :)

Both are compatible, although if you use a common password it won't report it as invalid in the AJAX mod. (That'd be up to the other of the other mod to include, if he wanted to do that.)

John 08-13-2008 06:33 PM

Updated to 1.3.2, lets you choose usergroups to omit from the scan. (E.g. banned users.)

Joe Siegler 08-13-2008 06:46 PM

w00tage on banned people.

b00k 08-13-2008 07:33 PM

-----------

nightbloom 08-13-2008 07:52 PM

So I used it and it just reloaded and said process complete. Does that mean that it didnt find a single bad password? You should probably have something that says it worked and found nothing if that is indeed what happened.

Because we hide links from users, Im surprised that not a single person would have made a "junk" account just to DL something.... so Im wondering if maybe Ive made some kind of mistake or have an incompatibility.

b00k 08-13-2008 08:06 PM

-----------

Elenna 08-14-2008 12:55 AM

It would also be wonderful to see a listing of people before they are emailed, so that you can notify them personally if they are a moderator, etc, and you'd want them to change their password before you implement the security measures.

Also, one of our moderators has two accounts with the same email address. I don't have specifics yet, but he is reporting problems with changing his second account's password.

John 08-14-2008 01:52 AM

Quote:

Originally Posted by Elenna (Post 1598127)
It would also be wonderful to see a listing of people before they are emailed, so that you can notify them personally if they are a moderator, etc, and you'd want them to change their password before you implement the security measures.

Also, one of our moderators has two accounts with the same email address. I don't have specifics yet, but he is reporting problems with changing his second account's password.

If you have 1.3.2 installed you can use the Ignore Usergroup setting to bypass usergroups from the scan. I'd recommend adding your mod usergroup ids, and perhaps posting a thread in your mod forum telling everyone to make sure their passwords are hard to guess.

As for users with duplicate email addresses, the only way to handle that is on a case by case basis.

Hornstar 08-14-2008 06:16 AM

fantastic work! I will give this a go in a sec. I too would love to see this merged with the ajax registration mod (but guess he will have to add to his). I will install this one now to send out the emails tho.

Edit: Just realized this was released by John ^^ great to see you back :D

Hornstar 08-14-2008 06:33 AM

uploaded files. installed product, set it up in vboptions. then went to admincp/passsec.php page and just got a blue blank page with Password Security Tools written at the top and nothing else.

How do I run the scanner?


Edit, refreshed admincp and saw the password security tools tab show up ^^



Users with usernames as passwords: 5214 Users with common passwords: 8801
WOW lol, glad I got to use this before those spammers did.



EDIT: didnt work, I got a database error

Quote:

Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE user SET password='d8081298facbac11db76c31b92ff6f25' WHERE userid=2;

MySQL Error : Table '*****_backup.user' doesn't exist
Error Number : 1146
Request Date : Thursday, August 14th 2008 @ 03:36:04 AM
Error Date : Thursday, August 14th 2008 @ 03:36:04 AM
Script : http://www.gamerzneeds.net/forums/ad...?do=dopassscan
Referrer : http://www.gamerzneeds.net/forums/ad...reparepassscan
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.45-community

RedTrinity 08-14-2008 09:59 AM

Quote:

Originally Posted by John (Post 1597705)
Ah, missed a table prefix. Download the zip again, and overwrite passsec.php.

Thanks for your support. I re-downloaded the ZIP, overwrote the old file with the new one and then re-imported the xml but am getting the same error, in the same place, as before :(

DeepXP 08-14-2008 01:23 PM

I must say you have developed one of the best plugins out there. My forum was taken over by these spammers and with the help of your plugin, I could reset all the weak usernames.

Great work and thanks again for the effort.

Regards,
Deep

Joe Siegler 08-14-2008 01:39 PM

Quote:

Originally Posted by TSR (Post 1597994)
John, great work!

I just ran this on one of my bigboards and it ran flawless.
(vBulletin 3.7.2)

One suggestion, what about a report to the admin on all the accounts affected?

That would be a neat little feature.

Thanks again!

That's shown on screen to you if you sit there and watch it.

benstafford 08-14-2008 07:53 PM

Has anyone tried this with 3.6 yet? I saw the earlier posts from MGSteve about trying to get it to work by modifying the XML file, but he didn't reply back on success or failure.

Rideharder 08-14-2008 09:28 PM

Come back soon for free soup.
Thanks!

Rideharder 08-14-2008 09:32 PM

specify your own custom banned passwords here.

So I can copy and paste!:p

Philip 08-14-2008 09:54 PM

Just wanted to say thank you for the great mod!
Our 70k users database had about 900 people using their name as password, and another 600+ using weak passwords, we were getting slammed with spam PMs today from some script exploiting users with weak passwords, this proved very useful.

Hornstar 08-15-2008 05:50 AM

awww, I think I am the only one getting the database error :/ I hope you can help me John, I really want to use this bad. your work is much appreciated!

John 08-15-2008 05:50 PM

Quote:

Originally Posted by hornstar1337 (Post 1598984)
awww, I think I am the only one getting the database error :/ I hope you can help me John, I really want to use this bad. your work is much appreciated!

Try this.

John 08-15-2008 05:53 PM

Quote:

Originally Posted by GamerGirl27 (Post 1598351)
Thanks for your support. I re-downloaded the ZIP, overwrote the old file with the new one and then re-imported the xml but am getting the same error, in the same place, as before :(

Try the attached passsec.php in the above post.

Hornstar 08-15-2008 09:25 PM

<font color="Red"> Users with usernames as passwords: 5214
Users with common passwords: 8801</font>

thanks it works now, however I should have uped it from 100 before starting lol, I now have to click on next 140 times. Didn't' take too long tho. many thanks.

nightbloom 08-16-2008 01:39 AM

Quote:

Originally Posted by TSR (Post 1598009)
as stated here:

:o thanks...

R-D 08-16-2008 03:16 PM

Installed, ran the scan, works perfectly. 84 passwords=usernames and 82 matched the common password list. Out of 3,355 members, by the way.

Thanks John!

Fungsten 08-16-2008 04:09 PM

I keep getting an in complete or corrupted download. When I extract it there is only a zero byte file. TIA.

P.S. I also had this happen with another file from another Mod. Not yours though.


All times are GMT. The time now is 08:44 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01442 seconds
  • Memory Usage 1,830KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (13)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete