<div dir="ltr">Try with <span style="color:rgb(0,0,187);font-family:Consolas,'Andale Mono WT','Andale Mono','Lucida Console',Monaco,'Courier New',Courier,monospace;font-size:14px;text-align:left;background-color:rgb(225,225,225)">SQLite3</span><br clear="all">
<div dir="ltr"><span style="font-family:Verdana,Arial,Helvetica,sans-serif"><span style="font-size:small">-Avi</span></span></div>
<br><br><div class="gmail_quote">On Fri, Jul 20, 2012 at 11:40 AM, Alex <span dir="ltr"><<a href="mailto:alex@thewinelake.com" target="_blank">alex@thewinelake.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Trying to do some stuff with the voicemail database from a php script.<br>
Couldn't quickly find the connection runes to the sqlite DB.<br>
<br>
Tried the following, but got the error "file is encrypted or is not a<br>
database"<br>
<br>
<?php<br>
echo sqlite_libversion();<br>
echo "<br>";<br>
<br>
echo phpversion();<br>
$dbhandle = sqlite_open('/usr/local/freeswitch/db/voicemail_default.db',<br>
0666, $error);<br>
if (!$dbhandle) die ($error);<br>
<br>
$sql = "SELECT * from voicemail_prefs";<br>
<br>
$result = sqlite_exec($dbhandle, $stm, $error);<br>
while ($row = sqlite_fetch_array($result, SQLITE_ASSOC)) {<br>
print_r($row);<br>
}<br>
<br>
?><br>
<br>
<br>
<br>
<br>
<br>
<br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
Join Us At ClueCon - Aug 7-9, 2012<br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</blockquote></div><br></div>