CDbException CDbConnection failed to open the DB connection.

[carlos alvarez]

@twisted1919

Inside my.cnf config file, I have changed:

max_user_connections=100

To: max_user_connections=1000

and the problem was solved !

Thanks for your advice.

 

[carlos alvarez]

@twisted1919

I changed:

max_user_connections = 100

To:

max_user_connections = 1000

inside my.cnf and the problem was solved !

 

[twisted1919]

@carlos alvarez - that's nice to hear, as you see there are many pieces you have to take care of beside just mailwizz

 

[Elancers Ltda]

Hi dear
in my.cnf
max_connections=250 or above

and

max_user_connections = 1000 or above

 

[twisted1919]

@Elancers Ltda - Can you post here the error you get as well?

 

[Elancers Ltda]

yes this error
CDbConnection failed to open the DB connection: SQLSTATE[08004] [1040] Too many connections

 

[twisted1919]

@Elancers Ltda - then i see no way than to increase those even more...
One thing, maybe you're wondering what's happening that you get so many connections. The answer is that when you send a campaign and opens/clicks start to happen, they'll flood your server, so your server needs to be prepared for this.

 

[Elancers Ltda]

@twisted1919 ,
In fact, when I hired the RDS server in amazon AWS, it only came with max_connections = 35 and so I had a lot of problems. I adjusted it to a fair value and put it to 250.

 

[twisted1919]

@Elancers Ltda - That good, make sure you restart if after you do new changes, so they take effect.

 

[Mohit1946]

i can resolve this issue easily..
Contact me or PM me-

Skype:
ID(world_338)

 

[Gary Orman]

Yes, I had exactly the same problem. I'm using AWS virtual servers and there was no max_connects or max_user_connections listed in the my.cnf file.

BTW, it took me ages to find where this file is stored on my server. In my case it was simply in /etc (off the root of the server). But I noticed Carlos has his in /etc/mysql. It's all very confusing.

Secondly, it's really important to reboot (or restart the MySQL server, if you know how to do that coz I don't) otherwise it has no effect!

 

[twisted1919]

You can only reboot mysql: systemctl restart mysql