I thought I’d share it for those out there needing some help. I’m working with a Ubuntu server box, but these instructions could be pretty easily adapted to other distros:
1. Ensure you have the Unix ODBC package installed. This is what PDO uses to connect to the Vertica instance:
2. Ensure that your PHP installation has PDO support with ODBC handling:
You should see something like “PDO_ODBC” there if it’s installed.
3. Grab the latest Vertica linux drivers from the My.Vertica site (requires a login). Click on the Downloads section and scroll all the way down to the drivers. Grab the right ones for your linux installation. I used the Linux ODBC 64-bit.
4. Make a “/opt/vertica” directory on your system and untar the archive there.