glori.xyz

  • TDM Setup Tips for Haimer Presetter Interface

    Database connection flow:

    • TDM > ODBC(32bit) > Microset(Haimer Presetter Software)
    • Microset is using following connection String:
      • Provider=MSDASQL.1;Persist Security Info=False;User ID=tms;Data Source=TDMSQL32
        • MSADSQL.1 is the “MS OLE DB Provider for ODBC Drivers”
        • TDMSQL32 is the 32bit ODBC System DSN
        • TDMSQL32 shall be specified with default database

  • 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

  • 使用TDM Control批量整理刀具數據

    儅TDM系統的刀具數據量變大之後，常常會有批量刪除，修改和整理數據的需要。使用TDM Control可以對刀具主數據進行快速的批量化的維護。

    這裏碰到客戶聞到：我要刪除某個整套刀數據，但是這個整套刀在十幾個刀具清單中使用，一個個到刀具清單的BOM表裏去刪除太麻煩了。有沒有快速的方法？

    這裏請看操作視頻：

    Edit Tables功能一般我們用作對數據表進行檢索然後修改數據記錄，其實也可以對數據記錄作刪除。例如這裏用到的對數據記錄進行“Mark to delete”操作，然後點擊Modify就會對標注為刪除的記錄進行直接刪除（注意，此操作需要對TDM系統的數據表完全理解和掌握，如果不是很確定，可以咨詢TDM系統技術支持）。

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

    参考链接：

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

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

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