PHP 扩展类安装

1. php扩展安装集合
   1. SNMP
      1. https://blog.csdn.net/weixin_33769207/article/details/92530705=
      2. 进入自己下载的php 比如  /home/jiangzhijie/php-7.2.2/ext/snmp安装即可
   2. Except
      1. linux服务安装
         1. https://www.cnblogs.com/zhoading/p/11988882.html
      2. php扩展安装
         1.  

            yum install -y expect expect-devel tcl tcl-devel
            pecl install expect-0.4.0

             

         2. db

            
            Create Table
            
            CREATE TABLE `event_queue` (
              `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
              `event_type` varchar(20) NOT NULL DEFAULT '' COMMENT '事件类型',
              `biz_data` varchar(2048) NOT NULL DEFAULT '',
              `status` smallint(6) NOT NULL DEFAULT '1' COMMENT '0 已处理 1 未处理',
              `create_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
              `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
              PRIMARY KEY (`id`),
              KEY `status` (`status`,`id`)
            ) ENGINE=InnoDB AUTO_INCREMENT=77681 DEFAULT CHARSET=utf8 COMMENT='消息队列';
            
            
            select d.id, d.ip, d.hostname, d.firm, d.version, d.type, d.remark, d.can_acled, d.idc_id, d.alias, 
                        da.login_type, da.user, idc.name_en as idc_name_en, idc.name_cn as idc_name_cn, d1.ip as slave_dev_ip,  
                        d.delete_mark 
                        from device d 
                        left join idc on d.idc_id = idc.id 
                        left join device d1 on d.slave_dev_id= d1.id 
                        left join device_auth da on d.id = da.dev_id 
                        where  d.is_ops_import = 0 and d.type!=3 order by delete_mark asc limit 0, 30;

             

         3. Jumpserver 
            1. https://www.cnblogs.com/Rightsec/p/10306671.html
         4. sql bak

            1. 
               
               
               
                select concat('alter table ',table_name,' modify varchar(100000);') from information_schema.columns where table_schema='sec_acl_gwxt' and COLUMN_NAME = 'description' and CHARACTER_MAXIMUM_LENGTH != 255;
               
               
               show varibales like '%general_log%'
               
               alter table user modify `remark` varchar(255) NOT NULL DEFAULT '';
               
               -----------------------------------------------------------+
               | alter table acl_apl modify varchar(255);                  |
               | alter table device_interface modify varchar(255);         |
               | alter table device_interface_back modify varchar(255);    |
               | alter table device_vlan modify varchar(255);          
               
               
               ALTER TABLE `sec_acl_gwxt`.`apl_path` CHANGE `links` `links` TEXT CHARSET utf8 COLLATE utf8_general_ci NULL COMMENT '设备链路, json {\'dev_id\':101, \'weight\':11} link status 11(from yes & to yes) 10(from yes & to no) 01(from no & to yes) 00 (both not allow)';