[Kamailio-Users] Adding Columns to Database

[JR Richardson]

On Fri, Nov 27, 2009 at 2:49 AM, Daniel-Constantin Mierla <miconda at gmail.com
> wrote:

> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/users/attachments/20091128/177e66cf/attachment.htm>