similar to: SQL update failing/long fullcontact

Hi, I am using Realtime for sip configuration. When there is an INVITE which arrives at asterisk asterisk makes the following selects: Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: Everything is fine. [Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_conf WHERE name = 'tzl' [Nov

Hi All, Has anyone else noticed that when a sip phone sitting behind a nat registers to asterisk using realtime database, the private IP of the phone is put into the fullcontact field instead of the public contact IP. The database has the correct public IP in the ipaddr field and correct port number in the port field, which is actually what asterisk uses to to contact the device. This

Hello, We use Asterisk Realtime for our billing software. 200+ installations of Asterisk with Realtime, but I see this for the first time. Asterisk 1.4.17, Addons 1.4.5, No patches, no NAT - just plain simple installation. With debug I can see: [Jan 30 22:38:21] DEBUG[27885]: res_config_mysql.c:662 mysql_reconnect: MySQL RealTime: Everything is fine. [Jan 30 22:38:21] DEBUG[27885]:

Hi We're using asterisk 1.4.17 with RealTime so our port and fullcontact values in out DB get updated dynamically. We use snom handsets and always set the network identity (port) in each phone to something in the 10000 range, so that each phone in a single location has a different port. When we look in the DB the location always has the port we set but the port value is often something

Hi, I've troubles with setting up Asterisk Realtime and MD5 authentication. With clear text passwords everything is working fine. -- Registered SIP 'edwin' at 10.0.0.37 port 5060 expires 600 -- Saved useragent "Cisco-CP7940G/8.0" for peer edwin [2007-01-15 10:18:12] DEBUG[28528]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: Everything is fine.

Hi All I am trying to get voicemail switched over to ARA on version 13 and notice that the password is not stored in the db when it is changed. A little hair pulling and playing around and I think the problem is in the function ast_update2_realtime in main/config.c. Issued source is ==> int ast_update2_realtime(const char *family, ...) { RAII_VAR(struct ast_variable *,

Hello, I am just getting started with res_config and ODBC. I have MySQL all setup and am filling it with my data. Everything seems very straight forward. One thing catches me so far: 1) How are register lines in sip.conf and iax.conf represented? i.e. register=> username:password@fwd.pulver.com/700 insert into ast_config (filename,category,var_name,var_val)

Hello, in asterisk 1.4.30 all realtime configurations go well. In asterisk 1.6.2.11 the following appears on CLI : [Sep 8 16:43:43] WARNING[1843]: res_config_mysql.c:325 realtime_mysql: MySQL RealTime: Invalid database specified: MyDBase (check res_mysql.conf) [Sep 8 16:43:43] WARNING[1843]: res_config_mysql.c:325 realtime_mysql: MySQL RealTime: Invalid database specified: MyDBase (check

Hi I'm using asterisk 1.0.3_1 from the freebsd ports. Everything works ok, except I can's get res_config to populate sip.conf (or any other conf file for that matter). my unixodbc works and I can access the database with the isql tool. There are no warnings or anything else in the asterisk log file indicating a problem. I have used the guide from

Hello, I have configured one provider in Asterisk Realtime DB without username and password, only host=<providers_IP> and ipaddress=<providers_IP> Now when I'm trying to send call using this provider I'm using following string: Dial(SIP/NUMBER at Provider) In Asterisk 1.4.15 debug I see that Realtime engine is using query: [Dec 20 00:02:15] DEBUG[14634]:

This is a problem with extconfig.conf - not your res_ or cdr_ ones. In your case - extconfig.conf probably contained something like 'sippeers => mysql,MyDBase,sippeers'. The 'problem' is that the middle parameter is no longer for the database name - it is for the context in res_mysql.conf. So, the above now becomes 'sippeers => mysql,general,sippeers'. Give that a

I want to let Asterisk read its configuration from a mysql database. I configured everything according to the wiki page: http://www.voip-info.org/tiki-index.php?page=Asterisk+res_config. However it doesn't work. I am using 1.0.8 asterisk version and here are my config files: Extconfig.conf: [settings] ;uncomment to load queues.conf via the db engine. ;queues.conf =>

Hello I just settup a realtime mysql table for sip_peers. All peers (friends) is autenticateing but when i want to initiate a call between them i got the following error. Someone have some ideea? Thank you. ---<Cut Here>--- pbx*CLI>console dial 1014 == Console is full duplex -- Executing [1014@default:1] Dial("OSS/dsp", "SIP/1014|40|t") in new stack

Thank you very much for all feedback on Asterisk Sunday News! This is the last issue for June. This week I'll go on holiday and will be back with more news in early July. My kids are getting summer leave this week and we'll be visiting the south of England for a while. Another part of Europe that still use their own currency. If you think there's an European standard, you're

Hi For whatever reason we've getting 2 or 3 CDR lines logged for each call, often in different formats: as1:~# grep test-89-1e2c /var/log/asterisk/cdr-csv/*.csv

Hi ALL; I got the latest Asterisk-addons for Mysql-Cdr, but I have problem compiling that.It says: # make ..... ........ res_config_mysql.c: In function `realtime_mysql': res_config_mysql.c:143: warning: passing arg 1 of `ast_strlen_zero' makes pointer from integer without a cast res_config_mysql.c: In function `realtime_multi_mysql': res_config_mysql.c:242: warning: passing arg

hi,all when i upgrade from 1.4.28 to 1.6.2.1, i can't connect to mysql database anymore, error as follow: [Jan 25 15:38:25] WARNING[3003]: res_config_mysql.c:325 realtime_mysql: MySQL RealTime: Invalid database specified: asterisk (check res_mysql.conf) the content of res_mysql.conf is: http://www.pastebin.org/81966 i've try command " mysql -uroot -proot" ,i can connect to

Hi there asterisk goes to 90% cpu usage when trying to authenticate a sip friend using realtime mysql, no other message does appear at cli and asterisk hungs; here some info: *CLI> realtime load sipfriends name 104 Jan 13 11:52:21 DEBUG[8928]: res_config_mysql.c:109 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sipfriends WHERE name = '104' Jan 13 11:52:21 DEBUG[8928]:

If anyone is interested ... just in case! :-)... I have tried to write , based on the cdr_mysql.so module, an Sybase module. To compile you can use something like that: export SYBPLATFORM=linux export SYBASE=/opt/sybase cc -I$SYBASE/include -c -o cdr_sybase.o cdr_sybase.c cc -shared -Xlinker -x -o cdr_sybase.so cdr_sybase.o -lsybdb -lm -L$SYBASE/lib (anyone could write the corect Makefile

Hi, I use cvs stable version. I'd like to add database support on extensions.conf. Other config files into db would be a big bonus. Looking through the wiki, there are several ways... but not sure which one is the best or widely used and supported... ast_data and res_config seem to be the best candidates. I read it many times and my impression is that ast_data seems to be better. But