Sqlite support

FreePBX Development
1

Hi,

I would like to work on sqlite support for FreePBX to help port FreePBX to embedded Asterisk boxen like http://rowetel.com/ip04. If this is useful please let me know!

I would appreciate some tips on what areas need doing. I have read the sqlite.readme and have traced the problems to the DB:sqlite backend in the latest PHP, as per this post in the installation forum:

http://www.freepbx.org/forum/freepbx/installation/sqlite3-support

Cheers,

David

2

Dave,
contact me offlline although and let me know what your experience is. I’ve got a very crazy schedule over the next 3 weeks so I may be slow in responding. There is a fair amount that has been done but I know there are several holes. There are also several modules that need install script changes and about 6-8 of them are already done, sitting in tickets in the ticket system, but cuco who had been working on them some months ago never got them in.

3

Thanks Philippe - I have emailed you via the FreePBX private email facility.

4

Just an update:

I have been working on an x86 box to get FreePBX working happily with sqlite3. The main job so far was to write an updated version of sqlite3.php, the PHP PEAR:DB backend that connects to the sqlite3 library. Also, I think a few of the SQL tables were not initialised correctly.

However I now have some basic functionality on my x86 with sqlite3, for example I can add extensions and most of the screens aren’t bombing out with SQL errors like they were when I started! I’ll keep plugging away and submit a patch once I have a little more working.

Cheers,

David

5

Hi,

I have been working on sqlite3 support and now have a set of patches that support sqlite3. Most of the screens work OK and I can set extensions/trunks etc and make calls. I have carefully documented the work I have done here:

https://freetel.svn.sourceforge.net/svnroot/freetel/freepbx-sandbox

I have also developed a “sandbox” type build system to build (from source) everything you need (PHP, lighttpd, sqlite3 etc) to easily run and test these patches.

Please let me know the best way I can contribute these patches back to FreePBX.

Thanks,

David

6

hello, David:
I am very interested in the freepbx-sandbox. I want to move it to Alix board 2c2. I have checked from your website. it looks good for my environment. maybe we can do something together.
please email me at:[email protected].
regards!
James.zhu