Hello all,
I want to use Asterisk with MariaDB CDR backend.
I have working Asterisk.
I have working MariaDB.
As far as I understand, since Asterisk 11 I must use ODBC connector to
MariaDB.
Unfortunately I cannot find any practical info concerning OpenBSD,
Asterisk, ODBC and MariaDB.
I tried iodbc package but I cannot find mysql drivers.
Can anyone point me to some article or practical example?
I will provide any additional info if needed.
Thanks for the help,
Ivo
pkg_info, everything installed from packages and dmesg below:
~ # pkg_info
adwaita-icon-theme-3.14.1 base icon theme for GNOME
asterisk-11.16.0 open source multi-protocol PBX and telephony toolkit
asterisk-core-sounds-en-gsm-1.4.26 core English sound files for Asterisk
(gsm)
asterisk-moh-opsound-wav-2.03p2 opsound music-on-hold for Asterisk (wav)
asterisk-odbc-11.16.0 ODBC support for Asterisk
at-spi2-atk-2.14.1 atk-bridge for at-spi2
at-spi2-core-2.14.1 service interface for assistive technologies
atk-2.14.0 accessibility toolkit used by gtk+
avahi-0.6.31p15 framework for Multicast DNS Service Discovery
bzip2-1.0.6p1 block-sorting file compressor, unencumbered
cairo-1.14.0p1 vector graphics library
cups-libs-2.0.2 CUPS libraries and headers
curl-7.40.0 get files from FTP, Gopher, HTTP or HTTPS servers
dbus-1.8.16v0 message bus system
dconf-0.22.0p1 configuration backend system
desktop-file-utils-0.22 utilities for dot.desktop entries
e2fsprogs-1.42.12p0 utilities to manipulate ext2 filesystems
ffmpeg-20150107p0 audio/video converter and streamer
gcr-3.14.0p0 library for bits of crypto UI and parsing
gdbm-1.11p0 GNU dbm
gdk-pixbuf-2.30.8 graphic library for gtk+2
gettext-0.19.4 GNU gettext
glib2-2.42.1p0 general-purpose utility library
glib2-networking-2.42.1 network-related gio modules for glib2
gmp-5.0.2p2 library for arbitrary precision arithmetic
gnome-icon-theme-3.12.0p1 base icon theme for GNOME
gnome-icon-theme-symbolic-3.12.0p1 base icon theme extension for special
UI contexts
gnome-keyring-3.14.0 password agent for the GNOME project
gnupg-1.4.19 GNU privacy guard - a free PGP replacement
gnutls-3.2.21 GNU Transport Layer Security library
graphite2-1.2.4 rendering for complex writing systems
gsettings-desktop-schemas-3.14.1 collection of shared GSettings schemas
gsm-1.0.13p2 u-law to gsm encoding audio converter and library
gtk+2-2.24.26 multi-platform graphical toolkit
gtk+3-3.14.8 multi-platform graphical toolkit
gtk-update-icon-cache-2.24.26 gtk+ icon theme caching utility
harfbuzz-0.9.38 text shaping library
hicolor-icon-theme-0.14 fallback theme of the icon theme specification
iksemel-1.4p3 XML parser designed for Jabber applications
iodbc-3.52.9p1 ODBC 3.x driver manager
iodbc-admin-3.52.9p1 ODBC 3.x driver manager admin application
jasper-1.900.1p2 reference implementation of JPEG-2000
jpeg-9a IJG's JPEG compression utilities
lame-3.99.5 lame ain't an MP3 encoder
libbind-6.0p3v0 BIND stub resolver library
libcroco-0.6.8p0 generic CSS parsing library for GNOME project
libdaemon-0.14p0 lightweight C library that eases the writing of daemons
libdbi-0.8.4 database-independent abstraction layer
libdbi-drivers-mysql-0.8.3.1p4 mysql driver for libdbi
libelf-0.8.13p2 read, modify, create ELF files on any arch
libexecinfo-0.2p4v0 clone of backtrace facility found in the GNU libc
libffi-3.0.13 Foreign Function Interface
libgcrypt-1.6.3 crypto library based on code used in GnuPG
libgda-5.2.2p2v2 GNOME Data Access library
libgda-mysql-5.2.2p1v0 MySQL backend for libgda
libgpg-error-1.18 error codes for GnuPG related software
libiconv-1.14p1 character set conversion library
libidn-1.29p0 internationalized string handling
libnettle-2.7.1p1 cryptographic library
libogg-1.3.2 Ogg bitstream library
libproxy-0.4.11p3 library handling all the details of proxy configuration
librsvg-2.40.7 SAX-based render library for SVG files
libsecret-0.18 library for storing and retrieving passwords and secrets
libslang-2.2.4p0 stack-based interpreter for terminal applications
libsoup-2.48.1 HTTP client/server library for GNOME
libssh2-1.4.3 library implementing the SSH2 protocol
libtasn1-4.2p0 Abstract Syntax Notation One structure parser library
libtheora-1.1.1p2 open video codec
libvorbis-1.3.4 audio compression codec library
libvpx-1.3.0p1 Google VP8/VP9 video codec
libxml-2.9.2p0 XML parsing library
libxslt-1.1.28p0 XSLT C Library for GNOME
lzo2-2.08 portable speedy lossless data compression library
mariadb-client-10.0.16v0 multithreaded SQL database (client)
mariadb-server-10.0.16v0 multithreaded SQL database (server)
mariadb-tests-10.0.16v0 multithreaded SQL database (regression test
suite/benchmark)
mc-4.8.13 free Norton Commander clone with many useful features
mtr-0.86p0 Matt's traceroute - network diagnostic tool
oniguruma-5.9.2 regular expressions library
opencore-amr-0.1.3 implementation of the Adaptive Multi Rate speech codec
opus-1.1 IETF audio codec
orc-0.4.19 library and toolset to operate arrays of data
p11-kit-0.22.1 library for loading and enumurating of PKCS#11 modules
p5-Clone-0.37 recursively copy Perl datatypes
p5-DBD-mysql-4.029 MySQL drivers for the Perl DBI
p5-DBI-1.633 unified perl interface for database access
p5-FreezeThaw-0.5001 module for converting structures to strings and back
p5-MLDBM-2.05 store multi-level hash structure in single-level
tied hash
p5-Net-Daemon-0.48p0 extension for portable daemons
p5-Params-Util-1.07p0 utility to make parameter checking easier
p5-PlRPC-0.2018p2 module for writing rpc servers and clients
p5-SQL-Statement-1.405 sql parsing and processing
p5-Term-ReadKey-2.30p6 change terminal modes, and perform non-blocking reads
pango-1.36.8 library for layout and rendering of text
pcre-8.35 perl-compatible regular expression library
png-1.6.16 library for manipulating PNG images
portaudio-svn-1919 portable cross-platform audio API
python-2.7.9p0 interpreted object-oriented programming language
quirks-2.54 exceptions to pkg_add rules
rsync-3.1.1 mirroring/synchronization over low bandwidth links
schroedinger-1.0.11p0 high-speed Dirac codec
screen-4.0.3p4 multi-screen window manager
sdl-1.2.15p6 cross-platform multimedia library
shared-mime-info-1.4 shared mime database for desktops
spandsp-0.0.6pre21 DSP library for telephony
speex-1.2rc1p0 patent-free speech codec
tiff-4.0.3p2 tools and library routines for working with TIFF images
unzip-6.0p6 extract, list & test files in a ZIP archive
x264-20141218 free H.264/MPEG-4 AVC encoder
x265-1.5 free H.265/HEVC encoder
xvidcore-1.3.3 ISO MPEG-4 compliant video codec
xz-5.2.0 LZMA compression and decompression tools
zip-3.0 create/update ZIP files compatible with PKZip(tm)
Dmesg:
~ # dmesg
OpenBSD 5.7-stable (GENERIC) #3: Mon Jul 13 22:04:04 EEST 2015
r...@build.office.bgone.net:/usr/src/sys/arch/i386/compile/GENERIC
cpu0: Geode(TM) Integrated Processor by AMD PCS ("AuthenticAMD"
586-class) 499 MHz
cpu0: FPU,DE,PSE,TSC,MSR,CX8,SEP,PGE,CMOV,CFLUSH,MMX,MMXX,3DNOW2,3DNOW
real mem = 267931648 (255MB)
avail mem = 251179008 (239MB)
mpath0 at root
scsibus0 at mpath0: 256 targets
mainbus0 at root
bios0 at mainbus0: date 01/15/14, BIOS32 rev. 0 @ 0xfd0e4
pcibios0 at bios0: rev 2.1 @ 0xf0000/0x10000
pcibios0: pcibios_get_intr_routing - function not supported
pcibios0: PCI IRQ Routing information unavailable.
pcibios0: PCI bus #0 is the last bus
bios0: ROM list: 0xe0000/0xa800
cpu0 at mainbus0: (uniprocessor)
mtrr: K6-family MTRR support (2 registers)
pci0 at mainbus0 bus 0: configuration mode 1 (bios)
pchb0 at pci0 dev 1 function 0 "AMD Geode LX" rev 0x33
glxsb0 at pci0 dev 1 function 2 "AMD Geode LX Crypto" rev 0x00: RNG AES
vr0 at pci0 dev 9 function 0 "VIA VT6105M RhineIII" rev 0x96: irq 10,
address 00:0d:b9:39:46:88
ukphy0 at vr0 phy 1: Generic IEEE 802.3u media interface, rev. 3: OUI
0x004063, model 0x0034
vr1 at pci0 dev 10 function 0 "VIA VT6105M RhineIII" rev 0x96: irq 11,
address 00:0d:b9:39:46:89
ukphy1 at vr1 phy 1: Generic IEEE 802.3u media interface, rev. 3: OUI
0x004063, model 0x0034
vr2 at pci0 dev 11 function 0 "VIA VT6105M RhineIII" rev 0x96: irq 15,
address 00:0d:b9:39:46:8a
ukphy2 at vr2 phy 1: Generic IEEE 802.3u media interface, rev. 3: OUI
0x004063, model 0x0034
glxpcib0 at pci0 dev 15 function 0 "AMD CS5536 ISA" rev 0x03: rev 3,
32-bit 3579545Hz timer, watchdog, gpio, i2c
gpio0 at glxpcib0: 32 pins
iic0 at glxpcib0
maxtmp0 at iic0 addr 0x4c: lm86
pciide0 at pci0 dev 15 function 2 "AMD CS5536 IDE" rev 0x01: DMA,
channel 0 wired to compatibility, channel 1 wired to compatibility
wd0 at pciide0 channel 0 drive 0: <CHN-PADOM44HS01M-016S>
wd0: 1-sector PIO, LBA, 15279MB, 31293360 sectors
wd0(pciide0:0:0): using PIO mode 4, Ultra-DMA mode 2
pciide0: channel 1 ignored (disabled)
ohci0 at pci0 dev 15 function 4 "AMD CS5536 USB" rev 0x02: irq 12,
version 1.0, legacy support
ehci0 at pci0 dev 15 function 5 "AMD CS5536 USB" rev 0x02: irq 12
usb0 at ehci0: USB revision 2.0
uhub0 at usb0 "AMD EHCI root hub" rev 2.00/1.00 addr 1
isa0 at glxpcib0
isadma0 at isa0
com0 at isa0 port 0x3f8/8 irq 4: ns16550a, 16 byte fifo
com0: console
com1 at isa0 port 0x2f8/8 irq 3: ns16550a, 16 byte fifo
pcppi0 at isa0 port 0x61
spkr0 at pcppi0
npx0 at isa0 port 0xf0/16: reported by CPUID; using exception 16
usb1 at ohci0: USB revision 1.0
uhub1 at usb1 "AMD OHCI root hub" rev 1.00/1.00 addr 1
nvram: invalid checksum
vscsi0 at root
scsibus1 at vscsi0: 256 targets
softraid0 at root
scsibus2 at softraid0: 256 targets
root on wd0a (b2b90f1fe5add363.a) swap on wd0b dump on wd0b
clock: unknown CMOS layout
