thr3ads.net - asterisk users - [asterisk-users] MySQL Voicemail Storage Questions\Errors [Feb 2008]

If this information is useful, please help other people find it:
Share via:

Mike Hammett

2008-Feb-23 00:28 UTC

[asterisk-users] MySQL Voicemail Storage Questions\Errors

I am running CentOS 5 with Asterisk 1.4.14.  I am trying to setup storage of
voicemail messages into MySQL.  It is my understanding that I can only do this
via ODBC.  I installed per
http://www.voip-info.org/wiki/view/CentOS+5+and+Asterisk+1.4.x+installation 
unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel and
mysql-connector-odbc. I reconfigured and built Asterisk, using menuconfig to
turn on ODBC voicemail storage.  Here is the output of some config files:

[root at Aiur asterisk]# cat /etc/odbcinst.ini
# Example driver definitinions
#
#

# Included in the unixODBC package
#[PostgreSQL]
#Description    = ODBC for PostgreSQL
#Driver         = /usr/lib/libodbcpsql.so
#Setup          = /usr/lib/libodbcpsqlS.so
#FileUsage      = 1


# Driver from the MyODBC package
# Setup from the unixODBC package
[MySQL]
Description     = ODBC for MySQL
Driver          = /usr/lib64/libmyodbc3.so
Setup           = /usr/lib64/libodbcmyS.so
FileUsage       = 1
You have new mail in /var/spool/mail/root
[root at Aiur asterisk]# cat /etc/odbc.ini
[astrealtime]
Description     = Asterisk realtime FUNC_ODBC access
Driver          = MySQL
Socket          = /var/lib/mysql/mysql.sock
Server          = localhost
User            = astrealtime
Pass            = XXXX
Database        = asterisk
Option          = 3
[root at Aiur asterisk]# cat  /etc/asterisk/res_odbc.conf
;;; odbc setup file

; ENV is a global set of environmental variables that will get set.
; Note that all environmental variables can be seen by all connections,
; so you can't have different values for different connections.
[ENV]
INFORMIXSERVER => my_special_database
INFORMIXDIR => /opt/informix

; All other sections are arbitrary names for database connections.

[asterisk]
enabled => no
dsn => asterisk
;username => myuser
;password => mypass
pre-connect => yes


[mysql]
enabled => yes
dsn => MySQL-asterisk
username => astrealtime
password => XXXX
pre-connect => yes

; Certain servers, such as MS SQL Server and Sybase use the TDS protocol, which
; limits the number of active queries per connection to 1.  By setting up pools
; of connections, Asterisk can be made to work with these servers.
[sqlserver]
enabled => no
dsn => mickeysoft
pooling => yes
limit => 5
username => oscar
password => thegrouch
pre-connect => yes



[root at Aiur asterisk]# cat /etc/asterisk/voicemail.conf
odbcstorage=mysql
odbctable=voicemail_messages

[root at Aiur asterisk]# asterisk -vvv | grep odbc
  == Parsing '/etc/asterisk/res_odbc.conf': Found
[Feb 22 18:21:46] NOTICE[21214]: res_odbc.c:229 load_odbc_config: Adding ENV
var: INFORMIXSERVER=my_special_database
[Feb 22 18:21:46] NOTICE[21214]: res_odbc.c:229 load_odbc_config: Adding ENV
var: INFORMIXDIR=/opt/informix
[Feb 22 18:21:46] NOTICE[21214]: res_odbc.c:508 odbc_obj_connect: Connecting
mysql
[Feb 22 18:21:46] WARNING[21214]: res_odbc.c:519 odbc_obj_connect: res_odbc:
Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not
found, and no default driver specified
[Feb 22 18:21:46] WARNING[21214]: res_odbc.c:444 ast_odbc_request_obj: Failed to
connect to mysql
[Feb 22 18:21:46] NOTICE[21214]: res_odbc.c:302 load_odbc_config: Registered
ODBC class 'mysql' dsn->[MySQL-asterisk]
[Feb 22 18:21:46] NOTICE[21214]: res_odbc.c:684 load_module: res_odbc loaded.
res_odbc.so => (ODBC Resource)
[Feb 22 18:21:46] NOTICE[21214]: config.c:1250 ast_config_engine_register:
Registered Config Engine odbc
res_config_odbc loaded.
res_config_odbc.so => (ODBC Configuration)
  == Parsing '/etc/asterisk/func_odbc.conf': Found
