Control Web Panel

WebPanel => CentOS-WebPanel Bugs => Topic started by: teddie2306 on August 11, 2015, 07:07:52 AM

Title: cannot add email account
Post by: teddie2306 on August 11, 2015, 07:07:52 AM
hi guys, i almost 5 months installed cwp on vps and nothing problem, but today when i want to create an email account,i have no result in list email account. is that sql problem ?? or else ? i had never update before,
plis help ,,
thanks,  :(
Title: Re: cannot add email account
Post by: anuradhan on August 25, 2015, 08:45:56 PM
Quote from: teddie2306 on August 11, 2015, 07:07:52 AM
hi guys, i almost 5 months installed cwp on vps and nothing problem, but today when i want to create an email account,i have no result in list email account. is that sql problem ?? or else ? i had never update before,
plis help ,,
thanks,  :(

i have the same problem.
tried but no luck. still see blank list of accounts.

did you able to fix the problem ?
any admin here to help fix this problem ?
Last change on Server: update php 5.6 and Mysql 5.6
Title: Re: cannot add email account
Post by: teddie2306 on September 01, 2015, 04:49:00 AM
Quote from: anuradhan on August 25, 2015, 08:45:56 PM
Quote from: teddie2306 on August 11, 2015, 07:07:52 AM
hi guys, i almost 5 months installed cwp on vps and nothing problem, but today when i want to create an email account,i have no result in list email account. is that sql problem ?? or else ? i had never update before,
plis help ,,
thanks,  :(

i have the same problem.
tried but no luck. still see blank list of accounts.

did you able to fix the problem ?
any admin here to help fix this problem ?
Last change on Server: update php 5.6 and Mysql 5.6

dude,i still unable to add email .. i dont know how to fix it,, i tried rebuild mysql with yum update/upgrade mysql-server but no luck..
still waiting for the solutions.. is it problem from mysql database or else ???  ???
Title: Re: cannot add email account
Post by: undone on September 02, 2015, 10:22:46 PM
I had the same problem and solved it!

If you upgrade your MySql server to 5.6 , SQL query used in the panel will fail!
To solve this problem:

(http://www.axgig.com/images/92365751542995912888.png)
(http://www.axgig.com/images/42707834439199169740.png)
Title: Re: cannot add email account
Post by: teddie2306 on September 04, 2015, 08:47:29 AM
Quote from: undone on September 02, 2015, 10:22:46 PM
I had the same problem and solved it!

If you upgrade your MySql server to 5.6 , SQL query used in the panel will fail!
To solve this problem:
  • Open your PhpMyAdmin
  • Open postfix database
  • Go to "Structure" tab of "mailbox"  table
  • Click on "Change"  next to "name"  column (see pic below)
  • Now, Change Default value drop down to "As defined:" and leave the new input box empty
  • Save it and create your email account!

(http://www.axgig.com/images/92365751542995912888.png)
(http://www.axgig.com/images/42707834439199169740.png)

hi dude, thank you so much,, you did it..  ;D
Title: Re: cannot add email account
Post by: undone on December 28, 2015, 09:13:08 AM
There is another way: disable STRICT_TRANS_TABLES  on your mysql.
edit your /usr/my.cnf:

sql_mode=NO_ENGINE_SUBSTITUTION
Title: Re: cannot add email account
Post by: locvfx on July 23, 2016, 04:44:59 AM
Quote from: undone on December 28, 2015, 09:13:08 AM
There is another way: disable STRICT_TRANS_TABLES  on your mysql.
edit your /usr/my.cnf:

sql_mode=NO_ENGINE_SUBSTITUTION

Alright, thank you very much. You made my day easy
Title: Re: cannot add email account
Post by: Ga Go on July 10, 2021, 01:48:39 PM
Hello, i just get into this post and i have problem i am using long time CWP Panel and i have first this issue for postfix email creation
can you please tell me exactly i can't see any picture below or something like that.

Here is screenshot what i get from when i want to create
https://prnt.sc/19zyuwd