[asterisk-users] [Fwd: FW: realtime mysql - p4]

[Andrew Thomas]

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' (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 asterisk at 127.0.0.1, 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.