PHP, ODBC, DB2 in linux or macOS

A scary tale where docker saves the day

TL;DR you may want to use this docker image https://cloud.docker.com/u/mkphp/repository/docker/mkphp/php-ibm-odbc

How do you connect PHP to a Database?

Well, you use the right driver, right? Which is usually ready for you to use out-of-the-box or at least, you just download it, enable it and that’s it.

For DB2 it’s bit more complicated than that.

First of all, I’m not saying DB2 is bad as a RDBMS. It has nice features and is robust. BUT…

DB2 is a proprietary piece of burocratic software from IBM. It’s ancient. It’s tightly coupled with the operating system from IBM (AFAIK).

By being deeply tied to the OS, it means you can’t just install DB2 in your Linux (ubuntu, fedora, centOS, etc), MacOS or Windows machine (just like MariaDB, MySQL, etc).

Now, that’s a problem.

A: What if I want to grab a copy from the database and have it locally to mess it up locally without risking stuff from staging or develop?

B: You can’t do that. At least not easily. There’s a way using containers but that’s a story for another day.

A: Well, I could connect remotely, right?

B: Yeah, assuming we have the right license for it.

A: Wait, are you telling me I need a special license just to connect to the database from a client? that’s crazy.

A: Okay, I’ll just set the DSN on my PDO on PHP to point to the development server

B: Sure. You’re using windows, right?

A: Ugh, hell no. I’m using linux, baby.

B: Oh, then you have to download the DSDriver from IBM’s website. Extract it. Install it. Copy the files to a safe location like /opt/ibm/dsdriver. Don’t forget to copy the .lic file too; our sysadmin will send you that one.

B: Once you have done that, THEN you can install the ibm_db2 driver for pdo through PECL.It’ll prompt for the dsdrivler/clidriver location.

B: Don’t forget to enable extension=ibm_db2.so in you php.ini

A: …okay.

B: OR if you’re using docker, use this image and just mount the license over.

Originally published at medium.com

Written with StackEdit.

Comentarios

  1. fabyannaigou18 de junio de 2022, 18:18

    Top 10 best online game for 3d money: Moneylines to Win
    This might have 퍼스트카지노 caused quite a lot of people 카지노 interested to check out which casinos let you play online. But when playing online games it is better to

    ResponderEliminar

Publicar un comentario

Entradas populares de este blog

Build your own disposable email server like mailinator

Imagen
The goal is to have a disposable server for disposable email. This can be easily done with docker and inbucket . TL;DR docker run -it --rm --name inbucket -p 9000:9000 -p 25:2500 -p 1100:1100 inbucket/inbucket Prepare your DNS record In your domain registrar, go to DNS management and add an entry in case you don’t have one. You can use whatever you want. In this example, I want to send any emails to test.softwareinarush.com as in 2308uasdfA@test.softwareinarush.com Add an A record that points to your server On the server, spin up a new container Simply run: docker run -it --rm --name inbucket -p 9000:9000 -p 25:2500 -p 1100:1100 inbucket/inbucket This will start a temporary container with all you need: Web UI 9000 to see emails in real time. Open port 25 to receive email ( could be changed but this works even with the mail command in MacOS ) Optionally use port 1100 for POP3 (I don’t) Test it Send a test email from command line (or other email service) mail -s ...
Leer más

Enviar reporte de commits por email

Esto es para enviar un reporte de tus commits por email utilizando sólo la terminal. git log --author = $USER --format = "- %B" --since = -7days --reverse | mail -s "What I've done this week" boss@company\.com # Send a commit report to your boss Written with StackEdit .
Leer más