[OpenSIPS-Users] opensips presence module init error

[Alex Balashov]

Are you able to connect to your MySQL instance at TCP port 3306, via, 
say, telnet?

Manivasagam Sivaraman wrote:

> 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.
>  
> 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.
>  
> ERROR:db_mysql:db_mysql_new_connection: driver error: Lost connection to 
> MySQL server at 'reading initial communication packet', system error: 111
> Here is the full log during start up
> ---------------------------------------------------
>  
> presence:/usr/local/etc/opensips# opensips -dddd
> Listening on
>              udp: 172.16.1.182 <http://172.16.1.182> [172.16.1.182 
> <http://172.16.1.182>]:5060
> Aliases:
>              udp: presence.smithmicro.com:5060 
> <http://presence.smithmicro.com:5060>
> Aug 20 10:52:26 [2995] INFO:core:init_tcp: using epoll_lt as the TCP io 
> watch method (auto detected)
> Aug 20 10:52:26 [2997] NOTICE:core:main: version: opensips 1.4.1-notls 
> (i386/linux)
> Aug 20 10:52:26 [2997] INFO:core:main: using 32 Mb shared memory
> Aug 20 10:52:26 [2997] INFO:core:main: using 1 Mb private memory per process
> Aug 20 10:52:26 [2997] INFO:sl:mod_init: Initializing StateLess engine
> Aug 20 10:52:26 [2997] INFO:tm:mod_init: TM - initializing...
> presence:/usr/local/etc/opensips# Aug 20 10:52:26 [2997] 
> INFO:maxfwd:mod_init: initializing...
> Aug 20 10:52:26 [2997] INFO:usrloc:ul_init_locks: locks array size 512
> Aug 20 10:52:26 [2997] INFO:registrar:mod_init: initializing...
> Aug 20 10:52:26 [2997] INFO:textops:mod_init: initializing...
> Aug 20 10:52:26 [2997] INFO:xlog:mod_init: initializing...
> Aug 20 10:52:26 [2997] INFO:acc:mod_init: initializing...
> Aug 20 10:52:26 [2997] INFO:auth:mod_init: initializing...
> Aug 20 10:52:26 [2997] INFO:auth_db:mod_init: initializing...
> Aug 20 10:52:26 [2997] NOTICE:presence:mod_init: initializing module ...
> 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
> 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
> Aug 20 10:52:26 [2997] ERROR:core:init_mod: failed to initialize module 
> presence
> Aug 20 10:52:26 [2997] ERROR:core:main: error while initializing modules
> Aug 20 10:52:26 [2997] NOTICE:presence:destroy: destroy module ...
>  
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users


-- 
Alex Balashov
Evariste Systems
Web    : http://www.evaristesys.com/
Tel    : (+1) (678) 954-0670
Direct : (+1) (678) 954-0671
Mobile : (+1) (706) 338-8599