how to use a custom text _id

[gfanini]

how could I use a custom text _id like "0F000000" with the library, with php 7
since it is allowed by mongodb : https://docs.mongodb.com/manual/core/index-text/

$recordid='0F000000';
$uri = 'mongodb://'.$dbhost.$g_replicaSet;		
$client=new MongoDB\Client($uri);		
$collection = $client->test->test_collection;  	
$item = $collection->findOne(array('_id' => new MongoDB\BSON\ObjectId($recordid)));

this gives an exception, I tried with regex but it unexplainably does not fetch any records from some _id, how could I debug why
the cursor comes back empty with

$regex = new MongoDB\BSON\Regex ('0F000000', 'i');
$query = new MongoDB\Driver\Query( array('_id' => $regex) );

the same regex works in mongo shell, perhaps enabling debug trace in mongo php ? I am launching from php 7.4 and 8 cli, not from apache say

[jmikola]

The MongoDB\BSON\ObjectId constructor requires a 24-character hexademical string as its first and only argument.

Using MongoDB\BSON\Regex in a query is equivalent to using the $regex query operator. Note that the $regex documentation also provides examples using /pattern/ or /pattern/<options> syntax. Those are intended to apply to the Javascript shell. When using the operator in PHP or another driver, you would use the following syntax:

{ <field>: { $regex: 'pattern', $options: '<options>' } }

In both cases (BSON regex type or the $regex operator), MongoDB attempts to match the regular expression against a string value. Note that strings and ObjectIds are two very different types in BSON. If your goal is to use a "custom text _id", there is no need to use the ObjectId class at all. You can simply use a PHP string value.

As far as matching a string value using a regular expression, consider the following script using the PHP library:

<?php

require_once 'vendor/autoload.php';

$client = new MongoDB\Client;
$collection = $client->test->foo;
$collection->drop();
$collection->insertOne(['_id' => '0F000000']);
$collection->insertOne(['_id' => '0f000000']);

echo "Query using the regular expression BSON type:\n";
$cursor = $collection->find(['_id' => new MongoDB\BSON\Regex('0F000000', 'i')]);
var_dump($cursor->toArray());

echo "\nQuery using the \$regex query operator:\n";
$cursor = $collection->find(['_id' => ['$regex' => '0F000000', '$options' => 'i']]);
var_dump($cursor->toArray());

echo "\nQuery using a string equality match:\n";
$cursor = $collection->find(['_id' => '0F000000']);
var_dump($cursor->toArray());

Running this script should produce output resembling the following:

Query using the regular expression BSON type:
array(2) {
  [0]=>
  object(MongoDB\Model\BSONDocument)#20 (1) {
    ["storage":"ArrayObject":private]=>
    array(1) {
      ["_id"]=>
      string(8) "0F000000"
    }
  }
  [1]=>
  object(MongoDB\Model\BSONDocument)#22 (1) {
    ["storage":"ArrayObject":private]=>
    array(1) {
      ["_id"]=>
      string(8) "0f000000"
    }
  }
}

Query using the $regex query operator:
array(2) {
  [0]=>
  object(MongoDB\Model\BSONDocument)#19 (1) {
    ["storage":"ArrayObject":private]=>
    array(1) {
      ["_id"]=>
      string(8) "0F000000"
    }
  }
  [1]=>
  object(MongoDB\Model\BSONDocument)#17 (1) {
    ["storage":"ArrayObject":private]=>
    array(1) {
      ["_id"]=>
      string(8) "0f000000"
    }
  }
}

Query using a string equality match:
array(1) {
  [0]=>
  object(MongoDB\Model\BSONDocument)#12 (1) {
    ["storage":"ArrayObject":private]=>
    array(1) {
      ["_id"]=>
      string(8) "0F000000"
    }
  }
}

[gfanini]

do you have perhaps any clue what could cause these same types of queries above to return nothing in linux debian 9 stretch

• php --ri mongodb | grep version
  PHP Warning: Module 'mongodb' already loaded in Unknown on line 0
  MongoDB extension version => 1.10.0
  libbson bundled version => 1.18.0
  libmongoc bundled version => 1.18.0
  libmongocrypt bundled version => 1.2.1

• php -version
  PHP Warning: Module 'mongodb' already loaded in Unknown on line 0
  PHP 7.4.24 (cli) (built: Sep 23 2021 22:05:24) ( NTS )
  Copyright (c) The PHP Group
  Zend Engine v3.4.0, Copyright (c) Zend Technologies
  with Zend OPcache v7.4.24, Copyright (c), by Zend Technologies

• locate mongodb.so
  /usr/lib/php/20190902/mongodb.so
  /usr/lib/php/20200930/mongodb.so

• ls -la /usr/lib/php/20190902/mongodb.so
  -rw-r--r-- 1 root root 1516736 Aug 2 09:20 /usr/lib/php/20190902/mongodb.so

• ls -la /usr/lib/php/20200930/mongodb.so
  -rw-r--r-- 1 root root 1516736 Aug 2 09:20 /usr/lib/php/20200930/mongodb.so

