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" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <[email protected]> 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 <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > > >To: "Asterisk Users Mailing List - Non-Commercial Discussion" > > ><[email protected]> > > >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
