Cant connect to odbc

Asterisk Asterisk Support
1

ODBC DSN Settings

Name: astcdr
DSN: astcdr
Last fail connection attempt: 2024-03-13 02:14:05
Number of active connections: 0 (out of 1)
Logging: Disabled

TRIED THis :
isql -v asterisk
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect

here is my odbc.ini
Description = MySQL connection to database
Driver = MySQL
Database = cdr
Server = localhost
User = root
Password = ###
Port = 3306
Socket = /var/run/mysqld/mysqld.sock

here is my odbcinst.ini
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc8a.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
FileUsage = 1

and this is what i finally added at the end of res_odbc.conf
[astcdr]
enabled => yes
dsn => astcdr
username => root
password => ###
pre-connect => yes

(please help me out where i went wrong as i am a beginner thanks in advance…)

2

Is your odbc.ini file missing the [ square brackets ] for the DSN ?

Does the DSN match throughout (is it astcdr or is it asterisk ?)

3

thanks for responding…
i managed to debug the error … yes the square bracket was one of the issues other was that the libmyodbc8a driver was not working so i switched to mariadb connector

4

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