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!