[OpenSIPS-Users] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock

[Vlad Paiu]

Hello,

Your OpenSIPS does not start at all, because it can't connect to the 
MySQL server.
Is the MySQL server running on localhost ?

Regards.

Vlad Paiu
OpenSIPS Developer


On 12/02/2011 10:43 PM, M.Abdulaziz wrote:
> Hello All,
>
> I was trying to configure opensips as a registerar but when uac clients
> sends the registration requests I got no reaction from opensips&  I got
> these error messages:
>
>
> Dec  2 22:29:16 [13681] DBG:db_mysql:db_mysql_connect: opening connection:
> mysql://xxxx:xxxx@localhost/opensips
> Dec  2 22:29:16 [13681] ERROR:db_mysql:db_mysql_connect: driver error(2002):
> Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
> Dec  2 22:29:16 [13681] ERROR:db_mysql:db_mysql_new_connection: initial
> connect failed
> Dec  2 22:29:16 [13681] ERROR:core:db_do_init: could not add connection to
> the pool
> Dec  2 22:29:16 [13681] ERROR:usrloc:register_udomain: failed to open
> database connection
> Dec  2 22:29:16 [13681] ERROR:registrar:domain_fixup: failed to register
> domain
> Dec  2 22:29:16 [13681] ERROR:core:fix_actions: fixing failed (code=-1) at
> cfg line 67
> Dec  2 22:29:16 [13681] ERROR:core:main: failed to fix configuration with
> err code -1
> Dec  2 22:29:16 [13681] DBG:core:shm_mem_destroy:
> Dec  2 22:29:16 [13681] DBG:core:shm_mem_destroy: destroying the shared
> memory lock
> Dec  2 22:29:16 [13679] DBG:core:wait_status_code: read code 111 ? rc = 0,
> errno=Success
> Dec  2 22:29:16 [13679] INFO:core:daemonize: pre-daemon process exiting with
> -1
>
>
> ********************************************* Here is my opensips.cfg file*
>
>
> # ----------- global configuration parameters ------------------------
>
> debug=6           # debug level (cmd line: -dddddddddd)
> fork=yes
> log_stderror=yes   # (cmd line: -E)
> children=8
>
>
>
> listen=udp:192.168.1.69:5060
> auto_aliases=no
>
> log_name="OPENSIPS-71"
> log_facility=LOG_LOCAL0
>
> # ------------------ module loading ----------------------------------
>
> #set module path
> mpath="/usr/local/lib64/opensips/modules/"
>
> # Uncomment this if you want to use SQL database
>
> loadmodule "db_mysql.so"
> loadmodule "sl.so"
> loadmodule "usrloc.so"
> loadmodule "registrar.so"
> loadmodule "textops.so"
> loadmodule "signaling.so"
> #loadmodule "mi_fifo"
>
> # ----------------- setting module-specific parameters ---------------
>
>
> # -- usrloc params --
>
>
> modparam("usrloc", "db_mode",   2)
> modparam("usrloc",
> "db_url","mysql://opensips:opensipsrw@localhost/opensips")
>
>
> # -------------------------  request routing logic -------------------
>
> # main routing logic
>
> route{
> 	
> 	if(is_method("REGISTER"))
> 	{
> 		#set_time_stamp("before new ul save");
> 		save("location");
> 		#diff_time_stamp(1,"after ul save");
> 		exit;
> 	}
>
> 	#set_time_stamp("before new ul lookup");
> 	if(lookup("location"))
> 	{
> 		#diff_time_stamp(1,"after ul lookup");
> 		sl_send_reply("200", "ok");
> 	} else {
> 		#diff_time_stamp(1,"after ul lookup");
> 		sl_send_reply("404", "not found");
> 	}
>
> }
>
>
>
> *could someone plz tell me where is mistake?*
>
> Thank you,
>
>
>
>
> --
> View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/Can-t-connect-to-local-MySQL-server-through-socket-var-lib-mysql-mysql-sock-tp7056051p7056051.html
> Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users