<br><br><div class="gmail_quote">On Fri, Nov 27, 2009 at 2:49 AM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com">miconda@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div></div><div class="h5">Hello,<br>
<br>
On 25.11.2009 5:40 Uhr, JR Richardson wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi All,<br>
<br>
Using openser 1.1.0-notls (i386/linux) from debian etch package.<br>
<br>
Working with mysql database integration, working fine, using permissions module with 'trusted' table and alias_db module with the 'dbalias' table.<br>
<br>
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.<br>
<br>
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?<br>
<br>
I have not tried yet, but would it break if I added the new columns to the openser_mysql script created tables?<br>
<br>
</blockquote>
first, 1.1.0 is very old, better use a more recent version, kamailio 1.5.3 for example.<br>
<br>
Then, adding custom columns in the db tables does not affect kamailio.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
-- <br>
Daniel-Constantin Mierla<br>
* <a href="http://www.asipto.com/" target="_blank">http://www.asipto.com/</a><br>
<br>
</div></div></blockquote></div>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.<br>
<br>Thanks.<br><br>JR<br>-- <br>JR Richardson<br>Engineering for the Masses<br>