27 Feb
2008
27 Feb
'08
5:53 p.m.
Hello
My name is Mauricio Viveros, I'm a Colombian programmer.
I'm implementing VoIP system in a little company, so I'm installed OPENSER with
POSTGRES module but when I try to run openser I get dis error message:
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/]
Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config file,
line 376, column 2-6: syntax error
Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config file,
line 376, column 2-6:
Feb 27 01:05:53 [7788] ERROR:core:main: bad config file (2 errors)
to see all trace, see the attached file openser_error_message.txt
I attached too the config files: openser.cfg y openserctlrc
I hope that you can help me with this problem.
Thank you very much.
Mauricio Viveros
Programmer
Cali-Colombia
28 Feb
28 Feb
12:32 p.m.
El Wednesday 27 February 2008 16:53:51 Mauricio Viveros escribió:
Hello
My name is Mauricio Viveros, I'm a Colombian programmer.
I'm implementing VoIP system in a little company, so I'm installed OPENSER
with POSTGRES module but when I try to run openser I get dis error message:
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/]
Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config file,
line 376, column 2-6: syntax error
Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config file,
line 376, column 2-6:
Feb 27 01:05:53 [7788] ERROR:core:main: bad config file (2 errors)
Obviously you have a "parse error in config file, line 376, column 2-6: syntax
error".
Instead od attaching all your files just paste that exact line (376).
Regards.
--
Iñaki Baz Castillo
ibc(a)in.ilimit.es
12:33 p.m.
On Wednesday 27 February 2008, Mauricio Viveros wrote:
My name is Mauricio Viveros, I'm a Colombian
programmer.
I'm implementing VoIP system in a little company, so I'm installed OPENSER
with POSTGRES module but when I try to run openser I get dis error message:
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/]
Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config file,
line 376, column 2-6: syntax error
Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config file,
line 376, column 2-6:
Feb 27 01:05:53 [7788] ERROR:core:main: bad config file (2 errors)
to see all trace, see the attached file openser_error_message.txt
I attached too the config files: openser.cfg y openserctlrc
I hope that you can help me with this problem.
Thank you very much.
Hi Mauricio,
i assume that you use version 1.3.0 of the server. There was a problem with
the configuration that gets shipped in this release, this causes probably the
error in line 376 of the config file. There were also some additional error
fixed in the default server configuration, you'll find a updated file (for
this release) at:
http://devel.openser.org/svn/branches/1.3/etc/openser.cfg
Perhaps you can base your modifications on this one.
I noticed that you want to use the postgres module. Please note that there are
a few additional issues with this database in the 1.3.0 version, for example
with the setup tools for this DB. This will be fixed in version 1.3.1 that
will come out in the near future, and also in the openser stable branch.
(Please don't CC to the team list, for general questions like this is the user
list the right one.)
Cheers,
Henning
1:18 p.m.
Hi there, from the error log it doesn't look like postgres or openser
1.3 fault, but your configuration file.
Line 376 was the line with "exit", since you have comment out the whole
route[2],
why leave the "exit" and close parenthesis there?
You can try to comment out line 376 and 377 then start the openser,
hopes this solve your question.
Regards,
David Loh
Mauricio Viveros wrote:
Hello
My name is Mauricio Viveros, I'm a Colombian programmer.
I'm implementing VoIP system in a little company, so I'm installed
OPENSER with POSTGRES module but when I try to run openser I get dis
error message:
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/]
Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config
file, line 376, column 2-6: syntax error
Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config
file, line 376, column 2-6:
Feb 27 01:05:53 [7788] ERROR:core:main: bad config file (2 errors)
to see all trace, see the attached file openser_error_message.txt
I attached too the config files: openser.cfg y openserctlrc
I hope that you can help me with this problem.
Thank you very much.
Mauricio Viveros
Programmer
Cali-Colombia
------------------------------------------------------------------------
_______________________________________________
Users mailing list
Users(a)lists.openser.org
http://lists.openser.org/cgi-bin/mailman/listinfo/users
29 Feb
29 Feb
4:31 p.m.
Hello
Thank you David Loh and Henning
I reviewed your instructions and did the next:
First I did the David's instructions, I just comment the lines 376 and 377
of the openser.cfg and the result was:
I don't get error message:
Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config file,
line 376, column 2-6: syntax error
Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config file,
line 376, column 2-6:
Feb 27 01:05:53 [7788] ERROR:core:main: bad config file (2 errors)
but when i try to monitoring the system with command
/usr/local/sbin/openserctl moni
I got the message:
ERROR: Error opening OpenSER's FIFO /tmp/openser_fifo
ERROR: Make sure you have the line 'modparam("mi_fifo",
"fifo_name",
"/tmp/openser_fifo")' in your config
ERROR: and also have loaded the mi_fifo module.
I have attached the complete starting trace in starting_trace1.txt and the
openser1.cfg
Then I tried with Henning's instructions, I changed my current
openser.cfgfor the
openser.cfg that I donwloaded from
http://devel.openser.org/svn/branches/1.3/etc/openser.cfg and changed the
properties to work with postgres but the result was
same that when I followed the David's instructions.
so, I returned to the initial openser.cfg file and sow that the lines 154
and 155 of --usrloc params-- session were commented
#modparam("usrloc", "db_url",
# "mysql://openser:openserrw@192.168.1.3/openser_1_3")
equals that 163 and 164 of --uth_db params-- session
#modparam("auth_db", "db_url",
# "mysql://openser:openserrw@192.168.1.3/openser_1_3")
then I uncommented that lines and changed mysql for pgsql, 192.168.1.3 for
192.168.1.1 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
the new lines were:
modparam("usrloc", "db_url",
"pgsql://openser:openserrw@192.168.1.1/openser")
equals that 163 and 164 of --uth_db params-- session
modparam("auth_db", "db_url",
"psql://openser:openserrw@192.168.1.1/openser")
I was run again the openser and the result was starting_trace2.txt and the
config file used was openser2.cfg
As you can see there are some error asociate with the postgres module:
ERROR:core:bind_dbmod: module pgsql does not export db_use_table function
Feb 28 22:58:23 [5979] ERROR:usrloc:mod_init: failed to bind database module
Feb 28 22:58:23 [5979] ERROR:core:init_mod: failed to initialize module
usrloc
Feb 28 22:58:23 [5979] ERROR:core:main: error while initializing modules
Feb 28 22:58:23 [5979] DBG:xlog:destroy: destroy module...
I don't know if it are the errors that Henning said in his response
that will be fixed in new release of openser 1.3.1
Thanks a lot for you time
Regards,
Mauricio Viveros
2008/2/28, David Loh <davidloh(a)vyke.com>om>:
Hi there, from the error log it doesn't look like postgres or openser 1.3fault, but
your configuration file.
Line 376 was the line with "exit", since you have comment out the whole
route[2],
why leave the "exit" and close parenthesis there?
You can try to comment out line 376 and 377 then start the openser,
hopes this solve your question.
Regards,
David Loh
Mauricio Viveros wrote:
Hello
My name is Mauricio Viveros, I'm a Colombian programmer.
I'm implementing VoIP system in a little company, so I'm installed OPENSER
with POSTGRES module but when I try to run openser I get dis error
message:
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/]
Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config file,
line 376, column 2-6: syntax error
Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config file,
line 376, column 2-6:
Feb 27 01:05:53 [7788] ERROR:core:main: bad config file (2 errors)
to see all trace, see the attached file openser_error_message.txt
I attached too the config files: openser.cfg y openserctlrc
I hope that you can help me with this problem.
Thank you very much.
Mauricio Viveros
Programmer
Cali-Colombia
------------------------------
_______________________________________________
Users mailing list
Users(a)lists.openser.org
http://lists.openser.org/cgi-bin/mailman/listinfo/users
4:35 p.m.
New subject: [OpenSER-Users] Fwd: Error starting Openser 1.3 with postgres
I'm sorry I forgot attach the files in my last email, so here they are.
---------- Forwarded message ----------
From: Mauricio Viveros <mavfez(a)gmail.com>
Date: 29-feb-2008 9:31
Subject: Re: [OpenSER-Users] Error starting Openser 1.3 with postgres
To: users(a)lists.openser.org
Hello
Thank you David Loh and Henning
I reviewed your instructions and did the next:
First I did the David's instructions, I just comment the lines 376 and 377
of the openser.cfg and the result was:
I don't get error message:
Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config file,
line 376, column 2-6: syntax error
Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config file,
line 376, column 2-6:
Feb 27 01:05:53 [7788] ERROR:core:main: bad config file (2 errors)
but when i try to monitoring the system with command
/usr/local/sbin/openserctl moni
I got the message:
ERROR: Error opening OpenSER's FIFO /tmp/openser_fifo
ERROR: Make sure you have the line 'modparam("mi_fifo",
"fifo_name",
"/tmp/openser_fifo")' in your config
ERROR: and also have loaded the mi_fifo module.
I have attached the complete starting trace in starting_trace1.txt and the
openser1.cfg
Then I tried with Henning's instructions, I changed my current
openser.cfgfor the
openser.cfg that I donwloaded from
http://devel.openser.org/svn/branches/1.3/etc/openser.cfg and changed the
properties to work with postgres but the result was
same that when I followed the David's instructions.
so, I returned to the initial openser.cfg file and sow that the lines 154
and 155 of --usrloc params-- session were commented
#modparam("usrloc", "db_url",
# "mysql://openser:openserrw@192.168.1.3/openser_1_3")
equals that 163 and 164 of --uth_db params-- session
#modparam("auth_db", "db_url",
# "mysql://openser:openserrw@192.168.1.3/openser_1_3")
then I uncommented that lines and changed mysql for pgsql, 192.168.1.3 for
192.168.1.1 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
the new lines were:
modparam("usrloc", "db_url",
"pgsql://openser:openserrw@192.168.1.1/openser")
equals that 163 and 164 of --uth_db params-- session
modparam("auth_db", "db_url",
"psql://openser:openserrw@192.168.1.1/openser")
I was run again the openser and the result was starting_trace2.txt and the
config file used was openser2.cfg
As you can see there are some error asociate with the postgres module:
ERROR:core:bind_dbmod: module pgsql does not export db_use_table function
Feb 28 22:58:23 [5979] ERROR:usrloc:mod_init: failed to bind database module
Feb 28 22:58:23 [5979] ERROR:core:init_mod: failed to initialize module
usrloc
Feb 28 22:58:23 [5979] ERROR:core:main: error while initializing modules
Feb 28 22:58:23 [5979] DBG:xlog:destroy: destroy module...
I don't know if it are the errors that Henning said in his response
that will be fixed in new release of openser 1.3.1
Thanks a lot for you time
Regards,
Mauricio Viveros
2008/2/28, David Loh <davidloh(a)vyke.com>om>:
Hi there, from the error log it doesn't look like postgres or openser 1.3fault, but
your configuration file.
Line 376 was the line with "exit", since you have comment out the whole
route[2],
why leave the "exit" and close parenthesis there?
You can try to comment out line 376 and 377 then start the openser,
hopes this solve your question.
Regards,
David Loh
Mauricio Viveros wrote:
Hello
My name is Mauricio Viveros, I'm a Colombian programmer.
I'm implementing VoIP system in a little company, so I'm installed OPENSER
with POSTGRES module but when I try to run openser I get dis error
message:
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/]
Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config file,
line 376, column 2-6: syntax error
Feb 27 01:05:53 [7788] CRITICAL:core:yyerror: parse error in config file,
line 376, column 2-6:
Feb 27 01:05:53 [7788] ERROR:core:main: bad config file (2 errors)
to see all trace, see the attached file openser_error_message.txt
I attached too the config files: openser.cfg y openserctlrc
I hope that you can help me with this problem.
Thank you very much.
Mauricio Viveros
Programmer
Cali-Colombia
------------------------------
_______________________________________________
Users mailing list
Users(a)lists.openser.org
http://lists.openser.org/cgi-bin/mailman/listinfo/users
3 Mar
3 Mar
11:38 a.m.
On Friday 29 February 2008, Mauricio Viveros wrote:
[..]
Then I tried with Henning's instructions, I changed my current
openser.cfgfor the
openser.cfg that I donwloaded from
http://devel.openser.org/svn/branches/1.3/etc/openser.cfg and changed the
properties to work with postgres but the result was
same that when I followed the David's instructions.
so, I returned to the initial openser.cfg file and sow that the lines 154
and 155 of --usrloc params-- session were commented
then I uncommented that lines and changed mysql for pgsql, 192.168.1.3 for
192.168.1.1 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
the new lines were:
modparam("usrloc", "db_url",
"pgsql://openser:openserrw@192.168.1.1/openser")
equals that 163 and 164 of --uth_db params-- session
modparam("auth_db", "db_url",
"psql://openser:openserrw@192.168.1.1/openser")
Hi Mauricio,
the correct driver name is 'postgres', not 'psql' or 'pgsql'. The
error
message that you've got because of this problem is somewhat misleading.
http://www.openser.org/dokuwiki/doku.php/troubleshooting:faq#qerrorcorebind…
Cheers,
Henning
6114
days inactive
6119
days old
6 comments
4 participants
participants (4)
-
David Loh -
Henning Westerholt -
Iñaki Baz Castillo -
Mauricio Viveros