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