Roundcubemail 1.6.3 login error after update

Hello all
I'am using Iredmail 1.6.4 pack and recentlly I have decided to upgrade to new Roundcube 1.6.3 after going to my mysql i had an old version :

+-------------------+------------+
| name | value |
+-------------------+------------+
| roundcube-version | 2016112200 |
+-------------------+------------+

after the update of Mysql that was done manually I've changed te system version to the newest :
UPDATE system SET value = 2022081200 WHERE name = 'roundcube-version';

I get this error in my mail.log :
IMAP Error: Login failed for bill AUTHENTICATE LOGIN: A0001 NO [AUTHENTICATIONFAILED]

This is what i got from the dovecot log :

master: Dovecot v2.3.19.1 (9b53102964) starting up for pop3, imap, sieve, lmtp (core dumps disabled)
2023-10-02T11:34:53.343009+02:00 sun dovecot: stats: Error: conn stats-reader (127.0.0.1:48810): didn't reply with a valid VERSION line: EXPORT#011global
2023-10-02T11:34:53.343130+02:00 sun dovecot: stats: Error: conn stats-reader (127.0.0.1:48816): didn't reply with a valid VERSION line: EXPORT#011global
2023-10-02T11:38:14.575927+02:00 sun dovecot: auth: Error: ldap(/etc/dovecot/dovecot-ldap.conf): Connection lost to LDAP server, reconnecting

I have checked mysql integrity of roundcube databse :
mysqlcheck -c roundcubemail -u root -p
mysqlcheck --auto-repair --all-databases -u root -p
All passed OK

My roundcube 1.6.3 config file :

// LOGGING
$config['log_driver'] = 'syslog';
$config['syslog_facility'] = LOG_MAIL;
$config['log_logins'] = true;

// IMAP
$config['imap_host'] = 'ssl://127.0.0.1:993';
$config['imap_auth_type'] = 'LOGIN';
$config['imap_delimiter'] = '/';
// Required if you're running PHP 5.6 or later
$config['imap_conn_options'] = array(
'ssl' => array(
'verify_peer' => false,
'verify_peer_name' => false,
),
);

// SMTP
$config['smtp_host'] = 'ssl://127.0.0.1:465';
$config['smtp_user'] = '%u';
$config['smtp_pass'] = '%p';
$config['smtp_auth_type'] = 'LOGIN';
// Required if you're running PHP 5.6 or later
$config['smtp_conn_options'] = array(
'ssl' => array(
'verify_peer' => false,
'verify_peer_name' => false,
),
);

// Use user's identity as envelope sender for 'return receipt' responses,
// otherwise it will be rejected by iRedAPD plugin `reject_null_sender`.
$config['mdn_use_from'] = true;

// SYSTEM
$config['auto_create_user'] = true;
$config['force_https'] = true;
$config['login_autocomplete'] = 2;
$config['ip_check'] = true;
$config['des_key'] = 'iRsMV8HKKJaljSkgeQvYMqrd';
$config['cipher_method'] = 'AES-256-CBC';
$config['useragent'] = 'Roundcube Webmail'; // Hide version number
$config['username_domain'] = 'erdon.com';
$config['mime_types'] = '/etc/mime.types';
$config['max_message_size'] = '25M';

// USER INTERFACE
$config['create_default_folders'] = true;
$config['quota_zero_as_unlimited'] = true;
$config['spellcheck_engine'] = 'pspell';

// USER PREFERENCES
$config['default_charset'] = 'UTF-8';
//$config['addressbook_sort_col'] = 'name';
$config['draft_autosave'] = 60;
$config['default_list_mode'] = 'list';
$config['autoexpand_threads'] = 2;
$config['check_all_folders'] = true;
$config['default_font_size'] = '12pt';
$config['message_show_email'] = true;
$config['layout'] = 'widescreen'; // three columns
//$config['skip_deleted'] = true;

// PLUGINS
$config['plugins'] = array('managesieve', 'password', 'zipdownload', 'enigma');

 

I do not understand what you have done.
Seems you had Iredmail, removed it and installed Roundcube.
But why do you need to change values in database? If Roundcube install adds entries in database, the install has failed if it has not done so.
It seems dovecot is failing, does it even start? If dovecot is not running, logging in to email box is not possible, I believe.
Anyway, no mention of what OS is involved.

 

Sorry my bad.
I have Iredmail 1.6.4 i just updated roundcube from 1.6.2 to 1.6.3 . Everything stands on Debian 12 with php 8.2-fpm , mariadb , nginx , amavisd is disabled , clamav disabled , nftables active + postfix and dovecot.
I have changed all ittle bit my config in roundcube now it logs to users but it still looks weird in this setup.
I'am trying to setup SSL/TLS config on this server alsow for clients like Outlook or Thunderbird :

Taken from :
/opt/www/roundcubemail-1.6.2/config/config.inc.php

$config['imap_host'] = '127.0.0.1'; // IF I try setting this to ssl:// roundcube login does not work anymore
$config['default_port'] = 993;
$config['imap_auth_type'] = 'LOGIN';
$config['imap_delimiter'] = '/';
// Required if you're running PHP 5.6 or later
$config['imap_conn_options'] = array(
'ssl' => array(
'verify_peer' => false,
'verify_peer_name' => false,
),
);

// SMTP
$config['smtp_host'] = 'ssl://127.0.0.1';
$config['default_port'] = 465;
$config['smtp_user'] = '%u';
$config['smtp_pass'] = '%p';
$config['smtp_auth_type'] = 'LOGIN';
// Required if you're running PHP 5.6 or later
$config['smtp_conn_options'] = array(
'ssl' => array(
'verify_peer' => false,
'verify_peer_name' => false,

My current postfix configuration is attached :

 

Why?
Does Iredmail support having components it maintains upgraded?

 

They released the new 1.6.5 ver of redmail wich has roundcube 1.6.3 and since i only needed roundcube to be updated that's what i have done. What about my config from postfix any suggestions there how to setup SSL/TLS.

 

Does iRedmail version 1.6.4 support Roundcube 1.6.3?
iRedmail docs seem to have info on how to upgrade Roundcube, did you follow those? Looks like the instructions are for upgrading Roundcube when doing upgrade of iRedmail, though.

My understanding is SSL should not be used for 127.0.0.1 or localhost, verifying localhost is localhost would not help much. And https certificates do not verify IP-addresses anyway.
I do not know iRedmail, and I let ISPConfig maintain postfix, dovecot and roundcube. If I were you, I would leave Roundcube as is, or if it must be upgraded do it with iRedmail Upgrade.
iRedmail forum may be more knowledgeable in these matters, you may get better help there.

 

Thanks for the pointers about SSL