[Ubuntu] How to build LAMP server 3 of 3 – MySQL
MySQL can be installed as simple as below. mysqld.conf sql_mode can be changed with query as well Root account setting After this, it will be easier to add other users and grant privileges with GUI of MySQL Workbench.
[Ubuntu] How to build LAMP server 2 of 3 – Apache
Apache configuration files for HTTP(Port 80) and HTTPS(Port 443) can be found as below. SSL Secured site can be configured by enabling ssl module and you will need to get SSL certificate in advance. Self-Signed SSL did not work for me. You can get free SSL certificates from Let’s Encrypt. No Browsing and .htaccess It […]
[Ubuntu] How to build LAMP server 1 of 3 – Server
LAMP server used to be installed as default. For 18.04 and 20.04, LAMP server can be installed as below. For 22.04, Apache and MySQL server gets installed for LAMP server as below. Update It is often recommended to run sudo apt-get update and sudo apt-get upgrade before installing packages. You can run sudo unattended-upgrade for […]
[AWS] RDS Instance changes in the cluster with no (much less?) Downtime.
(Source: https://stackoverflow.com/questions/54708210/how-to-change-aws-rds-instance-type-without-downtime) Instead of changing the instance type of the current instance, Add a new instance first. Then, you can delete the old instance in the cluster. There is no way to add the writer instance, So. In order to change the type of a writer instance. This way you will have nearly no downtime. […]
How to give Wi-Fi static IP address with Netplan on Ubuntu server
It is ideal for a server to have wired connections. Just in case you need to set up a server with wireless connections with static IP address. You can change any unnecessary YAML file names to .old or .bak as you like.
Setting up Range Extender, TP-LINK RE650 for the TekSavvy router, SmartRG SR516ac
First of all, you can read and follow the article below to understand the limitation of RE650 and to start the set-upWhy my Range Extender is unable to detect 5GHz wireless network of my root router? However, your 5GHz Band won’t work if the bandwidth of 5GHz is not set to 40MHz. The image below […]
[Qualtrics] How to use Regular Expression for field validation
Qualtrics provides many built in options for field validations. However, it is required to apply more sophisticated validation than default options. Regular Expression can be used for this kind of situation. First, if you need to allow only alphabet characters with spaces. You can select “Custom Validation” for Validation Type. Then, you can add regular […]
[Qualtrics] How to change log in message when Password Protection is selected from Survey Options
The default message of Password Protection can be inappropriate since it start with “This survey…”. For most of cases, this statement is true but it is not necessarily correct for all of cases. JavaScript can be used to change this message. You have to go to “Look & Feel” and click “edit” under “Header”. You […]
[Qualtrics] How to limit input text box size
It is possible to limit the size of text box by setting “maxlength” attribute of input text box JavaScript is used for this purpose to be precise it is jQuery script. jQuery can be inserted for each question by clicking gear shape icon. It will give you the option for “Add JavaScript”. The code below […]
[Qualtrics] How to set the maxlength for input text
When Custom Validation is used. It can be confusing for users because error messages do not show the exact reason for the error. The JavaScript code below can stop a respondent to type further than intended. The maximum length of the input text box below is set to 19. Javascript code can be inserted as […]