func_odbc.so => (ODBC lookups)
  == Parsing '/etc/asterisk/cdr_odbc.conf': Found
cdr_odbc.so => (ODBC CDR Backend)



[root at Aiur asterisk]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 22 to server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the
buffer.

mysql> use asterisk;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> describe voicemail_messages;
+----------------+-------------+------+-----+---------+----------------+
| Field          | Type        | Null | Key | Default | Extra          |
+----------------+-------------+------+-----+---------+----------------+
| id             | int(11)     | NO   | PRI | NULL    | auto_increment |
| msgnum         | int(11)     | NO   |     | 0       |                |
| dir            | varchar(80) | YES  | MUL | NULL    |                |
| context        | varchar(80) | YES  |     | NULL    |                |
| macrocontext   | varchar(80) | YES  |     | NULL    |                |
| callerid       | varchar(40) | YES  |     | NULL    |                |
| origtime       | varchar(40) | YES  |     | NULL    |                |
| duration       | varchar(20) | YES  |     | NULL    |                |
| mailboxuser    | varchar(80) | YES  |     | NULL    |                |
| mailboxcontext | varchar(80) | YES  |     | NULL    |                |
| recording      | longblob    | YES  |     | NULL    |                |
+----------------+-------------+------+-----+---------+----------------+
11 rows in set (0.00 sec)

mysql> exit;
Bye







