Linux

GoDaddy Apache cPanel: Install SSL Certificate

: Category: cPanel; 07 April 2022; Hits: 12417

What?
An article to remind me how to install an SSL certificate with GoDaddy.

Why?
A quick reference for myself as I found that with GoDaddy, a purchased SSL certificate seems to require re-installing each year despite it's expiry in a couple years time.

The first time I did it, there were more steps; the second time I just did as per the below. If I ever have to do the long process again, I'll add it to this article.

How?
I know there are instructions on the GoDaddy website but this is how I do it along with screenshots:

: Category: cPanel; 20 March 2019; Hits: 7708

What
A quick note as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible via other users).

How?
I want to list 2 methods here. One to create a .sql file of the backup but another to copy the contents to a copy of the database accessible only by root and and this database "backuper" user. For both methods, I grant the following to the user doing the backup on the database I want a backup of:

GRANT SELECT, LOCK TABLES, EVENT, INDEX, REFERENCES, TRIGGER, SHOW VIEW ON 'my_live_db'.* TO 'mybackupuser'@'localhost' IDENTIFIED BY 'mybackupuser';

: Category: Linux; 05 July 2011; Hits: 15116

I could just remember to search wikipedia for "Date (Unix)" or search my site for "Unix". This was easier.

Source: Wikipedia: Date (Unix)

: Category: Linux; 04 May 2011; Hits: 14317

Amazing little script I found on Stack Overflow. Wasn't really my solution as after 2 hours, realised that the customer had been looking at the wrong server. But this script showed me where the cron job we intended was located.

: Category: Linux; 19 September 2009; Hits: 9011

I've been told of two ways of running a downloaded .RUN file.

Note: Bear in mind that the following is all case-sensitive.

Through the terminal server

Download the .RUN file to your desktop
Open a terminal by going to Application > Accessories > Terminal
Type 'CD Desktop' to go to your desktop folder
Type 'LS' just to check the .RUN file is in this one
Type 'sudo sh nameoffile.run'

Through the Gnome GUI

Right-click on the file you downloaded
Select 'Properties'
Select the 'Permissions' tab
Tick the 'Execute' checkbox

Conclusion

The solution using the terminal worked for me but the second one using Gnome didn't.

Ubuntu as a media server

: Category: Linux; 19 September 2009; Hits: 10135

1. If someone wants to use Ubuntu as a home media pc connected to a
tv, there is the problem of overscan; consumer tv's crop off the
border around the image. How does Ubuntu intend to officially solve
this? Right now LinuxMCE has it's own method for doing this so the
LMCE UI is never cropped off, but when the user switches back to
Ubuntu's gnome desktop, the top nav bar is cut off if he's using a
normal tv and not a pc monitor. I'd like to have 1 screen adjustment
tool that correctly adjusts both the lmce desktop and the main ubuntu
desktop, so even when using the Ubuntu desktop on a TV, the top nav
isn't cropped.  Any ideas?