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
