[OpenSIPS-Users] opensips.pid does not exist -- OpenSIPS start failed

Thu Mar 29 10:40:08 CEST 2012

Hi, Miha!

You should add the module in your configuration file (I think you can 
find it in /usr/local/etc/opensips/opensips.cfg), in the modules 
section. You should add this line, preferably before any other loadmodule:
loadmodule "db_mysql.so"

Regards,

--
Ra(zvan Crainea
OpenSIPS Developer
http://www.opensips-solutions.com

On 03/29/2012 11:34 AM, Miha wrote:
> On 3/29/2012 10:26 AM, Razvan Crainea wrote:
>> Hi, Miha!
>>
>> If you take a closer look at your logs, you will find this error:
>> "No database module found"
>> This means that you haven't loaded any database module (i.e. 
>> db_mysql) in your configuration script.
>>
>> Regards,
>> --
>> Ra(zvan Crainea
>> OpenSIPS Developer
>> http://www.opensips-solutions.com
>>
>> On 03/29/2012 11:18 AM, Miha wrote:
>>> Hi,
>>>
>>> I was searching in google and noticed that there was I lot of themes 
>>> about this threat.
>>>
>>> In opensipsctlrc I have this:
>>>
>>>  $Id: opensipsctlrc 8290 2011-08-23 14:14:10Z razvancrainea $
>>> #
>>> # The OpenSIPS configuration file for the control tools.
>>> #
>>> # Here you can set variables used in the opensipsctl and 
>>> opensipsdbctl setup
>>> # scripts. Per default all variables here are commented out, the 
>>> control tools
>>> # will use their internal default values.
>>>
>>> ## your SIP domain
>>> # SIP_DOMAIN=opensips.org
>>>
>>> ## chrooted directory
>>> # $CHROOT_DIR="/path/to/chrooted/directory"
>>>
>>> ## database type: MYSQL, PGSQL, ORACLE, DB_BERKELEY, or DBTEXT,
>>> ## by default none is loaded
>>> # If you want to setup a database with opensipsdbctl, you must at 
>>> least specify
>>> # this parameter.
>>>  DBENGINE=MYSQL
>>>
>>> ## database host
>>>  DBHOST=127.0.0.1
>>>
>>> ## database name (for ORACLE this is TNS name)
>>>  DBNAME=opensips
>>>
>>> # database path used by dbtext or db_berkeley
>>> # DB_PATH="/usr/local/etc/opensips/dbtext"
>>>
>>> ## database read/write user
>>>  DBRWUSER=opensips
>>>
>>> ## password for database read/write user
>>>  DBRWPW="opensips"
>>>
>>> ## database super user (for ORACLE this is 'scheme-creator' user)
>>>  DBROOTUSER="root"
>>>
>>> # user name column
>>>  USERCOL="username"
>>>
>>> Than I have created database with opensipsdbctl create .
>>> After I start opensips I get this:
>>>
>>> [root at localhost opensips]# opensipsctl start
>>>
>>> INFO: Starting OpenSIPS :
>>>
>>> ERROR: PID file /var/run/opensips.pid does not exist -- OpenSIPS 
>>> start failed
>>> [root at localhost opensips]#
>>>
>>> This is my log message:
>>>
>>> Mar 29 10:15:02 localhost opensips: INFO:core:daemonize: pre-daemon 
>>> process exiting with -1
>>> Mar 29 10:17:40 localhost opensips: WARNING:core:fix_socket_list: 
>>> could not rev. resolve 172.31.1.191
>>> Mar 29 10:17:40 localhost opensips: WARNING:core:fix_socket_list: 
>>> could not rev. resolve 172.31.1.191
>>> Mar 29 10:17:40 localhost opensips: INFO:core:init_tcp: using 
>>> epoll_lt as the TCP io watch method (auto detected)
>>> Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: 
>>> NOTICE:core:main: version: opensips 1.7.0-notls (x86_64/linux)
>>> Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: 
>>> INFO:core:main: using 32 Mb shared memory
>>> Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: 
>>> INFO:core:main: using 2 Mb private memory per process
>>> Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: 
>>> NOTICE:signaling:mod_init: initializing module ...
>>> Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: 
>>> INFO:sl:mod_init: Initializing StateLess engine
>>> Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: 
>>> INFO:tm:mod_init: TM - initializing...
>>> Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: 
>>> INFO:rr:mod_init: rr - initializing
>>> Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: 
>>> INFO:maxfwd:mod_init: initializing...
>>> Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: 
>>> INFO:usrloc:ul_init_locks: locks array size 512
>>> Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: 
>>> INFO:registrar:mod_init: initializing...
>>> Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: 
>>> INFO:textops:mod_init: initializing...
>>> Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: 
>>> ERROR:core:db_check_api: module db_mysql does not export 
>>> db_use_table function
>>> Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: 
>>> ERROR:uri:mod_init: No database module found
>>> Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: 
>>> ERROR:core:init_mod: failed to initialize module uri
>>> Mar 29 10:17:40 localhost /usr/local/sbin/opensips[25216]: 
>>> ERROR:core:main: error while initializing modules
>>> Mar 29 10:17:40 localhost opensips: INFO:core:daemonize: pre-daemon 
>>> process exiting with -1
>>>
>>>
>>> Thanks!
>>>
>>> Regards,
>>> Miha
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> Hi @Ra(zvan,
>
> thank you for your quick replay. I noticed that but I do not know how 
> to load mysql modul(db_mysql).
>
> I compile it like this:
> [root at opensips1~]# make all include_modules="db_mysql"
> [root at opensips1~]# make include_modules="db_mysql" prefix="/usr/local" install
>
>
> Thank you!
>
> Miha
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20120329/c0e5ea04/attachment.htm>