Error in SMTP

i got this error when sending any email to any email address:









this is /usr/local/cwpsrv/var/services/roundcube/logs/errors.log:

Code: [Select]

[02-Nov-2024 17:37:08 Etc/UTC] PHP Fatal error:  Uncaught Error: Undefined class constant 'MYSQL_ATTR_FOUND_ROWS' in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/db/mysql.php:149
Stack trace:
#0 /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php(152): rcube_db_mysql->dsn_options()
#1 /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php(138): rcube_db->conn_create()
#2 /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php(230): rcube_db->dsn_connect()
#3 /usr/local/cwpsrv/var/services/roundcube/program/include/rcmail_utils.php(45): rcube_db->db_connect()
#4 /usr/local/cwpsrv/var/services/roundcube/program/include/rcmail_utils.php(111): rcmail_utils::db()
#5 /usr/local/cwpsrv/var/services/roundcube/bin/update.sh(174): rcmail_utils::db_update()
#6 {main}
  thrown in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/db/mysql.php on line 149
[02-Nov-2024 17:53:38 +0000]: <1aohg1nh> DB Error: [1146] Table 'roundcube.carddav_migrations' doesn't exist (SQL Query: SELECT `filename` FROM carddav_migrations) in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 543 (GET /?_autologin=1&sess=ZXlKMWMyVnlJam9pYVc1bWIwQm1iM0p6WVc1b2IzUmxiSE11YzJFaUxDSndZWE56SWpvaU9HUXdOakZsTURSaE1qWTFJaXdpYUc5emRDSTZJbXh2WTJGc2FHOXpkQ0lzSW1OM2NGOXpaWE56YVc5dUlqb2lObU15TlRGaE9XTXdPV05qTldNME9ESTRabVpoTVRGbFkyTmhZMlkzWkRNaWZRPT0=)
[02-Nov-2024 17:53:55 +0000]: <1aohg1nh> PHP Error: Invalid response code received from server (POST /?_task=mail&_unlock=loading1730570035163&_framed=1&_lang=en_US&_action=send)
[02-Nov-2024 17:53:55 +0000]: <1aohg1nh> SMTP Error: Failed to add recipient 'me@te.com'. 4.3.0 <me@te.com>: Temporary lookup failure (Code: 451) in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube.php on line 1702 (POST /?_task=mail&_unlock=loading1730570035163&_framed=1&_lang=en_US&_action=send)
[02-Nov-2024 17:54:13 +0000]: <1aohg1nh> PHP Error: Invalid response code received from server (POST /?_task=mail&_unlock=loading1730570053076&_framed=1&_lang=en_US&_action=send)
[02-Nov-2024 17:54:13 +0000]: <1aohg1nh> SMTP Error: Failed to add recipient 'me@te.com'. 4.3.0 <me@te.com>: Temporary lookup failure (Code: 451) in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube.php on line 1702 (POST /?_task=mail&_unlock=loading1730570053076&_framed=1&_lang=en_US&_action=send)
[03-Nov-2024 18:52:42 +0000]: <eltocub7> PHP Error: Invalid response code received from server (POST /?_task=mail&_unlock=loading1730659962227&_framed=1&_lang=en_US&_action=send)
[03-Nov-2024 18:52:42 +0000]: <eltocub7> SMTP Error: Failed to add recipient 'test@test.com'. 4.3.0 <test@test.com>: Temporary lookup failure (Code: 451) in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube.php on line 1702 (POST /?_task=mail&_unlock=loading1730659962227&_framed=1&_lang=en_US&_action=send)

This is Maillog :

Code: [Select]

