Re: [asterisk-users] realtime_multi_mysql: MySQL RealTime: Invalid database specified
On 27-09-12 11:54, Ishfaq Malik wrote: On Thu, 2012-09-27 at 11:00 +0200, Jonas Kellens wrote: Hello, this might seem a stupid question but I really don't see the solution to the problem. Using Asterisk 1.8.12.2 In extconfig.conf I have : voicemail => mysql,AsteriskHosted,voicemail_users sipusers => mysql,AsteriskHosted,sip_buddies sippeers => mysql,AsteriskHosted,sip_buddies queues => mysql,AsteriskHosted,queues queue_members => mysql,AsteriskHosted,queue_members In res_mysql I have : [AsteriskHosted] dbhost = 127.0.0.1 dbname = AsteriskHosted dbuser = myuser dbpass = mysecret dbport = 3306 dbsock = /var/lib/mysql/mysql.sock requirements=warn ; or createclose or createchar But still I get the error on Asterisk CLI : *CLI> [Sep 27 10:47:20] WARNING[1693]: res_config_mysql.c:335 realtime_mysql: MySQL RealTime: Invalid database specified: AsteriskHosted (check res_mysql.conf) *CLI> [Sep 27 10:47:57] WARNING[1693]: res_config_mysql.c:442 realtime_multi_mysql: MySQL RealTime: Invalid database specified: 'AsteriskHosted' (check res_mysql.conf) On 3 other servers I have installed, I have never had this problem. What can be the issue ?? Kind regards, Jonas. Shouldn't the config file be called res_config_mysql.conf and not res_mysql.conf in 1.8? Well, this solved my problem !! Still don't know why other 1.8-servers do not give this error... 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
Re: [asterisk-users] realtime_multi_mysql: MySQL RealTime: Invalid database specified
Now I see: you try to use the wrong config file - try /etc/asterisk/res_config_mysql.conf instead. Am 27.09.2012 11:40, schrieb Jonas Kellens: On 27-09-12 11:27, Thorsten Göllner wrote: Maybe a stupid answer ;-) Did you make a "reload"? Yes, I reloaded and restarted several times. Did you try from shell: mysql -u myuser -pmysecret AsteriskHosted Yes, works perfect to connect via commandline. Only Asterisk does not see the database and I really don't know why. No hints in debug and verbose log either... Kind regards, 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
Re: [asterisk-users] realtime_multi_mysql: MySQL RealTime: Invalid database specified
On 27-09-12 11:54, Ishfaq Malik wrote: On Thu, 2012-09-27 at 11:00 +0200, Jonas Kellens wrote: Hello, this might seem a stupid question but I really don't see the solution to the problem. Using Asterisk 1.8.12.2 In extconfig.conf I have : voicemail => mysql,AsteriskHosted,voicemail_users sipusers => mysql,AsteriskHosted,sip_buddies sippeers => mysql,AsteriskHosted,sip_buddies queues => mysql,AsteriskHosted,queues queue_members => mysql,AsteriskHosted,queue_members In res_mysql I have : [AsteriskHosted] dbhost = 127.0.0.1 dbname = AsteriskHosted dbuser = myuser dbpass = mysecret dbport = 3306 dbsock = /var/lib/mysql/mysql.sock requirements=warn ; or createclose or createchar But still I get the error on Asterisk CLI : *CLI> [Sep 27 10:47:20] WARNING[1693]: res_config_mysql.c:335 realtime_mysql: MySQL RealTime: Invalid database specified: AsteriskHosted (check res_mysql.conf) *CLI> [Sep 27 10:47:57] WARNING[1693]: res_config_mysql.c:442 realtime_multi_mysql: MySQL RealTime: Invalid database specified: 'AsteriskHosted' (check res_mysql.conf) On 3 other servers I have installed, I have never had this problem. What can be the issue ?? Kind regards, Jonas. Shouldn't the config file be called res_config_mysql.conf and not res_mysql.conf in 1.8? On my 3 other Asterisk 1.8 servers there is no problem with the file res_mysql.conf and no problem with connection to the database. Kind regards, 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
Re: [asterisk-users] realtime_multi_mysql: MySQL RealTime: Invalid database specified
Now I see: you try to use the wrong config file - try /etc/asterisk/res_config_mysql.conf instead. Am 27.09.2012 11:40, schrieb Jonas Kellens: On 27-09-12 11:27, Thorsten Göllner wrote: Maybe a stupid answer ;-) Did you make a "reload"? Yes, I reloaded and restarted several times. Did you try from shell: mysql -u myuser -pmysecret AsteriskHosted Yes, works perfect to connect via commandline. Only Asterisk does not see the database and I really don't know why. No hints in debug and verbose log either... Kind regards, 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 -- Thorsten Göllner OVM Office Voice Media GmbH Herderstrasse 68 40237 Düsseldorf Tel.: +49(0)211 / 618 57 53 Fax: +49(0)211 / 618 57 54 -- _ -- 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
Re: [asterisk-users] realtime_multi_mysql: MySQL RealTime: Invalid database specified
On Thu, 2012-09-27 at 11:00 +0200, Jonas Kellens wrote: > Hello, > > this might seem a stupid question but I really don't see the solution > to the problem. > > Using Asterisk 1.8.12.2 > > In extconfig.conf I have : > > voicemail => mysql,AsteriskHosted,voicemail_users > sipusers => mysql,AsteriskHosted,sip_buddies > sippeers => mysql,AsteriskHosted,sip_buddies > queues => mysql,AsteriskHosted,queues > queue_members => mysql,AsteriskHosted,queue_members > > In res_mysql I have : > > [AsteriskHosted] > dbhost = 127.0.0.1 > dbname = AsteriskHosted > dbuser = myuser > dbpass = mysecret > dbport = 3306 > dbsock = /var/lib/mysql/mysql.sock > requirements=warn ; or createclose or createchar > > > But still I get the error on Asterisk CLI : > > *CLI> [Sep 27 10:47:20] WARNING[1693]: res_config_mysql.c:335 > realtime_mysql: MySQL RealTime: Invalid database specified: > AsteriskHosted (check res_mysql.conf) > *CLI> [Sep 27 10:47:57] WARNING[1693]: res_config_mysql.c:442 > realtime_multi_mysql: MySQL RealTime: Invalid database specified: > 'AsteriskHosted' (check res_mysql.conf) > > > On 3 other servers I have installed, I have never had this problem. > > > What can be the issue ?? > > > Kind regards, > Jonas. > Shouldn't the config file be called res_config_mysql.conf and not res_mysql.conf in 1.8? -- Ishfaq Malik Department: VOIP Support Company: Packnet Limited t: +44 (0)845 004 4994 f: +44 (0)161 660 9825 e: i...@pack-net.co.uk w: http://www.pack-net.co.uk Registered Address: PACKNET LIMITED, 2A ENTERPRISE HOUSE, LLOYD STREET NORTH, MANCHESTER SCIENCE PARK, MANCHESTER, M156SE COMPANY REG NO. 04920552 -- _ -- 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
Re: [asterisk-users] realtime_multi_mysql: MySQL RealTime: Invalid database specified
On 27-09-12 11:27, Thorsten Göllner wrote: Maybe a stupid answer ;-) Did you make a "reload"? Yes, I reloaded and restarted several times. Did you try from shell: mysql -u myuser -pmysecret AsteriskHosted Yes, works perfect to connect via commandline. Only Asterisk does not see the database and I really don't know why. No hints in debug and verbose log either... Kind regards, 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
Re: [asterisk-users] realtime_multi_mysql: MySQL RealTime: Invalid database specified
Maybe a stupid answer ;-) Did you make a "reload"? Did you try from shell: mysql -u myuser -pmysecret AsteriskHosted ? Am 27.09.2012 11:00, schrieb Jonas Kellens: Hello, this might seem a stupid question but I really don't see the solution to the problem. Using Asterisk 1.8.12.2 In extconfig.conf I have : voicemail => mysql,AsteriskHosted,voicemail_users sipusers => mysql,AsteriskHosted,sip_buddies sippeers => mysql,AsteriskHosted,sip_buddies queues => mysql,AsteriskHosted,queues queue_members => mysql,AsteriskHosted,queue_members In res_mysql I have : [AsteriskHosted] dbhost = 127.0.0.1 dbname = AsteriskHosted dbuser = myuser dbpass = mysecret dbport = 3306 dbsock = /var/lib/mysql/mysql.sock requirements=warn ; or createclose or createchar But still I get the error on Asterisk CLI : *CLI> [Sep 27 10:47:20] WARNING[1693]: res_config_mysql.c:335 realtime_mysql: MySQL RealTime: Invalid database specified: AsteriskHosted (check res_mysql.conf) *CLI> [Sep 27 10:47:57] WARNING[1693]: res_config_mysql.c:442 realtime_multi_mysql: MySQL RealTime: Invalid database specified: 'AsteriskHosted' (check res_mysql.conf) On 3 other servers I have installed, I have never had this problem. What can be the issue ?? Kind regards, 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