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 <[email protected]> > Sent: Donnerstag, 7. November 2024 10:27 > To: [email protected] > Cc: [email protected] > 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#[email protected]:5230/dm8") > #################### > DBG:db_unixodbc:db_unixodbc_new_connection: opening connection: > unixodbc://xxxx:[email protected]/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 [email protected] > Important: keep the mailing list in the recipients, do not reply only to the > sender! > Edit mailing list options or unsubscribe: __________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to [email protected] Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:
