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.
-- _____________________________________________________________________ -- 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
