Laravel authentication segmentation fault during odbc connect

I use Laravel 7 and pdo and odbc, my database is Vertica DB 9.2 and it's ODBC works fine with isql. In Laravel when I run raw query there is no problem, but when I try to login the "artisan serve" command returns "segmentation fault (core dumped)" and Laravel exits.

Other information:
Ubuntu 16.04, Laravel 7.8, PHP 7.4.5, php7.4-odbc, PDO, Vertica DB 9.2
https://stackoverflow.com/questions/61590017/laravel-authentication-segmentation-fault-during-odbc-connect

Answers

  • Bryan_HBryan_H Employee

    Hi, I did a brief test with PDO in a PHP script not using Laravel, but could not reproduce the issue. However, I am using ODBC driver 10.0.0. It's possible that there is an issue in 9.2 that has been fixed, so are you able to obtain the latest driver from the Vertica web site and test with that?

  • I will also try to setup the complete similar environment with Vertica 10 driver and see if i can reproduce the issue.

  • Today I check Vertica 10.0.0 and Client Driver (ODBC) 10.0 but I had the problem again!
    Any idea?

  • Bryan_HBryan_H Employee

    We will try to replicate with the exact setup and versions, but was there any other log available, such as a stack trace? Does the artisan binary or package offer debug or trace logging?

  • Bryan_HBryan_H Employee

    How did you install php7.4? I created a Ubuntu 16.04 LTS instance on AWS and followed the directions to add a custom repository and was able to replicate the issue.
    However, I was able to get it to work by installing the build dependencies (unixODBC, unixODBC-devel, etc.) and build from source as follows:

    ./configure --with-pdo-odbc=unixODBC,/usr/ --without-sqlite3 --without-pdo-sqlite
    make
    sudo make install

    You'll likely need to remove all of the packaged php7.4 before building from source, and may need to install additional dependencies.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.