Author Topic: No "postfix" database, CWP7, MariaDB, Centos 7  (Read 11003 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
No "postfix" database, CWP7, MariaDB, Centos 7
« 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)
« Last Edit: November 29, 2020, 10:32:24 PM by AnatolS »

Re: No "postfix" database, CWP7, MariaDB, Centos 7
« Reply #1 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.

Offline
*
Re: No "postfix" database, CWP7, MariaDB, Centos 7
« Reply #2 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

Re: No "postfix" database, CWP7, MariaDB, Centos 7
« Reply #3 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.  ::)

Offline
*
Re: No "postfix" database, CWP7, MariaDB, Centos 7
« Reply #4 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 ;

Offline
*
Re: No "postfix" database, CWP7, MariaDB, Centos 7
« Reply #5 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

Re: No "postfix" database, CWP7, MariaDB, Centos 7
« Reply #6 on: November 30, 2020, 10:14:36 PM »

Offline
*
Re: No "postfix" database, CWP7, MariaDB, Centos 7
« Reply #7 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.

Re: No "postfix" database, CWP7, MariaDB, Centos 7
« Reply #8 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.  ::)

Offline
*
Re: No "postfix" database, CWP7, MariaDB, Centos 7
« Reply #9 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
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.

Offline
*
Re: No "postfix" database, CWP7, MariaDB, Centos 7
« Reply #10 on: December 02, 2020, 08:59:20 PM »
Thank you for a clear answer. I will reinstall CentOS and CWP

Offline
*
Re: No "postfix" database, CWP7, MariaDB, Centos 7
« Reply #11 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.

Offline
*
Re: No "postfix" database, CWP7, MariaDB, Centos 7
« Reply #12 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!

Offline
*
Re: No "postfix" database, CWP7, MariaDB, Centos 7
« Reply #13 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.