[OpenSIPS-Users] Trying to start opensips
Robert Thomas
thomcr at gmail.com
Fri Sep 16 08:40:26 CEST 2011
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 <modygw at yahoo.com> 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 <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
>
>
>
--
Robert
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110916/08b2d51e/attachment-0001.htm>
More information about the Users
mailing list