13 mar 2013 kl. 17:13 skrev Hoai-Anh Ngo-Vi <hngovi.h...@googlemail.com>:
> Dears, > > I have tried out Kamailio 3.3.4 with PostgreSQL as persistence but it does > not work. > > make FLAVOUR=kamailio include_modules="db_postgres" cfg > > was OK. I found /usr/local/lib/kamailio/modules/db_postgres.so after > installation. > > I have successfully set up database openser using /usr/local/sbin/kamdbctl > create with DBENGINE=PGSQL in /usr/local/etc/kamailio/kamctlrc. > > I have edited /usr/local/etc/kamailio/kamailio.cfg with: > > #!define WITH_PGSQL > #!define WITH_AUTH > #!define WITH_USRLOCDB > ... > > #!ifdef WITH_PGSQL > #!define DBURL "postgres://openser/openserrw@localhost:5432/openser" > #!endif > ... > #!ifdef WITH_PGSQL > loadmodule "db_postgres.so" > #!endif > > Run /etc/init.d/kamailio start|debug I got > Listening on > .... > > kamailio error, failed to start. > > Does someone know some hints or have a working example? > > When I comment out the first 3 define kamailio starts fine. Here's a few things you can do - Check the log files. Kamailio logs to syslog, so it can be /var/log/messages or /var/log/syslog or something else. - Run kamailio with "-c" to check your configuration files before you start. Now some database problems are not syntax errors, but connections issues (authorization). Those will only be seen when you actually start kamailio. - Check the debug option in kamailio to raise the level. It helps with database issues - Turn on logging to stderr in the core configuration file to get logging to your console for debugging. Good luck hunting! /O _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
