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

Sun Oct 22 22:52:20 MST 2006

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
>