duanbi7247 2011-12-02 05:41
浏览 56

与YII连接时数据库mysql代理错误

I have configure mysql cluster with one master and one slave. Configured mysql proxy as common ip to access the servers. when i connect using mysql command its successfully connecting. But when i tried to access mysql proxy in yii application I am getting following error

2011/12/01 05:25:40 [error] [exception.CDbException] SQLSTATE[42000] [1049] Unknown database 'PortalDB' 2011/12/01 05:25:40 [error] [exception.CDbException] exception 'CDbException' with message 'CDbConnection failed to open the DB connection.' in /var/www/YII/yii-1.1.8.r3324/framework/db/CDbConnection.php:370

Below is the db configuration in YII

   'db'=>array(
                    'connectionString'      => 'mysql:host=xxxx;dbname=PortalDB;port=4040;',
                    'emulatePrepare'        => true,
                    'username'              => 'root',
                    'password'              => 'mysql',
                    'charset'               => 'utf8',
                    'queryCachingDuration'  => 300,
                    'enableParamLogging'    => true
            ),
            'db2'=>array(

                'class'                 => 'CDbConnection',
                'connectionString'      => 'mysql:host=xxxx;dbname=PortalDB;port=4040;',//devdbserver.c27hiz0xxzr5.us-east-1.rds.amazonaws.com
                'emulatePrepare'        => true,
                'username'              => 'root',
                'password'              => 'mysql',
                'charset'               => 'utf8',
                'queryCachingDuration'  => 300,
                'enableParamLogging'    => true
            ),
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥35 平滑拟合曲线该如何生成
    • ¥100 c语言,请帮蒟蒻写一个题的范例作参考
    • ¥15 名为“Product”的列已属于此 DataTable
    • ¥15 安卓adb backup备份应用数据失败
    • ¥15 eclipse运行项目时遇到的问题
    • ¥15 关于#c##的问题:最近需要用CAT工具Trados进行一些开发
    • ¥15 南大pa1 小游戏没有界面,并且报了如下错误,尝试过换显卡驱动,但是好像不行
    • ¥15 自己瞎改改,结果现在又运行不了了
    • ¥15 链式存储应该如何解决
    • ¥15 没有证书,nginx怎么反向代理到只能接受https的公网网站