Hi, Nathan;
Can I know what the contents of you voicemail.conf now? I get Asterisk
Realtime Sip and extension working. I am trying to make Asterisk Realtime
voicemail works, but not luck. Do I miss some steps?
Previously I was using voicemail.conf. It works well.
# cat voicemail.conf
[general]
format=wav
[local]
2000 => 4321, Wei Kun, [EMAIL PROTECTED]
2001 => 8383, Wei Kun, [EMAIL PROTECTED]
So I moved all the data into DB, and comment out items in voicemail.conf
mysql> select * from voicemail_users;
+----------+-------------+---------+---------+----------+----------+--------
---------------+------+
| uniqueid | customer_id | context | mailbox | password | fullname | email
| page |
+----------+-------------+---------+---------+----------+----------+--------
---------------+------+
| 1 | 2000 | local | 2000 | 4321 | Wei Kun |
[EMAIL PROTECTED] | |
| 2 | 2001 | local | 2001 | 8765 | Wei Kun |
[EMAIL PROTECTED] | |
+----------+-------------+---------+---------+----------+----------+--------
---------------+------+
2 rows in set (0.03 sec)
The extension table looks like
mysql> select * from extensions_table;
+----+----------+-------+----------+---------------+----------------+
| id | context | exten | priority | app | appdata |
+----+----------+-------+----------+---------------+----------------+
| 1 | from-sip | 2000 | 1 | Dial | SIP/2000|20 |
| 2 | from-sip | 2000 | 2 | Voicemail | u2000 |
| 3 | from-sip | 2000 | 102 | Voicemail | b2000 |
| 4 | from-sip | 2000 | 103 | Hangup | |
| 5 | from-sip | 2001 | 1 | Dial | SIP/2001|20 |
| 6 | from-sip | 2001 | 2 | Voicemail | u2001 |
| 7 | from-sip | 2001 | 102 | Voicemail | b2001 |
| 8 | from-sip | 2001 | 103 | Hangup | |
| 9 | from-sip | 2999 | 1 | VoicemailMain | ${CALLERIDNUM} |
+----+----------+-------+----------+---------------+----------------+
9 rows in set (0.01 sec)
If I call 2001 from 2000, it take priority 1 and ring, and go to priority
2, now it get warning
Aug 11 15:04:08 WARNING[9316] app_voicemail.c: No entry in voicemail config
file for '2001'
no debug regarding this part. It looks like asterisk still looking for the
config file?
The extconfig looks like
voicemail => mysql,asterisk,voicemail_users
Kun
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Nathan Alberti
Sent: Friday, August 12, 2005 9:46 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] Realtime + MYSQL
Timur,
Thank you for your response, I realize my mistake.
I didn't understand that the table structures were different for the
static component of real time as apposed to the actual real time part.
Thank you again for your assistance.
Nathan.
Timur V. Elzhov wrote:
> On Thu, Aug 11, 2005 at 09:20:36AM -0400, Nathan Alberti wrote:
>
>
>>I'm having a few issues with the MySQL realtime configuration in
>>CVS-HEAD. I tested it initially with realtime extensions (realtime_ext
>>=> mysql,asterisk,extensions) and a realtime switch in extensions.conf
>>and that works fine, So I though I'd go back and test a static
>>configuration mapping.
>>
>>I used the table structure from the asterisk guru postgres howto to
>>create something similar in MySQL (shown below) and included the
>>following in extconfig;
>>
>>voicemail.conf => mysql,asterisk,voicemail_users
>
>
> No, this way is used to store NOT voicemail users info, but ANY
> configuration file. To create such a table from the existing config
> filr use ast2sql.pl script. Link is given here:
> http://www.voip-info.org/tiki-index.php?page=Asterisk+RealTime+Static
>
> But you're probably want to create just the voicemail users config
> table:
>
>
>>####MySQL Table####
>>CREATE TABLE voicemail_users (
>>id int NOT NULL auto_increment,
>>customer_id varchar(255) NOT NULL default '0',
>>context varchar(255) NOT NULL default '',
>>mailbox varchar(255) NOT NULL default '',
>>password varchar(4) NOT NULL default '0',
>>fullname varchar(50) NOT NULL default '',
>>email varchar(50) NOT NULL default '',
>>pager varchar(50) NOT NULL default '',
>>stamp datetime NOT NULL default '0000-00-00 00:00:00',
>>PRIMARY KEY (`id`)
>>);
>>#######
>
>
> So the correct line in extconfig.conf must be
>
> voicemail => mysql,asterisk,voicemail_users
>
> not voicemail.conf => mysql,asterisk,voicemail_users
>
>
> --
> Best regards,
> Timur.
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@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
_______________________________________________
Asterisk-Users mailing list
Asterisk-Users@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
_______________________________________________
Asterisk-Users mailing list
Asterisk-Users@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
