Category: Uncategorized

  • TrueNAS: Only one Virtual CPU is allowed in this system

    I’m on TrueNAS SCALE 25.10.4 – Goldeye (Community Edition). First, we need to change the permission of /usr to read-write. If you do not do this, you cannot save the changes. Create a backup of the original file /usr/lib/python3/dist-packages/middlewared/plugins/vm/vms.py (optional). Edit /usr/lib/python3/dist-packages/middlewared/plugins/vm/vms.py (it should be around line 227, on my version it’s on line 248-256).…

  • Smartctl

    Get the disk info Show identity information for device Show all SMART information for device Show all information for device Run the test Short test Long test Abort the test Check the test result Check self-test log Show device SMART health status Check the errors Check error log

  • Xorg

    Generate config file: Test config file: If everything is fine, move to /etc/X11 Start X11 Make sure you are in video and render groups If not If you want to run something when the X start: REFERENCES:

  • Vim: Equal Sign

    Primarily used to indent But you can use it to “pipe” it to external command by setting the ‘equalprg’ or ‘ep’. Now we can pipe input from Vim to md5 and back to Vim. when we press “==” it will cut the word “hello” pipe “hello” to md5 and output the result back to vim

  • Open a CSV File on Excel

    Open your CSV file in text editor and add sep=, on the first line. Or

  • PHP Enum

    Types Built-in Static Function Enum::cases() Built-in Attribute Enum::CASE->name Enum::CASE->value

  • SSH Forwarding

    Forward local socket /tmp/mysqld.sock to remote socket /var/run/mysqld/mysqld.sock Forward local port 0.0.0.0:5555 to remote socket /var/run/mysqld/mysqld.sock Forward local 0.0.0.0:5555 to remote localhost:8080 Forward traffic from the remote machine port 8080 to the local machine localhost:80 At this point, the users logged in are able to reach the local machine localhost:80 from the remote machine localhost:8080.…

  • MySQL/MariaDB Query Log

    Query log is disabled by default. To enabled it non-persistent way (will be disabled when you restart): By default, the general query log is written to ${hostname}.log in the datadir directory. In my case this is /var/lib/mysql. To change the file name format: To save it to TABLE instead of FILE: To read from the…

  • Stream Editor (sed)

    To insert/append to file (Linux) Apply the change to the file (Linux) To insert/append to file (MacOS) Apply the change to the file (MacOS)