Displaying 20 results from an estimated 600 matches similar to: "setting up ODBC for cdr logging into MariaDB"
2005 Feb 22
6
rodbc or unixodbc error
Hi,
I'm trying to establish a connection to a MySQL database, and am using the
rodbc package for it. This is in a GNU/Debian Linux box, with the
corresponding Debian unstable packages. I can login to my MySQL databases
from any shell and directory, so the problem is probably not there. Here's
an example of what I'm doing:
R> odbcConnect("test",
2009 Feb 12
4
Rails & unixODBC
Hello,
I decided to embrace getting a new Rails application to see an
existing MSSQL database and trying to get unixODBC, freeTDS, and
ActiveRecord able to query my MSSQL database.
I''m following the procedure outlined at
http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux
but my system (Ubuntu 8.10 - Intrepid Ibex, Rails 2.3, Ruby 1.8.7)
2008 Feb 23
2
MySQL Voicemail Storage Questions\Errors
I am running CentOS 5 with Asterisk 1.4.14. I am trying to setup storage of voicemail messages into MySQL. It is my understanding that I can only do this via ODBC. I installed per http://www.voip-info.org/wiki/view/CentOS+5+and+Asterisk+1.4.x+installation unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel and mysql-connector-odbc. I reconfigured and built Asterisk, using menuconfig to
2012 Jun 18
4
Asterisk 1.8.13.0 / problem with cdr logging (mysql, odbc)
Hi,
I am trying now for over 4 hours setting up cdr-logging via odbc into a
mysql database. But with no success. Do you have any hint for me?
cat /etc/odbc.ini
------------------
[MySQL-asterisk]
Description = MySQL ODBC Driver
Driver = MySQL
Socket = /var/run/mysqld/mysqld.sock
Server = localhost
User = xxx
Password = xxx
Database = asterisk
Option = 3
Port =
and
/etc/odbcinst.ini
2016 Mar 30
2
Asterisk 13.8.0 Now Available
Marek ?ervenka wrote:
> and what about
> https://www.asterisk-blog.com/2016/02/17/odbc_gutting/
While not in the email these are listed in the CHANGES and UPGRADE.txt
file. Going forward we'll try to ensure we include such things in the
release notes as well.
--
Joshua Colp
Digium, Inc. | Senior Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - US
Check us out at:
2017 Apr 19
3
How to build with cdr_adaptive_odbc ?
Than you very much.
I use asterisk 14, and yes, menuselect shows me the need for
generic_odbc(E), res_odbc_transaction(M) and ltdl(E)
but what does this imply under debian ?
I have unixodbc installed an tested and too libltdl-dev !
But what am I missing ?
On 04/19/2017 10:10 AM, Marcelo Terres wrote:
> What version of Asterisk are you using?
>
> When I go to cdr_adaptative_odbc in
2015 Feb 03
2
Problem with odbc connector with cdr
Hello,
I'm stuck with getting cdr records stored in MySql database. I have a
working realtime environment and have verified that the db connection works
fine when used via res_config_mysql.conf. I'd appreciate Your help on how
to get the odbc connector working as I think there's something wrong with
its configuration.
The problem presented itself as an error when making a call that
2006 Oct 29
1
Asterisk Voicemail with ODBC Realtime Access
Hi
I was trying to have realtime voicemail working with ODBC Driver.
Everything works fine with MySQL Realtime access, BUT as I want to implement
ODBC Storage as well, it seems that everything should go through ODBC ( what
I read on voip-info wiki page )
But I do not manage to make it work with ODBC.
Outside Asterisk, ODBC works fine, I can access my databases & tables !
Asterisk fails to
2005 Jul 27
5
cdr_mysql does not write to mysql db
Hi,
I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql db.
The problem is that no records are written to the db. Why?
I can import the csv-file to the db. so i assume the db is setup correct.
Is there any chance to get debug from cdr_mysql to find his problem?
This is my cdr_mysql.conf file:
[global]
hostname=localhost
dbname=cdr
password=passw0rd
user=root
;port=3306
2009 May 05
1
Asterisk cdr_odbc problems
I'm trying to get asterisk cdr_odbc configured, but it can't connect
through my odbc driver.
switchboard*CLI> module load cdr_odbc
[May 4 20:06:04] ERROR[17758]: cdr_odbc.c:358 odbc_load_module:
cdr_odbc: Unable to connect to datasource: asterisk
/etc/odbcinst.ini:
[MySQL]
Description = MySQL driver
Driver = /usr/lib/odbc/libmyodbc.so
Setup =
2010 Jan 12
1
FW: Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux
I think I figured this out. I should not have put the Driver name in
braces. Changing it from {MySQL} to MySQL seems to work.
-----Original Message-----
From: Marcus, Jeffrey
Sent: Tuesday, January 12, 2010 6:09 PM
To: 'r-help at r-project.org'
Subject: Problems connecting with MySQL using odbcDriverConnect (RODBC
package) on Linux
I am sure I'm doing something wrong here but not
2004 Jan 09
1
R and Postgresql (DBI)
Hi,
I'm running Debian (Sid), Postgres (7.3.4) and
R (1.8.1).
I get the following error when I tri to use DBI
>library("DBI")
> p <- dbDriver("PostgreSQL")
Error in do.call(as.character(drvName), list(...)) :
couldn't find function "PostgreSQL"
Is there any other package I need in order to
interface between R and Postgres ?
2012 Feb 26
10
Software Profili2 on Ubuntu by Wine
Hi
Greetings to all
Is my first post in this forum
sorry for my english
Many compliment to all developers for great work in Wine
Profili2 is the most famous Windows software for designe airfoil profile for RC airplane models.
Some times ago I have installed it in ubuntu 10.10 by Wine(1.3.5) with success
This software use an mdb file
First I have installed Profili download in this web site
2005 Mar 15
6
Realtime config
Having problems getting realtime working, I'm trying to use odbc for all
of this. I've got Fedora 3 and have been fighting with odbc for a day
now. I think I got it working correctly, however I can't seem to get the
realtime portion working. In asterisk 'odbc show' shows it connected, I
see it on my (odbc) mysql server connected and all, it connects and just
idles. So, without
1999 Jan 23
4
smbwrapper
> What you are looking for is smbwrapper, which is in fact included with
Samba
> 2.0. However as it is not supported on all systems it is not included
> in the default build (it should work nicely on Solaris though).
> Essentially smbwrapper is a preloaded library which intercepts system
calls and
> simulates a /smb filesystem, so you can access /smb/SERVER/SHARE/file.txt.
2016 Feb 09
2
CDR ODBC error
I am trying to get cdr via odbc to work on Asterisk 13.7.2 but I
keep getting this error:
[Feb 9 16:21:43] WARNING[2088]: cdr_odbc.c:160 execute_cb: cdr_odbc:
Error in ExecDirect: -1, query is: INSERT INTO cdr
(calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield,peeraccount,linkedid,sequence)
VALUES ({ts
2010 Jul 21
1
asterisk realtime SIP configuration
Hi All,
I am trying to configure asterisk realtime. But i am unable to get the
extensions listed successfully when i type "sip show peers" in the asterisk
CLI . i am unable to see any failure logs when i do a reload
i can able to connect to the data source through "odbc show" in the
CLI, Any hep in this regard is highly appreciated. Following is the
configuration
2006 Nov 05
1
Reading Voicemail Config from MySQL
Hi all,
I have been trying to get my asterisk (v1.2.10) to lookup voicemail
config data from my mysql database as opposed to voicemail.conf +
sip.conf for my users. Users register with SER and get passed through
to asterisk when they dial out. I followed the instructions as per
http://www.voip-info.org/wiki/view/Asterisk+voicemail+database
so basically I have
1) Build asterisk-addons-1.2.5 and
2006 Jun 17
1
ODBC cdr tearing my hair out
svn trunk.
I'm trying to get cdr to work with my odbc database. I have followed a
checklist that I had previously but still can't get it to work. There
are no errors (verbose 40 and debug 40), I get
[cdr_odbc.so] => (ODBC CDR Backend)
== Parsing '/etc/asterisk/cdr_odbc.conf': Found
*CLI> cdr status
CDR logging: enabled
CDR mode: simple
CDR registered backend:
2009 Aug 12
1
In odbcDriverConnect ODBC connection failed
R-sig-Debian help,
I have installed an ODBC Driver for Linux.
I want to connect to our database through R via:
>library(RODBC)
>con <- odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS")
Warning message:
In odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS") :
ODBC connection failed
I don't really know whether this