去芜存菁
服务器迁移后把原来的mysql data复制进去后大部分表是可以访问的，但是有几个表提示表不存在：
error: 1146: Table 'a_content' doesn't exist
这种情况就是要把原来mysql安装目录data里的 ibdata1 也要拷贝过去
INNODB是MYSQL数据库一种流行的数据库引擎，支持事务（行级），在企业级应用上成为可能
ibdata用来储存文件的数据，而库名的文件夹里面的那些表文件只是结构而已，由于新版的mysql默认试innodb，所以ibdata1文件默认就存在了，少了这个文件有的数据表就会出错。
今天从staging上导lendlease的库的时候发现有的表需要很长时间,后开一看system_logs尽然7个多G
mac上的Sequel Pro又不像windows上heidisql那样可以看到每个表的大小
所以需要自己查一下 看看是不是又不需要的表 而且又特别的大
SELECT TABLE_NAME, TABLE_ROWS, DATA_LENGTH FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'crm_lendlease' ORDER BY DATA_LENGTH DESC, TABLE_ROWS DESC
shoptima的项目 安装好了但是登录不进去
https://learnku.com/articles/5963/toggle-laravel-login-default-bcrypt-encryption-validation
跟着这篇文章先了解了laravel login default bcrypt 加密验证的流程
然后在
shoptima_crm/vendor/laravel/framework/src/Illuminate/Auth/EloquentUserProvider.php
public function validateCredentials
在check之前添加如下代码
$pwd = 'secret';
// echo $hash = password_hash($pwd, PASSWORD_BCRYPT);exit;
$hash = '$2y$10$sCP.2BFmk74IIJ6ftVT4.uN4BjH092LpvgcFAG7FtSOvT4VmJ0guW';
if (password_verify($pwd,$hash)) {
echo "密码正确";
} else {
echo "密码错误";
}
exit;
然后把password_hash算出的密码 保存到数据库里就可以了
password_hash每次加密过的结果都是不同的
只有通过password_verify来验证
—————————–
可以使用artisan来做：
php artisan tinker
$u =App\User::find(1)
$u->password=bcrypt('newpassword')
$u->save()
—————————–
另外一种方式：
Set mail driver as "log" ( .env file )
click forgot password
get password reset link(mail content) in laravel.log
paste it in browser and reset password.
今天需要修改人人商城的多商户左侧菜单
由于不想给商户太多权限 所以需要去除一部分
找了半天发现尽然是和主模块用的同一个模版
/addons/ewei_shopv2/template/web_v3/_header.html
而且菜单获取的内容和主模块一样去掉的办法很傻 直接在pluginMenu unset, 添加如下内容即可
/addons/ewei_shopv2/core/model/system.php
if($plugin == 'merch'){
// remove menu for plugins
unset($config[$key]['perm']);
unset($config[$key]['plugins']);
unset($config[$key]['sale']);
unset($config[$key]['sysset']['items'][1]);
unset($config[$key]['sysset']['items'][2]);
unset($config[$key]['shop']['items'][0]['items'][0]);
unset($config[$key]['shop']['items'][0]['items'][1]);
unset($config[$key]['shop']['items'][0]['items'][2]);
unset($config[$key]['shop']['items'][0]['items'][3]);
unset($config[$key]['shop']['items'][0]['items'][4]);
unset($config[$key]['shop']['items'][0]['items'][5]);
$config[$key]['shop']['items'][0] = array('title' => 店铺装修,'route' => diypage,'desc' => 店铺装修, 'top'=>true);
}
//发送红包start
$url = 'https://api.mch.weixin.qq.com/mmpaymkttransfers/sendredpack';
//获取openID
$uid = $list['uid'];
$result = pdo_fetch("SELECT openid FROM ims_meepo_online_user WHERE id=:id",array(':id'=>$uid));
$open_id = $result['openid'];
$money = (float)$list['money'];
$package = array();
$package['nonce_str'] = random(8);
$package['mch_billno'] = 'xxx'.rand(10000000000000,99999999999999);
$package['mch_id'] = '1515256111';
$package['wxappid'] = 'wx57a837f1e72026c3';
$package['send_name'] = 'xxxx';
$package['re_openid'] = $open_id;
$package['total_amount'] = $money*100;
$package['total_num'] = 1;
$package['wishing'] = 'xxxx佣金'.date('Y-m-d');
$package['client_ip'] = CLIENT_IP;
$package['act_name'] = 'xxxxx佣金';
$package['remark'] = '根据会员后台提现的金额返佣.';
$package['scene_id'] = 'PRODUCT_5';
ksort($package, SORT_STRING);
$string1 = '';
foreach($package as $key => $v) {
if (empty($v)) {
continue;
}
$string1 .= "{$key}={$v}";
}
$string1 .= "key=2nHuHsDijB4Ye7mNN22QxFAP3AW6l3hT";
$package['sign'] = strtoupper(md5($string1));
$dat = array2xml($package);
load()->func('communication');
$certPath = 'E:\xxxxx/apiclient_cert.pem';
$keyPath = 'E:\xxxxx\cert/apiclient_key.pem';
$extra = array(
CURLOPT_SSL_VERIFYPEER=>false,
CURLOPT_SSL_VERIFYHOST=>false,
CURLOPT_SSLCERTTYPE=>'PEM',
CURLOPT_SSLKEYTYPE=>'PEM',
CURLOPT_SSLCERT=>$certPath,
CURLOPT_SSLKEY=>$keyPath,
CURLOPT_POST=>1
);
$response = ihttp_request($url, $dat, $extra);
if($response['errno'] == 58){
$err_msg = $response['message'];
die(json_encode(error('-1',$err_msg)));
}else{
$xml = $response['content'];
$result = xml2array($xml);
if($result['result_code'] == 'SUCCESS'){
$pdo_list = pdo_update("meepo_online_money_page",array('order_static'=>$is_best),array('id'=>$id));
die(json_encode(error('0','success')));
}else if($result['result_code'] == 'FAIL'){
//alert error
$err_msg = $result['return_msg'];
die(json_encode(error('-1',$err_msg)));
}
}
//exit;
//echo $response;
//发送红包end
docker run --privileged -tid -p 8001:80 -v /www/wwwroot:/var/www/html fd514673a63e docker run --privileged=true --name mysql -e MYSQL_ROOT_PASSWORD=superhero -p 6603:3306 -v /www/config/mysql/mysql:/var/lib/mysql -tdi 4f3cbdbc3bdb
之前按网上方法更换源 都有问题 这个试过了是可以的
一、进入yum.repo.d
[root@node-01 ~]# cd /etc/yum.repos.d/ [root@node-01 yum.repos.d]# ls CentOS-Base.repo CentOS-Sources.repo
二、备份原yum源
[root@node-01 yum.repos.d]# mkdir yum-back [root@node-01 yum.repos.d]# mv CentOS-* yum-back/ [root@node-01 yum.repos.d]# ls yum-back
三、替换yum源为阿里源
[root@node-01 yum.repos.d]# cat CentOS-Base.repo # CentOS-Base.repo # # The mirror system uses the connecting IP address of the client and the # update status of each mirror to pick mirrors that are updated to and # geographically close to the client. You should use this for CentOS updates # unless you are manually picking other mirrors. # # If the mirrorlist= does not work for you, as a fall back you can try the # remarked out baseurl= line instead. # # [base] name=CentOS-$releasever - Base baseurl=https://mirrors.aliyun.com/centos-altarch/$releasever/os/$basearch/ gpgcheck=1 gpgkey=https://mirrors.aliyun.com/centos/RPM-GPG-KEY-CentOS-7 #released updates [updates] name=CentOS-$releasever - Updates baseurl=https://mirrors.aliyun.com/centos-altarch/$releasever/updates/$basearch/ gpgcheck=1 gpgkey=https://mirrors.aliyun.com/centos/RPM-GPG-KEY-CentOS-7 #additional packages that may be useful [extras] name=CentOS-$releasever - Extras baseurl=https://mirrors.aliyun.com/centos-altarch/$releasever/extras/$basearch/ gpgcheck=1 gpgkey=https://mirrors.aliyun.com/centos/RPM-GPG-KEY-CentOS-7 enabled=1 #additional packages that extend functionality of existing packages [centosplus] name=CentOS-$releasever - Plus baseurl=https://mirrors.aliyun.com/centos-altarch/$releasever/centosplus/$basearch/ gpgcheck=1 enabled=0 gpgkey=https://mirrors.aliyun.com/centos/RPM-GPG-KEY-CentOS-7
[root@node-01 yum.repos.d]# cat epel.repo [epel] name=Extra Packages for Enterprise Linux 7 - $basearch #baseurl=http://download.fedoraproject.org/pub/epel/7/$basearch baseurl=https://mirrors.tuna.tsinghua.edu.cn/epel/7/$basearch #metalink=https://mirrors.fedoraproject.org/metalink?repo=epel-7&arch=$basearch failovermethod=priority enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-7 [epel-debuginfo] name=Extra Packages for Enterprise Linux 7 - $basearch - Debug #baseurl=http://download.fedoraproject.org/pub/epel/7/$basearch/debug baseurl=https://mirrors.tuna.tsinghua.edu.cn/epel/7/$basearch/debug #metalink=https://mirrors.fedoraproject.org/metalink?repo=epel-debug-7&arch=$basearch failovermethod=priority enabled=0 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-7 gpgcheck=1 [epel-source] name=Extra Packages for Enterprise Linux 7 - $basearch - Source #baseurl=http://download.fedoraproject.org/pub/epel/7/SRPMS baseurl=https://mirrors.tuna.tsinghua.edu.cn/epel/7/SRPMS #metalink=https://mirrors.fedoraproject.org/metalink?repo=epel-source-7&arch=$basearch failovermethod=priority enabled=0 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-7 gpgcheck=1
四、运行yum生成缓存
[root@node-01 ~]# yum makecache [root@node-01 ~]# rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7-aarch64 [root@node-01 ~]# rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
五、验证
[root@node-01 ~]# yum -y install gcc-c++ Loaded plugins: fastestmirror, langpacks Loading mirror speeds from cached hostfile Resolving Dependencies --> Running transaction check ---> Package gcc-c++.aarch64 0:4.8.5-36.el7 will be installed --> Processing Dependency: libstdc++-devel = 4.8.5-36.el7 for package: gcc-c++-4.8.5-36.el7.aarch64 --> Processing Dependency: libstdc++ = 4.8.5-36.el7 for package: gcc-c++-4.8.5-36.el7.aarch64 --> Processing Dependency: gcc = 4.8.5-36.el7 for package: gcc-c++-4.8.5-36.el7.aarch64 ...... ...... ...... Installed: gcc-c++.aarch64 0:4.8.5-36.el7 Dependency Installed: cpp.aarch64 0:4.8.5-36.el7 gcc.aarch64 0:4.8.5-36.el7 libmpc.aarch64 0:1.0.1-3.el7 libstdc++-devel.aarch64 0:4.8.5-36.el7 Dependency Updated: libgcc.aarch64 0:4.8.5-36.el7 libgomp.aarch64 0:4.8.5-36.el7 libstdc++.aarch64 0:4.8.5-36.el7 Complete
#!/usr/bin/env python
#coding=utf-8
"""
新增域名解析记录，参数说明如下：
<accessKeyId>：填写自己的accessKey，建议使用RAM角色管理的Key
<accessSecret>：填写自己的accessSecret，建议使用RAM角色管理的Secret
"""
from aliyunsdkcore.client import AcsClient
from aliyunsdkcore.acs_exception.exceptions import ClientException
from aliyunsdkcore.acs_exception.exceptions import ServerException
from leokim_function import *
from check_cnnect_network import *
import os
import time
while True:
#判断存放IP的文件是否存在，不存在则创建
if os.path.exists("./ip"):
pass
else:
wirte_to_file("./ip","0.0.0.0")
client = AcsClient('<accessKeyId>', '<accessSecret>', 'cn-hangzhou')
if(connect_code() == 200):
#通过函数获取外网ip
ip = get_internet_ip()
#print(ip)
else:
time.sleep(5)
continue
#下面开始对比ip，如果ip与之前记录的ip一致，则不执行任何操作，如果ip有变化，则会更新本地存储文件和更新域名解析
with open("./ip", 'r') as f:
old_ip = f.read()
if ip == old_ip:
print("noupdate"+"\nnew_ip:"+ip+"\nold_ip:"+old_ip)
else:
#print("update"+"\nnew_ip:"+ip+"\nold_ip:"+old_ip)
wirte_to_file("./ip",ip)
des_relsult = Describe_SubDomain_Records(client,"A","rpi.sgl1885.com")
#判断子域名解析记录查询结果，TotalCount为0表示不存在这个子域名的解析记录，需要新增一个
if des_relsult["TotalCount"] == 0:
add_relsult = add_record(client,"5","600","A",ip,"rpi","sgl1885.com")
record_id = add_relsult["RecordId"]
print("域名解析新增成功！")
#判断子域名解析记录查询结果，TotalCount为1表示存在这个子域名的解析记录，需要更新解析记录，更新记录需要用到RecordId>，这个在查询函数中有返回des_relsult["DomainRecords"]["Record"][0]["RecordId"]
elif des_relsult["TotalCount"] == 1:
record_id = des_relsult["DomainRecords"]["Record"][0]["RecordId"]
update_record(client,"5","600","A",ip,"rpi",record_id)
print("域名解析更新成功！")
else:
record_id = 0
print("存在两个子域名解析记录值，请核查删除后再操作！")
path = './RecordId'
wirte_to_file(path,record_id)
time.sleep(10)
#!/usr/bin/env python
#coding=utf-8
"""
Priority(5)：解析优先级，非必填
TTL(600)：TTL值，默认600秒，非必填
Value("121.201.65.98")：记录值，必填
request.set_Type("A")：解析类型，A为解析成IPv4，如需解析根域名，填写@，必填
request.set_RR("www")：子域名，必填
request.set_DomainName("xiaoanran.club")：根域名，必填
返回值说明：
RecordId：解析记录ID，修改和查询域名时需要用到
RequestId：请求ID
"""
from aliyunsdkalidns.request.v20150109.AddDomainRecordRequest import AddDomainRecordRequest
from aliyunsdkalidns.request.v20150109.UpdateDomainRecordRequest import UpdateDomainRecordRequest
from aliyunsdkalidns.request.v20150109.DescribeSubDomainRecordsRequest import DescribeSubDomainRecordsRequest
import urllib
import json
#写入文件
def wirte_to_file(path,content):
with open(path,'w') as f:
f_name = open(path,'w')
f_name.write(content)
#新增解析记录，返回json格式的数据
def add_record(client,priority,ttl,record_type,value,rr,domainname):
request = AddDomainRecordRequest()
request.set_accept_format('json')
request.set_Priority(priority)
request.set_TTL(ttl)
request.set_Value(value)
request.set_Type(record_type)
request.set_RR(rr)
request.set_DomainName(domainname)
response = client.do_action_with_exception(request)
#response = str(response, encoding='utf-8')
relsult = json.loads(response)
return relsult
#更新解析记录
def update_record(client,priority,ttl,record_type,value,rr,record_id):
request = UpdateDomainRecordRequest()
request.set_accept_format('json')
request.set_Priority(priority)
request.set_TTL(ttl)
request.set_Value(value)
request.set_Type(record_type)
request.set_RR(rr)
request.set_RecordId(record_id)
response = client.do_action_with_exception(request)
#response = str(response, encoding='utf-8')
return response
#查询解析记录
def Describe_SubDomain_Records(client,record_type,subdomain):
request = DescribeSubDomainRecordsRequest()
request.set_accept_format('json')
request.set_Type(record_type)
request.set_SubDomain(subdomain)
response = client.do_action_with_exception(request)
#response = str(response, encoding='utf-8')
relsult = json.loads(response)
return relsult
#获取外网地址
def get_internet_ip():
response = urllib.urlopen('http://www.3322.org/dyndns/getip')
ip = response.read()
return ip
SELECT COALESCE(SUM(f.voucher_value), 0) as amount
树莓派上做的ddns要自启动
sudo vim /usr/lib/systemd/system/myddns.service
#这里myservice.service可以定义为自己想要取的名字。
[Unit] Description=myddns Service After=multi-user.target [Service] Type=idle ExecStart=/usr/bin/python2.7 /root/hwx_aliyun_ddns/DDNS.py [Install] WantedBy=multi-user.target
更改文件权限
sudo chmod 644 /usr/lib/systemd/system/myddns.service
使配置文件生效 sudo systemctl daemon-reload #重载服务列表 sudo systemctl enable myddns.service #设置开机自启动 sudo systemctl start myddns.service #开启服务 sudo systemctl status myddns.service #查看服务是否正常运行 或者重启查看能否自启动。 reboot
