portproxy | A TCP port proxy to record MySQL sql query | Proxy library

by arstercz Go Version: v0.1.0 License: No License

X-Ray Key Features Code Snippets(3)Community Discussions(9)Vulnerabilities Install Support

kandi X-RAY | portproxy Summary

portproxy is a Go library typically used in Networking, Proxy, Docker applications. portproxy has no bugs, it has no vulnerabilities and it has low support. You can download it from GitHub.

A TCP port proxy utility inspired by qtunnel(note: portproxy does not suport ssl mode(mysql 5.7/8.0 client), only used in test environments.

Support

Quality

Security

License

Reuse

Support

portproxy has a low active ecosystem.

It has 53 star(s) with 17 fork(s). There are 4 watchers for this library.

It had no major release in the last 12 months.

There are 0 open issues and 3 have been closed. There are no pull requests.

It has a neutral sentiment in the developer community.

The latest version of portproxy is v0.1.0

Quality

portproxy has no bugs reported.

Security

portproxy has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

License

portproxy does not have a standard license declared.

Check the repository for any license declaration and review the terms closely.

Without a license, all rights are reserved, and you cannot use the library in your applications.

Reuse

portproxy releases are available to install and integrate.

Installation instructions are not available. Examples and code snippets are available.

Top functions reviewed by kandi - BETA

kandi has reviewed portproxy and discovered the below as its top functions. This is intended to give you an instant insight into portproxy implemented functionality, and help decide if they suit your requirements.

proxyLog reads log from src to dst .
sql_escape is used to escape sequences .
main is the main entry point
New returns a new Proxy
Wait for SIGINT
Inserts a query log into the query_log .
NewRecycler returns a new recycler .
Get the backend dsn
get config file
dbh opens a connection to the database .

Get all kandi verified functions for this library.

portproxy Key Features

No Key Features are available at this moment for portproxy.

portproxy Examples and Code Snippets

portproxy,Usage

Lines of Code : 29

License : No License

Copy

Usage of ./portproxy:
  -backend string
        backend server ip and port (default "127.0.0.1:8003")
  -bind string
        locate ip and port (default ":8002")
  -buffer uint
        buffer size (default 4096)
  -conf string
        config file to

portproxy,changelog:

Lines of Code : 2

License : No License

Copy

20200423: skip error when does not set conf option
20170112: log mysql query

portproxy,How to Install

Lines of Code : 1

License : No License

Copy

go get github.com/arstercz/portproxy

Community Discussions

Trending Discussions on portproxy

Communictaion in local area network(LAN) problem about ROS on WSL2

Inserting variables as command options in Powershell scripts?

How do I use port forwarding to connect to an Oracle database using netsh?

Can I create a batch program that extracts only one of several IP?

Port forwarding not working for Nodejs application

How can Android Emulator reach server on local network?

Return Value from External PHP Class for Use in If Condition

Connect to server through proxy

Exposing a port externally in Azure Compute Emulator

QUESTION

Communictaion in local area network(LAN) problem about ROS on WSL2

Asked 2020-Dec-13 at 16:17

I am a developer of ROS projects. Recently I am trying using ROS(melodic) on WSL2(Windows Subsystem for Linux), and all things works just great. But I got some trouble when I want to use another PC which also in the same local area network(LAN) to communicate with. Before setting the environment variables like "ROS_MASTER_URI, ROS_IP", I know that since WSL 2 work on Hyper-V so the IP show on WSL2 is not the one in the real LAN. I have to do some command like below in order to make everyone in LAN communicate with the specific host:PORT on WSL2.

...

ANSWER

Answered 2020-Dec-13 at 16:17

The root problem is described in WSL issue #4150. To quote from that thread,

WSL 2 seems to NAT it's virtual network, instead of making it bridged to the host NIC.

Option 1 - Port forwarding script on login

There are a number of workarounds described in that issue, for which you've already figured out the first part (the port forwarding). The primary technique seems to be to create a PowerShell script to detect the IP address and create the port forwarding rules that runs upon Windows login. This particular comment near the top of the thread seems to be the canonical go-to answer, although many people have posted their tweaks or alternatives throughout the very long thread.

One downside - I believe the script that is mentioned there needs to be run at logon since the WSL subsystem seems to only want to run when a user is logged in. I've found that attempting to run a WSL service or instance through Windows OpenSSH results in that instance/service shutting down soon after the SSH session is closed, unless the user is already logged into Windows with a WSL instance opened.

Option 2 - WSL1

I would also propose that, assuming it fits your workflow and if the ROS works on it (it may not, given the device access you need, but not sure), you can simply use WSL1 instead of WSL2 to avoid this. You can try this out by:

Backing up your existing distro (from PowerShell or cmd, use wsl --export
Import the backup into a new WSL1 instance with wsl --import --version 1

It's possible to simply change versions in place, but I tend to like to have a backup anyway before doing it, and as long as you are backing up, you may as well leave the original in place.

Source https://stackoverflow.com/questions/65275743

QUESTION

Inserting variables as command options in Powershell scripts?

Asked 2020-Nov-07 at 13:22

Newb here, powershell experience is a solid 1 hour but I can't seem to find the answer to this anywhere so I'm starting to think it may not be the problem. I am attempting to create a script to allow me to connect to my ubuntu machine. The ip address changes with each reboot, so I created a bash script that outputs the ip address into ip.txt and im sure that is working well (no extra spaces or undesired characters).

I have created a variable that gives me the string from the file, and although the script runs successfully, the connection doesnt work. if I execute the command and manually enter the ip, it works.

...

ANSWER

Answered 2020-Nov-07 at 13:22

As suggested in the comment information, the IP Address in the ip.txt is probably preceded and/or succeeded by one or more new line (Cr/Lf) characters.

If you use the -Raw parameter, Get-content will return all the lines including newline characters as a single string ([String]). At the other hand, if you do not include the -Raw, Get-content will return all the lines as separate strings ([String[]]), which might cause an issue in your case as well.

To remove all possible white-space characters arround the IP Address, you might use the Trim() method which removes all leading and trailing white-space characters from the current string by default:

Source https://stackoverflow.com/questions/64725890

QUESTION

How do I use port forwarding to connect to an Oracle database using netsh?

Asked 2020-Apr-01 at 00:47

I have a machine(A) that has access to the host running the Oracle listener. I can connect to it fine using SQL Developer.

I have another machine(B) that I would also like to make a connection to the same database but its doesn't have direct access to the host running the listener. However, it does have access to machine (A).

I would like to forward a port on machine A to the Oracle listener host which is listening on port 1521.

Then I should be able to make a database connection from machine B to machine A and then forward a port to the host that has the Oracle listener. Sort of a man in the middle.

However, I'm running into issues. I can't even connect to the Oracle database from machine B using the forwarded port. I have experience using ssh tunnels to do the same thing. In this case, I'm not using ssh and I don't understand why this will not work. Below is the procedure I'm going through: Log into machine B - Oracle client is installed. SQL Developer is installed. Open SQL Developer - Select TNS connection. Enter in credentials. Connection Successful TNS Names entry:

...

ANSWER

Answered 2020-Mar-31 at 07:31

The same forward connection is working fine in both basic and advanced connection in SQL developer in my machine.

The only difference is machine A,B and Database are in the same network in my case where B can directly connect to the database also

Steps

1)You have to set up forwarding in machine A with machine A ip address as the listen address

2) Use the machine A ipaddress in TNS to connect to Database in machine B

