Remote Connecting to CPanel MySQL Database via DailyRazor

Many website hosting services provide a tool to manage your websites via CPanel. Normally, your website hosting company will also provide cheap or free database hosting for MySQL. One such example is the award-winning hosting company DailyRazor. Create MySQL Database via CPanel CPanel makes it very easy to create a…

Continue reading

Spring Data Pageable JPA Filter Query with 3 of 4 Parts of Composite Key via a Query Method

Let’s say you are using Spring Data and you have a “Composite Key” (ie, a tuple or EmbeddedId). Generally, you may want to query by the whole composite key (ie, by ID), which is generally fairly straightforward with a JPA “query method” (still not sure that is the official name)….

Continue reading

Allow BitBucket Webhooks Access to Jenkins on an AWS EC2 instance behind a Private VPC

Let’s say you want to let BitBucket notify Jenkins to do a build every time a PR is created or a branch is updated. You can leverage the BitBucket webhooks to do this. If so you will want to allow traffic from the BitBucket CIDR addresses here: https://support.atlassian.com/organization-administration/docs/ip-addresses-and-domains-for-atlassian-cloud-products/#AtlassiancloudIPrangesanddomains-OutgoingConnections If you…

Continue reading