Nov  3 20:12:26 panel postfix/pickup[274507]: AF0A116071B: uid=0 from=<root>
Nov  3 20:12:26 panel postfix/cleanup[276767]: AF0A116071B: message-id=<20241103191226.AF0A116071B@panel.forsanhotels.sa>
Nov  3 20:12:26 panel postfix/proxymap[274310]: warning: mysql:/etc/postfix/mysql-virtual_alias_default_maps.cf is unavailable. unsupported dictionary type: mysql
Nov  3 20:12:26 panel postfix/cleanup[276767]: warning: proxy:mysql:/etc/postfix/mysql-virtual_alias_default_maps.cf lookup error for "leebrimlow@gmail.com"
Nov  3 20:12:26 panel postfix/cleanup[276767]: warning: AF0A116071B: virtual_alias_maps map lookup problem for leebrimlow@gmail.com -- message not accepted, try again later
Nov  3 20:12:26 panel postfix/proxymap[274310]: warning: mysql:/etc/postfix/mysql-virtual_vacation.cf is unavailable. unsupported dictionary type: mysql
Nov  3 20:12:26 panel postfix/cleanup[276767]: warning: proxy:mysql:/etc/postfix/mysql-virtual_vacation.cf lookup error for "leebrimlow@gmail.com"
Nov  3 20:12:26 panel postfix/cleanup[276767]: warning: AF0A116071B: recipient_bcc_maps map lookup problem -- message not accepted, try again later

System info:

According to the provided error logs there is some problem with the databases of roundcube and dovecot/postfix. How did you install roundcube and postfix, dovecot ? Did you install them manually or using CWP ? Did you modified some configs, etc ?

i did not do any configuration, i just installed a new fresh cwp on Almalinux9

I just recommend you to install CWP again on a new fresh system and make sure there are no errors during the installation. Or copy the dovecot's, roundcube's database structure from some live server and recreate mailboxes on the new server.

As an extra step for investigation, check the php libs available for main php version installed on your server. It must support MySQLi, and PDO_mysql.

I posted a small guide on how to do the basic CWP on AL9, if you don't do it correctly things will get corrupted.

Also make sure you don't have MariaDB, PHP, etc installed. Just the minimal install of AL9

I posted a small guide on how to do the basic CWP on AL9, if you don't do it correctly things will get corrupted.

Also make sure you don't have MariaDB, PHP, etc installed. Just the minimal install of AL9

Hi,

please can we have a look at this guide…
secondly, how can there be no MariaDB, PHP, etc installed, but only a minimal installation of AL9,  or do you mean this minimal installation should be done before the installation of CWP?

BR
Venty

You would just use the providers base AlmaLinux 9 install, and then stop and do not install anything (MariaDB, PHP, etc.) before CWP.

If you do will have all kinds of problems that would be unfixable.

Just do the base image, and then see the following that was posted in another thread:
https://forum.centos-webpanel.com/apache/issues-with-brand-new-fresh-install-with-almalinux-9-4/msg49159/#msg49159

Then you will want to upgrade MariaDB from 10.4 to 10.11.
You can see that guide at AlphaGNU or
https://kb.starburstservices.com/control-web-panel-cwp/control-web-panel-cwp-admin-tutorials/upgrade-mariadb-10-x-to-10-11-in-cwp-on-almalinux-9/

Then it just up to you to compile PHP inside CWP to 8.1, 8.2 or 8.3

You would just use the providers base AlmaLinux 9 install, and then stop and do not install anything (MariaDB, PHP, etc.) before CWP.

If you do will have all kinds of problems that would be unfixable.

Just do the base image, and then see the following that was posted in another thread:
https://forum.centos-webpanel.com/apache/issues-with-brand-new-fresh-install-with-almalinux-9-4/msg49159/#msg49159

Then you will want to upgrade MariaDB from 10.4 to 10.11.
You can see that guide at AlphaGNU or
https://kb.starburstservices.com/control-web-panel-cwp/control-web-panel-cwp-admin-tutorials/upgrade-mariadb-10-x-to-10-11-in-cwp-on-almalinux-9/

Then it just up to you to compile PHP inside CWP to 8.1, 8.2 or 8.3

Hi,

Thank you very much for your reply...

Please clarify—when installing CWP on AL 8 and trying to select the combination Nginx, Varnish, and Apache, it turned out that the first two were not installed. The server can only work when the Apache variant is selected.
Are there any installation and configuration requirements for Nginx & Varnish on AL9?

Please also look at the link, it is not active:

https://kb.starburstservices.com/control-web-panel-cwp/control-web-panel-cwp-admin-tutorials/upgrade-mariadb-10-x-to-10-11-in-cwp-on-almalinux-9/

Thanks in advance!
BR
Venty

No, CWP will build Varnish & Nginx in the background.

Checked the link, it is working.

You can also use:
https://www.alphagnu.com/topic/23-upgrade-mariadb-1011-in-cwp-centos-7-centos-8-stream-almalinux-78-rockylinux-78/#comment-25