Can I reinstall/install webmail/rouncoube?

Community Support Mail
1

Can I reinstall/install webmail/rouncoube? When I install I forgot to enable mail support :frowning:

2

I find v-add-sys-roundcube, but I get error ā€œERROR: Mysql not available. Installation abortedā€ (I use postgresql)

3

Roundcube uses by default mysql database. It should be possible to use Postgresql instead (Feel free to create Postgresql support if mysql is missing) but the the little use of only PostgreSQL we voted against.

If you didnā€™t add mail system you also probally donā€™t have exim / dovecot installed. The best way is probally do a clean install

4

exim is installed (its good news :)), but rouncoube not installed, now I try to install mysql-server, but when I run v-add-sys-roundcube I continue see same error ā€œERROR: Mysql not available. Installation abortedā€, maybe I should do something else?(

5

Install mysql server and then run v-add-database-host mysql root password

6

is it ok, that mysql is 8 version?

7

We install by default MariaDB 10.6 Mysql should probally work fine but not testedā€¦

8

thanks for fast response)

try to execute v-add-database-host, but see this error :frowning:
root@localhost:/usr/local/hestia/conf# v-add-database-host mysql localhost root password
Error: mysql type is invalid

9

Uncomment hestiacp/v-add-database-host at 035eb154cfbc116162f73abb3c08441c1f14ae80 Ā· hestiacp/hestiacp Ā· GitHub

And it should be working fine

Or locate in /usr/local/hestia/conf/hestia.conf the option: DB_SYSTEM

And then add ,mysql to itā€¦

10

I comment v-add-database-host and run v-add-sys-roundcube

now I see errors in /var/log/roundcube/errors.log

as I understand - I should install php-mysql ext, is it native apt-get install scenario?

Stack trace:
#0 /var/lib/roundcube/program/lib/Roundcube/rcube_db.php(152): rcube_db_mysql->dsn_options()
#1 /var/lib/roundcube/program/lib/Roundcube/rcube_db.php(138): rcube_db->conn_create()
#2 /var/lib/roundcube/program/lib/Roundcube/rcube_db.php(230): rcube_db->dsn_connect()
#3 /var/lib/roundcube/program/lib/Roundcube/rcube_db.php(416): rcube_db->db_connect()
#4 /var/lib/roundcube/program/lib/Roundcube/rcube_db.php(379): rcube_db->_query()
#5 /var/lib/roundcube/program/lib/Roundcube/session/db.php(105): rcube_db->query()
#6 [internal function]: rcube_session_db->read()
#7 /var/lib/roundcube/program/lib/Roundcube/rcube_session.php(136): session_start()
#8 /var/lib/roundcube/program/lib/Roundcube/rcube.php(477): rcube_session->start()
#9 /var/lib/roundcube/program/include/rcmail.php(487): rcube->session_init()
#10 /var/lib/roundcube/program/include/rcmail.php(103): rcmail->session_in in /var/lib/roundcube/program/lib/Roundcube/db/mysql.php on line 149
[02-Nov-2021 13:42:57 Etc/UTC] PHP Warning:  session_start(): Failed to read session data: user (path: /var/lib/php/sessions) in /var/lib/roundcube/program/lib/Roundcube/rcube_session.php on line 136
[02-Nov-2021 13:42:57 Etc/UTC] PHP Fatal error:  Uncaught Error: Undefined class constant 'MYSQL_ATTR_FOUND_ROWS' in /var/lib/roundcube/program/lib/Roundcube/db/mysql.php:149