llc1123 / ssmgr-trojan-client Goto Github PK

CREATE TABLE users (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    username VARCHAR(64) NOT NULL,
    password CHAR(56) NOT NULL,
    quota BIGINT NOT NULL DEFAULT 0,
    download BIGINT UNSIGNED NOT NULL DEFAULT 0,
    upload BIGINT UNSIGNED NOT NULL DEFAULT 0,
    PRIMARY KEY (id),
    INDEX (password)
);

 [INFO] default - Message received: {"command":"add","port":60029,"password":"14f4ffe8604ab780b25bc729eb0c708f1b47f9dbbd4350c43aad8f7a"}
 [ERROR] default - Query error on 'add': ER_NO_DEFAULT_FOR_FIELD: Field 'username' doesn't have a default value

[ALL] 127.0.0.1:33912 incoming connection
[WARN] 127.0.0.1:33912 valid trojan request structure but possibly incorrect password (6c7f83d212bf6be15b78927895f9786c6c2d827979a7e57951b96114)

{
    "run_type": "server",
    "local_addr": "127.0.0.1",
    "local_port": 2443, 
    "remote_addr": "127.0.0.1",
    "remote_port": 80,
    "password": [
        "FixedPassword1",
        "FixedPassword2"
    ],
    "log_level": 0,
    "ssl": {
        "cert": "/home/ubuntu/.acme.sh/your.domain/fullchain.cer",
        "key": "/home/ubuntu/.acme.sh/your.domain/your.domain.key",
        "key_password": "",
        "cipher": "ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384",
        "cipher_tls13": "TLS_AES_128_GCM_SHA256:TLS_CHACHA20_POLY1305_SHA256:TLS_AES_256_GCM_SHA384",
        "prefer_server_cipher": true,
        "alpn": [
            "http/1.1"
        ],
        "alpn_port_override": {
            "h2": 81
        },
        "reuse_session": true,
        "session_ticket": false,
        "session_timeout": 600,
        "plain_http_response": "",
        "curves": "",
        "dhparam": ""
    },
    "tcp": {
        "prefer_ipv4": false,
        "no_delay": true,
        "keep_alive": true,
        "reuse_port": false,
        "fast_open": true,
        "fast_open_qlen": 20
    },
	"redis": {
        "enabled": true,
        "server_addr": "localhost",
        "server_port": 6379,
        "password": ""
	},
    "mysql": {
        "enabled": false,
        "server_addr": "10.0.0.45",
        "server_port": 3306,
        "database": "trojan",
        "username": "trojan",
        "password": "thisisthetrojandbpassword",
        "cafile": ""
    }
}

stream {

    #------------------------------
    server {
        listen 443;
        listen [::]:443;
        proxy_pass $name;
        proxy_protocol on; # Key step support HAProxy proxy_protocol
        ssl_preread on; # preread SNI hostname

        access_log /var/log/nginx/stream_access.log streamlog;
        error_log  /var/log/nginx/stream_error.log; # Health check notifications
    }
    
    map $ssl_preread_server_name $name {
		trojan.your.domain trojan_pre;
                www.dummpysite.com mtproxy;

                "~^cget\d{0,1}\.your\.domain $" LocalBackEnd;

        default LocalBackEnd;
    }

    #------------------------------
    upstream trojan_pre {
        server 127.0.0.1:2442;
    }

    server {
        listen localhost:2442 reuseport proxy_protocol;
        proxy_pass trojan;
    }
    
    upstream trojan {
        server 127.0.0.1:2443;
    }
    #------------------------------
    upstream mtproxy {
        server 127.0.0.1:3443;
    }
    #------------------------------
    upstream LocalBackEnd {
        server localhost:1443; # temp server
    }

}

http {
     .....
     include /etc/nginx/sites-enabled/*;
}