Trying to start opensips

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Trying to start opensips

yasiru welandawe
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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Trying to start opensips

thomcr
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 <[hidden email]> 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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users




--
Robert

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Trying to start opensips

yasiru welandawe

 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 <[hidden email]>
To: yasiru welandawe <[hidden email]>; OpenSIPS users mailling list <[hidden email]>
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 <[hidden email]> 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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users




--
Robert



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Trying to start opensips

thomcr
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 <[hidden email]> 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 <[hidden email]>
To: yasiru welandawe <[hidden email]>; OpenSIPS users mailling list <[hidden email]>
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 <[hidden email]> 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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users




--
Robert





--
Robert

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Trying to start opensips

yasiru welandawe
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 <[hidden email]>
To: yasiru welandawe <[hidden email]>
Cc: OpenSIPS users mailling list <[hidden email]>
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 <[hidden email]> 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 <[hidden email]>
To: yasiru welandawe <[hidden email]>; OpenSIPS users mailling list <[hidden email]>
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 <[hidden email]> 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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users




--
Robert





--
Robert



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Trying to start opensips

thomcr
Yasiru,

All right!, Good you got it working, glad to help.  Welcome to the opensips community.

On Fri, Sep 16, 2011 at 12:24 AM, yasiru welandawe <[hidden email]> wrote:
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 <[hidden email]>
To: yasiru welandawe <[hidden email]>
Cc: OpenSIPS users mailling list <[hidden email]>
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 <[hidden email]> 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 <[hidden email]>
To: yasiru welandawe <[hidden email]>; OpenSIPS users mailling list <[hidden email]>
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 <[hidden email]> 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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users




--
Robert





--
Robert





--
Robert

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