Re: [asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR

2010-08-02 Thread Andraž
No, from sources version 0.64 it's working fine.

On Sat, Jul 31, 2010 at 10:59 AM, Tzafrir Cohen tzafrir.co...@xorcom.comwrote:

 On Fri, Jul 30, 2010 at 07:15:00AM -0400, Fred Posner wrote:
  On Jul 30, 2010, at 5:04 AM, Andraž wrote:
 
   Ok, problem is another, when I run configure, it write this:
   checking for tds_version in -ltds... no
   configure: ***
   configure: *** The FreeTDS installation on this system appears to be
 broken.
   configure: *** Either correct the installation, or run configure
   configure: *** without explicitly specifying --with-tds
   ODBC is not a good solution, only if I can change the names of CDR
 fields.

 Hmm what was the exact '--with-tds' option you used? Have you passed
 any explicit path?

  
   How can I repair the installlation?

 If the above: try just not passing any explicit path. Or maybe even
 skipping this option altogether.

 Also:

  Have you tried installing freetds from source?

 This suggestion does not make sense to me.

 The package 1.6.2 I have here builds cdr_tds just fine. The Ubuntu
 package likewise:

  http://packages.ubuntu.com/lucid/amd64/asterisk/filelist

 As you can see from its build dependencies:

  http://packages.ubuntu.com/source/lucid/asterisk

 It depends on libfreetds-dev

 Have you installed it?

 As a rule of thumb, using:

  aptitude build-dep asterisk

 might be a good start.

 --
   Tzafrir Cohen
 icq#16849755  
 jabber:tzafrir.co...@xorcom.comjabber%3atzafrir.co...@xorcom.com
 +972-50-7952406   mailto:tzafrir.co...@xorcom.com
 http://www.xorcom.com  iax:gu...@local.xorcom.com/tzafrir

 --
 _
  -- Bandwidth and Colocation Provided by http://www.api-digital.com --
 New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR

2010-07-31 Thread Tzafrir Cohen
On Fri, Jul 30, 2010 at 07:15:00AM -0400, Fred Posner wrote:
 On Jul 30, 2010, at 5:04 AM, Andraž wrote:
 
  Ok, problem is another, when I run configure, it write this:
  checking for tds_version in -ltds... no
  configure: ***
  configure: *** The FreeTDS installation on this system appears to be broken.
  configure: *** Either correct the installation, or run configure
  configure: *** without explicitly specifying --with-tds
  ODBC is not a good solution, only if I can change the names of CDR fields.

Hmm what was the exact '--with-tds' option you used? Have you passed
any explicit path?

   
  How can I repair the installlation?

If the above: try just not passing any explicit path. Or maybe even
skipping this option altogether.

Also:

 Have you tried installing freetds from source?

This suggestion does not make sense to me.

The package 1.6.2 I have here builds cdr_tds just fine. The Ubuntu
package likewise:

  http://packages.ubuntu.com/lucid/amd64/asterisk/filelist

As you can see from its build dependencies:

  http://packages.ubuntu.com/source/lucid/asterisk

It depends on libfreetds-dev

Have you installed it?

As a rule of thumb, using:

  aptitude build-dep asterisk

might be a good start.

-- 
   Tzafrir Cohen
icq#16849755  jabber:tzafrir.co...@xorcom.com
+972-50-7952406   mailto:tzafrir.co...@xorcom.com
http://www.xorcom.com  iax:gu...@local.xorcom.com/tzafrir

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR

2010-07-30 Thread Andraž
Ok, problem is another, when I run configure, it write this:
checking for tds_version in -ltds... no
configure: ***
configure: *** The FreeTDS installation on this system appears to be broken.
configure: *** Either correct the installation, or run configure
configure: *** without explicitly specifying --with-tds
ODBC is not a good solution, only if I can change the names of CDR fields.

How can I repair the installlation?

On Wed, Jul 28, 2010 at 2:58 PM, Andraž atle...@gmail.com wrote:

 I resolved this isue using odbc.


 On Mon, Jul 26, 2010 at 11:27 AM, Tzafrir Cohen 
 tzafrir.co...@xorcom.comwrote:

  On Mon, Jul 26, 2010 at 10:05:27AM +0200, Andraž wrote:
  Hi,
 
  I have Ubuntu server 10.04 64bit, and Asterisk 1.4.34, compiled from
  sources. I installed freetds-common,freetds-dev, libct4, libsybdb5,
  freetds-bin, but, when I run configure and then make menuconfig in
 section
  Call Detail Recording - cdr_tds it's disabled. It only writes
 that
  Depends on: freetds(E). On another server (same configuration) I
 installed
  the same packages, and it's working fine. Any suggestions, what I did
 wrong?

 Have you re-ron ./configure #?

 --
   Tzafrir Cohen
 icq#16849755  
 jabber:tzafrir.co...@xorcom.comjabber%3atzafrir.co...@xorcom.com
 +972-50-7952406   mailto:tzafrir.co...@xorcom.com
 http://www.xorcom.com  iax:gu...@local.xorcom.com/tzafrir

 --
 _
 -- Bandwidth and Colocation Provided by http://www.api-digital.com --
 New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users



-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR

2010-07-30 Thread Fred Posner
On Jul 30, 2010, at 5:04 AM, Andraž wrote:

 Ok, problem is another, when I run configure, it write this:
 checking for tds_version in -ltds... no
 configure: ***
 configure: *** The FreeTDS installation on this system appears to be broken.
 configure: *** Either correct the installation, or run configure
 configure: *** without explicitly specifying --with-tds
 ODBC is not a good solution, only if I can change the names of CDR fields.
  
 How can I repair the installlation?
 
 On Wed, Jul 28, 2010 at 2:58 PM, Andraž atle...@gmail.com wrote:
 I resolved this isue using odbc.
 
 
 On Mon, Jul 26, 2010 at 11:27 AM, Tzafrir Cohen tzafrir.co...@xorcom.com 
 wrote:
 On Mon, Jul 26, 2010 at 10:05:27AM +0200, Andraž wrote:
  Hi,
 
  I have Ubuntu server 10.04 64bit, and Asterisk 1.4.34, compiled from
  sources. I installed freetds-common,freetds-dev, libct4, libsybdb5,
  freetds-bin, but, when I run configure and then make menuconfig in section
  Call Detail Recording - cdr_tds it's disabled. It only writes that
  Depends on: freetds(E). On another server (same configuration) I installed
  the same packages, and it's working fine. Any suggestions, what I did wrong?
 
 Have you re-ron ./configure #?
 
 --
   Tzafrir Cohenv

Have you tried installing freetds from source?

wget ftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz
tar -zxvf freetds-stable.tgz
cd freetds-0.82
./configure --prefix=/usr --with-tdsver=7.0 --with-unixodbc=/usr/lib
or ./configure --prefix=/usr --with-tdsver=7.0 --with-unixodbc=/usr
make  make install


---fred
http://qxork.com


-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR

2010-07-30 Thread Andraž
From source also doesn't work. :(

On Fri, Jul 30, 2010 at 1:15 PM, Fred Posner f...@teamforrest.com wrote:

 On Jul 30, 2010, at 5:04 AM, Andraž wrote:

  Ok, problem is another, when I run configure, it write this:
  checking for tds_version in -ltds... no
  configure: ***
  configure: *** The FreeTDS installation on this system appears to be
 broken.
  configure: *** Either correct the installation, or run configure
  configure: *** without explicitly specifying --with-tds
  ODBC is not a good solution, only if I can change the names of CDR
 fields.
 
  How can I repair the installlation?
 
  On Wed, Jul 28, 2010 at 2:58 PM, Andraž atle...@gmail.com wrote:
  I resolved this isue using odbc.
 
 
  On Mon, Jul 26, 2010 at 11:27 AM, Tzafrir Cohen 
 tzafrir.co...@xorcom.com wrote:
  On Mon, Jul 26, 2010 at 10:05:27AM +0200, Andraž wrote:
   Hi,
  
   I have Ubuntu server 10.04 64bit, and Asterisk 1.4.34, compiled from
   sources. I installed freetds-common,freetds-dev, libct4, libsybdb5,
   freetds-bin, but, when I run configure and then make menuconfig in
 section
   Call Detail Recording - cdr_tds it's disabled. It only writes
 that
   Depends on: freetds(E). On another server (same configuration) I
 installed
   the same packages, and it's working fine. Any suggestions, what I did
 wrong?
 
  Have you re-ron ./configure #?
 
  --
Tzafrir Cohenv

 Have you tried installing freetds from source?

 wget
 ftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz
 tar -zxvf freetds-stable.tgz
 cd freetds-0.82
 ./configure --prefix=/usr --with-tdsver=7.0 --with-unixodbc=/usr/lib
or ./configure --prefix=/usr --with-tdsver=7.0 --with-unixodbc=/usr
 make  make install


 ---fred
 http://qxork.com


 --
  _
 -- Bandwidth and Colocation Provided by http://www.api-digital.com --
 New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR

2010-07-30 Thread A J Stiles
On Friday 30 Jul 2010, Andraž wrote:
 From source also doesn't work. :(

If you ran ldconfig to force update of library configuration after you 
installed the freetds you compiled, and re-ran ./configure in the asterisk 
build directory, and it still doesn't want to let you use freeTDS, then 
something else must be the problem.

It's possible that the configure script is getting confused with the FreeTDS 
installed using apt-get and the FreeTDS installed from source code.  So try
$ ./configure --with-tds=/usr/local/lib
to force it to use the freeTDS files found in /usr/local/lib  (make 
appropriate substitutions if required).


By the way:  Your reply belongs *under* whatever you are replying to.  Then, 
somebody reading the messages in future can see the proper flow of the 
conversation.

-- 
AJS

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR

2010-07-30 Thread Andraž
I removed freetds which I installed from apt-get. Run what you said and stil
doesn't work. :(

I just hit reply, so I don't touch the subject line.

On Fri, Jul 30, 2010 at 2:12 PM, A J Stiles
asterisk_l...@earthshod.co.ukwrote:

 On Friday 30 Jul 2010, Andraž wrote:
  From source also doesn't work. :(

 If you ran ldconfig to force update of library configuration after you
 installed the freetds you compiled, and re-ran ./configure in the asterisk
 build directory, and it still doesn't want to let you use freeTDS, then
 something else must be the problem.

 It's possible that the configure script is getting confused with the
 FreeTDS
 installed using apt-get and the FreeTDS installed from source code.  So try
 $ ./configure --with-tds=/usr/local/lib
 to force it to use the freeTDS files found in /usr/local/lib  (make
 appropriate substitutions if required).


 By the way:  Your reply belongs *under* whatever you are replying to.
  Then,
 somebody reading the messages in future can see the proper flow of the
 conversation.

 --
 AJS

 --
  _
 -- Bandwidth and Colocation Provided by http://www.api-digital.com --
 New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR

2010-07-30 Thread Sean Bright
  On 7/26/2010 4:05 AM, Andraž wrote:
 I have Ubuntu server 10.04 64bit, and Asterisk 1.4.34, compiled from 
 sources. I installed freetds-common,freetds-dev, libct4, libsybdb5, 
 freetds-bin, but, when I run configure and then make menuconfig in 
 section Call Detail Recording - cdr_tds it's disabled.
The packaged version of FreeTDS on 10.04 is 0.82 which is too recent for 
the Asterisk 1.4. cdr_tds module.  The latest version of FreeTDS 
supported by Asterisk 1.4 is 0.64.  So you will have to compile from 
source (or find an ancient package) to get this working.

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR

2010-07-30 Thread Andraž
Tnx, now it's working fine. :)

On Fri, Jul 30, 2010 at 5:16 PM, Sean Bright sean.bri...@gmail.com wrote:

  On 7/26/2010 4:05 AM, Andraž wrote:
  I have Ubuntu server 10.04 64bit, and Asterisk 1.4.34, compiled from
  sources. I installed freetds-common,freetds-dev, libct4, libsybdb5,
  freetds-bin, but, when I run configure and then make menuconfig in
  section Call Detail Recording - cdr_tds it's disabled.
 The packaged version of FreeTDS on 10.04 is 0.82 which is too recent for
 the Asterisk 1.4. cdr_tds module.  The latest version of FreeTDS
 supported by Asterisk 1.4 is 0.64.  So you will have to compile from
 source (or find an ancient package) to get this working.

 --
  _
 -- Bandwidth and Colocation Provided by http://www.api-digital.com --
 New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR

2010-07-28 Thread Andraž
I resolved this isue using odbc.

On Mon, Jul 26, 2010 at 11:27 AM, Tzafrir Cohen tzafrir.co...@xorcom.comwrote:

  On Mon, Jul 26, 2010 at 10:05:27AM +0200, Andraž wrote:
  Hi,
 
  I have Ubuntu server 10.04 64bit, and Asterisk 1.4.34, compiled from
  sources. I installed freetds-common,freetds-dev, libct4, libsybdb5,
  freetds-bin, but, when I run configure and then make menuconfig in
 section
  Call Detail Recording - cdr_tds it's disabled. It only writes that
  Depends on: freetds(E). On another server (same configuration) I
 installed
  the same packages, and it's working fine. Any suggestions, what I did
 wrong?

 Have you re-ron ./configure #?

 --
   Tzafrir Cohen
 icq#16849755  
 jabber:tzafrir.co...@xorcom.comjabber%3atzafrir.co...@xorcom.com
 +972-50-7952406   mailto:tzafrir.co...@xorcom.com
 http://www.xorcom.com  iax:gu...@local.xorcom.com/tzafrir

 --
 _
 -- Bandwidth and Colocation Provided by http://www.api-digital.com --
 New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

[asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR

2010-07-26 Thread Andraž
Hi,

I have Ubuntu server 10.04 64bit, and Asterisk 1.4.34, compiled from
sources. I installed freetds-common,freetds-dev, libct4, libsybdb5,
freetds-bin, but, when I run configure and then make menuconfig in section
Call Detail Recording - cdr_tds it's disabled. It only writes that
Depends on: freetds(E). On another server (same configuration) I installed
the same packages, and it's working fine. Any suggestions, what I did wrong?



Regards Andraž
attachment: cdr.PNG-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR

2010-07-26 Thread A J Stiles
On Monday 26 Jul 2010, Andraž wrote:
 Hi,

 I have Ubuntu server 10.04 64bit, and Asterisk 1.4.34, compiled from
 sources. I installed freetds-common,freetds-dev, libct4, libsybdb5,
 freetds-bin, but, when I run configure and then make menuconfig in section
 Call Detail Recording - cdr_tds it's disabled. It only writes that
 Depends on: freetds(E). On another server (same configuration) I
 installed the same packages, and it's working fine. Any suggestions, what I
 did wrong?

Run
$ dpkg -l
on both boxes, and compare the output.  (Don't forget, you can always do 
something like
$ ssh 10.11.12.13 'dpkg -l'  other_box_packages
to run a command on another machine and trap its output in a file on yours.  
Just substitute the appropriate IP address or hostname.)

Chances are, there's a -dev package you've missed out.

(Why distributions still persist in separating out -dev packages in these days 
of fast CPUs, broadband internet connections and terabyte hard disks is 
beyond me, but that's for another day .)

-- 
AJS

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR

2010-07-26 Thread Tzafrir Cohen
On Mon, Jul 26, 2010 at 10:05:27AM +0200, Andraž wrote:
 Hi,
 
 I have Ubuntu server 10.04 64bit, and Asterisk 1.4.34, compiled from
 sources. I installed freetds-common,freetds-dev, libct4, libsybdb5,
 freetds-bin, but, when I run configure and then make menuconfig in section
 Call Detail Recording - cdr_tds it's disabled. It only writes that
 Depends on: freetds(E). On another server (same configuration) I installed
 the same packages, and it's working fine. Any suggestions, what I did wrong?

Have you re-ron ./configure #?

-- 
   Tzafrir Cohen
icq#16849755  jabber:tzafrir.co...@xorcom.com
+972-50-7952406   mailto:tzafrir.co...@xorcom.com
http://www.xorcom.com  iax:gu...@local.xorcom.com/tzafrir

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users