[Kamailio-Users] Adding Columns to Database
jmr.richardson at gmail.com
Wed Nov 25 05:40:31 CET 2009
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?
Engineering for the Masses
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Users