Re: Production server MySQL connection problem...
Try changing it to 'host' => 'localhost' On Wed, Sep 9, 2009 at 4:25 AM, CapeTownGuy wrote: > > Hi, I keep on getting the following message on my production server > and the hosting company asked me to troubleshoot my code... (xxx > denotes the correct server config info)... this configuration, when > edited on my localhost works fine. > > Warning (2): mysql_connect() [function.mysql-connect]: Host > 'www17.jnb2.host-h.net' is not allowed to connect to this MySQL server > [CORE/cake/libs/model/datasources/dbo/dbo_mysql.php, line 374] > > $config = array( > "persistent" => false, > "host" => "xxx", > "login" => "xxx", > "password" => "xxx", > "database" => "xxx", > "port" => "3306", > "connect" => "mysql_pconnect", > "driver" => "mysql", > "prefix" => "" > ) > $connect = "mysql_pconnect" > > Can somebody please point me in the right direction? > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Production server MySQL connection problem...
Does your provider guarantees that a client coming from the address "'www17.jnb2.host-h.net" has access to the mysql database ? On Wed, Sep 9, 2009 at 10:25 AM, CapeTownGuy wrote: > > Hi, I keep on getting the following message on my production server > and the hosting company asked me to troubleshoot my code... (xxx > denotes the correct server config info)... this configuration, when > edited on my localhost works fine. > > Warning (2): mysql_connect() [function.mysql-connect]: Host > 'www17.jnb2.host-h.net' is not allowed to connect to this MySQL server > [CORE/cake/libs/model/datasources/dbo/dbo_mysql.php, line 374] > > $config = array( > "persistent" => false, > "host" => "xxx", > "login" => "xxx", > "password" => "xxx", > "database" => "xxx", > "port" => "3306", > "connect" => "mysql_pconnect", > "driver" => "mysql", > "prefix" => "" > ) > $connect = "mysql_pconnect" > > Can somebody please point me in the right direction? > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Production server MySQL connection problem...
Hi, I keep on getting the following message on my production server and the hosting company asked me to troubleshoot my code... (xxx denotes the correct server config info)... this configuration, when edited on my localhost works fine. Warning (2): mysql_connect() [function.mysql-connect]: Host 'www17.jnb2.host-h.net' is not allowed to connect to this MySQL server [CORE/cake/libs/model/datasources/dbo/dbo_mysql.php, line 374] $config = array( "persistent" => false, "host" => "xxx", "login" => "xxx", "password" => "xxx", "database" => "xxx", "port" => "3306", "connect" => "mysql_pconnect", "driver" => "mysql", "prefix" => "" ) $connect= "mysql_pconnect" Can somebody please point me in the right direction? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---