Try with SQLite3 -Avi 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