<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[hoooooly的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/hoooooly</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; hoooooly]]></copyright><item><title><![CDATA[在k8s的pod中,调用ssh内网穿透]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/121892535</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/121892535</guid><author>hoooooly</author><pubDate>Sun, 12 Dec 2021 20:19:12 +0800</pubDate><description><![CDATA[首先 生成一份 ~.ssh/id_rsa与~/.ssh/id_rsa.pub文件

将两份文件的内容,使用base64编码,生成两个secret的配置

如 ssh_secrect.yaml:



更新或新增刚刚创建的secret


kubectl create -fssh_secrect.yaml

查看你的secret目录挂载的位置,以我的为例,我挂载在 /config 目录下



编写shell脚本

建议把shell文件写在项目中,不要打包进docker镜像内,不安全

我的shell文...]]></description><category></category></item><item><title><![CDATA[laravel使用env()方法获取配置时,值为null]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/120128177</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/120128177</guid><author>hoooooly</author><pubDate>Mon, 06 Sep 2021 10:15:00 +0800</pubDate><description><![CDATA[如果执行过config缓存


php artisan config:cache

在非config目录下的文件内,使用env()方法都无法获取env的配置,建议将配置在config中设置,如


  'name' =&gt; env('APP_NAME', 'Laravel'),

获取nema时,使用 config('name'),而不是 env('APP_NAME')
...]]></description><category></category></item><item><title><![CDATA[chrome打开网页很慢,别的浏览器打开相同的网页很快]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/116760536</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/116760536</guid><author>hoooooly</author><pubDate>Thu, 13 May 2021 18:24:55 +0800</pubDate><description><![CDATA[我们的测试环境,同事总是吐槽打开很慢,但是我这里速度很正常,1s打开,他哪里经常性的超时,超时时间10s,开始以为是chrome的某些插件导致的,全部关闭发现不行

并且,使用其他浏览器打开就很快,然后开始百度,最终发现,是chrome有一个默认设置,设置项的名称是 使用安全dns,关闭该选项即可


...]]></description><category></category></item><item><title><![CDATA[mac使用fish的时候添加可执行文件路径]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/114975891</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/114975891</guid><author>hoooooly</author><pubDate>Thu, 18 Mar 2021 13:51:00 +0800</pubDate><description><![CDATA[获取需要执行的文件路径,入


/usr/local/opt/php@7.4/bin
/usr/local/opt/php@7.4/sbin

修改fish的配置


vim ~/.config/fish/config.fish

写入配置


set -g fish_user_paths "/usr/local/opt/php@7.4/bin" $fish_user_paths
set -g fish_user_paths "/usr/local/opt/php@7.4/sbin" $fish_user_]]></description><category></category></item><item><title><![CDATA[php 将p12文件转成普通证书发送https请求]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/113741864</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/113741864</guid><author>hoooooly</author><pubDate>Sun, 07 Feb 2021 15:42:46 +0800</pubDate><description><![CDATA[今天遇到了一个接口联调,对方给了我一个java demo,需要证书发送请求,但是他给的文件是 apiclient_cert.p12这种格式的,然后给了我一个密码
但是我这边是php,一般使用的是一个key和秘钥一共两个证书

apiclient_key.pem
apiclient_cert.pem
于是 我这里需要根据他的p12文件和密码导出为通用的证书文件

# 首先,复制p12文件到linux,然后在linux下执行命令
openssl pkcs12 -in 证书名.p12 -out 文件名.pem -]]></description><category></category></item><item><title><![CDATA[IDE中快速打开当前目录&windows shell(cmd)中快速打开当前目录]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/112825989</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/112825989</guid><author>hoooooly</author><pubDate>Tue, 19 Jan 2021 14:14:59 +0800</pubDate><description><![CDATA[平时想打开当前项目中的文件夹,总是需要点来点去,最近找到了一个快捷的方法



点击右下角的Terminal



输入以下内容


start .

回车,即可打开当前项目的目录

PS:这个是windows shell的命令,所以,在cmd里执行也是可以的


...]]></description><category></category></item><item><title><![CDATA[superset 样式微调]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/112271302</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/112271302</guid><author>hoooooly</author><pubDate>Wed, 06 Jan 2021 14:46:51 +0800</pubDate><description><![CDATA[样式需求:

日期查询逻辑调整
	pivot表数据为空时,默认为null
	使数据表中的链接可直接点击
	选择列表修改为横排样式
	视频点击后,在本页面悬浮播放

	日期查询逻辑调整

	日期查询逻辑调整,lastday原本为 day &gt;= 1 &amp;&amp; day &lt;= 2,修改为 day &gt;= 1 &amp;&amp; day &lt; 2
	

# 修改以下文件
/home/yourname/env/superset/lib/python3.6/site-packages/s]]></description><category></category></item><item><title><![CDATA[安装pycrypto，windows10，全解]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/109615951</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/109615951</guid><author>hoooooly</author><pubDate>Wed, 11 Nov 2020 11:49:45 +0800</pubDate><description><![CDATA[安装pycrypto

一：下载pycrypto源码或pip安装

1.下载pycrypto源码

建意先全部阅读一遍在进行安装，坑太多，不能急
官网：https://www.dlitz.net/software/pycrypto/
github：https://github.com/dlitz/pycrypto
一般情况下下载2.6.1稳定版，下载完成后解压，cmd或者git bash进入解压后的文件夹，输入pythonsetup.pyinstall
如果输出看到running install_egg..]]></description><category></category></item><item><title><![CDATA[docker安装clickhouse]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/109129831</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/109129831</guid><author>hoooooly</author><pubDate>Sat, 17 Oct 2020 10:43:31 +0800</pubDate><description><![CDATA[直接运行, docker会自动帮你拉取镜像:


docker run -d --name ch-server --ulimit nofile=262144:262144 -p 8123:8123 -p 9000:9000 -p 9009:9009 yandex/clickhouse-server


查看镜像


[root@ly-A2 ~]# docker ps
CONTAINER ID        IMAGE                      COMMAND             C...]]></description><category></category></item><item><title><![CDATA[react-countup - 数字滚动效果,可以重置]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/109117380</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/109117380</guid><author>hoooooly</author><pubDate>Fri, 16 Oct 2020 15:22:07 +0800</pubDate><description><![CDATA[class Index extends Component {

  state = { 

    end:100

   }

  onComplete=()=&gt;{

    console.log('动画完成后')

  }

  onStart=()=&gt;{

    console.log('动画完成前')

  }

  start=()=&gt;{

    console.log(this.countup)

    this.countup.restart()

  }

 ..]]></description><category></category></item><item><title><![CDATA[superset pivot table 无数据时展示为空 不展示0]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/108515534</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/108515534</guid><author>hoooooly</author><pubDate>Thu, 10 Sep 2020 15:44:45 +0800</pubDate><description><![CDATA[当使用pivot table的时候,没有的值会使用null默认,如果想改为空或者0 需要修改源码

文件位置 superset/viz.py

找到这段代码


        return dict(
            columns=list(df.columns),
            html=df.to_html(
                na_rep="null",
                classes=(
                    "datafr...]]></description><category></category></item><item><title><![CDATA[支付宝账户余额查询接口,提示参数有误参数account_product_code和account_scene_code不能同时为空]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/107907439</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/107907439</guid><author>hoooooly</author><pubDate>Mon, 10 Aug 2020 11:00:16 +0800</pubDate><description><![CDATA[当前使用的sdk是支付宝python的sdk,该问题的原因是sdk有问题,需要修改sdk内容

文件位置: 你的python路径/lib/python2.7/site-packages/alipay/aop/api/domain/AlipayFundAccountQueryModel.py

原文件内容:


#!/usr/bin/env python
# -*- coding: utf-8 -*-
import json

from alipay.aop.api.constant.ParamConstan]]></description><category></category></item><item><title><![CDATA[mysql将数据按天,周,半月,月分组]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/87631495</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/87631495</guid><author>hoooooly</author><pubDate>Mon, 18 Feb 2019 17:30:15 +0800</pubDate><description><![CDATA[最近有个需求,要求查出今天,一周,15天,一个月的数据

created是时间戳

按天分组:


SELECT SUM(income) AS income,
FROM_UNIXTIME(created, '%Y-%m-%d') AS create_data
FROM `income`
GROUP BY create_data
ORDER BY create_data DESC

按周分组


S...]]></description><category></category></item><item><title><![CDATA[superset连接mysql失败]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/86692557</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/86692557</guid><author>hoooooly</author><pubDate>Tue, 29 Jan 2019 17:13:07 +0800</pubDate><description><![CDATA[刚装的superset,连接hbase成功,连接mysql的时候,先提示

no module named 'Mysqldb'

然后安装mysql客户端


pip install mysqlclient


mysql://account:password@127.0.0.1:3306/dbtest?charset=utf8

再连接mysql,提示


(MySQLdb._exception...]]></description><category></category></item><item><title><![CDATA[php-redis Zincrby无效的问题]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/86648615</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/86648615</guid><author>hoooooly</author><pubDate>Fri, 25 Jan 2019 16:45:20 +0800</pubDate><description><![CDATA[项目需要做个积分榜的功能,所以就用了redis的zset,本来测试服务器上好好的,

到了正式的就gg了 功能都正常,但是分数一直加不上,一直为0 ,

最后用redis看发现传过去的分值一项为空,其他的都正常

然后对比了正式和测试的predis扩展,正式的是3.10,测试的是3.16

后来改了下predis的版本,就好了...]]></description><category></category></item><item><title><![CDATA[smarty中,php数组传递给js的方法]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/85112836</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/85112836</guid><author>hoooooly</author><pubDate>Thu, 20 Dec 2018 10:22:00 +0800</pubDate><description><![CDATA[
var arr_data = JSON.parse('{$phpArray|@json_encode}');]]></description><category></category></item><item><title><![CDATA[smarty foreach输出变量 变量被转义]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/85051541</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/85051541</guid><author>hoooooly</author><pubDate>Mon, 17 Dec 2018 16:37:11 +0800</pubDate><description><![CDATA[今天使用smarty的时候,使用foreach输出变量,变量被转义了



smarty代码,刚开始就只有上面的{$value}



输出后



开始以为是自动转义,使用别的数据带上双引号就没事

后来加上smarty代码里{$source.$k}的方式调用就不会转义了

源码也懒得看,应该是foreach的时候自动给转义了吧...]]></description><category></category></item><item><title><![CDATA[php使用redis存储的数据,python取出后带有s:1]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/84959290</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/84959290</guid><author>hoooooly</author><pubDate>Tue, 11 Dec 2018 18:04:11 +0800</pubDate><description><![CDATA[今天用php做到redis的hash存储,取的是数据带上长度

php:


redis.hset('cache_key', 'field', 1)

python:


redis.hget('cache_key', 'field')

# 返回:
&quot;s:1:\&quot;1\&quot;;&quot;

这个是因为被php serialize了

所以python取的时候需要转义


import phpserialize...]]></description><category></category></item><item><title><![CDATA[mysql修改配置文件后的启动错误]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/84788561</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/84788561</guid><author>hoooooly</author><pubDate>Tue, 04 Dec 2018 14:57:10 +0800</pubDate><description><![CDATA[修改完mysql配置文件后,重新启动报错


Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/var/izbp1b0a77gz.pid)

连接mysql的时候报错


ERROR 2002 (HY000): Can't connect to local MySQL server...]]></description><category></category></item><item><title><![CDATA[superset设置起止时间为明天]]></title><link>https://blog.youkuaiyun.com/hoooooly/article/details/84638830</link><guid>https://blog.youkuaiyun.com/hoooooly/article/details/84638830</guid><author>hoooooly</author><pubDate>Thu, 29 Nov 2018 19:58:22 +0800</pubDate><description><![CDATA[使用superset的时候发现 修改时间总是从昨天开始 就很郁闷 这什么设定啊

然后通过查询源码,找到了修改方式

首先找到superset的安装目录


/root/anaconda3/envs/superset/lib/python3.6/site-packages/superset

首先删除 缓存的pyc文件 如果没有则忽略


/root/anaconda3/envs/superset...]]></description><category></category></item></channel></rss>