Control Web Panel

WebPanel => Postfix => Topic started by: AnatolS on November 29, 2020, 10:30:44 PM

Title: No "postfix" database, CWP7, MariaDB, Centos 7
Post by: AnatolS on November 29, 2020, 10:30:44 PM
Hi,
I have spent hours on googling and reading topics, but could not find an answer. Really hope on your help.
Problem.
After installing CWP7 on Centos 7 LAMP, I got errors that "postfix" database does not exist when log in to the CWP.
 
I tried to rebuild mailserver from CWP interface. The rebuild went well but the MySQL "postfix" database was not created. As a result, I can't create any email accounts - CWP7 under "Email accounts" shows mysql errors:

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

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

Do I need to add "postfix" DB manually and all the required tables manually?
Thank you very much for any advice

PHP version: 5.6.37
MySQL version: 5.5.68-MariaDB
Distro Name: CentOS Linux release 7.8.2003 (Core)
Title: Re: No "postfix" database, CWP7, MariaDB, Centos 7
Post by: cinique on November 30, 2020, 12:36:24 AM
Quote
..After installing CWP7 on Centos 7 LAMP..
You didn't bother to read the installation instructions!
Clean, minimal ISO.
Title: Re: No "postfix" database, CWP7, MariaDB, Centos 7
Post by: AnatolS on November 30, 2020, 01:06:01 PM
Quote
..After installing CWP7 on Centos 7 LAMP..
You didn't bother to read the installation instructions!
Clean, minimal ISO.
Do you mean to reinstall the CWP to lower version 6? Is there any way around? I have already installed and conducted Apache, Tomcat, Pistgresql and other things..
In the instruction it is written that CWP7 is supported for Centos7.
Thank you
Title: Re: No "postfix" database, CWP7, MariaDB, Centos 7
Post by: cinique on November 30, 2020, 04:24:46 PM
Quote
..After installing CWP7 on Centos 7 LAMP..
You didn't bother to read the installation instructions!
Clean, minimal ISO.
Do you mean to reinstall the CWP to lower version 6? Is there any way around? I have already installed and conducted Apache, Tomcat, Pistgresql and other things..
In the instruction it is written that CWP7 is supported for Centos7.
Thank you
Better stick with shared hosting.  ::)
Title: Re: No "postfix" database, CWP7, MariaDB, Centos 7
Post by: AnatolS on November 30, 2020, 05:50:00 PM
Quote
..After installing CWP7 on Centos 7 LAMP..
You didn't bother to read the installation instructions!
Clean, minimal ISO.
Do you mean to reinstall the CWP to lower version 6? Is there any way around? I have already installed and conducted Apache, Tomcat, Pistgresql and other things..
In the instruction it is written that CWP7 is supported for Centos7.
Thank you
Better stick with shared hosting.  ::)

Sorry, but what fo you mean by “clean”, clean what ?  Thank you for clarifying ;
Title: Re: No "postfix" database, CWP7, MariaDB, Centos 7
Post by: AnatolS on November 30, 2020, 09:14:55 PM
Minimal ISO - you mean CentOS blank (not LAMP)?
Clean - you mean yum clean all or?
Thank you
Title: Re: No "postfix" database, CWP7, MariaDB, Centos 7
Post by: cinique on November 30, 2020, 10:14:36 PM
Spoon feeding (again!)
https://control-webpanel.com/installation-instructions#step2
Title: Re: No "postfix" database, CWP7, MariaDB, Centos 7
Post by: AnatolS on December 01, 2020, 12:00:49 AM
Spoon feeding (again!)
https://control-webpanel.com/installation-instructions#step2
I saw that, but I asked a concrete question, why can’t you just tell what do you call “minimal”? NOTHING is said about this definition in your instructions.. Hosting provider supports both “black” and LAMP version. Do you mean that I would not install CentOS offered from hosting provider but instead to do it by myself according to the instruction?

And whet do you mean by “clean”? CWP, the whole CentOS of just MariaDB?
Sorry to bother you, but hope you can give a normal reply.
Title: Re: No "postfix" database, CWP7, MariaDB, Centos 7
Post by: cinique on December 01, 2020, 12:29:33 AM
You have a real problem with English..
Quote
3. Software Requirements

You must have a clean/fresh installation of supported operating systems:

    CentOS 6, RedHat 6 or CloudLinux 6, MINIMAL installation and English version only!
    CentOS 7 is also supported, we recommend a minimal version. (recommended)
...
Download CentOS 7.x – 64bit (minimal) (recommended)
Talk to your hosting provider and ask them about shared hosting.  ::)
Title: Re: No "postfix" database, CWP7, MariaDB, Centos 7
Post by: studio4host on December 02, 2020, 08:45:55 PM
minimal is OS without any packages installed...you need only core CentOS without any webservers or SQL databases as this all will be installed and configured by CWP
Title: Re: No "postfix" database, CWP7, MariaDB, Centos 7
Post by: AnatolS on December 02, 2020, 08:59:20 PM
Thank you for a clear answer. I will reinstall CentOS and CWP
Title: Re: No "postfix" database, CWP7, MariaDB, Centos 7
Post by: Hardoman on December 07, 2020, 10:42:19 AM
I had the same issue because I was installing it to the server with MariaDB already and Db was not created.
But I have created all of the DB tables myself, assigned postfix account permissions and it worked perfectly well.

Which tables to create I just took from conf files of postfix.
Title: Re: No "postfix" database, CWP7, MariaDB, Centos 7
Post by: AnatolS on December 07, 2020, 01:19:22 PM
Yes, I was thinking to do the same. Dud you find the tables structure as well in the configs? Did you also import any data in it? Thank you!
Title: Re: No "postfix" database, CWP7, MariaDB, Centos 7
Post by: Hardoman on December 09, 2020, 08:52:30 AM
No, I didn't import any data, just created tables.
The names of the tables I took from conf file - it was mentioned there which tables it queries.

Attach it for your reference.
(https://ipnets.ru/postfix_db.png)