4 Jul
2005
4 Jul
'05
11:49 p.m.
HI:
All modules need DB must be set:
modparam("acc|auth_db|domain|group|permissions|speeddial|uri_db|usrloc|xdz_t
ools", "db_url",
"mysql://ser:heslo@your_db_ip/ser")
Please confirm you can connect to your DB on SER1(2) first, this should do
set on your database.
By the way, if both your ser access same location table, all data will lose
when your ser restarted.
It's will cause UAs which register on another ser always offline if you
don't restart those UA.
Nilus
----- Original Message -----
From: "harry gaillac" <gaillacharry(a)yahoo.fr>
To: <serusers(a)lists.iptel.org>
Cc: <sems(a)lists.iptel.org>
Sent: Monday, July 04, 2005 11:58 PM
Subject: [Serusers] sharing a db server with two SER
Hello,
I want to use a dedicated ser+sems dedicated server
SER1---DB---SER2+SEMS
When i start SER2 I get :
serveur2:/etc/ser# tail /var/log/syslog
Jan 1 03:50:06 serveur2 /usr/sbin/ser[1086]: Maxfwd
module- initializing
Jan 1 03:50:06 serveur2 /usr/sbin/ser[1086]:
new_connection(): Can't connect to local MySQL server
through socket '/var/run/mysqld/mysqld.sock' (2)
Jan 1 03:50:06 serveur2 /usr/sbin/ser[1086]:
db_init(): Could not create a connection
Jan 1 03:50:06 serveur2 /usr/sbin/ser[1086]:
register_udomain(): Can not open database connection
Jan 1 03:50:06 serveur2 /usr/sbin/ser[1086]:
domain_fixup(): Error while registering domain
Jan 1 03:53:36 serveur2 /usr/sbin/ser[1094]: Maxfwd
module- initializing
Jan 1 03:53:36 serveur2 /usr/sbin/ser[1094]:
new_connection(): Can't connect to local MySQL server
through socket '/var/run/mysqld/mysqld.sock' (2)
Jan 1 03:53:36 serveur2 /usr/sbin/ser[1094]:
db_init(): Could not create a connection
Jan 1 03:53:36 serveur2 /usr/sbin/ser[1094]:
register_udomain(): Can not open database connection
Jan 1 03:53:36 serveur2 /usr/sbin/ser[1094]:
domain_fixup(): Error while registering domain
////////////////////////////////////////////////
ser.cfg:
port=5060
children=4
fifo="/tmp/ser_fifo"
fifo_db_url="mysql://ser:heslo@serveur1.home.net/ser"
user=ser
group=ser
fifo_user=ser # owner of the ser fifo
fifo_group=ser
fifo_mode=0660 # fifo's permissions
#disable_core=yes #disables core dumping
#open_fd_limit=1024 # sets the open file descriptors
limit
#mhomed=yes # usefull for multihomed hosts, small
performance penalty
#disable_tcp=yes
#tcp_accept_aliases=yes # accepts the tcp alias via
option (see NEWS)
listen=192.168.0.2
**************
# -- auth params --
# Uncomment if you are using auth module
#
modparam("auth_db", "db_url",
"mysql://ser:heslo@serveur1.home.net/ser")
modparam("auth_db", "calculate_ha1", yes)
Regards
harry
___________________________________________________________________________
Appel audio GRATUIT partout dans le monde avec le
nouveau Yahoo! Messenger
Téléchargez cette version sur http://fr.messenger.yahoo.com
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers