[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>: