<div dir="ltr"><div>I' new to opensips. I installed opensips with mysql support since I want to use presence with mysql. I'm getting following error when I start. I did have mysql server installed and created db and tables required for presence to work. I have all the user name password required for opensips user to access mysql in opensipsctlrc script. I could not proceed furthur.. please help me understand the follwoing error.</div>
<div> </div>
<div>Basically the presence module init failed since it is not able to communicate witht he my sql databse. My mysql db is running, I ahve all required username, password, table etc created.</div>
<div> </div>
<div>ERROR:db_mysql:db_mysql_new_connection: driver error: Lost connection to MySQL server at 'reading initial communication packet', system error: 111<br></div>
<div>Here is the full log during start up</div>
<div>---------------------------------------------------</div>
<div> </div>
<div>presence:/usr/local/etc/opensips# opensips -dddd<br>Listening on<br> udp: <a href="http://172.16.1.182">172.16.1.182</a> [<a href="http://172.16.1.182">172.16.1.182</a>]:5060<br>Aliases:<br> udp: <a href="http://presence.smithmicro.com:5060">presence.smithmicro.com:5060</a></div>
<div>Aug 20 10:52:26 [2995] INFO:core:init_tcp: using epoll_lt as the TCP io watch method (auto detected)<br>Aug 20 10:52:26 [2997] NOTICE:core:main: version: opensips 1.4.1-notls (i386/linux)<br>Aug 20 10:52:26 [2997] INFO:core:main: using 32 Mb shared memory<br>
Aug 20 10:52:26 [2997] INFO:core:main: using 1 Mb private memory per process<br>Aug 20 10:52:26 [2997] INFO:sl:mod_init: Initializing StateLess engine<br>Aug 20 10:52:26 [2997] INFO:tm:mod_init: TM - initializing...<br>presence:/usr/local/etc/opensips# Aug 20 10:52:26 [2997] INFO:maxfwd:mod_init: initializing...<br>
Aug 20 10:52:26 [2997] INFO:usrloc:ul_init_locks: locks array size 512<br>Aug 20 10:52:26 [2997] INFO:registrar:mod_init: initializing...<br>Aug 20 10:52:26 [2997] INFO:textops:mod_init: initializing...<br>Aug 20 10:52:26 [2997] INFO:xlog:mod_init: initializing...<br>
Aug 20 10:52:26 [2997] INFO:acc:mod_init: initializing...<br>Aug 20 10:52:26 [2997] INFO:auth:mod_init: initializing...<br>Aug 20 10:52:26 [2997] INFO:auth_db:mod_init: initializing...<br>Aug 20 10:52:26 [2997] NOTICE:presence:mod_init: initializing module ...<br>
Aug 20 10:52:26 [2997] ERROR:db_mysql:db_mysql_new_connection: driver error: Lost connection to MySQL server at 'reading initial communication packet', system error: 111<br>Aug 20 10:52:26 [2997] ERROR:core:db_do_init: could not add connection to the poolAug 20 10:52:26 [2997] ERROR:presence:mod_init: connecting to database failed<br>
Aug 20 10:52:26 [2997] ERROR:core:init_mod: failed to initialize module presence<br>Aug 20 10:52:26 [2997] ERROR:core:main: error while initializing modules<br>Aug 20 10:52:26 [2997] NOTICE:presence:destroy: destroy module ...</div>
<div> </div></div>