<font color='black' size='2' face='arial'>
<div style="FONT-FAMILY: arial,helvetica; COLOR: black; FONT-SIZE: 10pt">
<div id=AOLMsgPart_2_7082e7f5-bf19-4c67-99d2-324974f762ff><FONT color=black size=2 face=arial>
<div style="FONT-FAMILY: arial,helvetica; COLOR: black; FONT-SIZE: 10pt">
<div id=AOLMsgPart_2_f0252633-4a8b-4416-9498-864f19b57d05><FONT color=black size=2 face=arial><FONT color=black size=2 face=arial>
<div style="FONT-FAMILY: arial,helvetica; COLOR: black; FONT-SIZE: 10pt">
<div id=AOLMsgPart_2_551416bc-d0a2-4b40-a2eb-d1ffe2d09211><FONT color=black size=2 face=arial>
<div style="FONT-FAMILY: arial,helvetica; COLOR: black; FONT-SIZE: 10pt">
<div style="BACKGROUND-COLOR: rgb(255,255,255); MARGIN: 0px; FONT-FAMILY: Tahoma,Verdana,Arial,Sans-Serif; COLOR: rgb(0,0,0); FONT-SIZE: 12px" id=AOLMsgPart_0_84af452f-a6df-49e1-8a24-9bc8ad150f16><TT>For this one, you need to ensure that res_odbc.so loads before <br>
res_config_odbc.so. Actually, the load order in 1.8 is such that, unless<br>
you're using static realtime, you should not be using the 'preload' directive<br>
at all, and everything will just naturally load in the right order.<br>
<FONT size=2>--<br>
If I got that right, static realtime would mean something like</FONT></TT></div>
<div style="BACKGROUND-COLOR: rgb(255,255,255); MARGIN: 0px; FONT-FAMILY: Tahoma,Verdana,Arial,Sans-Serif; COLOR: rgb(0,0,0); FONT-SIZE: 12px"><TT><SPAN lang=DE>
<div><FONT size=2></FONT> </div>
<div><FONT size=2>sip</FONT>.conf => driver,database[,<FONT size=2>table</FONT>[,priority]]</div>
<div><FONT size=2></FONT> </div>
<div><FONT size=2>But I have </FONT></div>
<div><FONT size=2></FONT> </div>
<SPAN lang=DE>
<div>sipusers => odbc,mssql,t_sip_buddies</div>
<div>sippeers => odbc,mssql,t_sip_buddies</div>
<div>sipregs => odbc,<FONT size=2>mssql</FONT>,t_sip_buddies</div>
<div><FONT size=2></FONT> </div>
<div><FONT size=2>so I would assume that I don't need to preload res_odbc.so and res_config_odbc.so?</FONT></div>
<div><FONT size=2></FONT> </div>
<div><FONT size=2>But without the preloads in modules.conf when trying to start asterisk I get</FONT></div>
<div><FONT size=2></FONT> </div>
<div>[Aug 24 16:28:34] NOTICE[6825]: cdr.c:1567 do_reload: CDR simple logging enabled.<br>
[Aug 24 16:28:34] NOTICE[6825]: loader.c:1098 load_modules: 193 modules will be loaded.<br>
[Aug 24 16:28:34] WARNING[6825]: loader.c:387 load_dynamic_module: Error loading module 'res_config_odbc.so': /usr/lib/asterisk/modules/res_config_odbc.so: undefined symbol: ast_odbc_clear_cache<br>
[Aug 24 16:28:34] NOTICE[6825]: res_odbc.c:1471 odbc_obj_connect: Connecting mssql<br>
asterisk: net.c:348: tds_select: Assertion `timeout_seconds >= 0' failed.</div>
<FONT size=2></FONT></SPAN></SPAN></TT></div>
<div style="BACKGROUND-COLOR: rgb(255,255,255); MARGIN: 0px; FONT-FAMILY: Tahoma,Verdana,Arial,Sans-Serif; COLOR: rgb(0,0,0); FONT-SIZE: 12px"><TT><SPAN lang=DE><SPAN lang=DE><FONT size=2></FONT>
<div> </div>
<div><FONT size=2>and asterisk does not start.</FONT></div>
<FONT size=2></FONT></SPAN></SPAN></TT></div>
<div style="BACKGROUND-COLOR: rgb(255,255,255); MARGIN: 0px; FONT-FAMILY: Tahoma,Verdana,Arial,Sans-Serif; COLOR: rgb(0,0,0); FONT-SIZE: 12px"><TT><SPAN lang=DE><SPAN lang=DE><FONT size=2></FONT></SPAN></SPAN></TT> </div>
<div style="BACKGROUND-COLOR: rgb(255,255,255); MARGIN: 0px; FONT-FAMILY: Tahoma,Verdana,Arial,Sans-Serif; COLOR: rgb(0,0,0); FONT-SIZE: 12px"><TT><SPAN lang=DE><SPAN lang=DE><FONT size=2>With the preloads I get</FONT></SPAN></SPAN></TT></div>
<div style="BACKGROUND-COLOR: rgb(255,255,255); MARGIN: 0px; FONT-FAMILY: Tahoma,Verdana,Arial,Sans-Serif; COLOR: rgb(0,0,0); FONT-SIZE: 12px"><TT><SPAN lang=DE><SPAN lang=DE><FONT size=2></FONT></SPAN></SPAN></TT> </div>
<div style="BACKGROUND-COLOR: rgb(255,255,255); MARGIN: 0px; FONT-FAMILY: Tahoma,Verdana,Arial,Sans-Serif; COLOR: rgb(0,0,0); FONT-SIZE: 12px"><TT><SPAN lang=DE><SPAN lang=DE>[Aug 24 16:29:25] NOTICE[6857]: loader.c:1098 load_modules: 2 modules will be loaded.<br>
[Aug 24 16:29:25] NOTICE[6857]: res_odbc.c:1471 odbc_obj_connect: Connecting mssql<br>
asterisk: net.c:348: tds_select: Assertion `timeout_seconds >= 0' failed.</SPAN></SPAN></TT></div>
<TT><SPAN lang=DE><SPAN lang=DE><FONT size=2></FONT></SPAN></SPAN></TT></div>
<div style="FONT-FAMILY: arial,helvetica; COLOR: black; FONT-SIZE: 10pt"><TT><SPAN lang=DE><SPAN lang=DE></SPAN></SPAN></TT> </div>
<div style="FONT-FAMILY: arial,helvetica; COLOR: black; FONT-SIZE: 10pt"><TT><SPAN lang=DE><SPAN lang=DE>and asterisk does not start either.</SPAN></SPAN></TT></div>
<div style="FONT-FAMILY: arial,helvetica; COLOR: black; FONT-SIZE: 10pt"><TT><SPAN lang=DE><SPAN lang=DE></SPAN></SPAN></TT> </div>
<div style="FONT-FAMILY: arial,helvetica; COLOR: black; FONT-SIZE: 10pt"><TT><SPAN lang=DE><SPAN lang=DE>Only if I set my DSN 'mssql' to enabled => no in res_odbc.conf asterisk starts, but then it can't access my sip users config of course.</SPAN></SPAN></TT></div>
<div style="FONT-FAMILY: arial,helvetica; COLOR: black; FONT-SIZE: 10pt"><TT><SPAN lang=DE><SPAN lang=DE></SPAN></SPAN></TT> </div>
<div style="FONT-FAMILY: arial,helvetica; COLOR: black; FONT-SIZE: 10pt"><TT><SPAN lang=DE><SPAN lang=DE>So for me this looks like a bug because in 1.6 this worked without any problems.</SPAN></SPAN></TT></div>
<div style="FONT-FAMILY: arial,helvetica; COLOR: black; FONT-SIZE: 10pt"><TT><SPAN lang=DE><SPAN lang=DE></SPAN></SPAN></TT> </div>
<div style="FONT-FAMILY: arial,helvetica; COLOR: black; FONT-SIZE: 10pt"><TT><SPAN lang=DE><SPAN lang=DE>Oliver</SPAN></SPAN></TT></FONT></FONT></FONT><FONT color=black size=2 face=arial><FONT color=black size=2 face=arial><FONT color=black size=2 face=arial><TT><SPAN lang=DE><SPAN lang=DE></div>
</div>
</div>
</div>
</div>
<div style="BACKGROUND-COLOR: rgb(255,255,255); MARGIN: 0px; FONT-FAMILY: Tahoma,Verdana,Arial,Sans-Serif; COLOR: rgb(0,0,0); FONT-SIZE: 12px"><br>
</div>
<div style="BACKGROUND-COLOR: rgb(255,255,255); MARGIN: 0px; FONT-FAMILY: Tahoma,Verdana,Arial,Sans-Serif; COLOR: rgb(0,0,0); FONT-SIZE: 12px"><br>
</div>
</SPAN></SPAN></TT></FONT></FONT></FONT></FONT></div>
<!-- end of AOLMsgPart_2_7082e7f5-bf19-4c67-99d2-324974f762ff --></div>
</font>