Here is an example of the errors I'm getting (ignore No route to
destination, those phones just aren't on):



    -- Executing Goto("SIP/2441-ac047f90",
"rwest|815XXXXXXX|1")
    -- Goto (rwest,815XXXXXXX,1)
    -- Executing NoOp("SIP/2441-ac047f90", "CallerID is
"WIRELESS CALLER" <XXXXXXX>")
    -- Executing Dial("SIP/2441-ac047f90",
"SIP/rwest200&SIP/rwest201&SIP/rwest202&SIP/rwest203|15")
[Feb 22 18:14:42] WARNING[21068]: app_voicemail.c:2233 inboxcount: Failed to
obtain database object for 'asterisk'!
    -- Called rwest200
[Feb 22 18:14:42] WARNING[21149]: app_dial.c:1111 dial_exec_full: Unable to
create channel of type 'SIP' (cause 3 - No route to destination)
[Feb 22 18:14:42] WARNING[21149]: app_dial.c:1111 dial_exec_full: Unable to
create channel of type 'SIP' (cause 3 - No route to destination)
[Feb 22 18:14:42] WARNING[21149]: app_dial.c:1111 dial_exec_full: Unable to
create channel of type 'SIP' (cause 3 - No route to destination)
[Feb 22 18:14:42] NOTICE[21068]: chan_sip.c:12414 handle_response_peerpoke: Peer
'rwest200' is now Reachable. (37ms / 2000ms)
    -- SIP/rwest200-19612180 is ringing
[Feb 22 18:14:53] WARNING[21068]: app_voicemail.c:2233 inboxcount: Failed to
obtain database object for 'asterisk'!
    -- Nobody picked up in 15000 ms
[Feb 22 18:14:57] NOTICE[21149]: cdr.c:434 ast_cdr_free: CDR on channel
'SIP/rwest200-19612180' not posted
    -- Executing BackGround("SIP/2441-ac047f90",
"/var/lib/asterisk/sounds/rwestgreeting")
    -- <SIP/2441-ac047f90> Playing
'/var/lib/asterisk/sounds/rwestgreeting' (language 'en')
[Feb 22 18:15:04] WARNING[21068]: app_voicemail.c:2233 inboxcount: Failed to
obtain database object for 'asterisk'!
  == CDR updated on SIP/2441-ac047f90
    -- Executing Voicemail("SIP/2441-ac047f90", "200 at
rwest|u")
[Feb 22 18:15:09] WARNING[21149]: app_voicemail.c:1122 retrieve_file: Failed to
obtain database object for 'asterisk'!
[Feb 22 18:15:09] WARNING[21149]: app_voicemail.c:1122 retrieve_file: Failed to
obtain database object for 'asterisk'!
[Feb 22 18:15:09] WARNING[21149]: app_voicemail.c:1122 retrieve_file: Failed to
obtain database object for 'asterisk'!
    -- <SIP/2441-ac047f90> Playing 'vm-theperson' (language
'en')
    -- <SIP/2441-ac047f90> Playing 'digits/2' (language
'en')
    -- <SIP/2441-ac047f90> Playing 'digits/0' (language
'en')
    -- <SIP/2441-ac047f90> Playing 'digits/0' (language
'en')
    -- <SIP/2441-ac047f90> Playing 'vm-isunavail' (language
'en')
    -- <SIP/2441-ac047f90> Playing 'vm-intro' (language
'en')
[Feb 22 18:15:15] WARNING[21068]: app_voicemail.c:2233 inboxcount: Failed to
obtain database object for 'asterisk'!
[Feb 22 18:15:20] WARNING[21149]: app_voicemail.c:1187 last_message_index:
Failed to obtain database object for 'asterisk'!
    -- <SIP/2441-ac047f90> Playing 'beep' (language 'en')
    -- Recording the message
    -- x=0, open writing:  /var/spool/asterisk/voicemail/rwest/200/tmp/me15Bl
format: wav, 0x19652c30
[Feb 22 18:15:26] WARNING[21068]: app_voicemail.c:2233 inboxcount: Failed to
obtain database object for 'asterisk'!
    -- User hung up
[Feb 22 18:15:26] WARNING[21149]: app_voicemail.c:1233 message_exists: Failed to
obtain database object for 'asterisk'!
[Feb 22 18:15:26] WARNING[21149]: app_voicemail.c:1263 delete_file: Failed to
obtain database object for 'asterisk'!
[Feb 22 18:15:26] WARNING[21149]: app_voicemail.c:1400 store_file: Failed to
obtain database object for 'asterisk'!
[Feb 22 18:15:26] WARNING[21149]: app_voicemail.c:1122 retrieve_file: Failed to
obtain database object for 'asterisk'!
[Feb 22 18:15:26] WARNING[21149]: app_voicemail.c:2277 messagecount: Failed to
obtain database object for 'asterisk'!
[Feb 22 18:15:26] WARNING[21149]: app_voicemail.c:2277 messagecount: Failed to
obtain database object for 'asterisk'!
  == Spawn extension (rwest, 300, 1) exited non-zero on
'SIP/2441-ac047f90'



----------
Mike Hammett
Intelligent Computing Solutions
http://www.ics-il.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20080222/52243907/attachment-0001.htm

Tilghman Lesher

2008-Feb-23 00:56 UTC

head link

[asterisk-users] MySQL Voicemail Storage Questions\Errors

On Friday 22 February 2008 18:28:56 Mike Hammett wrote:
--snip--> [asterisk]
> enabled => no
> dsn => asterisk
> ;username => myuser
> ;password => mypass
> pre-connect => yes
--snip--> WARNING[21068]: app_voicemail.c:2233 inboxcount: Failed to obtain database
> object for 'asterisk'!
What does "enabled" mean to you?

-- 
Tilghman

Mike Hammett

2008-Mar-12 03:10 UTC

head link

[asterisk-users] MySQL Voicemail Storage Questions\Errors

[root at Aiur asterisk]# cat /etc/odbc.ini
[astrealtime]
Description             = MySQL ODBC For Asterisk
Trace           = Yes
TraceFile               = /tmp/odbc.log
Driver          = MySQL
Server          = localhost
User            = astrealtime
Password                = XXXX
Database                = asterisk
Socket          = /var/lib/mysql/mysql.sock

[root at Aiur asterisk]# cat /etc/odbcinst.ini
[MySQL]
Description             = ODBC for MySQL
Driver          = /usr/lib/libmyodbc.so
Setup           = /usr/lib/libodbcmyS.so
UsageCount              = 4

[MySQL ODBC 3.51 Driver]
Description             = ODBC 3.51 for MySQL
DRIVER          = /usr/lib/libmyodbc3.so
SETUP           = /usr/lib/libmyodbc3S.so
UsageCount              = 4

[root at Aiur asterisk]# isql astrealtime astrealtime XXXX
[ISQL]ERROR: Could not SQLConnect
[root at Aiur asterisk]# locate libmyodbc
/usr/lib64/libmyodbc3-3.51.12.so
/usr/lib64/libmyodbc3.so
/usr/lib64/libmyodbc3_r-3.51.12.so
/usr/lib64/libmyodbc3_r.so
[root at Aiur asterisk]# locate libodbcmyS
/usr/lib/libodbcmyS.a
/usr/lib/libodbcmyS.so
/usr/lib/libodbcmyS.so.1
/usr/lib/libodbcmyS.so.1.0.0
/usr/lib64/libodbcmyS.a
/usr/lib64/libodbcmyS.so
/usr/lib64/libodbcmyS.so.1
/usr/lib64/libodbcmyS.so.1.0.0
[root at Aiur asterisk]# rpm -qa | grep odbc
mysql-connector-odbc-3.51.12-2.2
[root at Aiur asterisk]# rpm -qa | grep ODBC
unixODBC-2.2.11-7.1
unixODBC-2.2.11-7.1
unixODBC-devel-2.2.11-7.1
unixODBC-devel-2.2.11-7.1
[root at Aiur asterisk]# mysql -u astrealtime -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 484 to server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the
buffer.

mysql> use asterisk;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+--------------------+
| Tables_in_asterisk |
+--------------------+
| cdr                |
| extensions_table   |
| iax                |
| queue_members      |
| queues             |
| sip                |
| voicemail_messages |
| voicemail_users    |
+--------------------+
8 rows in set (0.00 sec)


    -- Executing [s-NOANSWER at macro-stdexten:1]
VoiceMail("SIP/9826-ac087500", "200 at ics|u") in new stack
[Mar 11 21:29:36] NOTICE[26144]: res_odbc.c:508 odbc_obj_connect: Connecting
mysql
[Mar 11 21:29:36] WARNING[26144]: res_odbc.c:519 odbc_obj_connect: res_odbc:
Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not
found, and no default driver specified
[Mar 11 21:29:36] WARNING[26144]: res_odbc.c:444 ast_odbc_request_obj: Failed to
connect to mysql
[Mar 11 21:29:36] WARNING[26144]: app_voicemail.c:1122 retrieve_file: Failed to
obtain database object for 'mysql'!
[Mar 11 21:29:36] NOTICE[26144]: res_odbc.c:508 odbc_obj_connect: Connecting
mysql
[Mar 11 21:29:36] WARNING[26144]: res_odbc.c:519 odbc_obj_connect: res_odbc:
Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not
found, and no default driver specified
[Mar 11 21:29:36] WARNING[26144]: res_odbc.c:444 ast_odbc_request_obj: Failed to
connect to mysql
[Mar 11 21:29:36] WARNING[26144]: app_voicemail.c:1122 retrieve_file: Failed to
obtain database object for 'mysql'!
[Mar 11 21:29:36] NOTICE[26144]: res_odbc.c:508 odbc_obj_connect: Connecting
mysql
[Mar 11 21:29:36] WARNING[26144]: res_odbc.c:519 odbc_obj_connect: res_odbc:
Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not
found, and no default driver specified
[Mar 11 21:29:36] WARNING[26144]: res_odbc.c:444 ast_odbc_request_obj: Failed to
connect to mysql
[Mar 11 21:29:36] WARNING[26144]: app_voicemail.c:1122 retrieve_file: Failed to
obtain database object for 'mysql'!
    -- <SIP/9826-ac087500> Playing 'vm-theperson' (language
'en')
    -- <SIP/9826-ac087500> Playing 'digits/2' (language
'en')
    -- <SIP/9826-ac087500> Playing 'digits/0' (language
'en')
    -- <SIP/9826-ac087500> Playing 'digits/0' (language
'en')
    -- <SIP/9826-ac087500> Playing 'vm-isunavail' (language
'en')
    -- <SIP/9826-ac087500> Playing 'vm-intro' (language
'en')
[Mar 11 21:29:46] NOTICE[26144]: res_odbc.c:508 odbc_obj_connect: Connecting
mysql
[Mar 11 21:29:46] WARNING[26144]: res_odbc.c:519 odbc_obj_connect: res_odbc:
Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not
found, and no default driver specified
[Mar 11 21:29:46] WARNING[26144]: res_odbc.c:444 ast_odbc_request_obj: Failed to
connect to mysql
[Mar 11 21:29:46] WARNING[26144]: app_voicemail.c:1187 last_message_index:
Failed to obtain database object for 'mysql'!
    -- <SIP/9826-ac087500> Playing 'beep' (language 'en')
    -- Recording the message
    -- x=0, open writing:  /var/spool/asterisk/voicemail/ics/200/tmp/oDVLVZ
format: wav49, 0x1230a0a0
    -- x=1, open writing:  /var/spool/asterisk/voicemail/ics/200/tmp/oDVLVZ
format: gsm, 0x122ea400
    -- x=2, open writing:  /var/spool/asterisk/voicemail/ics/200/tmp/oDVLVZ
format: wav, 0x122f3740
    -- User hung up
[Mar 11 21:30:25] NOTICE[26144]: res_odbc.c:508 odbc_obj_connect: Connecting
mysql
[Mar 11 21:30:25] WARNING[26144]: res_odbc.c:519 odbc_obj_connect: res_odbc:
Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not
found, and no default driver specified
[Mar 11 21:30:25] WARNING[26144]: res_odbc.c:444 ast_odbc_request_obj: Failed to
connect to mysql
[Mar 11 21:30:25] WARNING[26144]: app_voicemail.c:1233 message_exists: Failed to
obtain database object for 'mysql'!
[Mar 11 21:30:25] NOTICE[26144]: res_odbc.c:508 odbc_obj_connect: Connecting
mysql
[Mar 11 21:30:25] WARNING[26144]: res_odbc.c:519 odbc_obj_connect: res_odbc:
Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not
found, and no default driver specified
[Mar 11 21:30:25] WARNING[26144]: res_odbc.c:444 ast_odbc_request_obj: Failed to
connect to mysql
[Mar 11 21:30:25] WARNING[26144]: app_voicemail.c:1263 delete_file: Failed to
obtain database object for 'mysql'!
[Mar 11 21:30:25] NOTICE[26144]: res_odbc.c:508 odbc_obj_connect: Connecting
mysql
[Mar 11 21:30:25] WARNING[26144]: res_odbc.c:519 odbc_obj_connect: res_odbc:
Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not
found, and no default driver specified
[Mar 11 21:30:25] WARNING[26144]: res_odbc.c:444 ast_odbc_request_obj: Failed to
connect to mysql
[Mar 11 21:30:25] WARNING[26144]: app_voicemail.c:1400 store_file: Failed to
obtain database object for 'mysql'!
[Mar 11 21:30:25] NOTICE[26144]: res_odbc.c:508 odbc_obj_connect: Connecting
mysql
[Mar 11 21:30:25] WARNING[26144]: res_odbc.c:519 odbc_obj_connect: res_odbc:
Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not
found, and no default driver specified
[Mar 11 21:30:25] WARNING[26144]: res_odbc.c:444 ast_odbc_request_obj: Failed to
connect to mysql
[Mar 11 21:30:25] WARNING[26144]: app_voicemail.c:1122 retrieve_file: Failed to
obtain database object for 'mysql'!
[Mar 11 21:30:25] NOTICE[26144]: res_odbc.c:508 odbc_obj_connect: Connecting
mysql
[Mar 11 21:30:25] WARNING[26144]: res_odbc.c:519 odbc_obj_connect: res_odbc:
Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not
found, and no default driver specified
[Mar 11 21:30:25] WARNING[26144]: res_odbc.c:444 ast_odbc_request_obj: Failed to
connect to mysql
[Mar 11 21:30:25] WARNING[26144]: app_voicemail.c:2277 messagecount: Failed to
obtain database object for 'mysql'!
[Mar 11 21:30:25] NOTICE[26144]: res_odbc.c:508 odbc_obj_connect: Connecting
mysql
[Mar 11 21:30:25] WARNING[26144]: res_odbc.c:519 odbc_obj_connect: res_odbc:
Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not
found, and no default driver specified
[Mar 11 21:30:25] WARNING[26144]: res_odbc.c:444 ast_odbc_request_obj: Failed to
connect to mysql
[Mar 11 21:30:25] WARNING[26144]: app_voicemail.c:2277 messagecount: Failed to
obtain database object for 'mysql'!
  == Spawn extension (macro-stdexten, s-NOANSWER, 1) exited non-zero on
'SIP/9826-ac087500' in macro 'stdexten'
  == Spawn extension (macro-stdexten, s-NOANSWER, 1) exited non-zero on
'SIP/9826-ac087500'



----------
Mike Hammett
Intelligent Computing Solutions
http://www.ics-il.com


  ----- Original Message ----- 
  From: Mike Hammett 
  To: Asterisk Users Mailing List - Non-Commercial Discussion 
  Sent: Friday, February 22, 2008 7:28 PM
  Subject: [asterisk-users] MySQL Voicemail Storage Questions\Errors


  I am running CentOS 5 with Asterisk 1.4.14.  I am trying to setup storage of
voicemail messages into MySQL.  It is my understanding that I can only do this
via ODBC.  I installed per
http://www.voip-info.org/wiki/view/CentOS+5+and+Asterisk+1.4.x+installation 
unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel and
mysql-connector-odbc. I reconfigured and built Asterisk, using menuconfig to
turn on ODBC voicemail storage.  Here is the output of some config files:

  [root at Aiur asterisk]# cat /etc/odbcinst.ini
  # Example driver definitinions
  #
  #

  # Included in the unixODBC package
  #[PostgreSQL]
  #Description    = ODBC for PostgreSQL
  #Driver         = /usr/lib/libodbcpsql.so
  #Setup          = /usr/lib/libodbcpsqlS.so
  #FileUsage      = 1


  # Driver from the MyODBC package
  # Setup from the unixODBC package
  [MySQL]
  Description     = ODBC for MySQL
  Driver          = /usr/lib64/libmyodbc3.so
  Setup           = /usr/lib64/libodbcmyS.so
  FileUsage       = 1
  You have new mail in /var/spool/mail/root
  [root at Aiur asterisk]# cat /etc/odbc.ini
  [astrealtime]
  Description     = Asterisk realtime FUNC_ODBC access
  Driver          = MySQL
  Socket          = /var/lib/mysql/mysql.sock
  Server          = localhost
  User            = astrealtime
  Pass            = XXXX
  Database        = asterisk
  Option          = 3
  [root at Aiur asterisk]# cat  /etc/asterisk/res_odbc.conf
  ;;; odbc setup file

  ; ENV is a global set of environmental variables that will get set.
  ; Note that all environmental variables can be seen by all connections,
  ; so you can't have different values for different connections.
  [ENV]
  INFORMIXSERVER => my_special_database
  INFORMIXDIR => /opt/informix

  ; All other sections are arbitrary names for database connections.

  [asterisk]
  enabled => no
  dsn => asterisk
  ;username => myuser
  ;password => mypass
  pre-connect => yes


  [mysql]
  enabled => yes
  dsn => MySQL-asterisk
  username => astrealtime
  password => XXXX
  pre-connect => yes

  ; Certain servers, such as MS SQL Server and Sybase use the TDS protocol,
which
  ; limits the number of active queries per connection to 1.  By setting up
pools
  ; of connections, Asterisk can be made to work with these servers.
  [sqlserver]
  enabled => no
  dsn => mickeysoft
  pooling => yes
  limit => 5
  username => oscar
  password => thegrouch
  pre-connect => yes



  [root at Aiur asterisk]# cat /etc/asterisk/voicemail.conf
  odbcstorage=mysql
  odbctable=voicemail_messages

  [root at Aiur asterisk]# asterisk -vvv | grep odbc
    == Parsing '/etc/asterisk/res_odbc.conf': Found
  [Feb 22 18:21:46] NOTICE[21214]: res_odbc.c:229 load_odbc_config: Adding ENV
var: INFORMIXSERVER=my_special_database
  [Feb 22 18:21:46] NOTICE[21214]: res_odbc.c:229 load_odbc_config: Adding ENV
var: INFORMIXDIR=/opt/informix
  [Feb 22 18:21:46] NOTICE[21214]: res_odbc.c:508 odbc_obj_connect: Connecting
mysql
  [Feb 22 18:21:46] WARNING[21214]: res_odbc.c:519 odbc_obj_connect: res_odbc:
Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not
found, and no default driver specified
  [Feb 22 18:21:46] WARNING[21214]: res_odbc.c:444 ast_odbc_request_obj: Failed
to connect to mysql
  [Feb 22 18:21:46] NOTICE[21214]: res_odbc.c:302 load_odbc_config: Registered
ODBC class 'mysql' dsn->[MySQL-asterisk]
  [Feb 22 18:21:46] NOTICE[21214]: res_odbc.c:684 load_module: res_odbc loaded.
  res_odbc.so => (ODBC Resource)
  [Feb 22 18:21:46] NOTICE[21214]: config.c:1250 ast_config_engine_register:
Registered Config Engine odbc
  res_config_odbc loaded.
  res_config_odbc.so => (ODBC Configuration)
    == Parsing '/etc/asterisk/func_odbc.conf': Found
  func_odbc.so => (ODBC lookups)
    == Parsing '/etc/asterisk/cdr_odbc.conf': Found
  cdr_odbc.so => (ODBC CDR Backend)



  [root at Aiur asterisk]# mysql -u root -p
  Enter password:
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 22 to server version: 5.0.22

  Type 'help;' or '\h' for help. Type '\c' to clear the
buffer.

  mysql> use asterisk;
  Reading table information for completion of table and column names
  You can turn off this feature to get a quicker startup with -A

  Database changed
  mysql> describe voicemail_messages;
  +----------------+-------------+------+-----+---------+----------------+
  | Field          | Type        | Null | Key | Default | Extra          |
  +----------------+-------------+------+-----+---------+----------------+
  | id             | int(11)     | NO   | PRI | NULL    | auto_increment |
  | msgnum         | int(11)     | NO   |     | 0       |                |
  | dir            | varchar(80) | YES  | MUL | NULL    |                |
  | context        | varchar(80) | YES  |     | NULL    |                |
  | macrocontext   | varchar(80) | YES  |     | NULL    |                |
  | callerid       | varchar(40) | YES  |     | NULL    |                |
  | origtime       | varchar(40) | YES  |     | NULL    |                |
  | duration       | varchar(20) | YES  |     | NULL    |                |
  | mailboxuser    | varchar(80) | YES  |     | NULL    |                |
  | mailboxcontext | varchar(80) | YES  |     | NULL    |                |
  | recording      | longblob    | YES  |     | NULL    |                |
  +----------------+-------------+------+-----+---------+----------------+
  11 rows in set (0.00 sec)

  mysql> exit;
  Bye
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20080311/3b8415aa/attachment.htm

Maybe Matching Threads

Search for more reasonably related threads

asterisk users - Feb 2008 - MySQL Voicemail Storage Questions\Errors

[asterisk-users] MySQL Voicemail Storage Questions\Errors

[asterisk-users] MySQL Voicemail Storage Questions\Errors

[asterisk-users] MySQL Voicemail Storage Questions\Errors

Maybe Matching Threads