[OpenSIPS-Users] Trying to start opensips

yasiru welandawe modygw at yahoo.com
Fri Sep 16 08:24:21 CEST 2011


Thank a lot Robert,

That was awesome! It worked perfectly. Now opensips is up and running.
Now um free to study opensips, Thanks to you :)
 
Regards
Yasiru


________________________________
From: Robert Thomas <thomcr at gmail.com>
To: yasiru welandawe <modygw at yahoo.com>
Cc: OpenSIPS users mailling list <users at lists.opensips.org>
Sent: Friday, September 16, 2011 11:09 AM
Subject: Re: [OpenSIPS-Users] Trying to start opensips


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/4fe96ac7/attachment.htm>


More information about the Users mailing list