API tools faq
paste
TheGerman

How to install & configure Asterisk x MariaDB ODBC / Debian

TheGerman
Feb 10th, 2019
108
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.26 KB | None | 0 0
raw download clone embed print report
  1. How to install and configure MariaDB ODBC for Asterisk running on a Debian 9
  2.  
  3. System: Debian 9, 64 bits, Asterisk 16.1.1, MariaDB v.10 (10.1.37-0+deb9u1)
  4.  
  5. * IMPORTANT *
  6. Don't waste your time - install the MariaDB ODBC connector version 2.0.15. Don't go for the latest version. Just use the one that is working for the scenario (Debian 9+Ast16+MariaDB 10)
  7.  
  8. Download MariaDB ODBC connector version 2.0.15 at
  9. https://downloads.mariadb.com/Connectors/odbc/connector-odbc-2.0.15/mariadb-connector-odbc-2.0.15-ga-debian-x86_64.tar.gz
  10.  
  11. Unpack file and move libmaodbc.so to /usr/lib/x86_64-linux-gnu/odbc/
  12.  
  13. Check dependencies:
  14. ldd /usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so
  15.  
  16. IF everything is ok, this is the result:
  17. linux-vdso.so.1 (0x00007ffe965a3000)
  18. libodbcinst.so.2 => /usr/lib/x86_64-linux-gnu/libodbcinst.so.2 (0x00007fd2192c4000)
  19. libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007fd218fc0000)
  20. libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fd218c21000)
  21. libltdl.so.7 => /usr/lib/x86_64-linux-gnu/libltdl.so.7 (0x00007fd218a17000)
  22. libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007fd2187fa000)
  23. /lib64/ld-linux-x86-64.so.2 (0x00007fd219781000)
  24. libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007fd2185f6000)
  25.  
  26. #################### ASTERISK ####################
  27.  
  28. /etc/asterisk/cdr_adaptive_odbc.conf:
  29. [adaptive_connection]
  30. connection=asterisk-connector
  31. table=cdr
  32. loguniqueid=yes
  33. table=cdr
  34. alias start => calldate
  35.  
  36. /etc/asterisk/res_odbc.conf
  37. [ENV]
  38. ODBCSYSINI => /etc
  39. ODBCINI => /etc/odbc.ini
  40.  
  41. [asterisk-connector]
  42. enabled => yes
  43. dsn => asterisk-connector
  44. username => YOUR_MARIADB_ASTERISKCDR_USERNAME
  45. password => YOUR_VERY_STRONG_MARIADB_PASSWORD
  46. pre-connect => yes
  47.  
  48. #################### ODBC ####################
  49.  
  50. /etc/odbcinst.ini
  51. [MariaDB]
  52. Description=MariaDB
  53. Driver=/usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so
  54. Setup=/usr/lib/x86_64-linux-gnu/odbc/libmdbodbc.so
  55. FileUsage=1
  56. UsageCount=2
  57.  
  58. /etc/odbc.ini
  59. [asterisk-connector]
  60. Description=MariaDB connection to 'asterisk' database
  61. Driver=MariaDB
  62. Database=asterisk
  63. Servername=localhost
  64. UserName=YOUR_MARIADB_ASTERISKCDR_USERNAME
  65. Password=YOUR_VERY_STRONG_MARIADB_PASSWORD
  66. Port=3306
  67. Socket=/var/run/mysqld/mysqld.sock
  68.  
  69. #################### TEST YOUR CONNECTION ####################
  70.  
  71. isql -v asterisk-connector YOUR_MARIADB_ASTERISKCDR_USERNAME YOUR_VERY_STRONG_MARIADB_PASSWORD
  72.  
  73. If everything is OK, this is the result:
  74.  
  75. +---------------------------------------+
  76. | Connected! |
  77. | |
  78. | sql-statement |
  79. | help [tablename] |
  80. | quit |
  81. | |
  82. +---------------------------------------+
  83. SQL>
  84.  
  85.  
  86. Enjoy!!!!!!!!!!!!
  87.  
  88.  
  89. MariaDB and ODBC packages installed (may not be necessary):
  90. ii dbconfig-mysql 2.0.8 all dbconfig-common MySQL/MariaDB support
  91. ii libdbd-mysql-perl 4.041-2 amd64 Perl5 database interface to the MariaDB/MySQL database
  92. ii libmariadbclient18:amd64 10.1.37-0+deb9u1 amd64 MariaDB database client library
  93. ii mariadb-client-10.1 10.1.37-0+deb9u1 amd64 MariaDB database client binaries
  94. ii mariadb-client-core-10.1 10.1.37-0+deb9u1 amd64 MariaDB database core client binaries
  95. ii mariadb-common 10.1.37-0+deb9u1 all MariaDB common metapackage
  96. ii mariadb-server 10.1.37-0+deb9u1 all MariaDB database server (metapackage depending on the latest version)
  97. ii mariadb-server-10.1 10.1.37-0+deb9u1 amd64 MariaDB database server binaries
  98. ii mariadb-server-core-10.1 10.1.37-0+deb9u1 amd64 MariaDB database core server files
  99. ii mycli 1.8.1-2 all CLI for MySQL/MariaDB
  100. ii libodbc1:amd64 2.3.4-1 amd64 ODBC library for Unix
  101. ii odbcinst 2.3.4-1 amd64 Helper program for accessing odbc ini files
  102. ii odbcinst1debian2:amd64 2.3.4-1 amd64 Support library for accessing odbc ini files
  103. ii unixodbc 2.3.4-1 amd64 Basic ODBC tools
  104. ii unixodbc-dev 2.3.4-1 amd64 ODBC libraries for UNIX (development files)
  105.  
  106.  
  107.  
  108. Other resources:
  109. Getting Asterisk Connected to MySQL via ODBC
  110. https://wiki.asterisk.org/wiki/display/AST/Getting+Asterisk+Connected+to+MySQL+via+ODBC
  111.  
  112. Asterisk+ODBC
  113. https://forums.asterisk.org/viewtopic.php?t=10891
  114.  
  115. Installing and Configuring ODBC
  116. http://asteriskdocs.org/en/2nd_Edition/asterisk-book-html-chunk/installing_configuring_odbc.html
  117.  
  118. debian 9 + odbc + mariadb : [01000] Can't open lib , file not found
  119. https://stackoverflow.com/questions/47179236/debian-9-odbc-mariadb-01000-cant-open-lib-file-not-found
  120. (check reply dated Jan 29 '18 at 1:55 from 0xdeface)
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!