8 Nov
2024
8 Nov
'24
10:14 a.m.
Hello,
the DB connection seems to be established. The kamailio tables are available in used table, right? Are you getting maybe more information about the error cause in the DB logs?
Cheers,
Henning
--
Henning Westerholt – https://skalatan.de/blog/
Kamailio services – https://gilawa.com
> -----Original Message-----
> From: 17603019528--- via sr-users sr-users@lists.kamailio.org
> Sent: Donnerstag, 7. November 2024 10:27
> To: sr-users@lists.kamailio.org
> Cc: 17603019528@163.com
> Subject: [SR-Users] [db_unixodbc] how to specify the database with
> unixodbc？
>
> Hi Dear Community,
> I want to use db_unixodbc to connect to the dm8 database.
> Although I use Opensips, I found that this module db_unixodbc, Kamailio and
> Opensips are the same.
> My question is how to specify the database with kamailio？ I add "Database =
> sbc" into odbc.ini, But nothing happened。
>
> ######
> cat /usr/local/etc/odbc.ini
> [DM8]
> Description = ODBC DRIVER FOR DM8
> Driver = DM8 ODBC DRIVER
> SERVER = 172.16.7.131
> TCP_PORT = 5230
>
> odbcinst -j
> unixODBC 2.3.12
> DRIVERS............: /usr/local/etc/odbcinst.ini SYSTEM DATA SOURCES:
> /usr/local/etc/odbc.ini FILE DATA SOURCES..:
> /usr/local/etc/ODBCDataSources USER DATA SOURCES..: /root/.odbc.ini
> SQLULEN Size.......: 8 SQLLEN Size........: 8 SQLSETPOSIROW Size.: 8
>
> #######
>
> ####################
> modparam("usrloc", "db_url",
> "unixodbc://opensips:opensips#$@172.16.7.131:5230/dm8")
> ####################
> DBG:db_unixodbc:db_unixodbc_new_connection: opening connection:
> unixodbc://xxxx:xxxx@172.16.7.131/dm8
> Nov 7 17:05:21 [145] DBG:db_unixodbc:db_unixodbc_new_connection:
> connection succeeded with reply
> <DSN=dm8;SERVER=172.16.7.131;UID=opensips;PWD=opensips#$;TCP_POR
> T=5230;>
> DBG:core:db_do_init: connection 0xfffd5bbbaf08 inserted in pool as
> 0xfffd5bbbb0e0 Nov 7 17:05:21 [145]
> ERROR:db_unixodbc:db_unixodbc_submit_query: rv=-1. Query= select
> table_version from version where table_name='dialog'
> Nov 7 17:05:21 [145] ERROR:db_unixodbc:db_unixodbc_extract_error:
> unixodbc:SQLExecDirect=42S02:1:-2106:Error in line: 1
>
> ####################
> __________________________________________________________
> Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe
> send an email to sr-users-leave@lists.kamailio.org
> Important: keep the mailing list in the recipients, do not reply only to the
> sender!
> Edit mailing list options or unsubscribe: