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 [EMAIL PROTECTED], 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
_______________________________________________
Asterisk-Users mailing list
[email protected]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
