[Asterisk-Users] MySQL

[VCI Help Desk]

    Yeah, I have been changing that line each time I re-install/re-configure
it but it never seems to work. My mysql.sock files is at
/var/lib/mysql/mysql.sock

    The best I've gotten it to work so far is trying to get the voicemail
password from the Mysql table with the wrong context. For some reason it
always wanted to put the context as "default" while I had "from-sip" as the
context in extensions.conf and sip.conf  I was able to see it do a mysql
request in the /var/log/mysql.log file.

      Bill




----- Original Message ----- 
From: Brian Wilkins
To: Asterisk Users Mailing List - Non-Commercial Discussion
Sent: Monday, December 13, 2004 4:33 AM
Subject: Re: [Asterisk-Users] MySQL


Yep, same problem I had. Look in /etc/mysql/my.cnf for the location of the
sock file.


On Monday 13 December 2004 03:17 pm, Greg - Cirelle Enterprises wrote:
> At 09:32 AM 12/13/04, you wrote:
> >     Same here. I've deleted and re-installed asterisk a few times and
the
> >RealTime voicemail never works. The best I've gotten is the MySQL query
to
> >execute with the wrong context. When I use "cvs checkout -r v1-0 zaptel
> >libpri asterisk asterisk-addons asterisk-sounds" to download the latest
> >version the "res_mysql.conf.sample" isn't even there. I made it from
> > scratch but it still doesn't work. If that file isn't there what else is
> > missing?
> >
> >       Bill
>
> I just found out (on my system), the res_mysql.conf has the
> local mysql socket setting looking for mysql.sock in /tmp/mysql.sock
>
> I did a locate mysql.sock which found the actual location and I
> put that location in res_mysql.conf in the dbsock parameter and
> it began working.
>
> Hope this helps you
>
> Greg
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users

-- 
Brian Wilkins
Software Engineer
brian at hcc.net

Heritage Communications Corporation
  Melbourne, FL     USA     32935
321.308.4000 x33
http://www.hcc.net

_______________________________________________
Asterisk-Users mailing list
Asterisk-Users at lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users