Re: [Freeswitch-users] Error on mod_nibblebill cannot connect to ODBC

2009-06-18 Thread Darren Schreiber 
Call me crazy but your DB DSN appears to be zenoss, but you have a db dsn of
tcapi still in the config file.

If your test was:
# isql zenoss edmar edmar 
 

Then zenoss should be your db_dsn:
param name=db_dsn value=zenoss/

Not
param name=db_dsn value=tcapi/


You should be seeing something about the ODBC connection failing at
FreeSWITCH startup if you look at the log closely (search for
mod_nibblebill) that indicates this, too.

- Darren


-Original Message-
From: Edmar Cruz [mailto:darklio...@yahoo.com] 
Sent: Tuesday, June 16, 2009 6:44 PM
To: freeswitch-users@lists.freeswitch.org
Subject: Re: [Freeswitch-users] Error on mod_nibblebill cannot connect to
ODBC


my nibble.conf.xml

configuration name=nibblebill.conf description=Nibble Billing
  settings
   

!-- Information for connecting to your database --
param name=db_username value=edmar/
param name=db_password value=edmar/
param name=db_dsn value=tcapi/

!-- The database table where your CASH column is located --


!-- The column name where we store the value of the account --
param name=db_column_cash value=cash/

!-- The column name for the unique ID identifying the account --
param name=db_column_account value=id/


!-- Default heartbeat interval. Set to 'off' for no heartbeat (i.e.
bill only at end of call) --
param name=global_heartbeat value=1/

!-- By default, warn a caller when their balance is at $5.00. You can
set this to a negative number. --
param name=lowbal_amt value=5/
param name=lowbal_action value=play ding/

!-- By default, terminate a caller when their balance hits $0.00. You
can set this to a negative number. --
param name=nobal_amt value=0/
param name=nobal_action value=hangup/

!-- If a call goes beyond a certain dollar amount, flag or terminate it
--
param name=percall_max_amt value=100/
param name=percall_action value=hangup/

  /settings
/configuration

Account 1001.xml

include
  user id=1001 mailbox=1001
params
  param name=password value=1234/
  param name=vm-password value=1001/
  param name=vm-mailto value=/
  param name=vm-email-all-messages value=false/
  param name=vm-delete-file value=false/
  param name=vm-attach-file value=false/
/params
variables
  variable name=toll_allow value=domestic,international,local/
  variable name=accountcode value=1001/
  variable name=user_context value=default/
  variable name=effective_caller_id_name value=Extension 1001/
  !--variable name=nibble_rate value=0.10/
  variable name=nibble_account value=1001/--
  variable name=effective_caller_id_number value=1001/
  variable name=outbound_caller_id_name
value=$${outbound_caller_name}/
  variable name=outbound_caller_id_number
value=$${outbound_caller_id}/
  variable name=callgroup value=techsupport/
  variable name=name value=Edmar/
  variable name=label value=/
  variable name=areacode value=63/
  variable name=effective_caller_int_name value=/
  variable name=effective_caller_int_number value=/
  variable name=record_calls value=false/
  variable name=vm_active value=true/
  variable name=process_cdr value=false/
  variable name=cfwd_active value=false/
  variable name=cfwd_dest value=/
  variable name=cfwd_busyactive value=false/
  variable name=cfwd_busydest value=/
  variable name=cfwd_noansweractive value=false/
  variable name=cfwd_noanswerdest value=/
  variable name=cfwd_noanswerseconds value=/
  variable name=call_progressaudio value=0/
  variable name=allow_outbound value=true/
  variable name=allow_xfer value=false/
  variable name=hotline_active value=true/
  variable name=hotline_dest value=/
  variable name=classofservice value=0/
/variables
  /user
/include


I check unixodbc has been installed. 

# isql zenoss edmar edmar 
[SQL]

Connected successfully but on freeswitch error Cannot connect to user ODBC
[root]


