<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    On 3/29/2012 10: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&#259;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>&nbsp;$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>
            &nbsp;DBENGINE=MYSQL<br>
            <br>
            ## database host<br>
            &nbsp;DBHOST=127.0.0.1<br>
            <br>
            ## database name (for ORACLE this is TNS name)<br>
            &nbsp;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>
            &nbsp;DBRWUSER=opensips<br>
            <br>
            ## password for database read/write user<br>
            &nbsp;DBRWPW="opensips"<br>
            <br>
            ## database super user (for ORACLE this is 'scheme-creator'
            user)<br>
            &nbsp;DBROOTUSER="root"<br>
            <br>
            # user name column<br>
            &nbsp;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&#259;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>
    @R&#259;zvan,<br>
    <br>
    I found it and uncomment it. Now it works:)<br>
    <br>
    Regards,<br>
    Miha<br>
  </body>
</html>