Thank you very much for the help with the debug level. Now we can finally find where the problem is. It seems that it has something to do with the MySQL database access. We changed the username and password in both ser_mysql.sh and serctl. So we got the following error message from the ser debug output:

0(29503) connect_db(): Access denied for user: 'ser@localhost' (Using password: YES) 0(29503) db_init(): Error while trying to connect database 0(29503) mod_init(): Error while connecting database 0(29503) init_mod(): Error while initializing module usrloc ERROR: error while initializing modules

We did not find any place to reset the password and username in the ser.cfg file, does that mean that those passwords and usernames are hard-coded into the C files? Which files should we change to reflect the password/username modification we made?

Thanks again.

Ziying Sherwin

On Thu, 22 Jan 2004, Bogdan-Andrei IANCU wrote:

Hi, increase the debug level in configuration file and you will see the line were the error lays in config script.

Bogdan

Ziying Sherwin wrote:

...

We are trying to compile ser 0.8.12 on Solaris 2.8 using gcc 3.3. The compilation and installation go smoothly until we tried to start the ser daemon with persistancy support.

We followed the instructions listed on the website. First, we modified the MySQL configuration file to increase the maximun connections allowed. Second we restart the MySQL daemon. Third, we modified the ser_mysql.sh file to set the username, password and path properly and used it to create the MySQL tables. Then we modifid ser.cfg file and uncommented the following lines:

loadmodule "/depot/package/ser_0.8.12/lib/ser/modules/mysql.so" loadmodule "/depot/package/ser_0.8.12/lib/ser/modules/auth.so" loadmodule "/depot/package/ser_0.8.12/lib/ser/modules/auth_db.so" modparam("usrloc", "db_mode", 2) modparam("auth", "calculate_ha1", yes) modparam("auth_db", "password_column", "password")

uncommented and modified the following lines:

if (!www_authorize("<our domain name>", "subscriber")) { www_challenge("<our domain name>", "0"); break; };

Finally, we tried to start the ser daemon by directly calling the binary "ser", and the got the following error message:

...

ser

ERROR: bad config file (1 errors)

How can we find where the error is? All the modules listed in the configuration file are present in the directory. What else could go wrong?

Thank you very much in advance.

Ziying Sherwin

---

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

Thank you again for the help. We modified the ser.cfg file and made some progress. The ser server finally started, but when we monitor it using "serctl moni" we noticed the following messages:

