Prameet,

Assuming you're using the auth_db module (which allows SER to store and read user account information from the MySQL subscriber table), the password is the column called "password" and this is set when you use "serctl add <user> <password> <email>" from a terminal window.

You can visit http://www.onsip.org/ for the "getting started" document which fully describes the auth_db module and MySQL authentication.

Regards, Paul

On Apr 1, 2005 4:20 PM, Prameet Chhabra Prameet.Chhabra@sun.com wrote:

WHen registirng a SIP cilent to SER. THe location table is updated with the regustration info (Ip address, port number, protocol etc). The question I have is what user name and password SER uuses to insert the row in the MYSQLK table. And where does it pick teh password from.

Thanks Prameet

Tina wrote:

...

Hi, please help me, I'm stuck with it!!!!! I am trying to set up several sers with a shared MySQL database for location service.

I set in each ser.cfg:

*/modparam("usrloc", "db_mode", 2) modparam("usrloc", "db_url","sql://ser:heslo@192.168.25.163/ser")/* *//* and the servers are not synchronized. The I set */modparam("usrloc", "db_mode", 2)/* *//* *//* // made UAC (Xlite) register to one of the servers. I see it via usrloc, but there is no record in "location" mySQL table....So others do not see the client and I'm unable to make calls....

Please help how to work with usrloc and mySQL...

Tina, software engineer

---

Do you Yahoo!? Better first dates. More second dates. Yahoo! Personals http://us.rd.yahoo.com/evt=27808/*http://personals.yahoo.com

---

---

Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

---

Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

Have a look at this thread: http://lists.iptel.org/pipermail/serusers/2005-January/014669.html g-)

Java Rockx wrote:

Tina,

I thought I saw you post the other day that you did not want to use t_replicate(), however, this is probably your best bet to getting this to work, IMHO.

Regards, Paul

On Apr 1, 2005 4:08 PM, Tina kramarv@yahoo.com wrote:

...

Hi, please help me, I'm stuck with it!!!!! I am trying to set up several sers with a shared MySQL database for location service.

I set in each ser.cfg:

modparam("usrloc", "db_mode", 2) modparam("usrloc", "db_url","sql://ser:heslo@192.168.25.163/ser")

and the servers are not synchronized. The I set modparam("usrloc", "db_mode", 2)

made UAC (Xlite) register to one of the servers. I see it via usrloc, but there is no record in "location" mySQL table....So others do not see the client and I'm unable to make calls....

Please help how to work with usrloc and mySQL...

Tina, software engineer

---

Do you Yahoo!? Better first dates. More second dates. Yahoo! Personals

---

Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

---

Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers