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

Sun Oct 22 23:31:53 MST 2006

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