[Devel] dbtext script (dbtext related patches included)

[Herman Sheremetyev]

openserctl fifo already works fine with dbtext as long as you define
fifo_db_url="dbtext:///path/to/db".  It complains about not being able
to use the DBENGINE because it's hardcoded to only work with mysql and
pgsql but that doesn't affect its actual operation, and would be easy
enough to fix.

Speaking of dbtext, I had to patch permissions and domain modules to
actually work properly with dbtext tables.  dbtext column types return
as DB_STR and those modules insist on DB_STRING.  My patches aren't
pretty but I'm attaching in case someone will find it useful or wants
to include in the main branch.

-Herman


---------- Forwarded message ----------
From: Ovidiu Sas <sip.nslu at gmail.com>
Date: Feb 1, 2007 11:40 AM
Subject: dbtext script
To: users at openser.org


Hi,


Since dbtext is part of the standard, my suggestion would be to
ship/install the sc.dbtext script along with the openserctl script.

We can install it as openser_dbtext_ctl and in openserctl we can make
a reference to it if no DBENGINE is provided:

see the following patch for openserct (openser-v1.1.1):
diff -Naurp sip-server/scripts/openserctl openser/scripts/openserctl
--- sip-server/scripts/openserctl       2006-09-15 08:41:42.000000000 -0400
+++ openser/scripts/openserctl  2007-01-17 09:39:09.000000000 -0500
@@ -126,6 +126,8 @@ do
        $f
 done
        echo
+       echo "Note: Use openser_dbtext_ctl for DBTEXT operations!"
+       echo

 }



Regards,
Ovidiu Sas
-------------- next part --------------
A non-text attachment was scrubbed...
Name: domain-db_str.patch
Type: text/x-patch
Size: 576 bytes
Desc: not available
Url : http://openser.org/pipermail/devel/attachments/20070202/9de9d575/domain-db_str.bin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: permissions-trusted-db_str.patch
Type: text/x-patch
Size: 1097 bytes
Desc: not available
Url : http://openser.org/pipermail/devel/attachments/20070202/9de9d575/permissions-trusted-db_str.bin