On Fri, Jul 20, 2012 at 11:40 AM, Alex <alex@thewinelake.com> wrote:

Trying to do some stuff with the voicemail database from a php script.
Couldn't quickly find the connection runes to the sqlite DB.

Tried the following, but got the error "file is encrypted or is not a
database"

<?php
echo sqlite_libversion();
echo "<br>";

echo phpversion();
$dbhandle = sqlite_open('/usr/local/freeswitch/db/voicemail_default.db',
0666, $error);
if (!$dbhandle) die ($error);

$sql = "SELECT * from voicemail_prefs";

$result = sqlite_exec($dbhandle, $stm, $error);
while ($row = sqlite_fetch_array($result, SQLITE_ASSOC)) {
print_r($row);
}

?>






_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

Join Us At ClueCon - Aug 7-9, 2012

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org