[Serusers] 2nd try: SER does not start with MySQL

[Kofi Obiri-Yeboah]

Sebastian,

Check your mySQL permissions. You need to make sure that the permissions are
set correctly for root and user mySQL

HTH

KOFI

-----Original Message-----
From: serusers-bounces at iptel.org [mailto:serusers-bounces at lists.iptel.org]On
Behalf Of Sebastian Kigelman
Sent: Wednesday, June 29, 2005 8:34 AM
To: serusers at lists.iptel.org
Subject: [Serusers] 2nd try: SER does not start with MySQL
Importance: High


Hi there!!!... Iam newy in SER mailing list, and I have a problem with my
SER installation that I saw that other members have before, but I can't find
a solution to the issue.

I have installed the SER (v0.8.14), all works fine until I add MySQL support
to get persistent users. after that, when I run "serctl start" I get this
error:

----------------------------------------------------------------
Starting SER : cat: /var/run/ser.pid: No such file or directory
started pid()
----------------------------------------------------------------

I have made some test to troubleshot this issue, for exsaplme: remplacing
DIR=... with the full path to SER executable in "serctl"... and also I
increase the debug level in "ser.cfg" to 7, and I get this output:

----------------------------------------------------------------
MyHost:/etc/ser# ser -c
 0(2577) loading module /usr/lib/ser/modules/mysql.so
 0(2577) loading module /usr/lib/ser/modules/sl.so
 0(2577) loading module /usr/lib/ser/modules/tm.so
 0(2577) loading module /usr/lib/ser/modules/rr.so
 0(2577) loading module /usr/lib/ser/modules/maxfwd.so
 0(2577) loading module /usr/lib/ser/modules/usrloc.so
 0(2577) loading module /usr/lib/ser/modules/registrar.so
 0(2577) loading module /usr/lib/ser/modules/auth.so
 0(2577) loading module /usr/lib/ser/modules/auth_db.so
 0(2577) set_mod_param_regex: usrloc matches module usrloc
 0(2577) set_mod_param_regex: found <db_mode> in module usrloc
[/usr/lib/ser/modules/usrloc.so]
 0(2577) set_mod_param_regex: auth_db matches module auth_db
 0(2577) set_mod_param_regex: found <calculate_ha1> in module auth_db
[/usr/lib/ser/modules/auth_db.so]
 0(2577) set_mod_param_regex: auth_db matches module auth_db
 0(2577) set_mod_param_regex: found <password_column> in module auth_db
[/usr/lib/ser/modules/auth_db.so]
 0(2577) set_mod_param_regex: rr matches module rr
 0(2577) set_mod_param_regex: found <enable_full_lr> in module rr
[/usr/lib/ser/modules/rr.so]
 0(2577) find_export: found <mf_process_maxfwd_header> in module
maxfwd_module [/usr/lib/ser/modules/maxfwd.so]
 0(2577) find_export: found <sl_send_reply> in module sl_module
[/usr/lib/ser/modules/sl.so]
 0(2577) find_export: found <sl_send_reply> in module sl_module
[/usr/lib/ser/modules/sl.so]
 0(2577) find_export: found <record_route> in module rr
[/usr/lib/ser/modules/rr.so]
 0(2577) find_export: found <loose_route> in module rr
[/usr/lib/ser/modules/rr.so]
 0(2577) find_export: found <t_relay> in module tm
[/usr/lib/ser/modules/tm.so]
 0(2577) find_export: found <www_authorize> in module auth_db
[/usr/lib/ser/modules/auth_db.so]
 0(2577) find_export: found <www_challenge> in module auth
[/usr/lib/ser/modules/auth.so]
 0(2577) find_export: found <save> in module registrar
[/usr/lib/ser/modules/registrar.so]
 0(2577) find_export: found <lookup> in module registrar
[/usr/lib/ser/modules/registrar.so]
 0(2577) find_export: found <sl_send_reply> in module sl_module
[/usr/lib/ser/modules/sl.so]
 0(2577) find_export: found <t_relay> in module tm
[/usr/lib/ser/modules/tm.so]
 0(2577) find_export: found <sl_reply_error> in module sl_module
[/usr/lib/ser/modules/sl.so]
 0(2577) routing table 0:
...blah
...blah
...blah
...blah
WARNING: could not rev. resolve 192.168.0.4
Listening on
              127.0.0.1 [127.0.0.1]:5060
              192.168.0.4 [192.168.0.4]:5060
Aliases: MyHost:5060 localhost:5060 localhost.localdomain:5060
config file ok, exiting...
 0(2577) DEBUG: tm_shutdown : start
 0(2577) DEBUG: tm_shutdown : empting hash table
 0(2577) DEBUG: tm_shutdown: releasing timers
 0(2577) DEBUG: tm_shutdown : removing semaphores
 0(2577) DEBUG: tm_shutdown : done
 0(2577) shm_mem_destroy
 0(2577) destroying the shared memory lock
----------------------------------------------------------------

I couldn't find what is wrong in my configuration...

BTW, I can add, remove and edit users in MySQL Database using "serctl"
subscribers commands (that means that my SER machine is talking with MySQL
server as in expected)


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