Probably your mysql server is not running.
Jan.
On 11-11 20:11, Trung Nguyen wrote:
Hi Marian, Thank you for your fast prompt. Ok I enabled that and I don't see that error, but I still can't connected to the remote mysql.
-----------2(19342) 1(19341)
rtpp_test: RTP proxy found, support for it enabled 2(19342) DEBUG: init_mod_child (-2): domain 2(19342) DEBUG: init_mod_child (-2): group 2(19342) connect_db(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 2(19342) db_init(): Error while trying to connect database 2(19342) group:init_child(): Unable to connect database 2(19342) init_mod_child(): Error while initializing module group 2(19342) ERROR: open_uac_fifo: init_child failed 2(19342) opening fifo server failed 2(19342) INFO: signal 15 received 2(19342) Memory status (pkg): 2(19342) fm_status (0x80c2b20): 2(19342) heap size= 1047440 2(19342) dumping free list: 2(19342) hash = 1 fragments no.: 7, bucket size: 8 - 8 (first 8) 2(19342) hash = 2 fragments no.: 2, bucket size: 16 - 16 (first 16) 2(19342) hash = 3 fragments no.: 3, bucket size: 24 - 24 (first 24) 2(19342) hash = 5 fragments no.: 1, bucket size: 40 - 40 (first 40) 2(19342) hash = 113 fragments no.: 1, bucket size: 904 - 904 (first 904) 2(19342) hash = 119 fragments no.: 1, bucket size: 952 - 952 (first 952) 2(19342) hash = 265 fragments no.: 1, bucket size: 524288 - 1048576 (first 1031944) 2(19342) TOTAL: 16 free fragments = 1034000 free bytes 2(19342) ----------------------------- 2(19342) INFO: SIGCHLD received: we do not worry about grand-children 2(19342) INFO: SIGCHLD received: we do not worry about grand-children 2(19342) INFO: signal 2 received 2(19342) Memory status (pkg): 2(19342) fm_status (0x80c2b20): 2(19342) heap size= 1047440 2(19342) dumping free list: 2(19342) hash = 1 fragments no.: 6, bucket size: 8 - 8 (first 8) 2(19342) hash = 2 fragments no.: 2, bucket size: 16 - 16 (first 16) 2(19342) hash = 3 fragments no.: 4, bucket size: 24 - 24 (first 24) 2(19342) hash = 265 fragments no.: 1, bucket size: 524288 - 1048576 (first 1034824) 2(19342) TOTAL: 13 free fragments = 1035000 free bytes 2(19342) ----------------------------- [root@NSIP1 lib]#
But when I try to do the command, the connection is fine. Is there anything I need to do or am I missing something.
[root@NSIP1 lib]# mysql -h 172.16.10.10 -u ser -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 37 to server version: 4.1.7-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
Thanks, Trung --- Marian Dumitru marian.dumitru@voice-sistem.ro wrote:
Hi Trung,
your mysql server exceeds the maximum number of connections. To fix this just modify in /etc/mysql.my.cnf in [mysqld] section: set-variable = max_connections=200
Best regards, Marian
Trung Nguyen wrote:
Hi there, I have been looking into the forum for help on
this
issue, but I can't find it. This is the error I
got:
1(0) DEBUG: callid: '77eaadff-0@172.16.10.11' 1(0) DEBUG: init_mod_child (-1): usrloc 1(17163) DBG: open_uac_fifo: opening fifo... 1(17163) DEBUG: FIFO created @ /tmp/ser_fifo 1(17163) DEBUG: fifo /tmp/ser_fifo opened,
mode=432
2(0) INFO: fifo process starting: 17164 2(0) DEBUG: init_mod_child (-2): tm 2(0) DEBUG: callid: '77eaadff-0@172.16.10.11' 2(0) DEBUG: init_mod_child (-2): usrloc 1(17163) DEBUG: init_mod_child (-1): acc 2(17164) DEBUG: init_mod_child (-2): acc 1(17163) DEBUG: init_mod_child (-1): nathelper 1(17163) rtpp_test: RTP proxy found, support for
it
enabled 1(17163) DEBUG: init_mod_child (-1): domain 1(17163) DEBUG: init_mod_child (-1): group 1(17163) connect_db(): Can't connect to local
MySQL
server through socket '/tmp/mysql.sock' (2) 1(17163) db_init(): Error while trying to connect database 1(17163) group:init_child(): Unable to connect database 1(17163) init_mod_child(): Error while
initializing
module group 2(17164) 1(17163) connect_db(): Too many
connections
timer: init_child failed 2(17164) db_init(): Error while trying to connect database 2(17164) acc:init_child(): Unable to connect
database
2(17164) init_mod_child(): Error while
initializing
module acc 1(17163) 2(17164) INFO: signal 15 received ERROR: open_uac_fifo: init_child failed 1(17163) 2(17164) Memory status (pkg): opening fifo server failed 1(17163) fm_status (0x80c2b20): 1(17163) heap size= 1047440 1(17163) dumping free list: 1(17163) hash = 1 fragments no.: 7,
Here's my ser.cfg
# $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15
andrei
Exp $ # # simple quick-start config script #
# ----------- global configuration parameters
debug=7 # debug level (cmd line:
-dddddddddd)
#fork=yes log_stderror=yes # (cmd line: -E)
/* Uncomment these lines to enter debugging mode debug=7 fork=no log_stderror=yes */ listen=172.16.10.11
check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R) #port=5060 #children=4 fifo="/tmp/ser_fifo"
# ------------------ module loading
# Uncomment this if you want to use SQL database loadmodule "/usr/local/lib/ser/modules/mysql.so"
loadmodule "/usr/local/lib/ser/modules/sl.so" loadmodule "/usr/local/lib/ser/modules/tm.so" loadmodule "/usr/local/lib/ser/modules/rr.so" loadmodule "/usr/local/lib/ser/modules/maxfwd.so" loadmodule "/usr/local/lib/ser/modules/usrloc.so" loadmodule "/usr/local/lib/ser/modules/acc.so" loadmodule
"/usr/local/lib/ser/modules/registrar.so"
loadmodule
"/usr/local/lib/ser/modules/nathelper.so"
loadmodule "/usr/local/lib/ser/modules/domain.so" loadmodule "/usr/local/lib/ser/modules/textops.so" loadmodule "/usr/local/lib/ser/modules/group.so"
# Uncomment this if you want digest authentication # mysql.so must be loaded ! loadmodule "/usr/local/lib/ser/modules/auth.so" loadmodule "/usr/local/lib/ser/modules/auth_db.so"
# ----------------- setting module-specific
parameters
# -- usrloc params --
#modparam("usrloc", "db_mode", 0)
# Uncomment this if you want to use SQL database # for persistent storage and comment the previous
line
modparam("usrloc", "db_mode", 2) modparam("usrloc", "db_url", "mysql://ser:heslo@172.16.10.10/ser")
# -- auth params -- # Uncomment if you are using auth module # modparam("auth_db", "calculate_ha1", yes) # # If you set "calculate_ha1" parameter to yes
(which
true in this config), # uncomment also the following parameter) # modparam("auth_db", "password_column", "password") modparam("auth_db", "db_url", "mysql://ser:heslo@172.16.10.10/ser") #modparam("auth_db", "use_rpid", 1) #modparam("auth", "rpid_prefix", "<sip:") #modparam("auth", "rpid_suffix",
"@unlimitedtalk.net>;party=calling;privacy=full;screen=yes")
# --acc params-- modparam("acc", "log_level", 1) modparam("acc", "log_flag", 1) modparam("acc", "log_missed_flag", 2) modparam("acc", "log_fmt", "fimos") modparam("acc", "db_url", "mysql://ser:heslo@172.16.10.10/ser") modparam("acc", "db_missed_flag", 2) modparam("acc", "db_flag", 1) # -- rr params -- # add value to ;lr param to make some broken UAs
happy
modparam("rr", "enable_full_lr", 1)
# !! Nathelper modparam("registrar", "nat_flag", 6) modparam("nathelper", "natping_interval", 30) #
Ping
interval 30 s modparam("nathelper", "ping_nated_only", 1) #
Ping
only clients behind NAT
Any help or guidance will be very appreciated.
Thank you, Trung
__________________________________ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
=== message truncated ===
__________________________________ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers