(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" <[EMAIL PROTECTED]> To: <[email protected]> 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 [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 _______________________________________________ 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