If still, you are facing problems then you can try enabling log and trace files to identify the issue as mentioned in these articles

Oracle Database 10g Debugging Connection problems 1

Oracle Database 10g Debugging Connection problems 2

Source https://stackoverflow.com/questions/60893844

QUESTION

Can I create a batch program that extracts only one of several IP?

Asked 2019-Nov-05 at 16:35

I am trying to create a batch file that port forwards my IP. The IP can be found with the command ipconfig | findstr IPv4, but there are multiple internet adapters and multiple IP addresses. I want to get only one address like 192.168.40.??

192.168.56.1 and 192.168.56.2 is my VirtualBox adapter. I'm not sure how to set the condition in the if statement.

This is the Windows batch file (*.bat):

ipconfig, findstr: ...

ANSWER

Answered 2019-Nov-05 at 08:58

If you want to get something like this ip 192.168.40.*

You can use a little regex with the command findstr like this :

Source https://stackoverflow.com/questions/58704157

QUESTION

Port forwarding not working for Nodejs application

Asked 2019-Aug-16 at 18:26

I am running my Nodejs application on port 9000. I want the application to be accessible from a public IP address.

I went to my router config and did:

My Nodejs application is still running on localhost:9000 but when I go to

mypublicipaddress:9000

I get this site cannot be reached.

