Penetration test – SQLMap: How do I create a local .sqlite copy of the vulnerable database?

I was playing around with sqlmap and found that a hidden folder with the name is created:

/%mycomputer%/.sqlmap/output

Inside, a folder is also created for each SQL injection test:

www.example.1
www.example.2

My question is as follows:
Can I save the entire database in the session.sqlite file?
If so, how? What is the command to place all of the information gathered in the "session"?

Public key infrastructure – CA certificate and local certificate

There is something that bothers me when I think of the CA certificate and the local certificate.

Below are my questions related to juniper, but which can also be general.

1) "Request security pki ca certificate register ca profile ROOT2" The above is used to get the CA certificate from the CA server if I am not mistaken. And the same (certificate) is used to confirm that it is actually a trusted CA server. But what does the certificate actually contain? How does the device know that it is the intended CA server?

Enter the image description here

The diagram above shows how the recipient receives the certificate and decrypts it using the public key of the certification authority. But how does the recipient know about the public key and the hash algorithm?

-> Is this negotiated separately before it all happens?

-> And does that happen in plain text?

-> And is it also a one-off thing, since the CA certificate is loaded onto the router and is used only once to authenticate the CA server or is used again during any period of traffic flow between the IPSec peers?

2) "Security request pki local certificate register certificate ID"

In the above step, the VPN peer requests a local certificate.

-> Is the CA server informed about the peer's public key during this step or is it exchanged early?

-> And does the above diagram also apply to the local certificate? In this case, the certificate contains the peer's public key and other information such as subject, etc. Does it have a hash to create a "fingerprint / digest" and re-encrypt it with its private key?

-> And if the above process is correct, do the peers recheck the integrity and authenticity of the local certificate by decrypting with the public key of the certification authority and then only sending it to the other peer? If not, does it send the received local certificate directly to the peer?

I couldn't get the answers to the questions asked above.

Please help me understand the same. Thanks in advance.

Network – How to forward connections to a remote computer to a port on my local computer

We have existing SQL connection strings like "tcp: aws.server.address, 1433".

We can no longer connect directly to aws.server.address and have to go through a jump server instead.

What do I need to do in Windows to ensure that traffic directed to aws.server.address on port 1433 is actually routed through the local port (i.e., 5001) that was established through an SSH tunnel like this without to change the connection string:

ssh -L 5001: aws.serveraddress: 1433 jump-host@mycompany.com

I thought I could only use netsh interface portproxy with a list address, Listenport equal aws.server.address, 1433 with a connection address, Connectport of 127.0.0.1.5001, but that doesn't seem to work. It doesn't "wait" for connections targeting the remote server and doesn't "connect" them to the local port I specified.

I also tried not to open a command session with the -N option for the ssh command. Maybe I have to do some tricks with routing tables or IP tables?

The whole goal here is to redirect traffic targeting aws.server.address, 1433 through this tunnel so I don't have to change all the connection strings to a local address and port. There has to be a way to do it.

Browser – Install an SSL certificate to deploy a local web application?

I need to install a local SSL certificate so that the browser trusts it. This tutorial contains instructions for OS X and Windows, but not for Ubuntu.

https://medium.com/@rubenvermeulen/running-angular-cli-over-https-with-a-trusted-certificate-4a0d5f92747a

For example, here are the instructions for OS X:

Double-click the certificate (server.crt)
Choose your keychain (login should be enough)
Add the certificate
Open the keychain access if it is not already open
Select the keychain you selected earlier
You should see the localhost certificate
Double-click the certificate
Build trust
Select the Always trust option when using this certificate
Close the certificate window
The certificate is now installed.

What would be the equivalent for Ubuntu?

Install HTTPS / SSL on Apache2.4 on Windows for the local domain

I followed this link https://shellcreeper.com/how-to-create-valid-ssl-in-localhost-for-xampp/ to install https / ssl / tls on Windows for local internal files on Apache2.4 Domain.

For some reason, Firefox and Chrome are not opening my local domain https: // Developerver

Firefox reports errors:
secure connection failed
An error occurred while connecting to the Developer Server. PR_CONNECT_ABORTED_ERROR
The page you are trying to view cannot be displayed because the authenticity of the received data could not be verified.

Chrome reports errors:
This website cannot be reached. The website at https: // Developserver / may be temporarily unavailable or has been permanently moved to a new web address.
ERR_CONNECTION_ABORTED

Port 80, therefore http: // developer server works fine.
I checked if port 443 is open on the server.

Can someone please help how to create a working (intranet) solution with https?

Best wishes,
Aviv

yii – how to upload a file using PHP from the server to the local computer

Simply save to a file share or upload it to an FTP site on your computer.

The reason for this problem is probably that a "local computer" does not normally have a public static IP address or does not run any software that accepts incoming connections.

It's probably easier when your local computer goes to the site and downloads the necessary files.

Plugins – does a WordPress project work on another local host?

Hello, I'm starting with WordPress and need help.
I am developing a project with localhost in xamp. My computer works as a server and my website is only available on it. I understand that
Now if I access the repository while creating a repository on Github and save my project there from another computer with xamp that works as a server, does the site work normally?
For example, would you have a problem with plugins or sending email through localhost?

The home server can only be accessed via the local IP

I set up my home server with Centos 7 and I usually use the Virtualmin control panel to control the server. I am currently testing my server with the Vesta panel. I am not a programmer, but I have few problems and cannot find a solution for it anywhere,
My server is running and my test website only works with my local static IP. If I enter my local static IP, I can access my website, but if I enter my website domain, I cannot access it! I don't know if my server should use my public static IP address (I have one) and how to refer to my domain name. I have already set up a name server in my domain registration company and forwarded the port for the local static IP address my website is working on and there is already a record for the public static IP … please advice