PyCharm

Hi, Here is a brief guide to setup PyCharm to send its traffic generated by requests through Fiddler.

Usage: If you get errors while implementing an extracted protocol from a Fiddler traces, you can forward the traffic to Fiddler, so that you can check the captured traces against the traffic generated from PyCharm to debug your code. For example, you can solve issues when receiving Code 422 in response.

Running PyCharm Traffic through Fiddler

First, you need to update proxy settings at PyCharm with Fiddler proxy details. This will ask to install Fiddler generated certificates at PyCharm. However, this step only allows PyCharm to direct it’s traffic to Fiddler, but your python code fails since this setting does not apply to urllib3 used by requests. Hence, we have to bypass certificate verification in the code.

Step 1: Add Fiddler Generated Certificates to PyCharm

At PyCharm IDE Goto -> File -> Settings ->Appearance & Behaviour -> System Settings -> HTTP Proxy -> Provide Fiddler proxy settings as follows (Host: 127.0.0.1, Port: 8888)

update proxy settings

Restart PyCharm -> It will prompt to Accept the Fiddler generated certificates for JetBrains.

Screenshot 2020-04-06 19.32.00

You can check the saved certificates at File -> Settings ->Tools-> Server Certificates

Step2: Update Python Code

In the python code, I’m using requests package to send HTTPS requests. Update the request with an additional argument as verify=False. Otherwise, it will throw an verification failed exception (ssl.SSLError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:646))

import requests

initResponse = requests.get(initURL, params=initParams, headers=headerInit,verify=False)

Now, it will only give a warning (InsecureRequestWarning: Unverified HTTPS request is being made to host ‘127.0.0.1’. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings
InsecureRequestWarning,) and pass the code. Assuming you are aware of the security of the URL you are visiting, this can help you forward PyCharm traffic through Fiddler without much hassle.

Cheers ! 🙂

Use MongoDB on Kali Linux with PyCharm

Posted by Kulani Mahadewa on February 5, 2020

Posted in: Kali Linux, Linux. Tagged: Kali, kali lin, mongo, mongod, mongoDB, PyCharm, pymongo. Leave a comment

Hi, In this post I will detail how I installed and used MongoDB on Kali Linux, including how I resolved the issues came across.

Step 1: Install mongodb on Kali Linux

Use the following command to install mongodb (refer: source)

sudo apt-get install mongodb

Alternatively, you can remove existing installations with the following command before executing the above install command.

sudo apt-get purge mongo*

Run the mongodb server

I tried the following two commands based on the existing tutorials, however with errors.

#1 mongod

Error: error0

#2 sudo systemctl start mongod

Error:

erro1

Solution:

create /data/db directory

sudo mkdir -p /data/db

sudo chmod g+w /data/db

mongod

server run 2

Step 2: Set up PyCharm

Install pymongo using the PyCharm interpreter. (File -> Settings -> Under ‘Project’ find the ‘Project Interpreter’)

Step 3: Create a mongodb database

Open a new terminal and use command

mongo

Following that you can use an existing tutorial : https://www.tutorialspoint.com/mongodb/mongodb_create_collection.htm on creating and managing mongoDBs as follows.

create db

Step 4: Use the created mongoDB on PyCharm

import pymongo

uri = 'mongodb://127.0.0.1:27017'
client = pymongo.MongoClient(uri)
db = client['actionmonitor']
collection = db['pagedefaults']

Cheers ! 🙂

Use MySQL Database with Pycharm Community Edition on Kali Linux

Posted by Kulani Mahadewa on June 2, 2019

Posted in: Kali Linux, Linux. Tagged: 2019.1.2, community edition, Kali, Kali Linux, MySQL, PyCharm. Leave a comment

Hi! Here I provide a brief guide to enable using mysql database on PyCharm 2019.1.2 (community edition).

Step 1. Create mysql database.

Kali linux comes with mysql pre-installed.

Start mysql server.

Open terminal and type,

 :~# service mysql start
 :~# mysql -u root -p  // provide password when prompt

Give privilege to ‘user’@localhost.

MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO '<username>'@'localhost' IDENTIFIED BY '<password>';

Step 2. Install DB Navigator on PyCharm IDE.

Select project -> File –> Settings –> Plugins
Search “DB Navigator”
Install package

Step 3. Connect the mysql database with PyCharm.

Press “+” on “DB Browser” –> select ‘MySQL’
In DB Navigator settings, select “+” again in “Connection” tab.
Fill the form with required information.
- For authentication: select “user/password”, and provide the ‘<username>’ and ‘<password>’ provided during grant privilege above.