[Laravel] Starting Laravel Project with existing DB/Schema
DB Settings After creating Laravel project with Composer, you need to modify two files to set DB environment. /config/database.php defines connections with environmental variables sourced from .env file. ‘mysql1’ connection has setting for connecting to ‘mysql1’ schema. ‘mysql2’ connection has setting for connecting to ‘mysql2’ schema. Now, your Laravel project is ready to connect to […]
[Docker] Setting up website with WordPress Docker on SSL
I used three images in my docker compose yaml file, They are mysql, wordpress and certbot. 1. certbot from Let’s Encrypt certbot is image from Let’s Encrypt and it is free. The docker compose syntax looks as below. When containers are running. certbot container runs only once to generate your certificates. They can be found […]
[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. […]
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 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 […]