asterisk users - Jan 2005 - asterisk realtime msql

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@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

(i skipped over this email at first because the subject is "msql" not
"mysql".)

what version MySQL did you compile against? what version of res_config_mysql
are you running? there was an update to it a few days ago.

-matthew

----- Original Message ----- 
From: "Maurizio Marini" <maumar@datalogica.com>
To: <Asterisk-users@lists.digium.com>
Sent: Thursday, January 13, 2005 5:03 AM
Subject: [Asterisk-Users] asterisk realtime msql

> 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@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
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users