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' (checkres_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 asterisk at 127.0.0.1, port 3306 with username voipadmin for 18 seconds. > kc3054*CLI> >
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: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Hans Witvliet Sent: 19 May 2011 23:14 To: asterisk-users at lists.digium.com Cc: j.witvliet at mindef.nl 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' (checkres_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 DescriptionUse Count> cdr_mysql.so MySQL CDR Backend0> res_config_mysql.so MySQL RealTime Configuration Driver0> app_mysql.so Simple Mysql Interface0> 3 modules loaded > kc3054*CLI> > kc3054*CLI> sip show users > Username Secret AccountcodeDef.Context ACL ForcerPort> j.witvliet geheim defaultNo Yes> 00000277611 25b06d3a0b5ef73 defaultNo Yes> kc3054*CLI> > kc3054*CLI> sip show peers > Name/username Host DynForcerport ACL Port Status Realtime> 00000277611 (Unspecified) DN 0 Unmonitored> j.witvliet (Unspecified) DN 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 asterisk at 127.0.0.1, port 3306 with usernamevoipadmin 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.
Sorry - I meant extconfig.conf - not cdr_mysql.conf (my mistake). I use (and done for a long time) mySQL for realtime storage - and it's never let me down (touch wood). Cheers -----Original Message----- From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Hans Witvliet Sent: 22 May 2011 22:50 To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] [Fwd: FW: realtime mysql - p4] On Fri, 2011-05-20 at 10:05 +0100, Andrew Thomas wrote:> 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). > > CheersTnx for the offer, Wil get the files when got back at the office. I presume that cdr_mysql.conf is only relevant for storing call-data-records? Perhaps that is something for later on. For now, i have to show a working *, with all sip-details in a mysql-DB. Other people pointed out that other means (postgres, ldap) might work better, but that's not an option for me. Hans -- _____________________________________________________________________ -- 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.