2019-3-29 nginx 配置protected-mode no ,昨天弄了2个小时的laravel-admin 自定义列表,主要是数据查询需要原生sql写

自定义数据列表数据源(grid),需要重写2个方法,目前只知道第一个啥用处,第二个还不清楚为什么重写,为什么重写;
public function paginate()
{
    $perPage = Request::get('per_page', 20);

    $page =   Request::get('page');

    $start = ($page-1)*$perPage;
    $sql = "SELECT a.date,a.roleid,a.rolename,IFNULL(b.maxlevel,1)
                    FROM loginput_czm.`createrole` a
                    LEFT JOIN
                    ( SELECT roleid,MAX(LEVEL) maxlevel
                    FROM loginput_czm.upgrade
                    GROUP BY roleid  )b
                    ON a.roleid=b.roleid
                    WHERE a.roleid != -1 LIMIT $start,$perPage";


    $sqlCount = "SELECT COUNT(*) AS total
                    FROM loginput_czm.`createrole` a
                    LEFT JOIN
                    ( SELECT roleid,MAX(LEVEL) maxlevel
                    FROM loginput_czm.upgrade
                    GROUP BY roleid  )b
                    ON a.roleid=b.roleid
                    WHERE a.roleid != -1";
    $result = DB::connection('loginput')->select($sql);
   //不知道为什么要解析下resutl
    extract($result);
   // dd($result);
   //这个是把array对象专程Collection对象,因为LengthAwarePaginator第一个参数只接收Collection对象数组;
    $datas = static::hydrate($result);
    $total = DB::connection('loginput')->select("$sqlCount");
    $totalSize = isset($total[0]->total)?$total[0]->total:0;
    $totalSize= intval($totalSize);
    $paginator = new LengthAwarePaginator($datas, $totalSize, $perPage,$page);
    //$url = url()->current()."?page=$page&per_page=$perPage";
    $url = url()->current();
    $paginator->setPath($url);
    return $paginator;
}
//这个方法看不懂,就从官方文档抄过来的;
public static function with($relations)
{
    return new static;
}

(error) DENIED Redis is running in protected mode because protected mode is enabled

redis禁止跨服务器访问,所以需要设置protected mode = no

1、修改redis服务器的配置文件
vi redis.conf  
 
注释以下绑定的主机地址
# bind 127.0.0.1
 
 
2、修改redis服务器的参数配置
 
修改redis的守护进程为no ，不启用
127.0.0.1:6379> config set daemonize "no"
OK
 
修改redis的保护模式为no，不启用
127.0.0.1:6379> config set protected-mode "no"
OK