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

Benjamin Jacob benjamin.jacob at masconit.com
Sun Oct 22 23:35:33 MST 2006 

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

More information about the asterisk-users mailing list