Webmail database error

localhost · June 22, 2022, 9:33am

All panels already update to 1.6.0 but in one of these all working fine but when try to acces to roundcube i get this error…

In logs don’t say nothing about it

eris · June 22, 2022, 9:42am

In /etc/roundcube/config.inc.php

Should contain a line like:

$config[‘db_dsnw’] = ‘mysql://roundcube:[email protected]/roundcube’;

Where is xxxxxxx is the password

Try login in with its via phpmyamdmin or mysql -u roundcube -p

localhost · June 22, 2022, 9:52am

thnx master,
i get this, maybe about privilegies? i change password and can acces but roundcube url still getting error database …

eris · June 22, 2022, 10:29am

Following command does create the database user:

github.com

hestiacp/hestiacp/blob/2ab11ee2ac32cbdb274148db6bf54896f7b0a7d5/bin/v-add-sys-roundcube#L138-L148

      
        
            if [ ! -z "$(echo "$DB_SYSTEM" | grep -w 'mysql')" ]; then
                mysql -e "DROP DATABASE IF EXISTS roundcube"
                mysql -e "DROP USER IF EXISTS [email protected]"
                mysql -e "CREATE DATABASE roundcube"
                # Mysql available on system
                r=$(generate_password)
                mysql -e "GRANT ALL ON roundcube.*
                 TO [email protected] IDENTIFIED BY '$r'"
                sed -i "s/%password%/$r/g" $RC_CONFIG_DIR/config.inc.php
                mysql roundcube < /var/lib/roundcube/SQL/mysql.initial.sql
            fi

localhost · June 22, 2022, 11:16pm

many thanks máster