I can't believe you are connecting to MySQL from PHPMYADMIN with absolutely the same details. The error means that the application cannot connect to the MySQL server on that port. By default on decent Ubuntu MySQL listens only on the local interface 127.0.0.1 and not on all IPs. You can check it with:
netstat -ntap |grep 3306 tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN - Thus if you have been connecting to the external IP before you will not be able to do so any longer (unless you reconfigure MySQL of course). Thus try using 127.0.0.1 for MySQL hostname. Best regards, Anatoli On Nov 12, 11: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
