On Fri, Nov 27, 2009 at 2:49 AM, Daniel-Constantin Mierla <miconda(a)gmail.com
Hello,
On 25.11.2009 5:40 Uhr, JR Richardson wrote:
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?
first, 1.1.0 is very old, better use a more recent version, kamailio
1.5.3 for
example.
Then, adding custom columns in the db tables does not affect kamailio.
Cheers,
Daniel
--
Daniel-Constantin Mierla
*
http://www.asipto.com/
Thanks Daniel, I was going to try that next, the system I'm using is in
production so I did not want to upgrade just to test. Even though it is a
very old version, it sure is rock solid for what I'm doing with it. Great
project.
Thanks.
JR
--
JR Richardson
Engineering for the Masses