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