On 3/29/2012 10:34 AM, Miha wrote:
On 3/29/2012 10:26 AM, Razvan Crainea wrote:
Hi, Miha!

If you take a closer look at your logs, you will find this error:
"No database module found"
This means that you haven't loaded any database module (i.e. db_mysql) in your configuration script.

Regards,
--
Ra(zvan Crainea
OpenSIPS Developer
http://www.opensips-solutions.com

On 03/29/2012 11:18 AM, Miha wrote:
Hi,

I was searching in google and noticed that there was I lot of themes about this threat.

In opensipsctlrc I have this:

 $Id: opensipsctlrc 8290 2011-08-23 14:14:10Z razvancrainea $
#
# The OpenSIPS configuration file for the control tools.
#
# Here you can set variables used in the opensipsctl and opensipsdbctl setup # scripts. Per default all variables here are commented out, the control tools
# will use their internal default values.

## your SIP domain
# SIP_DOMAIN=opensips.org

## chrooted directory
# $CHROOT_DIR="/path/to/chrooted/directory"

## database type: MYSQL, PGSQL, ORACLE, DB_BERKELEY, or DBTEXT,
## by default none is loaded
# If you want to setup a database with opensipsdbctl, you must at least specify
# this parameter.
 DBENGINE=MYSQL

## database host
 DBHOST=127.0.0.1

## database name (for ORACLE this is TNS name)
 DBNAME=opensips

# database path used by dbtext or db_berkeley
# DB_PATH="/usr/local/etc/opensips/dbtext"

## database read/write user
 DBRWUSER=opensips

## password for database read/write user
 DBRWPW="opensips"

## database super user (for ORACLE this is 'scheme-creator' user)
 DBROOTUSER="root"

# user name column
 USERCOL="username"

Than I have created database with opensipsdbctl create .
After I start opensips I get this:

[root@localhost opensips]# opensipsctl start

INFO: Starting OpenSIPS :

ERROR: PID file /var/run/opensips.pid does not exist -- OpenSIPS start failed
[root@localhost opensips]#

This is my log message:

Mar 29 10:15:02 localhost opensips: INFO:core:daemonize: pre-daemon process exiting with -1 Mar 29 10:17:40 localhost opensips: WARNING:core:fix_socket_list: could not rev. resolve 172.31.1.191 Mar 29 10:17:40 localhost opensips: WARNING:core:fix_socket_list: could not rev. resolve 172.31.1.191 Mar 29 10:17:40 localhost opensips: INFO:core:init_tcp: using epoll_lt as the TCP io watch method (auto detected) Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: NOTICE:core:main: version: opensips 1.7.0-notls (x86_64/linux) Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: INFO:core:main: using 32 Mb shared memory Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: INFO:core:main: using 2 Mb private memory per process Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: NOTICE:signaling:mod_init: initializing module ... Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: INFO:sl:mod_init: Initializing StateLess engine Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: INFO:tm:mod_init: TM - initializing... Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: INFO:rr:mod_init: rr - initializing Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: INFO:maxfwd:mod_init: initializing... Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: INFO:usrloc:ul_init_locks: locks array size 512 Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: INFO:registrar:mod_init: initializing... Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: INFO:textops:mod_init: initializing... Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: ERROR:core:db_check_api: module db_mysql does not export db_use_table function Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: ERROR:uri:mod_init: No database module found Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: ERROR:core:init_mod: failed to initialize module uri Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: ERROR:core:main: error while initializing modules Mar 29 10:17:40 localhost opensips: INFO:core:daemonize: pre-daemon process exiting with -1


Thanks!

Regards,
Miha


_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Hi @Ra(zvan,

thank you for your quick replay. I noticed that but I do not know how to load mysql modul(db_mysql).

I compile it like this:
[root@opensips1~]# make all include_modules="db_mysql"
[root@opensips1~]# make include_modules="db_mysql" prefix="/usr/local" install


Thank you!

Miha


_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
@Ra(zvan,

I found it and uncomment it. Now it works:)

Regards,
Miha
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to