Darren Schreiber wrote:
 
 What is in your ODBC settings in nibblebill.conf.xml ? Can you paste the
 real logs from FS's logs? The info below is not nearly detailed enough. 
 
 -Original Message-
 From: Edmar Cruz [mailto:darklio...@yahoo.com] 
 Sent: Monday, June 15, 2009 6:44 PM
 To: freeswitch-users@lists.freeswitch.org
 Subject: [Freeswitch-users] Error on mod_nibblebill cannot connect to ODBC
 
 
 Hi
 
 I experiencing an error on mod_nibblebill. I already load it from
 autoload_configs, especially mod_spidermonkey. Uncomment
 mod_spidermonkey_odbc. I also download unixodbc and created the files
 /etc/odbcinst.ini and /etc/odbc.ini with the correct format
 
 [zenoss]
 DATABASE = tcapi
 USER= root
 PASS= password
 .
 
 I type also on the console isql zenoss root password. Also working...
 
 But an error occur on freeswitch Cannot connect to user [root] ...
 
 What do you thinks is the problem?
 --
 View this message

Re: [Freeswitch-users] Error on mod_nibblebill cannot connect to ODBC

2009-06-18 Thread Edmar Cruz 

Ok thanks a lot for that. Sorry my mistake..

Darren Schreiber wrote:
 
 Call me crazy but your DB DSN appears to be zenoss, but you have a db dsn
 of
 tcapi still in the config file.
 
 If your test was:
 # isql zenoss edmar edmar 
  
 
 Then zenoss should be your db_dsn:
 
 
 Not
 
 
 
 You should be seeing something about the ODBC connection failing at
 FreeSWITCH startup if you look at the log closely (search for
 mod_nibblebill) that indicates this, too.
 
 - Darren
 
 
 -Original Message-
 From: Edmar Cruz [mailto:darklio...@yahoo.com] 
 Sent: Tuesday, June 16, 2009 6:44 PM
 To: freeswitch-users@lists.freeswitch.org
 Subject: Re: [Freeswitch-users] Error on mod_nibblebill cannot connect to
 ODBC
 
 
 my nibble.conf.xml
 
 configuration name=nibblebill.conf description=Nibble Billing
   settings

 
 !-- Information for connecting to your database --
 param name=db_username value=edmar/
 param name=db_password value=edmar/
 param name=db_dsn value=tcapi/
 
 !-- The database table where your CASH column is located --
 
 
 !-- The column name where we store the value of the account --
 param name=db_column_cash value=cash/
 
 !-- The column name for the unique ID identifying the account --
 param name=db_column_account value=id/
 
 
 !-- Default heartbeat interval. Set to 'off' for no heartbeat (i.e.
 bill only at end of call) --
 param name=global_heartbeat value=1/
 
 !-- By default, warn a caller when their balance is at $5.00. You can
 set this to a negative number. --
 param name=lowbal_amt value=5/
 param name=lowbal_action value=play ding/
 
 !-- By default, terminate a caller when their balance hits $0.00. You
 can set this to a negative number. --
 param name=nobal_amt value=0/
 param name=nobal_action value=hangup/
 
 !-- If a call goes beyond a certain dollar amount, flag or terminate
 it
 --
 param name=percall_max_amt value=100/
 param name=percall_action value=hangup/
 
   /settings
 /configuration
 
 Account 1001.xml
 
 include
   user id=1001 mailbox=1001
 params
   param name=password value=1234/
   param name=vm-password value=1001/
   param name=vm-mailto value=/
   param name=vm-email-all-messages value=false/
   param name=vm-delete-file value=false/
   param name=vm-attach-file value=false/
 /params
 variables
   variable name=toll_allow value=domestic,international,local/
   variable name=accountcode value=1001/
   variable name=user_context value=default/
   variable name=effective_caller_id_name value=Extension 1001/
   !--variable name=nibble_rate value=0.10/
   variable name=nibble_account value=1001/--
   variable name=effective_caller_id_number value=1001/
   variable name=outbound_caller_id_name
 value=$${outbound_caller_name}/
   variable name=outbound_caller_id_number
 value=$${outbound_caller_id}/
   variable name=callgroup value=techsupport/
   variable name=name value=Edmar/
   variable name=label value=/
   variable name=areacode value=63/
   variable name=effective_caller_int_name value=/
   variable name=effective_caller_int_number value=/
   variable name=record_calls value=false/
   variable name=vm_active value=true/
   variable name=process_cdr value=false/
   variable name=cfwd_active value=false/
   variable name=cfwd_dest value=/
   variable name=cfwd_busyactive value=false/
   variable name=cfwd_busydest value=/
   variable name=cfwd_noansweractive value=false/
   variable name=cfwd_noanswerdest value=/
   variable name=cfwd_noanswerseconds value=/
   variable name=call_progressaudio value=0/
   variable name=allow_outbound value=true/
   variable name=allow_xfer value=false/
   variable name=hotline_active value=true/
   variable name=hotline_dest value=/
   variable name=classofservice value=0/
 /variables
   /user
 /include
 
 
 I check unixodbc has been installed. 
 
 # isql zenoss edmar edmar 
 [SQL]
 
 Connected successfully but on freeswitch error Cannot connect to user ODBC
 [root]
 
 
 Darren Schreiber wrote:
 
 What is in your ODBC settings in nibblebill.conf.xml ? Can you paste the
 real logs from FS's logs? The info below is not nearly detailed enough. 
 
 -Original Message-
 From: Edmar Cruz [mailto:darklio...@yahoo.com] 
 Sent: Monday, June 15, 2009 6:44 PM
 To: freeswitch-users@lists.freeswitch.org
 Subject: [Freeswitch-users] Error on mod_nibblebill cannot connect to
 ODBC
 
 
 Hi
 
 I experiencing an error on mod_nibblebill. I already load it from
 autoload_configs, especially mod_spidermonkey. Uncomment
 mod_spidermonkey_odbc. I also download unixodbc and created the files
 /etc/odbcinst.ini and /etc/odbc.ini with the correct format
 
 [zenoss]
 DATABASE = tcapi
 USER= root
 PASS= password
 .
 
 I type also on the console isql zenoss root password