I also tried the netsh command:

...

ANSWER

Answered 2019-Aug-16 at 18:26

I went to my router config and did: [...]

My Nodejs application is still running on localhost:9000

This implies that you've bound your Node.js server to your loopback interface on your machine and are trying to reach it from your router which is impossible. Try to bind the server to an IP address that is reachable by the router or bind it to all IP addresses on your local machine (ie. 0.0.0.0 or ::).

For example:

Source https://stackoverflow.com/questions/57527832

QUESTION

How can Android Emulator reach server on local network?

Asked 2019-Jan-08 at 15:38

I want to connect to a server on my local network (10.134.0.178:80). The ip address of my machine is 10.134.3.12 and the ip address of the emulator Wi-Fi is 192.168.232.2.

Now I found out that you have to use 10.0.2.2 to connect to a server on your local machine. But the server isn't running on my local machine - instead it is a separate instace on my LAN.

My local machine can reach and ping the server without problems. The emulator not, but the emulator has internet access. So I can access e.g. www.google.com.

How can I connect the emulator with the server? The shown redirection rules only apply on port level. So how is this meant to be used? Other solutions only talk about a local server. Only one is talking about a similar case, but this is not working for me (no connection)

...

ANSWER

Answered 2019-Jan-08 at 14:33

Hmmm, well, your Android app should connect to the server's address/port as it appears to the host machine running the Android emulator. I have a web server on my LAN and my emulator can access it directly. Start with pointing Chrome in your emulator at a web server on your LAN (assuming you have one on there somewhere) - if the server is on 10.134.0.178:80 then just type 10.134.0.178 in to your Chrome address bar. If that's not working then you need to look and see what's stopping it - any redirection rules getting in the way?

Source https://stackoverflow.com/questions/54093604

QUESTION

Return Value from External PHP Class for Use in If Condition

Asked 2018-Dec-24 at 22:08

Still learning about OOP Programming, but am testing with proxy-scraper

Here's my test.php script that I'm looking to return a variable from a class in an external php file:

...

ANSWER

Answered 2018-Dec-24 at 22:08

Return an array containing the proxy and the country code from your generator.

Source https://stackoverflow.com/questions/53917924

QUESTION

Connect to server through proxy

Asked 2018-Nov-21 at 17:11

I want to connect to a server through proxy server that I have. I am searching for something that is similar to Python's HTTPConnection.set_tunnel, is there something like this in golang?

----edit-----

I'm trying to create a connection to a server that allows self signed certificates & transfers through proxy, will this code work properly?

...

ANSWER

Answered 2018-Nov-21 at 15:52

You can set environment variable HTTP_PROXY for HTTP or HTTPS_PROXY for HTTPS so the default http transport will use it.

Also as an alternative you can create http.Transport by yourself with Proxy field set to http.ProxyURL function call or use you custom implementation.

Example:

Source https://stackoverflow.com/questions/53414431

QUESTION

Exposing a port externally in Azure Compute Emulator

Asked 2017-Dec-19 at 20:49

I have made an Azure Cloud Service TCP listener in C#, and now I am trying to debug it locally. The service definition below exposes the port I am interested in, but when it is running locally, the address is bound to localhost, which is not visible to other devices on the same network.

...

ANSWER

Answered 2017-Dec-19 at 20:49

I managed to get this working by adding a check in the worker role. It's not pretty, and I'd much rather have this done through configuration than through code, but here's my solution:

Source https://stackoverflow.com/questions/47784459

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install portproxy

You can download it from GitHub.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: