On 09/08/2010 05:18 PM, Gareth Blades wrote: > Jonas Kellens wrote: > >> On 09/08/2010 04:50 PM, Gareth Blades wrote: >> >>> Jonas Kellens wrote: >>> >>> >>>> Hello, >>>> >>>> in asterisk 1.4.30 all realtime configurations go well. >>>> >>>> In asterisk 1.6.2.11 the following appears on CLI : >>>> >>>> [Sep 8 16:43:43] WARNING[1843]: res_config_mysql.c:325 realtime_mysql: >>>> MySQL RealTime: Invalid database specified: MyDBase (check res_mysql.conf) >>>> [Sep 8 16:43:43] WARNING[1843]: res_config_mysql.c:325 realtime_mysql: >>>> MySQL RealTime: Invalid database specified: MyDBase (check res_mysql.conf) >>>> >>>> res_mysql.conf : >>>> >>>> [general] >>>> dbhost = 127.0.0.1 >>>> dbname = MyDBase >>>> dbuser = asterisk >>>> dbpass = mysecret >>>> dbport = 3306 >>>> dbsock = /tmp/mysql.sock >>>> requirements=warn ; or createclose or createchar >>>> >>>> >>>> What do I need to change to be conform asterisk 1.6 ?! >>>> >>>> Reloading, restarting asterisk and restarting my CentOS-server all >>>> doesn't help. >>>> >>>> >>>> Jonas. >>>> >>>> >>>> >>> You have no entry called MyDBase in there. >>> Rename '[general]' to '[MyDBase]' and give it another go. >>> >>> >> This did not work. >> >> This is the message : >> >> [Sep 8 17:08:43] ERROR[1843]: res_config_mysql.c:1575 mysql_reconnect: >> MySQL RealTime: Failed to connect database server MyDBase on 127.0.0.1 >> (err 1045). Check debug for more info. >> [Sep 8 17:08:43] ERROR[1843]: res_config_mysql.c:1575 mysql_reconnect: >> MySQL RealTime: Failed to connect database server MyDBase on 127.0.0.1 >> (err 1045). Check debug for more info. >> >> >> However my log /var/log/asterisk/debug has no entry of today... Which >> debug info can I check then ?! >> >> >> Jonas. >> >> >> >> >> > You are closer. > 1) Make sure the myDBase database exists and the asterisk user has > permission to access it. > 2) You have an IP address& port together with a socket filename listed. > Decide whhich method you want to use and remove the configuration for > the other. >
Created another user on the MySQL-DB and now it works... Thanks. Jonas. -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users