Post your cdr_mysql.conf and res_mysql.conf and we'll take it from there. Don't forget to remove any 'private' info first (like passwords).
Cheers -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hans Witvliet Sent: 19 May 2011 23:14 To: [email protected] Cc: [email protected] Subject: [asterisk-users] [Fwd: FW: realtime mysql - p4] Ok, i tried the suggestion: Instead of: sippuser => resource, database_name, table_name sippeer => resource, database_name, table_name I put in: sippuser => resource, context, table_name sippeer => resource, context, table_name Unfortunately, with the same results. btw i tried both "general" as "default" Besids the commands i tried below, isn't there any other way to see what's going on? Perhaps it is totally unrelated, but if i perform a mysql-login on the prompt, i first have to select the database manualy, ie it isn't selected by default for the created mysqluser [in this case: voipadmin] Other wild idea, is there a minimum number of fields that haved to be filled? And why is asterisk complaining about not being able to find the databse, when trying to fill it from the asterisk-CLI? My database _is_ named "asterisk"...... > kc3054*CLI> 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) I mean, is that silly or what? > > > # grep mysql extconfig.conf |grep sip > ;sipusers => mysql,asterisk,sip_devices ;sippeers => > mysql,asterisk,sip_devices ;sipusers => mysql,general,sip_devices > ;sippeers => mysql,general,sip_devices sipusers => > mysql,default,sip_devices sippeers => mysql,default,sip_devices > > > kc3054*CLI> module show like mysql > Module Description Use Count > cdr_mysql.so MySQL CDR Backend 0 > res_config_mysql.so MySQL RealTime Configuration Driver 0 > app_mysql.so Simple Mysql Interface 0 > 3 modules loaded > kc3054*CLI> > kc3054*CLI> sip show users > Username Secret Accountcode Def.Context ACL ForcerPort > j.witvliet geheim default No Yes > 00000277611 25b06d3a0b5ef73 default No Yes > kc3054*CLI> > kc3054*CLI> sip show peers > Name/username Host Dyn Forcerport ACL Port Status Realtime > 00000277611 (Unspecified) D N 0 Unmonitored > j.witvliet (Unspecified) D N 0 Unmonitored > 2 sip peers [Monitored: 0 online, 0 offline Unmonitored: 0 online, 2 > offline] kc3054*CLI> kc3054*CLI> > > kc3054*CLI> > kc3054*CLI> realtime mysql cache > kc3054*CLI> realtime mysql status > general connected to [email protected], port 3306 with username voipadmin for 18 seconds. > kc3054*CLI> > -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users If you have received this communication in error we would appreciate you advising us either by telephone or return of e-mail. The contents of this message, and any attachments, are the property of DataVox, and are intended for the confidential use of the named recipient only. If you are not the intended recipient, employee or agent responsible for delivery of this message to the intended recipient, take note that any dissemination, distribution or copying of this communication and its attachments is strictly prohibited, and may be subject to civil or criminal action for which you may be liable. Every effort has been made to ensure that this e-mail or any attachments are free from viruses. While the company has taken every reasonable precaution to minimise this risk, neither company, nor the sender can accept liability for any damage which you sustain as a result of viruses. It is recommended that you should carry out your own virus checks before opening any attachments. Registered in England. No. 27459085. -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
