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/