Nobody can help me? Please...
----- Original Message ----- From: "Tijl Van den Broeck" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <[email protected]> Sent: Friday, October 20, 2006 1:46 PM Subject: Re: [asterisk-users] Asterisk Realtime... Help Me!!! > I'm having the same issue overhere with a nearly identical config: > > res_odbc.conf: > [mysql2] > enabled => yes > dsn => MySQL-asterisk > username => asterisk > password => asterisk > pre-connect => yes > > extconfig.conf > [settings] > sipusers => odbc,MySQL-asterisk,sip_buddies > sippeers => odbc,MySQL-asterisk,sip_buddies > > sip_buddies is identical to what is described at > http://www.voip-info.org/wiki/view/Asterisk+RealTime+Sip > > +----+------+-------------+----------+-----------+-----------------------+-- -----------+------------+-----------+----------+----------+------------+---- ---------+---------+----------+----------+---------+-----------+-----+------ +--------+------+-------------+------+---------+-------------+------------+- ---------------+--------+--------+----------+----------+-------+------------ -+------------+--------+----------+----------------+--------+ > | id | name | accountcode | amaflags | callgroup | callerid > | canreinvite | context | defaultip | dtmfmode | fromuser | > fromdomain | fullcontact | host | insecure | language | mailbox | > md5secret | nat | deny | permit | mask | pickupgroup | port | qualify > | restrictcid | rtptimeout | rtpholdtimeout | secret | type | > username | disallow | allow | musiconhold | regseconds | ipaddr | > regexten | cancallforward | setvar | > +----+------+-------------+----------+-----------+-----------------------+-- -----------+------------+-----------+----------+----------+------------+---- ---------+---------+----------+----------+---------+-----------+-----+------ +--------+------+-------------+------+---------+-------------+------------+- ---------------+--------+--------+----------+----------+-------+------------ -+------------+--------+----------+----------------+--------+ > | 1 | 1006 | NULL | NULL | 2 | Test account <1006> > | no | ciscophone | NULL | NULL | NULL | NULL > | NULL | dynamic | NULL | NULL | NULL | NULL > | no | NULL | NULL | NULL | 2 | | NULL | NULL > | NULL | NULL | 1234 | friend | 1006 | all > | alaw | NULL | 0 | | | yes > | | > +----+------+-------------+----------+-----------+-----------------------+-- -----------+------------+-----------+----------+----------+------------+---- ---------+---------+----------+----------+---------+-----------+-----+------ +--------+------+-------------+------+---------+-------------+------------+- ---------------+--------+--------+----------+----------+-------+------------ -+------------+--------+----------+----------------+--------+ > > modules.conf includes: > preload => res_odbc.so > preload => res_config_odbc.so > > > When I execute "odbc show", I can see a query coming in from asterisk > in the mysql query log, thus the odbc connection & mysql work. > 061020 13:25:47 10 Connect [EMAIL PROTECTED] on asterisk > 061020 13:27:03 10 Query select 1 > > Other than that, I have the same problem as Maurizio Pederneschi. > > *CLI> realtime load sipusers username 1006 > No rows found matching search criteria. > > Same DB problem occurs when I register the 1006 phone: > *CLI> Oct 20 13:29:58 NOTICE[32135]: chan_sip.c:11084 > handle_request_register: Registration from '<sip:[EMAIL PROTECTED]>' > failed for '172.16.5.206' - Username/auth name mismatch > At that time I see no incoming query whatsoever passing in the MySQL log. > > I'm running debian/unstable asterisk package 1.2.12.1.dfsg-1. Perhaps > it is a problem with just this release? > > greetings > > Tijl Van den Broeck > > > > On 10/20/06, Maurizio Pederneschi <[EMAIL PROTECTED]> 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
