I want say very short steps to make you page secure SSL with “Let’s Encrypt”
Our case, we consider a server where we have ssh access, and we can modify configuration files from apache and restart services.
First step, install certbot. yum install certbot
Second, request key for you webpage: certbot certonly –webroot -w /var/www/html/roundcubemail/ -d webmail.your-domain.com
If you run for the first time here, you will get some questions:
Saving debug log to /var/log/letsencrypt/letsencrypt.log
Plugins selected: Authenticator webroot, Installer None
Enter email address (used for urgent renewal and security notices) (Enter ‘c’ to
Starting new HTTPS connection (1): acme-v01.api.letsencrypt.org
Please read the Terms of Service at
https://letsencrypt.org/documents/LE-SA-v1.2-November-15-2017.pdf. You must
agree in order to register with the ACME server at
Next step you will get the key !
– Congratulations! Your certificate and chain have been saved at:
Your key file has been saved at:
Your cert will expire on 2018-10-07. To obtain a new or tweaked
version of this certificate in the future, simply run certbot
again. To non-interactively renew *all* of your certificates, run
– Your account credentials have been saved in your Certbot
configuration directory at /etc/letsencrypt. You should make a
secure backup of this folder now. This configuration directory will
also contain certificates and private keys obtained by Certbot so
making regular backups of this folder is ideal.
– If you like Certbot, please consider supporting our work by:
Donating to ISRG / Let’s Encrypt: https://letsencrypt.org/donate
Donating to EFF: https://eff.org/donate-le
Final step create you own VHOST config in web server.
A week ago, I posted on steemit.com a story about how to integrate wordpress with Blockchain steem. Here link!
Now I post from my blog that built with CMS wordpress where I installed and activated the stempress!
Let’s start with activating the steempres plugin.
As you can see in the picture you have to click on the “Activate” button and it should look like Stempress!
Now click on the settings and go to the activation menu. Here we have to connect with the user and “Posting key” from the steem. The “Posting key” is taken from our account on steemit.com. Click on “SHOW PRIBATE KEY” to show your real key for login. What you see at first time it’s not your real key.
Once you log in, it should look like this! That’s all, when you post, you have the option of posting what you write on the blog or not on steem Blockchain. See picture!
I think this is the first wordpress written post that also appears on Steem blockchain.
Today we add repository to Edge router lite for install more apps used in cli mode.
Log with ssh to your edge router lite or with cli:
and paste next commands
set system package repository wheezy components 'main contrib non-free'
set system package repository wheezy distribution wheezy
set system package repository wheezy password ''
set system package repository wheezy url 'http://ftp.us.debian.org/debian/'
set system package repository wheezy username ''
set system package repository wheezy-backports components main
set system package repository wheezy-backports distribution wheezy-backports
set system package repository wheezy-backports password ''
set system package repository wheezy-backports url 'http://http.us.debian.org/debian'
set system package repository wheezy-backports username ''
set system package repository wheezy-updates components 'main contrib'
set system package repository wheezy-updates distribution wheezy/updates
set system package repository wheezy-updates password ''
set system package repository wheezy-updates url 'http://security.debian.org/'
set system package repository wheezy-updates username ''
3. Unarhive and test if you have all you need to run
tar -zxvf roundcubemail-1.3.3-complete.tar.gz -C /path/to/folder/
( ex: tar -zxvf roundcubemail-1.3.3-complete.tar.gz -C /var/www/html/ )
read file roundcubemail-1.3.3/UPGRADING for REQUIREMENTS and roundcubemail-1.3.3/INSTALL
4. Final step, upgrade roundcubemail.
Upgrading from 1.1.1. Do you want to continue? (y/N)
Tips after update:
a. Check .htaccess settings (some php settings could become required)
b. If you’re using build-in addressbook, run indexing script /bin/indexcontacts.sh.
c. When upgrading from version older than 0.6-beta you should make sure
your folder settings contain namespace prefix. For example Courier users
should add INBOX. prefix to folder names in main configuration file.
d. Change layout in file roundcubemail-1.3.3/config/defaults.inc.php
// Interface layout. Default: 'widescreen'.
// 'widescreen' - three columns
// 'desktop' - two columns, preview on bottom
// 'list' - two columns, no preview
$config['layout'] = 'widescreen';
default come with ‘widescreen’ but I like ‘desktop’.
and ‘show_images‘ change to 1.
// display remote inline images
// 0 - Never, always ask
// 1 - Ask if sender is not in address book
// 2 - Always show inline images
$config['show_images'] = 0;
Q: I would like to know how to give permission to the database user logged in to access only one table and not whole database?
A: 1. Create user: CREATE USER 'userlimit'@'%' IDENTIFIED BY 'NewPassword';
2. Now run the following to grant the SELECT privilage to the table and database selected ( where you wish ). GRANT SELECT ON database_name.table_name TO 'userlimit'@'%';
Test: MariaDB [database_name]> select * from loturi;
ERROR 1142 (42000): SELECT command denied to user 'userlimit'@'localhost' for table 'loturi'
Now we have to remove caracacter * from each ID because we get error to next commands.
Open file /root/mailq-201711.txt with vim and execute commands :1,$ s/*/<space>/g where 1 it’s first line and $ last line. Save file and exit ( :wq )
And now delete mails form mailq with:
while read i; do postsuper -d $i; done </root/mailq-201711.txt
After read each line I delete ID with postsuper -d $i and read next line. Enjoy!