Fred wrote: > At 13:13 21/01/2008 -0600, Darrick Hartman (lists) wrote: >> This is not an Astlinux specific case. It's how mini_httpd works. > > Fine with me. I'll add this to my tutorial on AstLinux.
You should look at some of the changes coming with 0.5 and 0.6 as documented on the http://www.astlinux.org website. Specifically look at the runnix and unionfs web pages. >> I would be interested in seeing how you're using sqlite to store call data. > > For a couple of reasons: > 1. Since we sell softwares for a niche market, pretty much all our > customers are listed in the phonebook with a generic name, eg. "Garage"... > which isn't very helpful as far as CID is concerned. Thankfully, Asterisk > (apparently, no other PBX software can do this) is able to rewrite the CID > name on the fly before resuming the script when a call comes in. > > So what I do, is check if the call has a CID number -> if not, prompt for a > number -> look up the number in the database -> if available, fetch the > customer's name, or rewrite the CID name as "Not found in DB" -> ring the > phones -> if no one answers, let callers record a message, and hang up -> > move the WAV file into the www's data directory -> send an e-mail to the > support team telling me who called, and a link to the www's list of calls > so they can just click on the file to listen to it -> save the call into a > table -> have poor man's CRM read this to keep track of calls (who called, > for what, who handled the call, etc.) > > So... Asterisk's key/value BerkeleyDB just doesn't cut it. Hence my quest > for a Linux/FreeBSD distribution that supports Asterisk + PHP + SQLite, and > ideally, can run off a CF card because there's no room for a 3.5" HD. That's actually pretty cool! Let me know if you run into problems. Like I said, the SQLite package is probably 9 months old. There are likely updates available. If so, let me know and I can bump the version to the newest one available for sqlite3. (I'm assuming you want sqlite3) -- Darrick Hartman DJH Solutions, LLC http://www.djhsolutions.com ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Astlinux-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/astlinux-users Donations to support AstLinux are graciously accepted via PayPal to [EMAIL PROTECTED]
