Alls well that ends well !!! :-)
Maurizio Pederneschi wrote:
Great!
Thanks for your aid... I spend a lot of day around this problem...
Now realtime load returns data!
----- Original Message -----
From: "Tijl Van den Broeck" <[EMAIL PROTECTED]>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users@lists.digium.com>
Sent: Monday, October 23, 2006 7:52 AM
Subject: Re: [asterisk-users] Asterisk Realtime... Help Me!!!
Thanks alot!
Indeed it was the 3th solution, I changed
sipusers => odbc,MySQL-asterisk,sip_buddies
sippeers => odbc,MySQL-asterisk,sip_buddies
into
sipusers => odbc,mysql2,sip_buddies
sippeers => odbc,mysql2,sip_buddies
And "realtime load sipusers username 1006" now returns data :-)
greets
Tijl Van den Broeck
On 10/23/06, Benjamin Jacob <[EMAIL PROTECTED]> wrote:
Make additional checks :
1) ensure u've unixodbc, unixodbc-devel installed, use this command
rpm -qa | grep -i unixodbc
MUST see unixodbc and unixodbc-devel in the output!!!, else get
unixodbc and unixodbc-devel(am kinda guessing u do have that perfect).
2) /etc/odbcinst.ini and /etc/odbc.ini should be correct. cross check
3) Aaahh.. revelation!! I think, I know where you've gone wrong.
In your res_odbc.conf , you have given the database context as mysql(see
[mysql]).
This should be the same as the 2nd argument in ur extconfig.conf line
for realtime for your sipusers.
i.e. it should be
sipusers => odbc,mysql,sipusers
instead of
sipusers => odbc,asterisk,sipusers
This should work fine.
If it doesn't, paste your odbc.ini and odbcinst.ini files as well over
here.
or
give me ssh login access to your machine.(dont wory, wont mess up ur
machine).
cheerz
- Ben.
Maurizio Pederneschi wrote:
These are my conf file:
res_odbc.conf
;;; odbc setup file
; ENV is a global set of environmental variables that will get set.
; Note that all environmental variables can be seen by all connections,
; so you can't have different values for different connections.
[ENV]
INFORMIXSERVER => my_special_database
INFORMIXDIR => /opt/informix
; All other sections are arbitrary names for database connections.
;[asterisk]
;enabled => yes
;dsn => asterisk
;;username => myuser
;;password => mypass
;pre-connect => yes
[mysql]
enabled => yes
dsn => MySQL-asterisk
username => root
password =>
pre-connect => yes
---------------------------------------------------------------------------
-
-------------
extconfig.conf
;
; Static and realtime external configuration
; engine configuration
;
; Please read doc/README.extconfig for basic table
; formatting information.
;
[settings]
;
; Static configuration files:
;
; file.conf => driver,database[,table]
;
; maps a particular configuration file to the given
; database driver, database and table (or uses the
; name of the file as the table if not specified)
;
;uncomment to load queues.conf via the odbc engine.
;
;queues.conf => odbc,asterisk,ast_config
;
; The following files CANNOT be loaded from Realtime storage:
; asterisk.conf
; extconfig.conf (this file)
; logger.conf
;
; Additionally, the following files cannot be loaded from
; Realtime storage unless the storage driver is loaded
; early using 'preload' statements in modules.conf:
; manager.conf
; cdr.conf
; rtp.conf
;
;
; Realtime configuration engine
;
; maps a particular family of realtime
; configuration to a given database driver,
; database and table (or uses the name of
; the family if the table is not specified
;
;example => odbc,asterisk,alttable
;iaxusers => odbc,asterisk
;iaxpeers => odbc,asterisk
sipusers => odbc,asterisk,sipusers
;sippeers => odbc,asterisk
voicemail => odbc,asterisk
;extensions => odbc,asterisk
;queues => odbc,asterisk
;queue_members => odbc,asterisk
extensions => odbc,asterisk,extensions
---------------------------------------------------------------------------
-
------------------------------------
This is my table sipusers
| id | name | username | context | host | port | secret
|
allow | ipaddr | type | password |
| 1 | pippo | pippo | tutorial | dynamic | |
password |
g729;ilbc;gsm;ulaw;alaw | NULL | friend | password |
| 2 | testAsterisk | testAsterisk | tutorial | dynamic | |
password |
g729;ilbc;gsm;ulaw;alaw | NULL | friend | password |
---------------------------------------------------------------------------
-
----------------------------------------
This is the output of the "realtime load" command:
realtime load sipusers name pippo
No rows found matching search criteria.
Thank's
Maury
----- Original Message -----
From: "Benjamin Jacob" <[EMAIL PROTECTED]>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users@lists.digium.com>
Sent: Friday, October 20, 2006 12:39 PM
Subject: Re: [asterisk-users] Asterisk Realtime... Help Me!!!
Maurizio Pederneschi wrote:
Hi,
i have implemented Asterisk Realtime architecture with Odbc and MySql
DB. I have followed all the step of the documentation I found on the
Internet.
On the CLI, if I make "odbc show" I see that the DB connection is
"UP", but if I make "realtime load <family> <column> <value>" both
with extensions family or with sipusers family, I can't find anything
in the db.
Why it happens? What can I check in my configuration?
Someone know if there is a way to test if asterisk make effectively
the query to the DB when I make the "realtime load" command?
Please, help me!
Maury
------------------------------------------------------------------------
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
paste your relevant config files and also an example command (realtime
load etc) that you are using.
also.. if u can.. turn on logging(DEBUG) in logger.conf, or better
still, go change the code n put in ur own debug lines
duznt take too long to figure out where u r going wrong.
- Ben
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
