Oracle Find NVARCHAR Field
sometimes during database migration, we need To know if our database have NVARCHAR Field , below SQL can check Oracle database if it have NVARCHAR field. select table_name,column_name,data_type from user_tab_columns…
Redirect HTTP to HTTPS in Nginx
Since my server do not serve http, so need to redirect http to https simply modify /etc/nginx/nginx.conf server { listen 80 default_server; listen [::]:80 default_server; server_name _; return 301 https://$host$request_uri;…
An Example for downloading Derived Output using Enterprise Integration Framework
Introduce a Simple demo from 3DEPERIENCE CATIA Design and generated STEP derived output and use EIF to download STEP, using Postman to invoke web services. So from event monitoring we…
3DEXPERIENCE 2024x Installation on RHEL 8.6
This is only for demo case, all servers in one OS. create dedicated user for 3DEInstallation for all the commands, do not copy the first character. #useradd dsuser #passwd dsuser…
Naive Install
prerequisite: you need a domain name first. installation commands: #go install github.com/caddyserver/xcaddy/cmd/xcaddy@latest #~/go/bin/xcaddy build --with github.com/caddyserver/forwardproxy@caddy2=github.com/klzgrad/forwardproxy@naive config: create a file named Caddyfile { order forward_proxy before file_server } :443, domainname.com…
Ubuntu OS frequently Upgrading take too much disk space
In some VPS case , the disk space is very limited. while if you frequently upgrade Ubuntu , more and more disk space will be taken. To solve this, simply…
Oracle Cloud Centos 8 dnf warning
when do dnf or yum to install/update software , Centos 8 on Oracle Cloud will give error below: Failed loading plugin "osmsplugin": No module named 'librepo' To Solve this ,…
wordpress encounter http 500 error
when I try deferent themes and plugins, there will be chance that the server just not working. it gave an 500 error at browser In this case , to find…
Register and use SMTP Service for WordPress
Register SMTP Service at https://app.brevo.com/ I use Brevo.com to use SMTP to send mails , which allow 300 mails per day for free. One step is somehow complex is you…
nginx redirect root / to /wordpress/
Since Wordpress is installed under /wordpress/ url. and root / URL do not have any important content. so we need redirect URL / to URL /wordpress/ hear is the Nginx…