https:\/\/wiki.asterisk.org\/wiki\/display\/AST\/Getting+Asterisk+Connected+to+MySQL+via+ODBC
\nhttps:\/\/wiki.asterisk.org\/wiki\/display\/AST\/Configuring+res_odbc<\/p>\n
\todbcinst.ini
\n===================<\/p>\n
\r\n[MySQL]\r\nDescription = ODBC for MySQL\r\nDriver = \/usr\/lib\/odbc\/libmyodbc.so\r\nSetup = \/usr\/lib\/odbc\/libodbcmyS.so\r\nFileUsage = 1\r\n<\/pre>\n\todbc.ini
\n===============<\/p>\n\r\n[asterisk-connector]\r\nDescription\t= MySQL connection to 'asterisk' database\r\nDriver = MySQL\r\nDatabase = asterisk\r\nServer = localhost\r\nPort = 3306\r\nSocket = \/var\/lib\/mysqld\/mysqld.sock\r\n<\/pre>\n\tres_odbc.conf
\n====================<\/p>\n\r\n[asterisk]\r\nenabled => yes\r\ndsn => asterisk-connector\t\/\/ points to DB connection in odbc.ini\r\nusername => asterisk\r\npassword => welcome\r\npooling => no\r\nlimit => 1\r\npre-connect => yes\r\n<\/pre>\n\tcdr_adaptive_odbc.conf
\n==============================<\/p>\n\r\nconnection = asterisk \/\/ The database connection to be used. This is a reference \r\n \/\/ to the configured connection in res_odbc.conf. This field is required.\r\ntable = \/\/ The table name. This field is required.\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"https:\/\/wiki.asterisk.org\/wiki\/display\/AST\/Getting+Asterisk+Connected+to+MySQL+via+ODBC https:\/\/wiki.asterisk.org\/wiki\/display\/AST\/Configuring+res_odbc odbcinst.ini =================== [MySQL] Description = ODBC for MySQL Driver = \/usr\/lib\/odbc\/libmyodbc.so Setup = \/usr\/lib\/odbc\/libodbcmyS.so FileUsage = 1 odbc.ini =============== [asterisk-connector] Description = MySQL connection to ‘asterisk’ database Driver = MySQL Database = asterisk Server = localhost Port = 3306 Socket = \/var\/lib\/mysqld\/mysqld.sock res_odbc.conf ==================== [asterisk] enabled => yes dsn => asterisk-connector \/\/ points […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[43,221],"class_list":["post-986","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-asterisk","tag-odbc"],"_links":{"self":[{"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=\/wp\/v2\/posts\/986","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=986"}],"version-history":[{"count":3,"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=\/wp\/v2\/posts\/986\/revisions"}],"predecessor-version":[{"id":989,"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=\/wp\/v2\/posts\/986\/revisions\/989"}],"wp:attachment":[{"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=986"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=986"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=986"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}