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

[Benjamin Jacob]

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
>
>  
>