Allow user changes their password in RoundCube webmail
Khanh is a full stack web developer with over 15 years of experience developing for the web
Search for a command to run...
Khanh is a full stack web developer with over 15 years of experience developing for the web
No comments yet. Be the first to comment.
Elevate your bus reservation experience (or even movie, theater, train, ship, plane tickets) with the React Bus Seat Map Picker – a sophisticated and meticulously crafted script designed exclusively for bus seat bookings. Engineered with strict TypeS...

In previous blog, I migrated all posts from my WordPress to Hashnode at https://blog.donamkhanh.com. Now I create a simple landing page for my main domain and hosted on Github Page. You can access at https://donamkhanh.com. In feature, I'm going to h...

I just finished migrating my blog from Wordpress (self hosted on DigitalOcean) to Hashnode. How did I migrate? I don't have too many articles on Wordpress but I don't like doing it manually so the first thing I did was look to see if there was an aut...

Dự án mình đang làm có yêu cầu sử dụng Azure Active Directory (AAD) để lưu trữ thông tin người dùng & xác thực đăng nhập các kiểu. Ngoài các trường thông tin cơ bản mà AAD hỗ trợ ra thì dự án mình cần lưu thêm 1 số thông tùy chọn khác cho người dùng....

Introduction This is a concise front-end application developed with Angular. You can create a beautiful form with drag and drop visualization. You can get inspiration from it to make a draggable form; at the same time, you can also modify it to suit ...

After installed RoundCube for my customer, they asked: user can change their own password
To do this, we have to enable password plugin of RoundCube
cd plugins/password
cp config.inc.php.dist config.inc.php
nano config.inc.php
Set $rcmail_config['password_driver'] = 'sql';
Save file
cd ../config
nano main.inc.php
Find the line $rcmail_config['plugins'] = array(); and change to $rcmail_config['plugins'] = array( 'password');
Save file
If you finish 9 steps above and access to RoundCube, you will see the Password tab in Settings section. However, you maybe meet the error:
[1305] FUNCTION xxx_roundcube.update_passwd does not exist (SQL Query: SELECT update_passwd('', '@'))
The simplest way is modify password_query:
Find $rcmail_config['password_query'] in plugins/password/config.inc.php
Change $rcmail_config['password_query'] = 'SELECT update_passwd(%c, %u)'; to $rcmail_config['password_query'] = 'UPDATE zpanel_postfix.mailbox SET password=CONCAT(\'{PLAIN-MD5}\',MD5(%p)) WHERE username=%u AND password=CONCAT(\'{PLAIN-MD5}\',MD5(%o)) LIMIT 1';
All done!