[Asterisk-Users] asterisk realtime msql

[Matthew Boehm]

(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 at datalogica.com>
To: <Asterisk-users at 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 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
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at 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