[Asterisk-Users] asterisk realtime msql

[Maurizio Marini]

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]: res_config_mysql.c:637 mysql_reconnect: MySQL RealTime: Everything is fine.
                   Column Name  Column Value
          --------------------  --------------------
                      uniqueid  1
                          name  104
                   accountcode  104
                     callgroup  1
                       context  default
                          host  dynamic
                        secret  abc
                          type  friend
                      username  104
                    regseconds  0

*CLI> realtime mysql status
Jan 13 11:57:06 DEBUG[8928]: res_config_mysql.c:637 mysql_reconnect: MySQL RealTime: Everything is fine.
Connected to asterisk at 192.168.1.10, port 3306 with username root for 4 seconds.


in extconfig.conf i have:
[settings]
;<family name> => <driver>,<database name>[,table_name]
sipfriends => mysql,asterisk,sipfriends

in res_mysql.conf
[general]
dbhost = 192.168.1.10
dbname = asterisk
dbuser = root
dbpass =
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock

thnx in advance
any help will be very apreciated :)


-- 
Maurizio Marini