search for: update_mysql

Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk softphones. I followed the steps of "how to" of voip-org but always have this error: Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed...

..._mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM devices WHERE name = '109' AND host = 'dynamic' [Jan 30 22:38:21] DEBUG[27917]: res_config_mysql.c:662 mysql_reconnect: MySQL RealTime: Everything is fine. [Jan 30 22:38:21] DEBUG[27917]: res_config_mysql.c:365 update_mysql: MySQL RealTime: Update SQL: UPDATE devices SET ipaddr = '0.0.0.0', port = '0', regseconds = '0' WHERE name = '109' [Jan 30 22:38:21] DEBUG[27917]: res_config_mysql.c:379 update_mysql: MySQL RealTime: Updated 0 rows on table: devices [Jan 30 22:38:21] DEBUG[27885]: r...

Hi, I'm starting testing 1.6.2 beta. CentOs 5.2 I found my first crash, first I have [Mar 20 20:30:41] WARNING[11201]: res_config_mysql.c:611 update_mysql: Attempted to update column 'useragent' in table 'sip', but column does not exist! [Mar 20 20:30:41] ERROR[11201]: res_config_mysql.c:581 update_mysql: MySQL RealTime: Updating on column 'lastms', but that column does not exist within the table 'sip'! I would li...

Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk softphones. I followed the steps of "how to" of voip-org but always have this error: Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed...

I get that a lot since moving to 1.4.21 (from 1.4.18 or something). [Jun 17 09:19:54] WARNING[22053]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Question 1: what debug file should I be looking at? Mick -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20080617...

...Could anybody please let me know what's the cause for this warning.... *CLI> -- Registered SIP 'bharat' at 10.111.16.149 port 5060 expires 120 -- Saved useragent "SJphone/1.60.289a (SJ Labs)" for peer bharat Jan 13 10:06:58 WARNING[1147]: res_config_mysql.c:331 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. -- Registered SIP 'bharat' at 10.111.16.149 port 5060 expires 120 -- Saved useragent "SJphone/1.60.289a (SJ Labs)" for peer bharat Jan 13 10:08:58 WARNING[1147]: res_config_mysql.c:331 update_mysql: M...

...ered 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. [2007-01-15 10:18:12] DEBUG[28528]: res_config_mysql.c:355 update_mysql: MySQL RealTime: Update SQL: UPDATE SipUser SET ipaddr = '10.0.0.37', port = '5060', regseconds = '1168853292', username = 'edwin', fullcontact = 'sip:edwin@10.0.1.121:5060;transport=udp' WHERE name = 'edwin' [2007-01-15 10:18:12] DEBUG[28528]: res...

Dear Sir, Kindly note that I'm getting the following error when trying to register on asterisk server: [Feb 20 17:12:32] WARNING[2865]: res_config_mysql.c:358 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. I can connect to the database using the username and password defined inside res_mysql.conf but still getting the issue Regards -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium...

...> realtime update sipusers set SET port = 4343 WHERE name = 00000277611 Failed to update. Check the debug log for possible SQL related entries. Command 'realtime update sipusers set SET port = 4343 WHERE name = 00000277611' failed. [May 18 18:47:16] WARNING[16718]: res_config_mysql.c:559 update_mysql: MySQL RealTime: Invalid database specified: 'asterisk' (check res_mysql.conf) kc3054*CLI> ==> here the system talkes about _another_ config file! <== So which file should i configure: A) res_config_mysql.conf B) res_odbc.conf C) res_mysql.conf But even when i put my credentials...

...sers set SET port = 4343 WHERE name = > 00000277611 Failed to update. Check the debug log for possible SQL > related entries. > Command 'realtime update sipusers set SET port = 4343 WHERE name = > 00000277611' failed. > [May 18 18:47:16] WARNING[16718]: res_config_mysql.c:559 update_mysql: > MySQL RealTime: Invalid database specified: 'asterisk' (check res_mysql.conf) I mean, is that silly or what? > > > # grep mysql extconfig.conf |grep sip > ;sipusers => mysql,asterisk,sip_devices > ;sippeers => mysql,asterisk,sip_devices > ;sipusers => m...

Yes, we mostly talk about asterisk, hardware, software, phones, people, events and things asterisk-related. Asterisk is a registered trademark of Digium. Asterix is a registered trademark of Ren? Goscinny. We never discuss that, though. Here's the short URL for sending out to others that might be interested: http://x2z.eu It lands here: http://www.VoipUsersConference.org Once again, I

...(.text+0xdd6):/usr/local/src/asterisk-addons-1.4.1/res_config_mysql.c:297: undefined reference to `ast_log' res_config_mysql.o(.text+0xdf6):/usr/local/src/asterisk-addons-1.4.1/res_config_mysql.c:301: undefined reference to `mysql_free_result' res_config_mysql.o(.text+0xe53): In function `update_mysql': /usr/local/src/asterisk-addons-1.4.1/res_config_mysql.c:315: undefined reference to `ast_log' res_config_mysql.o(.text+0xebd):/usr/local/src/asterisk-addons-1.4.1/res_config_mysql.c:323: undefined reference to `ast_log' res_config_mysql.o(.text+0xf62):/usr/local/src/asterisk-addons-...