Unable to login to Roundcube: PHP Error: Failed to create a user record.

Error found in error logs:

[28-Nov-2018 14:14:25 +0200]: <4d284o3h> DB Error: [1364] Field 'alias' doesn't have a default value (SQL Query: INSERT INTO `users` (`created`, `last_login`, `username`, `mail_host`, `language`) VALUES (now(), now(), 'microsoft@orsharlogistic.ro', 'localhost', 'en_US')) in /var/www/html/roundcubemail-1.0.3/program/lib/Roundcube/rcube_db.php on line 543 (POST /?_task=login&_action=login)
[28-Nov-2018 14:14:25 +0200]: <4d284o3h> PHP Error: Failed to create new user in /var/www/html/roundcubemail-1.0.3/program/lib/Roundcube/rcube_user.php on line 686 (POST /?_task=login&_action=login)
[28-Nov-2018 14:14:25 +0200]: <4d284o3h> PHP Error: Failed to create a user record. Maybe aborted by a plugin? in /var/www/html/roundcubemail-1.0.3/program/include/rcmail.php on line 650 (POST /?_task=login&_action=login)

List from useres table in roundcube database.
MariaDB [roundcube]> describe users;
| Field | Type | Null | Key | Default | Extra |
| user_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| username | varchar(128) | NO | MUL | NULL | |
| mail_host | varchar(128) | NO | | NULL | |
| alias | varchar(128) | NO | MUL | NULL | |
| created | datetime | NO | | 1000-01-01 00:00:00 | |
| last_login | datetime | YES | | NULL | |
| language | varchar(5) | YES | | NULL | |
| preferences | text | YES | | NULL | |
| failed_login | datetime | YES | | NULL | |
| failed_login_counter | int(10) unsigned | YES | | NULL | |

Solutions: Remove alias column from users table.

Connect database:
mysql -u root -p

Use database you need to make change:
MariaDB [(none)]> use roundcube;

Alter table users;
ALTER TABLE roundcube.users DROP COLUMN roundcube.users.alias;

Now problem solved !


Source: https://support.plesk.com/hc/en-us/articles/360005898674-Unable-to-login-to-Roundcube-PHP-Error-Failed-to-create-a-user-record

How to remove domain from letsencrypt ?

Q:  Do you have a domain that you want to remove from the list of certificates with letencrypt?

Answer: Simple deletion from the list

certbot delete --cert-name domain.com

If you get error:
No certificate found with name blog.ceae.info (expected /etc/letsencrypt/renewal/blog.ceae.info.conf)

Use next command:

certbot delete --cert-name blog.ceae.info-0001

Free SSL for web, easy way !

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
cancel): postmaster@your-domain.com
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
(A)gree/(C)ancel: A

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
“certbot renew”
– 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.

SSLEngine On
SSLCertificateFile /etc/letsencrypt/live/webmail.your-domain.com/fullchain.pem
SSLCertificateKeyFile /etc/letsencrypt/live/webmail.your-domain.com/privkey.pem
ServerAdmin postmaster@your-domain.com
ServerName webmail.your-domain.com
DocumentRoot /var/www/html/roundcubemail
CustomLog /var/log/httpd/webmailssl_access.log common
ErrorLog /var/log/httpd/webmailssl_error.log

and restart you apache server:  systemctl restart httpd

Frecvente utilizate în Romania de operatorii de telefonie mobila!

Care sunt frecvențele utilizate de Orange România pentru retelele 2G, 3G si 4G ?

2G = 900 Mhz / 1800 Mhz
3G = 2100 Mhz / 900 Mhz
4G = 800 Mhz / 1800 Mhz / 2600 Mhz. Sursa

Care sunt frecventele pentru Vodafone ?
3G:900 si in orasele mari 2100
4G:800 și 1800 (mai ales 1800 ) [ 4G/LTE in benzile 3 si 20 (1800/800 Mhz). ]

Care sunt frecventele pentru Telekom ?
2G = 900 si 1800
3G = 900 și 2100
4G = 800, 900 și 1800

Care sunt pentru Digi ?
3G = 900Mhz si 2100Mhz
4G = banda 1 2100 Mhz FDD, banda 38 2600 Mhz TDD

O poza cu benzile în 4G în Romania, update 24.05.2018.

Network 4G Romania
Network 4G Romania

Redirect your visitors to SSL webpage!


After we’ve been able to get a free SSL certificate for our page now, we need to redirect to the SSL page.
According to Apache, the best way is to avoid using mod_rewrite !

< VirtualHost *:80 >
ServerName webmail.biotree.tk
Redirect "/" "https://webmail.biotree.tk/"
< /VirtualHost >

< VirtualHost *:443 >
    ServerName webmail.biotree.tk
    # ... SSL configuration goes here
< /VirtualHost >

I think this is the easiest way to redirect SSL from a non-SSL page.

How to activate Steempress plugin in WordPress !

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.

I wish you an excellent day!

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
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)

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 !

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 !