glori.xyz

Category: IT

  • Ubuntu Linux – 3 Commands to Disable IPv6

    #sysctl -w net.ipv6.conf.all.disable_ipv6=1
#sysctl -w net.ipv6.conf.default.disable_ipv6=1
#sysctl -w net.ipv6.conf.lo.disable_ipv6=1
    //code to check
#ip a
...
//should be no IPv6 entry now.

  • OpenWRT软件包自动更新

    #crontab -e
0 3 * * * opkg update && opkg update && opkg list-upgradable | cut -f 1 -d ' ' | xargs -r opkg upgrade
>
>
>
#/etc/init.d/cron enable
#/etc/init.d/cron start

    Reference Link

  • TDM Oracle Database Tips

    Environment:

    • TDM 2018+
    • Oracle 19c
    • Windows10/11

    Tips:

    • Do NOT change ORACLE_HOME\network\admin\sqlnet.ora
      • Some document was said to change AUTH… to (none). Do NOT change and keep it as (NTS) in Windows10/11, or it might cause some problem during DB creation and startup.
    • Avoid to install both Oracle DB Server and Client in same machine(Standalone)
    • Old TDM version(2018 or early) may still need 32bit Oracle Client. test.udl file can only verify 64bit, NOT 32bit OLE DB component.
    • Newer TDM version does not need TNSName anymore
    • SQL to check Database character(Unicode/non-Unicode)
    SQLPLUS > select value from nls_database_parameters

  • TDM Installation – Required Oracle(19c) components

    Notes:

    1. Actually OLE DB was the key component.
    2. Early TDM version/TDM Installer may need 32bit Oracle Client.
    3. Both Oracle DB Server and Client was needed for TDM standard alone installation. If there’s problem to recognize the component, please consider on which ORACLE HOME was used (especially command line operation).

  • Win11 启用自动登录

    默认安装的Windows 11没有启用自动登录的选项，以下方法首先修改注册表启用选项，然后使用userpasswords2自动登录界面进行设置。

    Uncheck the box to enable the user with autologon
    1. WIN+R > regedit
    2. WIN+R > control userpasswords2
    Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\PasswordLess\Device

    Reference: How to Log In Automatically to Windows 11

  • OpenWRT软件包更新日志

    wget -O ipk.pub https://master.dl.sourceforge.net/project/openwrt-passwall-build/ipk.pub
opkg-key add ipk.pub

read release arch << EOF
$(. /etc/openwrt_release ; echo ${DISTRIB_RELEASE%.*} $DISTRIB_ARCH)
EOF
for feed in passwall_luci passwall_packages passwall2; do
  echo "src/gz $feed https://master.dl.sourceforge.net/project/openwrt-passwall-build/releases/packages-$release/$arch/$feed" >> /etc/opkg/customfeeds.conf
done

opkg update
#Then update the package in web for luci-pa..

    Reference link.

  • WSL – Win11 安装手册

    Pre-requirements:

    Windows Feature:

    + Hyper-V

    +Windows Subsystem for Linux

    start > powershell (as Administrator)
PS> wsl --install

  • Win11创建本地用户账号和自动登录的方法

    参考链接：

    https://www.pctips.com/create-local-user-account

    已经成功通过【设置】页创建本地账号，接下来需要研究一下：

    1. 如何自动登录或者kiosk模式的方法
    2. 设置自启动程序的方法

  • odoo 系统操作备忘录

    修改默认web端口

    # C:\odoo13\server\odoo.conf
...
http_port = 28069 # 默认为8069
...

  • 数字化市场推广工具-SMTP Relay(邮件群发，邮件转发服务工具）

    最近使用的Sendgrid服务突然不好用了（免费期已过），又搜索了一圈类似的工具，记录在这里

    参考链接:

    7 The Best SMTP Relay Services

    价格敏感的话，直接看我收集的各个Saas服务的Price页面

    Postmark

    turboSMTP

    mailgun

    mailchimp

    SMTP2GO

    mailtrap

    目前暂时在试用sendpulse

    后继还会继续研究如何Web crawlers获客进行Email Campaigns