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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
