<div dir="ltr">asterisk trying connect to mysql via socket remove that line from config files.<div style>1 check if port 3306 is open in iptables on both servers.</div><div style>2 check permissions on db for user Asterisk. </div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Jun 3, 2013 at 9:18 PM, Olivier CALVANO <span dir="ltr"><<a href="mailto:o.calvano@gmail.com" target="_blank">o.calvano@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>on this server we don't have mysql.socket because he don't have mysql server<br><br></div>we want access to a mysql based on a other server<br>
<br><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">
2013/6/3 Bakko <span dir="ltr"><<a href="mailto:asannucci@gmail.com" target="_blank">asannucci@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
Hello,<br>
<br>
are you sure MySQL socket is in /tmp directory?<br>
<br>
dbsock = /tmp/mysql.sock<br>
<br>
Regards<br>
<br>
<div>El 03/06/2013 12:16, Olivier CALVANO
escribió:<br>
</div><div><div>
<blockquote type="cite">
<div dir="ltr">
<div>
<div>
<div>Thanks for your help Ron,<br>
<br>
Do you know where is the confirguration ?<br>
<br>
</div>
Because i have put into res_config_mysql.conf:<br>
<br>
[general]<br>
dbhost = <a href="http://myhost.mydomain.net" target="_blank">myhost.mydomain.net</a><br>
dbname = MyDB<br>
dbuser = MyUser<br>
dbpass = MyPassword<br>
dbport = 3306<br>
dbsock = /tmp/mysql.sock<br>
dbcharset = latin1<br>
requirements = warn<br>
<br>
<br>
</div>
after in extconfig.conf:<br>
sipusers => mysql,general,Comptes_SIP<br>
sippeers => mysql,general,Comptes_SIP<br>
iaxusers => mysql,general,Comptes_IAX<br>
iaxpeers => mysql,general,Comptes_IAX<br>
extensions => mysql,general,Extensions<br>
meetme => mysql,general,MeetMe<br>
musiconhold => mysql,general,Musiconhold<br>
voicemail => mysql,general,VoiceMail<br>
<br>
</div>
and in cdr_mysql.conf<br>
<br>
[global]<br>
hostname=<a href="http://myhost.mydomain.net" target="_blank">myhost.mydomain.net</a><br>
dbname=MyDB<br>
table=Cdr<br>
password=MyPassword<br>
user=MyUser<br>
port=3306<br>
sock=/tmp/mysql.sock<br>
<br>
[aliases]<br>
start=calldate<br>
end=callend<br>
callerid=clid<br>
src=src<br>
dst=dst<br>
dcontext=dcontext<br>
channel=channel<br>
dstchannel=dstchannel<br>
lastapp=lastapp<br>
lastdata=lastdata<br>
duration=duration<br>
billsec=billsec<br>
disposition=disposition<br>
amaflags=amaflags<br>
accountcode=accountcode<br>
userfield=userfield<br>
uniqueid=uniqueid<br>
CodeTier=CodeTier<br>
<br>
<br>
<br>
<div>
<div>
<div style="display:inline-block">
<div><span></span></div>
</div>
</div>
</div>
<div>
<div dir="ltr"><span lang="en"><span>you</span> <span>know</span>
<span>what file</span> <span>I forgot
to</span> <span>configure</span><span>?<br>
</span></span></div>
<div><span lang="en"><span>Olivier<br>
<br>
</span></span></div>
</div>
<br>
<br>
<br>
<br>
<div><br>
<div><br>
<br>
<br>
<br>
</div>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2013/6/3 Ron Wheeler <span dir="ltr"><<a href="mailto:rwheeler@artifact-software.com" target="_blank">rwheeler@artifact-software.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<div>Fix this.<br>
<br>
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c:
MySQL RealTime: No database user found, using 'asterisk'
as default.<br>
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c:
MySQL RealTime: No database password found, using
'asterisk' as default.<br>
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c:
MySQL RealTime: No database host found, using localhost
via socket.<br>
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c:
MySQL RealTime: No database name found, using 'asterisk'
as default.<br>
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c:
MySQL RealTime: No database port found, using 3306 as
default.<br>
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c:
MySQL RealTime: No database socket found (and unable to
detect a suitable path).<br>
<br>
Asterisk is telling you that you have not configured ANY
database.<br>
<br>
It is not worrying about what tables are in it because
you have not even defined the database itself. <br>
There is NO database at all so worrying about versions
is not Asterisk's big problem.. <br>
<br>
The rest of the messages after that are a bit screwy
because the routines producing the error are not aware
that there is no database at all so they just complain
about the piece that they know about.<span><font color="#888888"><br>
<br>
<br>
Ron</font></span>
<div>
<div><br>
<br>
<br>
On 03/06/2013 12:19 PM, Olivier CALVANO wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div>
<div dir="ltr">No other idea ?<br>
<br>
<br>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2013/6/3 Olivier CALVANO
<span dir="ltr"><<a href="mailto:o.calvano@gmail.com" target="_blank">o.calvano@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div>
<div>
<div>
<div>
<div>Hi<br>
<br>
</div>
i have installed a new Asterisk
server on Fedora. My first server
use Asterisk 1.6.x with a MySQL CDR
and<br>
realtime.<br>
<br>
</div>
I have a small problems, when i
configure on the new server, the same
information in MySQL, we have a error:<br>
<br>
[Jun 3 16:27:59] ERROR[3140]
res_config_mysql.c: MySQL RealTime:
Failed to connect database server SSI
on <a href="http://myhost.myserver.com" target="_blank">myhost.myserver.com</a>
(err 2003). Check debug for more info.<br>
[Jun 3 16:27:59] WARNING[3140]
res_config_mysql.c: Table VoiceMail
not found in database. This table
should exist if you're using realtime.<br>
[Jun 3 16:27:59] ERROR[3140]
cdr_mysql.c: Failed to connect to
mysql database SSI on <a href="http://myhost.myserver.com" target="_blank">myhost.myserver.com</a>.<br>
[Jun 3 16:30:14] ERROR[3220]
cdr_mysql.c: Failed to connect to
mysql database SSI on <a href="http://myhost.myserver.com" target="_blank">myhost.myserver.com</a>.<br>
[Jun 3 16:30:34] WARNING[3220]
res_config_mysql.c: MySQL RealTime: No
database user found, using 'asterisk'
as default.<br>
[Jun 3 16:30:34] WARNING[3220]
res_config_mysql.c: MySQL RealTime: No
database password found, using
'asterisk' as default.<br>
[Jun 3 16:30:34] WARNING[3220]
res_config_mysql.c: MySQL RealTime: No
database host found, using localhost
via socket.<br>
[Jun 3 16:30:34] WARNING[3220]
res_config_mysql.c: MySQL RealTime: No
database name found, using 'asterisk'
as default.<br>
[Jun 3 16:30:34] WARNING[3220]
res_config_mysql.c: MySQL RealTime: No
database port found, using 3306 as
default.<br>
[Jun 3 16:30:34] WARNING[3220]
res_config_mysql.c: MySQL RealTime: No
database socket found (and unable to
detect a suitable path).<br>
<br>
</div>
The exacly same config work on 1.6.x<br>
<br>
and from the new server, the database
access is Ok:<br>
<br>
[root@voip-2 log]# !mys<br>
mysql -h <a href="http://myhost.myserver.com" target="_blank">myhost.myserver.com</a>
-u Asterisk -p SSI<br>
Enter password:<br>
Reading table information for completion
of table and column names<br>
You can turn off this feature to get a
quicker startup with -A<br>
<br>
Welcome to the MySQL monitor. Commands
end with ; or \g.<br>
Your MySQL connection id is 5185<br>
Server version: 5.1.42-log Mandriva
Linux - MySQL Standard Edition (GPL)<br>
<br>
Copyright (c) 2000, 2013, Oracle and/or
its affiliates. All rights reserved.<br>
<br>
Oracle is a registered trademark of
Oracle Corporation and/or its<br>
affiliates. Other names may be
trademarks of their respective<br>
owners.<br>
<br>
Type 'help;' or '\h' for help. Type '\c'
to clear the current input statement.<br>
<br>
mysql> select * from VoiceMail;<br>
+----------+-------------+--------------+------------+----------+--------------+-----------------------+-------+---------+--------+--------+---------+----------+--------+----------+----------+-------------+--------------+---------------+--------+--------------+-----------+----------------+-------------+---------------------+<br>
| uniqueid | customer_id | context
| mailbox | password | fullname |
email | pager | tz
| attach | saycid | dialout | callback |
review | operator | envelope |
sayduration | saydurationm |
sendvoicemail | delete | nextaftercmd |
forcename | forcegreetings | hidefromdir
| stamp |<br>
+----------+-------------+--------------+------------+----------+--------------+-----------------------+-------+---------+--------+--------+---------+----------+--------+----------+----------+-------------+--------------+---------------+--------+--------------+-----------+----------------+-------------+---------------------+<br>
</div>
<..><br>
<br>
<br>
</div>
anyone know the problems ?<br>
<br>
thanks<span><font color="#888888"><br>
olivier<br>
<br>
<div>
<div>
<div><br>
</div>
</div>
</div>
</font></span></div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
</div>
</div>
<div>
<pre>--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --
New to Asterisk? Join us for a live introductory webinar every Thurs:
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a>
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a></pre>
</div>
</blockquote>
<div> <br>
<br>
<pre cols="72">--
Ron Wheeler
President
Artifact Software Inc
email: <a href="mailto:rwheeler@artifact-software.com" target="_blank">rwheeler@artifact-software.com</a>
skype: ronaldmwheeler
phone: <a href="tel:866-970-2435%2C%20ext%20102" value="+18669702435" target="_blank">866-970-2435, ext 102</a></pre>
</div>
</div>
<br>
--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar
every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</blockquote>
</div>
<br>
</div>
<br><span class="HOEnZb"><font color="#888888">
<fieldset></fieldset>
<br>
<pre>--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --
New to Asterisk? Join us for a live introductory webinar every Thurs:
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a>
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a></pre>
</font></span></blockquote><span class="HOEnZb"><font color="#888888">
<br>
</font></span></div></div></div><span class="HOEnZb"><font color="#888888">
<br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></font></span></blockquote></div><br></div>
<br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br></div>