[Asterisk-Users] Anyone got VM2 working with MySQL?

[Tilghman Lesher]

On Monday 27 October 2003 07:11, Philipp von Klitzing wrote:
> > MySQL CDR logging is installed and working..
>
> Can you connect via localhost & socket for CDR? That didn't work
> for me (on two machines), I need to use hostname & port.

In all likelihood, you have an authentication problem.  Note that
specifying '%' (or a name) for the hostname portion in your GRANT
does NOT match 'localhost'.  By far this is the most common
misperception, which leads people to believe that it doesn't work.  If
you want to use a local connection (i.e. socket file, skipping TCP),
the hostname portion of your GRANT *must* be 'localhost'.

> In voicemail.conf, however, there is no paramter to specify a port
> (or socket), at least not from what I read here on the list.

That is correct; it was never added.  Given the licensing problem with
MySQL, it is not likely to be added.

> How is this supposed to work anyway - with another #include file,
> or does Asterisk internally merge mySQL voice mailbox settings and
> voicemail.conf? When I dial my test setup defined in mySQL then *
> complains that there is no such entry... :-(

Asterisk would use the settings in the MySQL database instead of, not
in addition to, the voicemail boxes in voicemail.conf.

-Tilghman