[Kamailio-Users] Adding Columns to Database

JR Richardson jmr.richardson at gmail.com
Wed Nov 25 05:40:31 CET 2009


Hi All,

Using  openser 1.1.0-notls (i386/linux) from debian etch package.

Working with mysql database integration, working fine, using permissions
module with 'trusted' table and alias_db module with the 'dbalias' table.

I created the database and tables with openser_mysql cmd and things seemed
to work out of the box.  I ran into trouble when I dropped the database and
manually created just the 'trusted' and 'dbalias' tables and added a few
more columns in the tables [accountcode,notes,id(auto increment)].  When I
restarted openser, no go, was getting table version and structure errors.

So my question: is the table structure strict as per the openser_mysql
script and are all 19 tables required for a properly running instance?

I have not tried yet, but would it break if I added the new columns to the
openser_mysql script created tables?

Thanks.

JR
-- 
JR Richardson
Engineering for the Masses
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20091124/741ebd1f/attachment.htm>


More information about the sr-users mailing list