Voicemail Explorer with MySQL

celkin

My install (a beta version of Thirdlane MTE) stores voicemail in the pbxconf database. Can Voicemail explorer be configured to access them? The button shows the voicemail count correctly, but the explorer is looking to the file system, so they are not accessible.

nicolas

FOP2 version 2.27 supports odbc storage for voicemail, as used in asterisk. If TL uses odbc voicemail, then it should work providing you pass the correct odbc connection string

http://download.fop2.com/fop2-2.27-centos-i386.tgz
http://download.fop2.com/fop2-2.27-centos-x86_64.tgz

Read the fop2.cfg file for the relevant odbc config entries:

; For odbc based voicemail storage, you can set voicemail path to
; dbi:ODBC:name , where name is the dsn name as setup in odbc.ini
; By default the voicemessages table will be used, if you use a
; different one, you can specify it by appending !tablename
;
;voicemail_path=dbi:ODBC:asterisk!voicemessages

celkin

after upgrading(the x86_64 version), I get the following message when I attempt to start the server:

/usr/local/fop2/fop2_server -X 15
Flash Operator Panel 2 - White Label Version.
install_driver(ODBC) failed: Can't load '/tmp/par-root/cache-60e55ee7cac89b0db50861360bee1f7ebf101b04/b7a0966d.so' for module DBD::ODBC: libodbc.so.1: wrong ELF class: ELFCLASS32 at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.
at /usr/lib/perl5/site_perl/5.8.8/PAR/Heavy.pm line 128
Compilation failed in require at (eval 44) line 3.
Perhaps a required shared library or dll isn't installed where expected
at script/fop2_server.pl line 362

if I comment out the voicemail line (voicemail_path=dbi:ODBC:pbxconf!voicemail_messages), the server starts fine.

nicolas

Did you install the 64 bits version? The error shows clearly a problem with the binary format ELF32 bits, seems like you might have installed the 32 bits version instead?

celkin

I installed the 64 bit version from the link you provided.

nicolas

What's the output from this command:

uname -a

?

nicolas

I have updated the file and made sure the pakcaged library was indeed the 64 bits one. Please download it again and replace your fop2_server binary, let me know if it works.
Best regards,