Re: [Freeswitch-users] Error on mod_nibblebill cannot connect to ODBC

2009-06-16 Thread bakko 
Did you compiled freeswitch with this command?

./configure --enable-core-odbc-support
makemake installRegards

___
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

Re: [Freeswitch-users] Error on mod_nibblebill cannot connect to ODBC

2009-06-16 Thread dujinfang 
current configure will automatically use odbc if it's available, no  
need the --enable-core-odbc-support anymore.
better to check if unixodbc-dev package installed of not.


On Jun 16, 2009, at 8:51 PM, bakko wrote:

 Did you compiled freeswitch with this command?

 ./configure --enable-core-odbc-support
 makemake installRegards

 ___
 Freeswitch-users mailing list
 Freeswitch-users@lists.freeswitch.org
 http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
 UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
 http://www.freeswitch.org


___
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

Re: [Freeswitch-users] Error on mod_nibblebill cannot connect to ODBC

2009-06-16 Thread Darren Schreiber 
What is in your ODBC settings in nibblebill.conf.xml ? Can you paste the
real logs from FS's logs? The info below is not nearly detailed enough. 

-Original Message-
From: Edmar Cruz [mailto:darklio...@yahoo.com] 
Sent: Monday, June 15, 2009 6:44 PM
To: freeswitch-users@lists.freeswitch.org
Subject: [Freeswitch-users] Error on mod_nibblebill cannot connect to ODBC


Hi

I experiencing an error on mod_nibblebill. I already load it from
autoload_configs, especially mod_spidermonkey. Uncomment
mod_spidermonkey_odbc. I also download unixodbc and created the files
/etc/odbcinst.ini and /etc/odbc.ini with the correct format

[zenoss]
DATABASE = tcapi
USER= root
PASS= password
.

I type also on the console isql zenoss root password. Also working...

But an error occur on freeswitch Cannot connect to user [root] ...

What do you thinks is the problem?
--
View this message in context:
http://www.nabble.com/Error-on-mod_nibblebill-cannot-connect-to-ODBC-tp24045
890p24045890.html
Sent from the Freeswitch-users mailing list archive at Nabble.com.


___
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org


___
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

Re: [Freeswitch-users] Error on mod_nibblebill cannot connect to ODBC

2009-06-16 Thread Edmar Cruz 

my nibble.conf.xml

configuration name=nibblebill.conf description=Nibble Billing
  settings
   

!-- Information for connecting to your database --




!-- The database table where your CASH column is located --


!-- The column name where we store the value of the account --


!-- The column name for the unique ID identifying the account --



!-- Default heartbeat interval. Set to 'off' for no heartbeat (i.e.
bill only at end of call) --


!-- By default, warn a caller when their balance is at $5.00. You can
set this to a negative number. --



!-- By default, terminate a caller when their balance hits $0.00. You
can set this to a negative number. --



!-- If a call goes beyond a certain dollar amount, flag or terminate it
--



  /settings
/configuration

Account 1001.xml

include
  user id=1001 mailbox=1001