• pecl help version
  PHP Warning: Module 'mongodb' already loaded in Unknown on line 0
  PEAR Version: 1.10.12
  PHP Version: 7.4.24
  Zend Engine Version: 3.4.0
  Running on: Linux ECLASS-MGFRW01 4.9.0-9-amd64 Split and modify CRUD examples #1 SMP Debian 4.9.168-1+deb9u3 (2019-06-16) x86_64

• pecl install mongodb
  PHP Warning: Module 'mongodb' already loaded in Unknown on line 0
  pecl/mongodb is already installed and is the same as the released version 1.10.0
  install failed

whereas it works reliably without a glitch in windows 10 launching from cli within wamp

C:\wamp64\bin\php\php7.2.18\ext

05/09/2017 16:57 348.672 php_mongo.dll
09/09/2019 17:31 918.528 php_mongodb.dll

[jmikola]

do you have perhaps any clue what could cause these same types of queries above to return nothing in linux debian 9 stretch

Nothing in the script I shared is specific to an operating system, or even a recent version of the extension/library.

Based on the "Module 'mongodb' already loaded" warnings in the output you shared, you likely have some redundant lines in your PHP configuration (either php.ini or your within your scan directory for additional INIs); however, I don't imagine that would prevent the script from inserting and querying a document.

I would start by checking if the queries are actually executing successfully and returning a cursor with no results (e.g. var_dump() prints an empty array), or if there is some exception occurring that you're not seeing. Beyond that, try simplifying the script to query without a filter and see if you can at least return the two documents that were inserted.

[gfanini]

it was fetching mongodb.so by itself, not needed on linux php.ini I guess

• php --ini
  Configuration File (php.ini) Path: /etc/php/7.4/cli
  Loaded Configuration File: /etc/php/7.4/cli/php.ini
  Scan for additional .ini files in: /etc/php/7.4/cli/conf.d
  Additional .ini files parsed: /etc/php/7.4/cli/conf.d/10-opcache.ini,
  /etc/php/7.4/cli/conf.d/10-pdo.ini,
  /etc/php/7.4/cli/conf.d/15-xml.ini,
  /etc/php/7.4/cli/conf.d/20-calendar.ini,
  /etc/php/7.4/cli/conf.d/20-ctype.ini,
  /etc/php/7.4/cli/conf.d/20-dom.ini,
  /etc/php/7.4/cli/conf.d/20-exif.ini,
  /etc/php/7.4/cli/conf.d/20-ffi.ini,
  /etc/php/7.4/cli/conf.d/20-fileinfo.ini,
  /etc/php/7.4/cli/conf.d/20-ftp.ini,
  /etc/php/7.4/cli/conf.d/20-gettext.ini,
  /etc/php/7.4/cli/conf.d/20-iconv.ini,
  /etc/php/7.4/cli/conf.d/20-json.ini,
  /etc/php/7.4/cli/conf.d/20-mongodb.ini, ******** seems already loaded here ***********
  /etc/php/7.4/cli/conf.d/20-phar.ini,
  /etc/php/7.4/cli/conf.d/20-posix.ini,
  /etc/php/7.4/cli/conf.d/20-readline.ini,
  /etc/php/7.4/cli/conf.d/20-shmop.ini,
  /etc/php/7.4/cli/conf.d/20-simplexml.ini,
  /etc/php/7.4/cli/conf.d/20-sockets.ini,
  /etc/php/7.4/cli/conf.d/20-sysvmsg.ini,
  /etc/php/7.4/cli/conf.d/20-sysvsem.ini,
  /etc/php/7.4/cli/conf.d/20-sysvshm.ini,
  /etc/php/7.4/cli/conf.d/20-tokenizer.ini,
  /etc/php/7.4/cli/conf.d/20-xmlreader.ini,
  /etc/php/7.4/cli/conf.d/20-xmlwriter.ini,
  /etc/php/7.4/cli/conf.d/20-xsl.ini

I try to recompile mongodb.so and install from sources, another version in case ?
pecl install mongodb-1.9.2 would automatically build and install for which minimum php version ?
which version of mongodb for php version 7.4 ?
because it works perfectly with php 7.2 on windows, is it possible to try and revert to that on linux ?

[jmikola]

pecl install mongodb-1.9.2 would automatically build and install for which minimum php version ?
which version of mongodb for php version 7.4 ?

The extension releases are indexed on https://pecl.php.net/package/mongodb. The most recent stable version (1.10.0) supports PHP 7.1 and newer (see the bottom of that page for the complete list of compatible PHP versions).

The driver is thoroughly tested on Linux platforms (both in GitHub CI and our internal Evergreen tool) and we also run the test suite on AppVeyor for Windows. I'm not convinced that there is an actual bug at play in this issue. Unless you're able to clearly investigate how the script I shared fails for you (as suggested in the final paragraph of my last comment) I will not be able to provide more assistance here.

[pooooodles]

Hi @gfanini, we are closing this out since we haven't heard back, but please let us know if you'd like to pick this conversation back up and we'd be happy to continue!