<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi, Miha!<br>
<br>
You should add the module in your configuration file (I think you
can find it in /usr/local/etc/opensips/opensips.cfg), in the
modules section. You should add this line, preferably before any
other loadmodule:<br>
loadmodule "db_mysql.so"<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">--
Răzvan Crainea
OpenSIPS Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<br>
On 03/29/2012 11:34 AM, Miha wrote:
<blockquote cite="mid:4F741E86.1000301@softnet.si" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
On 3/29/2012 10:26 AM, Razvan Crainea wrote:
<blockquote cite="mid:4F741C98.40507@opensips.org" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<tt>Hi, Miha!<br>
<br>
If you take a closer look at your logs, you will find this
error:<br>
"No database module found"<br>
This means that you haven't loaded any database module (i.e.
db_mysql) in your configuration script.<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">--
Răzvan Crainea
OpenSIPS Developer
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<br>
On 03/29/2012 11:18 AM, Miha wrote:
<blockquote cite="mid:4F741ADB.5050402@softnet.si" type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
Hi,<br>
<br>
I was searching in google and noticed that there was I lot of
themes about this threat.<br>
<br>
In opensipsctlrc I have this:<br>
<br>
<small> $Id: opensipsctlrc 8290 2011-08-23 14:14:10Z
razvancrainea $<br>
#<br>
# The OpenSIPS configuration file for the control tools.<br>
#<br>
# Here you can set variables used in the opensipsctl and
opensipsdbctl setup<br>
# scripts. Per default all variables here are commented out,
the control tools<br>
# will use their internal default values.<br>
<br>
## your SIP domain<br>
# SIP_DOMAIN=opensips.org<br>
<br>
## chrooted directory<br>
# $CHROOT_DIR="/path/to/chrooted/directory"<br>
<br>
## database type: MYSQL, PGSQL, ORACLE, DB_BERKELEY, or
DBTEXT,<br>
## by default none is loaded<br>
# If you want to setup a database with opensipsdbctl, you
must at least specify<br>
# this parameter.<br>
DBENGINE=MYSQL<br>
<br>
## database host<br>
DBHOST=127.0.0.1<br>
<br>
## database name (for ORACLE this is TNS name)<br>
DBNAME=opensips<br>
<br>
# database path used by dbtext or db_berkeley<br>
# DB_PATH="/usr/local/etc/opensips/dbtext"<br>
<br>
## database read/write user<br>
DBRWUSER=opensips<br>
<br>
## password for database read/write user<br>
DBRWPW="opensips"<br>
<br>
## database super user (for ORACLE this is 'scheme-creator'
user)<br>
DBROOTUSER="root"<br>
<br>
# user name column<br>
USERCOL="username"</small><br>
<br>
Than I have created database with opensipsdbctl create .<br>
After I start opensips I get this:<br>
<br>
<small>[root@localhost opensips]# opensipsctl start<br>
<br>
<small>INFO: Starting OpenSIPS : <br>
<br>
ERROR: PID file /var/run/opensips.pid does not exist --
OpenSIPS start failed<br>
[root@localhost opensips]# </small><br>
<br>
This is my log message:<br>
<br>
Mar 29 10:15:02 localhost opensips: <a
moz-do-not-send="true" class="moz-txt-link-freetext"
href="INFO:core:daemonize">INFO:core:daemonize</a>:
pre-daemon process exiting with -1<br>
Mar 29 10:17:40 localhost opensips:
WARNING:core:fix_socket_list: could not rev. resolve
172.31.1.191<br>
Mar 29 10:17:40 localhost opensips:
WARNING:core:fix_socket_list: could not rev. resolve
172.31.1.191<br>
Mar 29 10:17:40 localhost opensips: <a
moz-do-not-send="true" class="moz-txt-link-freetext"
href="INFO:core:init_tcp">INFO:core:init_tcp</a>: using
epoll_lt as the TCP io watch method (auto detected)<br>
Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]:
NOTICE:core:main: version: opensips 1.7.0-notls
(x86_64/linux)<br>
Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: <a
moz-do-not-send="true" class="moz-txt-link-freetext"
href="INFO:core:main">INFO:core:main</a>: using 32 Mb
shared memory<br>
Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: <a
moz-do-not-send="true" class="moz-txt-link-freetext"
href="INFO:core:main">INFO:core:main</a>: using 2 Mb
private memory per process<br>
Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]:
NOTICE:signaling:mod_init: initializing module ...<br>
Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: <a
moz-do-not-send="true" class="moz-txt-link-freetext"
href="INFO:sl:mod_init">INFO:sl:mod_init</a>: Initializing
StateLess engine<br>
Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: <a
moz-do-not-send="true" class="moz-txt-link-freetext"
href="INFO:tm:mod_init">INFO:tm:mod_init</a>: TM -
initializing...<br>
Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: <a
moz-do-not-send="true" class="moz-txt-link-freetext"
href="INFO:rr:mod_init">INFO:rr:mod_init</a>: rr -
initializing<br>
Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: <a
moz-do-not-send="true" class="moz-txt-link-freetext"
href="INFO:maxfwd:mod_init">INFO:maxfwd:mod_init</a>:
initializing...<br>
Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: <a
moz-do-not-send="true" class="moz-txt-link-freetext"
href="INFO:usrloc:ul_init_locks">INFO:usrloc:ul_init_locks</a>:
locks array size 512<br>
Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: <a
moz-do-not-send="true" class="moz-txt-link-freetext"
href="INFO:registrar:mod_init">INFO:registrar:mod_init</a>:
initializing...<br>
Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: <a
moz-do-not-send="true" class="moz-txt-link-freetext"
href="INFO:textops:mod_init">INFO:textops:mod_init</a>:
initializing...<br>
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<br>
Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]:
ERROR:uri:mod_init: No database module found<br>
Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]:
ERROR:core:init_mod: failed to initialize module uri<br>
Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]:
ERROR:core:main: error while initializing modules<br>
Mar 29 10:17:40 localhost opensips: <a
moz-do-not-send="true" class="moz-txt-link-freetext"
href="INFO:core:daemonize">INFO:core:daemonize</a>:
pre-daemon process exiting with -1</small><br>
<br>
<br>
Thanks!<br>
<br>
Regards,<br>
Miha<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
Hi @Răzvan,<br>
<br>
thank you for your quick replay. I noticed that but I do not know
how to load mysql modul(<tt>db_mysql</tt>).<br>
<br>
I compile it like this:<br>
<pre>[root@opensips1~]# make all include_modules="db_mysql"
[root@opensips1~]# make include_modules="db_mysql" prefix="/usr/local" install</pre>
<br>
<br>
Thank you!<br>
<br>
Miha<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</body>
</html>