Trying out phpmyadmin/roundcube manual install and rainloop

Community Support Mail
1

So I thought I’d try out the new webmail and phpmyadmin enhancements. Here are my thoughts.

PHPmyadmin manual upgrade
No problems at all. Just ran /usr/local/hestia/install/upgrade/manual/migrate_phpmyadmin.sh
A couple of notes:

  • If you’ve changed the default URL for your database from phpmyadmin (a good idea!), then you’ll have to run this change again in Hestia control panel
  • If you altered your apache config to eg require a password for access, you’ll have to do it again in /etc/apache2/conf.d/phpmyadmin.conf this might be especially important because …
  • Previously root access to the database was forbidden. On this new install it is allowed.

Roundcube manual upgrade.
Ran /usr/local/hestia/install/upgrade/manual/migrate_roundcube.sh

  • Unlike the phpmyadmin upgrade, no backup was made. You might like to do this yourself first.
  • Post upgrade webmail initially failed to load: just got a white screen. After clearing browser cache, restarting apache, nginx, it came back. Not sure which fixed it, probably just a browser cache thing.
  • The install seemed to be missing an .htaccess file. There was a dangling symlink in /var/lib/roundcube/public_html linking to /var/lib/roundcube/.htaccess . I had to create that file and I filled it with the same contents as my previous one from /etc/roundcube/htaccess. In my case this also had an apache basic auth stanza to limit access.
  • I’ll need to reinstall the extra plugins I installed. In my case this was a carddav plugin.

Adding Rainloop
Ran v-add-sys-rainloop which finished with astonishing speed. Changed it as default mail client on the mail domain configuration page. Looks OK.

  • Not massively different to roundcube in functionality, although it does have a carddav function built in. But I couldn’t get that to work. Trying to sync it with my nextcloud install just gave an unhelpful error.
  • Was trying to figure out what was going on, and discovered that there’s an admin login for rainloop. The credentials are dumped in the /root/.rainloop file. However I couldn’t log into the admin panel with them. Supposedly you just add ?admin to the webmail URL. Anyone figured this out?
2

Think I figured out the rainloop problem. In rainloops application.ini file hidden in some crazy subdirectories in /etc/rainloop/ the database connection host is given as 127.0.0.1
Looking in mysql.user the Host value for the rainloop user is localhost. So changing 127.0.0.1 to localhost in the application.ini file, seems to have allowed the connection to take place. I can now sync contacts, but it is quite slow and keeps timing out. But it will get there in the end.

3

per Discord

in regards to the rainloop admin log-in…

Jaap Marcus — Yesterday at 5:49 AM
You have both installed at the same time
[5:49 AM]
Only 1 active per domain but you can set prefernce
[5:50 AM]
After install go to /root/ and you find a .rainloop file with username / password / path of the admin “account” of rainloop
[5:51 AM]
Some thing like:
Username: admin_f0e5a5fc
Password: D0ung4naLOptu1fr
Secret key: admin_f0e5a5fc

Isaac — Yesterday at 5:58 AM
what do to do with the admin account credentials then?

Jaap Marcus — Yesterday at 6:00 AM
https://webmail.domain.com/?admin_f0e5a5fc login with username / password

3 Likes
4

https://docs.hestiacp.com/admin_docs/mail.html#can-i-login-into-the-backend-of-rainloop

2 Likes
5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.