I bought this cheap keychain couple of months ago and thought it would be a nice weekend Arduino project. My idea is to modify this novelty device as a notifier to notify me when my Jenkins or software build is successful. It has a web interface and REST API. An astronaut keychain from a novelty […]
After installing MySQL, log in to it via terminal with $sudo mysql -u root Once inside MySQL, we will need to change the default plugin authentication to mysql_native_password and set a password for root. mysql> ALTER USER [email protected] IDENTIFIED WITH mysql_native_password BY ‘password’; mysql> exit You can now login in MySQL as root using the […]
Let say that you wanted to create a MySQL user for example johnpili and assign privileges. You can do that using the simple code snippet below: mysql> CREATE USER ‘johnpili’@’localhost’ IDENTIFIED BY ‘Pass2Word3r’; mysql> GRANT ALL PRIVILEGES ON *.* TO ‘johnpili’@’localhost’; mysql> FLUSH PRIVILEGES; […]
You may need to setup an SSH keys or environment variables to your Jenkins installations. One of the easy way to do this is to setup those environment variablesinside the jenkins user account. If you installed Jenkins in CentOS or Ubuntu via YUM or APT; These package managers will setup a jenkins user account without […]
You build your first Golang web application and running in a remote server via SSH. The problem with that is once the SSH session is terminated it also kill any running programs associated with that SSH session. Using nohup solves this problem but I think this is okay during development and testing phase. A better […]
Use OpenSSL generate a self-signed certificate for Golang. In this code snippetI created a certificate with validity of 15 years. openssl genrsa -out server.key 2048 openssl req -new -x509 -sha256 -key server.key -out server.crt -days 5475 Once you create the certificate and key you can use it in your Golang HTTP like this log.Fatal(http.ListenAndServeTLS(“:”+port, configuration.HTTP.ServerCert, […]
To randomly create a time.Sleep in Golang you can use the code snippet below. You may want to simulate a load in your web server and have an arbitrary seconds or minutes before getting the reply. rand.Seed(time.Now().UnixNano()) delta := rand.Intn(60 + 1) // randomly generates numbers 1 to 60 time.Sleep(time.Duration(delta) * time.Second) // sleep and […]
In response to this facebook post. I created a simple bus seat reservation user interface using VueJS. I started by preparing an SVG image of the bus seat and then render the SVG elements using Javascript (VueJS). You can use a raster image (sprite) for this but I prefer to use vector graphics (SVG) because […]
Perhaps you may need a ledger type query that can display a running total like the one on a bank statement. […]
Suppose you want to retrieve a list of products that are not in promotion. SELECT * FROM product t1 LEFT JOIN promo_product t2 ON t1.idProduct = t2.product_idProduct WHERE t2.idPromoProduct IS NULL […]