No "postfix" database, CWP7, MariaDB, Centos 7

Started by AnatolS, November 29, 2020, 10:30:44 PM

Previous topic - Next topic

AnatolS

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)

cinique

Quote..After installing CWP7 on Centos 7 LAMP..
You didn't bother to read the installation instructions!
Clean, minimal ISO.

AnatolS

Quote from: cynique 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.
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

cinique

Quote from: AnatolS on November 30, 2020, 01:06:01 PM
Quote from: cynique 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.
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.  ::)

AnatolS

Quote from: cynique on November 30, 2020, 04:24:46 PM
Quote from: AnatolS on November 30, 2020, 01:06:01 PM
Quote from: cynique 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.
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 ;

AnatolS

Minimal ISO - you mean CentOS blank (not LAMP)?
Clean - you mean yum clean all or?
Thank you


AnatolS

Quote from: cynique on November 30, 2020, 10:14:36 PM
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.

cinique

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.  ::)

studio4host

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
VPS & Dedicated server provider with included FREE Managed support for CWP.
http://www.studio4host.com/

*** Don't allow that your server or website is down, choose hosting provider with included expert managed support for your CWP.

AnatolS

Thank you for a clear answer. I will reinstall CentOS and CWP

Hardoman

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.

AnatolS

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!

Hardoman

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.