[Asterisk-Users] Realtime + MYSQL

[Wei Kun]

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, wei-kun at mediaring.com
2001 => 8383, Wei Kun, kunwei2005 at gmail.com

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  |
wei-kun at mediaring.com |      |
|        2 |        2001 | local   |    2001 | 8765     | Wei Kun  |
kunwei2005 at gmail.com  |      |
+----------+-------------+---------+---------+----------+----------+--------
---------------+------+
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: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com]On 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 at 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 at 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