PHP5 PHP7 用原生代码连接mongodb,有密码认证

前提
Win7上测试。PHP5需要安装php_mongo.dll 而PHP7安装的是php_mongodb.dll扩展
各个扩展:

  • php5.6.40 TS VC11 - mongo1.6.16 - mongodb1.6.10
  • php7.3.5 TS VC15 - mongodb 1.5.5

创建用户
在shell中执行创建mongo用户

> use test
switched to db test
> db.createUser({
	user: "test1",
	pwd: "test1",
	roles: [
		{ role: "readWrite", db: "test" },
		{ role: "read", db: "reporting" }
	]
	});
	
Successfully added user: {
        "user" : "test1",
        "roles" : [
                {
                        "role" : "readWrite",
                        "db" : "test"
                },
                {
                        "role" : "read",
                        "db" : "reporting"
                }
        ]
}
>
> show users;
{
        "_id" : "test.test1",
        "userId" : UUID("406cb77c-1fc0-4f34-a257-1c975349533a"),
        "user" : "test1",
        "db" : "test",
        "roles" : [
                {
                        "role" : "readWrite",
                        "db" : "test"
                },
                {
                        "role" : "read",
                        "db" : "reporting"
                }
        ],
        "mechanisms" : [
                "SCRAM-SHA-1",
                "SCRAM-SHA-256"
        ]
}
>
> db.auth('test1','test1')
1
> db
test


测试代码
文件 E:/test/mongo.php

<?php

$config = [
    'username' => 'test1',
    'password' => 'test1',
    'auth_db' => 'test',
    'host' => '127.0.0.1',
    'port' => '27017',
    'db' => 'test',
    'table' => 'foo',
    //    'db' => 'reporting',
    //    'table' => 'foo2',
];

$result = null;
if (PHP_VERSION_ID < 70000) {
    try {
//        $conn = new MongoClient("mongodb://" . $config['username'] . ':' . $config['password'] . '@' . $config['host'] . ':' . $config['port'] . '/' . $config['auth_db']);
        $conn = new MongoClient("mongodb://" . $config['host'], array(
            'username' => $config['username'],
            'password' => $config['password'],
            'db' => $config['auth_db'],
        ));

        $db = $conn->selectDB($config['db']);
        $mongo = $db->selectCollection($config['table']);
        $result = $mongo->findOne();
    } catch (Exception $e) {
        var_dump($e->getMessage());
    }
} else {


//    $manager = new MongoDB\Driver\Manager("mongodb://" . $config['username'] . ":" . $config['password'] . "@" . $config['host'] . ":" . $config['port'].'/'.$config['auth_db']);
    $manager = new MongoDB\Driver\Manager("mongodb://" . $config['host'] . ":" . $config['port'] . '/' . $config['auth_db'], [
        'username' => $config['username'],
        'password' => $config['password'],
        'db' => $config['auth_db']
    ]);

    $filter = [];
    $options = [];
    $query = new MongoDB\Driver\Query($filter, $options); //查询请求

    var_dump($config['db'] . "." . $config['table']);

    try {
        $result = $manager->executeQuery($config['db'] . "." . $config['table'], $query)->toArray();
    } catch (Exception $e) {
        var_dump($e->getMessage());
    }
}

var_dump($result);

输出
php5.6

D:\>d:/php56/php.exe e:/test/mongo.php
array(3) {
  ["_id"]=>
  object(MongoId)#6 (1) {
    ["$id"]=>
    string(24) "5d26ba7b1ed45d92904eb3d5"
  }
  ["x"]=>
  float(1)
  ["y"]=>
  float(1)
}

D:\>

但PHP5.6有一个问题,如果是切换到非认证数据库 reporting,无法访问,报错提示:Authentication failed

D:\>d:/php56/php.exe e:/test/mongo.php
string(113) "Failed to connect to: 127.0.0.1:27017: SASL Authentication failed o
n database 'reporting': Authentication failed."
NULL

D:\>

可问题是我用终端和no sql 工具,比如No SQL Manager For MongoDB 都没有问题。
都可以访问,如下图。如果你知道这个问题的原因,希望能联系我 coconets@163.com
在这里插入图片描述

  • php7.3
D:\>d:/php73/php.exe e:/test/mongo.php
string(14) "reporting.foo2"
array(1) {
  [0]=>
  object(stdClass)#6 (3) {
    ["_id"]=>
    object(MongoDB\BSON\ObjectId)#5 (1) {
      ["oid"]=>
      string(24) "5d26cde60e60a4d63cf516d1"
    }
    ["name"]=>
    string(3) "fff"
    ["pwd"]=>
    string(3) "zzz"
  }
}

D:\>d:/php73/php.exe e:/test/mongo.php
string(8) "test.foo"
array(1) {
  [0]=>
  object(stdClass)#6 (3) {
    ["_id"]=>
    object(MongoDB\BSON\ObjectId)#5 (1) {
      ["oid"]=>
      string(24) "5d26ba7b1ed45d92904eb3d5"
    }
    ["x"]=>
    float(1)
    ["y"]=>
    float(1)
  }
}

D:\>

  • 1
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值