Okay, for a new project I want to try and move to MongoDB, I am really looking forward to a schema free database where I can simply just store my ‘documents’ and do with them what I want! <\/p>\n\n\n\n
So let’s log into our server and get some stuff installed:<\/p>\n\n\n\n
$ doas pkg_add mongodb\n$ doas rcctl enable mongod\n$ doas rcctl start mongod\n$ mongo\nMongoDB shell version: 3.2.22\nconnecting to: test\nWelcome to the MongoDB shell.\nFor interactive help, type \"help\".\nFor more comprehensive documentation, see\n\thttp://docs.mongodb.org\/\nQuestions? Try the support group\n\thttp:\/\/groups.google.com\/group\/mongodb-user\nServer has startup warnings: \n2020-03-20T23:01:00.737+0100 I CONTROL [initandlisten] \n2020-03-20T23:01:00.737+0100 I CONTROL [initandlisten] ** NOTE: your operating system version does not support the method that MongoDB\n2020-03-20T23:01:00.737+0100 I CONTROL [initandlisten] ** uses to detect impending page faults.\n2020-03-20T23:01:00.737+0100 I CONTROL [initandlisten] ** This may result in slower performance for certain use cases\n2020-03-20T23:01:00.737+0100 I CONTROL [initandlisten] \n2020-03-20T23:01:00.737+0100 I CONTROL [initandlisten] ** WARNING: soft rlimits too low. Number of files is 128, should be at least 1000\n2020-03-20T23:01:00.737+0100 I CONTROL [initandlisten] <\/code><\/pre>\n\n\n\nFor what it’s worth Mongo is showing some startup warnings, I’m going to ignore these for now. Let’s first insert some data so we can test our db connection later when we are in PHP:<\/p>\n\n\n\n
$ mongo testdb\n> db.users.insert({ 'name': 'Remy Blom', 'email': 'r@aodw.nl' })<\/code><\/pre>\n\n\n\nThing is we have a working MongoDB, kinda cool, but I want to be able to talk to it from PHP (or do I? I might have to rethink that\u2026 PHP is waaaay old and stuff?)<\/p>\n\n\n\n
First we have to prepare our OpenBSD to be able to run the manual installation. (I still think this should also be able to work in such a way that you could just use the pecl install<\/code> method, but I kept running into the error mentioning AUTOCONF_VERSION<\/code> was not set…)<\/p>\n\n\n\n In order to get phpize<\/code> running I had to do:<\/p>\n\n\n\n$ doas pkg_add pear autoconf\n$ cd \/usr\/local\/bin\n$ ln -s phpize-7.3 phpize\n$ ln -s php-config-7.3 php-config<\/code><\/pre>\n\n\n\nFurthermore I had to add to my .\/profile<\/code>:<\/p>\n\n\n\nexport AUTOCONF_VERSION=2.69<\/code><\/pre>\n\n\n\nThen I had to re-login for the profile to take effect and then I could run:<\/p>\n\n\n\n
$ git clone https:\/\/github.com\/mongodb\/mongo-php-driver.git\n$ cd mongo-php-driver\n$ git submodule update --init\n$ phpize\n$ .\/configure\n$ make all\n$ sudo make install<\/code><\/pre>\n\n\n\nRestart php-fpm and ready to go:<\/p>\n\n\n\n
$ doas rcctl restart php73_fpm<\/code><\/pre>\n\n\n\nLet’s write a little program that returns that user we inserted in the beginning:<\/p>\n\n\n\n
<?php\n\n $m = new MongoDB\\Driver\\Manager(\"mongodb:\/\/localhost:27017\");\n $query = new MongoDB\\Driver\\Query([]); \n \n $results = $m->executeQuery(\"testdb.users\", $query);\n echo $results;\n\n foreach ($results as $result) {\n print_r($result);\n }<\/code><\/pre>\n\n\n\nRunning this code will print:<\/p>\n\n\n\n
stdClass Object\n(\n [_id] => MongoDB\\BSON\\ObjectId Object\n (\n [oid] => 5e79c3a3c7f38ba9c7943ffd\n )\n\n [name] => Remy Blom\n [email] => r@aodw.nl\n)<\/code><\/pre>\n\n\n\nPlease note that in the $results<\/code> object you don’t see any of your results, that had me looking puzzled and scratching my head for a while….<\/p>\n","protected":false},"excerpt":{"rendered":"Okay, for a new project I want to try and move to MongoDB, I am really looking forward to a schema free database where I can simply just store my ‘documents’ and do with them what I want! So let’s log into our server and get some stuff installed: For what it’s worth Mongo is … <\/p>\n