douxiangshi6568 2016-02-03 09:48
浏览 49
已采纳

Strato Server PHP Zend PDOException套接字

I'm trying to connect to a database using a PDO Connection via Zend:

<?php
class Feuerwehr_Db extends Zend_Db {

    public static function factoryEinsaetze(){
        $config = array(
            'LOCAL' => array(
                'servername' => "localhost",
                'username' => "root",
                'password' => "admin",
                'dbname' => "einsaetze"
            ),
            'LIVE' => array(
                    'servername' => "rdbms.strato.de",
                    'username' => "U2340080",
                    'password' => "*****",
                    'dbname' => "DB2340080"
            )
        );
        return parent::factory('Pdo_Mysql', $config[Feuerwehr_Environment::getStage()]);
    }
}

The Connection selects all login data correctly and creates a DB connection. Everything works fine locally but on my Strato Server the Connection fails with the following exception:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' in /mnt/web024/d1/57/5707957/htdocs/Beta/library/Zend/Db/Adapter/Pdo/Abstract.php:129 Stack trace: #0 /mnt/web024/d1/57/5707957/htdocs/Beta/library/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:servernam...', 'U2340080', '*****', Array) #1.....

The PHP Version on the server is 5.6 and a standard mysql_connect works perfectly.

  • 写回答

1条回答 默认 最新

  • doushi4795 2016-02-08 10:16
    关注

    Zend expected the key "host" and not "servername". Default param is set as localhost which explains the error exception.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 centos7.9 IPv6端口telnet和端口监控问题
  • ¥120 计算机网络的新校区组网设计
  • ¥20 完全没有学习过GAN,看了CSDN的一篇文章,里面有代码但是完全不知道如何操作
  • ¥15 使用ue5插件narrative时如何切换关卡也保存叙事任务记录
  • ¥20 海浪数据 南海地区海况数据,波浪数据
  • ¥20 软件测试决策法疑问求解答
  • ¥15 win11 23H2删除推荐的项目,支持注册表等
  • ¥15 matlab 用yalmip搭建模型,cplex求解,线性化处理的方法
  • ¥15 qt6.6.3 基于百度云的语音识别 不会改
  • ¥15 关于#目标检测#的问题:大概就是类似后台自动检测某下架商品的库存,在他监测到该商品上架并且可以购买的瞬间点击立即购买下单