[Serusers] sharing a db server with two SER

[Nilus]

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 at yahoo.fr>
To: <serusers at lists.iptel.org>
Cc: <sems at 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 at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>