Control Web Panel

WebPanel => CentOS-WebPanel GUI => Topic started by: maudam on March 04, 2024, 11:56:55 AM

Title: Sql errors in email->email routing->domain
Post by: maudam 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


Title: Re: Sql errors in email->email routing->domain
Post by: overseer on March 06, 2024, 06:25:19 PM

what version of mariadb are you running?

Title: Re: Sql errors in email->email routing->domain
Post by: maudam 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

Title: Re: Sql errors in email->email routing->domain
Post by: overseer 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.

Title: Re: Sql errors in email->email routing->domain
Post by: maudam 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 ?

Title: Re: Sql errors in email->email routing->domain
Post by: overseer 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.)

Title: Re: Sql errors in email->email routing->domain
Post by: maudam 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 ?

Title: Re: Sql errors in email->email routing->domain
Post by: overseer 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 (http://wiki.centos-webpanel.com/mariadb-upgrade-to-new-version)

Title: Re: Sql errors in email->email routing->domain
Post by: maudam 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