— iIT-Services

Archive
Programming

A Code of Conduct for (Open Source) Communities. According to Wikipedia, the Contributor Covenant is used in prominent projects including Linux, Ruby on Rails, Swift, Go, and JRuby. Relevant signers include Google, Apple, Microsoft, Intel, Eclipse and GitLab.

In 2016 GitHub added a feature to streamline the addition of the Contributor Covenant to an open source project and the Ruby library manager Bundler also has an option to add the Contributor Covenant to software programs that its users create: https://www.contributor-covenant.org.

Read More

The magazine computerwoche.de published a list of handy Open Source Intelligence Tools, incl.:

  • Maltego – comprehensive tool for graphical link analyses that offers real-time data mining and information gathering, as well as the representation of this information on a node-based graph, making patterns and multiple order connections between said information easily identifiable
  • Recon-ng – gathering tool aimed at reducing the time spent harvesting information from open sources
  • theHarvester – emails, subdomains and names Harvester
  • Shodan – world’s first search engine for Internet-connected devices
  • Metagoofil – metadata harvester
  • searchcode – search 75 billion lines of code from 40 million projects
  • SpiderFoot – automates OSINT so one can find what matters, faster
  • Babel X – discover and decipher geographically diverse, multilingual data into actionable insights in real time, babel street’s platform helps interpret real-time data, so one can make clear, decisive decisions that impact any mission
  • Mitaka – browser extension for OSINT search
  • BuiltWith – search tech stack of specific websites
  • Wappalyzer – find the technology stack of any website
  • DarkSearch.io – self-declared “first real” “dark web” “search engine” (yet, no longer publicly available)
  • Grep.app – tool for searches across git repos

The list seems compiled from pcwdld.com, where more detailed descriptions of each tool can be found.

Furthermore, the OSINT Framework helps gathering information from free tools or resources by providing a very good overview of available applications, platforms, methods etc.

Read More

Zapier is an online automation tool that connects your favorite apps, such as Gmail, Slack, Mailchimp, and more. You can connect two or more apps to automate repetitive tasks without coding or relying on developers to build the integration. It’s easy enough that anyone can build their own app workflows with just a few clicks.

For example, maybe you get a lot of email attachments in your Gmail account and you want to save them to Dropbox. Every time you get an attachment, you could open up the email, click the attachment, and then save it to Dropbox. Or you can have Zapier automate this for you, saving you time and effort: zapier.com.

Read More

Useful websites (collection by Labnol) on the Internet to increase productivity and help learn new skills. These useful websites solve at least one problem really well. And they all have cool URLs that are easy to memorize thus saving you a trip to Google: https://www.labnol.org/internet/101-useful-websites/18078/.

Read More

An open source and collaborative framework for extracting the data you need from websites. In a fast, simple, yet extensible way.

This free, open source tool uses web crawlers to extract information from websites. Using this tool does require some advanced skills, and coding knowledge. However, if you are willing to work your way past the learning curve, Scrapy is ideal for large web extraction projects. Because it is an open source tool, there is a lot of good community support available to users: https://scrapy.org/.

Read More

Protecting MS Excel Worksheets with passwords can be user-friendly. No one fiddles with the configuration. Yet, if you need to administer the sheets, lost passwords are a pain. So, in case you need to unprotect a sheet – and obviously only if you have the right to do so! – the following VBA code snippet can help:

Sub LittleMagicPasswordBreaker()
    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer
    
    On Error Resume Next
    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
    
    ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) _
        & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
        Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    If ActiveSheet.ProtectContents = False Then
        MsgBox "One usable password is " & Chr(i) & Chr(j) & _
            Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
            Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
        Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
End Sub

 
Just open the VBA editor ([Alt]+[F11]), copy the snippet into a new VBA Module of the Excel worksheet, and execute (Run or [F5]).

Credits to: https://www.iseepassword.com/crack-ms-excel-password.html#part1

Read More

A secure solution for file and email encryption. Gpg4win (GNU Privacy Guard for Windows) is Free Software and assists in sending emails via Outlook etc. using PGP: gpg4win.de.

Read More