[SOLVED] [exception.CDbException]

[Carlito Tevez]

Please help!

2016/03/14 10:29:01 [error] [exception.CDbException] SQLSTATE[HY000] [2002] No such file or directory
2016/03/14 10:29:01 [error] [exception.CDbException] exception 'CDbException' with message 'CDbConnection failed to open the DB connection.' in /home/cuzcuz/public_html/mailwizz/apps/common/framework/yiilite.php:8621
Stack trace:
#0 /home/cuzcuz/public_html/mailwizz/apps/common/framework/yiilite.php(8587): CDbConnection->open()
#1 /home/cuzcuz/public_html/mailwizz/apps/common/framework/yiilite.php(8576): CDbConnection->setActive(true)
#2 /home/cuzcuz/public_html/mailwizz/apps/common/framework/yiilite.php(1073): CDbConnection->init()
#3 /home/cuzcuz/public_html/mailwizz/apps/common/framework/yiilite.php(925): CModule->getComponent('db')
#4 /home/cuzcuz/public_html/mailwizz/apps/common/components/managers/OptionsManager.php(164): CModule->__get('db')
#5 /home/cuzcuz/public_html/mailwizz/apps/common/components/managers/OptionsManager.php(73): OptionsManager->loadCategory('system.extensio...')
#6 /home/cuzcuz/public_html/mailwizz/apps/common/components/managers/ExtensionsManager.php(188): OptionsManager->get('system.extensio...', 'disabled')
#7 /home/cuzcuz/public_html/mailwizz/apps/common/components/managers/ExtensionsManager.php(118): ExtensionsManager->isExtensionEnabled('translate')
#8 /home/cuzcuz/public_html/mailwizz/apps/common/components/init/SystemInit.php(85): ExtensionsManager->loadAllExtensions()
#9 /home/cuzcuz/public_html/mailwizz/apps/common/framework/yiilite.php(842): SystemInit->_runOnBeginRequest(Object(CEvent))
#10 /home/cuzcuz/public_html/mailwizz/apps/common/framework/yiilite.php(1218): CComponent->raiseEvent('onBeginRequest', Object(CEvent))
#11 /home/cuzcuz/public_html/mailwizz/apps/common/framework/yiilite.php(1203): CApplication->onBeginRequest(Object(CEvent))
#12 /home/cuzcuz/public_html/mailwizz/apps/init.php(219): CApplication->run()
#13 /home/cuzcuz/public_html/mailwizz/apps/console/console.php(28): require_once('/home/cuzcuz/...')
#14 {main}

 

[twisted1919]

Hey,

@Carlito Tevez - When you get this error? I assume you went through the install process, right?

 

[Carlito Tevez]

I get this when I try to send a campaign, then I got this error and can't send a campaign.

 

[Carlito Tevez]

my main-custom.php config:

'components' => array(
'db' => array(
'connectionString' => 'mysql:host=mydomain.com;dbname=cuzcuz_mailwizz',
'username' => 'cuzcuz_mailwizz',
'password' => 'cuzcuz123',
'tablePrefix' => 'mw_',
),
),
);

-rwxr-xr-x 1 cuzcuz cuzcuz 820 Mar 14 09:03 main-custom.php*
chmod 0755


Mysql Properties:


Database server

• Server: Localhost via UNIX socket
• Server type: MySQL
• Server version: 5.6.29 - MySQL Community Server (GPL)
• Protocol version: 10
• User: cuzcuz@localhost
• Server charset: UTF-8 Unicode (utf8)
  
  Web server
  • cpsrvd 11.54.0.19
  • Database client version: libmysql - 5.1.73
  • PHP extension: mysqli

 

[twisted1919]

@Carlito Tevez - try to use IP address for the MySQL host instead of a domain name.

 

[Carlito Tevez]

When i put my IP I get:


CDbException
CDbConnection failed to open the DB connection.

[~/www/mailwizz/apps/common/config]# ls
this one edited:
main-custom.php

right?

 

[Carlito Tevez]

[SOLVED] I put the local IP: 127.0.0.1 instead of localhost or domain.name.com and this Works!

Thank you.