Re: [asterisk-users] Asterisk Realtime... Help Me!!!
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 asterisk-users@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 [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 asterisk-users@lists.digium.com Sent: Friday, October 20, 2006 12:39 PM Subject: Re: [asterisk-users
Re: [asterisk-users] Asterisk Realtime... Help Me!!!
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 [EMAIL PROTECTED] To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@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 [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 asterisk-users@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
Re: [asterisk-users] Asterisk Realtime... Help Me!!!
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 asterisk-users@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
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 asterisk-users@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
Re: [asterisk-users] Asterisk Realtime... Help Me!!!
Nobody can help me? Please... - Original Message - From: Tijl Van den Broeck [EMAIL PROTECTED] To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com 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
[asterisk-users] Asterisk Realtime... Help Me!!!
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
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
Re: [asterisk-users] Asterisk Realtime... Help Me!!!
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 asterisk-users@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
Re: [asterisk-users] Asterisk Realtime... Help Me!!!
'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 asterisk-users@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