How to upgrade roundcubemail! From 1.1.1 to 1.3.3

This day we make update update to new version roundcubemail-1.3.3

    1. First step  make backup of actual version.
cp -R -p webmail_old/ /root/work/webmail_old-20171221
mysqldump -uroot -p yourpassword --routines --single-transaction your_roundcube_db > /etc/sqldump/your_roundcube_db.dump.sql

2. Second step download new version.

wget https://github.com/roundcube/roundcubemail/releases/download/1.3.3/roundcubemail-1.3.3-complete.tar.gz
or
wget https://serverde.biotree.tk/roundcubemail-1.3.3-complete.tar.gz

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.

roundcubemail-1.3.3/bin/installto.sh webmail_old/
Upgrading from 1.1.1. Do you want to continue? (y/N)
y
.....................................................

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;

Enjoy !

Update Centos 6.x to 6.9 and fail connect to Openvpn!

This week update to last vesion of centos 6.9 and find Openvpn do not work.

Error: ERROR: depth=0, error=certificate signature failure:
OpenSSL: error:140890B2:SSL routines:SSL3_GET_CLIENT_CERTIFICATE:no certificate returned

RHEL 6.9 / Centos 6.9 remove Deprecated Insecure Algorithms and Protocols link.

More info: CentOS 6.9 Release Notes

Solution 1:  Remove old keys from your Openvpn server and create new key.
Solution 2: Add exception for keys you have now but don’t forget to change keys in soon as posible.

Exception:

echo -e “LegacySigningMDs md2 md5\nMinimumDHBits 512\n” >> /etc/pki/tls/legacy-settings
service openvpn restart

Enjoy for today !

Adding the new MySQL user with access in database and just one table!

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'@'%';
Enjoy!

Test:
MariaDB [database_name]> select * from loturi;
ERROR 1142 (42000): SELECT command denied to user 'userlimit'@'localhost' for table 'loturi'

How remove a lot of mail from mailq with few cli comands.

Hello,

We have a lot of mail with errors like:

D7AF9121256 34341 Tue Nov 21 11:19:27 MAILER-DAEMON ……….

We want to remove them.

First commands:

mailq | grep MAILER-DAEMON | awk ‘{ print $1 }’ > /root/mailq-201711.txt

Here we catch the ID like D7AF9121256 each mail and save in file /root/mailq-201711.txt.

cat /root/mailq-201711.txt

F0DFF124FDB*
D79941257D6*
75668125191*
5879A1256F4*
4A9DB124CA3*
489E6124A01*
C7DC9124A8A*
3EE891252EC*
7E956125735*
69B0E124DAA*
58F9E12535D*
8DBF71255A0*
8D633125035*
08A411254DE*
549C9124902*
8144B12537B*
D927512497A*
6606C125774*
E09BA125439*
538091259BD*
1F749125973*
8A9CB1255DC*
1D949124DD7*
13B1812546E*

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!

Config for Samba to allow login Windows XP

Today I found a solution for Samba 4.6.2 in Centos 7.4 for all versions of Windows from 7 upwards are able to connect less Windows XP.

Word in smb.conf

lanman auth = yes
ntlm auth = yes

That’s how the config looks:

[global]
workgroup = SAMBA
server string = Samba
netbios name = Samba
interfaces = 192.168.22.250/24 192.168.0.250/24
hosts allow = 127. 192.168.22. 192.168.0.
max protocol = SMB2
socket options = TCP_NODELAY
read raw = no
log file = /var/log/samba/log.%m
max log size = 500

lanman auth = yes
ntlm auth = yes

security = user
map to guest = bad user

passdb backend = tdbsam

local master = yes
os level = 255
preferred master = yes
printing = cups
printcap name = cups
load printers = no
cups options = bsd

I think this information will help you if you have Windows XP computers on your network.

Roundcube add Context Menu plugins

Today I found a new plugins for Roundcubemail: “Context Menu”.

How to add:

cd /var/www/html/roundcubemail/plugins
GIT_SSL_NO_VERIFY=true git clone https://github.com/JohnDoh/Roundcube-Plugin-Context-Menu.git contextmenu
chown -R root.apache contextmenu
chmod -R o-rx contextmenu

Go to config.inc.php and activate plugins:
vim config/config.inc.php

// List of active plugins (in plugins/ directory)
$config['plugins'] = array('archive','zipdownload','managesieve','contextmenu');

And ready !

SteemIT tips

A few tips for exponential growth

The content you publish stays in the new feed only for a few seconds – no matter if you are old on the platform or not. You need to get more active followers. To do that, begin writing by having in mind some of the below advices:

1. Write an introduction post about yourself. Use for it the tags #introduceyourself and #steemit to gain more visibility.
2. The title, the first photo and first phrase will make the followers to read your post or not. Pay attention to them.
3. Emotions. Keep in mind that people react to emotions. Choose wisely your words – you might be surprised. This is a social media platform, so originality, creativity and emotions are key factors for your success.
4. Do not copy-paste content – it doesn’t bring a lot of followers and you might also get flagged for plagiarism unless you mention the source.
5. Tags. Select correctly the tags and use all 5 options allowed – you need to become visible. Use the main category that fits your article (e.g. use animals instead of dogs – if you’re article is about a dog, nature instead of landscapes etc).
6. Follow people who share similar interests with you. Do not ask people to follow you. Most probably, they won’t do it and even if they will press follow, they won’t upvote/promote your posts if they have different views/passions/writing style. You can also get flagged for this kind of behavior.
7. Write about things you really like rather than articles about stuffs that are trendy. You will put a lot more passion in it and people will notice that fact.
You need to build relationships. The more you get involved, the easier will be to get on top. Upvote, comment, resteem and follow others.
Join some challenges on the platform – there are quite a few interesting ones at the moment.
8. Last, but not least – enjoy being here. It’s a great community with a huge potential. Good things will come for those who are tenacious.

This post it is just for myself to remember rule !

Imapsync script or How to move more email account easy.

Today I will post a script that show you how to move easy more email account from old mail server to new server.
The story: We have have many account and we now details about every account ( user and password ).

The script

#!/bin/bash
# Example for imapsync massive migration on Unix systems.
# 
# Data is supposed to be in file.txt in the following format
# user001_1;password001_1;user001_2;password001_2
#
# Do not forget to put absolute path
#
# Separator is character semi-colon ; it can be changed
# by any character changing IFS=';'
# Each data line contains 4 columns, columns are 
# parameters for --user1 --password1 --user2 --password2
#
# Replace "imap.server1.org" and "imap.server2.org" 
# with your own hostname values. 
 
# This loop will also create a log file called 
# LOG/log_${u2}_$NOW.txt for each account transfer
# where u2 is just a variable containing the user2 
# account name, and NOW is the current date_time

mkdir -p LOG
 
{ while IFS=';' read  u1 p1 u2 p2
    do 
         { echo "$u1" | egrep "^#" ; } > /dev/null && continue
         NOW=`date +%Y_%m_%d_%H_%M_%S` 
         echo syncing to user "$u2"
         imapsync --host1 imap.server1.org -addheader  --user1 "$u1" --password1 "$p1" \
                  --host2 imap.server2.org --user2 "$u2" --password2 "$p2" \
                  > LOG/log_${u2}_$NOW.txt 2>&1
    done 
} < /etc/rc.d/file.txt
### Do not forget to put absolute path to your file "file.txt" or what ever you name it.

Example for file.txt. ( I put diferent example of user and password )

user001_1;password001_1;user001_2;password001_2
user011_1;password011_1;user022_3;password003_4
sales;passwSals34;sales@ceae.info;passSale7634 

Hope will help you this page!