MySQL is probably not listening for TCP connections. Try changing the host param to 'localhost', which will use a UNIX socket connection.
On Fri, Nov 12, 2010 at 3:56 PM, rogwei <[email protected]> wrote: > The subject search phrase returns 0 items in this group which > surprises me a little, and google isn't. Anyway, I upgraded my DB > server Ubuntu 9.10 to 10.04 LTS, and now when I try to access my > application I get the following warning and a missing database table > error. One factoid, I CAN connect with phpmyadmin using the same host > and credentials. > > The only my.cnf file on the server uses port 3306. Not sure what to do > or whose issue this is. Any help? > > Warning (2): mysql_connect() [function.mysql-connect]: [2002] > Connection refused (trying to connect via tcp://x.x.x.x:3306) [CORE/ > cake/libs/model/datasources/dbo/dbo_mysql.php, line 552] > Code | Context > $config = array( > "persistent" => false, > "host" => "x.x.x.x", > "login" => "xxxxxxxxx", > "password" => "xxxxxxxx", > "database" => "xxxxxxxxxx", > "port" => "3306", > "driver" => "mysql", > "prefix" => "" > ) > mysql_connect - [internal], line ?? > DboMysql::connect() - CORE/cake/libs/model/datasources/dbo/ > dbo_mysql.php, line 552 > DboSource::__construct() - CORE/cake/libs/model/datasources/ > dbo_source.php, line 143 > ConnectionManager::getDataSource() - CORE/cake/libs/model/ > connection_manager.php, line 114 > Model::setDataSource() - CORE/cake/libs/model/model.php, line 2818 > Model::__construct() - CORE/cake/libs/model/model.php, line 469 > AclNode::__construct() - CORE/cake/libs/model/db_acl.php, line 62 > ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 141 > DbAcl::__construct() - CORE/cake/libs/controller/components/acl.php, > line 237 > AclComponent::__construct() - CORE/cake/libs/controller/components/ > acl.php, line 58 > Component::_loadComponents() - CORE/cake/libs/controller/ > component.php, line 249 > Component::init() - CORE/cake/libs/controller/component.php, line 78 > Controller::constructClasses() - CORE/cake/libs/controller/ > controller.php, line 487 > Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 186 > Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171 > [main] - /Users/Roger/Sites/uypBarebones/index.php, line 84 > > Check out the new CakePHP Questions site http://cakeqs.org and help others > with their CakePHP related questions. > > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] For more options, visit this group at > http://groups.google.com/group/cake-php?hl=en > Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
