[unixODBC][Driver Manager]Can't open lib

astfan · November 4, 2023, 2:13pm

Hello,

Persistently facing the error: WARNING[51358] res_odbc.c: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Can’t open lib ‘/usr/local/lib/libmyodbc8a.so’ : file not found

Other tests return a success as attached. This is Asterisk 20.4.0 on Ubuntu 22.04.

What would be the misconfig?

Pooh · November 4, 2023, 2:32pm

“Can’t open lib ‘/usr/local/lib/libmyodbc8a.so’ : file not found”

“What would be the misconfig?”

Well, either you have not installed the MySQL ODBC driver, or you’ve installed
it elsewhere and need to put the correct path to it into odbcinst.ini

For info, on my Debian system the MariaDB equivalent driver is in
/usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so

Antony.

astfan · November 4, 2023, 3:00pm

Maybe the paths issue: Definitely not here: /usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so I checked. How would I confirm the paths are ok?

astfan · November 4, 2023, 3:12pm

@jcolp Oops, I notice that should have asked in Asterisk Support forum. Your input?

Pooh · November 4, 2023, 3:18pm

“Definitely not here:
/usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so”

Well, you certainly would not have that one, because I’m using MariaDB and
you’re using MySQL.

I suggest you try:

a) find / -name libmyodbc8a.so

that will tell you where it is, if it is installed

b) https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-installation-
binary-deb.html

that will tell you how to install it if you haven’t already

Antony

astfan · November 4, 2023, 3:33pm

root@databranch:~# find / -name libmyodbc8a.so
/usr/local/lib/libmyodbc8a.so

There it is…I have installed this package severally.

astfan · November 5, 2023, 11:32am

@penguinpbx Any word? Am stuck here for long.

david551 · November 5, 2023, 2:06pm

Never used database features, and the general rule is that you don’t tag to request replies, as people will provide anything they can and want to provide without being prompted.

astfan · November 6, 2023, 1:03pm

You have another suggestion this thing is really holding my progress back…

Pooh · November 6, 2023, 1:18pm

I am unable to reconcile your error message:

“Can’t open lib ‘/usr/local/lib/libmyodbc8a.so’ : file not found”

with your output from the find command:

root@databranch:~# find / -name libmyodbc8a.so
/usr/local/lib/libmyodbc8a.so

Unless there is some bizarre permissons problem in the directories leading
down to where that file is, I can’t see why ODBC is unable to open it.

Have you reviewed https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-
installation-binary-deb.html to make sure you installed the driver correctly?

Antony.

penguinpbx · November 6, 2023, 2:07pm

Debian 12 driver for MARIA should work out-of-the-box. Please see this relevant part of a related Ansible role (installs the off-topic FreePBX GUI with MARIA/MYSQL on Asterisk 20 on Debian 12):

github.com

chrsmj/pngnx23299/blob/943a95eeb6e617241036b8cc596f20c5ac09fab1/tasks/mariadb.yml

# SPDX-FileCopyrightText: 2023 Penguin PBX Solutions <chris at penguin p b x dot com>
#
# SPDX-License-Identifier: GPL-3.0-or-later
---
# file: roles/pngnx23299/tasks/mariadb.yml

# Configure MariaDB/MYSQL in a way that FreePBX can handle.

- name: Make MYSQL Great Again.
  become: yes
  ansible.builtin.ini_file:
    path: /etc/mysql/conf.d/freepbx.cnf
    section: mysqld
    option: sql_mode
    value: ''
    no_extra_spaces: yes

- name: Restart MariaDB (MYSQL).
  become: yes
  ansible.builtin.service:

This file has been truncated. show original

system · December 6, 2023, 2:07pm

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.