23 Aug
2004
23 Aug
'04
5 p.m.
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(a)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@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(a)tss.net | |
| 20040713164014 |
| default | 3609152050 | 1234 | | support(a)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