Hi all.
I cant stop to get this warning. Why?
WARNING[15466]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info.
NOTICE[15466]: chan_sip.c:12723 handle_response_peerpoke: Peer '5808' is now Reachable. (25ms / 2000ms)
WARNING[15466]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info.
NOTICE[15466]: chan_sip.c:12723 handle_response_peerpoke: Peer '5803' is now Reachable. (25ms / 2000ms)
I post my .conf files.
res_mysql.conf
[general]
dbhost = localhost
dbname = asterisk
dbuser = asteriskuser
dbpass = PASS
dbport = 3306
dbsock = /var/run/mysqld/mysqld.sock
extconfig.conf
[settings]
sippeers => mysql,asterisk,sippeers
extensions => mysql,asterisk,extensions
my DB:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| asterisk |
| mysql |
+--------------------+
mysql> show tables;
+--------------------+
| Tables_in_asterisk |
+--------------------+
| extensions |
| sippeers |
+--------------------+
This are my permissions:
echo "GRANT ALL PRIVILEGES ON *.* TO asteriskuser@localhost IDENTIFIED BY 'PASS';" | mysql -u root
Thanks all!