[Asterisk-Users] Problem with Asterisk VM + MySQL Database

[TSS Support]

We are trying to use the MySQL database for voicemail logins. I can see that
* connects correctly to the database and is executing queries, so I'm pretty
sure I got the config right. However, it doesn't seem to be picking the
password up properly. Found a couple of old mailing list messages about this
but no solution. Anyone seen this before and can help me figure out what I'm
missing? Here's the info:

Relevent debug statements from *

vm:/etc/mysql# asterisk -vvvvvvvvvgrc
  == Parsing '/etc/asterisk/asterisk.conf': Found
Asterisk CVS-05/31/04-22:00:51, Copyright (C) 1999-2004 Digium.
Written by Mark Spencer <markster at digium.com>
=========================================================================
Connected to Asterisk CVS-05/31/04-22:00:51 currently running on vm (pid =
30519)
    -- Remote UNIX connection
    -- Executing Wait("SIP/voicemail-6e98", "1") in new stack
    -- Executing VoiceMailMain("SIP/voicemail-6e98", "") in new stack
    -- Playing 'vm-login' (language 'en')
    -- Playing 'vm-password' (language 'en')
    -- Incorrect password '1234' for user '3609152000' (context = <any>)
    -- Playing 'vm-incorrect' (language 'en')
vm*CLI>

A snippet from the startup debug messages for *:

vm:~# grep database asterisk.txt
    -- Logging into database with user asterisk, password (redacted), and
database asterisk

And from the MySQL log:

040823 13:36:10       3 Connect     asterisk at localhost on asterisk
040823 13:36:43       3 Query       SELECT
password,fullname,email,pager,options FROM users WHERE context='default' AND
mailbox='3609152000'

And finally, the table in MySQL:

mysql> select * from users;
+---------+------------+----------+----------+-----------------+-------+----
-----+----------------+
| context | mailbox    | password | fullname | email           | pager |
options | stamp          |
+---------+------------+----------+----------+-----------------+-------+----
-----+----------------+
| default | 3609152000 | 1234     |          | support at tss.net |       |
| 20040713164014 |
| default | 3609152050 | 1234     |          | support at tss.net |       |
| 20040713164025 |
+---------+------------+----------+----------+-----------------+-------+----
-----+----------------+
2 rows in set (0.00 sec)



So what did I miss? It looks like the right data is there, it's selecting
it, and successfully getting it back, but not letting us log in.

-Keith, TSS

_______________________________________________
Serusers mailing list
Serusers at iptel.org
http://mail.iptel.org/mailman/listinfo/serusers