Hello <br><br>Thank you David Loh and Henning<br><br>I reviewed your instructions and did the next:<br><br>First I did the David's instructions, I just comment the lines 376 and 377 of the openser.cfg and the result was:<br>
<br>I don't get error message: <br>Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config file, line 376, column 2-6: syntax error<br>Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config file, line 376, column 2-6: <br>
Feb 27 01:05:53 [7788] ERROR:core:main: bad config file (2 errors)<br><br>but when i try to monitoring the system with command /usr/local/sbin/openserctl moni <br>I got the message: <br>ERROR: Error opening OpenSER's FIFO /tmp/openser_fifo<br>
ERROR: Make sure you have the line 'modparam("mi_fifo", "fifo_name", "/tmp/openser_fifo")' in your config<br>ERROR: and also have loaded the mi_fifo module.<br><br>I have attached the complete starting trace in starting_trace1.txt and the openser1.cfg<br>
<br>Then I tried with Henning's instructions, I changed my current openser.cfg for the openser.cfg that I donwloaded from <br><a href="http://devel.openser.org/svn/branches/1.3/etc/openser.cfg">http://devel.openser.org/svn/branches/1.3/etc/openser.cfg</a> and changed the properties to work with postgres but the result was<br>
same that when I followed the David's instructions.<br><br>so, I returned to the initial openser.cfg file and sow that the lines 154 and 155 of --usrloc params-- session were commented <br>#modparam("usrloc", "db_url",<br>
# "mysql://openser:openserrw@192.168.1.3/openser_1_3")<br><br>equals that 163 and 164 of --uth_db params-- session <br>#modparam("auth_db", "db_url",<br># "mysql://openser:openserrw@192.168.1.3/openser_1_3")<br>
<br>then I uncommented that lines and changed mysql for pgsql, <a href="http://192.168.1.3">192.168.1.3</a> for <a href="http://192.168.1.1">192.168.1.1</a> because it is the static ip of my pc and openser_1_3 for openser because it is the name of the database create in postgres<br>
<br>the new lines were:<br>modparam("usrloc", "db_url",<br> "pgsql://openser:openserrw@192.168.1.1/openser")<br><br>equals that 163 and 164 of --uth_db params-- session <br>modparam("auth_db", "db_url",<br>
"psql://openser:openserrw@192.168.1.1/openser")<br><br>I was run again the openser and the result was starting_trace2.txt and the config file used was openser2.cfg<br><br>As you can see there are some error asociate with the postgres module:<br>
ERROR:core:bind_dbmod: module pgsql does not export db_use_table function<br>Feb 28 22:58:23 [5979] ERROR:usrloc:mod_init: failed to bind database module<br>Feb 28 22:58:23 [5979] ERROR:core:init_mod: failed to initialize module usrloc<br>
Feb 28 22:58:23 [5979] ERROR:core:main: error while initializing modules<br>Feb 28 22:58:23 [5979] DBG:xlog:destroy: destroy module...<br><br>I don't know if it are the errors that Henning said in his response <br>that will be fixed in new release of openser 1.3.1<br>
<br>Thanks a lot for you time<br><br><br>Regards,<br>Mauricio Viveros<br><br><br><br><br><div><span class="gmail_quote">2008/2/28, David Loh <<a href="mailto:davidloh@vyke.com">davidloh@vyke.com</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000">
Hi there, from the error log it doesn't look like postgres or openser
1.3 fault, but your configuration file.<br>
<br>
Line 376 was the line with "exit", since you have comment out the whole
route[2], <br>
why leave the "exit" and close parenthesis there? <br>
<br>
You can try to comment out line 376 and 377 then start the openser,<br>
hopes this solve your question.<br>
<br>
Regards,<br>
David Loh<br>
<br>
Mauricio Viveros wrote:
<blockquote type="cite"><div><span class="e" id="q_1185fc0b9f99098c_1">Hello <br>
<br>
My name is Mauricio Viveros, I'm a Colombian programmer.<br>
I'm implementing VoIP system in a little company, so I'm installed <span style="font-weight: bold;">OPENSER </span>with <span style="font-weight: bold;">POSTGRES </span>module<span style="font-weight: bold;"> </span>but when I try to run <span style="font-weight: bold;">openser </span>I get dis error message:<br>
<br>
Feb 27 01:05:53 [7788] DBG:core:find_cmd_export_t: found
<sl_reply_error>(0) in module sl [/usr/local/lib/openser/modules/]<br>
Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config
file, line 376, column 2-6: syntax error<br>
Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config
file, line 376, column 2-6: <br>
Feb 27 01:05:53 [7788] ERROR:core:main: bad config file (2 errors)<br>
<br>
to see all trace, see the attached file <span style="font-weight: bold;">openser_error_message.txt </span><br>
I attached too the config files: <span style="font-weight: bold;">openser.cfg</span>
y <span style="font-weight: bold;">openserctlrc</span><br>
<br>
I hope that you can help me with this problem.<br>
Thank you very much.<br>
<br>
<br>
Mauricio Viveros<br>
Programmer <br>
Cali-Colombia<br>
<br>
<br>
<br>
<br>
</span></div><pre><pre><hr size="4" width="90%"><br>_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.openser.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Users@lists.openser.org</a><br>
<a href="http://lists.openser.org/cgi-bin/mailman/listinfo/users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://lists.openser.org/cgi-bin/mailman/listinfo/users</a>
</pre></pre>
</blockquote>
<br>
</div>
</blockquote></div><br>