[asterisk-users] Asterisk Realtime... Help Me!!!

[Maurizio Pederneschi]

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" <benjamin.jacob at masconit.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at 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