Jonas Kellens
2012-Sep-27 09:00 UTC
[asterisk-users] realtime_multi_mysql: MySQL RealTime: Invalid database specified
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. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120927/00b66bb9/attachment.htm>
Thorsten Göllner
2012-Sep-27 09:27 UTC
[asterisk-users] realtime_multi_mysql: MySQL RealTime: Invalid database specified
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Maybe a stupid answer ;-)<br>
Did you make a "reload"?<br>
<br>
Did you try from shell:<br>
mysql -u myuser -pmysecret AsteriskHosted<br>
?<br>
<br>
<div class="moz-cite-prefix">Am 27.09.2012 11:00, schrieb
Jonas
Kellens:<br>
</div>
<blockquote cite="mid:506415C1.7090405@telenet.be"
type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<font face="Helvetica, Arial, sans-serif">Hello,<br>
<br>
this might seem a stupid question but I really don't see the
solution to the problem.<br>
<br>
Using Asterisk 1.8.12.2<br>
<br>
In extconfig.conf I have :<br>
<br>
voicemail => mysql,AsteriskHosted,voicemail_users<br>
sipusers => mysql,AsteriskHosted,sip_buddies<br>
sippeers => mysql,AsteriskHosted,sip_buddies<br>
queues => mysql,AsteriskHosted,queues<br>
queue_members => mysql,AsteriskHosted,queue_members<br>
<br>
In res_mysql I have :<br>
<br>
[AsteriskHosted]<br>
dbhost = 127.0.0.1<br>
dbname = AsteriskHosted<br>
dbuser = myuser<br>
dbpass = mysecret<br>
dbport = 3306<br>
dbsock = /var/lib/mysql/mysql.sock<br>
requirements=warn ; or createclose or createchar<br>
<br>
<br>
But still I get the error on Asterisk CLI :<br>
<br>
*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)<br>
*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)<br>
<br>
<br>
On 3 other servers I have installed, I have never had this
problem.<br>
<br>
<br>
What can be the issue ??<br>
<br>
<br>
Kind regards,<br>
Jonas.</font></blockquote>
</body>
</html>
Ishfaq Malik
2012-Sep-27 09:54 UTC
[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 <ish at pack-net.co.uk> Department: VOIP Support Company: Packnet Limited t: +44 (0)845 004 4994 f: +44 (0)161 660 9825 e: ish at 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