... UsrLoc Stats Domain Registered Expired 'location' 0 0 ^V[cycle #: 15; if constant make sure server lives and fifo is on] Server: Sip EXpress router (0.8.12 (sparc64/solaris)) Now: Thu Jan 22 13:52:41 2004 Up Since: Thu Jan 22 13:41:38 2004 Up time: 663 [sec]

Transaction Statistics Current: 70 (71 waiting) Total: 283 (0 local) Replied localy: 364 Completion status 6xx: 0, 5xx: 0, 4xx: 283, 3xx: 0,2xx: 0

Stateless Server Statistics 200: 0 202: 0 2xx: 0 300: 0 301: 0 302: 0 3xx: 0 400: 0 401: 0 403: 0 404: 0 407: 0 408: 0 483: 12 4xx: 0 500: 0 5xx: 0 6xx: 0 xxx: 0 failures: 7 ...

Does that have anything to do with the message from the ser debug output:

0(0) DEBUG: setting SO_RCVBUF; set=65536,verify=65536 0(0) DEBUG: udp_init: trying SO_RCVBUF: 131072 0(0) DEBUG: setting SO_RCVBUF; set=131072,verify=131072 0(0) DEBUG: udp_init: trying SO_RCVBUF: 262144 0(0) DEBUG: setting SO_RCVBUF; set=262144,verify=262144 0(0) INFO: udp_init: SO_RCVBUF is finally 262144 0(0) WARNING: using only the first listen address (no fork) 1(686) DBG: open_uac_fifo: opening fifo... 1( 1(686) DEBUG: open_fifo_server: FIFO stat failed: Error 0 1(686) DEBUG: FIFO created @ /tmp/ser_fifo 1(686) DEBUG: fifo /tmp/ser_fifo opened, mode=432 686) DEBUG: init_mod_child (-1): tm

Why does it fail to open the fifo?

We also tried to test the ser by using a SIP user agent called "sip-communicator" (https://sip-communicator.dev.java.net/) which is a Java-base sip client. It does not contain a field in the configuration file to set the password. When we start the sip-communicator, it tried to register with our sip server, but failed to create a register transaction because our sip server is not responding. What happened to our sip server?

Thanks again.

Ziying Sherwin

On Thu, 22 Jan 2004, Vitali Nikolaev wrote:

Hello Ziying,

modparam("auth_db", "db_url","sql://ser:passwd@localhost/ser") modparam("usrloc", "db_url", "sql://ser:passwd@localhost/ser")

Thursday, January 22, 2004, 11:17:20 AM, you wrote:

ZS> Thank you very much for the help with the debug level. Now we can finally find ZS> where the problem is. It seems that it has something to do with the MySQL ZS> database access. We changed the username and password in both ser_mysql.sh ZS> and serctl. So we got the following error message from the ser debug output:

ZS> 0(29503) connect_db(): Access denied for user: ZS> 'ser@localhost' (Using password: YES) ZS> 0(29503) db_init(): Error while trying to connect database ZS> 0(29503) mod_init(): Error while connecting database ZS> 0(29503) init_mod(): Error while initializing module usrloc ZS> ERROR: error while initializing modules

ZS> We did not find any place to reset the password and username in the ser.cfg ZS> file, does that mean that those passwords and usernames are hard-coded into ZS> the C files? Which files should we change to reflect the password/username ZS> modification we made?

ZS> Thanks again.

ZS> Ziying Sherwin

ZS> On Thu, 22 Jan 2004, Bogdan-Andrei IANCU wrote:

...

...

Hi, increase the debug level in configuration file and you will see the line were the error lays in config script.

Bogdan

Ziying Sherwin wrote:

...

We are trying to compile ser 0.8.12 on Solaris 2.8 using gcc 3.3. The compilation and installation go smoothly until we tried to start the ser daemon with persistancy support.

We followed the instructions listed on the website. First, we modified the MySQL configuration file to increase the maximun connections allowed. Second we restart the MySQL daemon. Third, we modified the ser_mysql.sh file to set the username, password and path properly and used it to create the MySQL tables. Then we modifid ser.cfg file and uncommented the following lines:

loadmodule "/depot/package/ser_0.8.12/lib/ser/modules/mysql.so" loadmodule "/depot/package/ser_0.8.12/lib/ser/modules/auth.so" loadmodule

"/depot/package/ser_0.8.12/lib/ser/modules/auth_db.so"

...

modparam("usrloc", "db_mode", 2) modparam("auth", "calculate_ha1", yes) modparam("auth_db", "password_column", "password")

uncommented and modified the following lines:

if (!www_authorize("<our domain name>", "subscriber")) { www_challenge("<our domain name>", "0"); break; };

Finally, we tried to start the ser daemon by directly calling the binary "ser", and the got the following error message:

...

ser

ERROR: bad config file (1 errors)

How can we find where the error is? All the modules listed in the configuration file are present in the directory. What else could go wrong?

Thank you very much in advance.

Ziying Sherwin

---

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

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

-- Best regards, Vitali

Hi,

in config script, when setting the parameters for the usrloc module, you have something like: modparam("usrloc", "db_url", "sql://ser:xxxxx@localhost/ser") the sql url has this format: sql://user:password@host/database so, please update this URL conforming to your configuration.

Bogdan

Ziying Sherwin wrote:

Thank you very much for the help with the debug level. Now we can finally find where the problem is. It seems that it has something to do with the MySQL database access. We changed the username and password in both ser_mysql.sh and serctl. So we got the following error message from the ser debug output:

0(29503) connect_db(): Access denied for user: 'ser@localhost' (Using password: YES) 0(29503) db_init(): Error while trying to connect database 0(29503) mod_init(): Error while connecting database 0(29503) init_mod(): Error while initializing module usrloc ERROR: error while initializing modules

We did not find any place to reset the password and username in the ser.cfg file, does that mean that those passwords and usernames are hard-coded into the C files? Which files should we change to reflect the password/username modification we made?

Thanks again.

Ziying Sherwin

On Thu, 22 Jan 2004, Bogdan-Andrei IANCU wrote:

...

Hi, increase the debug level in configuration file and you will see the line were the error lays in config script.

Bogdan

Ziying Sherwin wrote:

...

We are trying to compile ser 0.8.12 on Solaris 2.8 using gcc 3.3. The compilation and installation go smoothly until we tried to start the ser daemon with persistancy support.

We followed the instructions listed on the website. First, we modified the MySQL configuration file to increase the maximun connections allowed. Second we restart the MySQL daemon. Third, we modified the ser_mysql.sh file to set the username, password and path properly and used it to create the MySQL tables. Then we modifid ser.cfg file and uncommented the following lines:

loadmodule "/depot/package/ser_0.8.12/lib/ser/modules/mysql.so" loadmodule "/depot/package/ser_0.8.12/lib/ser/modules/auth.so" loadmodule "/depot/package/ser_0.8.12/lib/ser/modules/auth_db.so" modparam("usrloc", "db_mode", 2) modparam("auth", "calculate_ha1", yes) modparam("auth_db", "password_column", "password")

uncommented and modified the following lines:

if (!www_authorize("<our domain name>", "subscriber")) { www_challenge("<our domain name>", "0"); break; };

Finally, we tried to start the ser daemon by directly calling the binary "ser", and the got the following error message:

...

ser

ERROR: bad config file (1 errors)

How can we find where the error is? All the modules listed in the configuration file are present in the directory. What else could go wrong?

Thank you very much in advance.

Ziying Sherwin

---

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

At 05:17 PM 1/22/2004, Ziying Sherwin wrote:

Thank you very much for the help with the debug level. Now we can finally find where the problem is. It seems that it has something to do with the MySQL database access. We changed the username and password in both ser_mysql.sh and serctl. So we got the following error message from the ser debug output:

0(29503) connect_db(): Access denied for user: 'ser@localhost' (Using password: YES) 0(29503) db_init(): Error while trying to connect database 0(29503) mod_init(): Error while connecting database 0(29503) init_mod(): Error while initializing module usrloc ERROR: error while initializing modules

We did not find any place to reset the password and username in the ser.cfg file

It occurs to me you just haven't looked and didn't try to use READMEs.

example:

modparam("usrloc|acc|auth_db|group|msilo", "db_url", "mysql://seruser:serpassword@dbhost/sertable")

, does that mean that those passwords and usernames are hard-coded into the C files?

no

-jiri