acme.sh can not renew the nginx server certification
If you have redirect port 80 to 443 at nginx.conf using 301 code, acme.sh renew certification will failed as Cannot find config file for domain cloudzhong.top I have already solved…
如何打开3DE的追踪Trace日志
有的时候，比如需要知道3DE操作时候数据库的SQL是哪些，这时候我们需要打开SQL的追踪。 使用管理员登陆"Collaboration and approvals" --》Utility --》 Run MQL ，运行下面的MQL trace type sql filename sql.txt 可以使用 print trace 查看当前的追踪状态，SQL TRACE有没有被打开。 这时候，如上图，3DSpace的所有SQL都会打印在/usr/DassualtSystemes/R2025x/3DSpace/logsCAS目录中的sql.txt文件中。 查看这个文件，可以看到很多SQL ，可以使用 tail -f sql.txt 查看SQL的更新（太多了看不过来） 当我们结束SQL查看后，我们需要关掉SQL的追踪，不然日志文件会越来越大，很容易导致磁盘空间不足。 使用 trace off…
VMware Workstation unrecoverable error: (mks) occurs when starting a VMWare virtual machine
previously when my VMware workstation upgrade to 17.6.0, I found that RHEL 8 VM failed to startup. The behavior is: after the VM started, then it crashed, and gave an…
Delete 3DPassport User and recreate
Normally when delete user at 3DPassport , it will not allowed the user to be recreated. at "3DPassport Control Center" , audit -> User, search the deleted user When you…
Replace text at multiple files at Linux
To replace txt https://hostname.domain.com/3dpassport at many files at same folder to https://bbbbb.domain.com/3dpassport sed -i "s/https:\/\/hostname.domain.com/https:\/\/bbbbb.domain.com/g" `grep -l https://hostname.domain.com *` command explanation: grep -l will only output the file name. ``…
Fixing ORA-27104: system-defined limits for shared memory was misconfigured
When starting an Oracle database, you may encounter the following error: ORA-27104: system-defined limits for shared memory was misconfigured This error usually indicates that the operating system's shared memory settings…
ACME.sh Can not renew certification
Using acme.sh to automatically renew certification. but it is failed. let us looks the detailed information. acme.sh --renew-all [Sun Aug 18 06:40:03 GMT 2024] Cannot find config file for domain…
Filter Apache Access logs Separate Requests From Local Servers
Some requests from local servers is annoying. Need to separate the logs, then the log can focus on users' requests. To separate the log, use apache environment variable, modify at…
How to know oracle table size including BLOB Columns
Just learned from today's customer meeting, so recording this. Our system have a table named TICKETGRANTINGTICKET which is used to store CAS authentication information. And it has 3 column defined…
How To Search TXO Newly Added Attribute
TXO is role trigram for "Customization Administrator", which is used OnPremise to add attributes and Subtypes etc.. Suppose you added an attribute through automatically added extension. it is still need…