[OpenSIPS-Users] Trying to start opensips

Robert Thomas thomcr at gmail.com
Fri Sep 16 07:39:03 CEST 2011


The user is not authorized to the db. Looks like you haven't created the
opensips database on the mysql server. Use the opensipsdbctl utility to
initialize the database. First edit the opensipsctlrc with the settings for
your database

. At /etc/opensips/opensipsctlrc, uncomment as follows:

   1. If you want to setup a database with opensipsdbctl, you must at least
   specify
   2. this parameter.

DBENGINE=MYSQL

   1. database host

DBHOST=localhost

   1. database name (for ORACLE this is TNS name)

DBNAME=opensips

   1. database path used by dbtext or db_berkeley
   2. DB_PATH="/usr/local/etc/opensips/dbtext"
   1. database read/write user

DBRWUSER=opensips

   1. password for database read/write user

DBRWPW="password"

   1. database super user (for ORACLE this is 'scheme-creator' user)

DBROOTUSER="root"

   1. user name column

USERCOL="username"

10. Now at /etc/opensips/ you should be able to run the following command to
create a database from script: opensipsdbctl create the process is
interactive.


On Thu, Sep 15, 2011 at 11:23 PM, yasiru welandawe <modygw at yahoo.com> wrote:

>
>  Thank you Robert,
>
> I found that I wasn't add the db_mysql module. After I adding it, now
> opensips.cfg looks changed.
> But opensips still not starting. Now it gives following errors;
>
> Must be mysql connection error. I have no idea how to fix it.
>
> astboxvm:~# /etc/init.d/opensips start
> Starting opensips: opensipsListening on
>              udp: 127.0.0.1 [127.0.0.1]:5065
>              udp: 192.168.102.24 [192.168.102.24]:5065
>              tcp: 127.0.0.1 [127.0.0.1]:5065
>              tcp: 192.168.102.24 [192.168.102.24]:5065
> Aliases:
>              tcp: localhost:5065
>              udp: localhost:5065
>
>  already running.
>
> syslog:
> Sep 17 14:54:08 astboxvm opensips: WARNING:core:fix_socket_list: could not
> rev. resolve 192.168.102.24
> Sep 17 14:54:08 astboxvm opensips: WARNING:core:fix_socket_list: could not
> rev. resolve 192.168.102.24
> Sep 17 14:54:08 astboxvm opensips: INFO:core:init_tcp: using epoll_lt as
> the TCP io watch method (auto detected)
> Sep 17 14:54:08 astboxvm /usr/sbin/opensips[2166]: NOTICE:core:main:
> version: opensips 1.7.0-notls (i386/linux)
> Sep 17 14:54:08 astboxvm /usr/sbin/opensips[2166]: INFO:core:main: using 64
> Mb shared memory
> Sep 17 14:54:08 astboxvm /usr/sbin/opensips[2166]: INFO:core:main: using 2
> Mb private memory per process
> Sep 17 14:54:08 astboxvm /usr/sbin/opensips[2166]:
> NOTICE:signaling:mod_init: initializing module ...
> Sep 17 14:54:08 astboxvm /usr/sbin/opensips[2166]: INFO:sl:mod_init:
> Initializing StateLess engine
> Sep 17 14:54:08 astboxvm /usr/sbin/opensips[2166]: INFO:tm:mod_init: TM -
> initializing...
> Sep 17 14:54:08 astboxvm /usr/sbin/opensips[2166]: INFO:rr:mod_init: rr -
> initializing
> Sep 17 14:54:08 astboxvm /usr/sbin/opensips[2166]: INFO:maxfwd:mod_init:
> initializing...
> Sep 17 14:54:08 astboxvm /usr/sbin/opensips[2166]:
> INFO:usrloc:ul_init_locks: locks array size 512
> Sep 17 14:54:08 astboxvm /usr/sbin/opensips[2166]: INFO:registrar:mod_init:
> initializing...
> Sep 17 14:54:08 astboxvm /usr/sbin/opensips[2166]: INFO:textops:mod_init:
> initializing...
> Sep 17 14:54:08 astboxvm /usr/sbin/opensips[2166]:
> ERROR:db_mysql:db_mysql_connect: driver error(1045): Access denied for user
> 'opensips'@'localhost' (using password: YES)
> Sep 17 14:54:08 astboxvm /usr/sbin/opensips[2166]:
> ERROR:db_mysql:db_mysql_new_connection: initial connect failed
> Sep 17 14:54:08 astboxvm /usr/sbin/opensips[2166]: ERROR:core:db_do_init:
> could not add connection to the pool
> Sep 17 14:54:08 astboxvm /usr/sbin/opensips[2166]: ERROR:uri:mod_init:
> Could not connect to database
> Sep 17 14:54:08 astboxvm /usr/sbin/opensips[2166]: ERROR:core:init_mod:
> failed to initialize module uri
> Sep 17 14:54:08 astboxvm /usr/sbin/opensips[2166]: ERROR:core:main: error
> while initializing modules
> Sep 17 14:54:08 astboxvm opensips: INFO:core:daemonize: pre-daemon process
> exiting with -1
>
> Thank you & Regards
> Yasiru
>
>
> ------------------------------
> *From:* Robert Thomas <thomcr at gmail.com>
> *To:* yasiru welandawe <modygw at yahoo.com>; OpenSIPS users mailling list <
> users at lists.opensips.org>
> *Sent:* Friday, September 16, 2011 10:25 AM
> *Subject:* Re: [OpenSIPS-Users] Trying to start opensips
>
> Looks like your config uses a function or a  module that depends on a
> database backend and either you didnt register one, or it was not compiled
>
> On Thu, Sep 15, 2011 at 10:34 PM, yasiru welandawe <modygw at yahoo.com>wrote:
>
> Hi All,
>
> I just start to learn opensips, and i complete installing it using apt.
> When I try this "/etc/init.d/opensips start" it gives,
> astboxvm:~# /etc/init.d/opensips start
> Starting opensips: opensipsListening on
>              udp: 127.0.0.1 [127.0.0.1]:5065
>              udp: 192.168.102.24 [192.168.102.24]:5065
>              tcp: 127.0.0.1 [127.0.0.1]:5065
>              tcp: 192.168.102.24 [192.168.102.24]:5065
> Aliases:
>              tcp: localhost:5065
>              udp: localhost:5065
>
>  already running.
>
> and syslog log follows,
> Sep 17 14:15:38 astboxvm opensips: WARNING:core:fix_socket_list: could not
> rev. resolve 192.168.102.24
> Sep 17 14:15:39 astboxvm opensips: WARNING:core:fix_socket_list: could not
> rev. resolve 192.168.102.24
> Sep 17 14:15:39 astboxvm opensips: INFO:core:init_tcp: using epoll_lt as
> the TCP io watch method (auto detected)
> Sep 17 14:15:39 astboxvm /usr/sbin/opensips[2002]: NOTICE:core:main:
> version: opensips 1.7.0-notls (i386/linux)
> Sep 17 14:15:39 astboxvm /usr/sbin/opensips[2002]: INFO:core:main: using 64
> Mb shared memory
> Sep 17 14:15:39 astboxvm /usr/sbin/opensips[2002]: INFO:core:main: using 2
> Mb private memory per process
> Sep 17 14:15:39 astboxvm /usr/sbin/opensips[2002]:
> NOTICE:signaling:mod_init: initializing module ...
> Sep 17 14:15:39 astboxvm /usr/sbin/opensips[2002]: INFO:sl:mod_init:
> Initializing StateLess engine
> Sep 17 14:15:39 astboxvm /usr/sbin/opensips[2002]: INFO:tm:mod_init: TM -
> initializing...
> Sep 17 14:15:39 astboxvm /usr/sbin/opensips[2002]: INFO:rr:mod_init: rr -
> initializing
> Sep 17 14:15:39 astboxvm /usr/sbin/opensips[2002]: INFO:maxfwd:mod_init:
> initializing...
> Sep 17 14:15:39 astboxvm /usr/sbin/opensips[2002]:
> INFO:usrloc:ul_init_locks: locks array size 512
> Sep 17 14:15:39 astboxvm /usr/sbin/opensips[2002]: INFO:registrar:mod_init:
> initializing...
> Sep 17 14:15:39 astboxvm /usr/sbin/opensips[2002]: INFO:textops:mod_init:
> initializing...
> Sep 17 14:15:39 astboxvm /usr/sbin/opensips[2002]: ERROR:core:db_check_api:
> module db_mysql does not export db_use_table function
> Sep 17 14:15:39 astboxvm /usr/sbin/opensips[2002]: ERROR:uri:mod_init: No
> database module found
> Sep 17 14:15:39 astboxvm /usr/sbin/opensips[2002]: ERROR:core:init_mod:
> failed to initialize module uri
> Sep 17 14:15:39 astboxvm /usr/sbin/opensips[2002]: ERROR:core:main: error
> while initializing modules
> Sep 17 14:15:39 astboxvm opensips: INFO:core:daemonize: pre-daemon process
> exiting with -1
>
> Can anyone help me.
>
> Thank you & regards
> Yasiru
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
>
> --
> Robert
>
>
>


-- 
Robert
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110915/3347b547/attachment.htm>


More information about the Users mailing list