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

[Philipp von Klitzing]

Hi!

> > 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'.

That I am aware of, in fact I made four users covering all possibilities 
(on one machine I need to use the local hostname instead of localhost for 
some reason); moreover I logged in locally using "mysql -u xxx -p" and 
that worked well for the db and table in question. So it must be 
something else.

> > 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.

What does that mean in this case:

1. The port is fixed to 3306, and hostname can be anything, or
2. Voicemail can only work with mySQL on the same box via socket and 
hostname must always be "localhost"?

Moreover: Do we have to expect mySQL support to be removed completely, 
and we should thus not spend our time on building on that, including CDR? 
Or will the db backend be swapped with something else like sqllite or pg? 
As you see I am a bit puzzled (and I am probably not alone at that). :->

> > 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.

Hm... where would I then define the [general] part and the [zonemessages] 
part that I currently have in voicemail.conf? I see no room for that in 
the proposed table structure.

Greetings, Philipp