params
  
  
  
  
  
  
/params
variables
  variable name=toll_allow value=domestic,international,local/
  variable name=accountcode value=1001/
  variable name=user_context value=default/
  variable name=effective_caller_id_name value=Extension 1001/
  !--variable name=nibble_rate value=0.10/
  variable name=nibble_account value=1001/--
  variable name=effective_caller_id_number value=1001/
  variable name=outbound_caller_id_name
value=$${outbound_caller_name}/
  variable name=outbound_caller_id_number
value=$${outbound_caller_id}/
  variable name=callgroup value=techsupport/
  variable name=name value=Edmar/
  variable name=label value=/
  variable name=areacode value=63/
  variable name=effective_caller_int_name value=/
  variable name=effective_caller_int_number value=/
  variable name=record_calls value=false/
  variable name=vm_active value=true/
  variable name=process_cdr value=false/
  variable name=cfwd_active value=false/
  variable name=cfwd_dest value=/
  variable name=cfwd_busyactive value=false/
  variable name=cfwd_busydest value=/
  variable name=cfwd_noansweractive value=false/
  variable name=cfwd_noanswerdest value=/
  variable name=cfwd_noanswerseconds value=/
  variable name=call_progressaudio value=0/
  variable name=allow_outbound value=true/
  variable name=allow_xfer value=false/
  variable name=hotline_active value=true/
  variable name=hotline_dest value=/
  variable name=classofservice value=0/
/variables
  /user
/include


I check unixodbc has been installed. 

# isql zenoss edmar edmar 
[SQL]

Connected successfully but on freeswitch error Cannot connect to user ODBC
[root]


Darren Schreiber wrote:
 
 What is in your ODBC settings in nibblebill.conf.xml ? Can you paste the
 real logs from FS's logs? The info below is not nearly detailed enough. 
 
 -Original Message-
 From: Edmar Cruz [mailto:darklio...@yahoo.com] 
 Sent: Monday, June 15, 2009 6:44 PM
 To: freeswitch-users@lists.freeswitch.org
 Subject: [Freeswitch-users] Error on mod_nibblebill cannot connect to ODBC
 
 
 Hi
 
 I experiencing an error on mod_nibblebill. I already load it from
 autoload_configs, especially mod_spidermonkey. Uncomment
 mod_spidermonkey_odbc. I also download unixodbc and created the files
 /etc/odbcinst.ini and /etc/odbc.ini with the correct format
 
 [zenoss]
 DATABASE = tcapi
 USER= root
 PASS= password
 .
 
 I type also on the console isql zenoss root password. Also working...
 
 But an error occur on freeswitch Cannot connect to user [root] ...
 
 What do you thinks is the problem?
 --
 View this message in context:
 http://www.nabble.com/Error-on-mod_nibblebill-cannot-connect-to-ODBC-tp24045
 890p24045890.html
 Sent from the Freeswitch-users mailing list archive at Nabble.com.
 
 
 ___
 Freeswitch-users mailing list
 Freeswitch-users@lists.freeswitch.org
 http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
 UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
 http://www.freeswitch.org
 
 
 ___
 Freeswitch-users mailing list
 Freeswitch-users@lists.freeswitch.org
 http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
 UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
 http://www.freeswitch.org
 
 

-- 
View this message in context: 
http://www.nabble.com/Error-on-mod_nibblebill-cannot-connect-to-ODBC-tp24045890p24065638.html
Sent from the Freeswitch-users mailing list archive at Nabble.com.


___
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

[Freeswitch-users] Error on mod_nibblebill cannot connect to ODBC

2009-06-15 Thread Edmar Cruz 

Hi

I experiencing an error on mod_nibblebill. I already load it from
autoload_configs, especially mod_spidermonkey. Uncomment
mod_spidermonkey_odbc. I also download unixodbc and created the files
/etc/odbcinst.ini and /etc/odbc.ini with the correct format

[zenoss]
DATABASE = tcapi
USER= root
PASS= password
.

I type also on the console isql zenoss root password. Also working...

But an error occur on freeswitch Cannot connect to user [root] ...

What do you thinks is the problem?
-- 
View this message in context: 
http://www.nabble.com/Error-on-mod_nibblebill-cannot-connect-to-ODBC-tp24045890p24045890.html
Sent from the Freeswitch-users mailing list archive at Nabble.com.


___
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org