ESXi Reverse Proxy

In a local network, you will need two computers to do this. One will be used as a proxy server, the other as a client. Then you need to activate the proxy on the server. And on the client PC - choose to access the Internet via a local network connection (i.e. from the server). Another option is to use a web server like Nginx.

It depends on how you plan to log in to Facebook. For example, if on a PC, just specify the proxy server settings in the connection properties or in the browser settings. If on a mobile (site or application), you need to specify the proxy data in the settings of the phone itself. Or you can install an application that allows you to automatically set up a VPN connection.

If you're encountering issues with parsing escaped backslashes in JSON, it's important to understand how JSON handles escape characters. In JSON, a backslash (\) is an escape character, and certain characters must be escaped to represent them in strings.

If you're working with a string that includes escaped backslashes and you want to properly parse it, make sure the JSON string itself is correctly formatted. Below is a general guide on how to handle escaped backslashes in JSON parsing:

1. Correct JSON Format:

Ensure that the JSON string is correctly formatted, and the backslashes are properly escaped. For example:

{
  "path": "C:\\Program Files\\Example"
}

In this example, the backslashes in the path are escaped with an additional backslash.

2. JSON Unmarshalling in Go:

If you're working with JSON parsing in Go (Golang), use the encoding/json package to unmarshal the JSON data into a Go struct.

Example:

package main

import (
	"encoding/json"
	"fmt"
)

type MyStruct struct {
	Path string `json:"path"`
}

func main() {
	jsonData := `{"path": "C:\\Program Files\\Example"}`

	var myStruct MyStruct
	err := json.Unmarshal([]byte(jsonData), &myStruct)
	if err != nil {
		fmt.Println("Error:", err)
		return
	}

	fmt.Println("Path:", myStruct.Path)
}

In this example, the backslashes in the JSON string are properly escaped, and the json.Unmarshal function is used to parse the JSON into a Go struct.

3. Manual Handling:

If you're working with JSON data in another language or context, make sure your JSON parser correctly handles escape characters. Some JSON parsers automatically handle escape characters, while others may require manual handling.

To save cookies in SQLite3 using Selenium, you'll need to follow these steps:

1. Install the required packages: Make sure you have Selenium and SQLite3 installed. You can install SQLite3 using pip:

pip install sqlite3

2. Connect to the SQLite3 database: Before saving cookies to SQLite3, you need to establish a connection to the database.

import sqlite3

# Connect to the SQLite3 database (or create it if it doesn't exist)
conn = sqlite3.connect("cookies.db")
cursor = conn.cursor()

# Create the cookies table if it doesn't exist
cursor.execute("""
CREATE TABLE IF NOT EXISTS cookies (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    value TEXT NOT NULL,
    domain TEXT NOT NULL,
    path TEXT NOT NULL,
    expiry TEXT NOT NULL
)
""")

# Commit the changes and close the connection
conn.commit()
conn.close()

3. Save cookies to SQLite3 using Selenium: In your Selenium code, you can save cookies to the SQLite3 database by iterating through the cookies in the browser and inserting them into the database.

from selenium import webdriver
from selenium.webdriver.chrome.options import Options
import sqlite3

# Set the path to the ChromeDriver executable
chrome_driver_path = "path/to/chromedriver"

# Set the preference to save downloaded files with a specific name pattern
options = Options()
options.add_argument("download.default_directory='path/to/download/folder'")
options.add_argument(f"download.download_path='path/to/download/folder'")
options.add_preference("download.filename_template", "%f - %r")

# Initialize the Chrome WebDriver with the specified options
driver = webdriver.Chrome(executable_path=chrome_driver_path, options=options)

# Your Selenium code goes here

# Connect to the SQLite3 database
conn = sqlite3.connect("cookies.db")
cursor = conn.cursor()

# Get all cookies from the browser
cookies = driver.get_cookies()

# Insert cookies into the SQLite3 database
for cookie in cookies:
    cursor.execute("""
    INSERT INTO cookies (name, value, domain, path, expiry)
    VALUES (?, ?, ?, ?, ?)
    """, (cookie['name'], cookie['value'], cookie['domain'], cookie['path'], cookie['expiry']))

# Commit the changes and close the connection
conn.commit()
conn.close()

# Your code to save the cookies to SQLite3

# Close the browser
driver.quit()

Replace path/to/chromedriver, path/to/download/folder, and %f - %r with the appropriate values for your setup.

This example saves the cookies from the browser to the SQLite3 database. You can modify the code to load cookies from the database and set them in the browser as needed.

In the settings bar (home screen), select "Network Settings" and then click on Ethernet. Here you should select the "Advanced Settings" option, which contains the "Proxy Server Settings" item. To further configure the proxy, select "Configure Manually", type in the proxy hostname and specify the port. Do not forget to list the domains that the proxy server should not use. You should leave this field empty if it does not exist. If the configuration process is successful, you will see the "Settings saved" notification.