# socket

**Repository Path**: sixihaoyue/socket

## Basic Information

- **Project Name**: socket
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-09-06
- **Last Updated**: 2023-08-12

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 设置环境变量
```
wget https://nodejs.org/dist/v8.11.1/node-v8.11.1-linux-x64.tar.gz
tar -xvf node-v8.11.1-linux-x64.tar.gz
ln -s node-v8.11.1-linux-x64/bin/node /usr/local/bin/node
ln -s node-v8.11.1-linux-x64/bin/npm /usr/local/bin/npm
```
#下载代码
```
tar -xvf socket.tar.gz
cd socket && npm install
```
#配置项
```
vi etc/api.js 
module.exports = {
  host: '0.0.0.0', 
  port: 8889, // api 服务端口
}
```
 ```
vi etc/config.js
module.exports = {
  server: {
      host: '0.0.0.0',
      port: 8888, // socket 服务端口
//      worker_processes: 1, // socket 服务进程数
  },
  services: [
      'sdk',
      'redis',
      'mysql',
      'api',
  ]
}
```

```
vi etc/mysql.js 
module.exports = {
//   log_query: true,
  master: {
    host: '127.0.0.1',
    port: 3306,
    username: 'pszn_eq',
    password: '123456',
    database: 'pszn_eq',
  },
  pool: {
    max: 5,
    min: 0,
    idle: 30000
  }
}
```
```
vi etc/redis.js 
module.exports = {
  host: '127.0.0.1',
  port: 6379,
  // password: '',
}
```
```
vi etc/log4js.js 
module.exports = {
  appenders: {
    console: {
      type: 'console'
    },
    file: {
      type: 'file',
      filename: 'data/main.log',
      encoding: 'utf-8'
    },
  },
  categories: {
    default: {
      appenders: ['console', 'file'],
      level: 'info'
    }
  }
}

```
```
vi etc/sdk.js 
module.exports = {
  apiAddr: 'https://yunfuwu.pushunzn.com'
}
```
守护进程
```
sudo apt-get install supervisor
vi /etc/supervisor/conf.d/socket.conf 

[program:socket]
directory=/var/www/socket
command=node main

autostart=true
autorestart=true
startretries=10
redirect_stderr=true


sudo supervisorctl reread
sudo supervisorctl update
sudo supervisorctl start socket
```


#数据库
###chargings 
|   字段 | 类型  | 说明
|  ----  | ----  |----  |
| code | CHAR(20)| 设备号| 
| 0x31  | MEDIUMTEXT |最近一次0x31包数据|
| 0x34  | MEDIUMTEXT|最近一次0x34包数据|
| 0x39  | MEDIUMTEXT |最近一次0x39包数据|
| accessed_at  | BIGINT |最近一次访问时间|
| created_at  | BIGINT |创建时间|
| updated_at  | BIGINT |更新时间|