Author Topic: Sql errors in email->email routing->domain  (Read 1464 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Sql errors in email->email routing->domain
« on: March 04, 2024, 11:56:55 AM »
Hi,
i made a fresh install of cwp on an lxc vm.
After a couple of days of testing all seem fine exept one thing.
When i go to email->email routing->domain in admin interface some sql errors araise:


Code: [Select]
Email Routing (remote/local)
Here you can change the email routing to remote or local exchanger.
By selecting remote Exchanger emails will be forwarded to the internet for that domain.

Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0

Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0


Offline
*****
Re: Sql errors in email->email routing->domain
« Reply #1 on: March 06, 2024, 06:25:19 PM »
what version of mariadb are you running?

Offline
*
Re: Sql errors in email->email routing->domain
« Reply #2 on: March 11, 2024, 04:30:09 PM »
Apache version: Apache/2.4.57
PHP version: 7.3.31
MySQL version: 10.4.33-MariaDB
FTP version: 1.0.49
MySql Port: 3306
Web Servers: apache-only

CWPpro version: 0.9.8.1176 | CWP Secure Kernel:Active

Distro Name: CentOS Stream release 8
Kernel Version: 5.13.19-3-pve
Platform: x86_64 lxc
« Last Edit: March 11, 2024, 04:32:55 PM by maudam »

Offline
*****
Re: Sql errors in email->email routing->domain
« Reply #3 on: March 11, 2024, 08:44:50 PM »
If you're doing a fresh install, don't use CentOS Stream, use AlmaLinux 8. It offers the best basis and path forward for EL8 and EL9.

Offline
*
Re: Sql errors in email->email routing->domain
« Reply #4 on: March 11, 2024, 10:41:32 PM »
I followed CWP install instructions.
https://control-webpanel.com/installation-instructions#step2

In software requirements centos 8 stream is recommended

Code: [Select]
CWP-CentOS 8 MINIMAL or BOOT Stream-Delayed. (RECOMMENDED LATEST)

We have our custom repositories making CentOS 8 Stream a stable version. More Info
CentOS 8 Stream MINIMAL or BOOT

Direct installation or converted from CentOS 8 Linux. (Recommended)

Should i make a new fresh install on Alma or Rocky ?



Offline
*****
Re: Sql errors in email->email routing->domain
« Reply #5 on: March 12, 2024, 01:43:07 AM »
AlmaLinux 8 will give you the best foundation for a new server. (The CentOS Stream recommendation in the CWP documentation was because that's all there was at the time -- better options are available now.)

Offline
*
Re: Sql errors in email->email routing->domain
« Reply #6 on: March 12, 2024, 01:15:28 PM »
Well, i followed your advice and installed CWP on alma 8.
The mysql error on mail routing is still there.
Bug in CWP ?

This forum is under monitoring by CWP staff ? Of i have to file a bug ?




« Last Edit: March 12, 2024, 01:17:10 PM by maudam »

Offline
*****
Re: Sql errors in email->email routing->domain
« Reply #7 on: March 12, 2024, 02:05:52 PM »
I've used the e-mail routing (local/remote exchanger) feature under CentOS 7.9 -- no errors w/MariaDB 10.4, 10.6, 10.11. Starburst -- how does it look in AlmaLinux?

I would suggest updating MariaDB to the latest LTS version 10.11. Follow this guide, but change the version # to 10.11:
http://wiki.centos-webpanel.com/mariadb-upgrade-to-new-version

Offline
*
Re: Sql errors in email->email routing->domain
« Reply #8 on: March 15, 2024, 06:56:41 PM »
I made a fresh install on centos 7.9 to test
Same errors. I think something in php code is wrong. It shouldn't be a problem in mariadb/mysql.
Looking at errors the mysql functions, the functions expects some values and don't receive them by php code.
I filed a bug report.

Thanks